Name: Vacant and Blighted Building Addresses

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer is a subset of ITSPE and and UBIDs representing vacant and blighted property building addresses which are directly correlated with Vacant and Blighted Property Building Footprints. The tax assessment roll public extract (ITSPE) is used for assessment and property analysis, to send property tax bills and notices, and stores comprehensive tax information such as ownership, mailing addresses, non-contiguous Air Rights lots (Multifamily or Development), Air Rights lots, possessory interest lots, record lots, tax lots, parcels, condominiums, and federally owned lands such as reservations and appropriations. The linkage from the Vector Property layers to this database is SSL (Square, Suffix, and Lot). The UBID data was originally created by spatially joining the 2019 building footprints published in DC Open Data with the Common Ownership Lots. The UBIDs were coded using US DOE’s Implementation code. Search for UBID and ITSPE in Open Data DC for individual documentation.

Copyright Text: Office of the Chief Financial Officer

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -8583761.984396003
YMin: 4695931.206626912
XMax: -8561695.126579044
YMax: 4721000.574515175
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [63, 138, 140, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 255 )
• ADDRESS_NUMBER ( type: esriFieldTypeInteger, alias: Address Number )
• ADDRESS_NUMBER_SUFFIX ( type: esriFieldTypeString, alias: Address Number Suffix, length: 6 )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Name, length: 30 )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Type, length: 50 )
• QUADRANT ( type: esriFieldTypeString, alias: Quadrant, length: 2 )
• ZIPCODE ( type: esriFieldTypeDouble, alias: Zip Code )
• CITY ( type: esriFieldTypeString, alias: City, length: 25 )
• STATE ( type: esriFieldTypeString, alias: State, length: 25 )
• COUNTRY ( type: esriFieldTypeString, alias: Country, length: 50 )
• ADDRESS_TYPE ( type: esriFieldTypeString, alias: Address Type, length: 30 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 15 )
• ANC ( type: esriFieldTypeString, alias: Advisory Neighborhood Commission, length: 12 )
• SMD ( type: esriFieldTypeString, alias: Single Member District, length: 12 )
• WARD ( type: esriFieldTypeString, alias: Ward, length: 25 )
• BLOCKKEY ( type: esriFieldTypeString, alias: Block Key, length: 100 )
• ROUTEID ( type: esriFieldTypeString, alias: Route Identifier, length: 50 )
• SUBBLOCKKEY ( type: esriFieldTypeString, alias: SubBlock Key, length: 100 )
• METADATA_ID ( type: esriFieldTypeDouble, alias: Metadata Identifier )
• NATIONAL_GRID ( type: esriFieldTypeString, alias: National Grid, length: 20 )
• HAS_SSL ( type: esriFieldTypeString, alias: Has Square, Suffix, Lot, length: 1 )
• HAS_PLACE_NAME ( type: esriFieldTypeString, alias: Has Place Name, length: 1 )
• HAS_CONDO ( type: esriFieldTypeString, alias: Has Condo, length: 1 )
• HAS_RESIDENTIAL_UNIT ( type: esriFieldTypeString, alias: Has Residential Unit, length: 1 )
• STREET_VIEW_URL ( type: esriFieldTypeString, alias: Street View URL, length: 200 )
• RESIDENTIAL_TYPE ( type: esriFieldTypeString, alias: Residential Type, length: 20 )
• PLACEMENT ( type: esriFieldTypeString, alias: Placement, length: 25 )
• BUILDING ( type: esriFieldTypeString, alias: Building, length: 20 )
• SSL_ALIGNMENT ( type: esriFieldTypeString, alias: Square, Suffix, Lot Alignment, length: 20 )
• SSL ( type: esriFieldTypeString, alias: Square, Suffix, Lot, length: 12 )
• MULTIPLE_LAND_SSL ( type: esriFieldTypeString, alias: Multiple Land Square, Suffix, Lot, length: 20 )
• SQUARE ( type: esriFieldTypeString, alias: Square, length: 4 )
• SUFFIX ( type: esriFieldTypeString, alias: Suffix, length: 4 )
• LOT ( type: esriFieldTypeString, alias: Lot, length: 4 )
• GRID_DIRECTION ( type: esriFieldTypeString, alias: Grid Direction, length: 20 )
• HOUSING_UNIT_COUNT ( type: esriFieldTypeDouble, alias: Housing Unit Count )
• RESIDENTIAL_UNIT_COUNT ( type: esriFieldTypeDouble, alias: Residential Unit Count )
• BEFORE_DATE ( type: esriFieldTypeDate, alias: Before Date, length: 8 )
• BEFORE_DATE_SOURCE ( type: esriFieldTypeString, alias: Before Date Source, length: 25 )
• BEGIN_DATE ( type: esriFieldTypeDate, alias: Begin Date, length: 8 )
• BEGIN_DATE_SOURCE ( type: esriFieldTypeString, alias: Begin Date Source, length: 25 )
• FIRST_KNOWN_DATE ( type: esriFieldTypeDate, alias: First Known Date, length: 8 )
• FIRST_KNOWN_DATE_SOURCE ( type: esriFieldTypeString, alias: First Known Date Source, length: 25 )
• MAR_ID ( type: esriFieldTypeDouble, alias: Master Address Repository Identifier )
• X_COORDINATE ( type: esriFieldTypeDouble, alias: X Coordinate )
• Y_COORDINATE ( type: esriFieldTypeDouble, alias: Y Coordinate )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 25 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 25 )
• SE_ANNO_CAD_DATA ( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata