{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "ProdGeoDB.STREETLIGHTS.StreetLighting_Lamps", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ModelName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "Streetlight GIS ID", "domain": null }, { "name": "GIS_FeatureKey", "type": "esriFieldTypeString", "alias": "Unique Lamp ID", "length": 20, "domain": null }, { "name": "LampStyle", "type": "esriFieldTypeString", "alias": "Lamp Style", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_LampStyle", "description": "Street Lighting - Lamp Style ", "codedValues": [ { "name": "Gas", "code": "GAS" }, { "name": "Light Emitting Diode (LED)", "code": "LED" }, { "name": "High Pressure Sodium (HPS)", "code": "HPS" }, { "name": "Metal Halide (MH)", "code": "MH" }, { "name": "Mercury Vapor (MV)", "code": "MV" }, { "name": "Low Pressure Sodium (LPS)", "code": "LPS" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FixtureStyle", "type": "esriFieldTypeString", "alias": "Fixture Style", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_FixtureStyle", "description": "Street Lighting - Fixture Style", "codedValues": [ { "name": "Box Light", "code": "BL" }, { "name": "Coach Lantern", "code": "CL" }, { "name": "Cobra", "code": "COB" }, { "name": "Decorative Acorn (King)", "code": "DA-K" }, { "name": "Decorative Acorn (Quattro)", "code": "DA-Q" }, { "name": "DuraStar", "code": "DS" }, { "name": "DuraStar - w/ Pedestrian Globe", "code": "DS+PG" }, { "name": "Flood Light", "code": "FL" }, { "name": "Helios", "code": "HEL" }, { "name": "Light Emitting Diode", "code": "LED" }, { "name": "Lumec Urbanscape (Philips)", "code": "LUM" }, { "name": "Ornamental Post Top", "code": "OPT" }, { "name": "Other", "code": "OTH" }, { "name": "Pedestrian Globe", "code": "PG" }, { "name": "Post Top Crook Arm", "code": "PTCA" }, { "name": "Unknown", "code": "UKN" }, { "name": "Wall Pack", "code": "WP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlType", "type": "esriFieldTypeString", "alias": "Control Type", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_ControlType", "description": "Street Lighting - Control Type", "codedValues": [ { "name": "Photo Electric", "code": "Photo" }, { "name": "Relay", "code": "Relay" }, { "name": "N/A", "code": "NA" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MountType", "type": "esriFieldTypeString", "alias": "Mount Type", "length": 8, "domain": { "type": "codedValue", "name": "StreetLighting_FixtureMountType", "description": "Street Lighting - Fixture Mount Type", "codedValues": [ { "name": "Arm", "code": "Arm" }, { "name": "Other", "code": "Other" }, { "name": "Post Top", "code": "Post Top" }, { "name": "Standard", "code": "Standard" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MountHeight", "type": "esriFieldTypeString", "alias": "Mount Height", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_FixtureMountHeight", "description": "Street Lighting - Fixture Mount Height", "codedValues": [ { "name": "2.7 m (9 ft)", "code": "9" }, { "name": "2.9 m (9.5 ft)", "code": "9.5" }, { "name": "3.0 m (10 ft)", "code": "10" }, { "name": "3.2 m (10.5 ft)", "code": "10.5" }, { "name": "3.3 m (11 ft)", "code": "11" }, { "name": "3.5 m (11.5 ft)", "code": "11.5" }, { "name": "3.7 m (12 ft)", "code": "12" }, { "name": "3.8 m (12.5 ft)", "code": "12.5" }, { "name": "4.0 m (13 ft)", "code": "13" }, { "name": "4.1 m (13.5 ft)", "code": "13.5" }, { "name": "4.3 m (14 ft)", "code": "14" }, { "name": "4.4 m (14.5 ft)", "code": "14.5" }, { "name": "4.6 m (15 ft)", "code": "15" }, { "name": "4.7 m (15.5 ft)", "code": "15.5" }, { "name": "4.9 m (16 ft)", "code": "16" }, { "name": "5.0 m (16.5)", "code": "16.5" }, { "name": "5.2 m (17 ft)", "code": "17" }, { "name": "5.3 m (17.5 ft)", "code": "17.5" }, { "name": "5.5 m (18 ft)", "code": "18" }, { "name": "5.6 m (18.5 ft)", "code": "18.5" }, { "name": "5.8 m (19 ft)", "code": "19" }, { "name": "5.9 m (19.5 ft)", "code": "19.5" }, { "name": "6.1 m (20 ft)", "code": "20" }, { "name": "6.2 m (20.5 ft)", "code": "20.5" }, { "name": "6.4 m (21 ft)", "code": "21" }, { "name": "6.6 m (21.5 ft)", "code": "21.5" }, { "name": "6.7 m (22 ft)", "code": "22" }, { "name": "6.9 m (22.5 ft)", "code": "22.5" }, { "name": "7.0 m (23 ft)", "code": "23" }, { "name": "7.2 m (23.5 ft)", "code": "23.5" }, { "name": "7.3 m (24 ft)", "code": "24" }, { "name": "7.5 m (24.5 ft)", "code": "24.5" }, { "name": "7.8 m (25.5 ft)", "code": "25.5" }, { "name": "7.9 m (26 ft)", "code": "26" }, { "name": "8.1 m (26.5 ft)", "code": "26.5" }, { "name": "8.2 m (27 ft)", "code": "27" }, { "name": "8.5 m (28 ft)", "code": "28" }, { "name": "8.7 m (28.5 ft)", "code": "28.5" }, { "name": "8.4 m (8.4 ft)", "code": "27.5" }, { "name": "7.6 m (25 ft)", "code": "25" }, { "name": "8.8 m (29 ft)", "code": "29" }, { "name": "9.0 m (29.5 ft)", "code": "29.5" }, { "name": "9.1 m (30 ft)", "code": "30" }, { "name": "9.3 m (30.5 ft)", "code": "30.5" }, { "name": "9.4 m (31 ft)", "code": "31" }, { "name": "9.6 m (31.5 ft)", "code": "31.5" }, { "name": "9.8 m (32 ft)", "code": "32" }, { "name": "9.9 m (32.5 ft)", "code": "32.5" }, { "name": "10.1 m (33 ft)", "code": "33" }, { "name": "10.2 m (33.5 ft)", "code": "33.5" }, { "name": "10.4 m (34 ft)", "code": "34" }, { "name": "10.5 m (34.5 ft)", "code": "34.5" }, { "name": "10.7 m (35 ft)", "code": "35" }, { "name": "10.8 m (35.5 ft)", "code": "35.5" }, { "name": "11.0 m (36 ft)", "code": "36" }, { "name": "11.1 m (36.5 ft)", "code": "36.5" }, { "name": "11.3 m (37 ft)", "code": "37" }, { "name": "11.4 m (37.5 ft)", "code": "37.5" }, { "name": "11.6 m (38 ft)", "code": "38" }, { "name": "11.7 m (38.5 ft)", "code": "38.5" }, { "name": "11.9 m (39 ft)", "code": "39" }, { "name": "12.0 m (39.5 ft)", "code": "39.5" }, { "name": "12.2 m (40 ft)", "code": "40" }, { "name": "12.3 m (40.5 ft)", "code": "40.5" }, { "name": "12.5 m (41 ft)", "code": "41" }, { "name": "12.6 m (41.5 ft)", "code": "41.5" }, { "name": "12.8 m (42 ft)", "code": "42" }, { "name": "13.0 m (42.5 ft)", "code": "42.5" }, { "name": "13.1 m (43 ft)", "code": "43" }, { "name": "13.3 m (43.5 ft)", "code": "43.5" }, { "name": "13.4 m (44 ft)", "code": "44" }, { "name": "13.6 m (44.5 ft)", "code": "44.5" }, { "name": "13.7 m (45 ft)", "code": "45" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ModelName", "type": "esriFieldTypeString", "alias": "Model Name", "length": 50, "domain": { "type": "codedValue", "name": "FixtureModelName", "description": "Fixture Model Name", "codedValues": [ { "name": "Autobahn ATB0", "code": "Autobahn ATB0\nAutobahn ATB0\nAutobahn ATB0" }, { "name": "Autobahn ATB1", "code": "Autobahn ATB1" }, { "name": "Autobahn ATB2", "code": "Autobahn ATB2" }, { "name": "Evolve ERS1", "code": "Evolve ERS1" }, { "name": "Evolve ERS2", "code": "Evolve ERS2" }, { "name": "Evolve ERS3", "code": "Evolve ERS3" }, { "name": "Evolve ERS4", "code": "Evolve ERS4" }, { "name": "LEDgend", "code": "LEDgend" }, { "name": "LEDway", "code": "LEDway" }, { "name": "NXT", "code": "NXT" }, { "name": "OVH", "code": "OVH" }, { "name": "Roadstar", "code": "Roadstar" }, { "name": "Roadview", "code": "Roadview" }, { "name": "Satellite", "code": "Satellite" }, { "name": "Streetworks", "code": "Streetworks" }, { "name": "TunnelPass LED", "code": "TunnelPass LED" }, { "name": "USSL", "code": "USSL" }, { "name": "Verdeon", "code": "Verdeon" }, { "name": "XSP", "code": "XSP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": { "type": "codedValue", "name": "FixtureModelNumber", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "DistributionType", "type": "esriFieldTypeString", "alias": "Distribution Type", "length": 50, "domain": { "type": "codedValue", "name": "FixtureDistributionType", "description": "Fixture Distribution Type", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CatalogNumber", "type": "esriFieldTypeString", "alias": "Catalog Number", "length": 50, "domain": { "type": "codedValue", "name": "FixtureCatalogueNumber", "description": "Fixture Catalog Number", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Voltage", "type": "esriFieldTypeInteger", "alias": "Voltage", "domain": { "type": "codedValue", "name": "StreetLighting_Voltage", "description": "Street Lighting - Voltage", "codedValues": [ { "name": "120 volts", "code": 120 }, { "name": "240 volts", "code": 240 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wattage", "type": "esriFieldTypeString", "alias": "Wattage", "length": 5, "domain": { "type": "codedValue", "name": "StreetLighting_Wattage", "description": "Street Lighting - Wattage", "codedValues": [ { "name": "100 watts", "code": "100" }, { "name": "101 watts", "code": "101" }, { "name": "103 Watts", "code": "103" }, { "name": "104 Watts", "code": "104" }, { "name": "105 Watts", "code": "105" }, { "name": "110 watts", "code": "110" }, { "name": "111 Watts", "code": "111" }, { "name": "112 watts", "code": "112" }, { "name": "120 Watts", "code": "120" }, { "name": "126 Watts", "code": "126" }, { "name": "130 watts", "code": "130" }, { "name": "132 Watts", "code": "132" }, { "name": "133 Watts", "code": "133" }, { "name": "134 watts", "code": "134" }, { "name": "138 Watts", "code": "138" }, { "name": "139 Watts", "code": "139" }, { "name": "140 watts", "code": "140" }, { "name": "143 Watts", "code": "143" }, { "name": "145 watts", "code": "145" }, { "name": "148 Watts", "code": "148" }, { "name": "15 Watts", "code": "15" }, { "name": "150 watts", "code": "150" }, { "name": "153 watts", "code": "153" }, { "name": "155 Watts", "code": "155" }, { "name": "156 Watts", "code": "156" }, { "name": "16 Watts", "code": "16" }, { "name": "160 watts", "code": "160" }, { "name": "165 Watts", "code": "165" }, { "name": "168 watts", "code": "168" }, { "name": "170 Watts", "code": "170" }, { "name": "174 Watts", "code": "174" }, { "name": "175 watts", "code": "175" }, { "name": "177 Watts", "code": "177" }, { "name": "178 Watts", "code": "178" }, { "name": "18 Watts", "code": "18" }, { "name": "180 watts", "code": "180" }, { "name": "182 Watts", "code": "182" }, { "name": "183 Watts", "code": "183" }, { "name": "185 watts", "code": "185" }, { "name": "197 Watts", "code": "197" }, { "name": "199 Watts", "code": "199" }, { "name": "200 watts", "code": "200" }, { "name": "204 Watts", "code": "204" }, { "name": "213 Watts", "code": "213" }, { "name": "215 watts", "code": "215" }, { "name": "230 Watts", "code": "230" }, { "name": "24 Watts", "code": "24" }, { "name": "244 Watts", "code": "244" }, { "name": "25 Watts", "code": "25" }, { "name": "250 watts", "code": "250" }, { "name": "252 watts", "code": "252" }, { "name": "26 Watts", "code": "26" }, { "name": "268 Watts", "code": "268" }, { "name": "275 Watts", "code": "275" }, { "name": "276 watts", "code": "276" }, { "name": "28 Watts", "code": "28" }, { "name": "280 Watts", "code": "280" }, { "name": "284 watts", "code": "284" }, { "name": "307 Watts", "code": "307" }, { "name": "32 Watts", "code": "32" }, { "name": "35 Watts", "code": "35" }, { "name": "36 Watts", "code": "36" }, { "name": "40 Watts", "code": "40" }, { "name": "400 watts", "code": "400" }, { "name": "43 watts", "code": "43" }, { "name": "45 Watts", "code": "45" }, { "name": "47 Watts", "code": "47" }, { "name": "48 Watts", "code": "48" }, { "name": "50 Watts", "code": "50" }, { "name": "51 Watts", "code": "51" }, { "name": "52 Watts", "code": "52" }, { "name": "53 watts", "code": "53" }, { "name": "54 Watts", "code": "54" }, { "name": "55 Watts", "code": "55" }, { "name": "56 Watts", "code": "56" }, { "name": "57 Watts", "code": "57" }, { "name": "59 Watts", "code": "59" }, { "name": "60 Watts", "code": "60" }, { "name": "65 watts", "code": "65" }, { "name": "67 Watts", "code": "67" }, { "name": "68 Watts", "code": "68" }, { "name": "69 Watts", "code": "69" }, { "name": "70 watts", "code": "70" }, { "name": "71 Watts", "code": "71" }, { "name": "72 Watts", "code": "72" }, { "name": "73 watts", "code": "73" }, { "name": "75 Watts", "code": "75" }, { "name": "77 Watts", "code": "77" }, { "name": "78 Watts", "code": "78" }, { "name": "79 Watts", "code": "79" }, { "name": "80 Watts", "code": "80" }, { "name": "83 watts", "code": "83" }, { "name": "84 Watts", "code": "84" }, { "name": "85 Watts", "code": "85" }, { "name": "87 watts", "code": "87" }, { "name": "88 Watts", "code": "88" }, { "name": "90 watts", "code": "90" }, { "name": "91 watts", "code": "91" }, { "name": "92 Watts", "code": "92" }, { "name": "95 Watts", "code": "95" }, { "name": "N/A", "code": "N/A" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UKN" }, { "name": "66 Watts", "code": "66" }, { "name": "44 Watts", "code": "44" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 1073741822, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "FixtureManufacturer", "description": "Fixture Manufacturer", "codedValues": [ { "name": "American Electric Lighting", "code": "American Electric Lighting" }, { "name": "Cooper Lighting", "code": "Cooper Lighting" }, { "name": "Cree", "code": "Cree" }, { "name": "Eaton/Cooper", "code": "Eaton/Cooper" }, { "name": "GE Lighting Solutions", "code": "GE Lighting Solutions" }, { "name": "Holophane", "code": "Holophane" }, { "name": "LED Roadway Lighting", "code": "LED Roadway Lighting" }, { "name": "Lithonia", "code": "Lithonia" }, { "name": "Philips Lumec", "code": "Philips Lumec" }, { "name": "Quattro", "code": "Quattro" }, { "name": "RUDD", "code": "RUDD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CorrelatedColourTemperature", "type": "esriFieldTypeSmallInteger", "alias": "CorrelatedColourTemperature", "domain": { "type": "codedValue", "name": "CCT", "description": "Correlated Colour Temperature Specification", "codedValues": [ { "name": "3000 K", "code": 3000 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LampBase", "type": "esriFieldTypeString", "alias": "Lamp Base", "length": 255, "domain": { "type": "codedValue", "name": "StreetLighting_LampBase", "description": "Street Lighting - Lamp Base", "codedValues": [ { "name": "Mogul", "code": "Mogul" }, { "name": "Medium", "code": "Medium" }, { "name": "Long", "code": "Long" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R1474_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1859GIS_ID", "fields": "GIS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "StreetLight Features", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "GIS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{29609916-B90D-40B8-958D-9FC6E0CC190C}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }