units_with_maps

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

83 rows where MNG_AGENCY = 29

View and edit SQL

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS

DES_TP

MNG_AG_TYP

MNG_AGENCY

  • Santa Rosa, City of · 83
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
62 61 {"type": "Polygon", "coordinates": [[[-122.66503, 38.48047], [-122.66507, 38.48062], [-122.66507, 38.48074], [-122.66505, 38.48087], [-122.66498, 38.48107], [-122.66496, 38.48119], [-122.66497, 38.48269], [-122.66322, 38.483], [-122.66293, 38.48249], [-122.66263, 38.48191], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48126], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48058], [-122.66503, 38.48047]]]} Open Access 1 151 Rincon Valley Community Park 24371 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 18.752 Rincon Valley Community Park 0 Local Park 2 4
200 199 {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} Open Access 1 47323 Finali Park 31030 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2 https://srcity.org/Facilities/Facility/Details/Finali-Park-66 Sonoma 16 2.768 Finali Park 2016 Local Park 2 4
302 301 {"type": "Polygon", "coordinates": [[[-122.73498, 38.41334], [-122.73206, 38.41414], [-122.732, 38.41029], [-122.73412, 38.41036], [-122.73414, 38.41144], [-122.73498, 38.41334]]]} Open Access 1 1039 Southwest Community Park 25702 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 19.939 Southwest Community Park 2000 Local Park 2 4
446 445 {"type": "Polygon", "coordinates": [[[-122.66242, 38.47114], [-122.66213, 38.47116], [-122.66213, 38.47141], [-122.66207, 38.47141], [-122.66205, 38.47119], [-122.662, 38.47116], [-122.66181, 38.47119], [-122.66165, 38.47124], [-122.66159, 38.47128], [-122.66148, 38.47136], [-122.66139, 38.47148], [-122.66134, 38.47158], [-122.66137, 38.47161], [-122.66165, 38.47167], [-122.66163, 38.47172], [-122.66122, 38.47168], [-122.66121, 38.47167], [-122.66054, 38.47168], [-122.66082, 38.47198], [-122.66076, 38.47205], [-122.6604, 38.47199], [-122.6607, 38.47278], [-122.66079, 38.47294], [-122.66069, 38.47298], [-122.66028, 38.47227], [-122.66019, 38.47203], [-122.66005, 38.47195], [-122.65984, 38.4719], [-122.65972, 38.47189], [-122.65961, 38.47193], [-122.65961, 38.47195], [-122.65973, 38.47217], [-122.65968, 38.47221], [-122.65941, 38.47206], [-122.6593, 38.47218], [-122.6593, 38.47224], [-122.65895, 38.47224], [-122.65893, 38.47227], [-122.65897, 38.47249], [-122.6589, 38.47252], [-122.65871, 38.47234], [-122.65847, 38.47254], [-122.65823, 38.47252], [-122.65819, 38.47273], [-122.65811, 38.47274], [-122.65799, 38.47254], [-122.65781, 38.4726], [-122.65772, 38.47271], [-122.65769, 38.47289], [-122.65823, 38.47383], [-122.65798, 38.47392], [-122.65784, 38.47368], [-122.65768, 38.47373], [-122.65754, 38.47273], [-122.65752, 38.47273], [-122.65748, 38.47249], [-122.65713, 38.47243], [-122.65711, 38.4723], [-122.65747, 38.47227], [-122.65765, 38.47233], [-122.65769, 38.47231], [-122.65833, 38.47224], [-122.65853, 38.47206], [-122.65851, 38.4719], [-122.65872, 38.47188], [-122.6587, 38.47167], [-122.65881, 38.47168], [-122.6589, 38.47164], [-122.65894, 38.47156], [-122.65892, 38.47146], [-122.66106, 38.47127], [-122.66098, 38.47103], [-122.66125, 38.4708], [-122.66134, 38.47078], [-122.66153, 38.47076], [-122.66159, 38.4708], [-122.66159, 38.47083], [-122.66166, 38.47084], [-122.66172, 38.47081], [-122.66174, 38.47076], [-122.66234, 38.47095], [-122.66242, 38.47114]]]} Open Access 1 1405 Tanglewood Park 26180 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 7.775 Tanglewood Park 0 Local Park 2 4
723 722 {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} No Public Access 3 4499 Stone Farm 25869 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 45.409 Stone Farm   None 67  
1302 1301 {"type": "Polygon", "coordinates": [[[-122.7616, 38.42519], [-122.7609, 38.42525], [-122.76082, 38.42464], [-122.76085, 38.4246], [-122.76086, 38.42454], [-122.76083, 38.42446], [-122.7608, 38.42413], [-122.76146, 38.42409], [-122.7616, 38.42519]]]} Open Access 1 10458 Village Green Park 27116 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 1.837 Village Green Park 0 Local Park 2 4
1325 1324 {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47541], [-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.6998, 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 10821 Hidden Valley Park 19920 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 8.794 Hidden Valley Park 0 Local Park 2 4
1327 1326 {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69344, 38.49011], [-122.69317, 38.49012], [-122.69239, 38.49008], [-122.69236, 38.49005], [-122.69238, 38.4897], [-122.69237, 38.48951], [-122.69231, 38.48938], [-122.69218, 38.48923], [-122.69204, 38.48914], [-122.69189, 38.48908], [-122.69146, 38.489], [-122.69126, 38.48894], [-122.69096, 38.48877], [-122.69078, 38.48865], [-122.69125, 38.48827], [-122.69152, 38.48843], [-122.69216, 38.48858], [-122.69245, 38.48857], [-122.69273, 38.48852], [-122.69314, 38.48835], [-122.69317, 38.48825], [-122.69296, 38.48806], [-122.69306, 38.48799], [-122.69316, 38.48795], [-122.69332, 38.48792], [-122.69337, 38.48793], [-122.6934, 38.48797], [-122.69343, 38.48816], [-122.6935, 38.48892], [-122.69361, 38.48938], [-122.69369, 38.48967], [-122.69381, 38.48999]]]} Open Access 1 10830 Rincon Ridge Park 24370 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 7.263 Rincon Ridge Park 0 Local Park 2 4
1487 1486 {"type": "Polygon", "coordinates": [[[-122.76629, 38.45731], [-122.76628, 38.45882], [-122.76465, 38.45882], [-122.76464, 38.45793], [-122.76534, 38.45792], [-122.76553, 38.45789], [-122.76572, 38.4578], [-122.76589, 38.45769], [-122.76613, 38.45742], [-122.76629, 38.45731]]]} Open Access 1 10402 Peterson Lane Park 23632 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 4.051 Peterson Lane Park 0 Local Park 2 4
1491 1490 {"type": "Polygon", "coordinates": [[[-122.7096, 38.43788], [-122.70954, 38.43791], [-122.70929, 38.4381], [-122.70925, 38.43795], [-122.70895, 38.43799], [-122.70876, 38.43769], [-122.70873, 38.43762], [-122.70874, 38.4376], [-122.7088, 38.43759], [-122.70951, 38.4375], [-122.7096, 38.43788]]]} Open Access 1 10579 Rae Park 24071 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 0.782 Rae Park 0 Local Park 2 4
1492 1491 {"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 10590 Railroad Depot Park 32921 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2 https://srcity.org/Facilities/Facility/Details/Railroad-Depot-Park-97 Sonoma 16 0.326 Railroad Depot Park 0 Local Park 2 4
1493 1492 {"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 10601 DeMeo Park 18080 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 1.14 DeMeo Park 0 Local Park 2 4
1495 1494 {"type": "Polygon", "coordinates": [[[-122.72547, 38.44105], [-122.72507, 38.44108], [-122.72464, 38.44045], [-122.72539, 38.44038], [-122.72547, 38.44105]]]} Open Access 1 10616 DeTurk Park 18123 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 0.923 DeTurk Park 0 Local Park 2 4
1497 1496 {"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 10498 Bellevue Ranch 15988 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 3.292 Bellevue Ranch 0 Local Park 2 4
1499 1498 {"type": "Polygon", "coordinates": [[[-122.71082, 38.40228], [-122.71082, 38.40279], [-122.7105, 38.40279], [-122.7105, 38.40224], [-122.71077, 38.40224], [-122.71082, 38.40228]]]} Open Access 1 10510 Red Hawk Park 24222 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 0.419 Red Hawk Park 0 Local Park 2 4
1502 1501 {"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.70384, 38.42669], [-122.70397, 38.42686], [-122.70489, 38.42844]]]} Open Access 1 10533 Martin Luther King Park 21919 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 5.524 Martin Luther King Park 0 Local Park 2 4
1504 1503 {"type": "Polygon", "coordinates": [[[-122.74197, 38.43694], [-122.74187, 38.43693], [-122.74179, 38.43719], [-122.74176, 38.43718], [-122.74183, 38.43691], [-122.74053, 38.43668], [-122.74052, 38.43665], [-122.74049, 38.43665], [-122.74048, 38.43651], [-122.74046, 38.43647], [-122.74041, 38.43638], [-122.74036, 38.43634], [-122.74029, 38.43618], [-122.74135, 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 10628 Westgate Park 32920 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 2.451 Westgate Park 0 Local Park 2 4
1505 1504 {"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 10640 Jacobs Park 20329 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 8.507 Jacobs Park 0 Local Park 2 4
1506 1505 {"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.45078], [-122.74855, 38.45051], [-122.74885, 38.45051], [-122.74889, 38.45078], [-122.74929, 38.45078], [-122.7493, 38.45103]]]} Open Access 1 10676 Brendon Park 16349 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 1.071 Brendon Park 0 Local Park 2 4
1507 1506 {"type": "Polygon", "coordinates": [[[-122.76048, 38.46948], [-122.76047, 38.46866], [-122.76257, 38.46867], [-122.76262, 38.4687], [-122.76263, 38.46944], [-122.76261, 38.46948], [-122.76218, 38.46953], [-122.76187, 38.46955], [-122.76156, 38.46954], [-122.76094, 38.46948], [-122.76048, 38.46948]]]} Open Access 1 10687 Pioneer Park 23734 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 4.352 Pioneer 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]);
Powered by Datasette · Query took 86.977ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette