units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
277 rows where AGNCY_NAME = 4 and DES_TP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1300 | 1300 | 1299 | {"type": "Polygon", "coordinates": [[[-117.24193, 32.80867], [-117.24174, 32.80869], [-117.24161, 32.80874], [-117.24159, 32.80866], [-117.2419, 32.80859], [-117.24193, 32.80867]]]} | Open Access 1 | 7345 | Color Mini-Park | 30090 | 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.058 | Color Mini-Park | 0 | Local Park 2 | 4 | |
5775 | 5775 | 5774 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | 5 | Zena Mini-Park | 27862 | 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.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
5821 | 5821 | 5820 | {"type": "Polygon", "coordinates": [[[-117.08852, 32.70427], [-117.08852, 32.70444], [-117.08831, 32.70444], [-117.08831, 32.70431], [-117.08833, 32.70428], [-117.08852, 32.70427]]]} | Open Access 1 | 46762 | Walls of Excellence Mini-Park | 30213 | 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.087 | Walls of Excellence Mini-Park | 0 | Local Park 2 | 4 | |
15438 | 15438 | 15437 | {"type": "Polygon", "coordinates": [[[-117.23713, 32.71023], [-117.23714, 32.71027], [-117.23708, 32.71051], [-117.23699, 32.71048], [-117.23698, 32.7103], [-117.23704, 32.71021], [-117.23713, 32.71023]]]} | Open Access 1 | 46708 | McCall Street Mini-Park | 30099 | 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.089 | McCall Street Mini-Park | 0 | Local Park 2 | 4 | |
10722 | 10722 | 10721 | {"type": "Polygon", "coordinates": [[[-117.14353, 32.71085], [-117.14337, 32.71085], [-117.14337, 32.71057], [-117.14353, 32.71057], [-117.14353, 32.71085]]]} | Open Access 1 | 19927 | Sherman Mini-Park | 30102 | 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.117 | Sherman Mini-Park | 0 | Local Park 2 | 4 | |
591 | 591 | 590 | {"type": "Polygon", "coordinates": [[[-117.16091, 32.71066], [-117.16057, 32.71067], [-117.16057, 32.71053], [-117.16091, 32.71052], [-117.16091, 32.71066]]]} | Open Access 1 | 2008 | Davis House Mini Park | 17950 | 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.118 | Davis House MP | 0 | Local Park 2 | 4 | |
85 | 85 | 84 | {"type": "Polygon", "coordinates": [[[-117.2351, 32.72159], [-117.23488, 32.72151], [-117.23474, 32.72148], [-117.23481, 32.72123], [-117.23487, 32.72124], [-117.23492, 32.72139], [-117.235, 32.72149], [-117.2351, 32.72159]]]} | Open Access 1 | 221 | Cabrillo Mini-Park South | 30118 | 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.12 | Cabrillo Mini-Park South | 0 | Local Park 2 | 4 | |
13727 | 13727 | 13726 | {"type": "Polygon", "coordinates": [[[-117.10185, 32.75039], [-117.10185, 32.75069], [-117.10169, 32.75069], [-117.10169, 32.75039], [-117.10185, 32.75039]]]} | Open Access 1 | 48831 | City Heights Square Mini Park | 33550 | 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.123 | City Heights Square MP | 0 | Local Park 2 | 4 | |
5776 | 5776 | 5775 | {"type": "Polygon", "coordinates": [[[-117.12088, 32.74978], [-117.12063, 32.74969], [-117.12063, 32.74952], [-117.12075, 32.74941], [-117.12088, 32.74978]]]} | Open Access 1 | 6 | Wabash Neighborhood Park | 30119 | 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.131 | Wabash Neighborhood Park | 0 | Local Park 2 | 4 | |
7643 | 7643 | 7642 | {"type": "Polygon", "coordinates": [[[-117.16198, 32.71308], [-117.16185, 32.71308], [-117.16185, 32.71266], [-117.16198, 32.71267], [-117.16198, 32.71308]]]} | Open Access 1 | 47731 | G Street Mini Park | 31532 | 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.138 | G Street MP | 0 | Local Park 2 | 4 | |
4151 | 4151 | 4150 | {"type": "Polygon", "coordinates": [[[-117.12552, 32.73807], [-117.12552, 32.73821], [-117.12512, 32.73821], [-117.12512, 32.73807], [-117.12552, 32.73807]]]} | Open Access 1 | 47523 | 32nd Street Mini Park | 31228 | 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.143 | 32nd Street MP | 0 | Local Park 2 | 4 | |
573 | 573 | 572 | {"type": "Polygon", "coordinates": [[[-117.07921, 32.69788], [-117.079, 32.69789], [-117.07891, 32.69768], [-117.0791, 32.69765], [-117.07915, 32.69766], [-117.07919, 32.6977], [-117.07921, 32.69788]]]} | Open Access 1 | 1899 | Santa Isabel Mini-Park | 25092 | 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.144 | Santa Isabel Mini-Park | 0 | Local Park 2 | 4 | |
2464 | 2464 | 2463 | {"type": "Polygon", "coordinates": [[[-117.12737, 32.76657], [-117.12714, 32.76651], [-117.12709, 32.76645], [-117.12721, 32.76614], [-117.12737, 32.76657]]]} | Open Access 1 | 18876 | Kenmore Terrace Mini-Park | 30055 | 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.146 | Kenmore Terrace Mini-Park | 0 | Local Park 2 | 4 | |
6406 | 6406 | 6405 | {"type": "Polygon", "coordinates": [[[-117.1194, 32.69936], [-117.11924, 32.69936], [-117.11924, 32.699], [-117.1194, 32.699], [-117.1194, 32.69936]]]} | Open Access 1 | 1879 | Martin Ave Mini-Park | 21902 | 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.149 | Martin Ave Mini-Park | 0 | Local Park 2 | 4 | |
6393 | 6393 | 6392 | {"type": "Polygon", "coordinates": [[[-117.13376, 32.70693], [-117.13375, 32.70731], [-117.13361, 32.70731], [-117.1336, 32.70693], [-117.13376, 32.70693]]]} | Open Access 1 | 1810 | L Street Mini Park | 20736 | 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.151 | L Street MP | 0 | Local Park 2 | 4 | |
1312 | 1312 | 1311 | {"type": "Polygon", "coordinates": [[[-117.27039, 32.84609], [-117.27014, 32.84608], [-117.26993, 32.8462], [-117.27002, 32.84597], [-117.27002, 32.84574], [-117.27016, 32.84595], [-117.27039, 32.84609]]]} | Open Access 1 | 7339 | Union Place Circle Mini-Park | 30081 | 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.154 | Union Place Circle Mini-Park | 0 | Local Park 2 | 4 | |
4187 | 4187 | 4186 | {"type": "Polygon", "coordinates": [[[-117.14245, 32.70033], [-117.1424, 32.70037], [-117.14215, 32.70029], [-117.14184, 32.70014], [-117.14188, 32.70009], [-117.14205, 32.70014], [-117.14216, 32.70013], [-117.14245, 32.70033]]]} | Open Access 1 | 1915 | Chicano Park | 17188 | 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.158 | Chicano Park | 0 | Local Park 2 | 4 | |
1311 | 1311 | 1310 | {"type": "Polygon", "coordinates": [[[-117.26402, 32.84939], [-117.26407, 32.8495], [-117.26406, 32.84954], [-117.26397, 32.8496], [-117.26395, 32.84966], [-117.26387, 32.84972], [-117.26384, 32.84976], [-117.26363, 32.84974], [-117.26402, 32.84939]]]} | Open Access 1 | 7338 | Charlotte Park | 17149 | 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.16 | Charlotte Park | 0 | Local Park 2 | 4 | |
2936 | 2936 | 2935 | {"type": "Polygon", "coordinates": [[[-117.17, 32.73053], [-117.16959, 32.73066], [-117.16954, 32.73064], [-117.16949, 32.73055], [-117.16992, 32.73042], [-117.17, 32.73053]]]} | Open Access 1 | 19917 | Laurel Street Mini-Park | 30117 | 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.16 | Laurel Street Mini-Park | 0 | Local Park 2 | 4 | |
6434 | 6434 | 6433 | {"type": "Polygon", "coordinates": [[[-117.10586, 32.68969], [-117.1057, 32.68969], [-117.10569, 32.68931], [-117.10586, 32.68931], [-117.10586, 32.68969]]]} | Open Access 1 | 1958 | 41st Street Mini-Park | 15201 | 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.161 | 41st Street Mini-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]);