{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 74, "name": "swControlStructure", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "FeatureType", "type": "esriFieldTypeString", "alias": "FeatureType", "length": 5, "domain": { "type": "codedValue", "name": "swContStrType", "description": "Control Structure Type", "codedValues": [ { "name": "Gate Valve", "code": "GV" }, { "name": "Flow Restrictor Tee", "code": "FRT" }, { "name": "Weir", "code": "WR" }, { "name": "Floatable Material Separator", "code": "FMS" }, { "name": "Overflow Riser", "code": "OVR" }, { "name": "Sluice Gate", "code": "SG" }, { "name": "Backflow Preventer", "code": "BP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ManholeID", "type": "esriFieldTypeString", "alias": "ManholeID", "length": 35, "domain": null }, { "name": "CatchBasinID", "type": "esriFieldTypeString", "alias": "CatchBasinID", "length": 35, "domain": null }, { "name": "VaultID", "type": "esriFieldTypeString", "alias": "VaultID", "length": 35, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 30, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 130, "domain": null }, { "name": "EstimatedEffectiveLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedEffectiveLife", "domain": null }, { "name": "InstallYear", "type": "esriFieldTypeSmallInteger", "alias": "InstallYear", "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "LifeCycle", "type": "esriFieldTypeString", "alias": "LifeCycle", "length": 5, "domain": { "type": "codedValue", "name": "swLifeCycle", "description": "Stormwater Life Cycle Status", "codedValues": [ { "name": "Active", "code": "AC" }, { "name": "Proposed", "code": "PR" }, { "name": "Abandoned", "code": "AB" }, { "name": "Removed", "code": "RE" }, { "name": "Scrapped", "code": "SC" }, { "name": "Planned Decommission", "code": "PD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CleanoutType", "type": "esriFieldTypeString", "alias": "CleanoutType", "length": 25, "domain": { "type": "codedValue", "name": "swCleanoutType", "description": "Different Type of Cleanout valve types on a Surface Water Control Structure", "codedValues": [ { "name": "Shear", "code": "SHR" }, { "name": "Slide", "code": "SLD" }, { "name": "Flap", "code": "FLP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OrifacePlate_DIAM", "type": "esriFieldTypeDouble", "alias": "OrifacePlate_DIAM", "domain": null }, { "name": "OverflowHeight", "type": "esriFieldTypeDouble", "alias": "OverflowHeight", "domain": null }, { "name": "MaxFlowCapacity", "type": "esriFieldTypeDouble", "alias": "MaxFlowCapacity", "domain": null }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "OwnedBy", "length": 6, "domain": { "type": "codedValue", "name": "swOwnedBy", "description": "Owner of Asset", "codedValues": [ { "name": "City of Shoreline", "code": "CITY" }, { "name": "City (Other)", "code": "CITYO" }, { "name": "County", "code": "COUNTY" }, { "name": "State", "code": "STATE" }, { "name": "Other", "code": "OTHER" }, { "name": "Private", "code": "PVT" }, { "name": "Sound Transit", "code": "CPSRTA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OperatedBy", "type": "esriFieldTypeString", "alias": "OperatedBy", "length": 25, "domain": { "type": "codedValue", "name": "swOperatedBy", "description": "Responsibility for SWES", "codedValues": [ { "name": "City-Regional", "code": "CREG" }, { "name": "City-Residential", "code": "CRES" }, { "name": "City-Commercial", "code": "CCOM" }, { "name": "City-ROW", "code": "CROW" }, { "name": "City-Parks", "code": "CPAR" }, { "name": "Other-Outside City", "code": "OTHO" }, { "name": "County-King", "code": "COUK" }, { "name": "City-Facility", "code": "CFAC" }, { "name": "Private", "code": "PVT" }, { "name": "State-WSDOT", "code": "WSDOT" }, { "name": "Private-BNSF", "code": "PVTRR" }, { "name": "City-Pollution Prevention", "code": "CPOLL" }, { "name": "Sound Transit", "code": "CPSRTA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 35, "domain": null } ], "indexes": [ { "name": "R1468_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1468", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G43313swManholeI", "fields": "ManholeID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G43313swCatchBas", "fields": "CatchBasinID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G43313swVaultID", "fields": "VaultID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1468", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "swVault", "relatedTableId": 32, "role": "esriRelRoleDestination", "keyField": "VaultID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{21037D31-2750-46B7-9DCC-9CCA54E7888F}" }, { "id": 29, "name": "swVault", "relatedTableId": 65, "role": "esriRelRoleDestination", "keyField": "VaultID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{21037D31-2750-46B7-9DCC-9CCA54E7888F}" }, { "id": 2, "name": "swCatchBasin", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "CatchBasinID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3E56705C-4824-4E7E-BBD9-B996285E9B61}" }, { "id": 18, "name": "swCatchBasin", "relatedTableId": 43, "role": "esriRelRoleDestination", "keyField": "CatchBasinID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3E56705C-4824-4E7E-BBD9-B996285E9B61}" }, { "id": 33, "name": "swCatchBasin", "relatedTableId": 86, "role": "esriRelRoleDestination", "keyField": "CatchBasinID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3E56705C-4824-4E7E-BBD9-B996285E9B61}" }, { "id": 7, "name": "swManhole", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "ManholeID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{280DDA96-2FB5-4DF7-AACF-237B3A75DCD0}" }, { "id": 23, "name": "swManhole", "relatedTableId": 44, "role": "esriRelRoleDestination", "keyField": "ManholeID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{280DDA96-2FB5-4DF7-AACF-237B3A75DCD0}" }, { "id": 38, "name": "swManhole", "relatedTableId": 87, "role": "esriRelRoleDestination", "keyField": "ManholeID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{280DDA96-2FB5-4DF7-AACF-237B3A75DCD0}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 4000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "0430ed826b6c47d39aed3e82239b70eb" }