View In:
ArcGIS Online Map Viewer
Name: Address Points Retired
Display Field: STREET_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The dataset contains locations and attributes of retired address points, created as part of the Master Address Repository (MAR) for the Office of the Chief Technology Officer (OCTO) and Department of Buildings (DOB). There are over 40,000 retired addresses. These once existed, but no longer do. More information on the MAR can be found at </SPAN><A href="https://opendata.dc.gov:443/pages/addressing-in-dc" STYLE="text-decoration:underline;"><SPAN>https://opendata.dc.gov/pages/addressing-in-dc</SPAN></A><SPAN>. The data dictionary is available: </SPAN><A href="https://opendata.dc.gov:443/documents/2a4b3d59aade43188b6d18e3811f4fd3/explore" STYLE="text-decoration:underline;"><SPAN>https://opendata.dc.gov/documents/2a4b3d59aade43188b6d18e3811f4fd3/explore</SPAN></A><SPAN>. In the MAR 2, the AddressPt is called ADDRESSES_PT and its features additional useful information such as placement location, created date, last edited date, begin date and more.</SPAN></P></DIV></DIV></DIV>
Copyright Text: Office of the Chief Technology Officer
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 50000
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Supports Datum Transformation: true
Extent:
XMin: -8584947.85844689
YMin: 4691862.387048862
XMax: -8561472.787091771
YMax: 4721095.072076196
Spatial Reference: 102100
(3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [64, 121, 150, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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: true
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: false
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:
Fields:
-
ADDRESS
(
type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS
)
-
ADDRESS_NUMBER
(
type: esriFieldTypeInteger, alias: Address Number, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_NUMBER
)
-
ADDRESS_NUMBER_SUFFIX
(
type: esriFieldTypeString, alias: Address Number Suffix, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ADDRESS_NUMBER_SUFFIX
)
-
STREET_NAME
(
type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STREET_NAME
)
-
QUADRANT
(
type: esriFieldTypeString, alias: Quadrant, editable: true, nullable: true, length: 2, defaultValue: null, modelName: QUADRANT
)
-
ZIPCODE
(
type: esriFieldTypeDouble, alias: Zipcode, editable: true, nullable: true, defaultValue: null, modelName: ZIPCODE
)
-
CITY
(
type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CITY
)
-
STATE
(
type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STATE
)
-
COUNTRY
(
type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COUNTRY
)
-
STREET_TYPE
(
type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_TYPE
)
-
ADDRESS_TYPE
(
type: esriFieldTypeString, alias: Address Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS_TYPE
)
-
STATUS
(
type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STATUS
)
-
WARD
(
type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WARD
)
-
NATIONAL_GRID
(
type: esriFieldTypeString, alias: National Grid, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NATIONAL_GRID
)
-
HAS_SSL
(
type: esriFieldTypeString, alias: Has Square, Suffix, Lot, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HAS_SSL
)
-
HAS_PLACE_NAME
(
type: esriFieldTypeString, alias: Has Place Name, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HAS_PLACE_NAME
)
-
HAS_CONDO
(
type: esriFieldTypeString, alias: Has Condo, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HAS_CONDO
)
-
HAS_RESIDENTIAL_UNIT
(
type: esriFieldTypeString, alias: Has Residential Unit, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HAS_RESIDENTIAL_UNIT
)
-
STREET_VIEW_URL
(
type: esriFieldTypeString, alias: Street View URL, editable: true, nullable: true, length: 200, defaultValue: null, modelName: STREET_VIEW_URL
)
-
RESIDENTIAL_TYPE
(
type: esriFieldTypeString, alias: Residential Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RESIDENTIAL_TYPE
)
-
HOUSING_UNIT_COUNT
(
type: esriFieldTypeDouble, alias: Housing Unit Count, editable: true, nullable: true, defaultValue: null, modelName: HOUSING_UNIT_COUNT
)
-
RESIDENTIAL_UNIT_COUNT
(
type: esriFieldTypeDouble, alias: Residential Unit Count, editable: true, nullable: true, defaultValue: null, modelName: RESIDENTIAL_UNIT_COUNT
)
-
PLACEMENT
(
type: esriFieldTypeString, alias: Placement, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PLACEMENT
)
-
BUILDING
(
type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BUILDING
)
-
SSL
(
type: esriFieldTypeString, alias: Square, Suffix, Lot, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SSL
)
-
SQUARE
(
type: esriFieldTypeString, alias: Square, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SQUARE
)
-
SUFFIX
(
type: esriFieldTypeString, alias: Suffix, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SUFFIX
)
-
LOT
(
type: esriFieldTypeString, alias: Lot, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LOT
)
-
SSL_ALIGNMENT
(
type: esriFieldTypeString, alias: Square, Suffix, Lot Alignment, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SSL_ALIGNMENT
)
-
MULTIPLE_LAND_SSL
(
type: esriFieldTypeString, alias: Multiple Land Square, Suffix, Lot, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MULTIPLE_LAND_SSL
)
-
GRID_DIRECTION
(
type: esriFieldTypeString, alias: Grid Direction, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GRID_DIRECTION
)
-
ROUTEID
(
type: esriFieldTypeString, alias: Route Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROUTEID
)
-
BLOCKKEY
(
type: esriFieldTypeString, alias: Block Key, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BLOCKKEY
)
-
SUBBLOCKKEY
(
type: esriFieldTypeString, alias: SubBlock Key, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SUBBLOCKKEY
)
-
MAR_ID
(
type: esriFieldTypeDouble, alias: Master Address Repository Identifier, editable: true, nullable: true, defaultValue: null, modelName: MAR_ID
)
-
METADATA_ID
(
type: esriFieldTypeDouble, alias: Metadata Identifier, editable: true, nullable: true, defaultValue: null, modelName: METADATA_ID
)
-
X_COORDINATE
(
type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: X_COORDINATE
)
-
Y_COORDINATE
(
type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: Y_COORDINATE
)
-
LATITUDE
(
type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE
)
-
LONGITUDE
(
type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE
)
-
BEFORE_DATE
(
type: esriFieldTypeDate, alias: Before Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BEFORE_DATE
)
-
BEFORE_DATE_SOURCE
(
type: esriFieldTypeString, alias: Before Date Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BEFORE_DATE_SOURCE
)
-
BEGIN_DATE
(
type: esriFieldTypeDate, alias: Begin Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BEGIN_DATE
)
-
BEGIN_DATE_SOURCE
(
type: esriFieldTypeString, alias: Begin Date Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BEGIN_DATE_SOURCE
)
-
FIRST_KNOWN_DATE
(
type: esriFieldTypeDate, alias: First Known Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIRST_KNOWN_DATE
)
-
FIRST_KNOWN_DATE_SOURCE
(
type: esriFieldTypeString, alias: First Known Date, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FIRST_KNOWN_DATE_SOURCE
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: Created DAte, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE
)
-
CREATED_USER
(
type: esriFieldTypeString, alias: Created User, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREATED_USER
)
-
LAST_EDITED_DATE
(
type: esriFieldTypeDate, alias: Last Edited Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE
)
-
LAST_EDITED_USER
(
type: esriFieldTypeString, alias: Last Edited User, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LAST_EDITED_USER
)
-
SE_ANNO_CAD_DATA
(
type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA, editable: true, nullable: true, defaultValue: null, modelName: SE_ANNO_CAD_DATA
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
Templates:
-
Name: Address Points Retired
Description:
Prototype:
LAST_EDITED_USER: null
ADDRESS: null
ADDRESS_NUMBER: null
ADDRESS_NUMBER_SUFFIX: null
STREET_NAME: null
QUADRANT: null
ZIPCODE: null
CITY: null
STATE: null
COUNTRY: null
STREET_TYPE: null
ADDRESS_TYPE: null
STATUS: null
WARD: null
NATIONAL_GRID: null
HAS_SSL: null
HAS_PLACE_NAME: null
HAS_CONDO: null
HAS_RESIDENTIAL_UNIT: null
STREET_VIEW_URL: null
RESIDENTIAL_TYPE: null
HOUSING_UNIT_COUNT: null
RESIDENTIAL_UNIT_COUNT: null
PLACEMENT: null
BUILDING: null
SSL: null
SQUARE: null
SUFFIX: null
LOT: null
SSL_ALIGNMENT: null
MULTIPLE_LAND_SSL: null
GRID_DIRECTION: null
ROUTEID: null
BLOCKKEY: null
SUBBLOCKKEY: null
MAR_ID: null
METADATA_ID: null
X_COORDINATE: null
Y_COORDINATE: null
LATITUDE: null
LONGITUDE: null
BEFORE_DATE: null
BEFORE_DATE_SOURCE: null
BEGIN_DATE: null
BEGIN_DATE_SOURCE: null
FIRST_KNOWN_DATE: null
FIRST_KNOWN_DATE_SOURCE: null
CREATED_DATE: null
CREATED_USER: null
LAST_EDITED_DATE: null
SE_ANNO_CAD_DATA: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Extract
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Analytic
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata