Name: Inspections

Display Field: Legal_First_Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• APN (type: esriFieldTypeString, alias: APN:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Legal_First_Name (type: esriFieldTypeString, alias: Legal First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Legal_Last_Name (type: esriFieldTypeString, alias: Legal Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Home_Phone (type: esriFieldTypeString, alias: Land Line Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cell_Phone (type: esriFieldTypeString, alias: Mobile Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Owner_Email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Contact_First_Name (type: esriFieldTypeString, alias: Legal First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Contact_Last_Name (type: esriFieldTypeString, alias: Legal Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Situs_Address (type: esriFieldTypeString, alias: Location Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Situs_City (type: esriFieldTypeString, alias: Location City/Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Situs_State (type: esriFieldTypeString, alias: Location State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Situs_ZIP_Code (type: esriFieldTypeString, alias: Location ZIP Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Situs_Mailing_Same (type: esriFieldTypeString, alias: Preferred Mailing Address is the same as the Property Location Address., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Mailing_Address (type: esriFieldTypeString, alias: Mailing Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mailing_City (type: esriFieldTypeString, alias: Mailing City/Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mailing_State (type: esriFieldTypeString, alias: Mailing State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mailing_ZIP_Code (type: esriFieldTypeString, alias: Mailing ZIP Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Onsite_Well (type: esriFieldTypeString, alias: A1. Does the parcel use groundwater from an onsite well?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Num_Active_Wells (type: esriFieldTypeInteger, alias: A2. How many active wells are on the parcel?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Active_Wells_Metered (type: esriFieldTypeString, alias: A3. Is/are the active well(s) metered?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Num_Inactive_Wells (type: esriFieldTypeInteger, alias: A4. How many inactive or inoperable wells are on the parcel?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Depth_Primary_Well (type: esriFieldTypeInteger, alias: A5. What is the depth (in feet) of the primary well on the parcel?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Well_Location (type: esriFieldTypeString, alias: Well_Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n1 (type: esriFieldTypeString, alias: A6. The parcel is located on the boundary of a groundwater basin -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Well_Monitoring (type: esriFieldTypeString, alias: A8. Would you be willing to have your well(s) monitored for scientific purposes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Undecided: Undecided])
• Confirm_Shared_Well (type: esriFieldTypeString, alias: A9. Does the parcel use groundwater from a shared well on a nearby parcel?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Nearby_APN_Address (type: esriFieldTypeString, alias: A10. If yes, what is the APN or address of the nearby parcel?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Data_Public_Water_System (type: esriFieldTypeString, alias: Data_Public_Water_System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n2 (type: esriFieldTypeString, alias: Current Data - Parcel is within Public Water System -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Public_Water_System (type: esriFieldTypeString, alias: B1. Survey Participant Response - Does the parcel use water from a Public Water System?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Name_Public_Water_System (type: esriFieldTypeString, alias: B2. If the listed name is incorrect, please provide the correct name of the Public Water System., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Data_Surface_Water (type: esriFieldTypeString, alias: Data_Surface_Water, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n3 (type: esriFieldTypeString, alias: Current Data - Parcel uses surface water from a reservoir, stream, or other surface water diversion -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Surface_Water (type: esriFieldTypeString, alias: C1. Survey Participant Response - Does the parcel use surface water from a reservoir, stream, or other surface water diversion?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Annual_Gallons_Surface_Water (type: esriFieldTypeInteger, alias: C2. How many gallons of surface water is used each year?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Registered_Diversion (type: esriFieldTypeString, alias: C3. Is the diversion registered or licensed with the state?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Reg_Diversion_Info (type: esriFieldTypeString, alias: C4. What is the registration, water right application or license number?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Diversion_Descrip (type: esriFieldTypeString, alias: C5. If not registered with the state, please briefly describe the surface water diversion., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Recycled_Water (type: esriFieldTypeString, alias: D1. Does the parcel use recycled water?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Name_Recycled_Water_Supplier (type: esriFieldTypeString, alias: D2. What is the name of the recycled water supplier?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Annual_Gallons_Recycled_Water (type: esriFieldTypeInteger, alias: D3. How many gallons of recycled water is used each year?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Residential_Dwellings (type: esriFieldTypeString, alias: Data_Residential_Dwellings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n4 (type: esriFieldTypeString, alias: Current Data - Residential dwellings are on the parcel -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Residential_Dwellings (type: esriFieldTypeString, alias: A1. Survey Participant Response - Are there residential dwellings on the parcel?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Num_Residential_Dwellings (type: esriFieldTypeInteger, alias: A2. How many residential dwellings are on the parcel?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Primary_Source_Household_Use (type: esriFieldTypeString, alias: A3. What is the primary source of water for residential use?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Onsite_Well: Onsite Well], [Shared_Well: Shared Well], [Public_Water_System: Public Water System], ... 2 more ...)
• Primary_Src_Household_Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Annual_Gallons_Household_Use (type: esriFieldTypeInteger, alias: A4. If residential water use is based on a water meter reading or an invoice, please provide the annual gallon usage., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hsehold_Use_with_Landscpe_Irrig (type: esriFieldTypeString, alias: A5. Does the residential water use you provided above include water used for landscape irrigation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Data_Landscape_Irrig (type: esriFieldTypeString, alias: Data_Landscape_Irrig, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n5 (type: esriFieldTypeString, alias: Current Data - Water is used for landscape irrigation -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Landscape_Irrig (type: esriFieldTypeString, alias: B1. Survey Participant Response - Is water used for landscape irrigation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Primary_Src_Landscape_Irrig (type: esriFieldTypeString, alias: B2. What is the primary source of water for irrigated landscape?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Onsite_Well: Onsite Well], [Shared_Well: Shared Well], [Public_Water_System: Public Water System], ... 3 more ...)
• Primary_Src_Landscape_Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Agriculture_Use (type: esriFieldTypeString, alias: C1. Is water used for agricultural irrigation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Primary_Src_Agri_Irrig (type: esriFieldTypeString, alias: C2. What is the primary source of water for agricultural irrigation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Onsite_Well: Onsite Well], [Shared_Well: Shared Well], [Public_Water_System: Public Water System], ... 3 more ...)
• Primary_Src_Agri_Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Annual_Gallons_PrimarySrc_Agri (type: esriFieldTypeInteger, alias: C3. Estimate the number of gallons used each year from the primary source., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_Meter_Invoice_PrimSrc_Agri (type: esriFieldTypeString, alias: C4. Is agricultural water use based on water meter readings or an invoice?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Secondary_Src_Agri_Irrig (type: esriFieldTypeString, alias: C5. What is the secondary source of water for agricultural irrigation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None - No Secondary Source], [Onsite_Well: Onsite Well], [Shared_Well: Shared Well], ... 4 more ...)
• Secondary_Src_Agri_Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Annual_Gallons_Scnd_Src_Agri (type: esriFieldTypeInteger, alias: C6. Estimate the number of gallons used each year from the secondary source., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_Meter_Invoice_Scnd_Src_Agri (type: esriFieldTypeString, alias: C7. Is secondary source water use based on water meter readings or an invoice?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Data_Citrus_Subtropical_Area_Ac (type: esriFieldTypeString, alias: Data_Citrus_Subtropical_Area_Ac, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n8 (type: esriFieldTypeString, alias: Citrus/Subtropical - Current Acreage Total -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Citrus_Subtropical_Area (type: esriFieldTypeDouble, alias: C10. Citrus/Subtropical - Survey Participant Acreage Total -, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Deciduous_Fruit_Nuts_Area_ (type: esriFieldTypeString, alias: Data_Deciduous_Fruit_Nuts_Area_Ac, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n9 (type: esriFieldTypeString, alias: Deciduous Fruit/Nuts - Current Acreage Total -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Deciduous_Fruit_Nuts_Ar (type: esriFieldTypeDouble, alias: C11. Deciduous Fruit/Nuts - Survey Participant Acreage Total -, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Grain_Area_Ac (type: esriFieldTypeString, alias: Data_Grain_Area_Ac, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n10 (type: esriFieldTypeString, alias: Grain - Current Acreage Total -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Grain_Area_Ac (type: esriFieldTypeDouble, alias: C.12 Grain - Survey Participant Acreage Total -, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Pasture_Area_Ac (type: esriFieldTypeString, alias: Data_Pasture_Area_Ac, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n11 (type: esriFieldTypeString, alias: Pasture - Current Acreage Total -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Pasture_Area_Ac (type: esriFieldTypeDouble, alias: C13. Pasture - Survey Participant Acreage Total -, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Truck_Berry_Crops_Area_Ac (type: esriFieldTypeString, alias: Data_Truck_Berry_Crops_Area_Ac, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n12 (type: esriFieldTypeString, alias: Truck/Berry Crops -Current Acreage Total -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Truck_Berry_Crops_Area_ (type: esriFieldTypeDouble, alias: C14. Truck/Berry Crops - Survey Participant Acreage Total -, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Vine_Area_Ac (type: esriFieldTypeString, alias: Data_Vine_Area_Ac, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n13 (type: esriFieldTypeString, alias: Vineyard - Current Acreage Total -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Vine_Area_Ac (type: esriFieldTypeDouble, alias: C15. Vineyard - Survey Participant Acreage Total -, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Non_Residential_Use (type: esriFieldTypeString, alias: Data_Non_Residential_Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n14 (type: esriFieldTypeString, alias: Current Data - Water is used for commercial, industrial, institutional, or other non-residential use -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Confirm_Non_Residential_Use (type: esriFieldTypeString, alias: D1. Survey Participant Response - Is water used for commercial, industrial, institutional, or other non-residential use?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Category_Non_Residential_Use (type: esriFieldTypeString, alias: D2. Select the category that best describes the use:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Commercial: Commercial], [Government: Government], [Industrial: Industrial], ... 6 more ...)
• Non_Residential_Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Non_Residential_Other_Descrip (type: esriFieldTypeString, alias: D3. Briefly describe the primary use of the operation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_Src_Non_Residential (type: esriFieldTypeString, alias: D4. What is the primary water source for commercial, industrial, institutional, or other non-residential use?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Onsite_Well: Onsite Well], [Shared_Well: Shared Well], [Public_Water_System: Public Water System], ... 3 more ...)
• Primary_Src_Non_Resi_Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Annual_Gallons_Non_Residential (type: esriFieldTypeInteger, alias: D5. Estimate the number of gallons of water used each year for commercial, industrial, institutional, or other non-residential use., SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_Meter_Invoice_Non_Resi (type: esriFieldTypeString, alias: D6. Is water use based on water meter readings or an invoice?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PrimaryUse_Non_Resi_Descrip (type: esriFieldTypeString, alias: D7. Briefly describe the primary use of water:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Concerns_About_Well (type: esriFieldTypeString, alias: 1. Do you have any concerns about groundwater or your well? If so, what are they?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Additional_Comments (type: esriFieldTypeString, alias: 2. Please enter any additional comments or information regarding your groundwater use that you would like to provide., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• n (type: esriFieldTypeString, alias: APN:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note_webpage_info (type: esriFieldTypeString, alias: Note Webpage Infor, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• note_Petaluma_Valley_url (type: esriFieldTypeString, alias: Note Petaluma Valley URL, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• note_Sonoma_Valley_url (type: esriFieldTypeString, alias: Note Sonoma Valley URL, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Data_Cannabis_Indoor_Area_Ac (type: esriFieldTypeString, alias: Data_Cannabis_Indoor_Area_Ac, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Parcels (0) -- Related To: Subbasin_Parcel (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/30/2023 7:10:36 PM

Schema Last Edit Date: 2/22/2024 6:57:08 PM

Data Last Edit Date: 10/30/2023 5:09:19 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat