Name: Address

Display Field: landmark_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 10000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -19664765.7485
YMin: 6229290.7538
XMax: -13634129.7135
YMax: 6776218.7911
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"f39b7d339e443ff8c918eee8ddbf1fe2","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAYAAAAGCAYAAADgzO9IAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAWklEQVQImWNhYGBg+L/vmTHDf0ZfBkZGSYY/vxoZ3eSesYAFGZjOMDCClDAwMLCwpf3f98yEBaISKggHTGksYO1YAAvITJB2VOF/s1hAFoHMBGmHCTI6SZ0FABGlHKGwjvW7AAAAAElFTkSuQmCC","contentType":"image/png","width":4,"height":4,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.add_number","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamicNeverRemove","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"unit IS NULL And room IS NULL","useCodedValues":true,"maxScale":0,"minScale":3500,"name":"Address Number","priority":-1,"symbol":{"type":"esriTS","color":[76,115,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":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.unit","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"room IS NULL","useCodedValues":true,"maxScale":0,"minScale":1200,"name":"Unit Label","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":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.st_name","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":800,"name":"Room Number","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"$feature.building","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamicNeverRemove","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":10000,"name":"Building Label","priority":-1,"symbol":{"type":"esriTS","color":[115,0,76,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":"Tahoma","size":10,"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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• state_prov (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AK: Alaska], [AL: Alabama], [AR: Arkansas], ... 57 more ...)
• county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• inc_muni (type: esriFieldTypeString, alias: Incorporated Municipality, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• 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)
• add_num_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])
• add_num_suf (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: [E: East], [N: North], [NE: Northeast], ... 5 more ...)
• st_pre_typ (type: esriFieldTypeString, alias: Street Name Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Access Road: Access Road], [Acres: Acres], [Alcove: Alcove], ... 303 more ...)
• st_pre_sep (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_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• st_pos_typ (type: esriFieldTypeString, alias: Street Name Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Access Road: Access Road], [Acres: Acres], [Alcove: Alcove], ... 303 more ...)
• st_pos_dir (type: esriFieldTypeString, alias: Street Name Post Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 5 more ...)
• st_pos_mod (type: esriFieldTypeString, alias: Street Name Post Modifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• lst_pre_dir (type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 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: 4, nullable: true, editable: true, Coded Values: [ALY: ALLEY], [ANX: ANEX], [ARC: ARCADE], ... 199 more ...)
• lst_pos_dir (type: esriFieldTypeString, alias: Legacy Street Name Post Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 5 more ...)
• esn (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• msag_comm (type: esriFieldTypeString, alias: MSAG Community Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• post_comm (type: esriFieldTypeString, alias: Postal Community Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• 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)
• unit (type: esriFieldTypeString, alias: Unit, 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)
• addtional_location_info (type: esriFieldTypeString, alias: Additional Location Information, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• landmark_name (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: [convention-center: Convention center or exhibition hall.], [classroom: Academic classroom or lecture hall.], [industrial: Industrial setting, such as a manufacturing floor or power plant.], ... 31 more ...)
• placement (type: esriFieldTypeString, alias: Placement Method, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-180 - 180])
• latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-90 - 90])
• elevation (type: esriFieldTypeSmallInteger, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fdid_guid (type: esriFieldTypeGUID, alias: FDID Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• site_guid (type: esriFieldTypeGUID, alias: Site GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• facility_guid (type: esriFieldTypeGUID, alias: Facility GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• level_guid (type: esriFieldTypeGUID, alias: Level GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• LEVEL_NUMBER (type: esriFieldTypeInteger, alias: LEVEL_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Floor 1], [2: Floor 2], [3: Floor 3], ... 105 more ...)
• LEVEL_NAME (type: esriFieldTypeString, alias: LEVEL_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Floor 1], [G: Ground Level], [L: Lobby], ... 154 more ...)
• NAME_SHORT (type: esriFieldTypeString, alias: NAME_SHORT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• unit_guid (type: esriFieldTypeGUID, alias: Unit GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• unit_name (type: esriFieldTypeString, alias: Unit Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• 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)
• 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)
• addr_line1 (type: esriFieldTypeString, alias: Address Line 1, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• addr_line2 (type: esriFieldTypeString, alias: Address Line 2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• addr_line3 (type: esriFieldTypeString, alias: Address Line 3, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)

Templates:

Name: Address
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• LEVEL_NUMBER: 1

Relationships:

• Contacts_Address (0) -- Related To: Contacts_Address (1)
• Inspector_Occupancy (1) -- Related To: Occupancy_Inspection (2)
• Inspector_Vegitation (2) -- Related To: Inspector_Vegitation (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/21/2023 4:39:04 AM

Schema Last Edit Date: 10/21/2023 4:39:04 AM

Data Last Edit Date: 10/15/2023 12:47:21 AM

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