Name: Address Points

Display Field: ADDRESS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 4800

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 5549712.50403271
YMin: 3578239.17753748
XMax: 5735424.10427624
YMax: 3721211.02699416
Spatial Reference: 102675 (3417)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[ADDRESS] CONCAT NEWLINE CONCAT [Unit]","labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"where":"(CITYCODE = 0 AND PLACE <> 'Removed' )","useCodedValues":true,"maxScale":0,"minScale":15840,"name":"Rural","priority":115,"symbol":{"type":"esriTS","color":[255,170,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Lucida Sans","size":8,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpression":"[TESTHNUM] CONCAT NEWLINE CONCAT [Unit]","labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"where":"(CITYCODE = 1 AND PLACE <> 'Removed' )","useCodedValues":true,"maxScale":0,"minScale":2400,"name":"Urban","priority":111,"symbol":{"type":"esriTS","color":[56,168,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Lucida Sans","size":8,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpression":"[TESTHNUM]","labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"where":"PLACE = 'Removed'","useCodedValues":true,"maxScale":0,"minScale":15840,"name":"Removed","priority":114,"symbol":{"type":"esriTS","color":[130,130,130,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Lucida Sans","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}

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)
• ID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• TD_STAMP (type: esriFieldTypeString, alias: TD_STAMP, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• BOX (type: esriFieldTypeString, alias: BOX, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: ROUTE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [DUBUQUE: Dubuque], [BELLEVUE: Bellevue], [BERNARD: Bernard], ... 23 more ...)
• PLACE (type: esriFieldTypeString, alias: PLACE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Airport Buildings: Airport Buildings], [Apartment: Apartment], [Business: Business], ... 16 more ...)
• DIR (type: esriFieldTypeString, alias: DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: North], [S: South], [E: East], ... 5 more ...)
• ROAD (type: esriFieldTypeString, alias: ROAD, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GPS (type: esriFieldTypeString, alias: GPS, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MATCH_OLD_ (type: esriFieldTypeString, alias: MATCH_OLD_, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• CHANGEBY (type: esriFieldTypeDouble, alias: CHANGEBY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WHYCHANGE (type: esriFieldTypeString, alias: WHYCHANGE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NEW_SEQ (type: esriFieldTypeString, alias: NEW_SEQ, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CURR_SEQ (type: esriFieldTypeString, alias: CURR_SEQ, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• COMBINEDOL (type: esriFieldTypeString, alias: COMBINEDOL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TESTHNUM (type: esriFieldTypeString, alias: TESTHNUM, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• TESTSTREET (type: esriFieldTypeString, alias: TESTSTREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ERROR (type: esriFieldTypeString, alias: ERROR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CURRENT_AD (type: esriFieldTypeString, alias: CURRENT_AD, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BILLING (type: esriFieldTypeString, alias: BILLING, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ZIP_CODE (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [52001: Dubuque 52001], [52002: Dubuque 52002], [52003: Dubuque 52003], ... 17 more ...)
• CHANGE (type: esriFieldTypeString, alias: CHANGE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ORIGADDRSI (type: esriFieldTypeString, alias: ORIGADDRSI, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [even: Even], [odd: Odd])
• NEWADDRSID (type: esriFieldTypeString, alias: NEWADDRSID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [even: Even], [odd: Odd])
• QC_CODE (type: esriFieldTypeString, alias: QC_CODE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CITYCODE (type: esriFieldTypeInteger, alias: CITYCODE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Rural], [1: Urban])
• MSAG_Comm (type: esriFieldTypeString, alias: MSAG Community, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [DUBUQUE: Dubuque], [BELLEVUE: Bellevue], [BERNARD: Bernard], ... 23 more ...)
• GC_Exception (type: esriFieldTypeString, alias: GC_Exception, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Site_UID (type: esriFieldTypeString, alias: SiteUnqID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)

Templates:

Name: Address Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PLACE: Home

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/15/2024 2:28:31 PM

Schema Last Edit Date: 5/15/2024 2:28:31 PM

Data Last Edit Date: 5/15/2024 2:28:31 PM

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