Name: PIKEMAPDATA.DBO.Addresses

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: 544686.800122079
YMin: 400141.626623571
XMax: 707126.554638244
YMax: 563936.989977069
Spatial Reference: 102629 (102629)
Vertical Spatial Reference: 115702 (115702)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[142,58,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"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:

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)
• ADDR_KEY (type: esriFieldTypeDouble, alias: ADDR_KEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ROADNAME (type: esriFieldTypeString, alias: ROADNAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FULLADDR (type: esriFieldTypeString, alias: FULLADDR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MSAG_Community (type: esriFieldTypeString, alias: MSAG_Community, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATION_DATE (type: esriFieldTypeString, alias: CREATION_DATE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CREATION_USER (type: esriFieldTypeString, alias: CREATION_USER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODIFY_DATE (type: esriFieldTypeString, alias: MODIFY_DATE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• MODIFY_USER (type: esriFieldTypeString, alias: MODIFY_USER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• C1_EXCEPTION (type: esriFieldTypeInteger, alias: C1_EXCEPTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pre_Dir (type: esriFieldTypeString, alias: Pre_Dir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ST_Name (type: esriFieldTypeString, alias: ST_Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Suf_Type (type: esriFieldTypeString, alias: Suf_Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Suf_Dir (type: esriFieldTypeString, alias: Suf_Dir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LAW_SECTOR (type: esriFieldTypeString, alias: LAW_SECTOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VERIFIED_ADDRESS (type: esriFieldTypeString, alias: VERIFIED_ADDRESS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CITY_LIMITS (type: esriFieldTypeString, alias: CITY_LIMITS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ADDR_SUF (type: esriFieldTypeString, alias: ADDR_SUF, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ZIP_CODE (type: esriFieldTypeInteger, alias: ZIP_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXCHANGE (type: esriFieldTypeString, alias: EXCHANGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MATCH_UP_ID (type: esriFieldTypeString, alias: MATCH_UP_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BRUNDIDGE_VOTING_DISTRICT (type: esriFieldTypeString, alias: BRUNDIDGE_VOTING_DISTRICT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TROY_VOTING_DISTRICT (type: esriFieldTypeString, alias: TROY_VOTING_DISTRICT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIRE_JURISDICTION (type: esriFieldTypeString, alias: FIRE_JURISDICTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDRESS_CLASS (type: esriFieldTypeString, alias: ADDRESS_CLASS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UID (type: esriFieldTypeString, alias: UID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LABEL (type: esriFieldTypeString, alias: LABEL, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Google_Street_View (type: esriFieldTypeString, alias: Google_Street_View, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ESN (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• CREATE_NAME (type: esriFieldTypeString, alias: CREATE_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATE_DATE (type: esriFieldTypeDate, alias: CREATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SPATIAL_NAME (type: esriFieldTypeString, alias: SPATIAL_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPATIAL_DATE (type: esriFieldTypeDate, alias: SPATIAL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AT_NAME (type: esriFieldTypeString, alias: AT_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AT_DATE (type: esriFieldTypeDate, alias: AT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COUNTY_VOTING_DISTRICT (type: esriFieldTypeString, alias: COUNTY_VOTING_DISTRICT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VOTING_PRECINCT (type: esriFieldTypeString, alias: VOTING_PRECINCT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ALT_FULL_ADDRESS_SEARCH_1 (type: esriFieldTypeString, alias: ALT_FULL_ADDRESS_SEARCH_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ALT_FULL_ADDRESS_SEARCH_2 (type: esriFieldTypeString, alias: ALT_FULL_ADDRESS_SEARCH_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SOUTHERN_SOFTWARE_ID_ADDRESS (type: esriFieldTypeString, alias: SOUTHERN_SOFTWARE_ID_ADDRESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• external_nguid (type: esriFieldTypeInteger, alias: external_nguid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• add_number_DM (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• st_premod_DM (type: esriFieldTypeString, alias: Street Name Pre Modifier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• st_predir_DM (type: esriFieldTypeString, alias: Street Name Pre Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• st_pretyp_DM (type: esriFieldTypeString, alias: Street Name Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• st_presep_DM (type: esriFieldTypeString, alias: Street Name Pre Separator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• st_name_DM (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• st_postyp_DM (type: esriFieldTypeString, alias: Street Name Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• st_posdir_DM (type: esriFieldTypeString, alias: Street Name Post Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• st_posmod_DM (type: esriFieldTypeString, alias: Street Name Post Modifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LSt_PreDir_DM (type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• LSt_Name_DM (type: esriFieldTypeString, alias: Legacy Street Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LSt_Type_DM (type: esriFieldTypeString, alias: Legacy Street Name Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LSt_PosDir_DM (type: esriFieldTypeString, alias: Legacy Street Name Post Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• County_DM (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• State_DM (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Floor (type: esriFieldTypeString, alias: Floor, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Room (type: esriFieldTypeString, alias: Room, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)

Templates:

Name: PIKEMAPDATA.DBO.Addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/17/2026 2:52:23 PM

Schema Last Edit Date: 8/17/2026 2:52:23 PM

Data Last Edit Date: 8/17/2026 2:52:23 PM

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