Name: Lamp
Display Field: assettype
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 12000
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -20037507.8427882
YMin: -30240971.4583861
XMax: 20037507.8427882
YMax: 30240971.4583861
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"assettype","defaultSymbol":{"type":"esriPMS","url":"6aab8fa2583d3399c8bee34395ad690a","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADJUlEQVQ4jbWUv08TYRjHv+K9Sq/vVdIjPakNLWCrovFHJwfTP0DGQsNwhGAIiyYymEjipoNxI0ZnB29oai7GEGxwMTAxMSlqGUShPa5wRO5XQ6zVAe/Sa6slJn6n955773Pf53mf92Hwn8S02yDJcoT5jgilbNismCZ+dOhVgk0xnd78J3A2K18Nh0NTPM9fZ/0sOjs7BcIQWJZl7em6ms8v5PZM/e3oyMibQ4ElWY7w9MTY2TOnb4dCIYH1+QAApmmCUgqeD/oB9A8M9M+sf16fyOcXnmna9kNRFPU/giVZjghdwbsXzp+7dVIQPD9cWVkBAKRSKQAA6/NhcPCcEOSDMx8/FeKSJN2oh3vAPD0xduXSxVs8H8Ts7CwMw2hKcXFx0V1zHIfp6WkQhqRtu6ICuNkEzmblqwP9sds8HwQATE5OYn5+HvF4HIlEwgMvFApYW1vD0NDQgSE+iL5YdDyblZ+PjqaXPeBwODR16lTYzZ9SCkqpu25U/XsAiEZ7/Wq5fAfAsAuWZDnC8/x156DqZZpmyxjHcZ4Y6/Mh1N19LZfLDWYymVUGAA76tNlWIpFwD61eiqIgmUw2xbkAJ9RqRwOuY9rlp8eOH/O3SldRFCwtLXnihmG0LA8hBCzbeRbAMgMAhq53EYY0bezp6YFhGJ5OcN01lMKRvW+XXMdHakc3Lcuyfjd/E6Cx7TiOa+n4Z+2n5awZAKhWK6vmwSk1gZPJJBRFgaIooJT+EQoAO5qmVjs6Vl2wKIp6Pr/wLNYXm2nsDOemOXV2nptKUKlALW+/doaT28d7pv62WCxNxE8PCC2/bKNisaRquztzzrMLHh0ZefPy1dwTjqMPGudEO22pKr583XhRP+k8s8Iy9h5//FS4TBiSdq52O2naLt69//BEVYr36uMesCiKuiRJN2y7ovbFouPRaK/fqXkqlfLcQrtSQbFYUr983Xihftt99Nex6cAB3Mzlck/Vcvl+qLv7GhfgBEIICENgGFvWjqapann7tba7M3foQe8ok8msAhiWJCnAML5BStlwrVYL2Pt2qbq/v9zo8NDghgyW2+1r1C+CAT6PdLQhqQAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"6aab8fa2583d3399c8bee34395ad690a","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADJUlEQVQ4jbWUv08TYRjHv+K9Sq/vVdIjPakNLWCrovFHJwfTP0DGQsNwhGAIiyYymEjipoNxI0ZnB29oai7GEGxwMTAxMSlqGUShPa5wRO5XQ6zVAe/Sa6slJn6n955773Pf53mf92Hwn8S02yDJcoT5jgilbNismCZ+dOhVgk0xnd78J3A2K18Nh0NTPM9fZ/0sOjs7BcIQWJZl7em6ms8v5PZM/e3oyMibQ4ElWY7w9MTY2TOnb4dCIYH1+QAApmmCUgqeD/oB9A8M9M+sf16fyOcXnmna9kNRFPU/giVZjghdwbsXzp+7dVIQPD9cWVkBAKRSKQAA6/NhcPCcEOSDMx8/FeKSJN2oh3vAPD0xduXSxVs8H8Ts7CwMw2hKcXFx0V1zHIfp6WkQhqRtu6ICuNkEzmblqwP9sds8HwQATE5OYn5+HvF4HIlEwgMvFApYW1vD0NDQgSE+iL5YdDyblZ+PjqaXPeBwODR16lTYzZ9SCkqpu25U/XsAiEZ7/Wq5fAfAsAuWZDnC8/x156DqZZpmyxjHcZ4Y6/Mh1N19LZfLDWYymVUGAA76tNlWIpFwD61eiqIgmUw2xbkAJ9RqRwOuY9rlp8eOH/O3SldRFCwtLXnihmG0LA8hBCzbeRbAMgMAhq53EYY0bezp6YFhGJ5OcN01lMKRvW+XXMdHakc3Lcuyfjd/E6Cx7TiOa+n4Z+2n5awZAKhWK6vmwSk1gZPJJBRFgaIooJT+EQoAO5qmVjs6Vl2wKIp6Pr/wLNYXm2nsDOemOXV2nptKUKlALW+/doaT28d7pv62WCxNxE8PCC2/bKNisaRquztzzrMLHh0ZefPy1dwTjqMPGudEO22pKr583XhRP+k8s8Iy9h5//FS4TBiSdq52O2naLt69//BEVYr36uMesCiKuiRJN2y7ovbFouPRaK/fqXkqlfLcQrtSQbFYUr983Xihftt99Nex6cAB3Mzlck/Vcvl+qLv7GhfgBEIICENgGFvWjqapann7tba7M3foQe8ok8msAhiWJCnAML5BStlwrVYL2Pt2qbq/v9zo8NDghgyW2+1r1C+CAT6PdLQhqQAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"Unknown"},{"symbol":{"type":"esriPMS","url":"fdd29ec30c402f8dca203e49a9fa3532","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADOklEQVQ4jbWUPWzTWhTH/xTbNI4dqtwqJm7UpC0VoSA+hPgYmBgRSE8KjToYIRj6hiKxIFGJga8BWBEMsDDgIQqyABURFQlYi3jd3isFBmipE5zW0au/ooYQGMBWHBdSIfGfzj2+/t1zzj33UPhDotptkBUlQX1GguNY0apaFr50GHUaC1Ims/Bb4FxOOSCKsVFCyGE2zKKzs1OgKRq2bdvLhqEVCpP5Zct4MTI8/HRNYFlREoTbeDy9ZfOZWCwmsKEQAKBk1kB4BoREwwD6Bwb6xz+8/3CyUJi8q+uLVyVJMn4KlhUlIXRFz23ftvX0JkHwHXjn1ScAwIVDvQAANhTC0NBWIUqi47Nv3g7KsnyqGe4DE27j8d07d5wmJIqeay9RNGuBFC8+m/NskWegju8HTdEZx6lqAMYC4FxOOTDQnzpDSBQA8M/Ybvz98B2OpAmOpqM++MRsBY9nddz+a/B7QCSKvlTyRC6n3BsZyUz5wKIYG+3pEb384zyDOM94dquavwNAMtkb1srlswCOeWBZURKEkMPuRTWrtEo5SmYNYmSDz8eGQoh1dx/M5/ND2Wx2hgKA733Kca2Ao2mCO69KAfC0amJ0bzzg5yO80Gisj3gRc11hjtnAhFdLd1q1cOn5vM9fNGurloemabBsZxrAFAUApmF00RQd2Linh0PRrPk6wZUYCYIBwFlxil7E6xrrF2zbtn80vx/AM4G2E1suztXXxlfbtSkAqNerM5ZlWQAC4NF9cUyrJqZVC/EI81MoACzpulbv6JjxwJIkGYXC5N1UX2q8tTPcl+bW2V0HSlCtQisvPnGHk9fHy5bxQlWLJwc3Dwir/tlGqlrU9MrShLv2wCPDw08fPJq4yfPcldY50U6fNA1z8x/vN08636ywzeUbs2/e7qIpOuM+7XbS9Qr+/e/1Ta2knm/2+8CSJBmyLJ9ynKrWl0qeSCZ7w27NLxzq9b1Cp1qFqha1ufmP97X/K9d/OTZdOICxfD5/SyuXL8e6uw/yEV6gaRoMRaNUqtlLuq5p5cUnemVpYs2D3lU2m50BcEyW5QhFhYY4jhUbjUbEWXGK9ZWVqdYI1wxuyWCq3b5WfQOrSj7xtmnzeAAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"121","label":"Lamp"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[198,252,184,255],"toColor":[198,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,182,252,255],"toColor":[242,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,233,252,255],"toColor":[179,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,196,179,255],"toColor":[252,196,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,189,255],"toColor":[252,242,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,241,255],"toColor":[252,215,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,197,252,255],"toColor":[184,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,232,255],"toColor":[204,252,232,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,230,215,255],"toColor":[252,230,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,207,255],"toColor":[252,184,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,220,252,255],"toColor":[212,220,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,230,255],"toColor":[252,182,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,211,255],"toColor":[252,207,211,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
HasM: true
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field: assettype
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [121: Lamp])
- creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- regulatorytype (type: esriFieldTypeSmallInteger, alias: Regulatory Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Distribution], [2: Gathering], ... 3 more ...)
- yesno (type: esriFieldTypeSmallInteger, alias: Drain Valve Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
- installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
- maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
- lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
- maopdesign (type: esriFieldTypeDouble, alias: MAOP Design, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [0 - 10000])
- maoptest (type: esriFieldTypeDouble, alias: MAOP Test, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 10000])
- maoprecord (type: esriFieldTypeDouble, alias: MAOP Record, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [0 - 10000])
- symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
- quantity (type: esriFieldTypeDouble, alias: Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
- usage (type: esriFieldTypeDouble, alias: Usage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
- notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
- rating (type: esriFieldTypeDouble, alias: Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
- specification (type: esriFieldTypeString, alias: Specification, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- remoteoperation (type: esriFieldTypeSmallInteger, alias: Remote Operation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
- modelnumber (type: esriFieldTypeString, alias: Model Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
- ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
- ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
- ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
- ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- locationdescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- cpprotected (type: esriFieldTypeSmallInteger, alias: Cathodically Protected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
Types:
ID: 0
Name: Unknown
Domains:
- Field Name: assettype
Inherited
- Field Name: regulatorytype
Inherited
- Field Name: yesno
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: maopdesign
Inherited
- Field Name: maoptest
Inherited
- Field Name: maoprecord
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: bondedinsulated
Inherited
- Field Name: remoteoperation
Inherited
- Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
- Field Name: ESRIGNSS_FIXTYPE
Inherited
- Field Name: ESRIGNSS_STATIONID
Inherited
- Field Name: ESRIGNSS_NUMSATS
Inherited
- Field Name: cpprotected
Inherited
Templates:
Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- regulatorytype: 0
- ownedby: 1
- lifecyclestatus: 8
- maintby: 1
- assettype: 0
- yesno: 0
- maopdesign: 0
- remoteoperation: 0
ID: 121
Name: Lamp
Domains:
- Field Name: assettype
Inherited
- Field Name: regulatorytype
Inherited
- Field Name: yesno
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: maopdesign
Inherited
- Field Name: maoptest
Inherited
- Field Name: maoprecord
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: bondedinsulated
Inherited
- Field Name: remoteoperation
Inherited
- Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
- Field Name: ESRIGNSS_FIXTYPE
Inherited
- Field Name: ESRIGNSS_STATIONID
Inherited
- Field Name: ESRIGNSS_NUMSATS
Inherited
- Field Name: cpprotected
Inherited
Templates:
Name: Lamp
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- regulatorytype: 0
- ownedby: 1
- lifecyclestatus: 8
- maintby: 1
- maopdesign: 0
- maoptest: 0
- assettype: 121
- yesno: 0
- maoprecord: 0
- remoteoperation: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/19/2021 9:28:30 PM
Schema Last Edit Date: 1/19/2021 9:28:30 PM
Data Last Edit Date: 1/19/2021 9:28:30 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Boxplots
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat