{ "currentVersion": 10.81, "id": 28, "name": "Fixture", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Status", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PoleID", "type": "esriFieldTypeInteger", "alias": "Pole ID", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 1, "domain": { "type": "codedValue", "name": "LightingAssetStatus", "description": "Possible Street Light Status Values", "codedValues": [ { "name": "Existing", "code": "E" }, { "name": "Future", "code": "F" }, { "name": "Unknown", "code": "U" }, { "name": "Historic", "code": "H" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "Type", "type": "esriFieldTypeSmallInteger", "alias": "Type", "domain": { "type": "codedValue", "name": "LightingFixtureType", "description": "Fixture Styles", "codedValues": [ { "name": "Roadway", "code": 0 }, { "name": "Pedestrian", "code": 1 }, { "name": "Crosswalk", "code": 2 }, { "name": "Street Sign", "code": 3 }, { "name": "Other", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Style", "type": "esriFieldTypeString", "alias": "Style", "length": 3, "domain": { "type": "codedValue", "name": "LightingFixtureStyle", "description": "Fixture Styles", "codedValues": [ { "name": "Cobra Flat", "code": "CF" }, { "name": "Cobra Round", "code": "CR" }, { "name": "Post Top", "code": "PT" }, { "name": "Top Hat", "code": "TH" }, { "name": "Domus", "code": "DO" }, { "name": "Shoebox", "code": "SB" }, { "name": "Coach", "code": "CO" }, { "name": "Pendant", "code": "PE" }, { "name": "Other", "code": "OT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Brand", "type": "esriFieldTypeString", "alias": "Brand", "length": 32, "domain": { "type": "codedValue", "name": "LightingFixtureBrand", "description": "Valid Light Fixture Brands", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "GE", "code": "GE" }, { "name": "Phillips", "code": "Phillips" }, { "name": "AEL", "code": "AEL" }, { "name": "Holophane", "code": "Holophane" }, { "name": "Cooper", "code": "Cooper" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 64, "domain": null }, { "name": "BulbType", "type": "esriFieldTypeString", "alias": "Bulb Type", "length": 3, "domain": { "type": "codedValue", "name": "LightingFixtureBulbType", "description": "Available Bulb Types", "codedValues": [ { "name": "High Pressure Sodium", "code": "HPS" }, { "name": "Metal Halide", "code": "MH" }, { "name": "LED", "code": "LED" }, { "name": "Mercury Vapor ", "code": "MV" }, { "name": "Fluorescent", "code": "FLS" }, { "name": "Unknown", "code": "UKN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Wattage", "type": "esriFieldTypeSmallInteger", "alias": "Wattage", "domain": null }, { "name": "Height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null }, { "name": "LightDistributionType", "type": "esriFieldTypeSmallInteger", "alias": "Light Distribution Type", "domain": { "type": "codedValue", "name": "LightingLightDistributionType", "description": "Valid Light Distribution Types", "codedValues": [ { "name": "I", "code": 1 }, { "name": "II", "code": 2 }, { "name": "III", "code": 3 }, { "name": "IV", "code": 4 }, { "name": "V", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WarranteePeriod", "type": "esriFieldTypeSmallInteger", "alias": "Warrantee Period (Years)", "domain": null }, { "name": "FixtureSpecifications", "type": "esriFieldTypeString", "alias": "Fixture Specifications", "length": 128, "domain": null }, { "name": "IESFile", "type": "esriFieldTypeString", "alias": "IES File", "length": 128, "domain": null }, { "name": "GeneralComment", "type": "esriFieldTypeString", "alias": "General Comment", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "HistoricFixtureID", "type": "esriFieldTypeGUID", "alias": "Historic Fixture ID", "length": 38, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeDate", "alias": "Replacement Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R688_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2115PoleID", "fields": "PoleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_688", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Pole", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "PoleID", "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 }