{ "currentVersion": 10.71, "id": 39, "name": "Poles_LightTable", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "St_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PKLT_FACILITYID", "type": "esriFieldTypeString", "alias": "Light FacilityID", "length": 255, "domain": null }, { "name": "POLE_FACILITYID", "type": "esriFieldTypeString", "alias": "Pole FacilityID", "length": 255, "domain": null }, { "name": "Badge_Num", "type": "esriFieldTypeString", "alias": "Badge_Num", "length": 255, "domain": null }, { "name": "LIGHTTYPE", "type": "esriFieldTypeString", "alias": "Light Fixture Type", "length": 50, "domain": { "type": "codedValue", "name": "LightType", "description": "The type of fixture", "codedValues": [ { "name": "RFS Cobra", "code": "RFS Cobra" }, { "name": "RFM Cobra", "code": "RFM Cobra" }, { "name": "RFL Cobra", "code": "RFL Cobra" }, { "name": "Acorn", "code": "Acorn" }, { "name": "Square", "code": "Square" }, { "name": "Esplanade Bracket", "code": "Esplanade Bracket" }, { "name": "Incandescent Globe", "code": "Incandescent Globe" }, { "name": "Pendant", "code": "Pendant" }, { "name": "Rectilinear", "code": "Rectilinear" }, { "name": "Whatley", "code": "Whatley" }, { "name": "Colonial", "code": "Colonial" }, { "name": "Cut-Off Flat Glass", "code": "Cut-Off Flat Glass" }, { "name": "Other (leave comment)", "code": "OTHER" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BULBTYPE", "type": "esriFieldTypeString", "alias": "Bulb Type", "length": 255, "domain": { "type": "codedValue", "name": "BulbType", "description": "The type of bulb in fixture", "codedValues": [ { "name": "LED", "code": "LED" }, { "name": "Fluroscent", "code": "Fluroscent" }, { "name": "High Pressure Sodium", "code": "HPS" }, { "name": "240V High Pressure Sodium", "code": "240VHPS" }, { "name": "Incandescent", "code": "Incandescent" }, { "name": "Low Pressure Sodium", "code": "LPS" }, { "name": "Metal Halide", "code": "Metal Halide" }, { "name": "Other (leave comment)", "code": "OTHER" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATTAGE", "type": "esriFieldTypeString", "alias": "Wattage", "length": 3, "domain": null }, { "name": "OWNBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned_By", "domain": { "type": "codedValue", "name": "OwnedBy_1", "description": "Who owns the asset", "codedValues": [ { "name": "City", "code": 1 }, { "name": "Tentative", "code": 0 }, { "name": "Private", "code": -1 }, { "name": "County", "code": -2 }, { "name": "Marin", "code": -3 }, { "name": "State", "code": -4 }, { "name": "Unknown", "code": -5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Maint_By", "domain": { "type": "codedValue", "name": "MaintBy_1", "description": "Who maintains the asset", "codedValues": [ { "name": "City", "code": 1 }, { "name": "Tentative", "code": 0 }, { "name": "Private", "code": -1 }, { "name": "County", "code": -2 }, { "name": "Marin", "code": -3 }, { "name": "State", "code": -4 }, { "name": "Unknown", "code": -5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINT_DIV", "type": "esriFieldTypeSmallInteger", "alias": "City Maint. Division", "domain": { "type": "codedValue", "name": "MaintDiv", "description": "Internal division responsible for maintenance", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Traffic", "code": 1 }, { "name": "Parks", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Light Fixture Condition", "domain": { "type": "codedValue", "name": "Condition_1", "description": "Condition", "codedValues": [ { "name": "Excellent", "code": 5 }, { "name": "Good", "code": 4 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 2 }, { "name": "Critical/Bad", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHIELD", "type": "esriFieldTypeSmallInteger", "alias": "Shield", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No boolean domain", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Retrofit_Date", "type": "esriFieldTypeDate", "alias": "Retrofit Date", "length": 8, "domain": null }, { "name": "PGE_METERNUM", "type": "esriFieldTypeString", "alias": "PGE_METER_NUM", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "G90POLE_FACILITY", "fields": "POLE_FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PGIS.GISEDITOR.PK_ASSETS_POLES_Working", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "POLE_FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }