Expand the map - add tax data for more counties

[typpo]

See How to add a county in the README.

Up-to-date spreadsheet with status of each county: https://docs.google.com/spreadsheets/d/1Po5WNrADfJhO87xdHXWqRZDPydDAOH7vbppzsICLVXg/edit#gid=0

[edre]

I found some data for San Diego county.

Parcel data at: https://hub.arcgis.com/datasets/SANDAG::parcels-4
In the zip file is a .dbf file (convert to a csv with dbfdump). The location is given in x and y coordinates that need some unclear conversion to lat/lon.

Tax data query: https://www.sdttc.com/content/ttc/en/tax-collection/prior-year-tax-records.html?fiscal_year=2019-07-01%7C2020-06-30&q={APN}&x=0&y=0

[typpo]

Hey @edre, thanks for the pointer. I believe the coordinate system is most likely California State Plane Zone 6 (reference) but I haven't tested it on the San Diego data.

I should have the coordinate conversion done soon because Contra Costa and several other counties also need it. Will let you know once I figure that out (at least latlng conversion can wait til parsing, it is not a blocker for scraping).

[typpo]

An update on new integrations

Added:

• Contra Costa added
• Marin added
• Sonoma added
• Yolo added (thanks to @highleyman)

In progress:

• Sacramento - I think @highleyman is running a scrape
• Solano - if @miloconway's pull request is any indication
• LA scrape 78% done - this caused me a bit of a heartbreak because the scrape completed last week but turned out the way the site handles sessions + concurrency meant some results were returned for the wrong parcel
• San Bernadino scrape 36% done
• San Diego - I've written a scraper, but their anti scraping is very restrictive and makes the process very slow. I don't think it's practical to scrape the data, so I've contacted the relevant office with the help of an SD local.

[typpo]

Update on county integrations

Added:

• Solano added (thanks @miloconway)
• Sacramento added (thanks @highleyman) - data is live but waiting on pull request
• San Bernadino added
• LA is finally done

In progress:

• SLO scrape (@kevbuchanan)
• San Diego scrape (via @swingley who reached out by email)

[jakebayless]

Napa County (for anyone interested in coding):

Tax lookup URL:
https://common1.mptsweb.com/megabytecommonsite/(S(lziqv3cprr25y12h1dkl4a0l))/PublicInquiry/Inquiry.aspx?CN=napa&SITE=Public&DEPT=Asr&PG=AsrMain&Asmt=018-030-014-000

Parcels:
http://gis.napa.ca.gov/giscatalog/catalog_xml.asp?srch_opt=all&db_name=x&theme=x&sort_order=layer&meta_style=fgdc&submit=Submit

[typpo]

Good news @jakebayless - Napa was added by @miloconway in #11!

Other progress: SLO was added by @kevbuchanan, San Diego by @swingley

In progress: North County San Diego, Orange County (almost done)

[jakebayless]

Excellent. Ok. Let's dive into some more rural and ag counties... For anyone interested in coding this:

Butte County, also recently impacted by big fires, perhaps useful and timely to have tax info exposed.
Butte tax records are the same web app as Sonoma County (reference that for code). APN and year is handy in the URL:

https://common2.mptsweb.com/MBC/butte/tax/main/053022019000/2020/0000

...and MAN! it took some digging, but here is the AGOL Butte County Parcels layer:
https://services.arcgis.com/3t3QfTXFRFX44zo8/arcgis/rest/services/Butte_County_Parcels/FeatureServer

[miloconway]

Currently in the process of looking at Fresno (I'm picking by population), can take a look at that one next unless someone else would like to.

[jakebayless]

Is there a master list of the counties added/needed so I/we can be methodical about researching the relevant endpoints? Maybe a sheet in drive or something we can share edits?

[jamesshannon]

Initial investigation for Placer:

GIS data overview page

Parcel information is in AddressPoints.csv. You'd think you'd want Parcels.csv but AddressPoints has a lat/lng centroid point while Parcels has some fields (like Shape__Area) which don't appear directly useful.

Tax info can be found at the URL: https://common3.mptsweb.com/MBC/placer/tax/main/__APN__/2020/0000 where __APN__ is the APN without -'s. E.g. https://common3.mptsweb.com/MBC/placer/tax/main/466120044000/2020/0000. Tax amount is found in the Totals - 1st and 2nd Installments section.

[typpo]

@jamesshannon The Placer system looks identical to Yolo County's, which means much of the code can be reused! https://github.com/typpo/ca-property-tax/tree/master/scrapers/yolo

[jamesshannon]

I'm splitting discussion of Placer County off to #17

[typpo]

Data recently added:

• SLO (@kevbuchanan)
• San Diego (@swingley)
• Fresno (@miloconway)
• Butte (@miloconway)
• Orange (me)

In progress:

• Placer (@jamesshannon)
• Riverside (me)

I've created a spreadsheet that summarizes the status of all California counties: link. The good news is that with 19 out of 58 counties, we are now covering 75% of the state's population.