{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "Sewer_LiftStations", "type": "Feature Layer", "description": "This point feature class is a collection of lift stations found in the City of Kilgore's sanitary sewer system. Lift stations pump wastewater to higher elevations in the sewer system.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": null, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "8d26e3fbe9a2c58e4ca7135be2b19c2a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABwAAAAUCAYAAACeXl35AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAWdJREFUSIm91L8rRWEcx/H3V1eHSd0syODuFmUxmZRBLDxKJmHjf7Ao3UwUA6WUc64UKeVHMVhtMlG2u92ruMM3OV8D13UR53KOz/Scp+f7fT09Pc9J8c9J/bbQ/HSXSWlE0BVx3MYOWsAIkHn7ppARmASmLfBGxelhrKA4clUb8Fs6qctf8ciajOl91D5voAWcRS16SR4MSDFkwc+rxdFbBQJp6uipDY0Y8y5A+QiGMsxDIl6AlcfRL02Ofu44kimeAGybdjNvRkxvcKwKlabfJTpoDEojp/AKhiwIrBterwTqcPixgl8kFKfHtss5Sl/Uor+ABcuxg3rL4nQvcVDSzFJgAHTOApo/vtNYQfOpp4gTx6b5HJiwBEmA9bTZFopSpIFx2+aEkDR4pfI7iw0UuEbYQIAGFsGbJ9R9oCChTkTtU8u/NAtkKzMK0B21vmYwrrwHOyzgMhlGWz+B4mhKBqvOvx/pM7Tadygwz/62AAAAAElFTkSuQmCC", "contentType": "image/png", "width": 21, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3075497.3240585476, "ymin": 6838275.039106995, "xmax": 3102593.429546237, "ymax": 6861997.512092814, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": "LIFTSTATIONTYPECODE", "subtypeFieldName": "LIFTSTATIONTYPECODE", "subtypeField": "LIFTSTATIONTYPECODE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "X_NAD83", "type": "esriFieldTypeDouble", "alias": "X_NAD83", "domain": null }, { "name": "Y_NAD83", "type": "esriFieldTypeDouble", "alias": "Y_NAD83", "domain": null }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null }, { "name": "NUMBEROFPUMPS", "type": "esriFieldTypeInteger", "alias": "Number Of Pumps", "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "NAME", "length": 200, "domain": null }, { "name": "LIFTSTATIONTYPECODE", "type": "esriFieldTypeInteger", "alias": "LIFTSTATIONTYPECODE", "domain": null }, { "name": "WETWELLINVERTELEVATION", "type": "esriFieldTypeDouble", "alias": "Wet Well Invert Elevation", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "DIAMETER", "domain": null }, { "name": "INCOMINGINVERTELEVATION1", "type": "esriFieldTypeDouble", "alias": "Incoming Invert Elevation 1", "domain": null }, { "name": "INCOMINGINVERTELEVATION2", "type": "esriFieldTypeDouble", "alias": "Incoming Invert Elevation 2", "domain": null }, { "name": "WETWELLSHAPE", "type": "esriFieldTypeString", "alias": "Wet Well Shape", "length": 50, "domain": { "type": "codedValue", "name": "Sewer_WellShape", "description": "", "codedValues": [ { "name": "Circular", "code": "Cir" }, { "name": "Rectangular", "code": "Rec" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WIDTH", "type": "esriFieldTypeDouble", "alias": "WIDTH", "domain": null }, { "name": "HEIGHT", "type": "esriFieldTypeDouble", "alias": "HEIGHT", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "DEPTH", "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 25, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12614_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12614", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42557ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12614", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9886_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": {}, "id": 1, "name": "Liftstation" } ], "subtypes": [ { "domains": {}, "defaultValues": { "ASSETID": null, "X_NAD83": null, "Y_NAD83": null, "ELEVATION": null, "NUMBEROFPUMPS": null, "ADDRESS": null, "LIFTSTATIONTYPECODE": null, "WETWELLINVERTELEVATION": null, "DIAMETER": null, "INCOMINGINVERTELEVATION1": null, "INCOMINGINVERTELEVATION2": null, "WETWELLSHAPE": null, "WIDTH": null, "HEIGHT": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "GlobalID": null, "LENGTH": null, "DEPTH": null, "TYPE": null }, "code": 1, "name": "Liftstation" } ], "relationships": [ { "id": 0, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "wwHoist", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "wwFence", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "wwSCADA", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "Kilgore.DBO.wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 1, "name": "Water", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 2, "name": "Water Tanks and Towers" } ], "minScale": 1000000, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 3035475.79456684, "ymin": 6823032.379203379, "xmax": 3116032.778321862, "ymax": 6872431.005297378, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 2, "name": "Water Tanks and Towers", "type": "Feature Layer", "description": "Contains water tank point locations.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 1, "name": "Water" }, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "f1d568eed32c176ab523387aa16e88ec", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAadJREFUKJGV008o5GEcx/H38Bu/7OxM/Gytn/awQiM0GcVBmVKzTTbZKfkT5eBAIX/KSf5k2/bkwJbl6OKw68QJxbYXm5K2diX5L8xBnvxr7EOMw4+a/fn/uT2fntfT863nUbg7Fl3X04QQus1mOxJC/AFOzZsU01qluL6ObN87keJKlPbYWCmDJ2wubalzP+fkUFcfsHMX1mj9OkhhdSFWNVretDbHa7T4JOn25JOZ69a+97SLmYnZcGyhqW8Af20Jloj7JoFsr1dERkQxM1EB7Bi4uKGSgqr398OwZOV7aOxt40tzvYHdHj/2mJePy+sbpOfkAdEG1uKTnwav8yYlVXM6XQaOVOzPwlGqVbi8uoHPzoPPwsHjS315cdXAh3trQMaT8fbqSuD39F8FQD0Q/XJ33UdCovooPJcQ2JgCQgqA7KmZpHN4lJhXpbx4YPzQJfwaX+BTVQuEv7CPleV0f1NJyyki4a3lFjw5hPkfC/zb8wHyfwwhusr8+ufRksDmYguOOCdWq4OLi1OCR+vqwf6Y7CztCD/P/DEItH0YAUbMvTQXwBXljH5+fXAuqgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3035475.79456684, "ymin": 6823032.379203379, "xmax": 3116032.778321862, "ymax": 6872431.005297378, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 100, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeInteger", "alias": "TYPE", "domain": { "type": "codedValue", "name": "WaterTankType", "description": "", "codedValues": [ { "name": "ELEVATED TANK", "code": 1 }, { "name": "GROUND STORAGE TANK", "code": 2 }, { "name": "UNKNOWN", "code": 3 }, { "name": "0", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CAPACITY", "type": "esriFieldTypeInteger", "alias": "CAPACITY", "domain": null }, { "name": "GROUND_ELEVATION", "type": "esriFieldTypeDouble", "alias": "GROUND ELEVATION", "domain": null }, { "name": "LINKED_IMAGES", "type": "esriFieldTypeString", "alias": "LINKED IMAGES", "length": 100, "domain": null }, { "name": "MAINTENANCE_NUMBER", "type": "esriFieldTypeString", "alias": "MAINTENANCE NUMBER", "length": 15, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 40, "domain": null }, { "name": "COATING", "type": "esriFieldTypeString", "alias": "COATING", "length": 40, "domain": null }, { "name": "HATCHES", "type": "esriFieldTypeString", "alias": "HATCHES", "length": 40, "domain": null }, { "name": "VENTS", "type": "esriFieldTypeString", "alias": "VENTS", "length": 40, "domain": null }, { "name": "LADDERS", "type": "esriFieldTypeString", "alias": "LADDERS", "length": 40, "domain": null }, { "name": "OVERFLOW_ELEVATION", "type": "esriFieldTypeString", "alias": "OVERFLOW ELEVATION", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN_KEY", "length": 20, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12656_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12656", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12656", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9928_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 3, "name": "Water Production", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 4, "name": "wpBuilding" }, { "id": 5, "name": "wpFence" }, { "id": 6, "name": "wpGroundwater" }, { "id": 7, "name": "wpPiping" }, { "id": 8, "name": "wpGenerator" }, { "id": 9, "name": "wpLiftStation" }, { "id": 10, "name": "wpMotor_Control_Center" }, { "id": 11, "name": "wpPlant" }, { "id": 12, "name": "wpReservoir" }, { "id": 13, "name": "wpTank_Basin" }, { "id": 14, "name": "wpTank_Tower" }, { "id": 15, "name": "wpVault" } ], "minScale": 1000000, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 3030867.328066364, "ymin": 6811723.685509518, "xmax": 3116160.814959362, "ymax": 6872536.639014602, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 4, "name": "wpBuilding", "type": "Feature Layer", "description": "Contains building footprint polygons of buildings used by the Longview water treatment plants.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 218, 186, 245, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3035416.219887197, "ymin": 6822895.339675352, "xmax": 3116006.589546025, "ymax": 6872492.351701602, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "CONSTRUCTION", "type": "esriFieldTypeString", "alias": "CONSTRUCTION", "length": 50, "domain": null }, { "name": "KilgoreGIS.SDE.wpBuilding.AREA", "type": "esriFieldTypeString", "alias": "AREA", "length": 50, "domain": null }, { "name": "ROOF", "type": "esriFieldTypeString", "alias": "ROOF", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN_KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12672_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12672", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42619ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42619FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12672", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9944_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "wpAir_Handling", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "wpChemical_Pump", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "wpElectrical", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "wpChlorinator", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "wpGate", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 16, "name": "wpHoist", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "wpHVAC", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 18, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 19, "name": "wpGenerator", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "wpSCADA", "relatedTableId": 43, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 21, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "wpMotorControlCenter", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 24, "name": "wpSafetyFeature", "relatedTableId": 42, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 25, "name": "wpEquipment", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 26, "name": "wprGenerator", "relatedTableId": 39, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 27, "name": "Kilgore.DBO.wpFence", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 28, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 5, "name": "wpFence", "type": "Feature Layer", "description": "Contains fence linework.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 156, 156, 156, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3032715.83880502, "ymin": 6815968.661927685, "xmax": 3099161.800072938, "ymax": 6852606.007616103, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "HEIGHT", "type": "esriFieldTypeString", "alias": "HEIGHT", "length": 10, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 25, "domain": null }, { "name": "SECURITY", "type": "esriFieldTypeString", "alias": "SECURITY", "length": 30, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALL DATE", "length": 8, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12673_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12673", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42620FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12673", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9945_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 27, "name": "Kilgore.DBO.wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 29, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 30, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 6, "name": "wpGroundwater", "type": "Feature Layer", "description": "Contains water well point locations.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 115, 223, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3030867.328066364, "ymin": 6811723.685509518, "xmax": 3040716.0646024495, "ymax": 6825378.067321435, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 25, "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeString", "alias": "LATITUDE", "length": 15, "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeString", "alias": "LONGITUDE", "length": 15, "domain": null }, { "name": "LABEL", "type": "esriFieldTypeString", "alias": "LABEL", "length": 5, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12675_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12675", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42622ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42622FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12675", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9947_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 7, "name": "wpPiping", "type": "Feature Layer", "description": "Contains pipeline linework of pipes in the water production facilities.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 133, 0, 11, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3115707.129515022, "ymin": 6872471.384551942, "xmax": 3115922.875474617, "ymax": 6872485.96063827, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "DIAMETER", "length": 15, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12678_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12678", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12678", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9950_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 8, "name": "wpGenerator", "type": "Feature Layer", "description": "Contains building footprint polygons of buildings used by the Longview water treatment plants.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 205, 205, 102, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3078719.5620861053, "ymin": 6849215.479292184, "xmax": 3097105.04664053, "ymax": 6851372.1846244335, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "FUEL_TYPE", "type": "esriFieldTypeString", "alias": "FUEL_TYPE", "length": 25, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN_KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12674_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12674", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42621FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12674", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9946_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 31, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 9, "name": "wpLiftStation", "type": "Feature Layer", "description": "Contains wastewater treatment plant lifstation polygons", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 201, 242, 208, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3096717.988031447, "ymin": 6851438.111329854, "xmax": 3096722.5080355257, "ymax": 6851442.777659103, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 30, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "LENGTH", "length": 20, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeString", "alias": "WIDTH", "length": 20, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "length": 20, "domain": null }, { "name": "DIAMTER", "type": "esriFieldTypeString", "alias": "DIAMTER", "length": 20, "domain": null }, { "name": "NUMBER_OF_PUMPS", "type": "esriFieldTypeString", "alias": "NUMBER_OF_PUMPS", "length": 20, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12676_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12676", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42623FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12676", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9948_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 32, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 10, "name": "wpMotor_Control_Center", "type": "Feature Layer", "description": "Contains building footprint polygons of buildings used by the Longview water treatment plants.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 205, 233, 247, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3096787.4383518547, "ymin": 6851452.490894273, "xmax": 3097090.02862595, "ymax": 6851563.310882598, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PANEL_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "PANEL_NAME", "type": "esriFieldTypeString", "alias": "PANEL NAME", "length": 40, "domain": null }, { "name": "NUMBER_OF_MOTORS", "type": "esriFieldTypeString", "alias": "NUMBER OF MOTORS", "length": 10, "domain": null }, { "name": "STARTER_MAKE", "type": "esriFieldTypeString", "alias": "STARTER MAKE", "length": 30, "domain": null }, { "name": "STARTER_MODEL", "type": "esriFieldTypeString", "alias": "STARTER MODEL", "length": 30, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 10, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN_KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12677_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12677", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42624FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12677", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9949_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 33, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 11, "name": "wpPlant", "type": "Feature Layer", "description": "Contains area boundaries of the water treatment facilities", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 197, 0, 255, 255 ], "width": 1.5 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3035326.542901188, "ymin": 6822834.500886261, "xmax": 3116160.814959362, "ymax": 6872536.639014602, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "STREET_ADDRESS", "type": "esriFieldTypeString", "alias": "STREET ADDRESS", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12679_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12679", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42626ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12679", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9951_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 28, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 30, "name": "wpFence", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 31, "name": "wpGenerator", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 32, "name": "wpLiftStation", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 33, "name": "wpMotor_Control_Center", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 34, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 35, "name": "wpReservoir", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 36, "name": "wpTank_Basin", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 37, "name": "Kilgore.DBO.wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 38, "name": "wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 12, "name": "wpReservoir", "type": "Feature Layer", "description": "Contains wastewater treatment plant building footprint polygons.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 198, 221, 247, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3095846.883802533, "ymin": 6851356.339511767, "xmax": 3115670.3894310296, "ymax": 6872434.4148095995, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 30, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "DIMENSIONS", "type": "esriFieldTypeString", "alias": "DIMENSIONS", "length": 40, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "SURFACE_AREA", "type": "esriFieldTypeString", "alias": "SURFACE AREA", "length": 25, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 35, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12680_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12680", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42627ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42627FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12680", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9952_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 39, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 35, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 13, "name": "wpTank_Basin", "type": "Feature Layer", "description": "Contains tank basin polygons.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 229, 235, 242, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 78, 78, 78, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3035400.5434093624, "ymin": 6823031.828247517, "xmax": 3095930.38101086, "ymax": 6851572.764931932, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 35, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 30, "domain": null }, { "name": "COATING", "type": "esriFieldTypeString", "alias": "COATING", "length": 30, "domain": null }, { "name": "HATCHES", "type": "esriFieldTypeString", "alias": "HATCHES", "length": 30, "domain": null }, { "name": "VENTS", "type": "esriFieldTypeString", "alias": "VENTS", "length": 30, "domain": null }, { "name": "LADDER", "type": "esriFieldTypeString", "alias": "LADDER", "length": 30, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "GROUND_ELEVATION", "type": "esriFieldTypeString", "alias": "GROUND ELEVATION", "length": 30, "domain": null }, { "name": "OVERFLOW_ELEVATION", "type": "esriFieldTypeString", "alias": "OVERFLOW ELEVATION", "length": 30, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12681_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12681", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42628ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42628FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12681", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9953_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 40, "name": "wpChemical_Pump", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 41, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 42, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 36, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 14, "name": "wpTank_Tower", "type": "Feature Layer", "description": "Contains tank and tower polygon features.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 208, 245, 220, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3035449.3408839405, "ymin": 6823037.837421849, "xmax": 3116065.7534696907, "ymax": 6872467.63948068, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 40, "domain": null }, { "name": "COATING", "type": "esriFieldTypeString", "alias": "COATING", "length": 40, "domain": null }, { "name": "HATCHES", "type": "esriFieldTypeString", "alias": "HATCHES", "length": 40, "domain": null }, { "name": "VENTS", "type": "esriFieldTypeString", "alias": "VENTS", "length": 40, "domain": null }, { "name": "LADDER", "type": "esriFieldTypeString", "alias": "LADDER", "length": 40, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 40, "domain": null }, { "name": "GROUND_ELEVATION", "type": "esriFieldTypeString", "alias": "GROUND ELEVATION", "length": 15, "domain": null }, { "name": "OVERFLOW_ELEVATION", "type": "esriFieldTypeString", "alias": "OVERFLOW_ELEVATION", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12683_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12683", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42630ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42630FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12683", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9955_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 29, "name": "Kilgore.DBO.wpFence", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 43, "name": "Kilgore.DBO.wprVault", "relatedTableId": 41, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 44, "name": "Kilgore.DBO.wpElectrical", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 45, "name": "Kilgore.DBO.wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 46, "name": "Kilgore.DBO.wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 47, "name": "Kilgore.DBO.wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 48, "name": "Kilgore.DBO.wpSCADA", "relatedTableId": 43, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 38, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 15, "name": "wpVault", "type": "Feature Layer", "description": "Contains building footprint polygons of buildings used by the Longview water treatment plants.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 3, "name": "Water Production" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3035395.2983411103, "ymin": 6823019.404059768, "xmax": 3097145.481270939, "ymax": 6851735.419462264, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "LENGTH", "length": 20, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeString", "alias": "WIDTH", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 20, "domain": null }, { "name": "HATCH", "type": "esriFieldTypeString", "alias": "HATCH", "length": 20, "domain": null }, { "name": "SUMP", "type": "esriFieldTypeString", "alias": "SUMP", "length": 20, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "DIAMETER", "length": 20, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12682_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12682", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42629ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42629FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12682", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9954_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 49, "name": "wpElectrical", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 50, "name": "wpHoist", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 51, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 52, "name": "wpMotor", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 53, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 54, "name": "wpMixer", "relatedTableId": 34, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 55, "name": "wpEquipment", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 56, "name": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 57, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 58, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 59, "name": "wpGate", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 60, "name": "wpChemical_Pump", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 61, "name": "wpAir_Handling", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 62, "name": "wpChlorinator", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 63, "name": "wpMotorControlCenter", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 34, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 16, "name": "WWTP", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 17, "name": "wwFence" }, { "id": 18, "name": "wwBuilding" }, { "id": 19, "name": "wwLiftStation" }, { "id": 20, "name": "wwPlant" }, { "id": 21, "name": "wwTank_Basin" }, { "id": 22, "name": "wwVault" } ], "minScale": 1000000, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 3075491.81460461, "ymin": 6838260.013014182, "xmax": 3102625.8348115236, "ymax": 6861964.732993096, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 17, "name": "wwFence", "type": "Feature Layer", "description": "Contains fence linework.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 16, "name": "WWTP" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 0, 0, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3075491.81460461, "ymin": 6841421.416468263, "xmax": 3102625.8348115236, "ymax": 6861964.732993096, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "HEIGHT", "type": "esriFieldTypeString", "alias": "HEIGHT", "length": 10, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 25, "domain": null }, { "name": "SECURITY", "type": "esriFieldTypeString", "alias": "SECURITY", "length": 30, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALL DATE", "length": 8, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12823_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12823", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42775FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12823", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S10095_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 64, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 65, "name": "wwPlant", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 18, "name": "wwBuilding", "type": "Feature Layer", "description": "Contains wastewater treatment plant building footprint polygons.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 16, "name": "WWTP" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 156, 156, 156, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 52, 52, 52, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3095099.34494327, "ymin": 6846655.794122845, "xmax": 3095681.0216014385, "ymax": 6847347.912489265, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 30, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "CONSTRUCTION", "type": "esriFieldTypeString", "alias": "CONSTRUCTION", "length": 50, "domain": null }, { "name": "KilgoreGIS.SDE.wwBuilding.AREA", "type": "esriFieldTypeString", "alias": "AREA", "length": 50, "domain": null }, { "name": "ROOF", "type": "esriFieldTypeString", "alias": "ROOF", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12822_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12822", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42774ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42774FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12822", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S10094_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 66, "name": "wwAir_Handling", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 67, "name": "wwHVAC", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 68, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 69, "name": "wwMotorControlCenter", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 70, "name": "wwHoist", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 71, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 72, "name": "wwChlorinator", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 73, "name": "wwSafetyFeature", "relatedTableId": 61, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 74, "name": "wwSCADA", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 75, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 76, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 77, "name": "wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 78, "name": "wwChemical_Pump", "relatedTableId": 46, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 79, "name": "wwEquipment", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 80, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 81, "name": "wwrLiftStation", "relatedTableId": 58, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 82, "name": "wwPlant", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 19, "name": "wwLiftStation", "type": "Feature Layer", "description": "Contains wastewater treatment plant lifstation polygons", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 16, "name": "WWTP" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 163, 255, 115, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3076452.7588769495, "ymin": 6838260.013014182, "xmax": 3102625.8348115236, "ymax": 6861964.732993096, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 30, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "LENGTH", "length": 20, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeString", "alias": "WIDTH", "length": 20, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "length": 20, "domain": null }, { "name": "DIAMTER", "type": "esriFieldTypeString", "alias": "DIAMTER", "length": 20, "domain": null }, { "name": "NUMBER_OF_PUMPS", "type": "esriFieldTypeString", "alias": "NUMBER_OF_PUMPS", "length": 20, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12824_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12824", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42776FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42776ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12824", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S10096_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 64, "name": "wwFence", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 83, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 84, "name": "wwEquipment", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 85, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 86, "name": "wwSCADA", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 87, "name": "wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 88, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 89, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 76, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 20, "name": "wwPlant", "type": "Feature Layer", "description": "Contains wastewater treatment plant boundaries", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 16, "name": "WWTP" }, "subLayers": [], "minScale": 1000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 132, 0, 168, 255 ], "width": 1.5 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3094793.9876143634, "ymin": 6846613.796831518, "xmax": 3095774.4561258554, "ymax": 6847431.505169854, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "STREET_ADDRESS", "type": "esriFieldTypeString", "alias": "STREET ADDRESS", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12825_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12825", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42777ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12825", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S10097_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 82, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 65, "name": "wwFence", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 90, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 91, "name": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 21, "name": "wwTank_Basin", "type": "Feature Layer", "description": "Contains tank basin polygons", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 16, "name": "WWTP" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 219, 229, 232, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 78, 78, 78, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3095385.816155106, "ymin": 6846885.526603013, "xmax": 3095751.352497533, "ymax": 6847292.880447105, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 30, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "capacity", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 20, "domain": null }, { "name": "COATING", "type": "esriFieldTypeString", "alias": "COATING", "length": 20, "domain": null }, { "name": "HATCHES", "type": "esriFieldTypeString", "alias": "HATCHES", "length": 20, "domain": null }, { "name": "VENTS", "type": "esriFieldTypeString", "alias": "VENTS", "length": 20, "domain": null }, { "name": "LADDER", "type": "esriFieldTypeString", "alias": "LADDER", "length": 20, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "GROUND_ELEVATION", "type": "esriFieldTypeString", "alias": "GROUND ELEVATION", "length": 20, "domain": null }, { "name": "OVERFLOW_ELEVATION", "type": "esriFieldTypeString", "alias": "OVERFLOW ELEVATION", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12826_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12826", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42778ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42778FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12826", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S10098_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 92, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 93, "name": "wwGate", "relatedTableId": 51, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 94, "name": "wwAir_Handling", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 95, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 96, "name": "wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 91, "name": "wwPlant", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 22, "name": "wwVault", "type": "Feature Layer", "description": "Contains building footprint polygons of buildings used by the Longview water treatment plants.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Kilgore.", "parentLayer": { "id": 16, "name": "WWTP" }, "subLayers": [], "minScale": 10000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 115, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3095019.2312583625, "ymin": 6846872.3205926865, "xmax": 3095647.4622853547, "ymax": 6847293.817453101, "spatialReference": { "wkid": 102738, "latestWkid": 2276 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "LENGTH", "length": 20, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeString", "alias": "WIDTH", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 20, "domain": null }, { "name": "HATCH", "type": "esriFieldTypeString", "alias": "HATCH", "length": 20, "domain": null }, { "name": "SUMP", "type": "esriFieldTypeString", "alias": "SUMP", "length": 20, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "DIAMETER", "length": 20, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R12827_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12827", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42779ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42779FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12827", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S10099_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 97, "name": "wwEquipment", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 98, "name": "wwHoist", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 99, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 100, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 101, "name": "wwGate", "relatedTableId": 51, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 102, "name": "wwFilter_Media", "relatedTableId": 50, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 103, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 104, "name": "wwAir_Handling", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 105, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 90, "name": "wwPlant", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.91, "id": 23, "name": "wpAir_Handling", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "HORSEPOWER", "type": "esriFieldTypeString", "alias": "HORSEPOWER", "length": 25, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12410_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12410", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42332FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12410", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 61, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 24, "name": "wpChemical_Pump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "ELECTRICAL", "type": "esriFieldTypeString", "alias": "ELECTRICAL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12411_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12411", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42333FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12411", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 40, "name": "wpTank_Basin", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 60, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 106, "name": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 25, "name": "wpChemical_Tank", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "CONTENTS", "type": "esriFieldTypeString", "alias": "CONTENTS", "length": 60, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 50, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "CONTAINMENT", "type": "esriFieldTypeString", "alias": "CONTAINMENT", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12413_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12413", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42335ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42335FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12413", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 106, "name": "wpChemical_Pump", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 107, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 108, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 56, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 26, "name": "wpChlorinator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "GAS", "type": "esriFieldTypeString", "alias": "GAS", "length": 25, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 50, "domain": null }, { "name": "EJECTOR_MAKE", "type": "esriFieldTypeString", "alias": "EJECTOR MAKE", "length": 60, "domain": null }, { "name": "EJECTOR_MODEL", "type": "esriFieldTypeString", "alias": "EJECTOR MODEL", "length": 50, "domain": null }, { "name": "REGULATOR_MAKE", "type": "esriFieldTypeString", "alias": "REGULATOR MAKE", "length": 60, "domain": null }, { "name": "REGULATOR_MODEL", "type": "esriFieldTypeString", "alias": "REGULATOR MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12414_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12414", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42336FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12414", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 62, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 27, "name": "wpElectrical", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 20, "domain": null }, { "name": "NUM_OF_PANELS", "type": "esriFieldTypeString", "alias": "NUM OF PANELS", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12412_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12412", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42334FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12412", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 49, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 44, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 28, "name": "wpEquipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "DESCRIPTION_1", "type": "esriFieldTypeString", "alias": "DESCRIPTION 1", "length": 100, "domain": null }, { "name": "DESCRIPTION_2", "type": "esriFieldTypeString", "alias": "DESCRIPTION 2", "length": 100, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12425_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12425", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42347FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12425", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 25, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 55, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 109, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 29, "name": "wpGate", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "DIMENSIONS", "type": "esriFieldTypeString", "alias": "DIMENSIONS", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "ACTUATOR", "type": "esriFieldTypeString", "alias": "ACTUATOR", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12416_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12416", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42338ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42338FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12416", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 110, "name": "wpValve_Operator", "relatedTableId": 44, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 59, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 30, "name": "wpGearbox", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12442_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12442", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42364FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12442", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 111, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 112, "name": "wpMixer", "relatedTableId": 34, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 31, "name": "wpHoist", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12417_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12417", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42339FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12417", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 50, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 32, "name": "wpHVAC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "HEATER", "type": "esriFieldTypeString", "alias": "HEATER", "length": 60, "domain": null }, { "name": "EXHAUST_FAN", "type": "esriFieldTypeString", "alias": "EXHAUST FAN", "length": 60, "domain": null }, { "name": "AIR_CONDITIONER", "type": "esriFieldTypeString", "alias": "AIR CONDITIONER", "length": 60, "domain": null }, { "name": "HEAT_PUMP", "type": "esriFieldTypeString", "alias": "HEAT PUMP", "length": 60, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12418_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12418", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42340FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12418", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 33, "name": "wpInstrumentation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "MEASUREMENT", "type": "esriFieldTypeString", "alias": "MEASUREMENT", "length": 30, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12419_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12419", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42341FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12419", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 39, "name": "wpReservoir", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 41, "name": "wpTank_Basin", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 51, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 45, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 107, "name": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 34, "name": "wpMixer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 40, "domain": null }, { "name": "DESCRIPTION1", "type": "esriFieldTypeString", "alias": "DESCRIPTION1", "length": 40, "domain": null }, { "name": "DESCRIPTION2", "type": "esriFieldTypeString", "alias": "DESRIPTION2", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN_KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12428_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12428", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42350ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42350FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12428", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 113, "name": "wpMotor", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 112, "name": "wpGearbox", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 54, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 35, "name": "wpMotor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 40, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "HORSEPOWER", "type": "esriFieldTypeString", "alias": "HORSEPOWER", "length": 25, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12427_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12427", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42349FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12427", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 52, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 114, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 113, "name": "wpMixer", "relatedTableId": 34, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 36, "name": "wpMotorControlCenter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PANEL_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "NUM_OF_MOTORS", "type": "esriFieldTypeString", "alias": "NUM OF MOTORS", "length": 15, "domain": null }, { "name": "HORSEPOWER", "type": "esriFieldTypeString", "alias": "HORSEPOWER", "length": 15, "domain": null }, { "name": "STARTER_MAKE", "type": "esriFieldTypeString", "alias": "STARTER_MAKE", "length": 60, "domain": null }, { "name": "STARTER_MODEL", "type": "esriFieldTypeString", "alias": "STARTER_MODEL", "length": 50, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 20, "domain": null }, { "name": "PANEL_NAME", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12422_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12422", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42344FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12422", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 22, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 63, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 37, "name": "wpPump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 40, "domain": null }, { "name": "DESIGN_HEAD", "type": "esriFieldTypeString", "alias": "DESIGN HEAD", "length": 40, "domain": null }, { "name": "DESIGN_FLOW", "type": "esriFieldTypeString", "alias": "DESIGN FLOW", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12415_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12415", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42337FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42337ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12415", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 109, "name": "wpEquipment", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 114, "name": "wpMotor", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 115, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 116, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 111, "name": "wpGearbox", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 53, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 38, "name": "wprPiping", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "SIZE", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "TYPE", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12421_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12421", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42343FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12421", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 42, "name": "wpTank_Basin", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 57, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 46, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 108, "name": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 116, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 39, "name": "wprGenerator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 40, "domain": null }, { "name": "FUEL_TYPE", "type": "esriFieldTypeString", "alias": "FUEL TYPE", "length": 30, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12426_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12426", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42348FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12426", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 26, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 40, "name": "wprValve", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "SIZE", "length": 20, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 20, "domain": null }, { "name": "FUNCTION_", "type": "esriFieldTypeString", "alias": "FUNCTION", "length": 30, "domain": null }, { "name": "ACCESS", "type": "esriFieldTypeString", "alias": "ACCESS", "length": 20, "domain": null }, { "name": "ACUATOR", "type": "esriFieldTypeString", "alias": "ACUATOR", "length": 20, "domain": null }, { "name": "DIRECTION_TO_CLOSE", "type": "esriFieldTypeString", "alias": "DIRECTION TO CLOSE", "length": 15, "domain": null }, { "name": "TURNS", "type": "esriFieldTypeString", "alias": "TURNS", "length": 10, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 40, "domain": null }, { "name": "TORQUE", "type": "esriFieldTypeString", "alias": "TORQUE", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12423_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12423", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42345ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42345FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12423", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 117, "name": "wpValve_Operator", "relatedTableId": 44, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 37, "name": "Kilgore.DBO.wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 58, "name": "wpVault", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 47, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 115, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 41, "name": "wprVault", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "LENGTH", "length": 20, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeString", "alias": "WIDTH", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 30, "domain": null }, { "name": "HATCH", "type": "esriFieldTypeString", "alias": "HATCH", "length": 20, "domain": null }, { "name": "SUMP", "type": "esriFieldTypeString", "alias": "SUMP", "length": 20, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "DIAMETER", "length": 20, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12429_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12429", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42351FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12429", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 43, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 42, "name": "wpSafetyFeature", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "FEATURE", "type": "esriFieldTypeString", "alias": "FEATURE", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 25, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12424_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12424", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42346FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12424", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 24, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 43, "name": "wpSCADA", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PANEL_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "PANEL_NAME", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "FORIEGN_KEY", "type": "esriFieldTypeString", "alias": "FORIEGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12420_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12420", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42342FORIEGN_KE", "fields": "FORIEGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12420", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 20, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 48, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 44, "name": "wpValve_Operator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 25, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12443_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12443", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42365FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12443", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 110, "name": "wpGate", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 117, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 45, "name": "wwAir_Handling", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "HORSEPOWER", "type": "esriFieldTypeString", "alias": "HORSEPOWER", "length": 25, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12430_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12430", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42352FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12430", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 66, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 94, "name": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 104, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 46, "name": "wwChemical_Pump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "ELECTRICAL", "type": "esriFieldTypeString", "alias": "ELECTRICAL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12435_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12435", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42357FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12435", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 78, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 47, "name": "wwChlorinator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "GAS", "type": "esriFieldTypeString", "alias": "GAS", "length": 25, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 50, "domain": null }, { "name": "EJECTOR_MAKE", "type": "esriFieldTypeString", "alias": "EJECTOR MAKE", "length": 60, "domain": null }, { "name": "EJECTOR_MODEL", "type": "esriFieldTypeString", "alias": "EJECTOR MODEL", "length": 50, "domain": null }, { "name": "REGULATOR_MAKE", "type": "esriFieldTypeString", "alias": "REGULATOR MAKE", "length": 60, "domain": null }, { "name": "REGULATOR_MODEL", "type": "esriFieldTypeString", "alias": "REGULATOR MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12433_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12433", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42355FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12433", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 72, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 48, "name": "wwElectrical", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 20, "domain": null }, { "name": "NUM_OF_PANELS", "type": "esriFieldTypeString", "alias": "NUM OF PANELS", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12402_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12402", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42324FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12402", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 68, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 88, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 99, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 49, "name": "wwEquipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "DESCRIPTION_1", "type": "esriFieldTypeString", "alias": "DESCRIPTION 1", "length": 100, "domain": null }, { "name": "DESCRIPTION_2", "type": "esriFieldTypeString", "alias": "DESCRIPTION 2", "length": 100, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12436_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12436", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42358FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12436", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 79, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 84, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 97, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 50, "name": "wwFilter_Media", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "VOLUME", "type": "esriFieldTypeString", "alias": "VOLUME", "length": 30, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12439_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12439", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42361FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12439", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 102, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 51, "name": "wwGate", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "DIMENSIONS", "type": "esriFieldTypeString", "alias": "DIMENSIONS", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "ACTUATOR", "type": "esriFieldTypeString", "alias": "ACTUATOR", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12438_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12438", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42360FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12438", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 93, "name": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 101, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 52, "name": "wwHoist", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeString", "alias": "CAPACITY", "length": 25, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12403_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12403", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42325FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12403", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 70, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 98, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 53, "name": "wwHVAC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "HEATER", "type": "esriFieldTypeString", "alias": "HEATER", "length": 60, "domain": null }, { "name": "EXHAUST_FAN", "type": "esriFieldTypeString", "alias": "EXHAUST FAN", "length": 60, "domain": null }, { "name": "AIR_CONDITIONER", "type": "esriFieldTypeString", "alias": "AIR CONDITIONER", "length": 60, "domain": null }, { "name": "HEAT_PUMP", "type": "esriFieldTypeString", "alias": "HEAT PUMP", "length": 60, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12431_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12431", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42353FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12431", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 67, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 54, "name": "wwInstrumentation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "MEASUREMENT", "type": "esriFieldTypeString", "alias": "MEASUREMENT", "length": 30, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12404_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12404", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42326FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12404", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 75, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 89, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 92, "name": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 100, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 55, "name": "wwMotor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 100, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 100, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 40, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "HORSEPOWER", "type": "esriFieldTypeString", "alias": "HORSEPOWER", "length": 15, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12441_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12441", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42363FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12441", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 118, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 56, "name": "wwMotorControlCenter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PANEL_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "NUM_OF_MOTORS", "type": "esriFieldTypeString", "alias": "NUM OF MOTORS", "length": 15, "domain": null }, { "name": "HORSEPOWER", "type": "esriFieldTypeString", "alias": "HORSEPOWER", "length": 15, "domain": null }, { "name": "STARTER_MAKE", "type": "esriFieldTypeString", "alias": "STARTER_MAKE", "length": 60, "domain": null }, { "name": "STARTER_MODEL", "type": "esriFieldTypeString", "alias": "STARTER_MODEL", "length": 50, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 20, "domain": null }, { "name": "PANEL_NAME", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12432_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12432", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42354FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12432", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 69, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 57, "name": "wwPump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model_Number", "length": 50, "domain": null }, { "name": "DESIGN_HEAD", "type": "esriFieldTypeString", "alias": "DESIGN HEAD", "length": 40, "domain": null }, { "name": "DESIGN_FLOW", "type": "esriFieldTypeString", "alias": "DESIGN FLOW", "length": 40, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12405_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12405", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42327ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42327FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12405", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 119, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 120, "name": "wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 118, "name": "wwMotor", "relatedTableId": 55, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 80, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 83, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 103, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 58, "name": "wwrLiftStation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "LENGTH", "length": 20, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeString", "alias": "WIDTH", "length": 20, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "length": 20, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "DIAMETER", "length": 20, "domain": null }, { "name": "NUMBER_OF_PUMPS", "type": "esriFieldTypeString", "alias": "NUMBER OF PUMPS", "length": 20, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12437_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12437", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42359FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12437", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 81, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 59, "name": "wwrPiping", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "SIZE", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "TYPE", "length": 20, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12406_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12406", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42328FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12406", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 71, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 85, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 95, "name": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 105, "name": "wwVault", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 119, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 60, "name": "wwrValve", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 40, "domain": null }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "SIZE", "length": 20, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 20, "domain": null }, { "name": "FUNCTION_", "type": "esriFieldTypeString", "alias": "FUNCTION", "length": 30, "domain": null }, { "name": "ACCESS", "type": "esriFieldTypeString", "alias": "ACCESS", "length": 20, "domain": null }, { "name": "ACUATOR", "type": "esriFieldTypeString", "alias": "ACUATOR", "length": 20, "domain": null }, { "name": "DIRECTION_TO_CLOSE", "type": "esriFieldTypeString", "alias": "DIRECTION TO CLOSE", "length": 15, "domain": null }, { "name": "TURNS", "type": "esriFieldTypeString", "alias": "TURNS", "length": 10, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 40, "domain": null }, { "name": "TORQUE", "type": "esriFieldTypeString", "alias": "TORQUE", "length": 15, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12408_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12408", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42330FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12408", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Kilgore.DBO.Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 77, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 87, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 96, "name": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 120, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 61, "name": "wwSafetyFeature", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "FEATURE", "type": "esriFieldTypeString", "alias": "FEATURE", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 25, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "FOREIGN_KEY", "type": "esriFieldTypeString", "alias": "FOREIGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12434_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12434", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42356FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12434", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 73, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }, { "currentVersion": 10.91, "id": 62, "name": "wwSCADA", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PANEL_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 60, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "PANEL_NAME", "type": "esriFieldTypeString", "alias": "MAKE", "length": 60, "domain": null }, { "name": "FORIEGN_KEY", "type": "esriFieldTypeString", "alias": "FORIEGN KEY", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12407_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12407", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G42329FORIEGN_KE", "fields": "FORIEGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12407", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 74, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 86, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 } ] }