superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
77 rows where ACCESS_TYP = 1 and MNG_AGENCY = 253
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Hayward Area Recreation and Park District · 45 ✖
ACCESS_TYP 1
- Open Access · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5087 | 5087 | 5086 | {"type": "Polygon", "coordinates": [[[-122.12445, 37.69399], [-122.12425, 37.69399], [-122.12416, 37.69402], [-122.12319, 37.69335], [-122.12328, 37.69327], [-122.12338, 37.69313], [-122.12363, 37.69319], [-122.12373, 37.69323], [-122.12373, 37.6934], [-122.12384, 37.69341], [-122.12385, 37.69364], [-122.12407, 37.69364], [-122.12415, 37.6937], [-122.12445, 37.69371], [-122.12445, 37.69399]]]} | Open Access 1 | Hesperian Park | 19883 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.936 | Hesperian Park | ||
5153 | 5153 | 5152 | {"type": "Polygon", "coordinates": [[[-122.12275, 37.71119], [-122.12138, 37.71191], [-122.12132, 37.71201], [-122.12132, 37.71212], [-122.12152, 37.71278], [-122.12137, 37.7128], [-122.12105, 37.71205], [-122.12101, 37.71185], [-122.12098, 37.71155], [-122.12107, 37.71113], [-122.12151, 37.71046], [-122.12275, 37.71119]]]} | Open Access 1 | Hillcrest Knolls Park | 19966 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.814 | Hillcrest Knolls Park | ||
5469 | 5469 | 5468 | {"type": "Polygon", "coordinates": [[[-122.01903, 37.65238], [-122.0182, 37.65246], [-122.01762, 37.65137], [-122.0177, 37.65132], [-122.01782, 37.65088], [-122.01797, 37.65081], [-122.01824, 37.65078], [-122.01828, 37.65093], [-122.01836, 37.65112], [-122.01892, 37.65202], [-122.01899, 37.65217], [-122.01903, 37.65238]]]} | Open Access 1 | Jalquin Vista Park | 20339 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.154 | Jalquin Vista Park | ||
5486 | 5486 | 5485 | {"type": "Polygon", "coordinates": [[[-122.08163, 37.67964], [-122.08077, 37.67994], [-122.08034, 37.67899], [-122.08115, 37.67873], [-122.08163, 37.67964]]]} | Open Access 1 | Japanese Gardens | 20362 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.2 | Japanese Gardens | ||
5835 | 5835 | 5834 | {"type": "Polygon", "coordinates": [[[-122.10386, 37.66497], [-122.10343, 37.66497], [-122.10343, 37.66475], [-122.10385, 37.66475], [-122.10386, 37.66497]]]} | Open Access 1 | La Placita Mini Park | 20788 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.229 | La Placita MP | ||
5954 | 5954 | 5953 | {"type": "Polygon", "coordinates": [[[-122.05144, 37.68537], [-122.05131, 37.68541], [-122.05103, 37.68483], [-122.05054, 37.68497], [-122.05009, 37.68402], [-122.04984, 37.68345], [-122.04983, 37.68337], [-122.04959, 37.68288], [-122.05066, 37.68269], [-122.05091, 37.68321], [-122.05088, 37.68324], [-122.05132, 37.6842], [-122.05095, 37.68432], [-122.05144, 37.68537]]]} | Open Access 1 | Lakeridge Park | 20970 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 5.386 | Lakeridge Park | ||
6162 | 6162 | 6161 | {"type": "Polygon", "coordinates": [[[-122.08382, 37.67039], [-122.083, 37.67089], [-122.0822, 37.67], [-122.08301, 37.66953], [-122.08382, 37.67039]]]} | Open Access 1 | Library Park | 21224 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.683 | Library Park | ||
6368 | 6368 | 6367 | {"type": "Polygon", "coordinates": [[[-122.10851, 37.65793], [-122.10708, 37.65845], [-122.10676, 37.65794], [-122.10824, 37.65731], [-122.10851, 37.65793]]]} | Open Access 1 | Longwood Park | 21458 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.404 | Longwood Park | ||
6406 | 6406 | 6405 | {"type": "Polygon", "coordinates": [[[-122.06246, 37.64119], [-122.06232, 37.64127], [-122.05822, 37.63602], [-122.05831, 37.63597], [-122.05832, 37.63595], [-122.05833, 37.63595], [-122.06246, 37.64119]]]} | Open Access 1 | Nuestro Parquecito | 22935 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.342 | Nuestro Parquecito | ||
6721 | 6721 | 6720 | {"type": "Polygon", "coordinates": [[[-122.09273, 37.63614], [-122.09226, 37.63664], [-122.09216, 37.63438], [-122.09246, 37.63438], [-122.0925, 37.6344], [-122.09251, 37.63442], [-122.09256, 37.63586], [-122.09261, 37.63602], [-122.09273, 37.63614]]]} | Open Access 1 | Martin Luther King Field | 21906 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.77 | Martin Luther King Field | ||
6788 | 6788 | 6787 | {"type": "Polygon", "coordinates": [[[-122.12224, 37.67045], [-122.12185, 37.67061], [-122.12193, 37.67077], [-122.12152, 37.67079], [-122.12086, 37.66972], [-122.12161, 37.66942], [-122.12204, 37.67012], [-122.1221, 37.67012], [-122.12222, 37.67031], [-122.12218, 37.67034], [-122.12224, 37.67045]]]} | Open Access 1 | Mc Conaghy Park | 21985 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.463 | Mc Conaghy Park | ||
6891 | 6891 | 6890 | {"type": "Polygon", "coordinates": [[[-122.1144, 37.68599], [-122.11396, 37.68623], [-122.11369, 37.68633], [-122.11347, 37.68631], [-122.11314, 37.6862], [-122.1129, 37.68607], [-122.11285, 37.685], [-122.11298, 37.68492], [-122.11301, 37.68483], [-122.11289, 37.68469], [-122.11285, 37.68395], [-122.11419, 37.68388], [-122.1144, 37.68599]]]} | Open Access 1 | Meek Park | 22104 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 7.907 | Meek Park | ||
7261 | 7261 | 7260 | {"type": "Polygon", "coordinates": [[[-122.10116, 37.6315], [-122.09735, 37.63159], [-122.09693, 37.63095], [-122.10101, 37.62939], [-122.10116, 37.6315]]]} | Open Access 1 | Mt. Eden Park | 22577 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 13.735 | Mt. Eden Park | ||
7645 | 7645 | 7644 | {"type": "Polygon", "coordinates": [[[-122.04961, 37.66126], [-122.04912, 37.66152], [-122.04848, 37.66153], [-122.04851, 37.66049], [-122.04931, 37.66038], [-122.04961, 37.66126]]]} | Open Access 1 | Old Highlands Park | 23086 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.498 | Old Highlands Park | ||
7876 | 7876 | 7875 | {"type": "Polygon", "coordinates": [[[-122.08803, 37.62809], [-122.08797, 37.62953], [-122.08792, 37.62957], [-122.08779, 37.62954], [-122.08761, 37.62946], [-122.08716, 37.62916], [-122.0867, 37.62889], [-122.0861, 37.62865], [-122.0856, 37.62851], [-122.08557, 37.62846], [-122.08561, 37.62834], [-122.08803, 37.62809]]]} | Open Access 1 | Palma Ceia Park | 23349 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 4.554 | Palma Ceia Park | ||
7889 | 7889 | 7888 | {"type": "Polygon", "coordinates": [[[-122.02692, 37.71714], [-122.02691, 37.71717], [-122.02654, 37.71755], [-122.02637, 37.71747], [-122.02451, 37.71785], [-122.02432, 37.71778], [-122.02444, 37.71756], [-122.02439, 37.71745], [-122.02463, 37.71737], [-122.02484, 37.71727], [-122.02502, 37.71717], [-122.02482, 37.71695], [-122.02504, 37.7168], [-122.02517, 37.71668], [-122.02554, 37.7163], [-122.0258, 37.71608], [-122.02603, 37.71595], [-122.02615, 37.71591], [-122.02674, 37.71691], [-122.02692, 37.71714]]]} | Open Access 1 | Palomares Hills Park | 23366 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 6.075 | Palomares Hills Park | ||
7993 | 7993 | 7992 | {"type": "Polygon", "coordinates": [[[-122.08616, 37.71826], [-122.08524, 37.71962], [-122.0845, 37.71944], [-122.0848, 37.71885], [-122.08526, 37.71821], [-122.08533, 37.718], [-122.08568, 37.71799], [-122.0858, 37.71803], [-122.08595, 37.7181], [-122.08616, 37.71826]]]} | Open Access 1 | Parsons Park | 23483 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.279 | Parsons Park | ||
8507 | 8507 | 8506 | {"type": "Polygon", "coordinates": [[[-122.11063, 37.64003], [-122.10917, 37.64003], [-122.10914, 37.63892], [-122.1106, 37.63889], [-122.11063, 37.64003]]]} | Open Access 1 | Rancho Arroyo Park | 24128 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.994 | Rancho Arroyo Park | ||
9031 | 9031 | 9030 | {"type": "Polygon", "coordinates": [[[-121.98774, 37.69927], [-121.987, 37.69915], [-121.98436, 37.69881], [-121.98245, 37.69859], [-121.98161, 37.69845], [-121.98091, 37.69828], [-121.98042, 37.69813], [-121.97989, 37.69799], [-121.97916, 37.69786], [-121.97787, 37.69781], [-121.97662, 37.69763], [-121.97536, 37.69737], [-121.97291, 37.69698], [-121.97296, 37.6967], [-121.97308, 37.69667], [-121.97325, 37.69658], [-121.97334, 37.69638], [-121.97349, 37.69634], [-121.97353, 37.69606], [-121.97363, 37.69594], [-121.97374, 37.69576], [-121.97373, 37.69571], [-121.97376, 37.69562], [-121.97371, 37.69553], [-121.97377, 37.69509], [-121.97355, 37.69429], [-121.97839, 37.69432], [-121.97842, 37.69486], [-121.98072, 37.69488], [-121.98069, 37.6951], [-121.98129, 37.69619], [-121.98162, 37.69661], [-121.98198, 37.697], [-121.982, 37.69713], [-121.98773, 37.69755], [-121.98774, 37.69927]]]} | Open Access 1 | Rowell Ranch Rodeo Park | 24705 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 83.083 | Rowell Ranch Rodeo Park | ||
9056 | 9056 | 9055 | {"type": "Polygon", "coordinates": [[[-122.04919, 37.62473], [-122.0482, 37.62471], [-122.04819, 37.62468], [-122.04791, 37.62468], [-122.04788, 37.62445], [-122.0478, 37.62427], [-122.04767, 37.62406], [-122.04748, 37.62389], [-122.04746, 37.62381], [-122.04768, 37.62358], [-122.04775, 37.62353], [-122.04789, 37.62346], [-122.04801, 37.62343], [-122.04807, 37.62336], [-122.04842, 37.62324], [-122.04874, 37.62365], [-122.04837, 37.62365], [-122.04836, 37.62367], [-122.04919, 37.62473]]]} | Open Access 1 | Twin Bridges Park | 26610 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.296 | Twin Bridges Park |
Advanced export
JSON shape: default, array, newline-delimited
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]);