{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "WaterPlant", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "3fc725696b4e4509b4dcc3e9f0544f70", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAB8AAAAYCAYAAAACqyaBAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAm5JREFUSInN1E9Ik2EAx/Hvxru9U+ecTss/4fAw+jMCa5L0hyA07CIFkf1DiJkWGHnTS6cOEXWyTlngNVaHQjykoJB4MBh5aJA1ljOdpWZzTmlr29PhddJy4HJb+Tu9z/P+nufz8vDwSvzHSL8PhBA2IUR5tjC1Wt2XFBdC2IA+3/dAWbbw8M/IW61GOpgMb1OpVGW7TEZ2X7iKJOsyCruePmZycvpALBZrjJ+AlKxY13WX3EJTRnH36PCGuaT4v8r2xp+1n8fb7+Damxk8w68Y7LJjvXKTus47PNinB6DJ8RpH03FlgVyEub6emoutVB2rTw8vNFvwAuGVFRZnvACEvs0RCi6td3IKjOvP1uYWXE/u4+13cONdAJ0+f+u4sbQCgPBqkKVPEwAsej7yY8kPQJHVhqTLXe8futxK0PMe71Af4YA/PTyveIeCB/y4BwYU3OVkdWEOgJL9toS+iEX5MuXZbNvUcJ2xEAD/5ykILYIsQyhEYHYaAGN5ZUJ/+N4tQm4XABq9IU28QMF9H5QNqy9dZ7y3m4VJNwCGktKEfng1iLW5nT0NZ8gxFKSJ5yuXyT0yCEBFzVHGe7vxjY0o703FCf1Ttx9iqrJstm1quHbtwoQmxgEotuwFYHZsSMHXTmYrSRmPJ29nBeaTp/EOvlTwTY42LVyjlTE3nGX56yzIWnR6A5WHT7A8Pw+AbDAiojGKqo8AoFarM4cDnHv0PGFca++g1t6RMGd/MZoy+ld4trL98P7OFpC0GYXiP56kuEql6gHahBAZRf+IMxKJOJPhTiFEjRCiMVtyNBrt0Wg0vg14/AMA54ZVWcovcL7ICxzhpdQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 23, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 913696.0689356625, "ymin": 564786.8891686574, "xmax": 913696.0689356625, "ymax": 564786.8891686574, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "WaterTreatmentPlant", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WaterTreatmentPlant", "type": "esriFieldTypeString", "alias": "WaterTreatmentPlant", "length": 50, "domain": null }, { "name": "WTP_ID", "type": "esriFieldTypeString", "alias": "WTP_ID", "length": 50, "domain": null }, { "name": "Legacy_ID", "type": "esriFieldTypeString", "alias": "Legacy_ID", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R104_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G152WTP_ID", "fields": "WTP_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S4_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "System", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "WTP_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 1, "name": "System Valves", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "cdc364aea01852c1d95eb94d31929c59", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA0FJREFUOI2t1F1Ik1EYB/D/2ftu+rp3s5lSM6nAgR+5NsoYqaNMozBGmJbOCxlGQVHRxZbZhRKVIooEuQvnkCzRvDHNeZNlhlb0ATZStKKh+TGa2tI50pxbN21p2wqhB87V85wf5zzng8Z/DvpvSbFYnGS1WpMBbAawAGAUwBMAzvWARCwWF8jlm27s3SvjpqZKmcjIDez370tLo6PWhfb2p5iddfR2d7/VAZj4FyhQqRSmnJx9Sbm5+yL4fGZ1jqtQJLAnTqRjePjzsdLS+sw3byZPjo2NPQgG8lQqxXOFIiGxsPAQhxAScEuEECQmbuNVV5+P3L1b075jhzh7aMja4QcWFOyv02gOS0JDQzitrT3IyzuAYKjN9g0NDSYMDjaRixf1DUNDVpl3+14wViDgH8vM3BNKCEFfnxnBUJvNjtraNmi1agiFYSgrKxTRNOdWc3NPtg88e/Zo8alTR4TeyUqlLCD65Ysdev1vDAASErYRLpdKB8AH4KQBYG7OkRUXt3XNSv5EbTY79Pr7azBvT1WqFGZkZDDz5UtrBw0AHA4lYBieX6+8qNFowvi4DTqdGgJBmF9dTEwUTyaT7/SBFMWhAnYfgEQSg8bGh1AqpWBZJmBNSAgPQiEb5euhx+N2BSqcmppFXV07bt48h4GBD0EPan7eieVl15gPjI7eODk9PRceFRW+CpuBwdAJna4ALMtAqZShv/8d7t3rQX7+WtRs/uSyWOyPfKBIxN59/XqkIitLAQCYnJxBfX0ndLp8rH4taWlSPHv2Di0tj6FWZ4AQAqdzEWbzR0dnZ6/ZB166ZKy6cOHo5bQ0abjD4YTRaPLDvJGaKgUhxId2db1AfPz2am/ee7FX5PLYM1VVzXdpmqK0WjX4/NCABwAAKSlJIISgsrIJDseSpby8ueJPEEVFNS23b+vkExPTWrfbzQmq/QqK4sBuX5hhWV4yAI8fCAAaTVVxa2vZ++vX79RmZOxikpPjEREh9OVdrhVYLFNoa+t1MwzzSiQKSy8paVxcbfj9h3l5Vxu6uw1NX7+O1xgMpmy7fT6Sy6W5Ho97xeVyL0okWwYkkpgrx49f6w+08oA/9sGDp38AOPdrrCt+AhgIOENbRKQOAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904916.713134829, "ymin": 559843.7163122371, "xmax": 942086.210646078, "ymax": 578892.8363504037, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_piSystemValveType", "description": "List of system valves types", "codedValues": [ { "name": "Air Release", "code": "Air Release" }, { "name": "Ball", "code": "Ball" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Cone", "code": "Cone" }, { "name": "Gate", "code": "Gate" }, { "name": "Gate and Plug", "code": "Gate and Plug" }, { "name": "Gate Tapping", "code": "Gate Tapping" }, { "name": "Other", "code": "Other" }, { "name": "Post Indicator Valve", "code": "PIV" }, { "name": "Plug", "code": "Plug" }, { "name": "Post Indicator Valve", "code": "PostInd" }, { "name": "Roundway", "code": "Roundway" }, { "name": "Shut Off", "code": "Shut Off" }, { "name": "Tapping", "code": "Tapping" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Backflow Control", "code": "Backflow Control" }, { "name": "Double Check", "code": "Double Check" }, { "name": "Pressure Reducer", "code": "Pressure Reducer" }, { "name": "Double Detector Check Valve", "code": "DDVC" }, { "name": "Flushing Valve", "code": "Flushing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BYPASSVALVE", "type": "esriFieldTypeSmallInteger", "alias": "Bypass Valve", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OPERABLE", "type": "esriFieldTypeSmallInteger", "alias": "Operable", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HYDRFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Hydrant Valve", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TURNSTOCLOSE", "type": "esriFieldTypeInteger", "alias": "Turns To Close", "domain": null }, { "name": "CLOCKTOCLOSE", "type": "esriFieldTypeSmallInteger", "alias": "Clockwise To Close", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "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": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R177_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S134_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 2, "name": "Hydrants", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "ea25ed94e7cecde915d2e5ee72a32bda", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAg9JREFUSInNlE1rE1EUhh+nk97SBoW0FSfUWC3BhQurVsSiWBCEYF1IIC1+UfE/iGJLwbYLF7pz7UJEG1u6KLosuqgbDQiuNItgBcfPwVgbuWkaXQzVmZtMMm1Dybu6nPee8wznnjM6myS9rkBCiNtSyv0e9j3gQU1AUspDwAkP+5mfGvXVus0EBWIhON4ObTr8Ab5KmLNgzqKlJqDzBokzYfbFO0HX3N7VAsxkGHj0mdSMydS6QVcMBq93M9EVZFs5P6BDIsruAwbjAdiSNHnsBzSseC1nI1zqChKu9DEA0SB7z4W5kzQ5CCw5rDQwqYLGnMmXDYh1VEP8V38nHRczXLtvucJPyoFcOhoCTXmT3wV4+tE+nw5DkyO7QYNeAxTQP3mCtgdLY7MLMJCyz1NHIB5Rcpq8qlUA6Q3eSWCPuKpAhdHytH7K0lh/BB4CGnbrVGUL6wC9y0Kx6H6nZh0G95S/v1KE9Dd/oOdOY/YD4qRBz7Ed/v4e819YnvzEKyC/GhNCvJFSloD6nIkpCe9z4saunLy5sxll/txa+MVyZlGMvJXyljO+ClFBJbqQkhPJXtFoLsnhnlY0ddxXivDyO/nMohgbeu2GqKralsQLORoPEetr53C0FbY22vEfeUhnYd7kbtKS49Xq+Or/tEVu2mMRAW9nraBaqO5AeaDMCgNQYU3XDjrl896GQRvWX+EhjQyKtP8AAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904910.867017914, "ymin": 559839.696635239, "xmax": 942090.5082096606, "ymax": 580022.029958159, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "domain": { "type": "codedValue", "name": "WS2_wHydrantManufacturer", "description": "The name of the hydrant manufacturer", "codedValues": [ { "name": "American Darling", "code": "American Darling" }, { "name": "Clow Corporation", "code": "Clow Corporation" }, { "name": "Corey", "code": "Corey" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Eddy", "code": "Eddy" }, { "name": "Iowa Valve", "code": "Iowa Valve" }, { "name": "Kennedy Valve", "code": "Kennedy Valve" }, { "name": "M&H Valve", "code": "M&H Valve" }, { "name": "M&H Valve / Dresser", "code": "M&H Valve / Dresser" }, { "name": "Mueller Company", "code": "Mueller Company" }, { "name": "Traverse City", "code": "Traverse City" }, { "name": "US Pipe", "code": "US Pipe" }, { "name": "Waterous", "code": "Waterous" }, { "name": "Wood-Matthews", "code": "Wood-Matthews" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LASTSERVICE", "type": "esriFieldTypeDate", "alias": "Last Service Date", "length": 8, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FLOW", "type": "esriFieldTypeDouble", "alias": "Flow Rate (GPM)", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "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": "ValidatedBy", "type": "esriFieldTypeInteger", "alias": "Validated By", "domain": { "type": "codedValue", "name": "WS2_Validation", "description": "Feature Location Validation", "codedValues": [ { "name": "Aerial Imagery", "code": 1 }, { "name": "Street View", "code": 2 }, { "name": "Field Verified", "code": 3 }, { "name": "GPS", "code": 4 }, { "name": "Needs Field Validation", "code": 5 }, { "name": "As_built", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "SecID", "type": "esriFieldTypeString", "alias": "SecID", "length": 12, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R176_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S133_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 3, "name": "Water Fittings", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 255, 255 ], "size": 5, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904910.8670179136, "ymin": 559839.6966352388, "xmax": 942087.4695018306, "ymax": 580022.0299581587, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "FITTINGTYPE", "type": "esriFieldTypeString", "alias": "Fitting Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piFittingType", "description": "List of infrastructure Fitting Types", "codedValues": [ { "name": "Bend", "code": "Bend" }, { "name": "Cap", "code": "Cap" }, { "name": "Coupling", "code": "Coupling" }, { "name": "Cross", "code": "Cross" }, { "name": "Expansion Joint", "code": "Expansion Joint" }, { "name": "Over Under", "code": "Over Under" }, { "name": "Reducer", "code": "Reducer" }, { "name": "Reducing Cross", "code": "Reducing Cross" }, { "name": "Reducing Tee", "code": "Reducing Tee" }, { "name": "Sleeve", "code": "Sleeve" }, { "name": "Tap", "code": "Tap" }, { "name": "Tee", "code": "Tee" }, { "name": "Transition", "code": "Transition" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "plug", "code": "plug" }, { "name": "Wye", "code": "Wye" }, { "name": "Vertical Bend", "code": "V_Bend" }, { "name": "Blowoff", "code": "Blowoff" }, { "name": "Tapping Sleeve", "code": "TappingSleeve" }, { "name": "Service Clamp", "code": "Clamp" }, { "name": "Corp. Stop", "code": "CorpStop" }, { "name": "Saddle", "code": "Saddle" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R184_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S141_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 4, "name": "Water Meters", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "ffcf9ea4e0a58977605208b137bf7616", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAqhJREFUOI2t1EtIVFEcx/HvuaP5GDQdVDRHyMTMHhSWkRHZQkuKaBNGJolpJiZqko/atMhQKwhFQ80CH2AJSisbjB4GaWAPyVwIGYjYqIubmVpjek+LabyOWrTov7rc8z+fc+7v3Htd+E/l8uchqZBNdJDGBqsbn3Gnl1Ix++9QrgxzgxZgJyDWeLBgmkeZmUUE5suRYYWz3BSdf4VMuTJTherEIDl1JUnIsBAUR8+ECs2PMV/uwRJSKJs/XhenV4VMOTJFheqWI6gRZuEXFuK8YoAJjsag7AqHtBaSI4qlMlgmkp2hFOmjGqh/cJhBL08io2qh/zxsDdeh+QWIrYD0zdCZh4i8QRIXZaPjMe2QiboIVzmZGCciH3XbJ1Z1QE2uDnW+AuuC/To0GMr3Iu68494AmHVII75onxgE/AC2eEDtMFz9Av6+9sl1z2GHUYdPxkFRtwzmkvSkVMw6MvKO343maNrkBWZ3uNsBxadgdBz6vsK5bfB9Ts/MZBDS+oNooMsBKb7eiKXh5sRBejvkJ0JTJ2RuByGdD8BoQAbNsM6qn5rURsfFt43r9aaEGDA+hLZnUNMPPYXQaHGG1HmEqvBJz0gy0fgE15I0vUlR4MIeSLXAsQAI8nNGhkZgBiRV9C5CbppovjZAVgmMAItvUHICfBiBtIOsqFvt8qcR3ttQtEXIVkURuWQcL8N6Zj9msOflbYTbeSuRrjcs1A8Lg03jhOPe74yEhpSxbWP0Gl7Qd7+IUMBnOVCQBJaXzB5qwsMIWbYKMbQMAipFHzkyunWMrtYC6VoWJd4mHmBtoD+BU9OInn6mKp5i7JnGwyhJVStFw9JFnL/+StEH0tctW5QX98rk4tcEgFAADZhDwYJKhq1BTC7f7Sr/I6HZqigAClaO/bl+Acew3yUVKzVQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 905231.5464946628, "ymin": 561074.0009251535, "xmax": 937095.1746964119, "ymax": 576151.7794965729, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "ACCOUNTID", "type": "esriFieldTypeString", "alias": "Account Number", "length": 30, "domain": null }, { "name": "METSERVICE", "type": "esriFieldTypeString", "alias": "Metered Service", "length": 5, "domain": { "type": "codedValue", "name": "WS2_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "Service Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_wServicePointType", "description": "The type of service point", "codedValues": [ { "name": "Domestic", "code": "Domestic" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Industrial", "code": "Industrial" }, { "name": "Fire", "code": "Fire" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "CRITICAL", "type": "esriFieldTypeSmallInteger", "alias": "CriticalCustomer", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Meter size", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R180_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S137_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 5, "name": "Miami Dade Meters", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "STRUCTTYPE", "field2": null, "field3": null, "defaultSymbol": { "type": "esriPMS", "url": "94e5a744d2b8a14feea73647c6604d88", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAWCAYAAAAxSueLAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAQNJREFUSIljYaAjYBkwy/7//7+ZgYFBkormz2JkZJyFYdm/f/9mMjAw+Lz6ycBw9tQJqtjkYGUx89+/f8+ZmJg2o1jGyMgoxcDAwND9goFhdXMHg0ttP0UWbavLZti5aRuDLi8jPKSwxhkrFw+DoJwiRZaxcfJgiA1cAsEHnpw9zvD753escgLS8gyC8srUs+zMoqkMdzYuxSrnPXUVdS2jBhi1bNQy6lgWMHEJA8PEJfSxjBoAq2WPb1xlOLNgCkUGv7h9jTjLcneep8giBgYGBpOEHNyW/fnzJ52FheVMtzxVK88tWCtPVlbWZwwMDFK/f/+WopZNUDPhACMY0RVQEwAAKtZBxAkcDxAAAAAASUVORK5CYII=", "contentType": "image/png", "width": 20, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "826840cc90ad681d8253d0200adc7b5c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAgxJREFUSIm1019IU2EYx/Hv8Zz557C2khhkri1Cl8LI5uzPEBL6g6ObrooRBmXWqIgMM0oyxIsgBl0VBLGLkqIwQm/csouZG2VNaqhQI7GL8lIaGbnaZhfhbNrYxtmeq8N7nuf3eTnveSUKXNLSg+kSF/IavFg+MuWae5cE4ovc0kqG+TXS+rjS8C8L4xqEuYvAMgBwt6V/pr7WalYK7L1m/fU1Og7884kKVWmB6O8oAyPPqKqsZvtWy397It8jeMeG2FGzE+PGzbkBsViMLq8D81o7jy8PoJJUq3peTQTo8jq4rwvkDizVxLchQuH3WGsbUtYTiQQPXrozjWcGTOomno4+WgV8/PyB2R/T6IpNyoCju1rpftGCc/Y8hgpjcn046KHV1k7/2z5lQF2VBXPQzvM3HtoOOYG/h3sneJXh9rByQJJUnGw6S+fgMY7sc6BRaxmbfM1BYxv6DZsyjWd3Dxq3NaIaLMEf8tO8207fqJvT+89lM5odoFFrOWO7zj3fbfQ6PdOREJaa+vwBAAcamrnpd3Ll4U9O2TopK5XzCxgqDByu7uBJ2MWeusz/f84AQM+JG3THeykpLlUOCAhskW2IQtFysyghiakj5bIOqSj9PtO+kctkPD2BjDt0dyi8B0orBZiamVwniqLi0IXEfDIkBej1Ha/EpzgfQBSFFcAnF0JeoldUwc/gD0wIjSQqPcpdAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Meter Station", "label": "Meter Station", "description": "" }, { "symbol": { "type": "esriPMS", "url": "3fc725696b4e4509b4dcc3e9f0544f70", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAB8AAAAYCAYAAAACqyaBAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAm5JREFUSInN1E9Ik2EAx/Hvxru9U+ecTss/4fAw+jMCa5L0hyA07CIFkf1DiJkWGHnTS6cOEXWyTlngNVaHQjykoJB4MBh5aJA1ljOdpWZzTmlr29PhddJy4HJb+Tu9z/P+nufz8vDwSvzHSL8PhBA2IUR5tjC1Wt2XFBdC2IA+3/dAWbbw8M/IW61GOpgMb1OpVGW7TEZ2X7iKJOsyCruePmZycvpALBZrjJ+AlKxY13WX3EJTRnH36PCGuaT4v8r2xp+1n8fb7+Damxk8w68Y7LJjvXKTus47PNinB6DJ8RpH03FlgVyEub6emoutVB2rTw8vNFvwAuGVFRZnvACEvs0RCi6td3IKjOvP1uYWXE/u4+13cONdAJ0+f+u4sbQCgPBqkKVPEwAsej7yY8kPQJHVhqTLXe8futxK0PMe71Af4YA/PTyveIeCB/y4BwYU3OVkdWEOgJL9toS+iEX5MuXZbNvUcJ2xEAD/5ykILYIsQyhEYHYaAGN5ZUJ/+N4tQm4XABq9IU28QMF9H5QNqy9dZ7y3m4VJNwCGktKEfng1iLW5nT0NZ8gxFKSJ5yuXyT0yCEBFzVHGe7vxjY0o703FCf1Ttx9iqrJstm1quHbtwoQmxgEotuwFYHZsSMHXTmYrSRmPJ29nBeaTp/EOvlTwTY42LVyjlTE3nGX56yzIWnR6A5WHT7A8Pw+AbDAiojGKqo8AoFarM4cDnHv0PGFca++g1t6RMGd/MZoy+ld4trL98P7OFpC0GYXiP56kuEql6gHahBAZRf+IMxKJOJPhTiFEjRCiMVtyNBrt0Wg0vg14/AMA54ZVWcovcL7ICxzhpdQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 23, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Treatment Plant", "label": "Treatment Plant", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 905168.6985232458, "ymin": 561899.0068210736, "xmax": 933152.797082495, "ymax": 572958.6799116582, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 20, "domain": null }, { "name": "STRUCTTYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_wStructureType", "description": "The type of water structures", "codedValues": [ { "name": "Enclosed Storage Facility", "code": "Enclosed Storage Facility" }, { "name": "Production Well", "code": "Production Well" }, { "name": "Pump Station", "code": "Pump Station" }, { "name": "Storage Basin", "code": "Storage Basin" }, { "name": "Treatment Plant", "code": "Treatment Plant" }, { "name": "Meter Station", "code": "Meter Station" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "WS2_AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R181_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S138_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 6, "name": "Water Service Lines", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DIAMETER", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "12", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "14", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "15", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "16", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "18", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "20", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "24", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "30", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "36", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "40", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "42", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "48", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "54", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "60", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "66", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "72", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "75", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 4 }, "value": "10", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 4 }, "value": "6", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 4 }, "value": "8", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "1.5", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "1.25", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "1", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "2.5", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "2", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "3", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "0.75", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "4", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "-1", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "0", "label": "4\" or less", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 905043.1265959106, "ymin": 560046.1079678237, "xmax": 942090.5082096606, "ymax": 578220.786513403, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINETYPE", "type": "esriFieldTypeString", "alias": "Line Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_wLateralType", "description": "The type of lateral line", "codedValues": [ { "name": "Hydrant", "code": "Hydrant" }, { "name": "Irrigation", "code": "Irrigation" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Domestic", "code": "Domestic" }, { "name": "Fire", "code": "Fire" }, { "name": "Industrial", "code": "Industrial" }, { "name": "Commercial", "code": "Commercial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "H_Link", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 150, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_wWaterType", "description": "The type of water flowing through pipe", "codedValues": [ { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Treated Water", "code": "Treated" }, { "name": "Detector check valve", "code": "Detector" }, { "name": "Post indicator valve", "code": "Post_ind" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "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": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL_DESC", "type": "esriFieldTypeString", "alias": "MATERIAL DESCRIPTION", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_MAT_DESC", "description": "Description of what the Asset is composed of", "codedValues": [ { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cooper", "code": "Cooper" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "High Density Polyethylene", "code": "High Density Polyethylene" }, { "name": "Not Determined", "code": "Not Determined" }, { "name": "Poly Vinyl Chloride", "code": "Poly Vinyl Chloride" }, { "name": "Polybutylene", "code": "Polybutylene" }, { "name": "Prestressed Concrete", "code": "Prestressed Concrete" }, { "name": "PVC-C900", "code": "PVC-C900" }, { "name": "Reinforced Concrete", "code": "Reinforced Concrete" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSET", "type": "esriFieldTypeString", "alias": "ASSET", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_ASSET", "description": "Assets are owned by the municipality", "codedValues": [ { "name": "Distribution", "code": "Distribution" }, { "name": "Fire Line", "code": "Fire Line" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Service Line", "code": "Service Line" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET TYPE", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_ASSET_TYPE", "description": "Description of the Asset", "codedValues": [ { "name": "Fire Line", "code": "Fire Line" }, { "name": "Fire Service", "code": "Fire Service" }, { "name": "Hydrant Lateral", "code": "Hydrant Lat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R185_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S142_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 7, "name": "Water Main In Use", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DIAMETER", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "12", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "14", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "15", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "16", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "18", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "20", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "24", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "30", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "36", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "40", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "42", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "48", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "54", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "60", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "66", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "72", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 7 }, "value": "75", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "10", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "6", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 6 }, "value": "8", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "1.5", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "1.25", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "1", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "2.5", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "2", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "3", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "0.75", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "4", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "-1", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 5 }, "value": "0", "label": "4\" or less", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904910.8670179136, "ymin": 559839.6966352388, "xmax": 942087.4695018306, "ymax": 580022.0299581587, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MATERIAL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_wWaterType", "description": "The type of water flowing through pipe", "codedValues": [ { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Treated Water", "code": "Treated" }, { "name": "Detector check valve", "code": "Detector" }, { "name": "Post indicator valve", "code": "Post_ind" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TRANSMISS", "type": "esriFieldTypeString", "alias": "Transmission System", "length": 5, "domain": { "type": "codedValue", "name": "WS2_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "H_link", "type": "esriFieldTypeString", "alias": "H_Link", "length": 150, "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": "Status", "type": "esriFieldTypeSmallInteger", "alias": "In use or abandoned", "domain": { "type": "codedValue", "name": "WS2_AssetStatus", "description": "In use or abandoned", "codedValues": [ { "name": "Abandoned", "code": 0 }, { "name": "In use", "code": 1 }, { "name": "Unknown", "code": 2 }, { "name": "By-Pass", "code": 3 }, { "name": "Removed", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL_DESC", "type": "esriFieldTypeString", "alias": "MATERIAL DESCRIPTION", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_MAT_DESC", "description": "Description of what the Asset is composed of", "codedValues": [ { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cooper", "code": "Cooper" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "High Density Polyethylene", "code": "High Density Polyethylene" }, { "name": "Not Determined", "code": "Not Determined" }, { "name": "Poly Vinyl Chloride", "code": "Poly Vinyl Chloride" }, { "name": "Polybutylene", "code": "Polybutylene" }, { "name": "Prestressed Concrete", "code": "Prestressed Concrete" }, { "name": "PVC-C900", "code": "PVC-C900" }, { "name": "Reinforced Concrete", "code": "Reinforced Concrete" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSET", "type": "esriFieldTypeString", "alias": "ASSET", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_ASSET", "description": "Assets are owned by the municipality", "codedValues": [ { "name": "Distribution", "code": "Distribution" }, { "name": "Fire Line", "code": "Fire Line" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Service Line", "code": "Service Line" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET TYPE", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_ASSET_TYPE", "description": "Description of the Asset", "codedValues": [ { "name": "Fire Line", "code": "Fire Line" }, { "name": "Fire Service", "code": "Fire Service" }, { "name": "Hydrant Lateral", "code": "Hydrant Lat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R175_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S132_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 8, "name": "Water Main Abandoned", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DIAMETER", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "12", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "14", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "15", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "16", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "18", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "20", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "24", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "30", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "36", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "40", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "42", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "48", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "54", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "60", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "66", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "72", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 5 }, "value": "75", "label": "12\" or more", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 3 }, "value": "10", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 3 }, "value": "6", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 3 }, "value": "8", "label": "6\" to 10\"", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "1.5", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "1.25", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "1", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "2.5", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "2", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "3", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "0.75", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "4", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "-1", "label": "4\" or less", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 190, 210, 255, 255 ], "width": 1.5 }, "value": "0", "label": "4\" or less", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904910.8670179136, "ymin": 559839.6966352388, "xmax": 942087.4695018306, "ymax": 580022.0299581587, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MATERIAL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_wWaterType", "description": "The type of water flowing through pipe", "codedValues": [ { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Treated Water", "code": "Treated" }, { "name": "Detector check valve", "code": "Detector" }, { "name": "Post indicator valve", "code": "Post_ind" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TRANSMISS", "type": "esriFieldTypeString", "alias": "Transmission System", "length": 5, "domain": { "type": "codedValue", "name": "WS2_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "H_link", "type": "esriFieldTypeString", "alias": "H_Link", "length": 150, "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": "Status", "type": "esriFieldTypeSmallInteger", "alias": "In use or abandoned", "domain": { "type": "codedValue", "name": "WS2_AssetStatus", "description": "In use or abandoned", "codedValues": [ { "name": "Abandoned", "code": 0 }, { "name": "In use", "code": 1 }, { "name": "Unknown", "code": 2 }, { "name": "By-Pass", "code": 3 }, { "name": "Removed", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL_DESC", "type": "esriFieldTypeString", "alias": "MATERIAL DESCRIPTION", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_MAT_DESC", "description": "Description of what the Asset is composed of", "codedValues": [ { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cooper", "code": "Cooper" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "High Density Polyethylene", "code": "High Density Polyethylene" }, { "name": "Not Determined", "code": "Not Determined" }, { "name": "Poly Vinyl Chloride", "code": "Poly Vinyl Chloride" }, { "name": "Polybutylene", "code": "Polybutylene" }, { "name": "Prestressed Concrete", "code": "Prestressed Concrete" }, { "name": "PVC-C900", "code": "PVC-C900" }, { "name": "Reinforced Concrete", "code": "Reinforced Concrete" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSET", "type": "esriFieldTypeString", "alias": "ASSET", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_ASSET", "description": "Assets are owned by the municipality", "codedValues": [ { "name": "Distribution", "code": "Distribution" }, { "name": "Fire Line", "code": "Fire Line" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Service Line", "code": "Service Line" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET TYPE", "length": 30, "domain": { "type": "codedValue", "name": "WS2_WLD_ASSET_TYPE", "description": "Description of the Asset", "codedValues": [ { "name": "Fire Line", "code": "Fire Line" }, { "name": "Fire Service", "code": "Fire Service" }, { "name": "Hydrant Lateral", "code": "Hydrant Lat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R175_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S132_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 9, "name": "WaterServiceLocation", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103022, "latestWkid": 6438 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 46, 138, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904924.6799824117, "ymin": 559750.7499627392, "xmax": 939345.8316124136, "ymax": 578950.9067723243, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ST_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LPROP_ID", "type": "esriFieldTypeDouble", "alias": "LPROP_ID", "domain": null }, { "name": "ADDRESSID", "type": "esriFieldTypeDouble", "alias": "ADDRESSID", "domain": null }, { "name": "FOLIO", "type": "esriFieldTypeString", "alias": "FOLIO", "length": 13, "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null }, { "name": "HSE_NUM", "type": "esriFieldTypeInteger", "alias": "HSE_NUM", "domain": null }, { "name": "PRE_DIR", "type": "esriFieldTypeString", "alias": "PRE_DIR", "length": 2, "domain": null }, { "name": "ST_NAME", "type": "esriFieldTypeString", "alias": "ST_NAME", "length": 20, "domain": null }, { "name": "ST_TYPE", "type": "esriFieldTypeString", "alias": "ST_TYPE", "length": 4, "domain": null }, { "name": "SUF_DIR", "type": "esriFieldTypeString", "alias": "SUF_DIR", "length": 2, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeInteger", "alias": "ZIP", "domain": null }, { "name": "PLUS4", "type": "esriFieldTypeSmallInteger", "alias": "PLUS4", "domain": null }, { "name": "MUNIC", "type": "esriFieldTypeSmallInteger", "alias": "MUNIC", "domain": null }, { "name": "MAILING_MU", "type": "esriFieldTypeString", "alias": "MAILING_MU", "length": 25, "domain": null }, { "name": "SNAME", "type": "esriFieldTypeString", "alias": "SNAME", "length": 42, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "UID", "type": "esriFieldTypeString", "alias": "UID", "length": 50, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R105_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S5_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.81, "id": 10, "name": "PSWaterCW.DBO.wtpAreationUnit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "Legacy", "type": "esriFieldTypeString", "alias": "Legacy", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R88_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G136System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "System", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 11, "name": "PSWaterCW.DBO.wtpCamera", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R89_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G137System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "System", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 12, "name": "PSWaterCW.DBO.wtpFlushingPort", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R90_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G138Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "wtpSludge", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 13, "name": "PSWaterCW.DBO.wtpGate", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R91_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G139Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Position", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 14, "name": "PSWaterCW.DBO.wtpGearBox", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R92_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G140System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "System", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 15, "name": "PSWaterCW.DBO.wtpGenerator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R93_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G141System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "System", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 16, "name": "PSWaterCW.DBO.wtpIntercome", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R94_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G142Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Position", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 17, "name": "PSWaterCW.DBO.wtpMotor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "Manufacturer Date", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MotorType", "type": "esriFieldTypeString", "alias": "MotorType", "length": 50, "domain": null }, { "name": "Walts", "type": "esriFieldTypeSmallInteger", "alias": "Walts", "domain": null }, { "name": "HorsePower", "type": "esriFieldTypeDouble", "alias": "HorsePower", "domain": null }, { "name": "Volts", "type": "esriFieldTypeSmallInteger", "alias": "Volts", "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "AMP", "type": "esriFieldTypeDouble", "alias": "AMP", "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R96_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G144Position_ID", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "wtpWell", "relatedTableId": 26, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "wtpSystem", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "wtpSludge", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 18, "name": "PSWaterCW.DBO.wtpPLC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R97_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G145Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "Position", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 19, "name": "PSWaterCW.DBO.wtpPosition", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Position", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 20, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 30, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "PositionStatus", "type": "esriFieldTypeString", "alias": "PositionStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_PositionStatus", "description": "PositionStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Out of Service", "code": "Out of Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R98_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G146Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G146System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Gate", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "Intercome", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "PLC", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "wtpPump", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "System", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "wtpChemicalTreatment", "relatedTableId": 28, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 20, "name": "PSWaterCW.DBO.wtpPump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "Manufacturer Date", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PumpType", "type": "esriFieldTypeString", "alias": "PumpType", "length": 50, "domain": null }, { "name": "HorsePower", "type": "esriFieldTypeDouble", "alias": "HorsePower", "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null }, { "name": "GPM", "type": "esriFieldTypeSmallInteger", "alias": "GPM", "domain": null }, { "name": "MGD", "type": "esriFieldTypeSmallInteger", "alias": "MGD", "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R99_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G147Position_ID", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "wtpWell", "relatedTableId": 26, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 16, "name": "wtpChemicalTreatment", "relatedTableId": 28, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "wtpPosition", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "wtpSludge", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 21, "name": "PSWaterCW.DBO.wtpStorage", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "TankType", "type": "esriFieldTypeString", "alias": "TankType", "length": 50, "domain": null }, { "name": "Capacity", "type": "esriFieldTypeString", "alias": "Capacity", "length": 50, "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null } ], "indexes": [ { "name": "R100_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G148System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "System", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 22, "name": "PSWaterCW.DBO.wtpSystem", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "System", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WTP_ID", "type": "esriFieldTypeString", "alias": "WTP_ID", "length": 20, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R101_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G149System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G149WTP_ID", "fields": "WTP_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I149System", "fields": "System", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "AreationUnit", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Camera", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "GearBox", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "Generator", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "Position", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 18, "name": "Storage", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 19, "name": "wtpAnalyzer", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "wtpWell", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 21, "name": "wtpFilter", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "wtpChemicalTreatment", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "wtpMotor", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "wtpSludge", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "WaterPlant", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "WTP_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 23, "name": "PSWaterCW.DBO.wtpTimer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R102_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G150Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 24, "name": "wtpSludge", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 24, "name": "PSWaterCW.DBO.wtpValve", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "Manufacturer Date", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R103_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G151Position_ID", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 25, "name": "wtpWell", "relatedTableId": 26, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 26, "name": "wtpFilter", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 25, "name": "PSWaterCW.DBO.wtpAnalyzer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Createdby", "type": "esriFieldTypeString", "alias": "Createdby", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "MFR", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "MFRModel", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeString", "alias": "MFRDate", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "Volts", "type": "esriFieldTypeSmallInteger", "alias": "Volts", "domain": null }, { "name": "AMPs", "type": "esriFieldTypeDouble", "alias": "AMPs", "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "Cycles", "type": "esriFieldTypeSmallInteger", "alias": "Cycles", "domain": null }, { "name": "Walts", "type": "esriFieldTypeSmallInteger", "alias": "Walts", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 50, "domain": null } ], "indexes": [ { "name": "R95_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G143System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "wtpSystem", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 26, "name": "PSWaterCW.DBO.wtpWell", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Feature", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R109_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_575_Feature_", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "wtpPump", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "wtpMotor", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 25, "name": "wtpValve", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "wtpSystem", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 27, "name": "PSWaterCW.DBO.wtpFilter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Feature", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R110_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_580_System_I", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_580_Feature_", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 26, "name": "wtpValve", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 21, "name": "wtpSystem", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 28, "name": "PSWaterCW.DBO.wtpChemicalTreatment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Feature", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R111_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_981_System_I", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_981_Feature_", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "wtpPump", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "wtpPosition", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "wtpSystem", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 29, "name": "PSWaterCW.DBO.wtpSludge", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Feature", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Feature", "type": "esriFieldTypeString", "alias": "Feature", "length": 50, "domain": null }, { "name": "Feature_ID", "type": "esriFieldTypeString", "alias": "Feature_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R113_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_989_System_I", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_989_Feature_", "fields": "Feature_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "wtpMotor", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "wtpPump", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "wtpFlushingPort", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 24, "name": "wtpTimer", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "Feature_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "wtpSystem", "relatedTableId": 22, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null } ] }