Name: Address
Display Field: FULLNAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Site address points represent the location of site or service delivery addresses assigned by local governments.
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13531834.5249015
YMin: 4526963.49508531
XMax: -13511337.8129548
YMax: 4558390.21816954
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,0],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}}},"scaleSymbols":true,"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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- SITEADDID (type: esriFieldTypeString, alias: Site Address ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ADDPTKEY (type: esriFieldTypeString, alias: Address Point ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ADDRNUM (type: esriFieldTypeInteger, alias: Full Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNITTYPE (type: esriFieldTypeString, alias: Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 22 more ...)
- UNITID (type: esriFieldTypeString, alias: Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ALTUNITTYPE (type: esriFieldTypeString, alias: Alternate Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 22 more ...)
- ALTUNITID (type: esriFieldTypeString, alias: Alternate Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- SUFFIX (type: esriFieldTypeString, alias: SUFFIX, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- STR_DIR (type: esriFieldTypeString, alias: Street Direction, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- FULLNAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- ST_TYPE (type: esriFieldTypeString, alias: ST_TYPE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [CT: CT], [DR: DR], [LN: LN], ... 10 more ...)
- FULLADDR (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- PLACENAME (type: esriFieldTypeString, alias: Place Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- MUNICIPALITY (type: esriFieldTypeString, alias: Municipality Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ZIP (type: esriFieldTypeInteger, alias: ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- APN (type: esriFieldTypeInteger, alias: APN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Current: Current], [Pending: Pending], [Retired: Retired], ... 2 more ...)
- ADDRESS_TYPE (type: esriFieldTypeString, alias: ADDRESS_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Situs: Situs Address], [Secondary: Secondary Address], [Irrigation Controller: Irrigation Controller], ... 9 more ...)
- FLOOR_NUM (type: esriFieldTypeSmallInteger, alias: FLOOR_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESN (type: esriFieldTypeInteger, alias: Emergency Service Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PSAP (type: esriFieldTypeString, alias: Public Safety Answering Point, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- MSAG (type: esriFieldTypeString, alias: MSAG Community, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- USNGCOORD (type: esriFieldTypeString, alias: USNG Coordinate, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ADDRCLASS (type: esriFieldTypeInteger, alias: Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [701: Agriculture, Food, and Livestock], [710: Industry], [720: Commercial and Retail], ... 13 more ...)
- POINTTYPE (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Building: Building], [Parcel: Parcel], [Unit, Condo, Office or Suite: Unit, Condo, Office or Suite], ... 3 more ...)
- ALIAS1 (type: esriFieldTypeString, alias: ALIAS1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ALIAS2 (type: esriFieldTypeString, alias: ALIAS2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- EMS (type: esriFieldTypeString, alias: EMS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STREETID (type: esriFieldTypeInteger, alias: STREETID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- ProjectID (type: esriFieldTypeInteger, alias: ProjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Address
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/8/2023 10:07:26 PM
Schema Last Edit Date: 2/8/2023 10:07:26 PM
Data Last Edit Date: 2/8/2023 10:07:26 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat