{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Water Service", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "xyUnits": 3.7240637144144125E7, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 112, 255, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6999999999999998 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.Permit"}, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "stackLabel": true, "stackRowLength": 24, "stackAlignment": "dynamic", "removeDuplicates": "none", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 2244822.699069798, "ymin": 694958.0765659213, "xmax": 2377157.311719969, "ymax": 800052.2608310133, "spatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Permit", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_12", "type": "esriFieldTypeOID", "alias": "OBJECTID_12", "domain": null }, { "name": "FID_", "type": "esriFieldTypeInteger", "alias": "FID_", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "AcctNumber", "type": "esriFieldTypeString", "alias": "AcctNumber", "length": 254, "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "ParcelID", "length": 254, "domain": null }, { "name": "AMPM", "type": "esriFieldTypeString", "alias": "AM or PM", "length": 254, "domain": { "type": "codedValue", "name": "Ut_Inspect_Time", "description": "AM or PM", "codedValues": [ { "name": "AM", "code": "AM" }, { "name": "PM", "code": "PM" }, { "name": "Anytime", "code": "Any" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 254, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 30, "domain": null }, { "name": "Special_Note", "type": "esriFieldTypeString", "alias": "Investigation Note", "length": 254, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner Name", "length": 254, "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null }, { "name": "med_X", "type": "esriFieldTypeDouble", "alias": "med_X", "domain": null }, { "name": "med_Y", "type": "esriFieldTypeDouble", "alias": "med_Y", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 20, "domain": null }, { "name": "PermitStatus", "type": "esriFieldTypeString", "alias": "PermitStatus", "length": 50, "domain": { "type": "codedValue", "name": "UtInspectionStatus", "description": "For Service Point", "codedValues": [ { "name": "Connected", "code": "Con" }, { "name": "Scheduled", "code": "Sch" }, { "name": "Permitted", "code": "Per" }, { "name": "Cut and Cap", "code": "CutC" }, { "name": "Abandoned", "code": "Abdn" }, { "name": "Idle", "code": "ID" }, { "name": "Disconnected", "code": "Dis" }, { "name": "Inspected", "code": "Insp" }, { "name": "Carry Over", "code": "Cov" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspSchDate", "type": "esriFieldTypeDate", "alias": "Scheduled Date", "length": 8, "domain": null }, { "name": "Permit", "type": "esriFieldTypeString", "alias": "Permit", "length": 50, "domain": null }, { "name": "Link", "type": "esriFieldTypeString", "alias": "Link", "length": 150, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Inspection_Type", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 50, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": { "type": "codedValue", "name": "UtInspector", "description": "Inspector", "codedValues": [ { "name": "K. McCloskey", "code": "KM" }, { "name": "S. Rigby", "code": "SR" }, { "name": "B. Cook", "code": "BC" }, { "name": "L. Crosby", "code": "LC" }, { "name": "M. Donovan", "code": "MD" }, { "name": "B. Palmer", "code": "BP" }, { "name": "J. Ihlenfield", "code": "JI" }, { "name": "None", "code": "N" }, { "name": "Jim L.", "code": "JL" }, { "name": "M. Nesselrotte", "code": "MN" }, { "name": "Stephens", "code": "MS" }, { "name": "Thompson", "code": "JT" }, { "name": "Woodford", "code": "DW" }, { "name": "L. Hietanen", "code": "LS" }, { "name": "J. Pizzi", "code": "JP" }, { "name": "T. Collins", "code": "TC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Meter_Owner", "type": "esriFieldTypeSmallInteger", "alias": "Meter Owner", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "LCDU", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BookPage", "type": "esriFieldTypeString", "alias": "Book and Page", "length": 50, "domain": null }, { "name": "Contact_No", "type": "esriFieldTypeString", "alias": "Contact Number", "length": 15, "domain": null }, { "name": "Investigation_Nature", "type": "esriFieldTypeString", "alias": "Nature of Investigation", "length": 50, "domain": { "type": "codedValue", "name": "Ut_Nature_Investigation", "description": "Nature of Investigation", "codedValues": [ { "name": "Turn On Water", "code": "turn on" }, { "name": "Turn Off Water", "code": "turn off" }, { "name": "Inspection", "code": "inspection" }, { "name": "Meter Set and Turn On", "code": "meter set and turn on" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Meter_Location", "type": "esriFieldTypeString", "alias": "Meter Location", "length": 50, "domain": null }, { "name": "Meter_Size", "type": "esriFieldTypeString", "alias": "Meter Size", "length": 50, "domain": null }, { "name": "Lat_Long", "type": "esriFieldTypeString", "alias": "Lat_Long", "length": 200, "domain": null }, { "name": "Tap_Size", "type": "esriFieldTypeString", "alias": "Tap Size", "length": 50, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 150, "domain": null }, { "name": "Inspection_Deposit", "type": "esriFieldTypeDouble", "alias": "Inspection Deposit", "domain": null }, { "name": "Credit", "type": "esriFieldTypeDouble", "alias": "Credit", "domain": null }, { "name": "Connection_Type", "type": "esriFieldTypeString", "alias": "Connection Type", "length": 50, "domain": { "type": "codedValue", "name": "UtInspResidential", "description": "Res - nonRes", "codedValues": [ { "name": "Apartment", "code": "Apartment" }, { "name": "Non-Residential", "code": "NonResidential" }, { "name": "Condo", "code": "Condo" }, { "name": "Duplex", "code": "Duplex" }, { "name": "Residential", "code": "Residential" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "UUID_16", "fields": "GlobalID,OBJECTID_12", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I14ParcelID", "fields": "ParcelID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G14Permit", "fields": "Permit", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G14AcctNumber", "fields": "AcctNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Water Inspections", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Water Permit", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Billing Service Account", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "AcctNumber", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746704472000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Water Permit", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "f992359ba09c65ce25504a3abe6901bf", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAqElEQVQokaWSyxHDIAwF9+AqaAOXYeqgDMZl4DaSMkIbriOHSB7ZI8jvXWSwVjyQJv7Q5OwloABN1kHiBtxGcJU4O0UrsADZgytwv1Y3yuKqagGFk8QeiPm/ABFoCpeO1Z6DBzAr3AbJnhr4r/2pgsJhmOaAwP7LycdBCm+YFrxRkfwD1hYkxu2KJv/0YBlniozVIt/r1bYtEHn18evZRiAdmADsvTs8ASmoHwty9BlAAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -81.21571809699998, "ymin": 41.75689971800006, "xmax": 2377069.5620163265, "ymax": 798426.8652565051, "spatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayFieldExpressionInfo": { "expression": "$feature.ConnectionType+\":\"+$feature.created_date", "title": "Custom" }, "displayField": "created_date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "Date Issued", "length": 8, "domain": null }, { "name": "Municipality", "type": "esriFieldTypeString", "alias": "Municipality", "length": 255, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "Parcel No.", "length": 255, "domain": null }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "Owner's Name", "length": 255, "domain": null }, { "name": "OwnerAddress", "type": "esriFieldTypeString", "alias": "Owner's Address", "length": 255, "domain": null }, { "name": "ServiceAddress", "type": "esriFieldTypeString", "alias": "Service Address", "length": 255, "domain": null }, { "name": "Sublot", "type": "esriFieldTypeString", "alias": "Sublot", "length": 255, "domain": null }, { "name": "BuildingNo", "type": "esriFieldTypeString", "alias": "Building No", "length": 255, "domain": null }, { "name": "Subdivision", "type": "esriFieldTypeString", "alias": "Subdivision", "length": 255, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Contractor", "description": "", "codedValues": [ { "name": "A.C. Rattray Construction Inc.", "code": "A.C. Rattray Construction, Inc. 7465 Jasani Ct. Mentor OH 44060" }, { "name": "AAA Flexible Pipe Cleaning Corporation", "code": "AAA Flexible Pipe Cleaning Corporation 7277 Bessemer Ave. Cleveland, OH 44127" }, { "name": "ABV Corporation", "code": "ABV Corporation 36315 Reading Ave Willoughby, OH 44094" }, { "name": "Adams Services Inc", "code": "Adams Services Inc 672 State Route 45 Austinburng, OH 44010" }, { "name": "Advanced Mechanical Contractors LLC", "code": "Advanced Mechanical Contractors LLC 37960 Depot Street Unit B Willoughby OH 44094" }, { "name": "Alba Contractors Inc", "code": "Alba Contractors Inc 8670 Twinbrook Rd Mentor OH 44060" }, { "name": "American Residential Service LLC dba Rescue Rooter", "code": "American Residential Service, LLC dba Rescue Rooter 4505 Industrial Parkway Cleveland, OH 44135" }, { "name": "Anthony Allega Cement Contractor Inc", "code": "Anthony Allega Cement Contractor Inc 5585 Canal Rd Valley View, OH 44125" }, { "name": "Barnes Earth & Turf LLC", "code": "Barnes Earth & Turf LLC 7493 S. Ridge Rd Madison, OH 44057" }, { "name": "Barone Contracting Co Inc", "code": "Barone Contracting Co Inc 552 N Lake Street Madison OH 44057" }, { "name": "Big Dig Uderground Repair Services LC", "code": "Big Dig Uderground Repair Services LC 35941 Wanaka Blvd Eastlake OH 44095" }, { "name": "Bills Sewer and Drain Cleaning LLC.", "code": "Bills Sewer and Drain Cleaning, LLC. P.O. BOX 1501 Willoughby, OH 44096" }, { "name": "Brothers Construction Inc.", "code": "Brothers Construction, Inc. 9310 Mercantile Drive Mentor OH 44060" }, { "name": "Brown Sprinkler Service Inc", "code": "Brown Sprinkler Service Inc 2458 SR 193 Dorset OH 44032" }, { "name": "Brunner Excavating Inc.", "code": "Brunner Excavating, Inc. 2084 Green Road Madison, OH 44057" }, { "name": "Camino Construction Inc", "code": "Camino Construction Inc 1548 East 367th Street Eastlake OH 44095" }, { "name": "Campbell Plumbing", "code": "Campbell Plumbing 90 River Drive Eastlake OH 44095" }, { "name": "CIR Incorporated", "code": "CIR Incorporated 2856 N County Line Rd Geneva, OH 44041-9604" }, { "name": "Ciro's Sewer Cleaning Inc", "code": "Ciro's Sewer Cleaning, Inc 37100 Research Dr. Eastlake, OH 44095" }, { "name": "Cleveland Roto Rooter LLC. DBA Mr. Rooter Plumbing", "code": "Cleveland Roto Rooter, LLC. DBA Mr. Rooter Plumbing 405 N. Brice Rd. Blacklick, OH 43004" }, { "name": "Complete Construction Site Management Co.", "code": "Complete Construction Site Management Co. 8263 Dines Road Novelty, OH 44072" }, { "name": "Davis Diggers Inc", "code": "Davis Diggers Inc 7985 King Memorial Rd Mentor OH 44060" }, { "name": "DB Bentley Inc", "code": "DB Bentley Inc 2649 Narrows Rd Painesville, OH 44077" }, { "name": "DeBoard's Benjamin Franklin Plumbing", "code": "DeBoard's Benjamin Franklin Plumbing 10020 Sherman Road Chesterland,OH 44024" }, { "name": "Difonzo Masonry & Cement Inc.", "code": "Difonzo Masonry & Cement, Inc. 36036 Lakeland Blvd. Eastlake OH 44095" }, { "name": "DiFranco Contractors Inc", "code": "DiFranco Contractors Inc 9970 Mentor Rd Chardon, OH 44024" }, { "name": "Domenicks Electric Sewer Cleaning Co Inc", "code": "Domenicks Electric Sewer Cleaning Co Inc 35886 Lakeland Blvd Eastlake OH 44095" }, { "name": "E. Dake Plumbing & Heating LTD.", "code": "E. Dake Plumbing & Heating, LTD. 3717 N. Ridge Road Perry, OH 44081" }, { "name": "Easton Excavating Inc.", "code": "Easton Excavating, Inc. 1373 St. Route 322 Orwell, OH 44076" }, { "name": "Eclispe Co. LLC.", "code": "Eclispe Co., LLC. 11554 E. Washington St. Chagrin Falls, OH" }, { "name": "Eden Excavating Inc", "code": "Eden Excavating Inc PO Box 7103 Eastlake OH 44097" }, { "name": "Eye Will Development Inc", "code": "Eye Will Development, Inc 759 Lakeshore Blvd Painesville OH 44077" }, { "name": "Farinacci Excavating Co. Inc.", "code": "Farinacci Excavating Co., Inc. 34980 Lakeland Blvd. Eastlake, OH 44095" }, { "name": "Fit-N-Finish LLC", "code": "Fit-N-Finish LLC 38243 Airport Pkwy Willoughby, OH 44094" }, { "name": "Formica Plumbing & Sewer Co.", "code": "Formica Plumbing & Sewer Co. 1445 E. 289th St Wickliffe, OH 44092" }, { "name": "GMC Contractors LLC", "code": "GMC Contractors LLC 37821 Milann Dr Willoughby, OH 44094" }, { "name": "H & M Concrete Co Inc", "code": "H & M Concrete Co Inc 1487 E 359th Street Eastlake OH 44095" }, { "name": "H Jack's Plumbing and Heating Co of Mentor Inc", "code": "H Jack's Plumbing and Heating Co of Mentor, Inc 29930 Lakeland Blvd Wickliffe, OH 44092" }, { "name": "Hach Excavating & Demolition Inc.", "code": "Hach Excavating & Demolition, Inc. 2000 Fairport Nursery Road Painesville OH 44077" }, { "name": "Hallmark Excavating Inc", "code": "Hallmark Excavating, Inc 482 Blackbrook Rd Painesville OH 44077" }, { "name": "Hearn Plumbing & Heating LLC.", "code": "Hearn Plumbing & Heating, LLC. 319 North Lake Street Madison, OH 44057" }, { "name": "Holbrook Sewer and Excavating", "code": "Holbrook Sewer and Excavating 6728 North Ridge Road Geneva, OH 44041" }, { "name": "Independence Excavating Inc", "code": "Independence Excavating Inc 5720 E. Schaffe Rd Independence, OH 44131" }, { "name": "Integrity Excavating II LLC", "code": "Integrity Excavating II LLC 1614 E. 40th Street Cleveland OH 44103" }, { "name": "Invisible Excavations LLC", "code": "Invisible Excavations LLC 19924 Ridge Rd North Royalton, OH 44133" }, { "name": "JA English dba A Rooter Man", "code": "JA English dba A Rooter Man PO Box 2955 East Liverpool OH 43920" }, { "name": "JC's Hauling and Stump Grinding", "code": "JC's Hauling and Stump Grinding 6530 Callahan Rd Rome OH 44085" }, { "name": "John F. Gallagher Company", "code": "John F. Gallagher Company 36360 Lakeland Blvd Eastlake OH 44095" }, { "name": "John Kelleher Co LLC", "code": "John Kelleher Co LLC 8101 Hermitage Rd Concord OH 44077" }, { "name": "JR Sbrocco Plumbing Inc", "code": "JR Sbrocco Plumbing Inc 38310 Willoughby Pkwy Willoughby, OH 44094" }, { "name": "JS Bova Excavating LLC", "code": "JS Bova Excavating LLC 235 State St Struthers OH 44471" }, { "name": "JS Paris Excavating Inc.", "code": "JS Paris Excavating, Inc. 12240 Commission Drive North Jackson, OH 44451" }, { "name": "JTO Inc", "code": "JTO Inc 6011 Heisley Blvd Mentor OH 44060" }, { "name": "Keith Smith Construction LLC.", "code": "Keith Smith Construction, LLC. 10389 Wilder Road Chardon, OH 44024" }, { "name": "Kent's Excavating Services Inc", "code": "Kent's Excavating Services, Inc 260 Ryan Rd Seville, OH 44273" }, { "name": "King Excavating Co", "code": "King Excavating Co 35080 Lakeland Blvd Eastlake OH 44095" }, { "name": "Kobella Plumbing Heating Cooling", "code": "Kobella Plumbing Heating Cooling 8281 Euclid Chardon Road Ste. B Kirtland, OH 44094" }, { "name": "Koski Construction", "code": "Koski Construction 5841 Woodman Ave PO Box 1038 Ashtabula, OH 44005" }, { "name": "Lake County Roto Roooter", "code": "Lake County Roto Roooter 274 Bowhall Rd. Painesville OH 44077" }, { "name": "Lake County Sewer Co. Inc.", "code": "Lake County Sewer Co., Inc. 32900 Lakeland Blvd Willowick, OH 44095" }, { "name": "Lassnick Excavating", "code": "Lassnick Excavating 7841 Proctor Road Painesville OH 44077" }, { "name": "Lou Severino Construction LLC.", "code": "Lou Severino Construction, LLC. 18808 White Oak Drive Chagrin Falls, OH 44023" }, { "name": "Mark Haynes Construction Inc.", "code": "Mark Haynes Construction, Inc. 3130 State Route 18 Norwalk, OH 44857" }, { "name": "Marous Brothers Construction Inc", "code": "Marous Brothers Construction Inc 1702 Joseph Lloyd Pkwy Willoughby, OH 44094" }, { "name": "Marut & Sons Excavating Inc", "code": "Marut & Sons Excavating Inc 3332 Blackmore Rd Perry OH 44081" }, { "name": "Mayes and Sons Plumbing Company", "code": "Mayes and Sons Plumbing Company 11434 Rolling Meadows Dr. Garrettsville, OH 44231" }, { "name": "McGeehan Contracting", "code": "McGeehan Contracting 11425 Aquilla Rd Chardon, OH 44024" }, { "name": "Miller Plumbing and Heating Company", "code": "Miller Plumbing and Heating Company 196 Bell Street Chagrin Falls, OH" }, { "name": "Monte Construction Co Inc", "code": "Monte Construction Co, Inc 9290 Amberwood Dr Kirtland, OH 44094" }, { "name": "Montz Excavating", "code": "Montz Excavating 4299 Lane Rd Perry OH 44081" }, { "name": "Morganti Enterprises Inc.", "code": "Morganti Enterprises, Inc. 33290 Lakeland Blvd. Eastlake OH 44095" }, { "name": "Mr. Excavator Inc.", "code": "Mr. Excavator, Inc. 8616 Euclid-Chardon Road Kirtland, OH 44094" }, { "name": "MUI Construction LLC", "code": "MUI Construction LLC 12351 Prospect Rd Strongsville OH 44149" }, { "name": "Nerone & Sons Inc.", "code": "Nerone & Sons, Inc. 19501 S. Miles Rd. Warrensville Hts OH 44128" }, { "name": "North Coast Excavating & Contracting LLC", "code": "North Coast Excavating & Contracting LLC 1290 Dorchester Ave Madison, OH 44057" }, { "name": "Northeast Ohio Trenching Service Inc", "code": "Northeast Ohio Trenching Service Inc 17900 Miles Rd Warrensville Hts OH 44128" }, { "name": "O'Neil Excavating LTD.", "code": "O'Neil Excavating, LTD. 12326 Meredith Ln. Concord OH 44077" }, { "name": "Personal Plumber Servie Corp. dba Valu-Rooter", "code": "Personal Plumber Servie Corp. dba Valu-Rooter 42343 N. Ridge Road Elyria, OH 44035" }, { "name": "Pillar Construction & Demolition LLC", "code": "Pillar Construction & Demolition LLC 616 N State St Painesville OH 44077" }, { "name": "Platform Cement Inc", "code": "Platform Cement Inc 7503 Tyler Blvd Mentor OH 44060" }, { "name": "Plumbing 911 Inc", "code": "Plumbing 911 Inc 1393 Gardner Blvd Norton, OH 44203" }, { "name": "Polchosky Excavating LLC.", "code": "Polchosky Excavating, LLC. 361 S. Ridge Rd. E Conneaut, OH 44030" }, { "name": "Precision Engineering & Contracting Inc.", "code": "Precision Engineering & Contracting, Inc. 31340 Solon Road, Suites25/26 Solon, OH 44139" }, { "name": "Precision Excavating & Grading Company", "code": "Precision Excavating & Grading Company 2570 Pressler Rd Akron, OH 44312" }, { "name": "R. Sheppard Construction", "code": "R. Sheppard Construction 1158 La Feure Rd Geneva, OH 44041" }, { "name": "R&R Fugman Excavating LTD.", "code": "R&R Fugman Excavating, LTD. 16798 Munn Road Chagrin Falls, OH" }, { "name": "Reeves Plumbing & Heating Company of Ohio", "code": "Reeves Plumbing & Heating Company of Ohio 1630 E.361st Street #7 Eastlake OH 44095" }, { "name": "RJ Platten Contracting Company", "code": "RJ Platten Contracting Company 14490 York Rd N Royalton, OH 44133" }, { "name": "Schafer Excavating. LLC.", "code": "Schafer Excavating. LLC. 1471 Lear Industrial Pkwy Avon, OH 44011" }, { "name": "SET Inc", "code": "SET Inc 235 E. Water St Lowellville, OH 44435" }, { "name": "Sevco Construction Co Inc", "code": "Sevco Construction Co Inc 38038 Poplar Drive Willoughby, OH 44094" }, { "name": "Sitetech Inc", "code": "Sitetech Inc 35700 E Royalton Rd Grafton OH 44044" }, { "name": "Sitework Developing Inc", "code": "Sitework Developing Inc 9940 Waterford Trail Chagrin Falls, OH 44023" }, { "name": "Solid Rock Excavating & Poured Walls Inc", "code": "Solid Rock Excavating & Poured Walls Inc 1333 E 289th Street Wickliffe, OH 44092" }, { "name": "Star Excavating", "code": "Star Excavating 5818 North Ridge Rd Madison, OH 44057" }, { "name": "TC Construction Co Inc", "code": "TC Construction Co Inc 2936 Lynn Drive Willoughby HIlls OH 44092" }, { "name": "Terrace Construction Company Inc.", "code": "Terrace Construction Company, Inc. 3965 Pearl Road Cleveland, OH 44109" }, { "name": "TJ Smith Excavating LLC.", "code": "TJ Smith Excavating, LLC. 11230 Hosford Road Chardon, OH 44024" }, { "name": "TRAX Construction Co", "code": "TRAX Construction Co 30701 Euclid Ave Wickliffe, OH 44092" }, { "name": "Triton Accu-Flow Meter Services LLC", "code": "Triton Accu-Flow Meter Services LLC 3516 Sturbridge Lane Painesville OH 44077" }, { "name": "Underground Construction Inc.", "code": "Underground Construction, Inc. 1815 Columbus Road Cleveland, OH 44113" }, { "name": "Union Industrial Contractros", "code": "Union Industrial Contractros 1800 E. 21st Street Ashtabula, OH 44004" }, { "name": "United Mechanical Contractors Inc", "code": "United Mechanical Contractors Inc 26660 Lakeland Blvd Euclid, OH 44132" }, { "name": "Vallejo Company", "code": "Vallejo Company 1340 E. 38st Street Cleveland OH 44114" }, { "name": "Vincent Homes LLC", "code": "Vincent Homes, LLC 2748 Rockefeller Rd Willoughby HIlls OH 44092" }, { "name": "WAP Construction LLC", "code": "WAP Construction LLC 26300 Chagrin Blvd Beachwood, OH 44122" }, { "name": "WF Hann & Sons Inc", "code": "WF Hann & Sons Inc 26401 Miles Rd Warrensville Hts OH 44128" }, { "name": "Winters & Lewis Excavating Inc", "code": "Winters & Lewis Excavating Inc PO Box 1040 Chardon, OH 44024" }, { "name": "Wyattworks Inc.", "code": "Wyattworks Inc. 1372 Lloyd Rd Wickliffe, OH 44092" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConnectionType", "type": "esriFieldTypeString", "alias": "Connection", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ConnectionType", "description": "", "codedValues": [ { "name": "Residential", "code": "Residential" }, { "name": "Condo", "code": "Condo" }, { "name": "Duplex", "code": "Duplex" }, { "name": "Apartment", "code": "Apartment" }, { "name": "NonResidential", "code": "NonResidential" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": null }, { "name": "Permit", "type": "esriFieldTypeString", "alias": "Permit No.", "length": 255, "domain": null }, { "name": "UnknownPermit", "type": "esriFieldTypeString", "alias": "UnknownPermit", "length": 255, "domain": null }, { "name": "NewPermit", "type": "esriFieldTypeString", "alias": "Permit No.", "length": 255, "domain": null }, { "name": "BenefitUnit", "type": "esriFieldTypeDouble", "alias": "Benefit Unit(s)", "domain": null }, { "name": "BenefitUnitFee", "type": "esriFieldTypeDouble", "alias": "Benefit Unit Fee", "domain": null }, { "name": "TapFee", "type": "esriFieldTypeDouble", "alias": "Tap Size Fee", "domain": null }, { "name": "Backflow", "type": "esriFieldTypeString", "alias": "Backflow Device Required", "length": 255, "domain": null }, { "name": "MeterFee", "type": "esriFieldTypeDouble", "alias": "Meter Fee", "domain": null }, { "name": "Labor", "type": "esriFieldTypeDouble", "alias": "Labor", "domain": null }, { "name": "Material", "type": "esriFieldTypeDouble", "alias": "Material", "domain": null }, { "name": "MeterFeeCal", "type": "esriFieldTypeString", "alias": "MeterFeeCal", "length": 255, "domain": null }, { "name": "TapFeeCal", "type": "esriFieldTypeString", "alias": "TapFeeCal", "length": 255, "domain": null }, { "name": "TapSize", "type": "esriFieldTypeString", "alias": "Tap Size", "length": 255, "domain": null }, { "name": "BenefitUnitCal", "type": "esriFieldTypeString", "alias": "BenefitUnitCal", "length": 255, "domain": null }, { "name": "WellChecked", "type": "esriFieldTypeString", "alias": "Is there a well on site?", "length": 255, "domain": null }, { "name": "InspectionFee", "type": "esriFieldTypeDouble", "alias": "Inspection Fee 70.00)", "domain": null }, { "name": "InspectionFeeCharge", "type": "esriFieldTypeDouble", "alias": "InspectionFeeCharge", "domain": null }, { "name": "Deposit", "type": "esriFieldTypeDouble", "alias": "Deposit", "domain": null }, { "name": "OtherFees", "type": "esriFieldTypeDouble", "alias": "Other Fees", "domain": null }, { "name": "PermitTotal", "type": "esriFieldTypeDouble", "alias": "Permit Amount", "domain": null }, { "name": "TotalPermit", "type": "esriFieldTypeDouble", "alias": "Total Paid", "domain": null }, { "name": "CheckName", "type": "esriFieldTypeString", "alias": "Check Name", "length": 255, "domain": null }, { "name": "MailingAddress", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 255, "domain": null }, { "name": "MailingCity", "type": "esriFieldTypeString", "alias": "Mailing City", "length": 255, "domain": null }, { "name": "PhoneNumber", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 255, "domain": null }, { "name": "PayInDate", "type": "esriFieldTypeDate", "alias": "Pay In Date", "length": 8, "domain": null }, { "name": "Receipt", "type": "esriFieldTypeString", "alias": "Receipt No.", "length": 255, "domain": null }, { "name": "ProjNo", "type": "esriFieldTypeString", "alias": "Project Number", "length": 255, "domain": null }, { "name": "AGOLuser", "type": "esriFieldTypeString", "alias": "Issue By", "length": 255, "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "email", "length": 255, "domain": null }, { "name": "Void", "type": "esriFieldTypeString", "alias": "Void", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Void", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VoidReason", "type": "esriFieldTypeString", "alias": "Void Reason", "length": 255, "domain": null }, { "name": "PermitDate", "type": "esriFieldTypeString", "alias": "PermitDate", "length": 255, "domain": null }, { "name": "PermitID", "type": "esriFieldTypeString", "alias": "PermitID", "length": 50, "domain": null }, { "name": "latlong", "type": "esriFieldTypeString", "alias": "latlong", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "RelatedObjectID", "type": "esriFieldTypeInteger", "alias": "RelatedObjectID", "domain": null }, { "name": "MeterLocation", "type": "esriFieldTypeString", "alias": "MeterLocation", "length": 255, "domain": null }, { "name": "JobNo", "type": "esriFieldTypeString", "alias": "Job No", "length": 50, "domain": null }, { "name": "PaymentMethod", "type": "esriFieldTypeString", "alias": "Payment Method", "length": 50, "domain": null }, { "name": "EmailCustomer", "type": "esriFieldTypeString", "alias": "Customers Email", "length": 50, "domain": null }, { "name": "TapInReimbursement", "type": "esriFieldTypeDouble", "alias": "TapIn Reimbursement", "domain": null }, { "name": "Assessment", "type": "esriFieldTypeDouble", "alias": "Assessment", "domain": null }, { "name": "Other_fee_name", "type": "esriFieldTypeString", "alias": "Other Fee Type", "length": 50, "domain": null }, { "name": "Credit", "type": "esriFieldTypeDouble", "alias": "Credit", "domain": null }, { "name": "Meter_Size", "type": "esriFieldTypeString", "alias": "Meter Size", "length": 50, "domain": null }, { "name": "ServiceGUID", "type": "esriFieldTypeGUID", "alias": "ServiceGUID", "length": 38, "domain": null }, { "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": "Water_Service_GlobalID", "type": "esriFieldTypeGUID", "alias": "Water_Service_GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_19", "fields": "globalid,objectid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G17RelatedObject", "fields": "RelatedObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I17CreationDate", "fields": "CreationDate", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I17Creator", "fields": "Creator", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I17EditDate", "fields": "EditDate", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I17Editor", "fields": "Editor", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G17Water_Service", "fields": "Water_Service_GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S5_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Water Service", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Water_Service_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746704494000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Water Inspections", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "061fb590656964589805bcd1bc868162", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAUElEQVQ4jWNhoBCwQOkGBgYGYxL1nmVgYGiAGWAMNeQ5kZoloerhLmCAan5GoitQDCALjBowagC6AZIk6IOrhRlwlgGatkkAz5ANIFUzHAAAXtEJJuZlz2UAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -81.27080849899994, "ymin": 41.647326011000075, "xmax": 2377069.562015571, "ymax": 798426.8652567591, "spatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "created_date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "hours_on_job", "type": "esriFieldTypeString", "alias": "Hours on Job", "length": 255, "domain": null }, { "name": "permit_no", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 255, "domain": null }, { "name": "builder_hours_on_job", "type": "esriFieldTypeDouble", "alias": "Builder Hours on Job", "domain": null }, { "name": "builders_personnel1", "type": "esriFieldTypeString", "alias": "Builders Personnel 1", "length": 255, "domain": null }, { "name": "job_title1", "type": "esriFieldTypeString", "alias": "Job Title 1", "length": 255, "domain": null }, { "name": "builders_personnel2", "type": "esriFieldTypeString", "alias": "Builders Personnel 2", "length": 255, "domain": null }, { "name": "job_title2", "type": "esriFieldTypeString", "alias": "Job Title 2", "length": 255, "domain": null }, { "name": "builders_personnel3", "type": "esriFieldTypeString", "alias": "Builders Personnel 3", "length": 255, "domain": null }, { "name": "job_title3", "type": "esriFieldTypeString", "alias": "Job Title 3", "length": 255, "domain": null }, { "name": "soil_type", "type": "esriFieldTypeString", "alias": "Soil Type", "length": 255, "domain": null }, { "name": "ground_water", "type": "esriFieldTypeString", "alias": "Ground Water", "length": 255, "domain": null }, { "name": "trench_width", "type": "esriFieldTypeDouble", "alias": "Trench Width", "domain": null }, { "name": "above_below_elevation", "type": "esriFieldTypeString", "alias": "Above or Below Elevation", "length": 255, "domain": null }, { "name": "above_below_feet", "type": "esriFieldTypeDouble", "alias": "Above oe Below in Feet", "domain": null }, { "name": "city_water", "type": "esriFieldTypeString", "alias": "City Water", "length": 255, "domain": null }, { "name": "is_well_metered", "type": "esriFieldTypeString", "alias": "Is Well Metered", "length": 255, "domain": null }, { "name": "no_of_apts", "type": "esriFieldTypeInteger", "alias": "Number of apartments", "domain": null }, { "name": "no_of_units", "type": "esriFieldTypeInteger", "alias": "Number of Units", "domain": null }, { "name": "no_of_trailers", "type": "esriFieldTypeInteger", "alias": "Number of Trailers", "domain": null }, { "name": "pipe_installed", "type": "esriFieldTypeDouble", "alias": "Pipe Installed", "domain": null }, { "name": "pipe_size", "type": "esriFieldTypeDouble", "alias": "Pipe Size", "domain": null }, { "name": "pipe_type", "type": "esriFieldTypeString", "alias": "Pipe Type", "length": 255, "domain": null }, { "name": "pipe_manufacturer", "type": "esriFieldTypeString", "alias": "Pipe Manufacturer", "length": 255, "domain": null }, { "name": "connection_to_building", "type": "esriFieldTypeDouble", "alias": "Connection to Building", "domain": null }, { "name": "install_date", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "pipe_date", "type": "esriFieldTypeDate", "alias": "Pipe Date", "length": 8, "domain": null }, { "name": "address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "type_of_connection", "type": "esriFieldTypeString", "alias": "Type of Connection", "length": 255, "domain": null }, { "name": "type_of_meter", "type": "esriFieldTypeString", "alias": "Type of Meter", "length": 255, "domain": null }, { "name": "meter_reading", "type": "esriFieldTypeInteger", "alias": "Meter Reading", "domain": null }, { "name": "date_of_connection", "type": "esriFieldTypeDate", "alias": "Date of Connection", "length": 8, "domain": null }, { "name": "name_of_individiual", "type": "esriFieldTypeString", "alias": "Name of Individual", "length": 255, "domain": null }, { "name": "relatedobjectID", "type": "esriFieldTypeInteger", "alias": "relatedobjectID", "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "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 by", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "laste edit date", "length": 8, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 255, "domain": null }, { "name": "time_of_arrival", "type": "esriFieldTypeDate", "alias": "Time of Arrival", "length": 8, "domain": null }, { "name": "time_of_departure", "type": "esriFieldTypeDate", "alias": "Time of Departure", "length": 8, "domain": null }, { "name": "residential", "type": "esriFieldTypeString", "alias": "Residential", "length": 255, "domain": null }, { "name": "new_house", "type": "esriFieldTypeString", "alias": "New House", "length": 255, "domain": null }, { "name": "existing_house", "type": "esriFieldTypeString", "alias": "Exsistion House", "length": 255, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Note", "length": 255, "domain": null }, { "name": "Owners_Name", "type": "esriFieldTypeString", "alias": "Owners Name", "length": 255, "domain": null }, { "name": "length_of_test", "type": "esriFieldTypeString", "alias": "Lenth of Test", "length": 255, "domain": null }, { "name": "latlong", "type": "esriFieldTypeString", "alias": "latlong", "length": 255, "domain": null }, { "name": "Photo", "type": "esriFieldTypeString", "alias": "Photo", "length": 255, "domain": null }, { "name": "Photo2", "type": "esriFieldTypeString", "alias": "Photo2", "length": 255, "domain": null }, { "name": "Photo3", "type": "esriFieldTypeString", "alias": "Photo3", "length": 255, "domain": null }, { "name": "Photo4", "type": "esriFieldTypeString", "alias": "Photo4", "length": 255, "domain": null }, { "name": "Photo5", "type": "esriFieldTypeString", "alias": "Photo5", "length": 255, "domain": null }, { "name": "Photo6", "type": "esriFieldTypeString", "alias": "Photo6", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "meter_location", "type": "esriFieldTypeString", "alias": "Meter Location", "length": 255, "domain": null }, { "name": "nature_investigation", "type": "esriFieldTypeString", "alias": "Nature of Ivestigation\n", "length": 255, "domain": { "type": "codedValue", "name": "Ut_Nature_Investigation", "description": "Nature of Investigation", "codedValues": [ { "name": "Turn On Water", "code": "turn on" }, { "name": "Turn Off Water", "code": "turn off" }, { "name": "Inspection", "code": "inspection" }, { "name": "Meter Set and Turn On", "code": "meter set and turn on" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "investigation_note", "type": "esriFieldTypeString", "alias": "Investigation Note", "length": 255, "domain": null }, { "name": "investigation_results", "type": "esriFieldTypeString", "alias": "Investigation Results", "length": 255, "domain": null }, { "name": "found_water", "type": "esriFieldTypeString", "alias": "Found Water", "length": 255, "domain": null }, { "name": "spoke_to", "type": "esriFieldTypeString", "alias": "Spoke To", "length": 255, "domain": null }, { "name": "ampm", "type": "esriFieldTypeString", "alias": "AM or PM", "length": 255, "domain": null }, { "name": "phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 255, "domain": null }, { "name": "pin", "type": "esriFieldTypeString", "alias": "pin", "length": 255, "domain": null }, { "name": "sublot", "type": "esriFieldTypeString", "alias": "sublot", "length": 255, "domain": null }, { "name": "depth", "type": "esriFieldTypeString", "alias": "Depth", "length": 15, "domain": null }, { "name": "meter_ID", "type": "esriFieldTypeInteger", "alias": "Meter ID", "domain": null }, { "name": "meter_size", "type": "esriFieldTypeString", "alias": "Meter Size", "length": 50, "domain": null }, { "name": "meter_serial", "type": "esriFieldTypeInteger", "alias": "Meter Serial No.", "domain": null }, { "name": "meter_read", "type": "esriFieldTypeDouble", "alias": "Meter Reading", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Water_Service_GlobalID", "type": "esriFieldTypeGUID", "alias": "Water_Service_GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_18", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G16permit_no", "fields": "permit_no", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_16_Water_Ser", "fields": "Water_Service_GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S4_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Water Service", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Water_Service_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746704489000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Munis Account Records", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Primary_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Account_Number", "type": "esriFieldTypeString", "alias": "Account Number", "length": 30, "domain": null }, { "name": "Start_Date", "type": "esriFieldTypeDate", "alias": "Start Date", "length": 8, "domain": null }, { "name": "Stop_Date", "type": "esriFieldTypeDate", "alias": "Stop Date", "length": 8, "domain": null }, { "name": "Account_Type", "type": "esriFieldTypeString", "alias": "Account Type", "length": 2, "domain": null }, { "name": "Parcel_ID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 30, "domain": null }, { "name": "Read_Location", "type": "esriFieldTypeString", "alias": "Read Location", "length": 65, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "length": 2, "domain": null }, { "name": "Service_Unit", "type": "esriFieldTypeString", "alias": "Service Unit", "length": 5, "domain": null }, { "name": "Service_City", "type": "esriFieldTypeString", "alias": "Service City", "length": 4, "domain": null }, { "name": "Service_Lot", "type": "esriFieldTypeString", "alias": "Service Lot", "length": 10, "domain": null }, { "name": "Steet_Number", "type": "esriFieldTypeInteger", "alias": "Steet Number", "domain": null }, { "name": "Streer_Suffix", "type": "esriFieldTypeString", "alias": "Streer Suffix", "length": 5, "domain": null }, { "name": "Streer_Post_Direction", "type": "esriFieldTypeString", "alias": "Street Post Direction", "length": 4, "domain": null }, { "name": "Streer_Pre_Direction", "type": "esriFieldTypeString", "alias": "Street Pre Direction", "length": 4, "domain": null }, { "name": "Street_Type", "type": "esriFieldTypeString", "alias": "Street Type", "length": 10, "domain": null }, { "name": "Service_Street", "type": "esriFieldTypeString", "alias": "Service Street", "length": 25, "domain": null }, { "name": "Service_Zip_Code", "type": "esriFieldTypeString", "alias": "Service Zip Code", "length": 10, "domain": null }, { "name": "Account_Create_Date", "type": "esriFieldTypeDate", "alias": "Account Create Date", "length": 8, "domain": null }, { "name": "Read_Sequence", "type": "esriFieldTypeInteger", "alias": "Read Sequence", "domain": null }, { "name": "Route_Book", "type": "esriFieldTypeString", "alias": "Route Book", "length": 6, "domain": null }, { "name": "Backflow_Required", "type": "esriFieldTypeString", "alias": "Backflow Required", "length": 1, "domain": null }, { "name": "Customer_ID", "type": "esriFieldTypeInteger", "alias": "Customer ID", "domain": null }, { "name": "Addtional_Adress", "type": "esriFieldTypeSmallInteger", "alias": "Addtional Address", "domain": null }, { "name": "Hold_Bill", "type": "esriFieldTypeString", "alias": "Hold Bill", "length": 1, "domain": null }, { "name": "Phone_Number", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 20, "domain": null }, { "name": "Billable", "type": "esriFieldTypeString", "alias": "Billable", "length": 1, "domain": null }, { "name": "Delivery_Method", "type": "esriFieldTypeString", "alias": "Delivery Method", "length": 1, "domain": null }, { "name": "Billing_Comment", "type": "esriFieldTypeString", "alias": "Billing Comment", "length": 30, "domain": null }, { "name": "Account_Key", "type": "esriFieldTypeInteger", "alias": "Account Key", "domain": null }, { "name": "Customer_Start_Date", "type": "esriFieldTypeDate", "alias": "Customer Start Date", "length": 8, "domain": null }, { "name": "Meter_Size", "type": "esriFieldTypeString", "alias": "Meter Size", "length": 10, "domain": null }, { "name": "Meter_Serial", "type": "esriFieldTypeString", "alias": "Meter Serial", "length": 15, "domain": null }, { "name": "Meter_Install", "type": "esriFieldTypeDate", "alias": "Meter Install", "length": 8, "domain": null }, { "name": "Meter_Remote", "type": "esriFieldTypeString", "alias": "Meter Remote", "length": 15, "domain": null }, { "name": "Service_Status", "type": "esriFieldTypeString", "alias": "Service Status", "length": 1, "domain": null }, { "name": "Type_", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "Acitve", "type": "esriFieldTypeString", "alias": "Acitve", "length": 1, "domain": null }, { "name": "Update_Date", "type": "esriFieldTypeDate", "alias": "Update Date", "length": 8, "domain": null }, { "name": "Update_By", "type": "esriFieldTypeString", "alias": "Update By", "length": 20, "domain": null }, { "name": "Primary_Name", "type": "esriFieldTypeString", "alias": "Primary Name", "length": 64, "domain": null }, { "name": "Secondary_Name", "type": "esriFieldTypeString", "alias": "Secondary Name", "length": 64, "domain": null }, { "name": "Mailing_Name_1", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 64, "domain": null }, { "name": "Mailing_Name_2", "type": "esriFieldTypeString", "alias": "Mailing Address 2", "length": 64, "domain": null }, { "name": "Mailing_Name_3", "type": "esriFieldTypeString", "alias": "Mailing Address 3", "length": 64, "domain": null }, { "name": "Customer_Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 20, "domain": null }, { "name": "Customer_Email", "type": "esriFieldTypeString", "alias": "Email", "length": 254, "domain": null }, { "name": "Phone_Type", "type": "esriFieldTypeString", "alias": "Phone Type", "length": 20, "domain": null }, { "name": "Primary_Address", "type": "esriFieldTypeString", "alias": "Primary Address", "length": 1, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "UUID_17", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_15_Account_N", "fields": "Account_Number", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "SDE.Water_Service", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Account_Number", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746704482000 } } ] }