superunits_with_maps

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

84 rows where MNG_AGENCY = 253

View and edit SQL

Suggested facets: YR_EST

ACCESS_TYP

MNG_AGENCY

  • Hayward Area Recreation and Park District · 84
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
318 317 {"type": "Polygon", "coordinates": [[[-122.10346, 37.63089], [-122.10346, 37.63092], [-122.10342, 37.63095], [-122.10209, 37.63146], [-122.10118, 37.63149], [-122.10113, 37.62978], [-122.10242, 37.62927], [-122.10248, 37.6293], [-122.10346, 37.63089]]]} Restricted Access 2 Brenkwitz School Park   31949 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 8.676 Brenkwitz School Park  
320 319 {"type": "Polygon", "coordinates": [[[-122.11964, 37.68374], [-122.11923, 37.684], [-122.11911, 37.68404], [-122.1168, 37.6842], [-122.11595, 37.68321], [-122.11627, 37.683], [-122.11617, 37.68289], [-122.11753, 37.6819], [-122.11964, 37.68374]]]} Restricted Access 2 Colonial Acres School Park   31951 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 11.664 Colonial Acres School Park  
321 320 {"type": "Polygon", "coordinates": [[[-122.05604, 37.67111], [-122.05571, 37.6729], [-122.05568, 37.67326], [-122.05563, 37.67337], [-122.05549, 37.67348], [-122.05533, 37.67354], [-122.05428, 37.67355], [-122.05406, 37.67328], [-122.0545, 37.67093], [-122.05604, 37.67111]]]} Restricted Access 2 East Avenue School Park   31952 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 9.509 East Avenue School Park  
322 321 {"type": "Polygon", "coordinates": [[[-122.02891, 37.61505], [-122.02833, 37.61549], [-122.02815, 37.61565], [-122.02808, 37.61564], [-122.02768, 37.6154], [-122.0275, 37.61532], [-122.02734, 37.61528], [-122.02669, 37.61518], [-122.0265, 37.6151], [-122.02633, 37.61497], [-122.02598, 37.61449], [-122.02752, 37.6138], [-122.02891, 37.61502], [-122.02891, 37.61505]]]} Restricted Access 2 El Rancho Verde School Park   31953 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 6.895 El Rancho Verde School Park  
594 593 {"type": "MultiPolygon", "coordinates": [[[[-122.15302, 37.6263], [-122.15283, 37.62659], [-122.1515, 37.6266], [-122.14839, 37.62665], [-122.14826, 37.62667], [-122.14763, 37.62687], [-122.14728, 37.62691], [-122.14546, 37.62688], [-122.14478, 37.62685], [-122.14441, 37.62681], [-122.144, 37.6268], [-122.14248, 37.62687], [-122.14139, 37.62687], [-122.14047, 37.62683], [-122.14027, 37.6268], [-122.13998, 37.62671], [-122.13982, 37.62673], [-122.13956, 37.62689], [-122.13937, 37.62323], [-122.13708, 37.62323], [-122.13704, 37.6234], [-122.13625, 37.62359], [-122.13581, 37.62359], [-122.13521, 37.62378], [-122.13519, 37.62365], [-122.13545, 37.623], [-122.13965, 37.6221], [-122.14706, 37.62481], [-122.14837, 37.62508], [-122.14973, 37.62515], [-122.1508, 37.62499], [-122.15138, 37.62484], [-122.15259, 37.62462], [-122.15302, 37.6263]]], [[[-122.14879, 37.65606], [-122.14479, 37.65609], [-122.14396, 37.65627], [-122.14392, 37.65609], [-122.14392, 37.65591], [-122.14433, 37.64981], [-122.14879, 37.65606]]], [[[-122.16185, 37.6312], [-122.16174, 37.64456], [-122.16171, 37.65587], [-122.16161, 37.65596], [-122.15072, 37.65604], [-122.15069, 37.65593], [-122.15098, 37.65355], [-122.14947, 37.65148], [-122.15252, 37.65117], [-122.15482, 37.65108], [-122.15483, 37.65097], [-122.15538, 37.65153], [-122.15604, 37.65307], [-122.15606, 37.65307], [-122.15555, 37.65078], [-122.15547, 37.65072], [-122.15521, 37.64933], [-122.15539, 37.64918], [-122.15538, 37.64917], [-122.15521, 37.64913], [-122.15538, 37.64891], [-122.15541, 37.64884], [-122.15518, 37.64882], [-122.15504, 37.64871], [-122.15489, 37.64814], [-122.15466, 37.64699], [-122.15488, 37.6468], [-122.15488, 37.64677], [-122.15469, 37.64672], [-122.1544, 37.64599], [-122.15437, 37.64555], [-122.15426, 37.64537], [-122.15389, 37.64384], [-122.1538, 37.64376], [-122.15348, 37.6423], [-122.15368, 37.64213], [-122.15367, 37.64208], [-122.15349, 37.64195], [-122.15351, 37.64192], [-122.15381, 37.64187], [-122.1539, 37.64184], [-122.15408, 37.64173], [-122.15408, 37.64167], [-122.15511, 37.64161], [-122.15521, 37.63118], [-122.16185, 37.6312]]]]} Open Access 1 Hayward Shoreline   4363 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 595.915 Hayward Shoreline 1977
1439 1438 {"type": "Polygon", "coordinates": [[[-122.08989, 37.61048], [-122.08987, 37.61053], [-122.08977, 37.61052], [-122.08967, 37.61056], [-122.08963, 37.61061], [-122.08961, 37.61069], [-122.08957, 37.61073], [-122.08562, 37.61228], [-122.08557, 37.61229], [-122.08553, 37.61227], [-122.0855, 37.61225], [-122.08428, 37.61025], [-122.08437, 37.6101], [-122.08512, 37.60981], [-122.0861, 37.60938], [-122.08619, 37.60938], [-122.08648, 37.60926], [-122.08681, 37.60932], [-122.08724, 37.60918], [-122.08742, 37.60915], [-122.08761, 37.60915], [-122.08791, 37.60919], [-122.08818, 37.60928], [-122.08836, 37.60916], [-122.08989, 37.61048]]]} Open Access 1 Alden E. Oliver Sports Park   15344 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 25.025 Alden E. Oliver Sports Park  
1634 1633 {"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.10694, 37.69288], [-122.10694, 37.69286], [-122.10699, 37.69283], [-122.10782, 37.69342]]]} Open Access 1 Ashland Park   15654 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 1.491 Ashland Park  
1826 1825 {"type": "Polygon", "coordinates": [[[-122.05682, 37.70364], [-122.0564, 37.70375], [-122.05514, 37.70372], [-122.05489, 37.70318], [-122.05456, 37.70286], [-122.05383, 37.70232], [-122.05378, 37.70221], [-122.05378, 37.70212], [-122.05386, 37.70191], [-122.05575, 37.70138], [-122.05582, 37.70159], [-122.05567, 37.70185], [-122.05613, 37.70198], [-122.05682, 37.70364]]]} Open Access 1 Bay Trees Park   15882 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 10.113 Bay Trees Park  
1876 1875 {"type": "Polygon", "coordinates": [[[-122.06106, 37.63806], [-122.06102, 37.63812], [-122.06103, 37.63819], [-122.06072, 37.63834], [-122.06026, 37.63776], [-122.06057, 37.6376], [-122.06066, 37.63766], [-122.06077, 37.63765], [-122.06106, 37.63806]]]} Open Access 1 Bechtel Mini Park   15943 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 0.774 Bechtel MP  
1990 1989 {"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 Bidwell Park   16069 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 10.154 Bidwell Park  
2028 2027 {"type": "Polygon", "coordinates": [[[-122.09878, 37.65729], [-122.09825, 37.6575], [-122.09773, 37.65671], [-122.09751, 37.65644], [-122.09709, 37.65605], [-122.09672, 37.65574], [-122.09648, 37.65547], [-122.09632, 37.6551], [-122.09726, 37.65473], [-122.09878, 37.65729]]]} Open Access 1 Birchfield Park   16118 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 5.571 Birchfield Park  
2586 2585 {"type": "MultiPolygon", "coordinates": [[[[-122.09848, 37.6662], [-122.09842, 37.66627], [-122.09778, 37.66645], [-122.09657, 37.66695], [-122.09658, 37.66685], [-122.09655, 37.66675], [-122.09646, 37.66666], [-122.09633, 37.66659], [-122.09627, 37.66653], [-122.09624, 37.66646], [-122.09624, 37.66632], [-122.09623, 37.66623], [-122.09615, 37.66613], [-122.09604, 37.66606], [-122.0961, 37.66601], [-122.09614, 37.66592], [-122.09613, 37.66585], [-122.09609, 37.66577], [-122.09603, 37.66572], [-122.09593, 37.66568], [-122.09583, 37.66567], [-122.09573, 37.6657], [-122.09569, 37.66565], [-122.09552, 37.66571], [-122.09542, 37.66556], [-122.09598, 37.66533], [-122.09605, 37.66536], [-122.09734, 37.66483], [-122.09751, 37.6647], [-122.09754, 37.6647], [-122.09759, 37.66472], [-122.09774, 37.66485], [-122.09775, 37.66489], [-122.09774, 37.66494], [-122.09781, 37.66499], [-122.09787, 37.66498], [-122.09791, 37.665], [-122.09798, 37.66507], [-122.09797, 37.66513], [-122.09803, 37.66519], [-122.09809, 37.66518], [-122.09813, 37.6652], [-122.09832, 37.66536], [-122.0984, 37.66548], [-122.09846, 37.6656], [-122.09848, 37.66577], [-122.09848, 37.6662]]], [[[-122.09979, 37.66635], [-122.09965, 37.66634], [-122.09922, 37.66653], [-122.09922, 37.66654], [-122.09962, 37.6669], [-122.09929, 37.66705], [-122.09921, 37.66703], [-122.09892, 37.66677], [-122.09883, 37.66665], [-122.09877, 37.66653], [-122.09875, 37.66646], [-122.09873, 37.66624], [-122.09873, 37.66586], [-122.09872, 37.66572], [-122.09864, 37.66551], [-122.09851, 37.66533], [-122.09853, 37.66528], [-122.09855, 37.66527], [-122.09979, 37.66635]]]]} Open Access 1 Cannery Park   16803 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 11.105 Cannery Park  
2605 2604 {"type": "Polygon", "coordinates": [[[-122.03644, 37.65092], [-122.03581, 37.65096], [-122.03481, 37.65153], [-122.03382, 37.65111], [-122.03393, 37.65094], [-122.03406, 37.65079], [-122.03463, 37.65028], [-122.03484, 37.65004], [-122.03481, 37.65], [-122.03496, 37.64975], [-122.035, 37.64973], [-122.03514, 37.64979], [-122.03553, 37.65008], [-122.03596, 37.65036], [-122.03605, 37.65047], [-122.03598, 37.65055], [-122.03644, 37.65092]]]} Open Access 1 Canyon View Park   16828 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 5.422 Canyon View Park  
2631 2630 {"type": "Polygon", "coordinates": [[[-122.08308, 37.68418], [-122.08272, 37.68452], [-122.08234, 37.68439], [-122.08172, 37.68431], [-122.08168, 37.68382], [-122.0816, 37.68341], [-122.08094, 37.68258], [-122.0823, 37.68258], [-122.08273, 37.68373], [-122.08287, 37.68398], [-122.08308, 37.68418]]]} Open Access 1 Carlos Bee Park   16860 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 5.137 Carlos Bee Park  
2753 2752 {"type": "Polygon", "coordinates": [[[-122.0975, 37.66354], [-122.09714, 37.66357], [-122.09618, 37.66266], [-122.09563, 37.66224], [-122.09518, 37.66185], [-122.0948, 37.66148], [-122.0965, 37.6607], [-122.09689, 37.66105], [-122.0972, 37.66164], [-122.09739, 37.66218], [-122.09747, 37.66261], [-122.09753, 37.66314], [-122.0975, 37.66354]]]} Open Access 1 Centennial Park   17031 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 9.49 Centennial Park  
2777 2776 {"type": "Polygon", "coordinates": [[[-122.06028, 37.72143], [-122.05949, 37.7214], [-122.05929, 37.72149], [-122.05929, 37.72141], [-122.05922, 37.72128], [-122.05923, 37.72117], [-122.05937, 37.72113], [-122.05955, 37.72111], [-122.06008, 37.72111], [-122.06028, 37.72109], [-122.06028, 37.72143]]]} Open Access 1 Deerview Park   18011 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 0.764 Deerview Park  
2880 2879 {"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 Cherryland Park   17174 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 3.634 Cherryland Park  
3091 3090 {"type": "Polygon", "coordinates": [[[-122.04506, 37.65547], [-122.04503, 37.65551], [-122.04411, 37.65578], [-122.04333, 37.65598], [-122.04326, 37.65535], [-122.04327, 37.65533], [-122.04349, 37.65521], [-122.04358, 37.65514], [-122.04367, 37.65502], [-122.04374, 37.65486], [-122.04377, 37.65484], [-122.044, 37.65483], [-122.04414, 37.65481], [-122.04427, 37.65477], [-122.0445, 37.65467], [-122.04456, 37.65475], [-122.04463, 37.65513], [-122.04497, 37.65514], [-122.04499, 37.65533], [-122.04506, 37.65547]]]} Open Access 1 College Heights Park   17504 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 3.294 College Heights Park  
3279 3278 {"type": "Polygon", "coordinates": [[[-122.03982, 37.62532], [-122.03904, 37.62569], [-122.03862, 37.62582], [-122.03843, 37.62596], [-122.03811, 37.62529], [-122.03914, 37.62488], [-122.03936, 37.62482], [-122.03964, 37.62485], [-122.03982, 37.62532]]]} Open Access 1 Fairway Greens Park   18823 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 2.548 Fairway Greens Park  
3480 3479 {"type": "Polygon", "coordinates": [[[-122.08302, 37.67721], [-122.08212, 37.6778], [-122.08184, 37.67751], [-122.0828, 37.6769], [-122.08302, 37.67721]]]} Open Access 1 De Anza Park   17969 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 1.03 De Anza Park  

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]);
Powered by Datasette · Query took 52.238ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette