units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, LABEL_NAME = "Rancho Bernardo OS" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4985 | 4985 | 4984 | {"type": "Polygon", "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.04245], [-117.06973, 33.04246], [-117.06954, 33.04239], [-117.06934, 33.0422], [-117.0698, 33.04173], [-117.06934, 33.04116], [-117.07006, 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.04012], [-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.07215, 33.04154], [-117.07232, 33.04163], [-117.07312, 33.04128], [-117.07317, 33.04129]]]} | Open Access 1 | 18664 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 19.326 | Rancho Bernardo OS | 0 | Local Recreation Area 3 | 4 | |
10106 | 10106 | 10105 | {"type": "Polygon", "coordinates": [[[-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.07592, 33.04025], [-117.07639, 33.04032], [-117.07681, 33.0401], [-117.0774, 33.04013], [-117.07797, 33.04027]]]} | Open Access 1 | 18640 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 26.317 | Rancho Bernardo OS | 0 | Local Recreation Area 3 | 4 | |
10107 | 10107 | 10106 | {"type": "Polygon", "coordinates": [[[-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 | 18646 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.746 | Rancho Bernardo OS | 0 | Local Recreation Area 3 | 4 | |
10384 | 10384 | 10383 | {"type": "Polygon", "coordinates": [[[-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]]]} | Open Access 1 | 18639 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 10.0 | Rancho Bernardo OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);