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

79 rows where MNG_AGENCY = 29 sorted by ACCESS_TYP

View and edit SQL

Suggested facets: YR_EST

MNG_AG_TYP

MNG_AGENCY

  • Santa Rosa, City of · 79
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
190 189 {"type": "Polygon", "coordinates": [[[-122.76777, 38.44155], [-122.76294, 38.44149], [-122.76245, 38.44143], [-122.75839, 38.44082], [-122.75793, 38.44072], [-122.75784, 38.43796], [-122.75939, 38.43796], [-122.75992, 38.4382], [-122.76024, 38.43812], [-122.76023, 38.43774], [-122.7607, 38.43792], [-122.76121, 38.43805], [-122.76187, 38.43812], [-122.76776, 38.43816], [-122.76777, 38.44155]]]} Open Access 1 A Place to Play Park   15224 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 76.452 A Place to Play Park  
1045 1044 {"type": "Polygon", "coordinates": [[[-122.70017, 38.45107], [-122.69985, 38.45112], [-122.69976, 38.45111], [-122.6999, 38.45099], [-122.69998, 38.45089], [-122.70003, 38.45087], [-122.70008, 38.4509], [-122.70012, 38.45099], [-122.70017, 38.45107]]]} Open Access 1 Triangle Park   32821 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.122 Triangle Park  
1046 1045 {"type": "Polygon", "coordinates": [[[-122.69406, 38.42745], [-122.69385, 38.42747], [-122.69367, 38.42746], [-122.69323, 38.42733], [-122.69295, 38.42728], [-122.69276, 38.42728], [-122.69252, 38.42729], [-122.6925, 38.42728], [-122.69245, 38.42715], [-122.69226, 38.4268], [-122.6925, 38.4267], [-122.69262, 38.42662], [-122.69273, 38.42651], [-122.6928, 38.42637], [-122.69306, 38.42644], [-122.69312, 38.42649], [-122.69314, 38.42658], [-122.69322, 38.42669], [-122.69329, 38.42675], [-122.69343, 38.42681], [-122.69351, 38.42687], [-122.69368, 38.42704], [-122.69378, 38.42716], [-122.69384, 38.42728], [-122.694, 38.42736], [-122.69406, 38.42745]]]} Open Access 1 Dauenhauer Park https://srcity.org/Facilities/Facility/Details/Dauenhauer-Park-59 32822 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 2.291 Dauenhauer Park  
1051 1050 {"type": "Polygon", "coordinates": [[[-122.71198, 38.44182], [-122.71187, 38.44186], [-122.7117, 38.44163], [-122.71179, 38.44159], [-122.71198, 38.44182]]]} Open Access 1 Jeju Way   32823 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.074 Jeju Way  
1052 1051 {"type": "Polygon", "coordinates": [[[-122.71534, 38.43546], [-122.71239, 38.43614], [-122.7121, 38.43498], [-122.71507, 38.43425], [-122.71534, 38.43546]]]} Open Access 1 Juilliard Park   32824 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.874 Juilliard Park  
1053 1052 {"type": "Polygon", "coordinates": [[[-122.71421, 38.43614], [-122.71396, 38.4362], [-122.71382, 38.43581], [-122.71408, 38.43575], [-122.71421, 38.43614]]]} Open Access 1 Church of One Tree https://srcity.org/633/Church-of-One-Tree 32825 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.253 Church of One Tree  
1245 1244 {"type": "Polygon", "coordinates": [[[-122.71434, 38.4402], [-122.71349, 38.44058], [-122.71304, 38.43997], [-122.71388, 38.43959], [-122.71434, 38.4402]]]} Open Access 1 Old Courthouse Square   32918 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.67 Old Courthouse Square  
1246 1245 {"type": "Polygon", "coordinates": [[[-122.71532, 38.47393], [-122.71504, 38.47426], [-122.71504, 38.47458], [-122.71331, 38.4746], [-122.7133, 38.47473], [-122.71345, 38.47478], [-122.71349, 38.47484], [-122.7135, 38.47491], [-122.71339, 38.47498], [-122.713, 38.47508], [-122.71274, 38.47512], [-122.71267, 38.47507], [-122.71267, 38.47483], [-122.7126, 38.4746], [-122.71301, 38.4746], [-122.71302, 38.47458], [-122.71279, 38.4741], [-122.71246, 38.47385], [-122.71229, 38.47366], [-122.7126, 38.47363], [-122.71325, 38.47374], [-122.71388, 38.47367], [-122.71416, 38.47368], [-122.71463, 38.47373], [-122.71487, 38.47378], [-122.71507, 38.47383], [-122.71532, 38.47393]]]} Open Access 1 Frances Nielsen Ranch Park   32919 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.88 Frances Nielsen Ranch Park  
1247 1246 {"type": "Polygon", "coordinates": [[[-122.74197, 38.43694], [-122.74187, 38.43693], [-122.74179, 38.43719], [-122.74176, 38.43718], [-122.74182, 38.43691], [-122.74053, 38.43668], [-122.74052, 38.43665], [-122.74049, 38.43665], [-122.74046, 38.43647], [-122.74041, 38.43638], [-122.74036, 38.43634], [-122.74029, 38.43618], [-122.74134, 38.43611], [-122.74131, 38.43586], [-122.74135, 38.43587], [-122.7414, 38.43611], [-122.74185, 38.43607], [-122.74197, 38.43694]]]} Open Access 1 Westgate Park   32920 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 2.461 Westgate Park  
1248 1247 {"type": "Polygon", "coordinates": [[[-122.72142, 38.43789], [-122.72122, 38.43798], [-122.72083, 38.43747], [-122.72102, 38.43739], [-122.72142, 38.43789]]]} Open Access 1 Railroad Depot Park https://srcity.org/Facilities/Facility/Details/Railroad-Depot-Park-97 32921 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.326 Railroad Depot Park  
1935 1934 {"type": "Polygon", "coordinates": [[[-122.73927, 38.40898], [-122.73867, 38.40899], [-122.738, 38.40906], [-122.73765, 38.40913], [-122.73678, 38.40934], [-122.73673, 38.40907], [-122.73673, 38.40862], [-122.73676, 38.40856], [-122.73679, 38.40856], [-122.73922, 38.40855], [-122.73926, 38.40859], [-122.73927, 38.40898]]]} Open Access 1 Bellevue Ranch   15988 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.291 Bellevue Ranch  
1988 1987 {"type": "Polygon", "coordinates": [[[-122.73461, 38.46734], [-122.7346, 38.46746], [-122.73412, 38.46748], [-122.73412, 38.46903], [-122.73393, 38.46903], [-122.73392, 38.46856], [-122.73274, 38.46856], [-122.73272, 38.46715], [-122.73363, 38.46714], [-122.73415, 38.46715], [-122.73417, 38.46733], [-122.73461, 38.46734]]]} Open Access 1 Bicentennial Park   16066 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.097 Bicentennial Park  
2223 2222 {"type": "Polygon", "coordinates": [[[-122.7493, 38.45103], [-122.74879, 38.45105], [-122.74793, 38.45105], [-122.74799, 38.45086], [-122.74798, 38.45076], [-122.74856, 38.45077], [-122.74855, 38.45051], [-122.74885, 38.45051], [-122.74889, 38.45078], [-122.74929, 38.45078], [-122.7493, 38.45103]]]} Open Access 1 Brendon Park   16349 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.075 Brendon Park  
2287 2286 {"type": "Polygon", "coordinates": [[[-122.68198, 38.46239], [-122.68133, 38.4633], [-122.68079, 38.46269], [-122.68076, 38.46258], [-122.68051, 38.46228], [-122.68082, 38.46212], [-122.68198, 38.46239]]]} Open Access 1 Brush Creek Park   16453 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 2.058 Brush Creek Park  
2358 2357 {"type": "Polygon", "coordinates": [[[-122.71212, 38.43656], [-122.7117, 38.43671], [-122.71147, 38.43682], [-122.71142, 38.43649], [-122.71151, 38.43656], [-122.71162, 38.43657], [-122.71167, 38.43655], [-122.71171, 38.43652], [-122.71172, 38.43645], [-122.71168, 38.43638], [-122.71161, 38.43636], [-122.71132, 38.43638], [-122.71122, 38.43594], [-122.71127, 38.43591], [-122.7112, 38.43553], [-122.71192, 38.43544], [-122.7121, 38.43627], [-122.71212, 38.43656]]]} Open Access 1 Burbank Home & Gardens   16508 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 2.036 Burbank Home & Gardens  
2843 2842 {"type": "Polygon", "coordinates": [[[-122.72736, 38.43806], [-122.72694, 38.43821], [-122.72682, 38.43805], [-122.7265, 38.43817], [-122.72622, 38.43778], [-122.72694, 38.43746], [-122.72736, 38.43806]]]} Open Access 1 DeMeo Park   18080 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.141 DeMeo Park  
2990 2989 {"type": "Polygon", "coordinates": [[[-122.69702, 38.44707], [-122.69667, 38.44712], [-122.69664, 38.44728], [-122.69643, 38.44733], [-122.69631, 38.4472], [-122.69599, 38.44727], [-122.69594, 38.44715], [-122.69636, 38.44706], [-122.69699, 38.44694], [-122.69702, 38.44707]]]} Open Access 1 Eastside Park   18400 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.421 Eastside Park  
3058 3057 {"type": "Polygon", "coordinates": [[[-122.74875, 38.47854], [-122.74847, 38.4785], [-122.74774, 38.47848], [-122.74764, 38.47838], [-122.74756, 38.47836], [-122.74744, 38.47839], [-122.74717, 38.47833], [-122.74716, 38.47697], [-122.74722, 38.47692], [-122.7478, 38.47691], [-122.74855, 38.47695], [-122.74864, 38.47728], [-122.74879, 38.47755], [-122.74887, 38.47785], [-122.74887, 38.47811], [-122.74883, 38.47835], [-122.74875, 38.47854]]]} Open Access 1 Coffey Park   17476 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.869 Coffey Park  
3082 3081 {"type": "Polygon", "coordinates": [[[-122.70759, 38.41914], [-122.70755, 38.42031], [-122.70755, 38.42031], [-122.70739, 38.42027], [-122.70713, 38.42014], [-122.70689, 38.41994], [-122.70666, 38.41953], [-122.70667, 38.41945], [-122.7068, 38.41934], [-122.70705, 38.41921], [-122.70739, 38.41913], [-122.70759, 38.41914]]]} Open Access 1 Colgan Creek Park   17495 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.807 Colgan Creek Park  
3083 3082 {"type": "Polygon", "coordinates": [[[-122.727, 38.40276], [-122.72699, 38.40298], [-122.72678, 38.40342], [-122.72676, 38.40361], [-122.7267, 38.40366], [-122.72629, 38.40366], [-122.72613, 38.40368], [-122.72613, 38.40277], [-122.727, 38.40276]]]} Open Access 1 Colgan Creek Park and Preserve   17496 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.602 Colgan Creek Park and Preserve  

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