Name: WV_Utilities_PSC_Database

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9194832.9677
YMin: 4478607.8403
XMax: -8654528.6935
YMax: 4956585.9033
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• FID (type: esriFieldTypeInteger, alias: FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• OWNER_NAME (type: esriFieldTypeString, alias: OWNER_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Flag_Issue (type: esriFieldTypeString, alias: Flag_Issue, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FACILITY_PHYSICAL_ADDRESS (type: esriFieldTypeString, alias: FACILITY_PHYSICAL_ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FACILITY_PHYSICAL_ADDRESS2 (type: esriFieldTypeString, alias: FACILITY_PHYSICAL_ADDRESS2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FACILITY_PHYSICAL_CITY (type: esriFieldTypeString, alias: FACILITY_PHYSICAL_CITY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FACILITY_PHYSICAL_STATE (type: esriFieldTypeString, alias: FACILITY_PHYSICAL_STATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FACILITY_PHYSICAL_ZIP_CODE (type: esriFieldTypeInteger, alias: FACILITY_PHYSICAL_ZIP_CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FACILITY_COUNTY (type: esriFieldTypeString, alias: FACILITY_COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PSC_Report_Year (type: esriFieldTypeInteger, alias: PSC Report Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Active_Customers (type: esriFieldTypeDouble, alias: Active Customers, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PWSID (type: esriFieldTypeString, alias: PWSID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_REPORTED__Total_Storage_Capac (type: esriFieldTypeDouble, alias: *REPORTED* Total Storage Capacity (M Gallons), SQL Type: sqlTypeFloat, nullable: true, editable: true)
• F_ASSUMED__Total_Storage_Capaci (type: esriFieldTypeDouble, alias: *ASSUMED* Total Storage Capacity (M Gallons), SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Miles_of_main_line (type: esriFieldTypeDouble, alias: Miles of main line, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Type_of_utility (type: esriFieldTypeString, alias: Type of utility, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Unmetered_Water_Sales__Gallons_ (type: esriFieldTypeString, alias: Unmetered Water Sales (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metered_Sales_to_Residential_Cu (type: esriFieldTypeString, alias: Metered Sales to Residential Customers (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metered_Sales_to_Commercial_Cus (type: esriFieldTypeString, alias: Metered Sales to Commercial Customers (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metered_Sales_to_Industrial_Cus (type: esriFieldTypeString, alias: Metered Sales to Industrial Customers (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metered_Sales_to_Public_Authori (type: esriFieldTypeString, alias: Metered Sales to Public Authorities (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metered_Sales_to_Multiple_Famil (type: esriFieldTypeString, alias: Metered Sales to Multiple Family Dwellings (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metered_Sales_Other__Gallons_ (type: esriFieldTypeString, alias: Metered Sales Other (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Fire_Protection__Gallons_ (type: esriFieldTypeString, alias: Total Fire Protection (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Other_Sales_to_Public_Authoriti (type: esriFieldTypeString, alias: Other Sales to Public Authorities (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Sales_to_Irrigation_Customers__ (type: esriFieldTypeString, alias: Sales to Irrigation Customers (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Sales_for_Resale__Gallons_ (type: esriFieldTypeString, alias: Sales for Resale (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Interdepartmental_Sales__Gallon (type: esriFieldTypeString, alias: Interdepartmental Sales (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Sales_of_Water__Gallons_ (type: esriFieldTypeDouble, alias: Total Sales of Water (Gallons), SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Total_Population_Served (type: esriFieldTypeString, alias: Total Population Served, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Gallons_Pumped (type: esriFieldTypeString, alias: Total Gallons Pumped, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Gallons_Lost_in_plant (type: esriFieldTypeString, alias: Gallons Lost in plant, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Gallons_Lost_fire_dept (type: esriFieldTypeString, alias: Gallons Lost fire dept, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Gallons_Lost_main_leaks (type: esriFieldTypeString, alias: Gallons Lost main leaks, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Gallons_Lost_backwashing (type: esriFieldTypeString, alias: Gallons Lost backwashing, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Gallons_lost_blowing_settling_b (type: esriFieldTypeString, alias: Gallons lost blowing settling basins, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_gallons_lost_accounted_fo (type: esriFieldTypeString, alias: Total gallons lost accounted for, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Unaccounted_for_lost_water__Gal (type: esriFieldTypeString, alias: Unaccounted for lost water (Gallons), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Percent_Uncounted_for____ (type: esriFieldTypeString, alias: Percent Uncounted for (%), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Water_Main_Breaks (type: esriFieldTypeString, alias: Water Main Breaks, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Water_Main_Breaks_Repaired (type: esriFieldTypeString, alias: Water Main Breaks Repaired, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Annual_total_leaks_100mi (type: esriFieldTypeString, alias: Annual total leaks/100mi, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Annual_total_breaks_100mi (type: esriFieldTypeString, alias: Annual total breaks/100mi, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/11/2024 8:26:18 PM

Schema Last Edit Date: 4/11/2024 8:26:18 PM

Data Last Edit Date: 4/11/2024 8:26:18 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat