superunits_with_maps

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

240 rows where MNG_AGENCY = 21

View and edit SQL

Suggested facets: YR_EST

ACCESS_TYP

MNG_AG_TYP

MNG_AGENCY

  • San Francisco, City and County of · 240
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
52 51 {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41588, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} Open Access 1 In Chan Kaajal Park http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ 31768 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1.398 In Chan Kaajal Park 2017
100 99 {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47256, 37.75525], [-122.47257, 37.75529], [-122.47226, 37.75545], [-122.47219, 37.75536], [-122.47216, 37.75526], [-122.47213, 37.75504], [-122.47212, 37.75467], [-122.47216, 37.75465], [-122.4722, 37.75466], [-122.47236, 37.75482], [-122.47273, 37.75508]]]} Open Access 1 Grand View Pk. Open Space   19427 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.642 Grand View Pk. OS  
110 109 {"type": "Polygon", "coordinates": [[[-122.47017, 37.74701], [-122.46995, 37.74702], [-122.46993, 37.74705], [-122.46994, 37.74711], [-122.46989, 37.74716], [-122.46955, 37.74717], [-122.46952, 37.74707], [-122.46946, 37.74704], [-122.46939, 37.74704], [-122.46935, 37.74706], [-122.46933, 37.74712], [-122.46935, 37.74718], [-122.46892, 37.7472], [-122.46888, 37.74678], [-122.46845, 37.74672], [-122.46709, 37.74679], [-122.46707, 37.74656], [-122.46717, 37.74654], [-122.46717, 37.74647], [-122.46742, 37.74645], [-122.46742, 37.74641], [-122.46739, 37.74639], [-122.46739, 37.74612], [-122.46761, 37.74618], [-122.46795, 37.74616], [-122.46802, 37.74609], [-122.46892, 37.74615], [-122.46962, 37.74611], [-122.46966, 37.74667], [-122.47015, 37.74665], [-122.47017, 37.74701]]]} Open Access 1 Hawk Hill Open Space   19745 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 4.845 Hawk Hill OS  
465 464 {"type": "Polygon", "coordinates": [[[-122.39224, 37.7649], [-122.39224, 37.7649], [-122.39054, 37.76501], [-122.39057, 37.76489], [-122.39068, 37.7646], [-122.3907, 37.76448], [-122.39068, 37.76432], [-122.39218, 37.76423], [-122.39224, 37.7649]]]} Open Access 1 Mariposa Park https://missionbayparks.com/mariposa-park/ 33504 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 2.58 Mariposa Park  
473 472 {"type": "Polygon", "coordinates": [[[-122.39332, 37.77186], [-122.39223, 37.77272], [-122.39223, 37.77272], [-122.39215, 37.77193], [-122.39332, 37.77186]]]} Open Access 1 Kids' Park https://missionbayparks.com/childrens-park/ 33505 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1.121 Kids' Park  
482 481 {"type": "Polygon", "coordinates": [[[-122.42215, 37.74582], [-122.42193, 37.74583], [-122.42211, 37.74534], [-122.42211, 37.74534], [-122.42215, 37.74582]]]} Open Access 1 San Jose Guerrero Park https://groundplaysf.org/projects/san-jose-guerrero-park/ 33506 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.126 San Jose Guerrero Park  
700 699 {"type": "Polygon", "coordinates": [[[-122.41343, 37.75828], [-122.41259, 37.75833], [-122.41255, 37.75792], [-122.41297, 37.75789], [-122.413, 37.7581], [-122.41341, 37.75807], [-122.41343, 37.75828]]]} Open Access 1 Mission Recreation Center http://sfrecpark.org/destination/mission-rec-center/ 30902 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.633 Mission Rec. Ctr.  
722 721 {"type": "Polygon", "coordinates": [[[-122.39604, 37.71764], [-122.39553, 37.71819], [-122.39529, 37.71804], [-122.39582, 37.71752], [-122.39604, 37.71764]]]} Open Access 1 Le Conte Mini Park   21123 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.474 Le Conte MP  
751 750 {"type": "MultiPolygon", "coordinates": [[[[-122.44577, 37.77293], [-122.44108, 37.77352], [-122.44092, 37.77277], [-122.44562, 37.77218], [-122.44577, 37.77293]]], [[[-122.51084, 37.77123], [-122.51081, 37.77125], [-122.46524, 37.77333], [-122.46492, 37.77336], [-122.45479, 37.77465], [-122.45476, 37.77464], [-122.45474, 37.77462], [-122.45417, 37.77186], [-122.446, 37.7729], [-122.44585, 37.77215], [-122.45401, 37.77111], [-122.454, 37.7709], [-122.45398, 37.77089], [-122.45365, 37.76926], [-122.45362, 37.76924], [-122.45359, 37.76908], [-122.45361, 37.76904], [-122.45324, 37.7672], [-122.45358, 37.76716], [-122.45359, 37.76714], [-122.45351, 37.76676], [-122.45315, 37.76677], [-122.45308, 37.76646], [-122.45319, 37.76644], [-122.45324, 37.76659], [-122.454, 37.76656], [-122.45401, 37.76654], [-122.45397, 37.76634], [-122.45449, 37.76628], [-122.45455, 37.76653], [-122.45477, 37.76653], [-122.45473, 37.76625], [-122.45677, 37.76598], [-122.45701, 37.76598], [-122.45721, 37.76599], [-122.45745, 37.76603], [-122.45764, 37.76608], [-122.45768, 37.76644], [-122.45788, 37.76644], [-122.45859, 37.76637], [-122.46049, 37.76628], [-122.51017, 37.76409], [-122.51021, 37.7641], [-122.51024, 37.76413], [-122.51025, 37.7645], [-122.51017, 37.76568], [-122.51018, 37.76647], [-122.51024, 37.76719], [-122.51029, 37.76771], [-122.51033, 37.76774], [-122.51042, 37.76819], [-122.51042, 37.76835], [-122.51047, 37.76859], [-122.51052, 37.76864], [-122.51063, 37.76917], [-122.51078, 37.77029], [-122.51076, 37.77035], [-122.5107, 37.77037], [-122.51069, 37.77048], [-122.51077, 37.77052], [-122.5108, 37.77056], [-122.51083, 37.77082], [-122.5108, 37.77092], [-122.51084, 37.77123]], [[-122.45534, 37.76756], [-122.45501, 37.76749], [-122.45487, 37.76756], [-122.45488, 37.76807], [-122.45516, 37.76805], [-122.45565, 37.76794], [-122.45563, 37.76788], [-122.45534, 37.76756]], [[-122.4691, 37.7719], [-122.46926, 37.772], [-122.46978, 37.77162], [-122.46885, 37.77083], [-122.46791, 37.77153], [-122.4686, 37.7722], [-122.4691, 37.7719]]]]} Open Access 1 Golden Gate Park http://sfrecpark.org/parks-open-spaces/golden-gate-park-guide/ 10900 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1022.23 Golden Gate Park 2000
803 802 {"type": "Polygon", "coordinates": [[[-122.43668, 37.71365], [-122.43644, 37.714], [-122.43632, 37.71395], [-122.43656, 37.7136], [-122.43668, 37.71365]]]} Open Access 1 Naples Green https://groundplaysf.org/projects/naples-green/ 33554 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.132 Naples Green  
984 983 {"type": "Polygon", "coordinates": [[[-122.42725, 37.71489], [-122.42703, 37.7156], [-122.42711, 37.71564], [-122.42656, 37.71707], [-122.42665, 37.71713], [-122.42622, 37.71825], [-122.42583, 37.71806], [-122.42574, 37.71799], [-122.42564, 37.71789], [-122.42557, 37.71779], [-122.42506, 37.71688], [-122.42291, 37.71824], [-122.42325, 37.71871], [-122.42334, 37.71887], [-122.42337, 37.719], [-122.42338, 37.71914], [-122.42336, 37.71927], [-122.42332, 37.71943], [-122.42331, 37.71956], [-122.42337, 37.71972], [-122.42347, 37.71983], [-122.42359, 37.71991], [-122.42375, 37.71997], [-122.42482, 37.72016], [-122.42532, 37.72032], [-122.42535, 37.72029], [-122.42553, 37.72036], [-122.42437, 37.7219], [-122.42519, 37.72232], [-122.4248, 37.72283], [-122.42481, 37.72285], [-122.42485, 37.72287], [-122.42436, 37.72352], [-122.42433, 37.72351], [-122.42415, 37.72351], [-122.41994, 37.72461], [-122.41944, 37.72342], [-122.41846, 37.72367], [-122.41796, 37.72247], [-122.41697, 37.72272], [-122.41663, 37.72195], [-122.41547, 37.72225], [-122.41579, 37.72303], [-122.41304, 37.72375], [-122.41097, 37.71877], [-122.40899, 37.71928], [-122.40884, 37.71891], [-122.40875, 37.71888], [-122.40898, 37.71837], [-122.4083, 37.71818], [-122.40883, 37.71694], [-122.40836, 37.71681], [-122.40832, 37.71687], [-122.40799, 37.71678], [-122.40813, 37.71645], [-122.40845, 37.71654], [-122.40854, 37.71635], [-122.40934, 37.71657], [-122.40939, 37.71651], [-122.40971, 37.71659], [-122.4097, 37.71666], [-122.40984, 37.7167], [-122.40991, 37.71657], [-122.41023, 37.71666], [-122.41032, 37.71647], [-122.41048, 37.71651], [-122.41055, 37.71635], [-122.41219, 37.7168], [-122.41246, 37.71668], [-122.41317, 37.71646], [-122.41318, 37.71631], [-122.41366, 37.7163], [-122.41404, 37.71619], [-122.41405, 37.71596], [-122.41434, 37.71529], [-122.41547, 37.71559], [-122.41547, 37.71438], [-122.41544, 37.71436], [-122.41566, 37.71385], [-122.41531, 37.71374], [-122.41584, 37.71252], [-122.42175, 37.7142], [-122.42201, 37.71369], [-122.42368, 37.71416], [-122.42426, 37.71274], [-122.42264, 37.71227], [-122.42319, 37.71113], [-122.42257, 37.71091], [-122.42264, 37.71083], [-122.42297, 37.71091], [-122.42309, 37.71079], [-122.42325, 37.71071], [-122.42397, 37.71068], [-122.42396, 37.71035], [-122.42445, 37.71054], [-122.42441, 37.71063], [-122.42455, 37.71073], [-122.42527, 37.7111], [-122.42564, 37.71124], [-122.42604, 37.71137], [-122.42659, 37.71159], [-122.42531, 37.71438], [-122.42725, 37.71489]], [[-122.41279, 37.71696], [-122.4128, 37.71699], [-122.41319, 37.71698], [-122.41318, 37.71659], [-122.41285, 37.71669], [-122.41257, 37.71675], [-122.41236, 37.71683], [-122.41279, 37.71696]]]} Open Access 1 McLaren Park http://sfrecpark.org/destination/john-mclaren-park/ 10942 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 333.496 McLaren Park  
1099 1098 {"type": "Polygon", "coordinates": [[[-122.44734, 37.70991], [-122.44625, 37.71028], [-122.44596, 37.70975], [-122.44705, 37.70937], [-122.44734, 37.70991]]]} Open Access 1 Alice Chalmers Playground   15359 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1.678 Alice Chalmers Playground  
1120 1119 {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} Open Access 1 Alamo Square   15322 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 12.697 Alamo Square 2000
1139 1138 {"type": "Polygon", "coordinates": [[[-122.41836, 37.75902], [-122.4181, 37.75904], [-122.41808, 37.75878], [-122.41833, 37.75876], [-122.41836, 37.75902]]]} Open Access 1 Alioto Mini Park   15366 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.161 Alioto MP  
1262 1261 {"type": "Polygon", "coordinates": [[[-122.42798, 37.79764], [-122.42731, 37.79773], [-122.42722, 37.79728], [-122.42789, 37.79719], [-122.42798, 37.79764]]]} Open Access 1 Allyne Park   15385 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.751 Allyne Park  
1367 1366 {"type": "Polygon", "coordinates": [[[-122.40867, 37.7532], [-122.4085, 37.75321], [-122.40848, 37.75292], [-122.40865, 37.75291], [-122.40867, 37.7532]]]} Open Access 1 24th & York Mini Park   15185 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.119 24th & York MP  
1376 1375 {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73972], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} Open Access 1 298 Berkeley Way Open Space   15190 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.83 298 Berkeley Way OS  
1387 1386 {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78187], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.46819, 37.78197], [-122.4682, 37.78188]]]} Open Access 1 10th Ave & Clement Mini Park   15169 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.689 10th Ave & Clement MP  
1389 1388 {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47242, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47226, 37.75966], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.47241, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} Open Access 1 15th Avenue Steps   15174 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 0.525 15th Avenue Steps  
1409 1408 {"type": "MultiPolygon", "coordinates": [[[[-122.38471, 37.73094], [-122.38443, 37.73124], [-122.38438, 37.73135], [-122.38425, 37.73143], [-122.38424, 37.73146], [-122.38417, 37.73151], [-122.38412, 37.73152], [-122.38406, 37.73146], [-122.38407, 37.73144], [-122.38396, 37.73132], [-122.38366, 37.73149], [-122.38384, 37.7317], [-122.38371, 37.73178], [-122.38341, 37.73147], [-122.38319, 37.73141], [-122.38328, 37.73126], [-122.38329, 37.73111], [-122.38319, 37.73087], [-122.38332, 37.73074], [-122.38341, 37.73076], [-122.38352, 37.73068], [-122.38354, 37.73064], [-122.38352, 37.7306], [-122.38345, 37.73054], [-122.38342, 37.73053], [-122.38361, 37.73031], [-122.38471, 37.73094]]], [[[-122.38538, 37.73098], [-122.38518, 37.7312], [-122.38511, 37.73116], [-122.38531, 37.73094], [-122.38538, 37.73098]]]]} Open Access 1 Adam Rogers Park   15256 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 2.813 Adam Rogers Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 58.805ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette