units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Palm Park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1704 | 1704 | 1703 | {"type": "MultiPolygon", "coordinates": [[[[-118.05718, 33.99178], [-118.05479, 33.99178], [-118.05477, 33.99], [-118.05543, 33.99001], [-118.05718, 33.99178]]], [[[-118.05829, 33.99261], [-118.05747, 33.99178], [-118.05572, 33.99], [-118.05744, 33.98999], [-118.05804, 33.99178], [-118.05829, 33.99261]]]]} | Open Access 1 | 6541 | Palm Park | 23346 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.607 | Palm Park | 0 | Local Park 2 | 4 | |
6012 | 6012 | 6011 | {"type": "Polygon", "coordinates": [[[-117.18055, 32.69876], [-117.18036, 32.6991], [-117.18016, 32.69861], [-117.18016, 32.69861], [-117.18055, 32.69876]]]} | Open Access 1 | 814 | Palm Park | 23344 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.203 | Palm Park | 0 | Local Park 2 | 4 |
7411 | 7411 | 7410 | {"type": "MultiPolygon", "coordinates": [[[[-118.29946, 34.19377], [-118.29936, 34.19386], [-118.29936, 34.19389], [-118.29915, 34.19409], [-118.29915, 34.19402], [-118.29932, 34.19385], [-118.29946, 34.19377]]], [[[-118.29955, 34.19439], [-118.29945, 34.19447], [-118.29928, 34.19425], [-118.29916, 34.19411], [-118.29917, 34.1941], [-118.29955, 34.19439]]], [[[-118.29935, 34.19458], [-118.29818, 34.19567], [-118.29755, 34.19631], [-118.29718, 34.19571], [-118.29721, 34.19553], [-118.29714, 34.19546], [-118.29597, 34.19535], [-118.29595, 34.19531], [-118.29645, 34.19512], [-118.2969, 34.19471], [-118.297, 34.19477], [-118.29711, 34.19477], [-118.29714, 34.19474], [-118.29724, 34.19449], [-118.29729, 34.19451], [-118.29759, 34.19414], [-118.29778, 34.19388], [-118.29804, 34.19363], [-118.29797, 34.19357], [-118.29804, 34.1935], [-118.29782, 34.19333], [-118.29783, 34.19329], [-118.29786, 34.19327], [-118.29859, 34.19334], [-118.29891, 34.19357], [-118.29896, 34.19365], [-118.299, 34.19416], [-118.29935, 34.19458]]]]} | Open Access 1 | 6831 | Palm Park | 23343 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 10.755 | Palm Park | 0 | Local Park 2 | 4 | |
8661 | 8661 | 8660 | {"type": "Polygon", "coordinates": [[[-122.22752, 37.47069], [-122.22724, 37.47091], [-122.22736, 37.47102], [-122.22714, 37.4712], [-122.22645, 37.47104], [-122.22721, 37.47044], [-122.22752, 37.47069]]]} | Open Access 1 | 13900 | Palm Park | 23345 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.953 | Palm Park | 1979 | Local Park 2 | 4 | |
14844 | 14844 | 14843 | {"type": "Polygon", "coordinates": [[[-118.13963, 33.87665], [-118.13948, 33.87676], [-118.1383, 33.87688], [-118.135, 33.87693], [-118.13403, 33.8769], [-118.13403, 33.8767], [-118.13963, 33.87665]]]} | Open Access 1 | 45351 | Palm Park | 23342 | 1024 | Bellflower, City of 449 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | City 2 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.952 | Palm Park | 0 | Local Park 2 | 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]);