units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 253 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9305 | 9305 | 9304 | {"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.69341], [-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 | 15510 | Hesperian Park | 19883 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.934 | Hesperian Park | 0 | Local Park 2 | 4 | |
9156 | 9156 | 9155 | {"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 | 15194 | Hillcrest Knolls Park | 19966 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.813 | Hillcrest Knolls Park | 0 | Local Park 2 | 4 | |
9155 | 9155 | 9154 | {"type": "Polygon", "coordinates": [[[-122.11417, 37.70787], [-122.11417, 37.70787], [-122.11329, 37.70866], [-122.11332, 37.70842], [-122.11328, 37.70824], [-122.1132, 37.70811], [-122.11301, 37.70804], [-122.11304, 37.70766], [-122.11417, 37.70787]]]} | Open Access 1 | 15191 | Fairmont Terrace Park | 18809 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.269 | Fairmont Terrace Park | 0 | Local Park 2 | 4 | |
9154 | 9154 | 9153 | {"type": "Polygon", "coordinates": [[[-122.12555, 37.70411], [-122.12363, 37.70561], [-122.12383, 37.70583], [-122.12339, 37.70622], [-122.12336, 37.70621], [-122.12346, 37.7058], [-122.12372, 37.70537], [-122.12391, 37.70519], [-122.12547, 37.70402], [-122.12555, 37.70411]]]} | Open Access 1 | 15189 | Fairmont Linear Park | 18804 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.132 | Fairmont Linear Park | 0 | Local Park 2 | 4 | |
9145 | 9145 | 9144 | {"type": "Polygon", "coordinates": [[[-122.11882, 37.69374], [-122.1188, 37.69506], [-122.11701, 37.69506], [-122.117, 37.6955], [-122.11632, 37.69548], [-122.11631, 37.6952], [-122.11528, 37.69519], [-122.11529, 37.6942], [-122.11632, 37.69421], [-122.11633, 37.69398], [-122.11717, 37.69399], [-122.11718, 37.69373], [-122.11882, 37.69374]]]} | Open Access 1 | 15174 | Edendale Park | 18430 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.673 | Edendale Park | 0 | Local Park 2 | 4 | |
9143 | 9143 | 9142 | {"type": "Polygon", "coordinates": [[[-122.10782, 37.69342], [-122.10723, 37.69384], [-122.107, 37.69365], [-122.10684, 37.69376], [-122.1067, 37.69364], [-122.10697, 37.69343], [-122.10661, 37.69311], [-122.10689, 37.6929], [-122.10691, 37.69291], [-122.10694, 37.69288], [-122.10694, 37.69286], [-122.10699, 37.69283], [-122.10782, 37.69342]]]} | Open Access 1 | 15171 | Ashland Park | 15654 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.486 | Ashland Park | 0 | Local Park 2 | 4 | |
9140 | 9140 | 9139 | {"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.08581, 37.71803], [-122.08595, 37.7181], [-122.08616, 37.71826]]]} | Open Access 1 | 15168 | Parsons Park | 23483 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.279 | Parsons Park | 0 | Local Park 2 | 4 | |
9132 | 9132 | 9131 | {"type": "Polygon", "coordinates": [[[-122.08308, 37.68418], [-122.08272, 37.68452], [-122.08234, 37.68439], [-122.08172, 37.68431], [-122.08168, 37.68381], [-122.0816, 37.68341], [-122.08094, 37.68258], [-122.0823, 37.68258], [-122.08273, 37.68373], [-122.08287, 37.68397], [-122.08308, 37.68418]]]} | Open Access 1 | 15163 | Carlos Bee Park | 16860 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.137 | Carlos Bee Park | 0 | Local Park 2 | 4 | |
9131 | 9131 | 9130 | {"type": "Polygon", "coordinates": [[[-122.05436, 37.68017], [-122.05423, 37.68062], [-122.05412, 37.68067], [-122.05414, 37.68057], [-122.0539, 37.68045], [-122.0531, 37.68083], [-122.05273, 37.68038], [-122.05255, 37.6796], [-122.05317, 37.67967], [-122.05318, 37.67971], [-122.05436, 37.68017]]]} | Open Access 1 | 15161 | Fairview Park | 18818 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.054 | Fairview Park | 0 | Local Park 2 | 4 | |
9000 | 9000 | 8999 | {"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 | 14874 | Japanese Gardens | 20362 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.2 | Japanese Gardens | 0 | Local Park 2 | 4 | |
8998 | 8998 | 8997 | {"type": "Polygon", "coordinates": [[[-122.11531, 37.64788], [-122.11529, 37.64789], [-122.11531, 37.64852], [-122.11527, 37.64857], [-122.11472, 37.6486], [-122.11441, 37.64865], [-122.11416, 37.64823], [-122.11456, 37.64807], [-122.11465, 37.64777], [-122.11453, 37.64739], [-122.11475, 37.64721], [-122.11492, 37.64652], [-122.11526, 37.64651], [-122.11531, 37.64788]]]} | Open Access 1 | 14868 | Greenwood Park | 19491 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/147/Greenwood-Park | Alameda 17 | 3.46 | Greenwood Park | 0 | Local Park 2 | 4 |
8997 | 8997 | 8996 | {"type": "MultiPolygon", "coordinates": [[[[-122.04337, 37.62404], [-122.0433, 37.62429], [-122.04202, 37.62518], [-122.04029, 37.62378], [-122.04286, 37.62379], [-122.0431, 37.62411], [-122.04331, 37.62396], [-122.04337, 37.62404]]], [[[-122.05058, 37.62653], [-122.04861, 37.62811], [-122.04838, 37.62793], [-122.0453, 37.62798], [-122.04225, 37.62538], [-122.04346, 37.62451], [-122.04355, 37.62461], [-122.04366, 37.6246], [-122.04449, 37.62538], [-122.04567, 37.62544], [-122.0457, 37.62672], [-122.04602, 37.62698], [-122.04659, 37.62714], [-122.04745, 37.62728], [-122.04796, 37.62732], [-122.04819, 37.62714], [-122.04814, 37.62684], [-122.04827, 37.62667], [-122.04822, 37.62471], [-122.04919, 37.62473], [-122.05058, 37.62653]]]]} | Restricted Access 2 | 14851 | Mission Hills Golf Course | 33042 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 37.311 | Mission Hills GC | 0 | Local Recreation Area 3 | 4 | |
8996 | 8996 | 8995 | {"type": "Polygon", "coordinates": [[[-122.07014, 37.61978], [-122.07006, 37.6198], [-122.0699, 37.61981], [-122.06971, 37.61985], [-122.0694, 37.62003], [-122.06922, 37.62008], [-122.06915, 37.62004], [-122.06907, 37.61961], [-122.0691, 37.61951], [-122.06908, 37.61944], [-122.06915, 37.61935], [-122.06914, 37.61919], [-122.07005, 37.61909], [-122.07014, 37.61978]]]} | Open Access 1 | 14860 | Stratford Village Park | 25907 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.858 | Stratford Village Park | 0 | Local Park 2 | 4 | |
8995 | 8995 | 8994 | {"type": "Polygon", "coordinates": [[[-122.04353, 37.6184], [-122.04178, 37.61966], [-122.04028, 37.61836], [-122.04197, 37.61708], [-122.04353, 37.6184]]]} | Open Access 1 | 14855 | Bidwell Park | 16069 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.154 | Bidwell Park | 0 | Local Park 2 | 4 | |
8992 | 8992 | 8991 | {"type": "Polygon", "coordinates": [[[-122.0868, 37.64365], [-122.0862, 37.64443], [-122.08561, 37.64443], [-122.0856, 37.64372], [-122.08598, 37.64371], [-122.08609, 37.64358], [-122.08652, 37.64359], [-122.08664, 37.64357], [-122.0868, 37.64365]]]} | Open Access 1 | 14846 | Schafer Park | 25179 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.748 | Schafer Park | 0 | Local Park 2 | 4 | |
8991 | 8991 | 8990 | {"type": "Polygon", "coordinates": [[[-122.06921, 37.65745], [-122.06885, 37.6576], [-122.06789, 37.65718], [-122.06765, 37.65698], [-122.06747, 37.65668], [-122.06699, 37.65618], [-122.06735, 37.65594], [-122.06776, 37.65649], [-122.06823, 37.65633], [-122.06921, 37.65745]]]} | Open Access 1 | 14843 | Spring Grove Park | 25738 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.192 | Spring Grove Park | 0 | Local Park 2 | 4 | |
8989 | 8989 | 8988 | {"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 | 14840 | Meek Park | 22104 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 7.907 | Meek Park | 0 | Local Park 2 | 4 | |
8987 | 8987 | 8986 | {"type": "Polygon", "coordinates": [[[-122.09567, 37.62037], [-122.09565, 37.62062], [-122.09561, 37.62089], [-122.09467, 37.62085], [-122.09433, 37.62076], [-122.09392, 37.62056], [-122.09321, 37.62], [-122.09278, 37.61977], [-122.09277, 37.61937], [-122.09283, 37.61933], [-122.09308, 37.61934], [-122.09332, 37.61941], [-122.09398, 37.6198], [-122.09428, 37.62011], [-122.0945, 37.62021], [-122.09478, 37.62027], [-122.09558, 37.62033], [-122.09567, 37.62037]]]} | Open Access 1 | 14865 | Christian Penke Park | 31451 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.375 | Christian Penke Park | 0 | Local Park 2 | 4 | |
8986 | 8986 | 8985 | {"type": "Polygon", "coordinates": [[[-122.07515, 37.62535], [-122.07338, 37.62536], [-122.07346, 37.62481], [-122.07338, 37.62446], [-122.07398, 37.62436], [-122.07422, 37.62446], [-122.07438, 37.6245], [-122.07509, 37.62453], [-122.07515, 37.62535]]]} | Open Access 1 | 14863 | Ruus Park | 24757 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.683 | Ruus Park | 0 | Local Park 2 | 4 | |
8985 | 8985 | 8984 | {"type": "Polygon", "coordinates": [[[-122.10726, 37.67622], [-122.10552, 37.67683], [-122.10512, 37.67609], [-122.10694, 37.67552], [-122.10726, 37.67622]]]} | Open Access 1 | 14837 | Cherryland Park | 17174 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.635 | Cherryland 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]);