21e8b9880d
Remove report_location view, add lat lng to report table
2026-03-18 18:55:50 +00:00
341c3ef6b9
Fix publicreport creation
...
The consistency is good, but I added some errors, like not using an enum
2026-03-18 18:45:18 +00:00
1d2570c912
Add DB model for publicreport logs
...
It's just way easier to track that deriving the data every time an API
request is made.
2026-03-18 17:32:06 +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
2538638c9d
Create generic backend process, fix background interdependencies
...
This refactor was born out of the inter-dependency cycles developing
between the "background" module and just about every other module which
was caused by the background module becoming a dependency of every
module that needed to background work and the fact that the background
module was also supposedly responsible for the logic for processing
those tasks.
Instead the "background" module is now very, very shallow and relies
entirely on the Postgres NOTIFY logic for triggering jobs. There's a new
table, `job` which holds just a type and single row ID.
All told, this means that jobs can be added to the queue as part of the
API-level or platform-level transaction, ensuring atomicity, and
processing coordination is handled by the platform module, which can
depend on anything.
2026-03-16 19:52:29 +00:00
cc95c38ab5
Initial creation of endpoint to send messages to public reporters
2026-03-16 00:20:41 +00:00
1a9a72adc0
Create district catch-all, make organization on public reports not null
2026-03-14 15:53:16 +00:00
e2af49a323
Make lead creation and invalidation for public reports work
...
The only thing wrong at this point that I can tell is that address
aren't being correctly populated when I reverse geocode.
2026-03-14 01:14:30 +00:00
32dcc50c94
Add new view for report counts and invalidated status
...
Also drop site.version from the primary key.
2026-03-12 15:27:36 +00:00
10b4bf929f
Add resolution for tracking review_task discards
2026-03-11 22:49:55 +00:00
3ccc05d4c5
Save tiles to the database to make empty tile load faster
2026-03-11 17:01:47 +00:00
5e7c547670
Fix map display on RMO status-by-id page
...
This involves rebuilding the "publicreport.report_location" view after
making a bunch of changes to making publicreport.water the consistent
name (over pool) throughout RMA tables.
2026-03-11 14:59:04 +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
2f7ecdfae8
Move publicreport.image to have a point location
2026-03-09 00:48:44 +00:00
cfe399e44f
Add address number to public reports
2026-03-08 03:16:58 +00:00
1e80c62701
Migrate public report classes to point location
...
...and drop quick report tables
2026-03-08 02:43:00 +00:00
e1bcbf79b1
Add tile cache and relationship to organization map layer
2026-03-06 21:13:32 +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
f97e769d4b
Add specific location via geometry column on pool
2026-03-05 18:38:22 +00:00
78a35e5d1f
Make parcels attached to addresses optional
2026-03-05 02:30:12 +00:00
60344e3c30
Relate compliance report requests through leads
2026-03-05 01:22:21 +00:00
9c3d2ba3df
Remove organization from fileupload.pool table, fix in district logic
2026-03-04 20:59:57 +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
6959499d37
Add signal database schema
2026-03-04 14:58:43 +00:00
6a5a59f8b8
Merge aerial flyover and pool CSV row datatypes
...
They are extremely similar, having both was just extra work.
2026-03-04 14:52:34 +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
ff2ec0ad14
Split out ability to upload flyover data from pool uploads
...
Tons of changes here, all in the name of quickly getting to where I can
create test compliance letters.
2026-03-02 18:49:02 +00:00
b292f47d47
Clean up removed generated bob files
2026-02-28 23:21:14 +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
2bb4a134b2
Add centroid information when geocoding
...
I would use the boundary rect, but I'm getting a 500-level error from
stadia maps
2026-02-25 16:08:32 +00:00
7ea66dc02e
Add user account roles
2026-02-18 07:03:32 +00:00
5a7c9fd090
Move data out of import.district and in to organization
...
Then get the organization settings page to work again.
Tons of other stuff is broken now.
2026-02-17 05:33:12 +00:00
a65f1e0776
Fix up attaching errors to rows
2026-02-16 17:59:18 +00:00
ef569aef18
Save tags on pool rows, show errors in summary table
2026-02-16 16:38:04 +00:00
f859e372c6
Fill in correct data about the district
2026-02-16 15:26:41 +00:00
a1cc2dbaff
Add district setting page and display of district boundary
2026-02-16 15:03:26 +00:00
2bc0e18b9e
Actually finish uploaded files
2026-02-14 05:40:27 +00:00
bdd862e649
Show actual information on oauth integration setting page
2026-02-13 21:14:46 +00:00
e40fe55eaf
Modify email subscription table to drop district ID
...
I don't have time to work out all the behavior, this is just to get to
where I can release
2026-02-10 05:12:42 +00:00
d93cdbef41
Drop district_id from subscriptions
2026-02-10 04:59:27 +00:00
b25daf12fa
Add table for holding subscriptions from users
2026-02-10 04:31:57 +00:00
d06b8f7949
Add mode data to pool upload rows, move to fileupload schema
...
This allows users to review the data before committing it to the
database
2026-02-09 19:03:27 +00:00
135ad2b73e
Do file upload, show list of uploads, do initial processing.
2026-02-09 18:25:44 +00:00
f9c8f37cec
Add organization to file upload
...
So everyone in the org can see it.
2026-02-08 05:00:14 +00:00
6716bc68c9
Make file uploads of CSV actually save to disk
2026-02-08 01:44:44 +00:00
57191fa222
Alter report submission page to request reporter name and consent
...
This also adds the new mechanism for handling notifications on reports
2026-02-06 15:39:49 +00:00
9328e7a2f8
Properly record and display pool reports
2026-02-05 21:43:29 +00:00
