units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

528 rows where AGNCY_NAME = 4 sorted by ACRES

This data as json, copyable, CSV (advanced)

Suggested facets: MNG_AG_ID, GAP_STS

YR_EST 5 ✖

MNG_AG_LEV 3 ✖

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
4537 4537 4536 {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} No Public Access 3 19907 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.035   0 Local Other or Unknown 14 4
2826 2826 2825 {"type": "Polygon", "coordinates": [[[-117.12944, 32.98294], [-117.12938, 32.98304], [-117.12928, 32.9829], [-117.12938, 32.98285], [-117.12944, 32.98294]]]} Open Access 1 931 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.04 Black Mtn. OS Park 0 Local Recreation Area 3 4
16082 16082 16081 {"type": "Polygon", "coordinates": [[[-117.25989, 32.84535], [-117.25988, 32.84542], [-117.25976, 32.84547], [-117.25976, 32.84541], [-117.25979, 32.84531], [-117.25983, 32.84528], [-117.25986, 32.84529], [-117.25988, 32.84531], [-117.25989, 32.84535]]]} Open Access 1 7340 Ludington Heights Open Space Park East 21583 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.042 Ludington Heights OS Park East   None 1376  
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
16083 16083 16082 {"type": "Polygon", "coordinates": [[[-117.26515, 32.8438], [-117.26511, 32.84397], [-117.26505, 32.84395], [-117.26498, 32.84389], [-117.26497, 32.84379], [-117.26498, 32.84377], [-117.26501, 32.84375], [-117.26509, 32.84374], [-117.26513, 32.84377], [-117.26515, 32.8438]]]} Open Access 1 7341 Ludington Heights Open Space Park West 21584 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.075 Ludington Heights OS Park West   None 1377  
5805 5805 5804 {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} Open Access 1 73 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.082 Uptown OS 0 Local Recreation Area 3 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
4934 4934 4933 {"type": "Polygon", "coordinates": [[[-117.08994, 32.84113], [-117.08988, 32.84128], [-117.08972, 32.84134], [-117.08976, 32.84106], [-117.08994, 32.84113]]]} Open Access 1 241 Tierrasanta Open Space 10608 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.095 Tierrasanta OS 0 Local Recreation Area 3 4
10588 10588 10587 {"type": "Polygon", "coordinates": [[[-117.10949, 32.77704], [-117.10951, 32.77714], [-117.10945, 32.77755], [-117.10939, 32.77756], [-117.10944, 32.77714], [-117.10941, 32.77704], [-117.10949, 32.77704]]]} Open Access 1 18912 Mission Valley Slopes #2 Open Space 22317 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.095 Mission Valley Slopes #2 OS 0 Local Recreation Area 3 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
6492 6492 6491 {"type": "Polygon", "coordinates": [[[-117.17175, 32.73853], [-117.17141, 32.73854], [-117.17141, 32.7384], [-117.17175, 32.7384], [-117.17175, 32.73853]]]} Open Access 1 180 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.122 Uptown OS 0 Local Recreation Area 3 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);