{ "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": "R12186_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12186", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41436ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12186", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9502_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": "wwFence", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "wwHoist", "relatedTableId": 52, "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": "Kilgore.DBO.wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "wwSCADA", "relatedTableId": 62, "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": "R12228_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12228", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_12228", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9544_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": "R12244_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12244", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41498ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41498FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12244", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9560_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": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "wpChlorinator", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "wpElectrical", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "wpEquipment", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "Kilgore.DBO.wpFence", "relatedTableId": 5, "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": "wpGenerator", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "wpHoist", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 18, "name": "wpHVAC", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 19, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "wpMotorControlCenter", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 21, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "wprGenerator", "relatedTableId": 39, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 24, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 25, "name": "wpSafetyFeature", "relatedTableId": 42, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 26, "name": "wpSCADA", "relatedTableId": 43, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 27, "name": "wpVault", "relatedTableId": 15, "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": "R12245_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12245", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41499FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12245", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9561_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "Kilgore.DBO.wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 29, "name": "wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 30, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "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": "R12247_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12247", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41501ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41501FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12247", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9563_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": "R12250_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12250", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_12250", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9566_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": "R12246_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12246", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41500FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12246", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9562_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "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": "R12248_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12248", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41502FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12248", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9564_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": "R12249_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12249", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41503FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12249", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9565_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": "R12251_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12251", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41505ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12251", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9567_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": 29, "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": "wpReservoir", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 35, "name": "Kilgore.DBO.wprValve", "relatedTableId": 40, "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": "wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 38, "name": "wpVault", "relatedTableId": 15, "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": "R12252_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12252", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41506ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41506FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12252", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9568_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": 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": 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": "R12253_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12253", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41507ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41507FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12253", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9569_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": "R12255_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12255", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41509ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41509FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12255", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9571_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 43, "name": "Kilgore.DBO.wpElectrical", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 30, "name": "Kilgore.DBO.wpFence", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 44, "name": "Kilgore.DBO.wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 45, "name": "Kilgore.DBO.wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 46, "name": "Kilgore.DBO.wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 47, "name": "Kilgore.DBO.wprVault", "relatedTableId": 41, "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": 37, "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": "R12254_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12254", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41508ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41508FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12254", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9570_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 49, "name": "wpAir_Handling", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 50, "name": "wpChemical_Pump", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 51, "name": "wpChemical_Tank", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 52, "name": "wpChlorinator", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 53, "name": "wpElectrical", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 54, "name": "wpEquipment", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 55, "name": "wpGate", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 56, "name": "wpHoist", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 57, "name": "wpInstrumentation", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 58, "name": "wpMixer", "relatedTableId": 34, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 59, "name": "wpMotor", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 60, "name": "wpMotorControlCenter", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 61, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 62, "name": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 63, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 27, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "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": 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": "R12395_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12395", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41654FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12395", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9711_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "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": "R12394_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12394", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41653ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41653FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12394", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9710_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": "wwChemical_Pump", "relatedTableId": 46, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 68, "name": "wwChlorinator", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 69, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 70, "name": "wwEquipment", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 71, "name": "wwHoist", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 72, "name": "wwHVAC", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 73, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 74, "name": "wwLiftStation", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 75, "name": "wwMotorControlCenter", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 76, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 77, "name": "wwrLiftStation", "relatedTableId": 58, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 78, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 79, "name": "wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 80, "name": "wwSafetyFeature", "relatedTableId": 61, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 81, "name": "wwSCADA", "relatedTableId": 62, "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": "R12396_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12396", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41655FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41655ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12396", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9712_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 83, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 84, "name": "wwEquipment", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 64, "name": "wwFence", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 85, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 86, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 87, "name": "wwrPiping", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 88, "name": "wwrValve", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 89, "name": "wwSCADA", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 74, "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": "R12397_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12397", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41656ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12397", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9713_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": "wwTank_Basin", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 91, "name": "wwVault", "relatedTableId": 22, "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": "R12398_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12398", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41657ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41657FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12398", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9714_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 92, "name": "wwAir_Handling", "relatedTableId": 45, "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": "wwInstrumentation", "relatedTableId": 54, "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": 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 }, { "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": "R12399_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12399", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41658ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41658FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12399", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9715_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 97, "name": "wwAir_Handling", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 98, "name": "wwElectrical", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 99, "name": "wwEquipment", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 100, "name": "wwFilter_Media", "relatedTableId": 50, "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": "wwHoist", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 103, "name": "wwInstrumentation", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 104, "name": "wwPump", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 105, "name": "wwrPiping", "relatedTableId": 59, "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 } ], "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": "R11976_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11976", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41205FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11976", "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": 49, "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": "R11977_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11977", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41206FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11977", "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": 106, "name": "wpChemical_Tank", "relatedTableId": 25, "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": 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": 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": "R11978_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11978", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41207ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41207FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11978", "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": 10, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 51, "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": "R11979_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11979", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41208FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11979", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 52, "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": "R11980_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11980", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41209FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11980", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 43, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "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": 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": "R11981_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11981", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41210FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11981", "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": 109, "name": "wpPump", "relatedTableId": 37, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "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": 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": "R11982_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11982", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41211ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41211FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11982", "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": 55, "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": "R11983_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11983", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41212FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11983", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 111, "name": "wpMixer", "relatedTableId": 34, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 112, "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": 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": "R11984_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11984", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41213FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11984", "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 }, { "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": 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": "R11985_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11985", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41214FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11985", "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 } ], "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": "R11986_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11986", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41215FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11986", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "wpBuilding", "relatedTableId": 4, "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 }, { "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": 44, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 57, "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": 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": "R11987_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11987", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41216ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41216FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11987", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 111, "name": "wpGearbox", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 113, "name": "wpMotor", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 58, "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": "R11988_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11988", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41217FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11988", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 113, "name": "wpMixer", "relatedTableId": 34, "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": 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": 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": "R11989_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11989", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41218FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11989", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 20, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 60, "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": "R11990_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11990", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41219FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41219ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11990", "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": 112, "name": "wpGearbox", "relatedTableId": 30, "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": "wprPiping", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 116, "name": "wprValve", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 21, "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": 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": "R11992_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11992", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41221FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11992", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 23, "name": "wpBuilding", "relatedTableId": 4, "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": 115, "name": "wpPump", "relatedTableId": 37, "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": 45, "name": "Kilgore.DBO.wpTank_Tower", "relatedTableId": 14, "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": 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": "R11991_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11991", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41220FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11991", "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 } ], "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": "R11993_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11993", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41222ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41222FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11993", "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": 24, "name": "wpBuilding", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 35, "name": "Kilgore.DBO.wpPlant", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 116, "name": "wpPump", "relatedTableId": 37, "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": 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": 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": "R11994_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11994", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41223FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11994", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 47, "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": "R11995_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11995", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41224FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11995", "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 } ], "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": "R11996_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11996", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41225FORIEGN_KE", "fields": "FORIEGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11996", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 26, "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": "R11997_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11997", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41226FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11997", "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": "R11998_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11998", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41227FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11998", "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": 92, "name": "wwTank_Basin", "relatedTableId": 21, "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": 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": "R11999_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11999", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41228FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11999", "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": 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": "R12000_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12000", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41229FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12000", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 68, "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": "R12001_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12001", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41230FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12001", "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": 69, "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": 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": 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": "R12002_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12002", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41231FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12002", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 70, "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": 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": 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": "R12003_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12003", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41232FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12003", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "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": 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": "R12004_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12004", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41233FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12004", "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": "R12005_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12005", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41234FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12005", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "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": 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": 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": "R12006_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12006", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41235FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12006", "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": 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": "R12007_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12007", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41236FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12007", "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": 73, "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": 94, "name": "wwTank_Basin", "relatedTableId": 21, "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": 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": "R12008_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12008", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41237FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12008", "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": "R12009_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12009", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41238FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12009", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 75, "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": "R12010_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12010", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41239ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41239FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12010", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 118, "name": "wwMotor", "relatedTableId": 55, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "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": 4, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 76, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 86, "name": "wwLiftStation", "relatedTableId": 19, "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": 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": "R12011_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12011", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41240FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12011", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 77, "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": "R12012_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12012", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41241FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12012", "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": 78, "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": 119, "name": "wwPump", "relatedTableId": 57, "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 } ], "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": "R12013_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12013", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41242FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12013", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Kilgore.DBO.Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FOREIGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 79, "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": 120, "name": "wwPump", "relatedTableId": 57, "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 } ], "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": "R12014_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12014", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41243FOREIGN_KE", "fields": "FOREIGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12014", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 80, "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": "R12015_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_12015", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41244FORIEGN_KE", "fields": "FORIEGN_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_12015", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Sewer_LiftStations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 81, "name": "wwBuilding", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "FORIEGN_KEY", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 89, "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 } ] }