Name: AddressPT

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: The NAD is a spatial database containing address data, point location coordinates, jurisdictions, record level metadata and other supporting data for addressable locations including structures, some sub-units within those structures and landmarks as included in the aggregated datasets from providers included therein. Its coverage includes twenty-six whole and partial coverage states, including Arizona, Arkansas, Colorado, Connecticut, Delaware, Indiana, Iowa, Kansas, Maine, Maryland, Massachusetts, Montana, New Jersey, New Mexico, New York, North Carolina, Ohio, Rhode Island, Tennessee, Texas, Utah, Vermont, Virginia and Wisconsin, and the District of Columbia, as well as variable numbers of counties and cities in several states, and one American Indian Reservation: Anchorage Municipality, Haines and Matanuska-Susitna Boroughs, Yakutat City and Borough, and Dillingham City, Alaska; Merced County, California; East Baton Rouge and Terrebonne Parishes, Louisiana; Anoka, Carver, Chisago, Dakota, Hennepin, Isanti, Le Sueur, Ramsey, Scott, Sherburne and Washington Counties, Minnesota; Boone, Christian, Cole, Greene, Jasper, St. Charles, St. Louis, Stone and Taney Counties, and Independence City, Missouri; Blair County, Pennsylvania; York County, South Carolina; Sioux Falls City and Rosebud Sioux Reservation, South Dakota; Big Horn, Campbell, Crook, Fremont, Laramie, Sublette and Teton Counties, Wyoming.

Copyright Text: US Department of Transportation 855-368-4200 1200 New Jersey Avenue, SE Washington, DC 20590 nad@dot.gov US Census Bureau 301-763-1128 4600 Silver Hill Road Washington, DC 20233 geo.geography@census.gov

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2133544.24565032
YMin: 145311.171674027
XMax: 2296794.30423341
YMax: 305223.787964373
Spatial Reference: 3426 (3426)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,44,138,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AS: American Samoa], ... 56 more ...)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Abbeville: Abbeville], [Acadia Parish: Acadia Parish], [Accomack: Accomack], ... 1966 more ...)
• Inc_Muni (type: esriFieldTypeString, alias: Incorporated Municipality, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Uninc_Comm (type: esriFieldTypeString, alias: Unincorporated Community, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Nbrhd_Comm (type: esriFieldTypeString, alias: Neighborhood Community, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Post_Comm (type: esriFieldTypeString, alias: Postal Community Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Zip_Code (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Plus_4 (type: esriFieldTypeString, alias: Zip Plus 4 Addition, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Bulk_Zip (type: esriFieldTypeString, alias: Bulk Delivery ZIP Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Bulk_Plus4 (type: esriFieldTypeString, alias: Bulk Delivery ZIP Plus 4 Addition, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• StN_PreMod (type: esriFieldTypeString, alias: Street Name Pre Modifier ( PRM ), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• StN_PreDir (type: esriFieldTypeString, alias: Street Name Pre Directional ( PRD ), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [North: North], [Northeast: Northeast], [East: East], ... 13 more ...)
• StN_PreTyp (type: esriFieldTypeString, alias: Street Name Pre Type ( STP ), SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Access: Access], [Access Road: Access Road], ... 434 more ...)
• StN_PreSep (type: esriFieldTypeString, alias: Street Name Pre Type Separator ( STPS ), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [at: at], [de: de], [de la: de la], ... 9 more ...)
• StreetName (type: esriFieldTypeString, alias: Street Name ( RD ), SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• StN_PosTyp (type: esriFieldTypeString, alias: Street Name Post Type ( STS ), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Access: Access], [Access Road: Access Road], ... 434 more ...)
• StN_PosDir (type: esriFieldTypeString, alias: Street Name Post Directional ( POD ), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [North: North], [Northeast: Northeast], [East: East], ... 13 more ...)
• StN_PosMod (type: esriFieldTypeString, alias: Street Name Post Modifier ( POM ), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• AddNum_Pre (type: esriFieldTypeString, alias: Address number prefix (HNP), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Add_Number (type: esriFieldTypeInteger, alias: Address number (HNO), SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddNum_Suf (type: esriFieldTypeString, alias: Address number suffix (HNS), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LandmkPart (type: esriFieldTypeString, alias: Landmark Name Part (LMKP), SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LandmkName (type: esriFieldTypeString, alias: Landmark (LMK), SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building (BLD), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Floor (type: esriFieldTypeString, alias: Floor (FLR), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit (UNIT), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Room (type: esriFieldTypeString, alias: Room (ROOM), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Addtl_Loc (type: esriFieldTypeString, alias: Additional Location Information (LOC), SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Milepost (type: esriFieldTypeString, alias: Milepost, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Address Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Address Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NatGrid_Coord (type: esriFieldTypeString, alias: National Grid Coordinates, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Addr_Type (type: esriFieldTypeString, alias: Address Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Agricultural: Agricultural], [Residential: Residential (Housing)], [Commercial: Commercial (Office, Retail, Restaurant, Banking)], ... 10 more ...)
• Placement (type: esriFieldTypeString, alias: Address Placement, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Structure - Rooftop: Structure - Rooftop], [Structure - Entrance: Structure - Entrance], [Structure - Interior: Structure - Interior Unit Location], ... 17 more ...)
• Source (type: esriFieldTypeString, alias: Address Source, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• AddAuth (type: esriFieldTypeString, alias: Address Authority, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• UniqWithin (type: esriFieldTypeString, alias: Unique Within, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LastUpdate (type: esriFieldTypeDate, alias: Date Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Effective (type: esriFieldTypeDate, alias: Effective Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Expired (type: esriFieldTypeDate, alias: Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SEARCH (type: esriFieldTypeString, alias: SEARCH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADD_ID (type: esriFieldTypeSmallInteger, alias: ADD_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PZ (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CityWard (type: esriFieldTypeString, alias: City Ward, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: AddressPT
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/20/2022 10:40:14 PM

Schema Last Edit Date: 12/20/2022 10:40:14 PM

Data Last Edit Date: 12/20/2022 10:40:14 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat