superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and LABEL_NAME = "Rancho Bernardo OS"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14924 | 14924 | 14923 | {"type": "MultiPolygon", "coordinates": [[[[-117.07317, 33.04129], [-117.07272, 33.04158], [-117.07248, 33.04177], [-117.07222, 33.04203], [-117.07193, 33.04238], [-117.07178, 33.04251], [-117.07149, 33.04266], [-117.07131, 33.04272], [-117.07111, 33.04276], [-117.07053, 33.04278], [-117.06987, 33.04274], [-117.06987, 33.04246], [-117.06973, 33.04246], [-117.06954, 33.04239], [-117.06934, 33.0422], [-117.0698, 33.04173], [-117.06934, 33.04116], [-117.07005, 33.04122], [-117.07007, 33.04105], [-117.07045, 33.04106], [-117.07048, 33.04081], [-117.07056, 33.0408], [-117.07062, 33.04076], [-117.07066, 33.04072], [-117.07069, 33.04066], [-117.07077, 33.04013], [-117.07076, 33.04009], [-117.07084, 33.03969], [-117.07086, 33.03954], [-117.07141, 33.03952], [-117.07271, 33.039], [-117.07304, 33.03917], [-117.07281, 33.0398], [-117.07242, 33.04014], [-117.07236, 33.04134], [-117.07216, 33.04154], [-117.07232, 33.04163], [-117.07312, 33.04128], [-117.07317, 33.04129]]], [[[-117.0758, 33.05332], [-117.07486, 33.05461], [-117.07464, 33.05489], [-117.07427, 33.05519], [-117.0739, 33.05528], [-117.07358, 33.05544], [-117.07325, 33.05464], [-117.07308, 33.05394], [-117.0731, 33.05312], [-117.07325, 33.05324], [-117.07328, 33.05322], [-117.07345, 33.05331], [-117.07363, 33.05332], [-117.07546, 33.05313], [-117.0758, 33.05332]]], [[[-117.07797, 33.04027], [-117.07781, 33.04086], [-117.07775, 33.041], [-117.07751, 33.04143], [-117.07715, 33.04186], [-117.07433, 33.04471], [-117.07392, 33.04523], [-117.07373, 33.04559], [-117.07364, 33.04581], [-117.07355, 33.04621], [-117.07353, 33.0464], [-117.07351, 33.04778], [-117.07352, 33.04803], [-117.07355, 33.04829], [-117.07367, 33.04871], [-117.0739, 33.04915], [-117.07417, 33.04948], [-117.07446, 33.04974], [-117.07529, 33.05034], [-117.07489, 33.05026], [-117.07438, 33.05012], [-117.07409, 33.05017], [-117.0738, 33.05008], [-117.07337, 33.05008], [-117.07325, 33.04781], [-117.07336, 33.04649], [-117.07338, 33.04594], [-117.07363, 33.04519], [-117.07446, 33.04369], [-117.07462, 33.04237], [-117.07561, 33.03984], [-117.07592, 33.04019], [-117.07593, 33.04026], [-117.07639, 33.04032], [-117.07681, 33.0401], [-117.0774, 33.04013], [-117.07797, 33.04027]]], [[[-117.0883, 33.04361], [-117.08826, 33.04399], [-117.08819, 33.04412], [-117.08796, 33.04409], [-117.08767, 33.04391], [-117.08764, 33.04374], [-117.08753, 33.04348], [-117.08757, 33.04346], [-117.0878, 33.04366], [-117.08789, 33.04359], [-117.0883, 33.04361]]]]} | Open Access 1 | Rancho Bernardo Open Space | 24130 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 56.408 | Rancho Bernardo OS |
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]);