{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "Inspected Valves (OK)", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103117, "latestWkid": 6537 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "df462d86fff1ae61a79cc6afdad6e639", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAFFJREFUOI1jYaARYIExwv6zO/9l+ClJqYHMDOx3VzH+PA43+D/Dz0omBgZnSg3+///nQgYGBoTB1AajBo8aPGrwqMGjBg8yg1czMrjQxGBqAwCPAg9e7P1DNwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 16, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 694975.6924107671, "ymin": 1616349.7884590104, "xmax": 732861.1569524333, "ymax": 1689169.0611149818, "spatialReference": { "wkid": 103117, "latestWkid": 6537 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "gisqbywater.DBO.testvalves.Size", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "gisqbywater.DBO.testvalves.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "gisqbywater.DBO.testvalves.Size", "type": "esriFieldTypeString", "alias": "Size", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Brand", "type": "esriFieldTypeString", "alias": "Brand", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Year_Insta", "type": "esriFieldTypeString", "alias": "Year_Insta", "length": 10, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Open_Direc", "type": "esriFieldTypeString", "alias": "Open_Direc", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 40, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Number_Tur", "type": "esriFieldTypeString", "alias": "Number_Tur", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Repairs", "type": "esriFieldTypeString", "alias": "Repairs", "length": 40, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Depth", "type": "esriFieldTypeSingle", "alias": "Depth", "domain": null }, { "name": "gisqbywater.DBO.testvalves.Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Photo", "type": "esriFieldTypeString", "alias": "Photo", "length": 230, "domain": null }, { "name": "gisqbywater.DBO.testvalves.GNSS_Heigh", "type": "esriFieldTypeDouble", "alias": "GNSS_Heigh", "domain": null }, { "name": "gisqbywater.DBO.testvalves.Updated", "type": "esriFieldTypeString", "alias": "Updated", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.LABEL", "type": "esriFieldTypeString", "alias": "LABEL", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "gisqbywater.DBO.testvalves.ID_NO", "type": "esriFieldTypeSmallInteger", "alias": "ID_NO", "domain": null }, { "name": "gisqbywater.DBO.valvereltable.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VALVEID", "type": "esriFieldTypeSmallInteger", "alias": "VALVEID", "domain": null }, { "name": "gisqbywater.DBO.valvereltable.CREW_ONE", "type": "esriFieldTypeString", "alias": "CREW_ONE", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 1", "description": "Crew Member 1", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.CREW_TWO", "type": "esriFieldTypeString", "alias": "CREW_TWO", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 2", "description": "Crew Member 2", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VBOX_LOC", "type": "esriFieldTypeString", "alias": "VBOX_LOC", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Location", "description": "Valve Box Location", "codedValues": [ { "name": "Intersection", "code": "Intersection" }, { "name": "Edge of Paved Road", "code": "Edge of Paved Road" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "ROW", "code": "ROW" }, { "name": "Near Hydrant", "code": "Near Hydrant" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VBOXL_CMNT", "type": "esriFieldTypeString", "alias": "VBOX_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VBOX_SUR", "type": "esriFieldTypeString", "alias": "VBOX_SUR", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Surface", "description": "Valve Box Surface", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Dirt/Grass", "code": "Dirt/Grass" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Wet Area", "code": "Wet Area" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VBOXS_CMNT", "type": "esriFieldTypeString", "alias": "VBOXS_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.REP_BOX", "type": "esriFieldTypeString", "alias": "REP_BOX", "length": 50, "domain": { "type": "codedValue", "name": "Repair Box/Cap", "description": "Repair Box/Cap", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.REPBX_CMNT", "type": "esriFieldTypeString", "alias": "REPBX_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VAC", "type": "esriFieldTypeString", "alias": "VAC", "length": 50, "domain": { "type": "codedValue", "name": "Vacuum", "description": "Vacuum", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VAC_CMNT", "type": "esriFieldTypeString", "alias": "VAC_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.NUT_ACC", "type": "esriFieldTypeString", "alias": "NUT_ACC", "length": 50, "domain": { "type": "codedValue", "name": "Nut Accessible", "description": "Nut Accessible", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.NUTA_CMNT", "type": "esriFieldTypeString", "alias": "NUTA_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VAL_OP", "type": "esriFieldTypeString", "alias": "VAL_OP", "length": 50, "domain": { "type": "codedValue", "name": "Valve Operational", "description": "Valve Operational", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VALOP_CMNT", "type": "esriFieldTypeString", "alias": "VALOP_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "gisqbywater.DBO.testvalves.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R7_pk", "fields": "gisqbywater.DBO.testvalves.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4_ID_NO", "fields": "gisqbywater.DBO.testvalves.ID_NO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S2_idx", "fields": "gisqbywater.DBO.testvalves.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R8_SDE_ROWID_UK", "fields": "gisqbywater.DBO.valvereltable.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13_VALVEID", "fields": "gisqbywater.DBO.valvereltable.VALVEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "gisqbywater.DBO.valvereltable", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "ID_NO", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "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, "serviceItemId": "d55d87d449a84bf18cdf84b1fa7af1ab" }, { "currentVersion": 10.91, "id": 1, "name": "Inspected Valves (Follow up)", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103117, "latestWkid": 6537 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "880d4ff21ab534e949ac46091b767d82", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAE9JREFUOI3tzLENgCAYBeEjIflncB5cynGYhikc5FVYSeyBxOJdddWX2VR+p0cUpGNajLiT1AaMdAFl1u1SBT7w4gwbNmzY8M/gBOcWeHUPpHgOpUwAIj8AAAAASUVORK5CYII=", "contentType": "image/png", "width": 16, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 694975.6924107671, "ymin": 1616349.7884590104, "xmax": 732861.1569524333, "ymax": 1689169.0611149818, "spatialReference": { "wkid": 103117, "latestWkid": 6537 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "gisqbywater.DBO.testvalves.Size", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "gisqbywater.DBO.testvalves.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "gisqbywater.DBO.testvalves.Size", "type": "esriFieldTypeString", "alias": "Size", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Brand", "type": "esriFieldTypeString", "alias": "Brand", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Year_Insta", "type": "esriFieldTypeString", "alias": "Year_Insta", "length": 10, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Open_Direc", "type": "esriFieldTypeString", "alias": "Open_Direc", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 40, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Number_Tur", "type": "esriFieldTypeString", "alias": "Number_Tur", "length": 60, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Repairs", "type": "esriFieldTypeString", "alias": "Repairs", "length": 40, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Depth", "type": "esriFieldTypeSingle", "alias": "Depth", "domain": null }, { "name": "gisqbywater.DBO.testvalves.Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Photo", "type": "esriFieldTypeString", "alias": "Photo", "length": 230, "domain": null }, { "name": "gisqbywater.DBO.testvalves.GNSS_Heigh", "type": "esriFieldTypeDouble", "alias": "GNSS_Heigh", "domain": null }, { "name": "gisqbywater.DBO.testvalves.Updated", "type": "esriFieldTypeString", "alias": "Updated", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.LABEL", "type": "esriFieldTypeString", "alias": "LABEL", "length": 50, "domain": null }, { "name": "gisqbywater.DBO.testvalves.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "gisqbywater.DBO.testvalves.ID_NO", "type": "esriFieldTypeSmallInteger", "alias": "ID_NO", "domain": null }, { "name": "gisqbywater.DBO.valvereltable.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VALVEID", "type": "esriFieldTypeSmallInteger", "alias": "VALVEID", "domain": null }, { "name": "gisqbywater.DBO.valvereltable.CREW_ONE", "type": "esriFieldTypeString", "alias": "CREW_ONE", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 1", "description": "Crew Member 1", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.CREW_TWO", "type": "esriFieldTypeString", "alias": "CREW_TWO", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 2", "description": "Crew Member 2", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VBOX_LOC", "type": "esriFieldTypeString", "alias": "VBOX_LOC", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Location", "description": "Valve Box Location", "codedValues": [ { "name": "Intersection", "code": "Intersection" }, { "name": "Edge of Paved Road", "code": "Edge of Paved Road" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "ROW", "code": "ROW" }, { "name": "Near Hydrant", "code": "Near Hydrant" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VBOXL_CMNT", "type": "esriFieldTypeString", "alias": "VBOX_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VBOX_SUR", "type": "esriFieldTypeString", "alias": "VBOX_SUR", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Surface", "description": "Valve Box Surface", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Dirt/Grass", "code": "Dirt/Grass" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Wet Area", "code": "Wet Area" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VBOXS_CMNT", "type": "esriFieldTypeString", "alias": "VBOXS_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.REP_BOX", "type": "esriFieldTypeString", "alias": "REP_BOX", "length": 50, "domain": { "type": "codedValue", "name": "Repair Box/Cap", "description": "Repair Box/Cap", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.REPBX_CMNT", "type": "esriFieldTypeString", "alias": "REPBX_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VAC", "type": "esriFieldTypeString", "alias": "VAC", "length": 50, "domain": { "type": "codedValue", "name": "Vacuum", "description": "Vacuum", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VAC_CMNT", "type": "esriFieldTypeString", "alias": "VAC_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.NUT_ACC", "type": "esriFieldTypeString", "alias": "NUT_ACC", "length": 50, "domain": { "type": "codedValue", "name": "Nut Accessible", "description": "Nut Accessible", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.NUTA_CMNT", "type": "esriFieldTypeString", "alias": "NUTA_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.VAL_OP", "type": "esriFieldTypeString", "alias": "VAL_OP", "length": 50, "domain": { "type": "codedValue", "name": "Valve Operational", "description": "Valve Operational", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gisqbywater.DBO.valvereltable.VALOP_CMNT", "type": "esriFieldTypeString", "alias": "VALOP_CMNT", "length": 150, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "gisqbywater.DBO.valvereltable.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "gisqbywater.DBO.testvalves.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R7_pk", "fields": "gisqbywater.DBO.testvalves.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4_ID_NO", "fields": "gisqbywater.DBO.testvalves.ID_NO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S2_idx", "fields": "gisqbywater.DBO.testvalves.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R8_SDE_ROWID_UK", "fields": "gisqbywater.DBO.valvereltable.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13_VALVEID", "fields": "gisqbywater.DBO.valvereltable.VALVEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "gisqbywater.DBO.valvereltable", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "ID_NO", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "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, "serviceItemId": "d55d87d449a84bf18cdf84b1fa7af1ab" } ], "tables": [ { "currentVersion": 10.91, "id": 2, "name": "gisqbywater.DBO.valvereltable", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CREW_ONE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "VALVEID", "type": "esriFieldTypeSmallInteger", "alias": "VALVEID", "domain": null }, { "name": "CREW_ONE", "type": "esriFieldTypeString", "alias": "CREW_ONE", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 1", "description": "Crew Member 1", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREW_TWO", "type": "esriFieldTypeString", "alias": "CREW_TWO", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 2", "description": "Crew Member 2", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VBOX_LOC", "type": "esriFieldTypeString", "alias": "VBOX_LOC", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Location", "description": "Valve Box Location", "codedValues": [ { "name": "Intersection", "code": "Intersection" }, { "name": "Edge of Paved Road", "code": "Edge of Paved Road" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "ROW", "code": "ROW" }, { "name": "Near Hydrant", "code": "Near Hydrant" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VBOXL_CMNT", "type": "esriFieldTypeString", "alias": "VBOX_CMNT", "length": 150, "domain": null }, { "name": "VBOX_SUR", "type": "esriFieldTypeString", "alias": "VBOX_SUR", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Surface", "description": "Valve Box Surface", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Dirt/Grass", "code": "Dirt/Grass" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Wet Area", "code": "Wet Area" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VBOXS_CMNT", "type": "esriFieldTypeString", "alias": "VBOXS_CMNT", "length": 150, "domain": null }, { "name": "REP_BOX", "type": "esriFieldTypeString", "alias": "REP_BOX", "length": 50, "domain": { "type": "codedValue", "name": "Repair Box/Cap", "description": "Repair Box/Cap", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPBX_CMNT", "type": "esriFieldTypeString", "alias": "REPBX_CMNT", "length": 150, "domain": null }, { "name": "VAC", "type": "esriFieldTypeString", "alias": "VAC", "length": 50, "domain": { "type": "codedValue", "name": "Vacuum", "description": "Vacuum", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VAC_CMNT", "type": "esriFieldTypeString", "alias": "VAC_CMNT", "length": 150, "domain": null }, { "name": "NUT_ACC", "type": "esriFieldTypeString", "alias": "NUT_ACC", "length": 50, "domain": { "type": "codedValue", "name": "Nut Accessible", "description": "Nut Accessible", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUTA_CMNT", "type": "esriFieldTypeString", "alias": "NUTA_CMNT", "length": 150, "domain": null }, { "name": "VAL_OP", "type": "esriFieldTypeString", "alias": "VAL_OP", "length": 50, "domain": { "type": "codedValue", "name": "Valve Operational", "description": "Valve Operational", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALOP_CMNT", "type": "esriFieldTypeString", "alias": "VALOP_CMNT", "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 } ], "indexes": [ { "name": "R8_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13_VALVEID", "fields": "VALVEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "gisqbywater.DBO.testvalves", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "VALVEID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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, "serviceItemId": "d55d87d449a84bf18cdf84b1fa7af1ab" } ] }