units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
533 rows where MNG_AGENCY = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 19
- Local Park 269
- Local Recreation Area 206
- Local Other or Unknown 14
- Local Conservation Area 9
- Local Historic or Cultural Area 1
- None 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
ACCESS_TYP 4
- Open Access 484
- No Public Access 18
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 513
MNG_AGENCY 1
- San Diego, City of · 513 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7847 | 7847 | 7846 | {"type": "Polygon", "coordinates": [[[-117.15681, 33.0032], [-117.15678, 33.00321], [-117.15678, 33.00317], [-117.15673, 33.00305], [-117.15662, 33.00291], [-117.15655, 33.00286], [-117.1565, 33.00276], [-117.15678, 33.00276], [-117.15681, 33.0032]]]} | Open Access 1 | 9594 | Black Mountain Open Space Park | 10257 | 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.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.148 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 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 | |
3180 | 3180 | 3179 | {"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 | 1903 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.166 | Clay Avenue MP | 0 | Local Park 2 | 4 | |
79 | 79 | 78 | {"type": "Polygon", "coordinates": [[[-117.23873, 32.83257], [-117.23825, 32.83268], [-117.2382, 32.83254], [-117.23868, 32.83244], [-117.23873, 32.83257]]]} | Open Access 1 | 236 | La Jolla Open Space | 20766 | 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.172 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | Unnamed site - San Diego, City of | 31719 | 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.196 | 0 | Local Other or Unknown 14 | 4 | ||
29 | 29 | 28 | {"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.83613], [-117.08206, 32.83602], [-117.08212, 32.83605]]]} | Open Access 1 | 46752 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.206 | Corte Playa San Juan Mini-Park | 0 | Local Park 2 | 4 | |
10177 | 10177 | 10176 | {"type": "Polygon", "coordinates": [[[-117.09722, 32.75933], [-117.09681, 32.75932], [-117.09682, 32.75912], [-117.09722, 32.75913], [-117.09722, 32.75933]]]} | Open Access 1 | 18714 | 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 | 0.207 | Kensington/College OS | 0 | Local Recreation Area 3 | 4 | |
10601 | 10601 | 10600 | {"type": "Polygon", "coordinates": [[[-117.11151, 32.76653], [-117.11122, 32.7666], [-117.11114, 32.76647], [-117.11104, 32.76634], [-117.11132, 32.76628], [-117.11139, 32.7664], [-117.11151, 32.76653]]]} | Open Access 1 | 18877 | 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 | 0.209 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
605 | 605 | 604 | {"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 | 2082 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.22 | J Street MP | 0 | Local Park 2 | 4 | |
505 | 505 | 504 | {"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 | 2045 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.23 | 30th Street MP | 0 | Local Park 2 | 4 | |
15431 | 15431 | 15430 | {"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 | 46698 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.231 | Ocean View Mini-Park | 0 | Local Park 2 | 4 | |
5845 | 5845 | 5844 | {"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.23455, 32.72259], [-117.23464, 32.72274], [-117.23485, 32.72297]]]} | Open Access 1 | 217 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.233 | Cabrillo Mini-Park North | 0 | Local Park 2 | 4 | |
14698 | 14698 | 14697 | {"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 | 46749 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.242 | West Maple Canyon 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]);