{ "currentVersion": 10.91, "id": 1, "name": "PWE_GDB.ADM.Traffic_Light_Fixture_Information", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "LightFixtures", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Pole_ID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Old_AF_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "AF_ID", "type": "esriFieldTypeInteger", "alias": "AF_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AF_ID" }, { "name": "Old_AF_ID", "type": "esriFieldTypeString", "alias": "Old_AF_ID", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Old_AF_ID" }, { "name": "Pole_ID", "type": "esriFieldTypeInteger", "alias": "Pole_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pole_ID" }, { "name": "POLENO", "type": "esriFieldTypeString", "alias": "POLENO", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "POLENO" }, { "name": "EWEB_NO", "type": "esriFieldTypeString", "alias": "EWEB_NO", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "EWEB_NO" }, { "name": "Arm_Number", "type": "esriFieldTypeInteger", "alias": "Arm_Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Arm_Number" }, { "name": "Arm_Length", "type": "esriFieldTypeSmallInteger", "alias": "Arm_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Arm_Length" }, { "name": "Tennon_Diameter", "type": "esriFieldTypeSingle", "alias": "Tennon_Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Tennon_Diameter" }, { "name": "Mounting_Height", "type": "esriFieldTypeDouble", "alias": "Mounting_Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mounting_Height" }, { "name": "Orientation", "type": "esriFieldTypeString", "alias": "Orientation", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Orientation" }, { "name": "Angle", "type": "esriFieldTypeInteger", "alias": "Angle", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Angle" }, { "name": "Wattage", "type": "esriFieldTypeInteger", "alias": "Wattage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Wattage" }, { "name": "Voltage", "type": "esriFieldTypeInteger", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Voltage" }, { "name": "Fixture_Type", "type": "esriFieldTypeString", "alias": "Fixture_Type", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Fixture_Type" }, { "name": "Fix_Number", "type": "esriFieldTypeInteger", "alias": "Fix_Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fix_Number" }, { "name": "Lighting_Pattern", "type": "esriFieldTypeString", "alias": "Lighting_Pattern", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Lighting_Pattern" }, { "name": "Type_Lens", "type": "esriFieldTypeString", "alias": "Type_Lens", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Type_Lens" }, { "name": "PEC", "type": "esriFieldTypeSmallInteger", "alias": "PEC", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PEC" }, { "name": "PEC_CIR", "type": "esriFieldTypeString", "alias": "PEC_CIR", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "PEC_CIR" }, { "name": "Shorting_Cap", "type": "esriFieldTypeSmallInteger", "alias": "Shorting_Cap", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shorting_Cap" }, { "name": "Plug", "type": "esriFieldTypeSmallInteger", "alias": "Plug", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Plug" }, { "name": "Shield", "type": "esriFieldTypeSmallInteger", "alias": "Shield", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shield" }, { "name": "Painted", "type": "esriFieldTypeSmallInteger", "alias": "Painted", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Painted" }, { "name": "Fixture_Installed", "type": "esriFieldTypeDate", "alias": "Fixture_Installed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Fixture_Installed" }, { "name": "FixtureType", "type": "esriFieldTypeString", "alias": "FixtureType", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FixtureType" }, { "name": "Record_Status", "type": "esriFieldTypeString", "alias": "Record_Status", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Record_Status" }, { "name": "Date_Inspected", "type": "esriFieldTypeDate", "alias": "Date_Inspected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Inspected" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "Manufacture" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Notes" }, { "name": "Installed_By", "type": "esriFieldTypeString", "alias": "Installed_By", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "Installed_By" }, { "name": "Installed_Date", "type": "esriFieldTypeDate", "alias": "Installed_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Installed_Date" }, { "name": "Supervisor_Status", "type": "esriFieldTypeString", "alias": "Supervisor_Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Supervisor_Status" }, { "name": "Ornamental", "type": "esriFieldTypeSmallInteger", "alias": "Ornamental", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Ornamental" }, { "name": "Record_Created", "type": "esriFieldTypeDate", "alias": "Record_Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Record_Created" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "PK__TRAFFIC___F4B70D857CB2FCFE", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3242_Pole_ID", "fields": "Pole_ID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "PWE_GDB.ADM.Traffic_Light_Fixture_Information", "description": "", "prototype": { "attributes": { "Record_Created": null, "AF_ID": null, "Old_AF_ID": null, "Pole_ID": null, "POLENO": null, "EWEB_NO": null, "Arm_Number": null, "Arm_Length": null, "Tennon_Diameter": null, "Mounting_Height": null, "Orientation": null, "Angle": null, "Wattage": null, "Voltage": null, "Fixture_Type": null, "Fix_Number": null, "Lighting_Pattern": null, "Type_Lens": null, "PEC": null, "PEC_CIR": null, "Shorting_Cap": null, "Plug": null, "Shield": null, "Painted": null, "Fixture_Installed": null, "FixtureType": null, "Record_Status": null, "Date_Inspected": null, "Manufacture": null, "Notes": null, "Installed_By": null, "Installed_Date": null, "Supervisor_Status": null, "Ornamental": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 5000, "maxRecordCountFactor": 1 }