superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACRES = "2.918"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6644 | 6644 | 6643 | {"type": "MultiPolygon", "coordinates": [[[[-122.52978, 37.8954], [-122.52954, 37.89543], [-122.52847, 37.89519], [-122.52798, 37.89489], [-122.5279, 37.89438], [-122.52814, 37.89335], [-122.52828, 37.89337], [-122.52811, 37.89431], [-122.52822, 37.89474], [-122.52855, 37.89493], [-122.52945, 37.89515], [-122.52977, 37.89515], [-122.52978, 37.8954]]], [[[-122.53527, 38.06893], [-122.5352, 38.06916], [-122.53501, 38.06911], [-122.53442, 38.06923], [-122.53406, 38.06927], [-122.53308, 38.06944], [-122.53252, 38.06952], [-122.53229, 38.06957], [-122.53239, 38.06949], [-122.5325, 38.06943], [-122.5325, 38.06937], [-122.53297, 38.06927], [-122.53439, 38.06908], [-122.53527, 38.06893]]]]} | No Public Access 3 | Marin Audubon Society | 21815 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 2.918 | Marin Audubon Society | ||
8558 | 8558 | 8557 | {"type": "Polygon", "coordinates": [[[-117.78052, 33.66198], [-117.78052, 33.66204], [-117.78004, 33.66252], [-117.77971, 33.66281], [-117.77938, 33.66301], [-117.77934, 33.66295], [-117.77937, 33.66293], [-117.77939, 33.66289], [-117.77936, 33.66283], [-117.77923, 33.66266], [-117.77886, 33.66229], [-117.7792, 33.66209], [-117.77967, 33.66174], [-117.77987, 33.66157], [-117.77992, 33.66157], [-117.78052, 33.66198]]]} | Restricted Access 2 | Ravencreek Park | 24198 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Private 14 | 2.918 | Ravencreek Park |
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]);