superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
- Open Access 388
- No Public Access 14
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 413
MNG_AGENCY 1
- San Diego, City of · 413 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2858 | 2858 | 2857 | {"type": "Polygon", "coordinates": [[[-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], [-117.26407, 32.8495]]]} | Open Access 1 | Charlotte Park | 17149 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.16 | Charlotte Park | ||
11449 | 11449 | 11448 | {"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 | 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 | 0.16 | Laurel Street Mini-Park | ||
3021 | 3021 | 3020 | {"type": "Polygon", "coordinates": [[[-117.1262, 32.70317], [-117.12603, 32.70317], [-117.12603, 32.70279], [-117.12619, 32.70279], [-117.1262, 32.70317]]]} | Open Access 1 | Clay Avenue Mini Park | 17395 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.166 | Clay Avenue MP | ||
12967 | 12967 | 12966 | {"type": "Polygon", "coordinates": [[[-117.08212, 32.83605], [-117.08201, 32.83608], [-117.08196, 32.83613], [-117.08194, 32.83618], [-117.08196, 32.83628], [-117.08204, 32.83636], [-117.08165, 32.83637], [-117.08171, 32.83615], [-117.08175, 32.8361], [-117.08182, 32.83612], [-117.08206, 32.83602], [-117.08212, 32.83605]]]} | Open Access 1 | Corte Playa San Juan Mini-Park | 30203 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.206 | Corte Playa San Juan Mini-Park | ||
4349 | 4349 | 4348 | {"type": "Polygon", "coordinates": [[[-117.12293, 32.70992], [-117.12268, 32.70992], [-117.12268, 32.70958], [-117.12293, 32.70958], [-117.12293, 32.70992]]]} | Open Access 1 | J Street Mini Park | 20289 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.219 | J Street MP | ||
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 30th Street Mini Park | 15192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.23 | 30th Street MP | ||
12839 | 12839 | 12838 | {"type": "Polygon", "coordinates": [[[-117.1025, 32.70094], [-117.10248, 32.70095], [-117.10248, 32.70114], [-117.10232, 32.70107], [-117.10231, 32.70059], [-117.10249, 32.70059], [-117.1025, 32.70094]]]} | Open Access 1 | Ocean View Mini-Park | 30061 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.232 | Ocean View Mini-Park | ||
12880 | 12880 | 12879 | {"type": "Polygon", "coordinates": [[[-117.23485, 32.72297], [-117.23478, 32.72303], [-117.23437, 32.72274], [-117.2344, 32.72271], [-117.23447, 32.72246], [-117.2345, 32.72246], [-117.23456, 32.72259], [-117.23464, 32.72274], [-117.23485, 32.72297]]]} | Open Access 1 | Cabrillo Mini-Park North | 30114 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.233 | Cabrillo Mini-Park North | ||
12965 | 12965 | 12964 | {"type": "Polygon", "coordinates": [[[-117.16575, 32.73251], [-117.16563, 32.73264], [-117.16531, 32.73292], [-117.16531, 32.73252], [-117.16575, 32.73251]]]} | Open Access 1 | West Maple Canyon Mini-Park | 30201 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.242 | West Maple Canyon Mini-Park | ||
4299 | 4299 | 4298 | {"type": "Polygon", "coordinates": [[[-117.11842, 32.77457], [-117.11817, 32.77496], [-117.11806, 32.77488], [-117.11838, 32.77423], [-117.11842, 32.77457]]]} | Open Access 1 | Indian Hill Open Space Park | 20202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.245 | Indian Hill OS Park | ||
12836 | 12836 | 12835 | {"type": "Polygon", "coordinates": [[[-117.19344, 32.75165], [-117.19315, 32.75181], [-117.19311, 32.75179], [-117.19296, 32.75158], [-117.1933, 32.75139], [-117.19344, 32.75165]]]} | Open Access 1 | El Campo Santo Neighborhood Park | 30058 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.275 | El Campo Santo Neighborhood Park | ||
12972 | 12972 | 12971 | {"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 | Pearlman Mini-Park | 30208 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.3 | Pearlman Mini-Park | ||
13024 | 13024 | 13023 | {"type": "Polygon", "coordinates": [[[-117.11064, 32.73711], [-117.11063, 32.73738], [-117.11017, 32.73738], [-117.11017, 32.73711], [-117.11064, 32.73711]]]} | Open Access 1 | Virgie Hazel McCain and William Henry Carter Mini Park | 30270 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.323 | Virgie Hazel McCain and William Henry Carter MP | ||
13722 | 13722 | 13721 | {"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 | 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 | 0.328 | Forestview Lane MP | ||
12964 | 12964 | 12963 | {"type": "Polygon", "coordinates": [[[-117.17153, 32.7519], [-117.1707, 32.75191], [-117.17051, 32.75205], [-117.17051, 32.75178], [-117.17134, 32.75177], [-117.17134, 32.75182], [-117.1714, 32.75187], [-117.17153, 32.7519]]]} | Open Access 1 | West Lewis Mini-Park | 30200 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.331 | West Lewis Mini-Park | ||
13712 | 13712 | 13711 | {"type": "Polygon", "coordinates": [[[-117.27323, 32.85056], [-117.27322, 32.85066], [-117.27317, 32.85074], [-117.27304, 32.85083], [-117.27295, 32.85079], [-117.27295, 32.85077], [-117.27298, 32.85075], [-117.273, 32.85069], [-117.27288, 32.8505], [-117.27277, 32.85041], [-117.27279, 32.85034], [-117.27299, 32.85025], [-117.27317, 32.85046], [-117.27323, 32.85056]]]} | Open Access 1 | La Jolla Cove | http://www.lajollabythesea.com/la-jolla-cove | 31200 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.352 | La Jolla Cove | |
905 | 905 | 904 | {"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 | 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 | 0.353 | San Ysidro MP | ||
12845 | 12845 | 12844 | {"type": "Polygon", "coordinates": [[[-117.10971, 32.69341], [-117.1097, 32.69341], [-117.10898, 32.69341], [-117.1097, 32.69303], [-117.10971, 32.69341]]]} | Open Access 1 | Z Street Mini-Park | 30067 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.357 | Z Street Mini-Park | ||
12939 | 12939 | 12938 | {"type": "Polygon", "coordinates": [[[-117.1088, 32.74494], [-117.10861, 32.74528], [-117.1085, 32.74535], [-117.10835, 32.74537], [-117.10835, 32.74493], [-117.1088, 32.74494]]]} | Open Access 1 | Central Avenue Mini-Park | 30175 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.359 | Central Avenue Mini-Park | ||
10839 | 10839 | 10838 | {"type": "Polygon", "coordinates": [[[-117.27442, 32.82285], [-117.27439, 32.82288], [-117.2744, 32.82331], [-117.27434, 32.82333], [-117.27422, 32.82306], [-117.27402, 32.8227], [-117.27427, 32.82259], [-117.27442, 32.82285]]]} | Open Access 1 | Via Del Norte Mini Park | 27065 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.364 | Via Del Norte MP |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);