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

79 rows where MNG_AGENCY = 29 sorted by SUID_NMA

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Santa Rosa, City of · 59
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
4229 4228 {"type": "Polygon", "coordinates": [[[-122.71034, 38.49485], [-122.71017, 38.49538], [-122.70934, 38.49527], [-122.70927, 38.49498], [-122.70966, 38.49491], [-122.71034, 38.49485]]]} Open Access 1 Fir Ridge Park   18907 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 0.974 Fir Ridge Park  
4246 4245 {"type": "Polygon", "coordinates": [[[-122.67816, 38.4529], [-122.67762, 38.45386], [-122.67755, 38.45412], [-122.67671, 38.4539], [-122.67688, 38.45341], [-122.67693, 38.45318], [-122.6772, 38.45246], [-122.67816, 38.4529]]]} Open Access 1 Flat Rock Park   18940 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 3.264 Flat Rock Park  
4341 4340 {"type": "Polygon", "coordinates": [[[-122.71874, 38.48454], [-122.71869, 38.48464], [-122.71849, 38.48473], [-122.71825, 38.48472], [-122.71701, 38.48418], [-122.71617, 38.48412], [-122.71608, 38.48403], [-122.71597, 38.48385], [-122.71598, 38.48356], [-122.71586, 38.48337], [-122.71585, 38.48324], [-122.71575, 38.48311], [-122.71563, 38.48271], [-122.71578, 38.48242], [-122.71645, 38.48208], [-122.71813, 38.48189], [-122.71837, 38.48227], [-122.71839, 38.48241], [-122.71821, 38.48312], [-122.7183, 38.48367], [-122.71853, 38.48395], [-122.71869, 38.48423], [-122.71869, 38.4844], [-122.71874, 38.48454]]]} Open Access 1 Fountain Grove Park   19021 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 14.017 Fountain Grove Park  
3496 3495 {"type": "Polygon", "coordinates": [[[-122.71291, 38.46188], [-122.71241, 38.46199], [-122.71216, 38.46156], [-122.7115, 38.46172], [-122.70972, 38.46007], [-122.70965, 38.45995], [-122.71273, 38.45904], [-122.71291, 38.46188]]]} Open Access 1 Franklin Park   19066 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 13.315 Franklin Park  
4412 4411 {"type": "Polygon", "coordinates": [[[-122.70955, 38.4434], [-122.70874, 38.44377], [-122.70831, 38.44322], [-122.70831, 38.44319], [-122.70912, 38.4428], [-122.70955, 38.4434]]]} Open Access 1 Fremont Park   19102 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1.548 Fremont Park 2000
4473 4472 {"type": "Polygon", "coordinates": [[[-122.66368, 38.41889], [-122.66292, 38.41936], [-122.66115, 38.4199], [-122.65968, 38.41989], [-122.65968, 38.41787], [-122.65839, 38.41785], [-122.65799, 38.41691], [-122.6615, 38.41693], [-122.66368, 38.41889]]]} Open Access 1 Galvin Park   19183 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 24.146 Galvin Park  
4977 4976 {"type": "Polygon", "coordinates": [[[-122.73678, 38.44783], [-122.73649, 38.44785], [-122.73648, 38.44771], [-122.73672, 38.44771], [-122.73677, 38.44775], [-122.73678, 38.44783]]]} Open Access 1 Haydn Village Park   19753 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 0.09 Haydn Village Park  
5121 5120 {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47542], [-122.70162, 38.47624], [-122.70157, 38.47671], [-122.7013, 38.47657], [-122.70121, 38.4765], [-122.70093, 38.47617], [-122.70076, 38.47599], [-122.70056, 38.47583], [-122.69975, 38.47539], [-122.69979, 38.47531], [-122.69915, 38.47498], [-122.69895, 38.47484], [-122.69885, 38.47467], [-122.70244, 38.47464], [-122.7023, 38.47517], [-122.70221, 38.47536], [-122.70256, 38.47544]]]} Open Access 1 Hidden Valley Park   19920 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 8.8 Hidden Valley Park  
5274 5273 {"type": "Polygon", "coordinates": [[[-122.6718, 38.45488], [-122.6715, 38.45491], [-122.67052, 38.45514], [-122.66999, 38.45567], [-122.66937, 38.45577], [-122.664, 38.4564], [-122.66196, 38.4572], [-122.66201, 38.45754], [-122.66181, 38.45757], [-122.66059, 38.45805], [-122.66056, 38.45805], [-122.65974, 38.45828], [-122.65973, 38.45625], [-122.6609, 38.4552], [-122.6609, 38.45518], [-122.66088, 38.45517], [-122.66193, 38.4541], [-122.66192, 38.45408], [-122.66197, 38.45406], [-122.66737, 38.45035], [-122.66768, 38.44951], [-122.66805, 38.44909], [-122.6682, 38.44925], [-122.66856, 38.44969], [-122.66934, 38.45101], [-122.6718, 38.45488]]]} Open Access 1 Howarth Park   20122 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 111.55 Howarth Park 1970
5294 5293 {"type": "Polygon", "coordinates": [[[-122.71433, 38.45338], [-122.7143, 38.4539], [-122.71426, 38.45392], [-122.71394, 38.45391], [-122.71397, 38.45335], [-122.7143, 38.45336], [-122.71433, 38.45338]]]} Open Access 1 Humboldt Park   20146 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 0.481 Humboldt Park  
5460 5459 {"type": "Polygon", "coordinates": [[[-122.73719, 38.44047], [-122.73597, 38.44051], [-122.73603, 38.44154], [-122.7343, 38.4416], [-122.7342, 38.43999], [-122.73707, 38.43986], [-122.73708, 38.43996], [-122.73716, 38.43995], [-122.73719, 38.44047]]]} Open Access 1 Jacobs Park   20329 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 8.514 Jacobs Park  
5514 5513 {"type": "Polygon", "coordinates": [[[-122.74343, 38.44794], [-122.74343, 38.44831], [-122.74298, 38.44833], [-122.743, 38.44868], [-122.74102, 38.44879], [-122.74092, 38.44747], [-122.74293, 38.44734], [-122.74299, 38.44795], [-122.74343, 38.44794]]]} Open Access 1 Jennings Park   20390 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 6.811 Jennings Park  
5694 5693 {"type": "Polygon", "coordinates": [[[-122.81259, 38.40564], [-122.81258, 38.40688], [-122.81096, 38.40685], [-122.81095, 38.40686], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.41961], [-122.81123, 38.42122], [-122.81049, 38.42125], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.4206], [-122.80889, 38.42267], [-122.80642, 38.42269], [-122.80108, 38.42268], [-122.79501, 38.42272], [-122.79499, 38.41973], [-122.80359, 38.4197], [-122.80349, 38.41056], [-122.80349, 38.4086], [-122.80676, 38.40743], [-122.80677, 38.40815], [-122.80679, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81022, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564]]]} No Public Access 3 Kelly Farm   20586 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 369.086 Kelly Farm  
6296 6295 {"type": "Polygon", "coordinates": [[[-122.76936, 38.43528], [-122.7686, 38.43533], [-122.76804, 38.43541], [-122.76769, 38.43551], [-122.76768, 38.4354], [-122.76753, 38.43421], [-122.76921, 38.43412], [-122.76936, 38.43528]]]} Open Access 1 Live Oak Park   21370 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 4.841 Live Oak Park  
6731 6730 {"type": "Polygon", "coordinates": [[[-122.70489, 38.42844], [-122.70386, 38.4288], [-122.7029, 38.42713], [-122.70284, 38.42692], [-122.70304, 38.4268], [-122.70316, 38.42678], [-122.7032, 38.42675], [-122.70329, 38.42672], [-122.70344, 38.42671], [-122.70354, 38.42665], [-122.70377, 38.42657], [-122.70384, 38.42664], [-122.70385, 38.42669], [-122.70397, 38.42686], [-122.70489, 38.42844]]]} Open Access 1 Martin Luther King Park   21919 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 5.524 Martin Luther King Park  
6753 6752 {"type": "Polygon", "coordinates": [[[-122.67198, 38.43672], [-122.67163, 38.43671], [-122.67165, 38.43646], [-122.67173, 38.43598], [-122.67152, 38.43563], [-122.67188, 38.43551], [-122.67205, 38.4358], [-122.67208, 38.43593], [-122.67208, 38.43604], [-122.67204, 38.43622], [-122.67198, 38.43672]]]} Open Access 1 Matanzas Park   21948 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1.031 Matanzas Park  
6960 6959 {"type": "Polygon", "coordinates": [[[-122.67335, 38.42801], [-122.67288, 38.42828], [-122.67285, 38.42825], [-122.67287, 38.42816], [-122.67285, 38.42811], [-122.67279, 38.42807], [-122.67269, 38.42808], [-122.67264, 38.42812], [-122.67263, 38.42817], [-122.67267, 38.42825], [-122.67275, 38.42834], [-122.67152, 38.42905], [-122.6715, 38.42775], [-122.67151, 38.42747], [-122.6724, 38.42746], [-122.67242, 38.42735], [-122.67303, 38.42735], [-122.67304, 38.42768], [-122.67335, 38.42801]]]} Open Access 1 Mesquite Park   22186 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 4.468 Mesquite Park  
7450 7449 {"type": "Polygon", "coordinates": [[[-122.70898, 38.449], [-122.70895, 38.44953], [-122.70824, 38.44951], [-122.70826, 38.44898], [-122.70898, 38.449]]]} Open Access 1 North Park   22842 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 0.916 North Park  
7490 7489 {"type": "Polygon", "coordinates": [[[-122.75088, 38.45585], [-122.75084, 38.45588], [-122.75076, 38.45647], [-122.75075, 38.45755], [-122.74783, 38.45898], [-122.74765, 38.45912], [-122.74747, 38.45933], [-122.74741, 38.45951], [-122.74739, 38.45969], [-122.74536, 38.45968], [-122.74536, 38.45837], [-122.74552, 38.45829], [-122.74565, 38.45773], [-122.74604, 38.45735], [-122.74659, 38.45735], [-122.74655, 38.45765], [-122.7475, 38.45765], [-122.74779, 38.45762], [-122.74779, 38.45737], [-122.74839, 38.45732], [-122.74838, 38.45653], [-122.74829, 38.45649], [-122.74831, 38.45648], [-122.74831, 38.45585], [-122.74823, 38.45583], [-122.74823, 38.45502], [-122.75085, 38.45501], [-122.75088, 38.45585]]]} Open Access 1 Northwest Community Park   22896 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 32.079 Northwest Community Park  
7567 7566 {"type": "Polygon", "coordinates": [[[-122.65695, 38.47237], [-122.65661, 38.47241], [-122.65663, 38.4726], [-122.65583, 38.47267], [-122.65577, 38.47231], [-122.65546, 38.47228], [-122.65536, 38.47187], [-122.65566, 38.47179], [-122.65568, 38.47108], [-122.6564, 38.47113], [-122.65656, 38.47214], [-122.65693, 38.47223], [-122.65695, 38.47237]]]} Open Access 1 Oak Lake Green Park   22985 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 3.471 Oak Lake Green 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]);