{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 90, "name": "swHydrodynamicSeparator", "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": 255, "domain": { "type": "codedValue", "name": "swHydroSepType", "description": "Types of Hydrodynamic Separators", "codedValues": [ { "name": "Cascade Separator", "code": "Cascade Separator" }, { "name": "CDS", "code": "CDS" }, { "name": "DSBB Separator", "code": "DSBB Separator" }, { "name": "SciCloneX", "code": "SciCloneX" }, { "name": "Stormceptor", "code": "Stormceptor" }, { "name": "Vortechs", "code": "Vortechs" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ManholeID", "type": "esriFieldTypeString", "alias": "ManholeID", "length": 50, "domain": null }, { "name": "CatchBasinID", "type": "esriFieldTypeString", "alias": "CatchBasinID", "length": 50, "domain": null }, { "name": "VaultID", "type": "esriFieldTypeString", "alias": "VaultID", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "EstimatedEffectiveLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedEffectiveLife", "domain": null }, { "name": "InstallYear", "type": "esriFieldTypeSmallInteger", "alias": "InstallYear", "domain": null }, { "name": "LifeCycle", "type": "esriFieldTypeString", "alias": "LifeCycle", "length": 255, "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": "Cover_Type", "type": "esriFieldTypeString", "alias": "Cover_Type", "length": 255, "domain": { "type": "codedValue", "name": "swCoverType", "description": "Cover Types found in MACP 6.0 and other City additions", "codedValues": [ { "name": "Solid", "code": "S" }, { "name": "Inner Cover", "code": "IC" }, { "name": "Locking", "code": "LOCK" }, { "name": "Hatch, Single", "code": "HS" }, { "name": "Hatch, Double", "code": "HD" }, { "name": "Lamphole", "code": "LAMP" }, { "name": "Vented", "code": "VENT" }, { "name": "Gasketed", "code": "GASK" }, { "name": "Bolted", "code": "BOLT" }, { "name": "Vaned", "code": "VANE" }, { "name": "Standard", "code": "STND" }, { "name": "Trash Rack - Conical", "code": "DEBC" }, { "name": "Trash Rack - Pipe End", "code": "DEBP" }, { "name": "Other", "code": "OTH" }, { "name": "Bi-Directional Vaned", "code": "BVAN" }, { "name": "Beehive", "code": "HIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaxFlowCapacity", "type": "esriFieldTypeString", "alias": "MaxFlowCapacity", "length": 255, "domain": null }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "OwnedBy", "length": 255, "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": 255, "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": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R6363_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_6363", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_6363", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_127335_Vault", "fields": "VaultID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_127335_Catch", "fields": "CatchBasinID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_127335_Manho", "fields": "ManholeID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "DBO.swVault", "relatedTableId": 32, "role": "esriRelRoleDestination", "keyField": "VaultID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C977FC4F-7412-4278-9240-208492CFC32A}" }, { "id": 26, "name": "DBO.swVault", "relatedTableId": 65, "role": "esriRelRoleDestination", "keyField": "VaultID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C977FC4F-7412-4278-9240-208492CFC32A}" }, { "id": 8, "name": "swManhole", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "ManholeID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9E324220-0424-412D-B000-67FE0A4B61C0}" }, { "id": 24, "name": "swManhole", "relatedTableId": 44, "role": "esriRelRoleDestination", "keyField": "ManholeID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9E324220-0424-412D-B000-67FE0A4B61C0}" }, { "id": 39, "name": "swManhole", "relatedTableId": 87, "role": "esriRelRoleDestination", "keyField": "ManholeID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9E324220-0424-412D-B000-67FE0A4B61C0}" }, { "id": 0, "name": "swCatchBasin", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "CatchBasinID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A1BF9249-F95E-458A-B1E7-D0D7BCAF661F}" }, { "id": 16, "name": "swCatchBasin", "relatedTableId": 43, "role": "esriRelRoleDestination", "keyField": "CatchBasinID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A1BF9249-F95E-458A-B1E7-D0D7BCAF661F}" }, { "id": 31, "name": "swCatchBasin", "relatedTableId": 86, "role": "esriRelRoleDestination", "keyField": "CatchBasinID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A1BF9249-F95E-458A-B1E7-D0D7BCAF661F}" } ], "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" }