superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, MNG_AGENCY = 441, MNG_AG_TYP = 2 and PARK_NAME = "Silverado Creek Maintenance District"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12818 | 12818 | 12817 | {"type": "MultiPolygon", "coordinates": [[[[-122.29905, 38.32779], [-122.29848, 38.32836], [-122.29839, 38.32842], [-122.29828, 38.32846], [-122.29818, 38.32846], [-122.29777, 38.32842], [-122.29755, 38.32853], [-122.29772, 38.32878], [-122.29764, 38.32883], [-122.29773, 38.32895], [-122.29741, 38.32886], [-122.29693, 38.32878], [-122.29676, 38.32872], [-122.29662, 38.32864], [-122.2972, 38.3285], [-122.29769, 38.32826], [-122.29767, 38.3282], [-122.29787, 38.32817], [-122.29791, 38.32814], [-122.29796, 38.32817], [-122.29801, 38.32814], [-122.29814, 38.32821], [-122.29825, 38.3282], [-122.29829, 38.32816], [-122.29829, 38.3281], [-122.29869, 38.32773], [-122.29876, 38.32764], [-122.29889, 38.32758], [-122.29905, 38.32779]]], [[[-122.29827, 38.33084], [-122.29801, 38.33096], [-122.29792, 38.33085], [-122.29785, 38.33081], [-122.29739, 38.3307], [-122.2972, 38.33046], [-122.29733, 38.3304], [-122.29776, 38.33062], [-122.29794, 38.33066], [-122.29796, 38.33065], [-122.29814, 38.33067], [-122.29827, 38.33084]]]]} | No Public Access 3 | Silverado Creek Maintenance District | 30030 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.348 | Silverado Creek Maintenance District |
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]);