Name: Water_Usage_Estimation

Display Field: Address

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APN (type: esriFieldTypeDouble, alias: APN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Resident_Number__2B_3_residents (type: esriFieldTypeInteger, alias: Resident Number (2B 3 residents, 3B 4 residents, 4+B 5 residents), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estimated_Mortgage_20_down_paym (type: esriFieldTypeDouble, alias: Estimated Mortgage 20 down payment 7.2 Mortgage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lot_size_sqft_0_if_not_sfh (type: esriFieldTypeDouble, alias: Lot size sqft 0 if not sfh, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pool (type: esriFieldTypeInteger, alias: Pool, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Excess (type: esriFieldTypeInteger, alias: Excess, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sprinkler (type: esriFieldTypeInteger, alias: Sprinkler, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ET0_in (type: esriFieldTypeDouble, alias: ET0 in, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Household_Income_1000s (type: esriFieldTypeDouble, alias: Household Income 1000s , SQL Type: sqlTypeOther, nullable: true, editable: true)
• Irrigated_area_sqft (type: esriFieldTypeDouble, alias: Irrigated area sqft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Landscape_Ratio (type: esriFieldTypeDouble, alias: Landscape Ratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pool_Metric (type: esriFieldTypeDouble, alias: Pool Metric, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Excess_Metric (type: esriFieldTypeInteger, alias: Excess Metric, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sprinkler_Metric (type: esriFieldTypeInteger, alias: Sprinkler Metric, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KGal_Year_Indoor (type: esriFieldTypeDouble, alias: KGal/Year Indoor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KGal_Year_Outdoor (type: esriFieldTypeDouble, alias: KGal/Year Outdoor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_KGal_Year (type: esriFieldTypeDouble, alias: Total KGal/Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• House_Water_Consumption (type: esriFieldTypeDouble, alias: House Water Consumption, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pool_Water_Consumption (type: esriFieldTypeDouble, alias: Pool Water Consumption, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Irrigated_Area_Water_Consumptio (type: esriFieldTypeDouble, alias: Irrigated Area Water Consumption, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Redfin_Price (type: esriFieldTypeInteger, alias: Redfin Price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Assessed_Value (type: esriFieldTypeInteger, alias: Assessed Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lot_Size (type: esriFieldTypeDouble, alias: Lot Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Redfin_price_sqft (type: esriFieldTypeDouble, alias: Redfin price/sqft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Assessed_value_sqft (type: esriFieldTypeDouble, alias: Assessed value/sqft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• City_s_average_accessed_value_s (type: esriFieldTypeDouble, alias: City's average accessed value/sqft, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Water_Usage_Estimation
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/29/2024 6:34:08 PM

Schema Last Edit Date: 11/29/2024 6:34:08 PM

Data Last Edit Date: 11/29/2024 6:34:08 PM

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