Commit graph

15 commits

Author SHA1 Message Date
7a361a330d
Remove now-extraneous latitude/longitude generated columns
Now that we can pull out the geometry directly into a go object we don't
need these and they complicate our insertions
2026-05-07 16:38:42 +00:00
ac27c60e0c
Save address IDs when doing pool geocoding 2026-04-15 20:29:42 +00:00
59e58840c9
Fix address lat/lng location names, populate in report response 2026-04-14 15:43:49 +00:00
730f40956f
Store addresses on every geocode 2026-04-10 22:32:40 +00:00
6c79b8a85e
Add address GID to public report
This is _way_ better than trying to re-transmit structured address data
to the backend via strings
2026-04-08 14:40:27 +00:00
edfd8e285f
Add location x and y to address table
For easier reference
2026-03-20 17:59:13 +00:00
1e071d5ce5
Overhaul publicreport storage layer, create unified tables
This is a huge change. I was getting really sick of the split between
nuisance/water tables when more than half of the data they store is
common. I finally bit off the big work of switching it all.

This creates a single unified table, publicreport.report and copies the
existing report data into it. It also ports existing data from the
original tables into the new table.

Along with all of this I also overhauled the system for handling
asynchronous work to use a LISTEN/NOTIFY connection from the database
and a single cache table to avoid ever losing work.
2026-03-18 15:36:20 +00:00
e932c2c473
Rework publicreport addressing
This adds the ability to link a proper address in the database to the
report and harmonizes the field names with the address table. It also
migrates away from mapbox entirely.

And I fixed the "pool" naming for the publicreports, which are supposed
to be the more generic 'water'.
2026-03-09 18:02:22 +00:00
4494bd97cf
Rename address.geom to address.location
It's a better name.
2026-03-06 19:46:41 +00:00
527e82031e
Remove a bunch of generated bob, add feature and review tasks 2026-03-06 18:56:30 +00:00
daa8cb1748
Push geocoding down a layer
This makes it possible to always save address information from our
geocoder.
2026-03-04 18:29:52 +00:00
6aa7fa60b4
Add region (state) to address 2026-03-03 20:27:12 +00:00
a0eee3a95f
Rework mailer database schema, add UUID to mailers
At this point, I sent out our first test mailers for Delta.
2026-03-02 23:27:55 +00:00
91fe244da8
Add data for handling parcel images 2026-02-28 22:54:39 +00:00
7b1ffbab12
Add new tables for storing parcel and address data 2026-02-26 18:18:33 +00:00