{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 25, "name": "Waste Water Lift Stations", "type": "Feature Layer", "parentLayer": { "id": 23, "name": "Lift Stations and WWTP" }, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "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>", "copyrightText": "Mathew Bailey of Engineering", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "lsINSTRUMENTATION", "relatedTableId": 29, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 1, "name": "BaytownGIS.SDE.lsODORCONTROLUNIT", "relatedTableId": 32, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 2, "name": "sde.SDE.wwtpWELL", "relatedTableId": 24, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 3, "name": "sde.SDE.wwtpODORCONTROL", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 4, "name": "sde.SDE.lsCONTROLPANEL", "relatedTableId": 27, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 5, "name": "sde.SDE.lsPUMPS", "relatedTableId": 31, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 6, "name": "BaytownGIS.SDE.lsBACKFLOWPREVENTER", "relatedTableId": 26, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 7, "name": "sde.SDE.lsMOTORS", "relatedTableId": 30, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 8, "name": "sde.SDE.wwtpHOIST", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false }, { "id": 9, "name": "lsGENERATOR", "relatedTableId": 28, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "UNIQUE_ID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": 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 } }, "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" }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LS_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "LS_NAME", "type": "esriFieldTypeString", "alias": "LS_NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LS_NAME" }, { "name": "PUMP_1", "type": "esriFieldTypeString", "alias": "PUMP_1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMP_1" }, { "name": "PUMP_2", "type": "esriFieldTypeString", "alias": "PUMP_2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMP_2" }, { "name": "PUMP_3", "type": "esriFieldTypeString", "alias": "PUMP_3", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMP_3" }, { "name": "PUMP_4", "type": "esriFieldTypeString", "alias": "PUMP_4", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMP_4" }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "OWNERSHIP", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OWNERSHIP" }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "District" }, { "name": "FloodZone", "type": "esriFieldTypeString", "alias": "FloodZone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FloodZone" }, { "name": "YearBuilt", "type": "esriFieldTypeInteger", "alias": "YearBuilt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YearBuilt" }, { "name": "BLDG_VAL", "type": "esriFieldTypeInteger", "alias": "BLDG_VAL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BLDG_VAL" }, { "name": "contents_v", "type": "esriFieldTypeInteger", "alias": "contents_v", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "contents_v" }, { "name": "X", "type": "esriFieldTypeString", "alias": "X", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "X" }, { "name": "Y", "type": "esriFieldTypeString", "alias": "Y", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Y" }, { "name": "Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Telephone" }, { "name": "Internet_C", "type": "esriFieldTypeString", "alias": "Internet_C", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Internet_C" }, { "name": "Autodialer", "type": "esriFieldTypeString", "alias": "Autodialer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Autodialer" }, { "name": "Wireless_R", "type": "esriFieldTypeInteger", "alias": "Wireless_R", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Wireless_R" }, { "name": "Bandwidth", "type": "esriFieldTypeString", "alias": "Bandwidth", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Bandwidth" }, { "name": "Generator", "type": "esriFieldTypeString", "alias": "Generator", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Generator" }, { "name": "Diesel", "type": "esriFieldTypeString", "alias": "Diesel", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Diesel" }, { "name": "File_Name", "type": "esriFieldTypeString", "alias": "File_Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "File_Name" }, { "name": "Update_", "type": "esriFieldTypeString", "alias": "Update_", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Update_" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "COMMENT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COMMENT" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "BuildingValue", "type": "esriFieldTypeInteger", "alias": "BuildingValue", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BuildingValue" }, { "name": "ContentValue", "type": "esriFieldTypeInteger", "alias": "ContentValue", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ContentValue" }, { "name": "WetWellCapacity", "type": "esriFieldTypeInteger", "alias": "WetWellCapacity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WetWellCapacity" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Size" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "RehabYear", "type": "esriFieldTypeString", "alias": "RehabYear", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RehabYear" }, { "name": "Criticality", "type": "esriFieldTypeString", "alias": "Criticality", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Criticality" }, { "name": "ConditionScore", "type": "esriFieldTypeInteger", "alias": "ConditionScore", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConditionScore" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "LS_service_areas", "type": "esriFieldTypeString", "alias": "LS_service_areas", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LS_service_areas" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Waste Water Lift Stations", "description": "", "prototype": { "attributes": { "LS_service_areas": null, "ConditionScore": null, "ADDRESS": null, "LS_NAME": null, "PUMP_1": null, "PUMP_2": null, "PUMP_3": null, "PUMP_4": null, "OWNERSHIP": null, "District": null, "FloodZone": null, "YearBuilt": null, "BLDG_VAL": null, "contents_v": null, "X": null, "Y": null, "Telephone": null, "Internet_C": null, "Autodialer": null, "Wireless_R": null, "Bandwidth": null, "Generator": null, "Diesel": null, "File_Name": null, "Update_": null, "COMMENT": null, "UNIQUE_ID": null, "WARRANTYDATE": null, "LOCATION": null, "LIFECYCLE": null, "Criticality": null, "RehabYear": null, "Enabled": 1, "Size": null, "BuildingValue": null, "ContentValue": null, "WetWellCapacity": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "WWTP Foot Prints", "type": "Feature Layer", "parentLayer": { "id": 23, "name": "Lift Stations and WWTP" }, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "

20160725 - Bob - added 7,000 records from interns <\/SPAN><\/P><\/DIV><\/DIV>", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 10, "name": "BaytownGIS.SDE.wwtpMOTOR", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 11, "name": "BaytownGIS.SDE.wwtpODORCONTROL", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 12, "name": "BaytownGIS.SDE.wwtpGEARBOX", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 13, "name": "BaytownGIS.SDE.wwtpDIGESTOR", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 14, "name": "BaytownGIS.SDE.wwtpWELL", "relatedTableId": 24, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 15, "name": "BaytownGIS.SDE.wwtpDOOR", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 16, "name": "BaytownGIS.SDE.wwtpCONVEYOR", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 17, "name": "BaytownGIS.SDE.wwtpCHEMICALFEEDSYSTEM", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 18, "name": "BaytownGIS.SDE.wwtpPUMP", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 19, "name": "BaytownGIS.SDE.wwtpGENERATOR", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 20, "name": "BaytownGIS.SDE.wwtpFILTER", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 21, "name": "BaytownGIS.SDE.wwtpBLOWER", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 22, "name": "BaytownGIS.SDE.wwtpHEATER", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 23, "name": "BaytownGIS.SDE.wwtpHOIST", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 24, "name": "BaytownGIS.SDE.wwtpINSTRUMENTATION", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 25, "name": "BaytownGIS.SDE.wwtpTANKS", "relatedTableId": 22, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 26, "name": "BaytownGIS.SDE.wwtpFAN", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 27, "name": "BaytownGIS.SDE.wwtpRAKEARM", "relatedTableId": 19, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 28, "name": "BaytownGIS.SDE.wwtpSCALE", "relatedTableId": 21, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 29, "name": "sde.SDE.wwtpCLARIFIER", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 30, "name": "BaytownGIS.SDE.wwtpBELTPRESS", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 31, "name": "BaytownGIS.SDE.wwtpSAFETY", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false }, { "id": 32, "name": "BaytownGIS.SDE.wwtpAIRLIFT", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Unique_ID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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" }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Str_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "HCAD_NUM", "type": "esriFieldTypeString", "alias": "HCAD_NUM", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "HCAD_NUM" }, { "name": "Str_pfx", "type": "esriFieldTypeString", "alias": "Str_pfx", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Str_pfx" }, { "name": "Str_num", "type": "esriFieldTypeDouble", "alias": "Str_num", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Str_num" }, { "name": "str_num_sf", "type": "esriFieldTypeString", "alias": "str_num_sf", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "str_num_sf" }, { "name": "Str_name", "type": "esriFieldTypeString", "alias": "Str_name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Str_name" }, { "name": "Str_sfx", "type": "esriFieldTypeString", "alias": "Str_sfx", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Str_sfx" }, { "name": "Str_sfx_di", "type": "esriFieldTypeString", "alias": "Str_sfx_di", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Str_sfx_di" }, { "name": "str_unit", "type": "esriFieldTypeString", "alias": "str_unit", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "str_unit" }, { "name": "Site_addr_", "type": "esriFieldTypeString", "alias": "Site_addr_", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Site_addr_" }, { "name": "Site_addr1", "type": "esriFieldTypeString", "alias": "Site_addr1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Site_addr1" }, { "name": "Site_add_1", "type": "esriFieldTypeString", "alias": "Site_add_1", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Site_add_1" }, { "name": "Yr_Impr", "type": "esriFieldTypeString", "alias": "Yr_Impr", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Yr_Impr" }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Unit" }, { "name": "Label1", "type": "esriFieldTypeString", "alias": "Label1", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Label1" }, { "name": "Label2", "type": "esriFieldTypeString", "alias": "Label2", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Label2" }, { "name": "Structure", "type": "esriFieldTypeString", "alias": "Structure", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Structure" }, { "name": "Common_Nam", "type": "esriFieldTypeString", "alias": "Common_Nam", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Common_Nam" }, { "name": "Loc_Name", "type": "esriFieldTypeString", "alias": "Loc_Name", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Loc_Name" }, { "name": "SUB_Name_1", "type": "esriFieldTypeString", "alias": "SUB_Name_1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUB_Name_1" }, { "name": "SUB_Name_2", "type": "esriFieldTypeString", "alias": "SUB_Name_2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUB_Name_2" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Editor" }, { "name": "Date", "type": "esriFieldTypeString", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Date" }, { "name": "Prop_Addre", "type": "esriFieldTypeString", "alias": "Prop_Addre", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Prop_Addre" }, { "name": "ParcelID", "type": "esriFieldTypeInteger", "alias": "ParcelID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ParcelID" }, { "name": "Label3", "type": "esriFieldTypeString", "alias": "Label3", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Label3" }, { "name": "File_Name", "type": "esriFieldTypeString", "alias": "File_Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "File_Name" }, { "name": "Unique_ID", "type": "esriFieldTypeString", "alias": "Unique_ID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Unique_ID" }, { "name": "Comment_1", "type": "esriFieldTypeString", "alias": "Comment_1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Comment_1" }, { "name": "PlantID", "type": "esriFieldTypeString", "alias": "PlantID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PlantID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateBuilt" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WWTP Foot Prints", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateBuilt": null, "HCAD_NUM": null, "Str_pfx": null, "Str_num": null, "str_num_sf": null, "Str_name": null, "Str_sfx": null, "Str_sfx_di": null, "str_unit": null, "Site_addr_": null, "Site_addr1": null, "Site_add_1": null, "Yr_Impr": null, "Unit": null, "Label1": null, "Label2": null, "Structure": null, "Common_Nam": null, "Loc_Name": null, "SUB_Name_1": null, "SUB_Name_2": null, "Editor": null, "Date": null, "Prop_Addre": null, "ParcelID": null, "Label3": null, "File_Name": null, "Unique_ID": null, "Comment_1": null, "PlantID": null, "LIFECYCLE": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "WWTPAIRLIFT", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 32, "name": "BaytownGIS.SDE.wwtpFOOTPRINTS", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R375_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G441BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WWTPAIRLIFT", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "wwtpBELTPRESS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 30, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R374_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G440BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpBELTPRESS", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "wwtpBLOWER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 21, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpBLOWER", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "wwtpCHEMICALFEEDSYSTEM", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 17, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R388_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G454BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpCHEMICALFEEDSYSTEM", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "wwtpCLARIFIER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 29, "name": "sde.SDE.wwtpFOOTPRINTS", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateBuilt" } ], "indexes": [ { "name": "R368_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G434BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpCLARIFIER", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateBuilt": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "wwtpCONVEYOR", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 16, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R373_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G439BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpCONVEYOR", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "wwtpDIGESTOR", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 13, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateBuilt" } ], "indexes": [ { "name": "R389_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G455BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpDIGESTOR", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateBuilt": null, "CORRESPONDINGDRAWINGNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "wwtpDOOR", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 15, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R386_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G452BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpDOOR", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "wwtpFAN", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 26, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R387_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G453BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpFAN", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "wwtpFILTER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 20, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R379_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G445BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpFILTER", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "wwtpGEARBOX", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 12, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R382_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G448BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpGEARBOX", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "wwtpGENERATOR", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 19, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "PERMANENTGENERATOR", "type": "esriFieldTypeString", "alias": "Permanent Generator", "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERMANENTGENERATOR" }, { "name": "FUELTYPE", "type": "esriFieldTypeString", "alias": "Fuel Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUELTYPE" }, { "name": "HOURSOFOPERATION", "type": "esriFieldTypeString", "alias": "Hours of Operation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HOURSOFOPERATION" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R371_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G437BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpGENERATOR", "description": "", "prototype": { "attributes": { "HOURSOFOPERATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null, "LOCATION": null, "FUELTYPE": null, "PERMANENTGENERATOR": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 13, "name": "wwtpHEATER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 22, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BUILDINGNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R381_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G447BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpHEATER", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 14, "name": "wwtpHOIST", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 8, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false }, { "id": 23, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BUILDINGNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R377_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G443BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpHOIST", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 15, "name": "wwtpCONTROLPANEL", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 24, "name": "BaytownGIS.SDE.wwtpFOOTPRINTS", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BUILDINGNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R390_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G456BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpCONTROLPANEL", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "wwtpMOTOR", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 10, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "HP", "type": "esriFieldTypeSmallInteger", "alias": "HP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HP" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "date_installed", "type": "esriFieldTypeDate", "alias": "date_installed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_installed" } ], "indexes": [ { "name": "R378_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G444BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpMOTOR", "description": "", "prototype": { "attributes": { "LOCATION": null, "date_installed": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "HP": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 17, "name": "wwtpODORCONTROL", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 11, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false }, { "id": 3, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R380_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G446BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpODORCONTROL", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "wwtpPUMP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 18, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpPUMP", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "wwtpRAKEARM", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 27, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R376_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G442BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpRAKEARM", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "wwtpSAFETY", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 31, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R369_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G435BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpSAFETY", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 21, "name": "wwtpSCALE", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 28, "name": "BaytownGIS.SDE.WasteWater_Treatment_Plant_Foot_Prints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R384_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G450BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpSCALE", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 22, "name": "wwtpTANKS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 25, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateBuilt" } ], "indexes": [ { "name": "R383_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G449BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpTANKS", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateBuilt": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 24, "name": "wwtpWELL", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false }, { "id": 14, "name": "BaytownGIS.SDE.WasteWaterTP", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "BUILDINGID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ABOVEGROUNDFEATURENAME", "type": "esriFieldTypeString", "alias": "ABOVE GROUND FEATURE NAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ABOVEGROUNDFEATURENAME" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateBuilt", "type": "esriFieldTypeDate", "alias": "DateBuilt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateBuilt" } ], "indexes": [ { "name": "R370_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G436BUILDINGID", "fields": "BUILDINGID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "wwtpWELL", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateBuilt": null, "ABOVEGROUNDFEATURENAME": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 26, "name": "lsBACKFLOWPREVENTER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "BaytownGIS.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Size" }, { "name": "Liftstation", "type": "esriFieldTypeString", "alias": "Liftstation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Liftstation" }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ModelNumber" }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LIFTSTATIONID" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R1260_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5482_LIFTSTA", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsBACKFLOWPREVENTER", "description": "", "prototype": { "attributes": { "UNIQUE_ID": null, "DateInstalled": null, "Name": null, "SerialNumber": null, "Size": null, "Liftstation": null, "ModelNumber": null, "LIFTSTATIONID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 27, "name": "lsCONTROLPANEL", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATION ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R372_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G438LIFTSTATIONI", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsCONTROLPANEL", "description": "", "prototype": { "attributes": { "LOCATION": null, "DateInstalled": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "LIFTSTATIONID": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 28, "name": "lsGENERATOR", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 9, "name": "WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "LIFSTATIONID", "type": "esriFieldTypeString", "alias": "Building ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BUILDINGID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "PERMANENTGENERATOR", "type": "esriFieldTypeString", "alias": "Permanent Generator", "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERMANENTGENERATOR" }, { "name": "HOURSOFOPERATION", "type": "esriFieldTypeString", "alias": "Hours of Operation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HOURSOFOPERATION" }, { "name": "FUELTYPE", "type": "esriFieldTypeString", "alias": "Fuel Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUELTYPE" }, { "name": "PORTABLE", "type": "esriFieldTypeString", "alias": "PORTABLE", "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PORTABLE" }, { "name": "ADDITIONALFUELONSITE", "type": "esriFieldTypeString", "alias": "ADDITIONALFUELONSITE", "domain": { "type": "codedValue", "name": "YesNo", "description": "YES OR NO", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ADDITIONALFUELONSITE" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R1153_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4173_LIFSTAT", "fields": "LIFSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsGENERATOR", "description": "", "prototype": { "attributes": { "ADDITIONALFUELONSITE": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "LIFSTATIONID": null, "WARRANTYDATE": null, "LOCATION": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "PERMANENTGENERATOR": null, "HOURSOFOPERATION": null, "FUELTYPE": null, "PORTABLE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 29, "name": "lsINSTRUMENTATION", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CORRESPONDINGDRAWINGNUMBER", "type": "esriFieldTypeString", "alias": "CORRESPONDING DRAWING NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORRESPONDINGDRAWINGNUMBER" }, { "name": "ORIGINALIDNUMBER", "type": "esriFieldTypeString", "alias": "ORIGINAL ID NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINALIDNUMBER" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "MODELNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "FACILITYNAME", "type": "esriFieldTypeString", "alias": "Facility Name", "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" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYNAME" }, { "name": "BUILDINGNAME", "type": "esriFieldTypeString", "alias": "Building Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BUILDINGNAME" }, { "name": "LIFSTATIONID", "type": "esriFieldTypeString", "alias": "LIFSTATIONID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LIFSTATIONID" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFTSTATIONID" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R1154_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4174_LIFTSTA", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsINSTRUMENTATION", "description": "", "prototype": { "attributes": { "LIFTSTATIONID": null, "DateInstalled": null, "CORRESPONDINGDRAWINGNUMBER": null, "ORIGINALIDNUMBER": null, "NAME": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "UNIQUE_ID": null, "LIFECYCLE": null, "FACILITYNAME": null, "BUILDINGNAME": null, "LIFSTATIONID": null, "WARRANTYDATE": null, "LOCATION": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 30, "name": "lsMOTORS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 7, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Motor_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Lift_Station", "type": "esriFieldTypeString", "alias": "Lift Station", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Lift_Station" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Address" }, { "name": "Pump_Number", "type": "esriFieldTypeSmallInteger", "alias": "Pump Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pump_Number" }, { "name": "AvgRunTime", "type": "esriFieldTypeString", "alias": "AvgRunTime", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "AvgRunTime" }, { "name": "Motor_Name", "type": "esriFieldTypeString", "alias": "Motor Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Motor_Name" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "UNIQUE_ID" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LIFTSTATIONID" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODEL" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "FRAME", "type": "esriFieldTypeString", "alias": "FRAME", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "FRAME" }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HP" }, { "name": "VOLTAGE", "type": "esriFieldTypeString", "alias": "VOLTAGE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "VOLTAGE" }, { "name": "AMPS", "type": "esriFieldTypeString", "alias": "AMPS", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "AMPS" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInstalled" } ], "indexes": [ { "name": "R385_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G451LIFTSTATIONI", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsMOTORS", "description": "", "prototype": { "attributes": { "AMPS": null, "DateInstalled": null, "Lift_Station": null, "Address": null, "Pump_Number": null, "AvgRunTime": null, "Motor_Name": null, "LIFECYCLE": null, "UNIQUE_ID": null, "LOCATION": null, "WARRANTYDATE": null, "LIFTSTATIONID": null, "MANUFACTURER": null, "MODEL": null, "SERIALNUMBER": null, "FRAME": null, "HP": null, "VOLTAGE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 31, "name": "lsPUMPS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 5, "name": "sde.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PUMPNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PUMPNAME", "type": "esriFieldTypeString", "alias": "PUMPNAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PUMPNAME" }, { "name": "LIFTSTATION", "type": "esriFieldTypeString", "alias": "LIFTSTATION", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "LIFTSTATION" }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LIFTSTATIONID" }, { "name": "Unique_ID", "type": "esriFieldTypeString", "alias": "Unique_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Unique_ID" }, { "name": "PUMPNUMBER", "type": "esriFieldTypeSmallInteger", "alias": "PUMPNUMBER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PUMPNUMBER" }, { "name": "AVGRUNTIME", "type": "esriFieldTypeDouble", "alias": "AVGRUNTIME", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AVGRUNTIME" }, { "name": "DIAMETERFT", "type": "esriFieldTypeDouble", "alias": "DIAMETERFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETERFT" }, { "name": "DEPTHFT", "type": "esriFieldTypeDouble", "alias": "DEPTHFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTHFT" }, { "name": "PUMPMAKE", "type": "esriFieldTypeString", "alias": "PUMPMAKE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMPMAKE" }, { "name": "PUMPMODEL", "type": "esriFieldTypeString", "alias": "PUMPMODEL", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMPMODEL" }, { "name": "PUMPSERIALNUMBER", "type": "esriFieldTypeString", "alias": "PUMPSERIALNUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMPSERIALNUMBER" }, { "name": "PUMPHP", "type": "esriFieldTypeDouble", "alias": "PUMPHP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PUMPHP" }, { "name": "PUMPGPM", "type": "esriFieldTypeString", "alias": "PUMPGPM", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PUMPGPM" }, { "name": "PUMPTDH", "type": "esriFieldTypeString", "alias": "PUMPTDH", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PUMPTDH" }, { "name": "PUMPSYSTEM", "type": "esriFieldTypeString", "alias": "PUMPSYSTEM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMPSYSTEM" }, { "name": "PUMPTYPE", "type": "esriFieldTypeString", "alias": "PUMPTYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMPTYPE" }, { "name": "DISCHARGE", "type": "esriFieldTypeDouble", "alias": "DISCHARGE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISCHARGE" }, { "name": "VOLTAGE", "type": "esriFieldTypeDouble", "alias": "VOLTAGE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VOLTAGE" }, { "name": "AMPS", "type": "esriFieldTypeDouble", "alias": "AMPS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AMPS" }, { "name": "RPM", "type": "esriFieldTypeDouble", "alias": "RPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPM" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "LIFECYCLE", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LIFECYCLE" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "date_installed", "type": "esriFieldTypeDate", "alias": "date_installed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_installed" } ], "indexes": [ { "name": "R392_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G458LIFTSTATIONI", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsPUMPS", "description": "", "prototype": { "attributes": { "LOCATION": null, "date_installed": null, "PUMPNAME": null, "LIFTSTATION": null, "LIFTSTATIONID": null, "Unique_ID": null, "PUMPNUMBER": null, "AVGRUNTIME": null, "DIAMETERFT": null, "DEPTHFT": null, "PUMPMAKE": null, "PUMPMODEL": null, "PUMPSERIALNUMBER": null, "PUMPHP": null, "PUMPGPM": null, "PUMPTDH": null, "PUMPSYSTEM": null, "PUMPTYPE": null, "DISCHARGE": null, "VOLTAGE": null, "AMPS": null, "RPM": null, "LIFECYCLE": null, "WARRANTYDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "lsODORCONTROLUNIT", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "BaytownGIS.SDE.WasteWater_Lift_Stations", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LIFTSTATIONID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ModelNumber" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "LiftStation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location" }, { "name": "LIFTSTATIONID", "type": "esriFieldTypeString", "alias": "LIFTSTATIONID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LIFTSTATIONID" }, { "name": "UNIQUE_ID", "type": "esriFieldTypeString", "alias": "UNIQUE_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UNIQUE_ID" } ], "indexes": [ { "name": "R1259_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5480_LIFTSTA", "fields": "LIFTSTATIONID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "lsODORCONTROLUNIT", "description": "", "prototype": { "attributes": { "LIFTSTATIONID": null, "UNIQUE_ID": null, "Name": null, "ModelNumber": null, "SerialNumber": null, "Location": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }