superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 147 and PARK_NAME = "Pleasants Valley Park Acquisition"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11583 | 11583 | 11582 | {"type": "Polygon", "coordinates": [[[-122.02447, 38.35922], [-122.02441, 38.35963], [-122.02438, 38.35974], [-122.0243, 38.35989], [-122.02412, 38.36012], [-122.02319, 38.36106], [-122.02305, 38.36125], [-122.02297, 38.3614], [-122.0229, 38.36161], [-122.0229, 38.36183], [-122.02283, 38.36192], [-122.02274, 38.36194], [-122.02251, 38.36195], [-122.02234, 38.36194], [-122.02201, 38.36187], [-122.02148, 38.36165], [-122.02137, 38.36158], [-122.02129, 38.36152], [-122.02124, 38.36143], [-122.02123, 38.36125], [-122.02128, 38.36076], [-122.02126, 38.36039], [-122.02026, 38.36038], [-122.01853, 38.3603], [-122.01833, 38.36029], [-122.01799, 38.36023], [-122.0215, 38.35922], [-122.02447, 38.35922]]]} | Open Access 1 | Pleasants Valley Park Acquisition | 28085 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 19.725 | Pleasants Valley Park Acquisition |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);