superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 3 and YR_EST = 2010
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13136 | 13136 | 13135 | {"type": "Polygon", "coordinates": [[[-122.61347, 38.57103], [-122.60977, 38.57104], [-122.60939, 38.57019], [-122.60879, 38.56687], [-122.61337, 38.56677], [-122.61347, 38.57103]]]} | No Public Access 3 | Willer Donation | 31822 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 42.634 | Willer Donation | 2010 | |
14706 | 14706 | 14705 | {"type": "MultiPolygon", "coordinates": [[[[-121.66883, 37.12359], [-121.66674, 37.12357], [-121.66651, 37.12332], [-121.66627, 37.12302], [-121.66597, 37.12252], [-121.66553, 37.12198], [-121.6661, 37.12198], [-121.66632, 37.12234], [-121.66625, 37.12238], [-121.66631, 37.12246], [-121.66637, 37.12244], [-121.66821, 37.12247], [-121.66883, 37.12359]]], [[[-121.67204, 37.11703], [-121.66846, 37.11719], [-121.6659, 37.11598], [-121.66581, 37.1145], [-121.67047, 37.11431], [-121.67204, 37.11703]]]]} | No Public Access 3 | El Toro Open Space Preserve | http://www.openspaceauthority.org | 18545 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 39.195 | El Toro OSP | 2010 |
15040 | 15040 | 15039 | {"type": "Polygon", "coordinates": [[[-121.8416, 37.7472], [-121.82536, 37.75118], [-121.82537, 37.7512], [-121.84132, 37.74732], [-121.84129, 37.7523], [-121.8324, 37.75239], [-121.83241, 37.75942], [-121.82329, 37.75956], [-121.82326, 37.75633], [-121.82328, 37.75239], [-121.8206, 37.75236], [-121.82304, 37.75176], [-121.82343, 37.73824], [-121.83817, 37.73833], [-121.84157, 37.73832], [-121.8416, 37.7472]]]} | No Public Access 3 | Doolan Canyon Regional Preserve | 33749 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 778.462 | Doolan Canyon RPr | 2010 |
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]);