units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
281 rows where DES_TP = 2 and MNG_AGENCY = 4 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST
AGNCY_LEV 4 ✖
- City 277
- State 2
- County 1
- Special District 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 281
MNG_AGENCY 1
- San Diego, City of · 281 ✖
DES_TP 1
- Local Park · 281 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
13700 | 13700 | 13699 | {"type": "Polygon", "coordinates": [[[-117.10891, 32.76431], [-117.10845, 32.76431], [-117.10847, 32.76337], [-117.10865, 32.76342], [-117.10891, 32.76431]]]} | Open Access 1 | 48830 | Terrace Drive Mini Park | 33549 | 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 | https://www.sandiego.gov/sites/default/files/adams.pdf | San Diego 4 | 0.759 | Terrace Drive MP | 0 | Local Park 2 | 4 |
11519 | 11519 | 11518 | {"type": "Polygon", "coordinates": [[[-117.15865, 32.90484], [-117.15766, 32.9055], [-117.15764, 32.9055], [-117.15694, 32.90501], [-117.15673, 32.90517], [-117.15582, 32.90455], [-117.15595, 32.90437], [-117.15623, 32.90451], [-117.15631, 32.9044], [-117.15716, 32.90483], [-117.15808, 32.90422], [-117.15865, 32.90484]]]} | Open Access 1 | 48230 | Salk Neighborhood Park | 30831 | 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 | 3.974 | Salk Neighborhood Park | 0 | Local Park 2 | 4 | |
8018 | 8018 | 8017 | {"type": "Polygon", "coordinates": [[[-117.07726, 32.82341], [-117.07515, 32.82374], [-117.07514, 32.82348], [-117.07463, 32.82217], [-117.07561, 32.82194], [-117.07704, 32.82323], [-117.07726, 32.82341]]]} | Open Access 1 | 47737 | Camp Elliott Neighborhood Park | 31540 | 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 | 6.611 | Camp Elliott Neighborhood Park | 0 | Local Park 2 | 4 | |
8009 | 8009 | 8008 | {"type": "Polygon", "coordinates": [[[-117.21811, 32.87657], [-117.21809, 32.87661], [-117.218, 32.87664], [-117.21696, 32.87666], [-117.21654, 32.87677], [-117.2164, 32.87634], [-117.21541, 32.87589], [-117.21425, 32.87618], [-117.21425, 32.87547], [-117.21431, 32.87534], [-117.21436, 32.87529], [-117.21448, 32.87522], [-117.21463, 32.87518], [-117.21746, 32.87517], [-117.21749, 32.87594], [-117.21811, 32.8764], [-117.21811, 32.87657]]]} | Open Access 1 | 47736 | Weiss Mandell Eastgate Neighborhood Park | 31539 | 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 | 9.754 | Weiss Mandell Eastgate Neighborhood Park | 0 | Local Park 2 | 4 | |
8008 | 8008 | 8007 | {"type": "Polygon", "coordinates": [[[-117.16727, 32.71112], [-117.16654, 32.71073], [-117.16629, 32.71062], [-117.16603, 32.71054], [-117.16572, 32.71049], [-117.16572, 32.7102], [-117.16725, 32.71103], [-117.16727, 32.71112]]]} | Open Access 1 | 47735 | King, Jr. Promenade Park | 31538 | 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.483 | King, Jr. Promenade Park | 0 | Local Park 2 | 4 | |
7807 | 7807 | 7806 | {"type": "Polygon", "coordinates": [[[-117.11293, 32.81673], [-117.11252, 32.81766], [-117.11164, 32.81742], [-117.11146, 32.81776], [-117.11149, 32.81779], [-117.11054, 32.81797], [-117.11042, 32.81793], [-117.11036, 32.81787], [-117.11033, 32.81791], [-117.11028, 32.81791], [-117.1101, 32.81788], [-117.11003, 32.81789], [-117.10987, 32.81794], [-117.10979, 32.818], [-117.10978, 32.81808], [-117.10942, 32.81814], [-117.10938, 32.8178], [-117.11012, 32.81739], [-117.11026, 32.81733], [-117.11059, 32.81724], [-117.11189, 32.81656], [-117.11264, 32.81638], [-117.11273, 32.81639], [-117.11284, 32.81645], [-117.11287, 32.81651], [-117.11285, 32.81659], [-117.11293, 32.81673]]]} | Open Access 1 | 47732 | Damato Park | 31533 | 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 | 6.967 | Damato 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 | |
7764 | 7764 | 7763 | {"type": "Polygon", "coordinates": [[[-117.05995, 32.79051], [-117.05985, 32.79091], [-117.05962, 32.79212], [-117.05724, 32.792], [-117.05709, 32.79219], [-117.05701, 32.79214], [-117.05719, 32.79191], [-117.05734, 32.79033], [-117.05995, 32.79051]]]} | Open Access 1 | 47663 | Pasatiempo Neighborhood Park | 31403 | 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.697 | Pasatiempo Neighborhood Park | 0 | Local Park 2 | 4 | |
7632 | 7632 | 7631 | {"type": "Polygon", "coordinates": [[[-117.09477, 32.73317], [-117.09468, 32.73326], [-117.09471, 32.73329], [-117.09294, 32.73506], [-117.09199, 32.73506], [-117.09262, 32.73397], [-117.09333, 32.73319], [-117.09477, 32.73317]]]} | Open Access 1 | 47653 | Charles L. Lewis III Memorial Park | 31396 | 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 | 6.224 | Charles L. Lewis III Memorial Park | 0 | Local Park 2 | 4 | |
7555 | 7555 | 7554 | {"type": "Polygon", "coordinates": [[[-117.02716, 32.57161], [-117.02625, 32.5719], [-117.02589, 32.5711], [-117.02577, 32.57094], [-117.02564, 32.57082], [-117.02547, 32.57071], [-117.02522, 32.5706], [-117.02501, 32.57054], [-117.02477, 32.57052], [-117.02459, 32.57053], [-117.02427, 32.5706], [-117.02399, 32.57074], [-117.02375, 32.57093], [-117.02269, 32.57021], [-117.02263, 32.56916], [-117.02312, 32.56929], [-117.0232, 32.5694], [-117.02325, 32.56944], [-117.02381, 32.56969], [-117.02395, 32.56992], [-117.02418, 32.56988], [-117.02471, 32.56986], [-117.02489, 32.56983], [-117.02503, 32.56978], [-117.02526, 32.56966], [-117.0254, 32.56956], [-117.02554, 32.56942], [-117.02626, 32.56929], [-117.02631, 32.56932], [-117.02656, 32.56937], [-117.02697, 32.56951], [-117.02698, 32.57062], [-117.02715, 32.57064], [-117.02716, 32.57161]]]} | Open Access 1 | 47618 | Cesar Solis Park | 31542 | 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 | 15.465 | Cesar Solis Park | 2018 | Local Park 2 | 4 | |
7554 | 7554 | 7553 | {"type": "Polygon", "coordinates": [[[-117.0515, 32.56906], [-117.05149, 32.57089], [-117.0493, 32.57089], [-117.04932, 32.56905], [-117.0515, 32.56906]]]} | Open Access 1 | 47617 | Los Altos Neighborhood Park | 30075 | 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.286 | Los Altos Neighborhood Park | 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 | |
5252 | 5252 | 5251 | {"type": "Polygon", "coordinates": [[[-117.09086, 32.91299], [-117.09052, 32.91303], [-117.09046, 32.91266], [-117.0908, 32.91262], [-117.09086, 32.91299]]]} | Open Access 1 | 47490 | Forestview Lane Mini Park | 31209 | 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.328 | Forestview Lane MP | 0 | Local Park 2 | 4 | |
14490 | 14490 | 14489 | {"type": "Polygon", "coordinates": [[[-117.15766, 32.9055], [-117.15651, 32.90626], [-117.1561, 32.90582], [-117.15673, 32.90517], [-117.15693, 32.90501], [-117.15764, 32.9055], [-117.15766, 32.9055]]]} | Restricted Access 2 | 47149 | Salk Neighborhood Park | 31627 | 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 | 2.342 | Salk Neighborhood Park | 0 | Local Park 2 | 4 | |
4007 | 4007 | 4006 | {"type": "MultiPolygon", "coordinates": [[[[-117.14406, 32.70147], [-117.1438, 32.70178], [-117.14126, 32.70002], [-117.14133, 32.6999], [-117.14168, 32.70003], [-117.14184, 32.70014], [-117.14214, 32.70029], [-117.14239, 32.70037], [-117.14245, 32.70033], [-117.14406, 32.70147]]], [[[-117.14441, 32.70113], [-117.14421, 32.70131], [-117.14265, 32.70025], [-117.14169, 32.69956], [-117.14176, 32.69951], [-117.14179, 32.69934], [-117.14203, 32.69909], [-117.14229, 32.69886], [-117.1439, 32.7], [-117.14382, 32.70008], [-117.14379, 32.70022], [-117.14379, 32.70042], [-117.14375, 32.70045], [-117.14383, 32.70053], [-117.14392, 32.70058], [-117.14392, 32.70062], [-117.14396, 32.70074], [-117.14401, 32.70083], [-117.14441, 32.70113]]]]} | Open Access 1 | 46820 | Chicano Park | 17188 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.609 | Chicano Park | 0 | Local Park 2 | 4 | |
5896 | 5896 | 5895 | {"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]} | Restricted Access 2 | 46816 | Clay Elementary School Park | 31950 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.701 | Clay Elementary School Park | 0 | Local Park 2 | 4 | |
5961 | 5961 | 5960 | {"type": "Polygon", "coordinates": [[[-117.16308, 32.91366], [-117.16263, 32.91397], [-117.16087, 32.9139], [-117.16086, 32.91379], [-117.15982, 32.91379], [-117.15983, 32.91351], [-117.16086, 32.91351], [-117.16085, 32.91259], [-117.16033, 32.91259], [-117.16035, 32.9124], [-117.16045, 32.91223], [-117.16028, 32.9122], [-117.15996, 32.91208], [-117.15982, 32.91199], [-117.15966, 32.91192], [-117.1596, 32.91184], [-117.15959, 32.9117], [-117.15954, 32.91163], [-117.15948, 32.9116], [-117.15915, 32.91151], [-117.15895, 32.91143], [-117.15875, 32.91147], [-117.15857, 32.9116], [-117.15832, 32.91162], [-117.15828, 32.9116], [-117.15822, 32.91154], [-117.15815, 32.91152], [-117.15797, 32.91154], [-117.15776, 32.91145], [-117.15757, 32.91145], [-117.15753, 32.91142], [-117.15753, 32.91138], [-117.15768, 32.91125], [-117.15769, 32.91114], [-117.15773, 32.91103], [-117.15771, 32.91099], [-117.15762, 32.91094], [-117.1575, 32.91079], [-117.15743, 32.91075], [-117.16086, 32.91078], [-117.16086, 32.91194], [-117.16104, 32.91192], [-117.16157, 32.91208], [-117.16187, 32.91219], [-117.16228, 32.9126], [-117.16253, 32.9126], [-117.16256, 32.91301], [-117.16308, 32.91366]]]} | Open Access 1 | 46813 | McAuliffe Community Park | 30276 | 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 | 17.712 | McAuliffe Community Park | 0 | Local Park 2 | 4 | |
3848 | 3848 | 3847 | {"type": "Polygon", "coordinates": [[[-117.04738, 32.55364], [-117.04717, 32.55399], [-117.04686, 32.55386], [-117.04707, 32.55351], [-117.04738, 32.55364]]]} | Open Access 1 | 46812 | San Ysidro Mini Park | 32781 | 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.354 | San Ysidro MP | 0 | Local Park 2 | 4 | |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 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.773 | Neighborhood 8 Neighborhood 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]);