superunits_with_maps

Table actions

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

40 rows where ACCESS_TYP = 1, MNG_AGENCY = 512 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 40 ✖

MNG_AGENCY 1

  • Los Banos, City of · 40 ✖

ACCESS_TYP 1

  • Open Access · 40 ✖
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
501 501 500 {"type": "Polygon", "coordinates": [[[-120.88074, 37.0513], [-120.88052, 37.05153], [-120.88038, 37.05151], [-120.88026, 37.05154], [-120.8802, 37.05146], [-120.8801, 37.05143], [-120.88012, 37.05135], [-120.88008, 37.05123], [-120.88029, 37.05101], [-120.88074, 37.0513]]]} Open Access 1 Neighborhood Park http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf 33512 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.508 Neighborhood Park  
502 502 501 {"type": "Polygon", "coordinates": [[[-120.81459, 37.06623], [-120.81092, 37.06787], [-120.80651, 37.06239], [-120.80833, 37.06136], [-120.80844, 37.06144], [-120.80879, 37.06158], [-120.80923, 37.06165], [-120.80948, 37.06163], [-120.80998, 37.06145], [-120.81015, 37.06174], [-120.81, 37.06182], [-120.80952, 37.0622], [-120.80924, 37.06258], [-120.80908, 37.06288], [-120.80882, 37.06348], [-120.80885, 37.06432], [-120.80889, 37.06465], [-120.80909, 37.06503], [-120.80962, 37.06559], [-120.80985, 37.06582], [-120.81016, 37.06605], [-120.81055, 37.06627], [-120.81136, 37.06658], [-120.81166, 37.0666], [-120.81196, 37.0666], [-120.8127, 37.06653], [-120.81317, 37.06646], [-120.81437, 37.066], [-120.81459, 37.06623]]]} Open Access 1 Meadowlands III Basin http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf 33514 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 24.134 Meadowlands III Basin  
643 643 642 {"type": "Polygon", "coordinates": [[[-120.83479, 37.08983], [-120.83269, 37.08984], [-120.83279, 37.08797], [-120.83477, 37.08796], [-120.83479, 37.08983]]]} Open Access 1 Ag Sports Complex   15283 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 9.304 Ag Sports Complex  
1195 1195 1194 {"type": "Polygon", "coordinates": [[[-120.85495, 37.07113], [-120.85494, 37.07164], [-120.85416, 37.07164], [-120.85417, 37.0712], [-120.85421, 37.07116], [-120.85472, 37.07109], [-120.8549, 37.07109], [-120.85495, 37.07113]]]} Open Access 1 Orchard Terrace Park   32886 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 1.0 Orchard Terrace Park  
1196 1196 1195 {"type": "Polygon", "coordinates": [[[-120.84016, 37.08053], [-120.84011, 37.0806], [-120.84009, 37.08068], [-120.8401, 37.08076], [-120.84015, 37.08085], [-120.84015, 37.08118], [-120.83981, 37.08118], [-120.8398, 37.08128], [-120.83792, 37.08128], [-120.83796, 37.08102], [-120.83796, 37.08054], [-120.83802, 37.08052], [-120.838, 37.07954], [-120.83958, 37.07956], [-120.83955, 37.07964], [-120.83956, 37.07971], [-120.83963, 37.07983], [-120.83968, 37.07986], [-120.83978, 37.0799], [-120.83988, 37.0799], [-120.84005, 37.07986], [-120.84014, 37.07986], [-120.84013, 37.08043], [-120.84016, 37.08053]]]} Open Access 1 Vinyard 14 Basin C   32887 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 8.529 Vinyard 14 Basin C  
1198 1198 1197 {"type": "Polygon", "coordinates": [[[-120.82975, 37.07849], [-120.8297, 37.07853], [-120.82881, 37.07853], [-120.82862, 37.07851], [-120.82843, 37.07848], [-120.82825, 37.07842], [-120.82801, 37.07829], [-120.82776, 37.07809], [-120.82777, 37.07803], [-120.82915, 37.07712], [-120.82921, 37.07712], [-120.8296, 37.0775], [-120.82971, 37.07768], [-120.82976, 37.07787], [-120.82975, 37.07849]]]} Open Access 1 Regency Park D   32888 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 4.561 Regency Park D  
1199 1199 1198 {"type": "Polygon", "coordinates": [[[-120.83477, 37.08028], [-120.83422, 37.08027], [-120.83417, 37.08005], [-120.83425, 37.08002], [-120.83433, 37.07998], [-120.8344, 37.07988], [-120.83477, 37.07997], [-120.83477, 37.08028]]]} Open Access 1 Regency Tot Lot   32889 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.457 Regency Tot Lot  
1423 1423 1422 {"type": "Polygon", "coordinates": [[[-120.86852, 37.05834], [-120.8685, 37.05835], [-120.86824, 37.05832], [-120.86805, 37.05827], [-120.8679, 37.05819], [-120.86778, 37.05804], [-120.86758, 37.05772], [-120.86761, 37.05771], [-120.86852, 37.05834]]]} Open Access 1 Airport Park   15303 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.388 Airport Park  
2004 2004 2003 {"type": "Polygon", "coordinates": [[[-120.86345, 37.06099], [-120.86343, 37.06202], [-120.86271, 37.06203], [-120.86293, 37.06176], [-120.86305, 37.06159], [-120.86338, 37.06099], [-120.86345, 37.06099]]]} Open Access 1 Big Page Park   16084 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.92 Big Page Park  
2711 2711 2710 {"type": "Polygon", "coordinates": [[[-120.85118, 37.05874], [-120.85101, 37.05897], [-120.85058, 37.05878], [-120.85048, 37.05889], [-120.85003, 37.05869], [-120.85107, 37.05869], [-120.85118, 37.05874]]]} Open Access 1 Catholic Park   16978 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.409 Catholic Park  
2961 2961 2960 {"type": "Polygon", "coordinates": [[[-120.84921, 37.07125], [-120.84921, 37.07145], [-120.84882, 37.07145], [-120.84882, 37.07131], [-120.84901, 37.0713], [-120.84921, 37.07125]]]} Open Access 1 Citrus Terrace Park I   17286 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.154 Citrus Terrace Park I  
2962 2962 2961 {"type": "Polygon", "coordinates": [[[-120.8521, 37.07214], [-120.85209, 37.0729], [-120.85185, 37.0729], [-120.85119, 37.07263], [-120.85117, 37.07269], [-120.85052, 37.07269], [-120.85053, 37.07214], [-120.8521, 37.07214]]]} Open Access 1 Citrus Terrace Park II   17287 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 2.352 Citrus Terrace Park II  
3090 3090 3089 {"type": "Polygon", "coordinates": [[[-120.83251, 37.0478], [-120.8325, 37.04919], [-120.83102, 37.0492], [-120.83096, 37.04915], [-120.83095, 37.04844], [-120.83092, 37.04831], [-120.83088, 37.04825], [-120.83085, 37.04816], [-120.8313, 37.04813], [-120.83133, 37.04778], [-120.83251, 37.0478]]]} Open Access 1 College Green Park   17503 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 5.009 College Green Park  
3114 3114 3113 {"type": "Polygon", "coordinates": [[[-120.8676, 37.06527], [-120.86648, 37.06525], [-120.86652, 37.06449], [-120.86575, 37.06447], [-120.8658, 37.06262], [-120.86597, 37.06263], [-120.86669, 37.0628], [-120.86684, 37.06288], [-120.86699, 37.06321], [-120.86707, 37.06356], [-120.86716, 37.06357], [-120.86716, 37.0645], [-120.86744, 37.06472], [-120.86757, 37.06493], [-120.8676, 37.06527]]]} Open Access 1 Colorado Ball Park   17541 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 7.363 Colorado Ball Park  
3323 3323 3322 {"type": "Polygon", "coordinates": [[[-120.84713, 37.04245], [-120.84713, 37.04345], [-120.84567, 37.04345], [-120.84567, 37.04249], [-120.84573, 37.04244], [-120.84713, 37.04245]]]} Open Access 1 Cresthills Park   17807 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 3.568 Cresthills Park  
3460 3460 3459 {"type": "Polygon", "coordinates": [[[-120.83791, 37.07101], [-120.8379, 37.0712], [-120.83756, 37.07144], [-120.83712, 37.07102], [-120.8372, 37.07098], [-120.83724, 37.0709], [-120.83757, 37.07092], [-120.83791, 37.07101]]]} Open Access 1 Davis Park   17952 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.618 Davis Park  
4492 4492 4491 {"type": "Polygon", "coordinates": [[[-120.86689, 37.05334], [-120.8667, 37.05372], [-120.86651, 37.05366], [-120.86618, 37.05375], [-120.86598, 37.0537], [-120.86624, 37.05316], [-120.86655, 37.05326], [-120.86657, 37.05324], [-120.86689, 37.05334]]]} Open Access 1 Gardens Park I   19206 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.817 Gardens Park I  
4493 4493 4492 {"type": "Polygon", "coordinates": [[[-120.86874, 37.05209], [-120.86844, 37.05234], [-120.86842, 37.05229], [-120.86827, 37.05216], [-120.8681, 37.05227], [-120.86796, 37.05215], [-120.86814, 37.05202], [-120.86814, 37.05168], [-120.8685, 37.05176], [-120.86848, 37.05186], [-120.86852, 37.05196], [-120.8686, 37.05203], [-120.86874, 37.05209]]]} Open Access 1 Gardens Park III   19207 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 0.603 Gardens Park III  
4494 4494 4493 {"type": "Polygon", "coordinates": [[[-120.86434, 37.05547], [-120.86298, 37.0554], [-120.86298, 37.05515], [-120.86305, 37.05514], [-120.86311, 37.05509], [-120.86314, 37.05503], [-120.86312, 37.05497], [-120.86142, 37.05281], [-120.86144, 37.05275], [-120.86219, 37.05249], [-120.86201, 37.05197], [-120.86178, 37.05147], [-120.86136, 37.0508], [-120.86102, 37.05034], [-120.86092, 37.05016], [-120.8608, 37.04986], [-120.86075, 37.04956], [-120.86161, 37.04955], [-120.86176, 37.0498], [-120.86179, 37.0501], [-120.86186, 37.05039], [-120.86199, 37.05065], [-120.86226, 37.05108], [-120.86248, 37.05149], [-120.86265, 37.05191], [-120.86277, 37.05233], [-120.8634, 37.05223], [-120.86434, 37.05547]]]} Open Access 1 Gardens Park V   19208 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 17.019 Gardens Park V  
5535 5535 5534 {"type": "Polygon", "coordinates": [[[-120.81962, 37.06595], [-120.81952, 37.06616], [-120.81949, 37.06634], [-120.81768, 37.06633], [-120.81768, 37.06535], [-120.81776, 37.0653], [-120.81793, 37.0653], [-120.81825, 37.06533], [-120.81846, 37.06537], [-120.81867, 37.06545], [-120.81888, 37.06555], [-120.81917, 37.06575], [-120.81931, 37.06583], [-120.81962, 37.06595]]]} Open Access 1 Jo Lin Park   20416 1189 Los Banos, City of 512 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 3.746 Jo Lin 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]);