{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 59, "name": "Media / Plans", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "media_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "media_table", "type": "esriFieldTypeString", "alias": "media_table", "length": 200, "domain": { "type": "codedValue", "name": "LayerName", "description": "", "codedValues": [ { "name": "Catch Basins", "code": "tbl_catch_basins" }, { "name": "Feed Points", "code": "tbl_feed_points" }, { "name": "Flare Ends", "code": "tbl_flare_ends" }, { "name": "Gate Valves", "code": "tbl_gate_valves" }, { "name": "Hydrants", "code": "tbl_hydrants" }, { "name": "Inspection Projects", "code": "tbl_inspection_projects" }, { "name": "Lift Stations", "code": "tbl_lift_stations" }, { "name": "Light Lines", "code": "tbl_light_lines" }, { "name": "Lights", "code": "tbl_lights" }, { "name": "Parcels", "code": "tbl_parcels" }, { "name": "Plantings", "code": "tbl_plantings_forestry" }, { "name": "PRV's", "code": "tbl_pressure_relief_valves" }, { "name": "Private Trees", "code": "tbl_private_trees" }, { "name": "Sanitary Manholes", "code": "tbl_sanitary_manholes" }, { "name": "Sanitary Sewers", "code": "tbl_sanitary_sewers" }, { "name": "Signals", "code": "tbl_signals" }, { "name": "Signs", "code": "tbl_signs" }, { "name": "Storm Manholes", "code": "tbl_storm_manholes" }, { "name": "Storm Sewers", "code": "tbl_storm_sewers" }, { "name": "Stormwater Ponds", "code": "tbl_stormwater_ponds" }, { "name": "Streets", "code": "tbl_streets" }, { "name": "Structures", "code": "tbl_structures" }, { "name": "Trails & Paths", "code": "tbl_trails_paths" }, { "name": "Trees", "code": "tbl_trees" }, { "name": "Water Breaks", "code": "tbl_water_breaks" }, { "name": "Water Mains", "code": "tbl_water_lines" }, { "name": "Water Towers", "code": "tbl_water_towers" }, { "name": "Wells", "code": "tbl_wells" }, { "name": "Force Mains", "code": "tbl_force_mains" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "media_table_id", "type": "esriFieldTypeInteger", "alias": "media_table_id", "domain": null }, { "name": "media_name", "type": "esriFieldTypeString", "alias": "media_name", "length": 100, "domain": null }, { "name": "media_date_added", "type": "esriFieldTypeDate", "alias": "media_date_added", "length": 8, "domain": null }, { "name": "media_user_id", "type": "esriFieldTypeInteger", "alias": "media_user_id", "domain": null }, { "name": "media_path", "type": "esriFieldTypeString", "alias": "media_path", "length": 1073741822, "domain": null }, { "name": "media_notes", "type": "esriFieldTypeString", "alias": "media_notes", "length": 1073741822, "domain": null }, { "name": "media_table_sid", "type": "esriFieldTypeString", "alias": "media_table_sid", "length": 100, "domain": null }, { "name": "media_type", "type": "esriFieldTypeString", "alias": "media_type", "length": 50, "domain": { "type": "codedValue", "name": "media_type_1_1", "description": "Media Type", "codedValues": [ { "name": "Building Inspector Curb Tie", "code": "Building Inspector Curb Tie" }, { "name": "Can Not Find Curb Tie", "code": "Can Not Find Curb Tie" }, { "name": "Curb Tie", "code": "Curb Tie" }, { "name": "JPG Image", "code": "JPG Image" }, { "name": "PDF", "code": "PDF" }, { "name": "Plat", "code": "Plat" }, { "name": "PNG Image", "code": "PNG Image" }, { "name": "Survey", "code": "Survey" }, { "name": "TIF Image", "code": "TIF Image" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "media_media_type_id", "type": "esriFieldTypeInteger", "alias": "media_media_type_id", "domain": null }, { "name": "media_table_id_integer", "type": "esriFieldTypeInteger", "alias": "media_table_id_integer", "domain": null }, { "name": "relfeatureglobalid", "type": "esriFieldTypeGUID", "alias": "relfeatureglobalid", "length": 38, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "length": 38, "domain": null }, { "name": "userenter", "type": "esriFieldTypeString", "alias": "Entered By", "length": 255, "domain": { "type": "codedValue", "name": "userenter_1", "description": "User Entered", "codedValues": [ { "name": "Bob Moore", "code": "Bob Moore" }, { "name": "Brian Bachmeier", "code": "Brian Bachmeier" }, { "name": "Chris Buntjer", "code": "Chris Buntjer" }, { "name": "Connor Papenfuss", "code": "Connor Papenfuss" }, { "name": "Dan Determan", "code": "Dan Determan" }, { "name": "Dane Neska", "code": "Dane Neska" }, { "name": "Jake Knoepfler", "code": "Jake Knoepfler" }, { "name": "Jeremy Quinzon", "code": "Jeremy Quinzon" }, { "name": "Jim Romanik", "code": "Jim Romanik" }, { "name": "Kelly Armstrong", "code": "Kelly Armstrong" }, { "name": "Loren Cota", "code": "Loren Cota" }, { "name": "Mike Kothe", "code": "Mike Kothe" }, { "name": "Miranda Williams", "code": "Miranda Williams" }, { "name": "Reade Damlo", "code": "Reade Damlo" }, { "name": "Steve Schloegel", "code": "Steve Schloegel" }, { "name": "Terry Lang", "code": "Terry Lang" }, { "name": "Trent Wirkus", "code": "Trent Wirkus" }, { "name": "Wade Madsen", "code": "Wade Madsen" }, { "name": "Street Department", "code": "Street Department" }, { "name": "Environmental Services Department", "code": "Environmental Services Department" }, { "name": "Parks Department", "code": "Parks Department" }, { "name": "Neil Hiatt", "code": "Neil Hiatt" }, { "name": "Tim Mehlhorn", "code": "Tim Mehlhorn" }, { "name": "Nate Burlingame", "code": "Nate Burlingame" }, { "name": "GIS Admin", "code": "GIS Admin" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "media_type_usage", "type": "esriFieldTypeString", "alias": "Media Type Usage", "length": 255, "domain": { "type": "codedValue", "name": "media_type_usage", "description": "Media Type Usage", "codedValues": [ { "name": "Curb Tie", "code": "Curb Tie" }, { "name": "Plat", "code": "Plat" }, { "name": "Asbuilt", "code": "Asbuilt" }, { "name": "Survey", "code": "Survey" }, { "name": "Document", "code": "Document" }, { "name": "Plan", "code": "Plan" }, { "name": "Can Not Find Curb Tie", "code": "Can Not Find Curb Tie" }, { "name": "Building Inspector Curb Tie", "code": "Building Inspector Curb Tie" }, { "name": "Photo", "code": "Photo" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "gdb_25206_relfea", "fields": "relfeatureglobalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r420_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_420", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 95, "name": "sde.sde.tbl_private_trees", "relatedTableId": 28, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{72969ACC-97E3-4A63-860C-6C518EF3E01B}" }, { "id": 24, "name": "sde.sde.tbl_wells", "relatedTableId": 43, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1087116E-DF42-4CEE-B50E-0BD2B86A0082}" }, { "id": 19, "name": "sde.sde.tbl_gate_valves", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{98166402-5F10-433B-BF64-3A405C155682}" }, { "id": 53, "name": "sde.sde.tbl_stormwater_ponds", "relatedTableId": 44, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{54E4532D-7618-4561-BC14-CDFAC8AC06FE}" }, { "id": 32, "name": "sde.sde.tbl_flare_ends", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E0B77B9D-0EF5-4170-9B10-4C41DB244FE2}" }, { "id": 103, "name": "sde.sde.tbl_plantings_forestry", "relatedTableId": 30, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7B36F434-B584-4CB2-BBF2-C876D8BF4467}" }, { "id": 7, "name": "sde.sde.tbl_water_breaks", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECBCB4A6-DAA3-4557-A5AD-0EE1965427E1}" }, { "id": 31, "name": "sde.sde.tbl_storm_manholes", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1FFFD8FA-EBFE-4810-ACBB-6E53DA366E52}" }, { "id": 41, "name": "sde.sde.tbl_storm_sewers", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A7A5EA58-C88B-403C-9922-6F5249B0D405}" }, { "id": 3, "name": "sde.sde.tbl_water_towers", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B8022F0D-B6AC-41D7-A035-55D86844BB4F}" }, { "id": 54, "name": "sde.sde.tbl_sanitary_manholes", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8C9573F2-67F2-428D-B20F-67973C48F1B3}" }, { "id": 15, "name": "sde.sde.tbl_hydrants", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B0545D34-B4E7-4A6B-BD9A-F3034509748A}" }, { "id": 93, "name": "sde.sde.tbl_signs", "relatedTableId": 26, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C7437047-3BE4-40E3-86C5-205AEC3FD88C}" }, { "id": 99, "name": "sde.sde.tbl_trees", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{430AB091-FDD6-48E5-92B2-52BD44B44AA5}" }, { "id": 23, "name": "sde.sde.tbl_water_lines", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7EBAB273-814B-416E-B1AF-DCC756D8F2A7}" }, { "id": 116, "name": "sde.sde.tbl_parcels", "relatedTableId": 32, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E12E513D-F245-47BC-A4CA-15962D79838B}" }, { "id": 61, "name": "sde.sde.tbl_lift_stations", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{362978DA-87A1-4660-8C66-74E9E260413D}" }, { "id": 36, "name": "sde.sde.tbl_catch_basins", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AC65023B-001A-4517-BF28-708F42E75B06}" }, { "id": 82, "name": "sde.sde.tbl_fiber_optics", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B2804635-2887-4C4D-8C47-207466A91FCE}" }, { "id": 69, "name": "sde.sde.tbl_force_mains", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A764348D-875B-4FCC-ADC0-07BA4ABF5E24}" }, { "id": 108, "name": "sde.sde.tbl_streets", "relatedTableId": 31, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A37CCDAE-06C1-4954-8F40-BBCD080F43DA}" }, { "id": 86, "name": "sde.sde.tbl_signals", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{91537070-A12D-439D-96F9-5C9C3C8ACFEA}" }, { "id": 8, "name": "sde.sde.tbl_pressure_relief_valves", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0F3C7DAF-4D49-4E57-9F5C-16ACA9331166}" }, { "id": 45, "name": "sde.sde.tbl_storm_vaults", "relatedTableId": 60, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8E43D7EF-0FB2-4CE3-9255-734B57974C6F}" }, { "id": 62, "name": "sde.sde.tbl_sanitary_sewers", "relatedTableId": 17, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7B3BC585-4410-4FB8-AD8D-5EBFDBFD9029}" }, { "id": 73, "name": "sde.sde.tbl_lights", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CB849B1F-1910-4ABE-A714-3163B040306A}" }, { "id": 78, "name": "sde.sde.tbl_light_lines", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C19E6492-9F9F-49D9-9FD3-3045AD1107D3}" }, { "id": 77, "name": "sde.sde.tbl_feed_points", "relatedTableId": 41, "role": "esriRelRoleDestination", "keyField": "relfeatureglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C5EE7A80-057C-4137-8182-1AB12A97417C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "4f369977157d42fab6a6538e28a4504a" }