{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "Sewer Customers", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 3753, "latestWkid": 3753, "vcsWkid": 5703, "latestVcsWkid": 5703 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 211, 255, 190, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 48, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2058627.8573473096, "ymin": 482236.593969807, "xmax": 2192591.134695798, "ymax": 587785.3763101399, "spatialReference": { "wkid": 3753, "latestWkid": 3753, "vcsWkid": 5703, "latestVcsWkid": 5703 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "countylayers.DBO.parcel.SUBDV_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "countylayers.DBO.parcel.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "countylayers.DBO.parcel.AREA", "type": "esriFieldTypeDouble", "alias": "AREA", "domain": null }, { "name": "countylayers.DBO.parcel.PERIMETER", "type": "esriFieldTypeDouble", "alias": "PERIMETER", "domain": null }, { "name": "countylayers.DBO.parcel.PLY_", "type": "esriFieldTypeDouble", "alias": "PLY_", "domain": null }, { "name": "countylayers.DBO.parcel.PLY_ID", "type": "esriFieldTypeDouble", "alias": "PLY_ID", "domain": null }, { "name": "countylayers.DBO.parcel.TDN", "type": "esriFieldTypeString", "alias": "TDN", "length": 3, "domain": null }, { "name": "countylayers.DBO.parcel.BKN", "type": "esriFieldTypeString", "alias": "BKN", "length": 3, "domain": null }, { "name": "countylayers.DBO.parcel.PGN", "type": "esriFieldTypeString", "alias": "PGN", "length": 2, "domain": null }, { "name": "countylayers.DBO.parcel.SPN", "type": "esriFieldTypeString", "alias": "SPN", "length": 3, "domain": null }, { "name": "countylayers.DBO.parcel.PPN_MODIFI", "type": "esriFieldTypeString", "alias": "PPN_MODIFI", "length": 1, "domain": null }, { "name": "countylayers.DBO.parcel.STAR", "type": "esriFieldTypeInteger", "alias": "STAR", "domain": null }, { "name": "countylayers.DBO.parcel.SUBDV_LOT_", "type": "esriFieldTypeString", "alias": "SUBDV_LOT_", "length": 6, "domain": null }, { "name": "countylayers.DBO.parcel.CITY_LOT_", "type": "esriFieldTypeString", "alias": "CITY_LOT_", "length": 5, "domain": null }, { "name": "countylayers.DBO.parcel.VILLAGE_LO", "type": "esriFieldTypeString", "alias": "VILLAGE_LO", "length": 5, "domain": null }, { "name": "countylayers.DBO.parcel.DEED_ACRE", "type": "esriFieldTypeDouble", "alias": "DEED_ACRE", "domain": null }, { "name": "countylayers.DBO.parcel.LOT_FLG", "type": "esriFieldTypeSmallInteger", "alias": "LOT_FLG", "domain": null }, { "name": "countylayers.DBO.parcel.SUBDV_NAME", "type": "esriFieldTypeString", "alias": "SUBDV_NAME", "length": 120, "domain": null }, { "name": "countylayers.DBO.parcel.R_O_W", "type": "esriFieldTypeSmallInteger", "alias": "R_O_W", "domain": null }, { "name": "countylayers.DBO.parcel.DATE1", "type": "esriFieldTypeDate", "alias": "DATE1", "length": 8, "domain": null }, { "name": "countylayers.DBO.parcel.DATE2", "type": "esriFieldTypeDate", "alias": "DATE2", "length": 8, "domain": null }, { "name": "countylayers.DBO.parcel.ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "countylayers.DBO.parcel.FIRST_", "type": "esriFieldTypeString", "alias": "FIRST_", "length": 6, "domain": null }, { "name": "countylayers.DBO.parcel.SECOND_", "type": "esriFieldTypeString", "alias": "SECOND_", "length": 6, "domain": null }, { "name": "countylayers.DBO.parcel.LAKE", "type": "esriFieldTypeString", "alias": "LAKE", "length": 30, "domain": null }, { "name": "countylayers.DBO.parcel.RIVER", "type": "esriFieldTypeString", "alias": "RIVER", "length": 30, "domain": null }, { "name": "countylayers.DBO.parcel.LOCK__ID", "type": "esriFieldTypeDouble", "alias": "LOCK__ID", "domain": null }, { "name": "countylayers.DBO.parcel.PHASE__ID", "type": "esriFieldTypeInteger", "alias": "PHASE__ID", "domain": null }, { "name": "countylayers.DBO.parcel.OBJECT__ID", "type": "esriFieldTypeDouble", "alias": "OBJECT__ID", "domain": null }, { "name": "countylayers.DBO.parcel.PPNPLUS", "type": "esriFieldTypeString", "alias": "PPNPLUS", "length": 12, "domain": null }, { "name": "countylayers.DBO.parcel.PPN", "type": "esriFieldTypeString", "alias": "PPN", "length": 11, "domain": null }, { "name": "countylayers.DBO.parcel.PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 26, "domain": null }, { "name": "countylayers.DBO.parcel.RECNO", "type": "esriFieldTypeDouble", "alias": "RECNO", "domain": null }, { "name": "countylayers.DBO.parcel.OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 200, "domain": null }, { "name": "countylayers.DBO.parcel.PERCENT_", "type": "esriFieldTypeString", "alias": "PERCENT_", "length": 24, "domain": null }, { "name": "countylayers.DBO.parcel.TOT_OWNERS", "type": "esriFieldTypeString", "alias": "TOT_OWNERS", "length": 2, "domain": null }, { "name": "countylayers.DBO.parcel.NUMBER", "type": "esriFieldTypeString", "alias": "NUMBER", "length": 13, "domain": null }, { "name": "countylayers.DBO.parcel.ROAD", "type": "esriFieldTypeString", "alias": "ROAD", "length": 50, "domain": null }, { "name": "countylayers.DBO.parcel.STRUCTURE", "type": "esriFieldTypeString", "alias": "STRUCTURE", "length": 12, "domain": null }, { "name": "countylayers.DBO.parcel.TOT_ADDS", "type": "esriFieldTypeString", "alias": "TOT_ADDS", "length": 2, "domain": null }, { "name": "countylayers.DBO.parcel.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "mcse.DBO.sewer_customers.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "mcse.DBO.sewer_customers.CustomerID", "type": "esriFieldTypeInteger", "alias": "CustomerID", "domain": null }, { "name": "mcse.DBO.sewer_customers.AccountNo", "type": "esriFieldTypeInteger", "alias": "AccountNo", "domain": null }, { "name": "mcse.DBO.sewer_customers.CustomerType", "type": "esriFieldTypeString", "alias": "CustomerType", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.PersonFName", "type": "esriFieldTypeString", "alias": "PersonFName", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.PersonLName_BusinessName", "type": "esriFieldTypeString", "alias": "PersonLName/BusinessName", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.CustomerAdrs1", "type": "esriFieldTypeString", "alias": "CustomerAdrs1", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.City", "type": "esriFieldTypeString", "alias": "City", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.State", "type": "esriFieldTypeString", "alias": "State", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.LocationID", "type": "esriFieldTypeInteger", "alias": "LocationID", "domain": null }, { "name": "mcse.DBO.sewer_customers.LocationNo", "type": "esriFieldTypeInteger", "alias": "LocationNo", "domain": null }, { "name": "mcse.DBO.sewer_customers.ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.ServiceAddress", "type": "esriFieldTypeString", "alias": "ServiceAddress", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.LocationCity", "type": "esriFieldTypeString", "alias": "LocationCity", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.LocationState", "type": "esriFieldTypeString", "alias": "LocationState", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.LocationZIP", "type": "esriFieldTypeString", "alias": "LocationZIP", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.ServiceName", "type": "esriFieldTypeString", "alias": "ServiceName", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.ERU", "type": "esriFieldTypeDouble", "alias": "ERU", "domain": null }, { "name": "mcse.DBO.sewer_customers.Active", "type": "esriFieldTypeString", "alias": "Active", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": null }, { "name": "mcse.DBO.sewer_customers.Route", "type": "esriFieldTypeString", "alias": "Route", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.sewer_customers.BillingCycle", "type": "esriFieldTypeInteger", "alias": "BillingCycle", "domain": null }, { "name": "mcse.DBO.sewer_customers.PumpStation", "type": "esriFieldTypeInteger", "alias": "PumpStation", "domain": null }, { "name": "mcse.DBO.sewer_customers.WaterSystem", "type": "esriFieldTypeString", "alias": "WaterSystem", "length": 1073741822, "domain": null } ], "geometryField": { "name": "countylayers.DBO.parcel.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1728_pk", "fields": "countylayers.DBO.parcel.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1138_idx", "fields": "countylayers.DBO.parcel.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R1858_SDE_ROWID_UK", "fields": "mcse.DBO.sewer_customers.OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "28659617f7714668bc55c949803a4c7b" }, { "currentVersion": 10.81, "id": 1, "name": "Water Customers", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 3753, "latestWkid": 3753, "vcsWkid": 5703, "latestVcsWkid": 5703 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 190, 232, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 31, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2058627.8573473096, "ymin": 482236.593969807, "xmax": 2192591.134695798, "ymax": 587785.3763101399, "spatialReference": { "wkid": 3753, "latestWkid": 3753, "vcsWkid": 5703, "latestVcsWkid": 5703 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "countylayers.DBO.parcel.SUBDV_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "countylayers.DBO.parcel.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "countylayers.DBO.parcel.AREA", "type": "esriFieldTypeDouble", "alias": "AREA", "domain": null }, { "name": "countylayers.DBO.parcel.PERIMETER", "type": "esriFieldTypeDouble", "alias": "PERIMETER", "domain": null }, { "name": "countylayers.DBO.parcel.PLY_", "type": "esriFieldTypeDouble", "alias": "PLY_", "domain": null }, { "name": "countylayers.DBO.parcel.PLY_ID", "type": "esriFieldTypeDouble", "alias": "PLY_ID", "domain": null }, { "name": "countylayers.DBO.parcel.TDN", "type": "esriFieldTypeString", "alias": "TDN", "length": 3, "domain": null }, { "name": "countylayers.DBO.parcel.BKN", "type": "esriFieldTypeString", "alias": "BKN", "length": 3, "domain": null }, { "name": "countylayers.DBO.parcel.PGN", "type": "esriFieldTypeString", "alias": "PGN", "length": 2, "domain": null }, { "name": "countylayers.DBO.parcel.SPN", "type": "esriFieldTypeString", "alias": "SPN", "length": 3, "domain": null }, { "name": "countylayers.DBO.parcel.PPN_MODIFI", "type": "esriFieldTypeString", "alias": "PPN_MODIFI", "length": 1, "domain": null }, { "name": "countylayers.DBO.parcel.STAR", "type": "esriFieldTypeInteger", "alias": "STAR", "domain": null }, { "name": "countylayers.DBO.parcel.SUBDV_LOT_", "type": "esriFieldTypeString", "alias": "SUBDV_LOT_", "length": 6, "domain": null }, { "name": "countylayers.DBO.parcel.CITY_LOT_", "type": "esriFieldTypeString", "alias": "CITY_LOT_", "length": 5, "domain": null }, { "name": "countylayers.DBO.parcel.VILLAGE_LO", "type": "esriFieldTypeString", "alias": "VILLAGE_LO", "length": 5, "domain": null }, { "name": "countylayers.DBO.parcel.DEED_ACRE", "type": "esriFieldTypeDouble", "alias": "DEED_ACRE", "domain": null }, { "name": "countylayers.DBO.parcel.LOT_FLG", "type": "esriFieldTypeSmallInteger", "alias": "LOT_FLG", "domain": null }, { "name": "countylayers.DBO.parcel.SUBDV_NAME", "type": "esriFieldTypeString", "alias": "SUBDV_NAME", "length": 120, "domain": null }, { "name": "countylayers.DBO.parcel.R_O_W", "type": "esriFieldTypeSmallInteger", "alias": "R_O_W", "domain": null }, { "name": "countylayers.DBO.parcel.DATE1", "type": "esriFieldTypeDate", "alias": "DATE1", "length": 8, "domain": null }, { "name": "countylayers.DBO.parcel.DATE2", "type": "esriFieldTypeDate", "alias": "DATE2", "length": 8, "domain": null }, { "name": "countylayers.DBO.parcel.ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "countylayers.DBO.parcel.FIRST_", "type": "esriFieldTypeString", "alias": "FIRST_", "length": 6, "domain": null }, { "name": "countylayers.DBO.parcel.SECOND_", "type": "esriFieldTypeString", "alias": "SECOND_", "length": 6, "domain": null }, { "name": "countylayers.DBO.parcel.LAKE", "type": "esriFieldTypeString", "alias": "LAKE", "length": 30, "domain": null }, { "name": "countylayers.DBO.parcel.RIVER", "type": "esriFieldTypeString", "alias": "RIVER", "length": 30, "domain": null }, { "name": "countylayers.DBO.parcel.LOCK__ID", "type": "esriFieldTypeDouble", "alias": "LOCK__ID", "domain": null }, { "name": "countylayers.DBO.parcel.PHASE__ID", "type": "esriFieldTypeInteger", "alias": "PHASE__ID", "domain": null }, { "name": "countylayers.DBO.parcel.OBJECT__ID", "type": "esriFieldTypeDouble", "alias": "OBJECT__ID", "domain": null }, { "name": "countylayers.DBO.parcel.PPNPLUS", "type": "esriFieldTypeString", "alias": "PPNPLUS", "length": 12, "domain": null }, { "name": "countylayers.DBO.parcel.PPN", "type": "esriFieldTypeString", "alias": "PPN", "length": 11, "domain": null }, { "name": "countylayers.DBO.parcel.PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 26, "domain": null }, { "name": "countylayers.DBO.parcel.RECNO", "type": "esriFieldTypeDouble", "alias": "RECNO", "domain": null }, { "name": "countylayers.DBO.parcel.OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 200, "domain": null }, { "name": "countylayers.DBO.parcel.PERCENT_", "type": "esriFieldTypeString", "alias": "PERCENT_", "length": 24, "domain": null }, { "name": "countylayers.DBO.parcel.TOT_OWNERS", "type": "esriFieldTypeString", "alias": "TOT_OWNERS", "length": 2, "domain": null }, { "name": "countylayers.DBO.parcel.NUMBER", "type": "esriFieldTypeString", "alias": "NUMBER", "length": 13, "domain": null }, { "name": "countylayers.DBO.parcel.ROAD", "type": "esriFieldTypeString", "alias": "ROAD", "length": 50, "domain": null }, { "name": "countylayers.DBO.parcel.STRUCTURE", "type": "esriFieldTypeString", "alias": "STRUCTURE", "length": 12, "domain": null }, { "name": "countylayers.DBO.parcel.TOT_ADDS", "type": "esriFieldTypeString", "alias": "TOT_ADDS", "length": 2, "domain": null }, { "name": "countylayers.DBO.parcel.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "mcse.DBO.water_customers.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "mcse.DBO.water_customers.CustomerID", "type": "esriFieldTypeInteger", "alias": "CustomerID", "domain": null }, { "name": "mcse.DBO.water_customers.AccountNo", "type": "esriFieldTypeInteger", "alias": "AccountNo", "domain": null }, { "name": "mcse.DBO.water_customers.CustomerType", "type": "esriFieldTypeString", "alias": "CustomerType", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.PersonFName", "type": "esriFieldTypeString", "alias": "PersonFName", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.PersonLName_BusinessName", "type": "esriFieldTypeString", "alias": "PersonLName/BusinessName", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.CustomerAdrs1", "type": "esriFieldTypeString", "alias": "CustomerAdrs1", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.City", "type": "esriFieldTypeString", "alias": "City", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.State", "type": "esriFieldTypeString", "alias": "State", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.LocationID", "type": "esriFieldTypeInteger", "alias": "LocationID", "domain": null }, { "name": "mcse.DBO.water_customers.LocationNo", "type": "esriFieldTypeInteger", "alias": "LocationNo", "domain": null }, { "name": "mcse.DBO.water_customers.ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.ServiceAddress", "type": "esriFieldTypeString", "alias": "ServiceAddress", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.LocationCity", "type": "esriFieldTypeString", "alias": "LocationCity", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.LocationState", "type": "esriFieldTypeString", "alias": "LocationState", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.LocationZIP", "type": "esriFieldTypeString", "alias": "LocationZIP", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.ServiceName", "type": "esriFieldTypeString", "alias": "ServiceName", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.Active", "type": "esriFieldTypeString", "alias": "Active", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": null }, { "name": "mcse.DBO.water_customers.Route", "type": "esriFieldTypeString", "alias": "Route", "length": 1073741822, "domain": null }, { "name": "mcse.DBO.water_customers.BillingCycle", "type": "esriFieldTypeInteger", "alias": "BillingCycle", "domain": null }, { "name": "mcse.DBO.water_customers.PumpStation", "type": "esriFieldTypeInteger", "alias": "PumpStation", "domain": null }, { "name": "mcse.DBO.water_customers.WaterSystem", "type": "esriFieldTypeString", "alias": "WaterSystem", "length": 1073741822, "domain": null } ], "geometryField": { "name": "countylayers.DBO.parcel.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1728_pk", "fields": "countylayers.DBO.parcel.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1138_idx", "fields": "countylayers.DBO.parcel.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R1859_SDE_ROWID_UK", "fields": "mcse.DBO.water_customers.OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "28659617f7714668bc55c949803a4c7b" } ], "tables": [ { "currentVersion": 10.81, "id": 2, "name": "mcse.DBO.water_customers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PersonFName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeInteger", "alias": "CustomerID", "domain": null }, { "name": "AccountNo", "type": "esriFieldTypeInteger", "alias": "AccountNo", "domain": null }, { "name": "CustomerType", "type": "esriFieldTypeString", "alias": "CustomerType", "length": 1073741822, "domain": null }, { "name": "PersonFName", "type": "esriFieldTypeString", "alias": "PersonFName", "length": 1073741822, "domain": null }, { "name": "PersonLName_BusinessName", "type": "esriFieldTypeString", "alias": "PersonLName/BusinessName", "length": 1073741822, "domain": null }, { "name": "CustomerAdrs1", "type": "esriFieldTypeString", "alias": "CustomerAdrs1", "length": 1073741822, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 1073741822, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 1073741822, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 1073741822, "domain": null }, { "name": "LocationID", "type": "esriFieldTypeInteger", "alias": "LocationID", "domain": null }, { "name": "LocationNo", "type": "esriFieldTypeInteger", "alias": "LocationNo", "domain": null }, { "name": "ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "length": 1073741822, "domain": null }, { "name": "ServiceAddress", "type": "esriFieldTypeString", "alias": "ServiceAddress", "length": 1073741822, "domain": null }, { "name": "LocationCity", "type": "esriFieldTypeString", "alias": "LocationCity", "length": 1073741822, "domain": null }, { "name": "LocationState", "type": "esriFieldTypeString", "alias": "LocationState", "length": 1073741822, "domain": null }, { "name": "LocationZIP", "type": "esriFieldTypeString", "alias": "LocationZIP", "length": 1073741822, "domain": null }, { "name": "ServiceName", "type": "esriFieldTypeString", "alias": "ServiceName", "length": 1073741822, "domain": null }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "length": 1073741822, "domain": null }, { "name": "Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 1073741822, "domain": null }, { "name": "BillingCycle", "type": "esriFieldTypeInteger", "alias": "BillingCycle", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeInteger", "alias": "PumpStation", "domain": null }, { "name": "WaterSystem", "type": "esriFieldTypeString", "alias": "WaterSystem", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R1859_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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 }, "serviceItemId": "28659617f7714668bc55c949803a4c7b" }, { "currentVersion": 10.81, "id": 3, "name": "mcse.DBO.sewer_customers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PersonFName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeInteger", "alias": "CustomerID", "domain": null }, { "name": "AccountNo", "type": "esriFieldTypeInteger", "alias": "AccountNo", "domain": null }, { "name": "CustomerType", "type": "esriFieldTypeString", "alias": "CustomerType", "length": 1073741822, "domain": null }, { "name": "PersonFName", "type": "esriFieldTypeString", "alias": "PersonFName", "length": 1073741822, "domain": null }, { "name": "PersonLName_BusinessName", "type": "esriFieldTypeString", "alias": "PersonLName/BusinessName", "length": 1073741822, "domain": null }, { "name": "CustomerAdrs1", "type": "esriFieldTypeString", "alias": "CustomerAdrs1", "length": 1073741822, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 1073741822, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 1073741822, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 1073741822, "domain": null }, { "name": "LocationID", "type": "esriFieldTypeInteger", "alias": "LocationID", "domain": null }, { "name": "LocationNo", "type": "esriFieldTypeInteger", "alias": "LocationNo", "domain": null }, { "name": "ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "length": 1073741822, "domain": null }, { "name": "ServiceAddress", "type": "esriFieldTypeString", "alias": "ServiceAddress", "length": 1073741822, "domain": null }, { "name": "LocationCity", "type": "esriFieldTypeString", "alias": "LocationCity", "length": 1073741822, "domain": null }, { "name": "LocationState", "type": "esriFieldTypeString", "alias": "LocationState", "length": 1073741822, "domain": null }, { "name": "LocationZIP", "type": "esriFieldTypeString", "alias": "LocationZIP", "length": 1073741822, "domain": null }, { "name": "ServiceName", "type": "esriFieldTypeString", "alias": "ServiceName", "length": 1073741822, "domain": null }, { "name": "ERU", "type": "esriFieldTypeDouble", "alias": "ERU", "domain": null }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "length": 1073741822, "domain": null }, { "name": "Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 1073741822, "domain": null }, { "name": "BillingCycle", "type": "esriFieldTypeInteger", "alias": "BillingCycle", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeInteger", "alias": "PumpStation", "domain": null }, { "name": "WaterSystem", "type": "esriFieldTypeString", "alias": "WaterSystem", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R1858_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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 }, "serviceItemId": "28659617f7714668bc55c949803a4c7b" } ] }