Name: Address_Points
Display Field: ST_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text: Systems Mamagement Specialist
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON
Use Standardized Queries: True
Extent:
XMin: 350125.612782003
YMin: 120960.616422835
XMax: 510052.503664831
YMax: 221311.52617885
Spatial Reference: 103778 (103778)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,36,98,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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ADD_ID (type: esriFieldTypeString, alias: Address Unique Identifier, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
- ADD_ID_LOC (type: esriFieldTypeString, alias: Local Address Unique Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ANUMBERPRE (type: esriFieldTypeString, alias: Address Number Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- ANUMBER (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: false, editable: true)
- ANUMBERSUF (type: esriFieldTypeString, alias: Address Number Suffix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- ST_PRE_MOD (type: esriFieldTypeString, alias: Street Name Pre Modifier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- ST_PRE_DIR (type: esriFieldTypeString, alias: Street Name Pre Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [North: North], [South: South], [East: East], ... 5 more ...)
- ST_PRE_TYP (type: esriFieldTypeString, alias: Street Name Pre Type, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Avenue: Avenue], [County Highway: County Highway], [County Road: County Road], ... 6 more ...)
- ST_PRE_SEP (type: esriFieldTypeString, alias: Street Name Pre Separator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ST_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 60, nullable: false, editable: true)
- ST_POS_TYP (type: esriFieldTypeString, alias: Street Name Post Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Alcove: Alcove], [Alley: Alley], ... 224 more ...)
- ST_POS_DIR (type: esriFieldTypeString, alias: StreetName Post Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [North: North], [South: South], [East: East], ... 5 more ...)
- ST_POS_MOD (type: esriFieldTypeString, alias: Street Name Post Modifier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- SUB_TYPE1 (type: esriFieldTypeString, alias: Subaddress Type 1, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Apartment: Apartment], [Building: Building], [Center: Center], ... 19 more ...)
- SUB_ID1 (type: esriFieldTypeString, alias: Subaddress Identifier 1, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- SUB_TYPE2 (type: esriFieldTypeString, alias: Subaddress Type 2, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Apartment: Apartment], [Building: Building], [Center: Center], ... 19 more ...)
- SUB_ID2 (type: esriFieldTypeString, alias: Subaddress Identifier 2, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- ZIP (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true)
- ZIP4 (type: esriFieldTypeString, alias: ZIP Plus 4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- CTU_NAME (type: esriFieldTypeString, alias: CTU Name, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [Belle Plaine: Belle Plaine], [Belle Plaine Township: Belle Plaine Township], [Blakeley Township: Blakeley Township], ... 16 more ...)
- CTU_ID_TXT (type: esriFieldTypeString, alias: CTU Code, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true, Coded Values: [02394113: Belle Plaine], [00663556: Belle Plaine Township], [00663612: Blakeley], ... 23 more ...)
- POSTCOMM (type: esriFieldTypeString, alias: Postal Community Name, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true, Coded Values: [Belle Plaine: Belle Plaine], [Burnsville: Burnsville], [Elko New Market: Elko New Market], ... 9 more ...)
- CO_CODE (type: esriFieldTypeString, alias: County Code, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true, Coded Values: [27139: Scott], [27079: Le Sueur])
- CO_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true, Coded Values: [Scott: Scott], [Le Sueur: Le Sueur])
- STATE_CODE (type: esriFieldTypeString, alias: State Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [MN: Minnesota])
- LOC_DESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- LANDMARK (type: esriFieldTypeString, alias: Complete Landmark Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- RESIDENCE (type: esriFieldTypeString, alias: Residence, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- MAILABLE (type: esriFieldTypeString, alias: Mailable Address, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- STATE_PIN (type: esriFieldTypeString, alias: Parcel Unique Identifier, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
- PLACE_LOC (type: esriFieldTypeString, alias: Placement Location, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Centroid or random placement within parcel polygon], [2: Aligned to doorstop], ... 5 more ...)
- CEN_GEO (type: esriFieldTypeString, alias: Centerline Geocodable, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- UNI_WO_SUB (type: esriFieldTypeString, alias: Unique Without Subaddresses, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- USNG_CODE (type: esriFieldTypeString, alias: US National Grid Code, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- GIS911POC (type: esriFieldTypeString, alias: 911 GIS Point-of-Contact, SQL Type: sqlTypeOther, length: 75, nullable: false, editable: true, Coded Values: [Scott: Scott], [Le Sueur: Le Sueur])
- ESN (type: esriFieldTypeString, alias: Emergency Service Number, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true)
- PSAP_CODE (type: esriFieldTypeString, alias: PSAP Code, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true, Coded Values: [SCOT: Scott County], [LESR: LeSueur County])
- MSAG_C (type: esriFieldTypeString, alias: MSAG Community Name, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [Belle Plaine: Belle Plaine], [Elko New Market: Elko New Market], [Jordan: Jordan], ... 16 more ...)
- VERROR_911 (type: esriFieldTypeString, alias: 911 Validation Error, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- STATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Active: Active], [Retired: Retired])
- EFF_DATE (type: esriFieldTypeDate, alias: Effective Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- RET_DATE (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- AAUTHORITY (type: esriFieldTypeString, alias: Address Authority, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true, Coded Values: [ScottCounty: ScottCounty], [BellePlaine: BellePlaine], [BoltonMenk: BoltonMenk], ... 8 more ...)
- EDIT_ORG (type: esriFieldTypeString, alias: Editing Organization, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true, Coded Values: [BellePlaine: BellePlaine], [CreditRiver: CreditRiver], [ElkoNewMarket: ElkoNewMarket], ... 7 more ...)
- COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- STRUCTURE_TYPE (type: esriFieldTypeString, alias: STRUCTURE_TYPE, SQL Type: sqlTypeOther, length: 101, nullable: false, editable: true, Coded Values: [Bridge: Bridge], [Cell Tower: Cell Tower], [Cemetery: Cemetery], ... 12 more ...)
- REVIEW (type: esriFieldTypeString, alias: REVIEW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- AUTHORITY_REVIEW (type: esriFieldTypeString, alias: AUTHORITY_REVIEW, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- WEBUSER (type: esriFieldTypeString, alias: WEBUSER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- RENTAL (type: esriFieldTypeString, alias: RENTAL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- GRIDNUMBER (type: esriFieldTypeString, alias: GRIDNUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- FULL_ADDRESS_USPS (type: esriFieldTypeString, alias: FULL_ADDRESS_USPS, SQL Type: sqlTypeOther, length: 250, nullable: false, editable: true)
- MAILABLE_COMMENTS (type: esriFieldTypeString, alias: MAILABLE_COMMENTS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [Address Mismatch: Address Mismatch], [Address Not Found: Address Not Found], [Multiple addresses were found for the information you entered, and no default exists: Multiple addresses were found for the information you entered, and no default exists], ... 2 more ...)
- ADR_RETURNED (type: esriFieldTypeString, alias: ADR_RETURNED, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
- AC_MAILABLE_COMMENTS (type: esriFieldTypeString, alias: AC_MAILABLE_COMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [AC OVERRIDE-DIRECTIONAL: AC OVERRIDE-DIRECTIONAL], [AC OVERRIDE-DIRECTIONAL AND SUBTYPE: AC OVERRIDE-DIRECTIONAL AND SUBTYPE], [AC OVERRIDE-DIRECTIONAL AND UNIT TYPE: AC OVERRIDE-DIRECTIONAL AND UNIT TYPE], ... 13 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- MULTI_TENANT (type: esriFieldTypeString, alias: MULTI_TENANT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- TO_DELETE (type: esriFieldTypeString, alias: TO_DELETE, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- AC_DATE (type: esriFieldTypeDate, alias: AC_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- USPS_VALIDATION_COMMENTS (type: esriFieldTypeString, alias: USPS_VALIDATION_COMMENTS, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- EDIT_DATE (type: esriFieldTypeDate, alias: EDIT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- LST_PREDIR (type: esriFieldTypeString, alias: LST_PREDIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- LST_NAME (type: esriFieldTypeString, alias: LST_NAME, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- LST_TYPE (type: esriFieldTypeString, alias: LST_TYPE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- LST_POSDIR (type: esriFieldTypeString, alias: LST_POSDIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
Templates:
Name: Address_Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ANUMBER: 0
- ST_NAME:
- ZIP:
- CTU_NAME:
- CTU_ID_TXT:
- POSTCOMM:
- CO_CODE:
- CO_NAME:
- STATE_CODE: MN
- MAILABLE: Unknown
- STATE_PIN: 27139-
- PLACE_LOC:
- CEN_GEO: Unknown
- GIS911POC: Scott
- ESN:
- PSAP_CODE: SCOT
- MSAG_C:
- STATUS: Active
- AAUTHORITY:
- EDIT_ORG:
- STRUCTURE_TYPE:
- REVIEW: No
- AUTHORITY_REVIEW: No
- RENTAL: No
- FULL_ADDRESS_USPS:
- TO_DELETE: No
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/18/2024 3:27:21 PM
Schema Last Edit Date: 4/18/2024 3:27:21 PM
Data Last Edit Date: 4/18/2024 3:27:13 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates