Name: VA_Public_Water_Supply

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9004501.0302
YMin: 4377407.0693
XMax: -8809330.0232
YMax: 4518569.9791
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"97321f96be507c8cfcb4e65f51068de9","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAPCAYAAADZCo4zAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAm0lEQVQYlYWPwQ3CMAxFnxVPwRrtqRUb0DXCGjAGc3QERG9ZA6YAo7QNCiTAv8SW/392lD/St24yz53AVkLdAB43v21pmMxjNHN9tiZRcoJ/VY5TomiRjor1StEi/UHR2WlZOmmlKI5oqMvRKMbmyzhShnhDic8UDdcf86D0smeqHCoEOjks3+yk5WIjsMO4IYw8OKYVi3oZakueiF8vYEO8H0oAAAAASUVORK5CYII=","contentType":"image/png","width":6,"height":11,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: Long Label, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: Short Label, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Address Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: Place Name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: Address Building, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: Address Number From, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: Address Number To, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: Address Range, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: Prefix Directional, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: Prefix Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: Suffix Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: Suffix Directional, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: Building Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: Level Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: Level Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: Unit Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: Subaddress, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: Metro Area, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: Region Abbreviation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: Postal Extension, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CntryName (type: esriFieldTypeString, alias: Country Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: Language Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayX (type: esriFieldTypeDouble, alias: Display X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: Display Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Minimum X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Maximum X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Minimum Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Maximum Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: Extra Info, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• StrucType (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StrucDet (type: esriFieldTypeString, alias: Structure Details, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_SUBMISSIONYEARQUARTER (type: esriFieldTypeString, alias: SUBMISSIONYEARQUARTER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PWSID (type: esriFieldTypeInteger, alias: PWSID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_PWS_NAME (type: esriFieldTypeString, alias: PWS_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PRIMACY_AGENCY_CODE (type: esriFieldTypeInteger, alias: PRIMACY_AGENCY_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_EPA_REGION (type: esriFieldTypeInteger, alias: EPA_REGION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_SEASON_BEGIN_DATE (type: esriFieldTypeString, alias: SEASON_BEGIN_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SEASON_END_DATE (type: esriFieldTypeString, alias: SEASON_END_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PWS_ACTIVITY_CODE (type: esriFieldTypeString, alias: PWS_ACTIVITY_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PWS_DEACTIVATION_DATE (type: esriFieldTypeDateOnly, alias: PWS_DEACTIVATION_DATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_PWS_TYPE_CODE (type: esriFieldTypeString, alias: PWS_TYPE_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_DBPR_SCHEDULE_CAT_CODE (type: esriFieldTypeInteger, alias: DBPR_SCHEDULE_CAT_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_CDS_ID (type: esriFieldTypeString, alias: CDS_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_GW_SW_CODE (type: esriFieldTypeString, alias: GW_SW_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_LT2_SCHEDULE_CAT_CODE (type: esriFieldTypeString, alias: LT2_SCHEDULE_CAT_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OWNER_TYPE_CODE (type: esriFieldTypeString, alias: OWNER_TYPE_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_POPULATION_SERVED_COUNT (type: esriFieldTypeInteger, alias: POPULATION_SERVED_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_POP_CAT_2_CODE (type: esriFieldTypeInteger, alias: POP_CAT_2_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_POP_CAT_3_CODE (type: esriFieldTypeInteger, alias: POP_CAT_3_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_POP_CAT_4_CODE (type: esriFieldTypeInteger, alias: POP_CAT_4_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_POP_CAT_5_CODE (type: esriFieldTypeInteger, alias: POP_CAT_5_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_POP_CAT_11_CODE (type: esriFieldTypeInteger, alias: POP_CAT_11_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_PRIMACY_TYPE (type: esriFieldTypeString, alias: PRIMACY_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PRIMARY_SOURCE_CODE (type: esriFieldTypeString, alias: PRIMARY_SOURCE_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_IS_GRANT_ELIGIBLE_IND (type: esriFieldTypeString, alias: IS_GRANT_ELIGIBLE_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_IS_WHOLESALER_IND (type: esriFieldTypeString, alias: IS_WHOLESALER_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_IS_SCHOOL_OR_DAYCARE_IND (type: esriFieldTypeString, alias: IS_SCHOOL_OR_DAYCARE_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SERVICE_CONNECTIONS_COUNT (type: esriFieldTypeInteger, alias: SERVICE_CONNECTIONS_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_SUBMISSION_STATUS_CODE (type: esriFieldTypeString, alias: SUBMISSION_STATUS_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ORG_NAME (type: esriFieldTypeString, alias: ORG_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ADMIN_NAME (type: esriFieldTypeString, alias: ADMIN_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_EMAIL_ADDR (type: esriFieldTypeString, alias: EMAIL_ADDR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PHONE_NUMBER (type: esriFieldTypeString, alias: PHONE_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PHONE_EXT_NUMBER (type: esriFieldTypeInteger, alias: PHONE_EXT_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_FAX_NUMBER (type: esriFieldTypeString, alias: FAX_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ALT_PHONE_NUMBER (type: esriFieldTypeString, alias: ALT_PHONE_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ADDRESS_LINE1 (type: esriFieldTypeString, alias: ADDRESS_LINE1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ADDRESS_LINE2 (type: esriFieldTypeString, alias: ADDRESS_LINE2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_CITY_NAME (type: esriFieldTypeString, alias: CITY_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ZIP_CODE (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_COUNTRY_CODE (type: esriFieldTypeString, alias: COUNTRY_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_FIRST_REPORTED_DATE (type: esriFieldTypeDateOnly, alias: FIRST_REPORTED_DATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_LAST_REPORTED_DATE (type: esriFieldTypeDateOnly, alias: LAST_REPORTED_DATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_STATE_CODE (type: esriFieldTypeString, alias: STATE_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SOURCE_WATER_PROTECTION_CO (type: esriFieldTypeString, alias: SOURCE_WATER_PROTECTION_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SOURCE_PROTECTION_BEGIN_DA (type: esriFieldTypeString, alias: SOURCE_PROTECTION_BEGIN_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OUTSTANDING_PERFORMER (type: esriFieldTypeString, alias: OUTSTANDING_PERFORMER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OUTSTANDING_PERFORM_BEGIN_ (type: esriFieldTypeString, alias: OUTSTANDING_PERFORM_BEGIN_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_REDUCED_RTCR_MONITORING (type: esriFieldTypeString, alias: REDUCED_RTCR_MONITORING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_REDUCED_MONITORING_BEGIN_D (type: esriFieldTypeString, alias: REDUCED_MONITORING_BEGIN_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_REDUCED_MONITORING_END_DAT (type: esriFieldTypeString, alias: REDUCED_MONITORING_END_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SEASONAL_STARTUP_SYSTEM (type: esriFieldTypeString, alias: SEASONAL_STARTUP_SYSTEM, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: VA_Public_Water_Supply
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_REDUCED_MONITORING_END_DAT:
• USER_SEASONAL_STARTUP_SYSTEM:
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_SUBMISSIONYEARQUARTER:
• USER_PWSID: 0
• USER_PWS_NAME:
• USER_PRIMACY_AGENCY_CODE: 0
• USER_EPA_REGION: 0
• USER_SEASON_BEGIN_DATE:
• USER_SEASON_END_DATE:
• USER_PWS_ACTIVITY_CODE:
• USER_PWS_TYPE_CODE:
• USER_DBPR_SCHEDULE_CAT_CODE: 0
• USER_CDS_ID:
• USER_GW_SW_CODE:
• USER_LT2_SCHEDULE_CAT_CODE:
• USER_OWNER_TYPE_CODE:
• USER_POPULATION_SERVED_COUNT: 0
• USER_POP_CAT_2_CODE: 0
• USER_POP_CAT_3_CODE: 0
• USER_POP_CAT_4_CODE: 0
• USER_POP_CAT_5_CODE: 0
• USER_POP_CAT_11_CODE: 0
• USER_PRIMACY_TYPE:
• USER_PRIMARY_SOURCE_CODE:
• USER_IS_GRANT_ELIGIBLE_IND:
• USER_IS_WHOLESALER_IND:
• USER_IS_SCHOOL_OR_DAYCARE_IND:
• USER_SERVICE_CONNECTIONS_COUNT: 0
• USER_SUBMISSION_STATUS_CODE:
• USER_ORG_NAME:
• USER_ADMIN_NAME:
• USER_EMAIL_ADDR:
• USER_PHONE_NUMBER:
• USER_PHONE_EXT_NUMBER: 0
• USER_FAX_NUMBER:
• USER_ALT_PHONE_NUMBER:
• USER_ADDRESS_LINE1:
• USER_ADDRESS_LINE2:
• USER_CITY_NAME:
• USER_ZIP_CODE:
• USER_COUNTRY_CODE:
• USER_STATE_CODE:
• USER_SOURCE_WATER_PROTECTION_CO:
• USER_SOURCE_PROTECTION_BEGIN_DA:
• USER_OUTSTANDING_PERFORMER:
• USER_OUTSTANDING_PERFORM_BEGIN_:
• USER_REDUCED_RTCR_MONITORING:
• USER_REDUCED_MONITORING_BEGIN_D:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/9/2025 4:42:47 PM

Schema Last Edit Date: 6/9/2025 4:42:47 PM

Data Last Edit Date: 6/9/2025 4:42:47 PM

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