Name: Review

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

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)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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