Name: Address

Display Field: st_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text: City of Bismarck GIS Dept: Contact Darrel Nucech - GIS Coordinator, 701-355-1600

Min. Scale: 5090.58061999825

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1856730.06528871
YMin: 343838.620078743
XMax: 2077442.98589239
YMax: 605578.651574805
Spatial Reference: 2910 (2910)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"4cc0ed55d972ebe6295a53aa5229851c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAYAAAAGCAYAAADgzO9IAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAD0lEQVQImWNhwAFYBlICAAjKABk/1SSdAAAAAElFTkSuQmCC","contentType":"image/png","width":4,"height":4,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.ADDRESS","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","removeDuplicates":"none","stackLabel":false,"useCodedValues":true,"maxScale":854,"minScale":1334.4651660488232,"name":"Full Address","priority":-1,"symbol":{"type":"esriTS","color":[115,76,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"AvenirNext LT Pro Regular","size":7.5,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.Add_Number","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","removeDuplicates":"none","stackLabel":false,"useCodedValues":true,"maxScale":2085.1018219512862,"minScale":5090.5806199982571,"name":"House Number","priority":-1,"symbol":{"type":"esriTS","color":[115,76,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,127],"haloSize":1,"font":{"family":"AvenirNext LT Pro Regular","size":7.5,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.ADDRESS + \" \" + $feature.Unit","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"useCodedValues":true,"maxScale":0,"minScale":853,"name":"Full Address With Unit","priority":-1,"symbol":{"type":"esriTS","color":[115,76,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,127],"haloSize":1,"font":{"family":"AvenirNext LT Pro Medium","size":7.5,"style":"normal","weight":"bold","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:

• DiscrpAgID (type: esriFieldTypeString, alias: Discrepancy Agency ID, SQL Type: sqlTypeOther, length: 75, nullable: false, editable: true)
• DateUpdate (type: esriFieldTypeDate, alias: Date Updated, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
• Effective (type: esriFieldTypeDate, alias: Effective Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Site_NGUID (type: esriFieldTypeString, alias: Site NENA Globally Unique ID, SQL Type: sqlTypeOther, length: 254, nullable: false, editable: true)
• AddCode (type: esriFieldTypeString, alias: Additional Code, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• AddDataURI (type: esriFieldTypeString, alias: Additional Data URI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Inc_Muni (type: esriFieldTypeString, alias: Incorporated Municipality, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [ALMONT: ALMONT], [ARENA: ARENA], [BALDWIN: BALDWIN], ... 61 more ...)
• 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)
• AddNum_Pre (type: esriFieldTypeString, alias: Address Number Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Add_Number (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 999999])
• AddNum_Suf (type: esriFieldTypeString, alias: Address Number Suffix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• St_PreMod (type: esriFieldTypeString, alias: Street name Pre Modifier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• St_PreTyp (type: esriFieldTypeString, alias: Street Name Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AVENUE: Avenues (as a Prefix)], [BIA ROAD: Bureau of Indian Affairs Roads], [BIA ROUTE: Bureau of Indian Affairs Routes], ... 4 more ...)
• St_PreSep (type: esriFieldTypeString, alias: Street Name Pre Type Separator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [at: at], [de las: de las], [del: del], ... 7 more ...)
• St_PosTyp (type: esriFieldTypeString, alias: Street Name Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AVE: AVE], [ALY: ALY], [BND: BND], ... 30 more ...)
• St_PosDir (type: esriFieldTypeString, alias: Street Name Post Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [N: N], [W: W], [E: E], ... 5 more ...)
• St_PosMod (type: esriFieldTypeString, alias: Street Name Post Modifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LSt_PreDir (type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N], [W: W], [E: E], ... 5 more ...)
• LSt_Name (type: esriFieldTypeString, alias: Legacy Street Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LSt_Type (type: esriFieldTypeString, alias: Legacy Street Name Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [ALY: ALLEY], [ANX: ANEX], [ARC: ARCADE], ... 199 more ...)
• LSt_PosDir (type: esriFieldTypeString, alias: Legacy Street Name Post Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N], [W: W], [E: E], ... 5 more ...)
• F_ESN (type: esriFieldTypeString, alias: Future ESN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MSAGComm (type: esriFieldTypeString, alias: MSAG Community Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [ALMONT: ALMONT], [ARENA: ARENA], [BALDWIN: BALDWIN], ... 61 more ...)
• Post_Comm (type: esriFieldTypeString, alias: Postal Community Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [ALMONT: ALMONT], [ARENA: ARENA], [BALDWIN: BALDWIN], ... 61 more ...)
• Post_Code (type: esriFieldTypeString, alias: Postal Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Post_Code4 (type: esriFieldTypeString, alias: ZIP Plus 4, SQL Type: sqlTypeOther, length: 4, 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)
• Seat (type: esriFieldTypeString, alias: Seat, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Addtl_Loc (type: esriFieldTypeString, alias: Additional Location Information, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• LandmkName (type: esriFieldTypeString, alias: Complete Landmark Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Mile_Post (type: esriFieldTypeString, alias: Milepost, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Place_Type (type: esriFieldTypeString, alias: Place Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [airport: A place from which aircrafts operate, such as an airport or heliport.], [arena: Enclosed area used for sports events.], [bank: Business establishment in which money is kept for saving, commercial purposes, is invested, supplied for loans, or exchanged.], ... 31 more ...)
• Placement (type: esriFieldTypeString, alias: Placement Method, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Geocoding: Placement of an address point to represent an address along a road segment based on the high and low numbers assigned to the road segment using geocoding techniques.], [Parcel: Placement of an address point to represent an address associated with a parcel.], [Property Access: Placement of an address point to represent an address based on the location of the primary access to a given property.], ... 3 more ...)
• Long (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-180 - 180])
• Lat (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-90 - 90])
• Elev (type: esriFieldTypeSmallInteger, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACCURACY (type: esriFieldTypeString, alias: Accuracy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sub centimeter: Sub centimeter], [Sub decimeter: Sub decimeter], [Sub meter: Sub meter], ... 4 more ...)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MSAG_ADD (type: esriFieldTypeString, alias: MSAG Address, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• CREATED (type: esriFieldTypeDate, alias: CREATED, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
• GEOMSAG_STATUS (type: esriFieldTypeString, alias: GEOMSAG STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Permit_Location (type: esriFieldTypeString, alias: Permit Location, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [CITY OF BISMARCK: CITY OF BISMARCK], [BISMARCK ETA: BISMARCK ETA], [BURLEIGH COUNTY: BURLEIGH COUNTY], ... 2 more ...)
• City_Code (type: esriFieldTypeString, alias: City CAD Code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ALMT: ALMT], [ARE: ARE], [BAL: BAL], ... 19 more ...)
• Label_CAD (type: esriFieldTypeString, alias: Label_CAD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• City_L (type: esriFieldTypeString, alias: City CAD Code Left, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ALMT: ALMT], [ARE: ARE], [BAL: BAL], ... 19 more ...)
• City_R (type: esriFieldTypeString, alias: City CAD Code Right, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ALMT: ALMT], [ARE: ARE], [BAL: BAL], ... 19 more ...)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Expire (type: esriFieldTypeDate, alias: Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [CA: Canada], [MX: Mexico], [US: United States])
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [AK: Alaska], [AL: Alabama], [AR: Arkansas], ... 59 more ...)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true, Coded Values: [ADAMS COUNTY: Adams County], [BARNES COUNTY: Barnes County], [BENSON COUNTY: Benson County], ... 68 more ...)
• St_PreDir (type: esriFieldTypeString, alias: Street Name Pre Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [N: N], [W: W], [E: E], ... 5 more ...)
• St_Name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STR_NAME (type: esriFieldTypeString, alias: Full Street Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• ESN (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LOCAL_ID (type: esriFieldTypeString, alias: Local ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 210, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: Source of Record, SQL Type: sqlTypeOther, length: 75, nullable: false, editable: true)
• DLVRY_ADD (type: esriFieldTypeString, alias: DELIVERY ADDRESS, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• EDITOR (type: esriFieldTypeString, alias: EDITOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• SP_USERNAME (type: esriFieldTypeString, alias: SP_USERNAME, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SP_DATETIME (type: esriFieldTypeDate, alias: SP_DATETIME, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• Structure_Type (type: esriFieldTypeSmallInteger, alias: Structure Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Addressable Structure - Single Address], [4: Non-Addressable Structure], [7: Verified - No Structure], ... 2 more ...)
• Placement_Source (type: esriFieldTypeSmallInteger, alias: Placement Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Aerial Imagery], [3: Visual Fieldwork], [5: County provided information], ... 3 more ...)
• Attribute_Source (type: esriFieldTypeSmallInteger, alias: Attribute Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: ALI Database], [3: Fieldwork Verification], [4: Resident Verification - in person], ... 7 more ...)
• Addressing_Issue (type: esriFieldTypeSmallInteger, alias: Addressing Issue, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: NO], [2: YES], [3: YES - Odd\Even Issue], ... 3 more ...)
• FIELDWORK_RESULTS (type: esriFieldTypeSmallInteger, alias: FIELDWORK_RESULTS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Resolved], [2: Unresolved - Left behind Survey], [4: None], ... 1 more ...)
• Parcel_ID (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Floodplain (type: esriFieldTypeString, alias: Floodplain, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• UQID (type: esriFieldTypeString, alias: Former UQID (Temp), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Primary_Address (type: esriFieldTypeString, alias: Primary Address, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

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: 8/24/2022 5:43:50 PM

Schema Last Edit Date: 8/24/2022 5:43:50 PM

Data Last Edit Date: 8/24/2022 5:43:50 PM

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