superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 2 and PARK_NAME = "Silverado Creek Maintenance District"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 1
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12819 | 12819 | 12818 | {"type": "Polygon", "coordinates": [[[-122.29798, 38.33067], [-122.2977, 38.3306], [-122.29733, 38.3304], [-122.29738, 38.33037], [-122.29738, 38.33035], [-122.2971, 38.33019], [-122.29687, 38.33011], [-122.29654, 38.33007], [-122.29575, 38.33011], [-122.29559, 38.33009], [-122.29548, 38.33005], [-122.29536, 38.33], [-122.29524, 38.32991], [-122.29512, 38.32975], [-122.29513, 38.32973], [-122.29505, 38.32962], [-122.29489, 38.32949], [-122.29377, 38.32872], [-122.29434, 38.32843], [-122.29473, 38.32871], [-122.29487, 38.32874], [-122.29508, 38.32873], [-122.29513, 38.32885], [-122.29533, 38.3288], [-122.29577, 38.32878], [-122.29645, 38.32868], [-122.29666, 38.32881], [-122.29641, 38.32889], [-122.29616, 38.32894], [-122.29587, 38.32897], [-122.29553, 38.32898], [-122.29532, 38.32901], [-122.29516, 38.32904], [-122.29512, 38.32911], [-122.29524, 38.3297], [-122.29541, 38.32981], [-122.29557, 38.3298], [-122.29556, 38.32988], [-122.2956, 38.32994], [-122.2957, 38.32996], [-122.29584, 38.32991], [-122.29655, 38.32983], [-122.29684, 38.32984], [-122.29713, 38.32989], [-122.29742, 38.33002], [-122.29773, 38.33028], [-122.29771, 38.33033], [-122.29798, 38.33067]]]} | Open Access 1 | Silverado Creek Maintenance District | 30031 | 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 | 4.306 | 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]);