units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where UNIT_NAME = "Garfield Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310 | 310 | 309 | {"type": "Polygon", "coordinates": [[[-117.7344, 34.06396], [-117.73343, 34.06398], [-117.73339, 34.06293], [-117.7344, 34.06291], [-117.7344, 34.06396]]]} | Open Access 1 | 839 | Garfield Park | 19215 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 2.655 | Garfield Park | 0 | Local Park 2 | 4 | |
1052 | 1052 | 1051 | {"type": "Polygon", "coordinates": [[[-118.14761, 34.11561], [-118.14713, 34.11686], [-118.14711, 34.11686], [-118.14708, 34.11692], [-118.14706, 34.11702], [-118.14668, 34.11802], [-118.14657, 34.11825], [-118.14637, 34.11854], [-118.14609, 34.11883], [-118.14581, 34.11883], [-118.14576, 34.1182], [-118.14641, 34.11565], [-118.14761, 34.11561]]]} | Open Access 1 | 5653 | Garfield Park | 19217 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | Los Angeles 6 | 7.505 | Garfield Park | 0 | Local Park 2 | 4 | |
5041 | 5041 | 5040 | {"type": "Polygon", "coordinates": [[[-122.23485, 37.78563], [-122.23432, 37.7862], [-122.23352, 37.78576], [-122.23411, 37.78532], [-122.23485, 37.78563]]]} | Open Access 1 | 13351 | Garfield Park | 19213 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.445 | Garfield Park | 0 | Local Park 2 | 4 | |
8843 | 8843 | 8842 | {"type": "Polygon", "coordinates": [[[-122.30257, 38.33174], [-122.30009, 38.33299], [-122.29868, 38.33123], [-122.29887, 38.33115], [-122.29897, 38.33107], [-122.29953, 38.33077], [-122.29956, 38.33079], [-122.29991, 38.33061], [-122.30058, 38.33052], [-122.30079, 38.33048], [-122.3009, 38.33044], [-122.30104, 38.33034], [-122.30124, 38.33028], [-122.30135, 38.33029], [-122.30139, 38.33028], [-122.30257, 38.33174]]]} | Open Access 1 | 14452 | Garfield Park | 19218 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 14.0 | Garfield Park | 0 | Local Park 2 | 4 | |
9555 | 9555 | 9554 | {"type": "Polygon", "coordinates": [[[-122.04308, 36.95834], [-122.04233, 36.95843], [-122.04218, 36.95748], [-122.04293, 36.95738], [-122.04308, 36.95834]]]} | Open Access 1 | 16414 | Garfield Park | 19216 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.778 | Garfield Park | 0 | Local Park 2 | 4 | |
12610 | 12610 | 12609 | {"type": "Polygon", "coordinates": [[[-118.16982, 33.89865], [-118.16899, 33.89865], [-118.16899, 33.89833], [-118.16906, 33.89827], [-118.16982, 33.89827], [-118.16982, 33.89865]]]} | Open Access 1 | 29325 | Garfield Park | 19214 | 1245 | Paramount, City of 285 | City 2 | City Agency 2 | http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 | City 2 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 0.795 | Garfield 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]);