{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 23, "name": "Lift Stations and WWTP", "type": "Group Layer", "description": "New Group Layer", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 25, "name": "Waste Water Lift Stations" }, { "id": 0, "name": "WWTP Foot Prints" } ], "minScale": 0, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 3222252.8719471395, "ymin": 1.3823018231758058E7, "xmax": 3281106.47996147, "ymax": 1.3870681933018401E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "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, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 25, "name": "Waste Water Lift Stations", "type": "Feature Layer", "description": "

20170712 - Bob - Updated the lift stations last month by verifing the locatiions and correcting the address listed in the table. Identified them as Public or Private from personnel maintaining the stations. <\/SPAN><\/P>

20170712 - Bob Added the field \"UNIQUE_ID\" and populated the field using \"LS\", (Lift Station) and a numerical number leaving spaces for future numbering .<\/SPAN><\/P><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278, "vcsWkid": 115702, "latestVcsWkid": 115702, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "NAD_1983", "heightUnit": "meter" }, "copyrightText": "Mathew Bailey of Engineering", "parentLayer": { "id": 23, "name": "Lift Stations and WWTP" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 113, 158, 42, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3222252.8719471395, "ymin": 1.3823018231758058E7, "xmax": 3281106.47996147, "ymax": 1.3870681933018401E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "LS_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "LS_NAME", "type": "esriFieldTypeString", "alias": "LS_NAME", "length": 50, "domain": null }, { "name": "PUMP_1", "type": "esriFieldTypeString", "alias": "PUMP_1", "length": 50, "domain": null }, { "name": "PUMP_2", "type": "esriFieldTypeString", "alias": "PUMP_2", "length": 50, "domain": null }, { "name": "PUMP_3", "type": "esriFieldTypeString", "alias": "PUMP_3", "length": 50, "domain": null }, { "name": "PUMP_4", "type": "esriFieldTypeString", "alias": "PUMP_4", "length": 50, "domain": null }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "OWNERSHIP", "length": 50, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "length": 50, "domain": { "type": "codedValue", "name": "LIFTSTATIONdistricts", "description": "Lift Station Districts", "codedValues": [ { "name": "CENTRAL", "code": "CENTRAL" }, { "name": "EAST", "code": "EAST" }, { "name": "NORTHEAST", "code": "NORTHEAST" }, { "name": "WEST", "code": "WEST" }, { "name": "CENTRAL WWTP", "code": "CENTRAL WWTP" }, { "name": "EAST WWTP", "code": "EAST WWTP" }, { "name": "NORTHWEST WWTP", "code": "NORTHWEST WWTP" }, { "name": "WEST WWTP", "code": "WEST WWTP" }, { "name": "BAWA WTP", "code": "BAWA WTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FloodZone", "type": "esriFieldTypeString", "alias": "FloodZone", "length": 50, "domain": null }, { "name": "YearBuilt", "type": "esriFieldTypeInteger", "alias": "YearBuilt", "domain": null }, { "name": "BLDG_VAL", "type": "esriFieldTypeInteger", "alias": "BLDG_VAL", "domain": null }, { "name": "contents_v", "type": "esriFieldTypeInteger", "alias": "contents_v", "domain": null }, { "name": "X", "type": "esriFieldTypeString", "alias": "X", "length": 50, "domain": null }, { "name": "Y", "type": "esriFieldTypeString", "alias": "Y", "length": 50, "domain": null }, { "name": "Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "length": 50, "domain": null }, { "name": "Internet_C", "type": "esriFieldTypeString", "alias": "Internet_C", "length": 50, "domain": null }, { "name": "Autodialer", "type": "esriFieldTypeString", "alias": "Autodialer", "length": 50, "domain": null }, { "name": "Wireless_R", "type": "esriFieldTypeInteger", "alias": "Wireless_R", "domain": null }, { "name": "Bandwidth", "type": "esriFieldTypeString", "alias": "Bandwidth", "length": 50, "domain": null }, { "name": "Generator", "type": "esriFieldTypeString", "alias": "Generator", "length": 50, "domain": null }, { "name": "Diesel", "type": "esriFieldTypeString", "alias": "Diesel", "length": 50, "domain": null }, { "name": "File_Name", "type": "esriFieldTypeString", "alias": "File_Name", "length": 50, "domain": null }, { "name": "Update_", "type": "esriFieldTypeString", "alias": "Update_", "length": 10, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "COMMENT", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 40, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 25, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "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": "BuildingValue", "type": "esriFieldTypeInteger", "alias": "BuildingValue", "domain": null }, { "name": "ContentValue", "type": "esriFieldTypeInteger", "alias": "ContentValue", "domain": null }, { "name": "WetWellCapacity", "type": "esriFieldTypeInteger", "alias": "WetWellCapacity", "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 50, "domain": { "type": "codedValue", "name": "LiftStationSize", "description": "LiftStation Size", "codedValues": [ { "name": "Small", "code": "Small" }, { "name": "Medium", "code": "Medium" }, { "name": "Large", "code": "Large" }, { "name": "Extra Large", "code": "Extra Large" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RehabYear", "type": "esriFieldTypeString", "alias": "RehabYear", "length": 50, "domain": null }, { "name": "Criticality", "type": "esriFieldTypeString", "alias": "Criticality", "length": 50, "domain": { "type": "codedValue", "name": "wwLiftStationCriticality", "description": "Criticality for WW Liftstations", "codedValues": [ { "name": "Minimal Impact", "code": "Minimal Impact" }, { "name": "Low Impact", "code": "Low Impact" }, { "name": "Medium Impact", "code": "Medium Impact" }, { "name": "High Impact", "code": "High Impact" }, { "name": "Very-High Impact", "code": "Very-High Impact" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConditionScore", "type": "esriFieldTypeInteger", "alias": "ConditionScore", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "LS_service_areas", "type": "esriFieldTypeString", "alias": "LS_service_areas", "length": 50, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R466_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G539UNIQUE_ID", "fields": "UNIQUE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_466", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_466", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S391_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "lsINSTRUMENTATION", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "BaytownGIS.SDE.lsODORCONTROLUNIT", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "sde.SDE.wwtpWELL", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "sde.SDE.wwtpODORCONTROL", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 4, "name": "sde.SDE.lsCONTROLPANEL", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "sde.SDE.lsPUMPS", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "BaytownGIS.SDE.lsBACKFLOWPREVENTER", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "sde.SDE.lsMOTORS", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "sde.SDE.wwtpHOIST", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "lsGENERATOR", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "WWTP Foot Prints", "type": "Feature Layer", "description": "

20160725 - Bob - added 7,000 records from interns <\/SPAN><\/P><\/DIV><\/DIV>", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278, "vcsWkid": 115702, "latestVcsWkid": 115702, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "NAD_1983", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": { "id": 23, "name": "Lift Stations and WWTP" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 196, 221, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 3223021.8799235523, "ymin": 1.3831379511295319E7, "xmax": 3263041.7752773017, "ymax": 1.3863544966649309E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Str_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "HCAD_NUM", "type": "esriFieldTypeString", "alias": "HCAD_NUM", "length": 13, "domain": null }, { "name": "Str_pfx", "type": "esriFieldTypeString", "alias": "Str_pfx", "length": 2, "domain": null }, { "name": "Str_num", "type": "esriFieldTypeDouble", "alias": "Str_num", "domain": null }, { "name": "str_num_sf", "type": "esriFieldTypeString", "alias": "str_num_sf", "length": 3, "domain": null }, { "name": "Str_name", "type": "esriFieldTypeString", "alias": "Str_name", "length": 50, "domain": null }, { "name": "Str_sfx", "type": "esriFieldTypeString", "alias": "Str_sfx", "length": 10, "domain": null }, { "name": "Str_sfx_di", "type": "esriFieldTypeString", "alias": "Str_sfx_di", "length": 50, "domain": null }, { "name": "str_unit", "type": "esriFieldTypeString", "alias": "str_unit", "length": 50, "domain": null }, { "name": "Site_addr_", "type": "esriFieldTypeString", "alias": "Site_addr_", "length": 50, "domain": null }, { "name": "Site_addr1", "type": "esriFieldTypeString", "alias": "Site_addr1", "length": 50, "domain": null }, { "name": "Site_add_1", "type": "esriFieldTypeString", "alias": "Site_add_1", "length": 10, "domain": null }, { "name": "Yr_Impr", "type": "esriFieldTypeString", "alias": "Yr_Impr", "length": 4, "domain": null }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "length": 50, "domain": null }, { "name": "Label1", "type": "esriFieldTypeString", "alias": "Label1", "length": 20, "domain": null }, { "name": "Label2", "type": "esriFieldTypeString", "alias": "Label2", "length": 20, "domain": null }, { "name": "Structure", "type": "esriFieldTypeString", "alias": "Structure", "length": 20, "domain": null }, { "name": "Common_Nam", "type": "esriFieldTypeString", "alias": "Common_Nam", "length": 50, "domain": null }, { "name": "Loc_Name", "type": "esriFieldTypeString", "alias": "Loc_Name", "length": 50, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUB_Name_1", "type": "esriFieldTypeString", "alias": "SUB_Name_1", "length": 50, "domain": null }, { "name": "SUB_Name_2", "type": "esriFieldTypeString", "alias": "SUB_Name_2", "length": 50, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 10, "domain": null }, { "name": "Date", "type": "esriFieldTypeString", "alias": "Date", "length": 10, "domain": null }, { "name": "Prop_Addre", "type": "esriFieldTypeString", "alias": "Prop_Addre", "length": 100, "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeInteger", "alias": "ParcelID", "domain": null }, { "name": "Label3", "type": "esriFieldTypeString", "alias": "Label3", "length": 50, "domain": null }, { "name": "File_Name", "type": "esriFieldTypeString", "alias": "File_Name", "length": 50, "domain": null }, { "name": "Unique_ID", "type": "esriFieldTypeString", "alias": "Unique_ID", "length": 25, "domain": null }, { "name": "Comment_1", "type": "esriFieldTypeString", "alias": "Comment_1", "length": 100, "domain": null }, { "name": "PlantID", "type": "esriFieldTypeString", "alias": "PlantID", "length": 25, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 20, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "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": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "length": 8, "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": "R465_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G538Unique_ID", "fields": "Unique_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G538PlantID", "fields": "PlantID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_465", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_465", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S390_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "BaytownGIS.SDE.wwtpMOTOR", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "BaytownGIS.SDE.wwtpODORCONTROL", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "BaytownGIS.SDE.wwtpGEARBOX", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "BaytownGIS.SDE.wwtpDIGESTOR", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "BaytownGIS.SDE.wwtpWELL", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "BaytownGIS.SDE.wwtpDOOR", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 16, "name": "BaytownGIS.SDE.wwtpCONVEYOR", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "BaytownGIS.SDE.wwtpCHEMICALFEEDSYSTEM", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 18, "name": "BaytownGIS.SDE.wwtpPUMP", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 19, "name": "BaytownGIS.SDE.wwtpGENERATOR", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "BaytownGIS.SDE.wwtpFILTER", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 21, "name": "BaytownGIS.SDE.wwtpBLOWER", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "BaytownGIS.SDE.wwtpHEATER", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "BaytownGIS.SDE.wwtpHOIST", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 24, "name": "BaytownGIS.SDE.wwtpINSTRUMENTATION", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 25, "name": "BaytownGIS.SDE.wwtpTANKS", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 26, "name": "BaytownGIS.SDE.wwtpFAN", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 27, "name": "BaytownGIS.SDE.wwtpRAKEARM", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 28, "name": "BaytownGIS.SDE.wwtpSCALE", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 29, "name": "sde.SDE.wwtpCLARIFIER", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 30, "name": "BaytownGIS.SDE.wwtpBELTPRESS", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 31, "name": "BaytownGIS.SDE.wwtpSAFETY", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 32, "name": "BaytownGIS.SDE.wwtpAIRLIFT", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "WWTPAIRLIFT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R375_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G441BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 32, "name": "BaytownGIS.SDE.wwtpFOOTPRINTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "wwtpBELTPRESS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R374_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G440BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 30, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "wwtpBLOWER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R393_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G459NAME", "fields": "NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G459BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "wwtpCHEMICALFEEDSYSTEM", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R388_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G454BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "wwtpCLARIFIER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "length": 8, "domain": null } ], "indexes": [ { "name": "R368_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G434BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 29, "name": "sde.SDE.wwtpFOOTPRINTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "wwtpCONVEYOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R373_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G439BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "wwtpDIGESTOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "length": 8, "domain": null } ], "indexes": [ { "name": "R389_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G455BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "wwtpDOOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R386_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G452BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "wwtpFAN", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R387_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G453BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 26, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "wwtpFILTER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R379_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G445BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 20, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "wwtpGEARBOX", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R382_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G448BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "wwtpGENERATOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "PERMANENTGENERATOR", "type": "esriFieldTypeString", "alias": "Permanent Generator", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FUELTYPE", "type": "esriFieldTypeString", "alias": "Fuel Type", "length": 255, "domain": null }, { "name": "HOURSOFOPERATION", "type": "esriFieldTypeString", "alias": "Hours of Operation", "length": 255, "domain": null }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R371_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G437BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 13, "name": "wwtpHEATER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "length": 100, "domain": null }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R381_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G447BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 22, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 14, "name": "wwtpHOIST", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "length": 100, "domain": null }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R377_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G443BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 15, "name": "wwtpCONTROLPANEL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "length": 100, "domain": null }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R390_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G456BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 24, "name": "BaytownGIS.SDE.wwtpFOOTPRINTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "wwtpMOTOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HP", "type": "esriFieldTypeSmallInteger", "alias": "HP", "domain": null }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "date_installed", "type": "esriFieldTypeDate", "alias": "date_installed", "length": 8, "domain": null } ], "indexes": [ { "name": "R378_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G444BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 17, "name": "wwtpODORCONTROL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R380_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G446BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "wwtpPUMP", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R391_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G457NAME", "fields": "NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G457BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "wwtpRAKEARM", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R376_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G442BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 27, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "wwtpSAFETY", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R369_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G435BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 31, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 21, "name": "wwtpSCALE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R384_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G450BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 28, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 22, "name": "wwtpTANKS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "length": 8, "domain": null } ], "indexes": [ { "name": "R383_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G449BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 25, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 24, "name": "wwtpWELL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ABOVEGROUNDFEATURENAME", "type": "esriFieldTypeString", "alias": "ABOVE GROUND FEATURE NAME", "length": 100, "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "length": 8, "domain": null } ], "indexes": [ { "name": "R370_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G436BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 26, "name": "lsBACKFLOWPREVENTER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 255, "domain": null }, { "name": "Liftstation", "type": "esriFieldTypeString", "alias": "Liftstation", "length": 255, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 255, "domain": null }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "length": 40, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 255, "domain": null }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R1260_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5482_LIFTSTA", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "BaytownGIS.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 27, "name": "lsCONTROLPANEL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATION ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R372_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G438LIFTSTATIONI", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 28, "name": "lsGENERATOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LIFSTATIONID", "type": "esriFieldTypeString", "alias": "Building ID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "PERMANENTGENERATOR", "type": "esriFieldTypeString", "alias": "Permanent Generator", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HOURSOFOPERATION", "type": "esriFieldTypeString", "alias": "Hours of Operation", "length": 255, "domain": null }, { "name": "FUELTYPE", "type": "esriFieldTypeString", "alias": "Fuel Type", "length": 255, "domain": null }, { "name": "PORTABLE", "type": "esriFieldTypeString", "alias": "PORTABLE", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDITIONALFUELONSITE", "type": "esriFieldTypeString", "alias": "ADDITIONALFUELONSITE", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R1153_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4173_LIFSTAT", "fields": "LIFSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 29, "name": "lsINSTRUMENTATION", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "length": 50, "domain": null }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 50, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 100, "domain": { "type": "codedValue", "name": "WWTPnames", "description": "WWTP NAMES", "codedValues": [ { "name": "CENTRAL DISTRICT WWTP", "code": "CENTRAL DISTRICT WWTP" }, { "name": "EAST DISTRICT WWTP", "code": "EAST DISTRICT WWTP" }, { "name": "NORTHEAST DISTRICT WWTP", "code": "NORTHEAST DISTRICT WWTP" }, { "name": "WEST DISTRICT WWTP", "code": "WEST DISTRICT WWTP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "length": 100, "domain": null }, { "name": "LIFSTATIONID", "type": "esriFieldTypeString", "alias": "LIFSTATIONID", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "length": 50, "domain": null }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R1154_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4174_LIFTSTA", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 30, "name": "lsMOTORS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Motor_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Lift_Station", "type": "esriFieldTypeString", "alias": "Lift Station", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "Pump_Number", "type": "esriFieldTypeSmallInteger", "alias": "Pump Number", "domain": null }, { "name": "AvgRunTime", "type": "esriFieldTypeString", "alias": "AvgRunTime", "length": 5, "domain": null }, { "name": "Motor_Name", "type": "esriFieldTypeString", "alias": "Motor Name", "length": 50, "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 25, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 20, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "length": 8, "domain": null }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "length": 25, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 75, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "length": 50, "domain": null }, { "name": "FRAME", "type": "esriFieldTypeString", "alias": "FRAME", "length": 15, "domain": null }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "length": 15, "domain": null }, { "name": "AMPS", "type": "esriFieldTypeString", "alias": "AMPS", "length": 15, "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null } ], "indexes": [ { "name": "R385_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G451LIFTSTATIONI", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 31, "name": "lsPUMPS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PUMPNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PUMPNAME", "type": "esriFieldTypeString", "alias": "PUMPNAME", "length": 100, "domain": null }, { "name": "LIFTSTATION", "type": "esriFieldTypeString", "alias": "LIFTSTATION", "length": 75, "domain": null }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "length": 20, "domain": null }, { "name": "Unique_ID", "type": "esriFieldTypeString", "alias": "Unique_ID", "length": 20, "domain": null }, { "name": "PUMPNUMBER", "type": "esriFieldTypeSmallInteger", "alias": "PUMPNUMBER", "domain": null }, { "name": "AVGRUNTIME", "type": "esriFieldTypeDouble", "alias": "AVGRUNTIME", "domain": null }, { "name": "DIAMETERFT", "type": "esriFieldTypeDouble", "alias": "DIAMETERFT", "domain": null }, { "name": "DEPTHFT", "type": "esriFieldTypeDouble", "alias": "DEPTHFT", "domain": null }, { "name": "PUMPMAKE", "type": "esriFieldTypeString", "alias": "PUMPMAKE", "length": 50, "domain": null }, { "name": "PUMPMODEL", "type": "esriFieldTypeString", "alias": "PUMPMODEL", "length": 50, "domain": null }, { "name": "PUMPSERIALNUMBER", "type": "esriFieldTypeString", "alias": "PUMPSERIALNUMBER", "length": 50, "domain": null }, { "name": "PUMPHP", "type": "esriFieldTypeDouble", "alias": "PUMPHP", "domain": null }, { "name": "PUMPGPM", "type": "esriFieldTypeString", "alias": "PUMPGPM", "length": 15, "domain": null }, { "name": "PUMPTDH", "type": "esriFieldTypeString", "alias": "PUMPTDH", "length": 15, "domain": null }, { "name": "PUMPSYSTEM", "type": "esriFieldTypeString", "alias": "PUMPSYSTEM", "length": 50, "domain": null }, { "name": "PUMPTYPE", "type": "esriFieldTypeString", "alias": "PUMPTYPE", "length": 50, "domain": null }, { "name": "DISCHARGE", "type": "esriFieldTypeDouble", "alias": "DISCHARGE", "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeDouble", "alias": "VOLTAGE", "domain": null }, { "name": "AMPS", "type": "esriFieldTypeDouble", "alias": "AMPS", "domain": null }, { "name": "RPM", "type": "esriFieldTypeDouble", "alias": "RPM", "domain": null }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "length": 20, "domain": { "type": "codedValue", "name": "LIFECYCLE", "description": "ASSET LIFE CYCLE", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "ABANDONED", "code": "ABANDONED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "INACTIVE", "code": "INACTIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "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": "date_installed", "type": "esriFieldTypeDate", "alias": "date_installed", "length": 8, "domain": null } ], "indexes": [ { "name": "R392_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G458LIFTSTATIONI", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "lsODORCONTROLUNIT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "LiftStation", "length": 255, "domain": null }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "length": 40, "domain": null }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "length": 255, "domain": null } ], "indexes": [ { "name": "R1259_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5480_LIFTSTA", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "BaytownGIS.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }