superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=423"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
263 | 263 | 262 | {"type": "MultiPolygon", "coordinates": [[[[-123.755, 39.87752], [-123.75055, 39.8776], [-123.75066, 39.88592], [-123.75094, 39.88594], [-123.75092, 39.88684], [-123.75087, 39.88704], [-123.75058, 39.89043], [-123.75052, 39.89133], [-123.75038, 39.89109], [-123.749, 39.8906], [-123.74871, 39.89041], [-123.74865, 39.89024], [-123.74867, 39.89014], [-123.74908, 39.88965], [-123.7491, 39.88932], [-123.74952, 39.88837], [-123.74918, 39.88773], [-123.74887, 39.88724], [-123.7483, 39.88721], [-123.74779, 39.88698], [-123.74754, 39.88668], [-123.747, 39.88634], [-123.7459, 39.8862], [-123.74548, 39.88623], [-123.74448, 39.88606], [-123.74281, 39.88631], [-123.74168, 39.8868], [-123.74075, 39.88691], [-123.73998, 39.88672], [-123.73935, 39.88646], [-123.73875, 39.8863], [-123.73814, 39.88634], [-123.73792, 39.88625], [-123.73756, 39.88601], [-123.73747, 39.88542], [-123.73781, 39.8847], [-123.7379, 39.8844], [-123.73814, 39.88399], [-123.73821, 39.88343], [-123.73818, 39.88291], [-123.73798, 39.88262], [-123.73766, 39.88234], [-123.7366, 39.88168], [-123.73606, 39.88143], [-123.73523, 39.88072], [-123.73486, 39.88024], [-123.73477, 39.87985], [-123.7346, 39.8795], [-123.73434, 39.87912], [-123.73385, 39.87865], [-123.73272, 39.87868], [-123.73158, 39.87814], [-123.73089, 39.87795], [-123.73049, 39.8778], [-123.72278, 39.87776], [-123.72224, 39.87746], [-123.72231, 39.87425], [-123.72056, 39.87422], [-123.72014, 39.87474], [-123.71949, 39.8752], [-123.7185, 39.87573], [-123.71811, 39.87606], [-123.71783, 39.87654], [-123.71767, 39.8775], [-123.71887, 39.8775], [-123.71833, 39.87805], [-123.718, 39.87829], [-123.71745, 39.87862], [-123.71721, 39.8787], [-123.71683, 39.87878], [-123.7166, 39.8788], [-123.71643, 39.8787], [-123.71593, 39.87795], [-123.71439, 39.87795], [-123.71401, 39.87776], [-123.71342, 39.87738], [-123.71321, 39.8773], [-123.71297, 39.87726], [-123.71294, 39.87563], [-123.7128, 39.87542], [-123.71248, 39.8751], [-123.71232, 39.87497], [-123.71216, 39.87468], [-123.71205, 39.87422], [-123.71206, 39.87371], [-123.71204, 39.8734], [-123.71211, 39.87311], [-123.71225, 39.87281], [-123.71274, 39.87221], [-123.71296, 39.872], [-123.71319, 39.87186], [-123.7131, 39.87078], [-123.71373, 39.87073], [-123.71771, 39.87076], [-123.73169, 39.87066], [-123.73178, 39.86706], [-123.73285, 39.86693], [-123.73306, 39.86696], [-123.7332, 39.86793], [-123.73633, 39.86793], [-123.73636, 39.87067], [-123.7411, 39.87063], [-123.74117, 39.87419], [-123.74549, 39.87415], [-123.75493, 39.87397], [-123.75503, 39.87595], [-123.755, 39.87752]]], [[[-123.71375, 39.87805], [-123.71298, 39.87807], [-123.71302, 39.87765], [-123.7134, 39.87773], [-123.7136, 39.87785], [-123.71375, 39.87805]]], [[[-123.73643, 39.88607], [-123.73235, 39.88614], [-123.73237, 39.88849], [-123.72993, 39.88851], [-123.72993, 39.88603], [-123.72945, 39.88602], [-123.72928, 39.87809], [-123.73095, 39.87825], [-123.73203, 39.87858], [-123.73261, 39.87927], [-123.73299, 39.88019], [-123.73283, 39.88058], [-123.73328, 39.88099], [-123.73332, 39.88171], [-123.734, 39.88208], [-123.7339, 39.88264], [-123.73432, 39.88267], [-123.73433, 39.88311], [-123.73504, 39.88356], [-123.73643, 39.88607]]]]} | Open Access 1 | Standish-Hickey State Recreation Area | http://www.parks.ca.gov/?page_id=423 | 1755 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1010.932 | Standish-Hickey SRA | 1921 |
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]);