Name: OWTS Points

Display Field: Status

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset was created using the following steps:1. Used spreadsheet with updated EnvisionConnect data, edited for geocoding, named, "GIS_GEOCODING_ONLY_InventoryNo1", and converted to a table in ArcMap2. Joined the spreadsheet "GIS_GEOCODING_ONLY_InventoryNo1" with the "Survey Responses" spreadsheet, which contains survey responses from letters sent to everyone with an OWTS in EC. The letters asked people to respond to ACDEH, with information on their property.3. Exported the joined table, as an excel spreadsheet, then created a new table back in ArcMap.4. Geocoded based on the "Geocoded APN" field (filed only has 1 APN, or is blank, or says "multiple" if there were multple APNs matched to one property. This is the case because many of the APNs in EnvisionConnect were old, and have since mapped two many different parcel numbers. It is difficult to tell which new parcel contained the OWTS.

Copyright Text: Alameda County Department of Envieonmental Health, Land Use Program created.

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13609180.4931
YMin: 4506437.8209
XMax: -13526418.4089
YMax: 4561012.8572
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"14a54329f8c7e5cc1ab1218d873d7ccd","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAPCAYAAADZCo4zAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAlElEQVQYlWNhIABYwGT1AV+G/4w+DIyMxgz/GaQYGP5vZvjzs5Ghy+0ZC0PFYWOG//9nMjAwSDL8h+ljTGNg4UgDMVgYmP75MjAwSmI1v/pwGsgKSZwO+P/PmIU4Rw68guf4FbTZNzBUHZQEBw4K+D+Loc0+HWJFm306Q9VBSAhCJBvBGlHcAFfE8BwmielIkCI0AACgeieGr5nFswAAAABJRU5ErkJggg==","contentType":"image/png","width":6,"height":11,"angle":0,"xoffset":0,"yoffset":4.875}},"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)
• 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_addr, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Ref_ID (type: esriFieldTypeString, alias: Ref_ID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ARC_Single (type: esriFieldTypeString, alias: ARC_Single, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OID_ (type: esriFieldTypeInteger, alias: OID_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECORD_ID (type: esriFieldTypeString, alias: RECORD_ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CURRENT_OW (type: esriFieldTypeString, alias: CURRENT_OW, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PREV_OWNER (type: esriFieldTypeString, alias: PREV_OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EC_OWNER (type: esriFieldTypeString, alias: EC_OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_STREE (type: esriFieldTypeString, alias: SITE_STREE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_PRE_D (type: esriFieldTypeString, alias: SITE_PRE_D, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_STR_1 (type: esriFieldTypeString, alias: SITE_STR_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_STR_2 (type: esriFieldTypeString, alias: SITE_STR_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_POST_ (type: esriFieldTypeString, alias: SITE_POST_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_UNIT_ (type: esriFieldTypeString, alias: SITE_UNIT_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_UNIT (type: esriFieldTypeString, alias: SITE_UNIT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• STREET_CIT (type: esriFieldTypeString, alias: STREET_CIT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CENSUS_TRA (type: esriFieldTypeString, alias: CENSUS_TRA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CURRENT_AP (type: esriFieldTypeString, alias: CURRENT_AP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• APN_GEOCOD (type: esriFieldTypeString, alias: APN_GEOCOD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• HISTORIC_A (type: esriFieldTypeString, alias: HISTORIC_A, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SUNOL_BOX_ (type: esriFieldTypeString, alias: SUNOL_BOX_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SUNOL_BOX1 (type: esriFieldTypeString, alias: SUNOL_BOX1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SCAN_L_DRI (type: esriFieldTypeString, alias: SCAN_L_DRI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SCAN_E_FIL (type: esriFieldTypeString, alias: SCAN_E_FIL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SCAN_INCOM (type: esriFieldTypeString, alias: SCAN_INCOM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SCAN_TEST_ (type: esriFieldTypeString, alias: SCAN_TEST_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• BOX_NO (type: esriFieldTypeString, alias: BOX_NO, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FILE_NO (type: esriFieldTypeString, alias: FILE_NO, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ACTIVE_FIL (type: esriFieldTypeString, alias: ACTIVE_FIL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OWNER_MAIL (type: esriFieldTypeString, alias: OWNER_MAIL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EMAIL (type: esriFieldTypeString, alias: EMAIL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• AS_OF_DATE (type: esriFieldTypeString, alias: AS_OF_DATE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NET_VALUE (type: esriFieldTypeString, alias: NET_VALUE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• LOT_SIZE_F (type: esriFieldTypeString, alias: LOT_SIZE_F, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• BUILDINGS (type: esriFieldTypeString, alias: BUILDINGS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• BEDS (type: esriFieldTypeString, alias: BEDS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• LOT_SIZE_A (type: esriFieldTypeString, alias: LOT_SIZE_A, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• YEAR_BUILT (type: esriFieldTypeString, alias: YEAR_BUILT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• BATHS (type: esriFieldTypeString, alias: BATHS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• POOL (type: esriFieldTypeString, alias: POOL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SEWERCONNE (type: esriFieldTypeString, alias: SEWERCONNE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• STD_ADV (type: esriFieldTypeString, alias: STD_ADV, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NO_RECORD (type: esriFieldTypeString, alias: NO_RECORD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• DATE_INSTA (type: esriFieldTypeString, alias: DATE_INSTA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• HIST_OF_FA (type: esriFieldTypeString, alias: HIST_OF_FA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OBJECTID_2 (type: esriFieldTypeInteger, alias: OBJECTID_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECORD_I_1 (type: esriFieldTypeString, alias: RECORD_I_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• APN (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OWNER_MA_1 (type: esriFieldTypeString, alias: OWNER_MA_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VALUE (type: esriFieldTypeString, alias: VALUE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OWTS_SITE_ (type: esriFieldTypeString, alias: OWTS_SITE_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PROP_OWNER (type: esriFieldTypeString, alias: PROP_OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CORRECTION (type: esriFieldTypeString, alias: CORRECTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PROP_MAILI (type: esriFieldTypeString, alias: PROP_MAILI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CORRECTI_1 (type: esriFieldTypeString, alias: CORRECTI_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PHONE_NO_1 (type: esriFieldTypeString, alias: PHONE_NO_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PHONE_NO_2 (type: esriFieldTypeString, alias: PHONE_NO_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PHONE_NO_3 (type: esriFieldTypeString, alias: PHONE_NO_3, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EMAIL_1 (type: esriFieldTypeString, alias: EMAIL_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EMAIL_2 (type: esriFieldTypeString, alias: EMAIL_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_ADDRE (type: esriFieldTypeString, alias: SITE_ADDRE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CORRECTI_2 (type: esriFieldTypeString, alias: CORRECTI_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SITE_ADD_U (type: esriFieldTypeString, alias: SITE_ADD_U, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NO_OWTS (type: esriFieldTypeString, alias: NO_OWTS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CON_TO_SEW (type: esriFieldTypeString, alias: CON_TO_SEW, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RENTAL (type: esriFieldTypeString, alias: RENTAL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OTHER_INFO (type: esriFieldTypeString, alias: OTHER_INFO, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RETURNED_S (type: esriFieldTypeString, alias: RETURNED_S, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NOTES_1 (type: esriFieldTypeString, alias: NOTES_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)

Templates:

Name: OWTS Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/18/2025 10:35:49 PM

Schema Last Edit Date: 6/18/2025 10:35:49 PM

Data Last Edit Date: 6/18/2025 10:35:49 PM

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