units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
533 rows where MNG_AGENCY = 4
This data as json, copyable, CSV (advanced)
DES_TP 19
- Local Park 216
- Local Recreation Area 191
- Local Other or Unknown 14
- Local Conservation Area 7
- Local Historic or Cultural Area 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency 443
MNG_AGENCY 1
- San Diego, City of · 443 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2837 | 2837 | 2836 | {"type": "Polygon", "coordinates": [[[-117.2474, 32.75459], [-117.24739, 32.75484], [-117.24661, 32.75496], [-117.24628, 32.75506], [-117.23979, 32.75584], [-117.2352, 32.75631], [-117.23602, 32.75535], [-117.23671, 32.75479], [-117.23711, 32.75456], [-117.24002, 32.75307], [-117.24079, 32.75264], [-117.24111, 32.75238], [-117.24153, 32.752], [-117.24208, 32.75143], [-117.24236, 32.75155], [-117.24326, 32.75207], [-117.24425, 32.75223], [-117.2449, 32.75257], [-117.24493, 32.7527], [-117.24492, 32.75295], [-117.24495, 32.75313], [-117.24529, 32.75309], [-117.24534, 32.75326], [-117.24542, 32.7534], [-117.2455, 32.75351], [-117.24543, 32.75352], [-117.24526, 32.75374], [-117.24531, 32.75376], [-117.24579, 32.75419], [-117.24596, 32.75431], [-117.24592, 32.75436], [-117.24592, 32.75438], [-117.24619, 32.75434], [-117.2462, 32.75437], [-117.24625, 32.75436], [-117.24628, 32.75454], [-117.24654, 32.75461], [-117.24668, 32.75462], [-117.2469, 32.75459], [-117.24721, 32.75461], [-117.2474, 32.75459]]]} | Open Access 1 | 46755 | Ocean Beach Athletic Area - Robb Field | 30206 | 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 | 68.208 | Ocean Beach Athletic Area - Robb Field | 0 | Local Recreation Area 3 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 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.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
2840 | 2840 | 2839 | {"type": "Polygon", "coordinates": [[[-117.19326, 32.96674], [-117.19257, 32.96698], [-117.19225, 32.96707], [-117.1915, 32.96711], [-117.19085, 32.96726], [-117.18994, 32.96739], [-117.18968, 32.96693], [-117.19283, 32.96625], [-117.19304, 32.96653], [-117.19313, 32.9666], [-117.19326, 32.96674]]]} | Open Access 1 | 46742 | Solana Ranch Neighborhood Park | 30192 | 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 | 4.961 | Solana Ranch Neighborhood Park | 0 | Local Park 2 | 4 | |
2841 | 2841 | 2840 | {"type": "Polygon", "coordinates": [[[-117.25994, 32.80298], [-117.25981, 32.80306], [-117.25952, 32.80239], [-117.25945, 32.80228], [-117.25935, 32.80219], [-117.25919, 32.80211], [-117.2593, 32.80184], [-117.25941, 32.80193], [-117.25954, 32.80211], [-117.25969, 32.80243], [-117.2598, 32.80281], [-117.25994, 32.80298]]]} | Open Access 1 | 46743 | Palisades South Neighborhood Park | 30193 | 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.502 | Palisades South Neighborhood Park | 0 | Local Park 2 | 4 | |
2842 | 2842 | 2841 | {"type": "Polygon", "coordinates": [[[-117.10063, 32.90516], [-117.10062, 32.90527], [-117.10055, 32.90555], [-117.10002, 32.90543], [-117.09972, 32.90538], [-117.09858, 32.90527], [-117.09844, 32.90524], [-117.09823, 32.90515], [-117.09819, 32.90512], [-117.09818, 32.90508], [-117.09819, 32.90505], [-117.0983, 32.90494], [-117.09838, 32.905], [-117.09885, 32.9048], [-117.09917, 32.90479], [-117.09953, 32.90481], [-117.0999, 32.90489], [-117.10032, 32.905], [-117.10056, 32.90509], [-117.10063, 32.90516]]]} | Open Access 1 | 46756 | Hoyt Neighborhood Park | 30207 | 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.842 | Hoyt Neighborhood Park | 0 | Local Park 2 | 4 | |
2843 | 2843 | 2842 | {"type": "Polygon", "coordinates": [[[-117.20575, 32.9544], [-117.2055, 32.95463], [-117.20523, 32.95435], [-117.20525, 32.95431], [-117.20544, 32.95418], [-117.20575, 32.9544]]]} | Open Access 1 | 46757 | Pearlman Mini-Park | 30208 | 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.3 | Pearlman Mini-Park | 0 | Local Park 2 | 4 | |
2845 | 2845 | 2844 | {"type": "Polygon", "coordinates": [[[-117.14968, 32.92475], [-117.14966, 32.92527], [-117.14827, 32.92531], [-117.14824, 32.92448], [-117.14822, 32.92432], [-117.14812, 32.92408], [-117.14815, 32.92402], [-117.14838, 32.92394], [-117.1486, 32.92391], [-117.14951, 32.9239], [-117.14954, 32.9245], [-117.14957, 32.92454], [-117.14953, 32.92457], [-117.14951, 32.92464], [-117.14954, 32.92472], [-117.14959, 32.92474], [-117.14968, 32.92475]]]} | Open Access 1 | 18765 | Sandburg Neighborhood Park | 30128 | 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 | 4.777 | Sandburg Neighborhood Park | 0 | Local Park 2 | 4 | |
2863 | 2863 | 2862 | {"type": "Polygon", "coordinates": [[[-117.07559, 32.72323], [-117.07539, 32.7234], [-117.07481, 32.72421], [-117.07206, 32.72624], [-117.0702, 32.72693], [-117.0696, 32.72708], [-117.06827, 32.72704], [-117.06825, 32.72702], [-117.06823, 32.72697], [-117.06824, 32.72647], [-117.07044, 32.72525], [-117.07229, 32.72419], [-117.07324, 32.72391], [-117.07336, 32.72229], [-117.07486, 32.72154], [-117.07488, 32.72155], [-117.07528, 32.72141], [-117.07545, 32.72138], [-117.07551, 32.72139], [-117.07554, 32.72144], [-117.07522, 32.72244], [-117.07522, 32.72267], [-117.07527, 32.72281], [-117.07534, 32.72297], [-117.07559, 32.72323]]]} | Open Access 1 | 1921 | Chollas Radio System Open Space | 17220 | 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 | 33.615 | Chollas Radio System OS | 0 | Local Recreation Area 3 | 4 | |
2866 | 2866 | 2865 | {"type": "MultiPolygon", "coordinates": [[[[-117.07543, 32.54723], [-117.07334, 32.54725], [-117.07265, 32.54719], [-117.07205, 32.54707], [-117.07148, 32.54689], [-117.0711, 32.54673], [-117.07109, 32.54619], [-117.0715, 32.54637], [-117.07191, 32.54654], [-117.07243, 32.54667], [-117.07273, 32.54673], [-117.07335, 32.54678], [-117.07543, 32.54677], [-117.07543, 32.54723]]], [[[-117.07531, 32.56113], [-117.07484, 32.56105], [-117.07453, 32.56098], [-117.07423, 32.56089], [-117.07377, 32.56072], [-117.07348, 32.56061], [-117.0732, 32.56047], [-117.07246, 32.56004], [-117.07531, 32.56004], [-117.07531, 32.56113]]], [[[-117.08397, 32.55455], [-117.08325, 32.55455], [-117.08325, 32.55408], [-117.08397, 32.55408], [-117.08398, 32.55438], [-117.08397, 32.55455]]], [[[-117.08438, 32.55435], [-117.08437, 32.55447], [-117.08419, 32.55448], [-117.08419, 32.55436], [-117.08438, 32.55435]]], [[[-117.08848, 32.54379], [-117.08838, 32.54365], [-117.08828, 32.54358], [-117.08847, 32.54358], [-117.08848, 32.54379]]]]} | Open Access 1 | 997 | Tijuana River Valley Regional Park | 26363 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 11.187 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
2874 | 2874 | 2873 | {"type": "Polygon", "coordinates": [[[-117.14485, 32.76313], [-117.14397, 32.76313], [-117.14396, 32.76342], [-117.14397, 32.76345], [-117.14372, 32.76346], [-117.14373, 32.76523], [-117.14395, 32.76524], [-117.14396, 32.76581], [-117.14304, 32.76603], [-117.14301, 32.7631], [-117.1426, 32.76309], [-117.14264, 32.76296], [-117.1427, 32.76295], [-117.14269, 32.76278], [-117.14298, 32.76265], [-117.14321, 32.76259], [-117.14485, 32.76258], [-117.14485, 32.76313]]]} | Open Access 1 | 18879 | Old Trolley Barn Neighborhood Park | 30171 | 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 | 8.531 | Old Trolley Barn Neighborhood Park | 0 | Local Park 2 | 4 | |
2881 | 2881 | 2880 | {"type": "Polygon", "coordinates": [[[-117.06406, 32.78016], [-117.06333, 32.78013], [-117.06188, 32.77973], [-117.06192, 32.77935], [-117.06341, 32.77979], [-117.06386, 32.77995], [-117.06406, 32.78016]]]} | Open Access 1 | 18907 | Del Cerro Open Space | 18024 | 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 | 1.799 | Del Cerro OS | 0 | Local Recreation Area 3 | 4 | |
2889 | 2889 | 2888 | {"type": "Polygon", "coordinates": [[[-117.16878, 32.77562], [-117.16839, 32.77574], [-117.16786, 32.77554], [-117.16726, 32.77553], [-117.16681, 32.77571], [-117.16642, 32.77612], [-117.16533, 32.7761], [-117.16536, 32.77461], [-117.1675, 32.7746], [-117.1675, 32.77392], [-117.16783, 32.77404], [-117.16823, 32.77435], [-117.1684, 32.77454], [-117.16851, 32.77471], [-117.16857, 32.77484], [-117.16862, 32.775], [-117.16878, 32.77562]]]} | Open Access 1 | 18922 | Mission Heights Neighborhood Park | 30170 | 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 | 11.236 | Mission Heights Neighborhood Park | 0 | Local Park 2 | 4 | |
2898 | 2898 | 2897 | {"type": "MultiPolygon", "coordinates": [[[[-117.128, 32.77112], [-117.1267, 32.77192], [-117.12494, 32.77251], [-117.12305, 32.77069], [-117.12307, 32.76955], [-117.12337, 32.76924], [-117.12376, 32.76949], [-117.12392, 32.7695], [-117.12395, 32.76958], [-117.12388, 32.76991], [-117.12414, 32.76994], [-117.12334, 32.77072], [-117.12335, 32.77073], [-117.12562, 32.77051], [-117.12557, 32.77058], [-117.12567, 32.77109], [-117.12522, 32.77132], [-117.12524, 32.77156], [-117.12649, 32.77148], [-117.12616, 32.77045], [-117.12765, 32.7703], [-117.128, 32.77112]]], [[[-117.12954, 32.77121], [-117.12905, 32.77141], [-117.12829, 32.77179], [-117.12802, 32.77117], [-117.12879, 32.77065], [-117.12877, 32.77077], [-117.12954, 32.77121]]]]} | Open Access 1 | 18937 | Mission Valley Hillsides Open Space | 22316 | 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 | 18.353 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
2904 | 2904 | 2903 | {"type": "Polygon", "coordinates": [[[-117.09734, 32.77391], [-117.09657, 32.77426], [-117.0963, 32.77399], [-117.09703, 32.77345], [-117.09734, 32.77391]]]} | Open Access 1 | 18959 | Kensington/College Open Space | 20616 | 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 | 1.04 | Kensington/College OS | 0 | Local Recreation Area 3 | 4 | |
2935 | 2935 | 2934 | {"type": "Polygon", "coordinates": [[[-117.18255, 32.94128], [-117.18039, 32.94131], [-117.18039, 32.9413], [-117.18045, 32.94128], [-117.18051, 32.94125], [-117.18058, 32.94113], [-117.18082, 32.94096], [-117.18108, 32.94066], [-117.18125, 32.94055], [-117.1815, 32.94046], [-117.18229, 32.94033], [-117.1825, 32.94037], [-117.18255, 32.94128]]]} | Open Access 1 | 19894 | Del Mar Mesa Neighborhood Park | 30122 | 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.706 | Del Mar Mesa Neighborhood 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 | |
2937 | 2937 | 2936 | {"type": "Polygon", "coordinates": [[[-117.05063, 32.54496], [-117.05045, 32.5451], [-117.05031, 32.54524], [-117.05019, 32.54542], [-117.05009, 32.54563], [-117.05005, 32.54566], [-117.05002, 32.54566], [-117.04976, 32.54556], [-117.04949, 32.54548], [-117.04904, 32.5454], [-117.04904, 32.54465], [-117.05033, 32.54465], [-117.05063, 32.54496]]]} | Open Access 1 | 19935 | Coral Gate Neighborhood Park | 30106 | 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.018 | Coral Gate Neighborhood Park | 0 | Local Park 2 | 4 | |
2938 | 2938 | 2937 | {"type": "Polygon", "coordinates": [[[-117.15707, 32.96385], [-117.15706, 32.96529], [-117.15668, 32.96524], [-117.15655, 32.96525], [-117.15644, 32.96529], [-117.15637, 32.96534], [-117.1562, 32.96553], [-117.15605, 32.96562], [-117.15602, 32.96567], [-117.15594, 32.96564], [-117.15568, 32.9656], [-117.1557, 32.96396], [-117.15633, 32.9639], [-117.15707, 32.96385]]]} | Open Access 1 | 19937 | Torrey Meadows Neighborhood Park | 30147 | 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 | 5.35 | Torrey Meadows Neighborhood Park | 0 | Local Park 2 | 4 | |
2947 | 2947 | 2946 | {"type": "Polygon", "coordinates": [[[-117.09158, 32.69871], [-117.09156, 32.70037], [-117.09058, 32.70036], [-117.0906, 32.69872], [-117.09158, 32.69871]]]} | Open Access 1 | 1907 | John F. Kennedy Neighborhood Park | 30062 | 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 | 4.163 | John F. Kennedy Neighborhood Park | 0 | Local Park 2 | 4 | |
3037 | 3037 | 3036 | {"type": "Polygon", "coordinates": [[[-117.15797, 32.72307], [-117.15789, 32.72312], [-117.15779, 32.72316], [-117.1574, 32.72322], [-117.15657, 32.72322], [-117.1564, 32.72318], [-117.15638, 32.72315], [-117.15639, 32.7231], [-117.15647, 32.72301], [-117.15659, 32.72301], [-117.15666, 32.72303], [-117.15676, 32.72309], [-117.15682, 32.72311], [-117.15727, 32.7231], [-117.15731, 32.72309], [-117.15733, 32.72306], [-117.15746, 32.72301], [-117.15753, 32.72293], [-117.15761, 32.72301], [-117.15771, 32.72306], [-117.15797, 32.72307]]]} | Open Access 1 | 46759 | Tweet Street Mini-Park | 30210 | 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://segd.org/tweet-street-park | San Diego 4 | 0.556 | Tweet 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]);