units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 29
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 | 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 | 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 | 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 | 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 | |
1302 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | |
1509 | 1509 | 1508 | {"type": "Polygon", "coordinates": [[[-122.73461, 38.46734], [-122.7346, 38.46746], [-122.73412, 38.46747], [-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.73416, 38.46733], [-122.73461, 38.46734]]]} | Open Access 1 | 10704 | Bicentennial Park | 16066 | 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.086 | Bicentennial Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);