units_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 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
783 782 {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} Open Access 1 5069 Southgate Park 25689 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 14.46 Southgate Park 1965 Local Park 2 4
1101 1100 {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} Open Access 1 15630 Haymont Mini Park 19758 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.431 Haymont MP 0 Local Park 2 4
1434 1433 {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} Open Access 1 47699 J.A. Lewis Park 31435 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 12.57 J.A. Lewis Park 0 Local Park 2 4
1435 1434 {"type": "Polygon", "coordinates": [[[-122.13981, 37.67822], [-122.13977, 37.67831], [-122.13782, 37.6791], [-122.13753, 37.67864], [-122.13699, 37.67886], [-122.13613, 37.67751], [-122.13869, 37.67647], [-122.13981, 37.67822]]]} Open Access 1 47700 Mervin Morris Park 31436 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 13.34 Mervin Morris Park 0 Local Park 2 4
1451 1450 {"type": "Polygon", "coordinates": [[[-122.09749, 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.09749, 37.66354]]]} Open Access 1 9747 Centennial Park 17031 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 9.492 Centennial Park 0 Local Park 2 4
1518 1517 {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} Open Access 1 47719 Adobe Park 31505 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/facilities/facility/details/Adobe-Park-116 Alameda 17 3.894 Adobe Park 0 Local Park 2 4
1911 1910 {"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 14788 Rancho Arroyo Park 24128 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.995 Rancho Arroyo Park 0 Local Park 2 4
1912 1911 {"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.65003], [-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.65054], [-122.03644, 37.65092]]]} Open Access 1 14813 Canyon View Park 16828 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.42 Canyon View Park 0 Local Park 2 4
1913 1912 {"type": "Polygon", "coordinates": [[[-122.10025, 37.63972], [-122.09932, 37.64006], [-122.09902, 37.63977], [-122.09843, 37.63943], [-122.09845, 37.63939], [-122.09852, 37.63939], [-122.09978, 37.63889], [-122.10025, 37.63972]]]} Open Access 1 14791 Gansberger Park 19186 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.664 Gansberger Park 0 Local Park 2 4
1914 1913 {"type": "Polygon", "coordinates": [[[-122.05238, 37.63238], [-122.05203, 37.63263], [-122.05126, 37.63194], [-122.05159, 37.63169], [-122.05238, 37.63238]]]} Open Access 1 14805 Valle Vista Park 26774 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.045 Valle Vista Park 0 Local Park 2 4
1916 1915 {"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 14853 Fairway Greens Park 18823 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.548 Fairway Greens Park 0 Local Park 2 4
1920 1919 {"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 14886 De Anza Park 17969 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.03 De Anza Park 0 Local Park 2 4
1983 1982 {"type": "Polygon", "coordinates": [[[-122.05682, 37.70364], [-122.05641, 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 15157 Bay Trees Park 15882 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.11 Bay Trees Park 0 Local Park 2 4
2052 2051 {"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 15627 East Avenue School Park 31952 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 9.509 East Avenue School Park 0 Local Park 2 4
2256 2255 {"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 18099 Mt. Eden Park 22577 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 13.739 Mt. Eden Park 0 Local Park 2 4
2719 2718 {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} Restricted Access 2 18348 Oliver Property 23136 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 118.291 Oliver Property 1977 Local Other or Unknown 14 4
3610 3609 {"type": "Polygon", "coordinates": [[[-122.14555, 37.66548], [-122.14449, 37.66584], [-122.14439, 37.66644], [-122.14233, 37.66724], [-122.14201, 37.66706], [-122.14184, 37.66295], [-122.14345, 37.66316], [-122.14555, 37.66548]]]} Open Access 1 441 San Lorenzo Community Park 24925 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 23.787 San Lorenzo Community Park 0 Local Park 2 4
5221 5220 {"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.97915, 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.97841, 37.69486], [-121.98072, 37.69488], [-121.98068, 37.69509], [-121.98129, 37.6962], [-121.98162, 37.69661], [-121.98198, 37.697], [-121.98199, 37.69713], [-121.98773, 37.69755], [-121.98774, 37.69927]]]} Open Access 1 289 Rowell Ranch Rodeo Park 24705 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 83.074 Rowell Ranch Rodeo Park 0 Local Park 2 4
5287 5286 {"type": "Polygon", "coordinates": [[[-122.05946, 37.69439], [-122.05885, 37.69507], [-122.05883, 37.69556], [-122.05837, 37.69604], [-122.0583, 37.69656], [-122.05816, 37.69676], [-122.05724, 37.69663], [-122.0572, 37.69677], [-122.05723, 37.69694], [-122.05723, 37.69719], [-122.05716, 37.69742], [-122.05696, 37.69785], [-122.0571, 37.69796], [-122.05793, 37.698], [-122.05779, 37.69844], [-122.05769, 37.69896], [-122.05722, 37.6991], [-122.0572, 37.69932], [-122.05738, 37.6997], [-122.05682, 37.69978], [-122.0567, 37.70057], [-122.05573, 37.70103], [-122.05575, 37.70138], [-122.05386, 37.70191], [-122.0541, 37.70148], [-122.05419, 37.70111], [-122.05497, 37.70103], [-122.05533, 37.70088], [-122.05541, 37.70078], [-122.05512, 37.7002], [-122.05508, 37.69964], [-122.05485, 37.69902], [-122.05494, 37.69854], [-122.05526, 37.69825], [-122.05619, 37.69811], [-122.05662, 37.69776], [-122.05681, 37.69721], [-122.05677, 37.69689], [-122.05636, 37.69651], [-122.05587, 37.69632], [-122.05596, 37.69539], [-122.05657, 37.69468], [-122.05841, 37.69457], [-122.05946, 37.69439]]]} Open Access 1 15159 Earl Warren Park 18355 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 31.448 Earl Warren Park 0 Local Park 2 4
6459 6458 {"type": "Polygon", "coordinates": [[[-122.07934, 37.6359], [-122.07868, 37.63596], [-122.07811, 37.63594], [-122.07765, 37.63578], [-122.07731, 37.63541], [-122.07665, 37.63442], [-122.07597, 37.63349], [-122.07584, 37.63306], [-122.07927, 37.63317], [-122.07934, 37.6359]]]} Open Access 1 1996 Weekes Park 27330 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 17.561 Weekes 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 76.525ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette