units_with_maps

Table actions

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

396 rows where ACCESS_TYP = 1, COUNTY = 22 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 396 ✖
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
97 97 96 {"type": "Polygon", "coordinates": [[[-117.30816, 34.53759], [-117.30716, 34.53889], [-117.30693, 34.53907], [-117.30671, 34.53892], [-117.30646, 34.53843], [-117.30645, 34.53754], [-117.30753, 34.53753], [-117.30754, 34.5372], [-117.30789, 34.5372], [-117.30789, 34.53752], [-117.30816, 34.53759]]]} Open Access 1 251 Avalon Park 15721 1367 Victorville, City of 40 City 2 City Agency 2 http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 City 2 1367 Victorville, City of 39 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation San Bernardino 22 4.449 Avalon Park 0 Local Park 2 4
137 137 136 {"type": "Polygon", "coordinates": [[[-117.71227, 34.05211], [-117.7113, 34.05211], [-117.71127, 34.05209], [-117.71124, 34.05098], [-117.71125, 34.05096], [-117.71128, 34.05095], [-117.71144, 34.05095], [-117.71167, 34.05098], [-117.71176, 34.05095], [-117.71179, 34.05098], [-117.71225, 34.05098], [-117.71227, 34.05211]]]} Open Access 1 356 Essex Park 18719 1210 Montclair, City of 55 City 2 City Agency 2 http://www.ci.montclair.ca.us/ City 2 1210 Montclair, City of 53 City 2 City Agency 2   San Bernardino 22 2.899 Essex Park 0 Local Park 2 4
204 204 203 {"type": "Polygon", "coordinates": [[[-117.02997, 34.03356], [-117.02997, 34.03377], [-117.02941, 34.03377], [-117.02914, 34.03394], [-117.02885, 34.03399], [-117.02788, 34.03405], [-117.02754, 34.03409], [-117.02722, 34.03415], [-117.0269, 34.03424], [-117.02635, 34.03442], [-117.02582, 34.03455], [-117.02582, 34.03393], [-117.02624, 34.03374], [-117.02655, 34.03364], [-117.02714, 34.03341], [-117.02743, 34.03333], [-117.02775, 34.03332], [-117.02809, 34.03329], [-117.02842, 34.03316], [-117.02872, 34.03302], [-117.02896, 34.033], [-117.02925, 34.03307], [-117.02953, 34.03319], [-117.02978, 34.03334], [-117.02997, 34.03356]]]} Open Access 1 549 Flag Hill Veterans Memorial Park 18934 1387 Yucaipa, City of 83 City 2 City Agency 2 http://yucaipa.org/recreation/parks/ City 2 1387 Yucaipa, City of 81 City 2 City Agency 2   San Bernardino 22 7.782 Flag Hill Veterans Memorial Park 0 Local Park 2 4
244 244 243 {"type": "Polygon", "coordinates": [[[-117.19007, 34.07019], [-117.19006, 34.0736], [-117.18985, 34.0736], [-117.18986, 34.07019], [-117.19007, 34.07019]]]} Open Access 1 47336 Lugonia Garden 31047 1269 Redlands, City of 101 City 2 City Agency 2 http://www.cityofredlands.org/ City 2 1269 Redlands, City of 99 City 2 City Agency 2 http://www.cityofredlands.org/recreation/gardens San Bernardino 22 1.811 Lugonia Garden 0 Local Park 2 4
245 245 244 {"type": "Polygon", "coordinates": [[[-117.17915, 34.07497], [-117.17889, 34.07497], [-117.17889, 34.07456], [-117.17873, 34.07455], [-117.17877, 34.07447], [-117.17915, 34.07447], [-117.17915, 34.07497]]]} Open Access 1 47337 Clement Garden 31048 1269 Redlands, City of 101 City 2 City Agency 2 http://www.cityofredlands.org/ City 2 1269 Redlands, City of 99 City 2 City Agency 2 http://www.cityofredlands.org/recreation/gardens San Bernardino 22 0.356 Clement Garden 0 Local Park 2 4
246 246 245 {"type": "Polygon", "coordinates": [[[-117.14865, 34.08097], [-117.14842, 34.08086], [-117.14818, 34.0805], [-117.14822, 34.0787], [-117.14826, 34.07852], [-117.14847, 34.07818], [-117.14864, 34.07795], [-117.14865, 34.08097]]]} Open Access 1 47338 Granite Citrus Grove 31049 1269 Redlands, City of 101 City 2 City Agency 2 http://www.cityofredlands.org/ City 2 1269 Redlands, City of 99 City 2 City Agency 2   San Bernardino 22 2.837 Granite Citrus Grove 0 Local Park 2 4
247 247 246 {"type": "MultiPolygon", "coordinates": [[[[-117.19099, 34.07975], [-117.18687, 34.07973], [-117.18688, 34.07746], [-117.18692, 34.07744], [-117.18906, 34.07745], [-117.18906, 34.0777], [-117.18766, 34.0777], [-117.18766, 34.07866], [-117.18812, 34.07867], [-117.18811, 34.07919], [-117.18814, 34.07928], [-117.18819, 34.07936], [-117.18831, 34.07946], [-117.18846, 34.0795], [-117.18863, 34.0795], [-117.18878, 34.07944], [-117.18886, 34.07937], [-117.18895, 34.07925], [-117.18895, 34.07902], [-117.18912, 34.07902], [-117.18912, 34.07879], [-117.19053, 34.0788], [-117.19077, 34.0789], [-117.19099, 34.07891], [-117.19099, 34.07975]]], [[[-117.19099, 34.07883], [-117.19081, 34.07881], [-117.1906, 34.07871], [-117.19051, 34.07871], [-117.19051, 34.07868], [-117.19099, 34.07868], [-117.19099, 34.07883]]]]} Open Access 1 47339 Texas Citrus Grove 31050 1269 Redlands, City of 101 City 2 City Agency 2 http://www.cityofredlands.org/ City 2 1269 Redlands, City of 99 City 2 City Agency 2   San Bernardino 22 12.156 Texas Citrus Grove 0 Local Park 2 4
259 259 258 {"type": "MultiPolygon", "coordinates": [[[[-117.36134, 34.13414], [-117.36044, 34.13413], [-117.35976, 34.13403], [-117.35946, 34.134], [-117.35748, 34.134], [-117.35744, 34.13395], [-117.35744, 34.13232], [-117.35952, 34.13231], [-117.35953, 34.1325], [-117.36134, 34.13414]]], [[[-117.36159, 34.13433], [-117.36161, 34.13552], [-117.36157, 34.13564], [-117.36063, 34.13558], [-117.36062, 34.13562], [-117.36025, 34.1356], [-117.35802, 34.13514], [-117.35779, 34.13507], [-117.35765, 34.13499], [-117.35753, 34.13488], [-117.35745, 34.13473], [-117.35745, 34.13419], [-117.35943, 34.13418], [-117.35973, 34.1342], [-117.36018, 34.13429], [-117.36044, 34.13431], [-117.36062, 34.13432], [-117.36064, 34.13431], [-117.36159, 34.13433]]]]} Open Access 1 716 Frisbie Park 19125 1273 Rialto, City of 106 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 1273 Rialto, City of 103 City 2 City Agency 2   San Bernardino 22 24.7 Frisbie Park 0 Local Park 2 4
292 292 291 {"type": "Polygon", "coordinates": [[[-117.74983, 33.98171], [-117.74983, 33.98173], [-117.74917, 33.98211], [-117.7487, 33.98234], [-117.74822, 33.9825], [-117.74765, 33.98266], [-117.74706, 33.98292], [-117.74679, 33.98308], [-117.74653, 33.98325], [-117.74634, 33.98341], [-117.74612, 33.98362], [-117.7458, 33.98398], [-117.74576, 33.984], [-117.74571, 33.98399], [-117.74532, 33.98373], [-117.74293, 33.9821], [-117.74291, 33.98201], [-117.74313, 33.98179], [-117.74377, 33.98124], [-117.74408, 33.98175], [-117.74983, 33.98171]]]} Open Access 1 47368 Veterans Park 31090 1054 Chino Hills, City of 119 City 2 City Agency 2 http://www.chinohills.org/index.aspx?nid=364 City 2 1054 Chino Hills, City of 116 City 2 City Agency 2 https://www.chinohills.org/index.aspx?NID=1083 San Bernardino 22 20.038 Veterans Park 0 Local Park 2 4
307 307 306 {"type": "MultiPolygon", "coordinates": [[[[-117.62955, 34.07444], [-117.62956, 34.0754], [-117.62946, 34.07586], [-117.62937, 34.07617], [-117.62935, 34.07617], [-117.62931, 34.07628], [-117.62915, 34.07659], [-117.6287, 34.07729], [-117.62856, 34.07757], [-117.62816, 34.07757], [-117.62788, 34.07753], [-117.62727, 34.07753], [-117.62726, 34.07445], [-117.62955, 34.07444]]], [[[-117.63188, 34.07786], [-117.62911, 34.07787], [-117.62898, 34.07785], [-117.62878, 34.07778], [-117.62895, 34.0773], [-117.6295, 34.07649], [-117.62969, 34.07598], [-117.62977, 34.07546], [-117.62977, 34.07444], [-117.63186, 34.07443], [-117.63188, 34.07786]]]]} Open Access 1 813 John Galvin Park 20443 1232 Ontario, City of 126 City 2 City Agency 2 http://www.ci.ontario.ca.us/index.aspx?page=456 City 2 1232 Ontario, City of 123 City 2 City Agency 2   San Bernardino 22 36.644 John Galvin Park 0 Local Park 2 4
353 353 352 {"type": "Polygon", "coordinates": [[[-117.66787, 34.10512], [-117.66674, 34.10513], [-117.66674, 34.1034], [-117.66787, 34.1034], [-117.66787, 34.10512]]]} Open Access 1 975 Baldy View Park 15781 1363 Upland, City of 145 City 2 City Agency 2 http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp City 2 1363 Upland, City of 141 City 2 City Agency 2   San Bernardino 22 4.946 Baldy View Park 0 Local Park 2 4
372 372 371 {"type": "Polygon", "coordinates": [[[-117.18137, 34.05688], [-117.1811, 34.05687], [-117.1811, 34.05655], [-117.18137, 34.05655], [-117.18137, 34.05688]]]} Open Access 1 1330 Hale Park 19603 1269 Redlands, City of 101 City 2 City Agency 2 http://www.cityofredlands.org/ City 2 1269 Redlands, City of 99 City 2 City Agency 2   San Bernardino 22 0.219 Hale Park 0 Local Park 2 4
399 399 398 {"type": "Polygon", "coordinates": [[[-117.67941, 34.11771], [-117.67723, 34.11772], [-117.67722, 34.116], [-117.6794, 34.11599], [-117.67941, 34.11771]]]} Open Access 1 1203 Greenbelt Park 19473 1363 Upland, City of 145 City 2 City Agency 2 http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp City 2 1363 Upland, City of 141 City 2 City Agency 2   San Bernardino 22 9.512 Greenbelt Park 0 Local Park 2 4
410 410 409 {"type": "Polygon", "coordinates": [[[-117.31293, 34.04116], [-117.31264, 34.04165], [-117.31246, 34.04162], [-117.31235, 34.04161], [-117.31217, 34.04164], [-117.31119, 34.04202], [-117.31116, 34.04197], [-117.31117, 34.04193], [-117.31118, 34.04169], [-117.31137, 34.04167], [-117.31142, 34.04163], [-117.31149, 34.04153], [-117.31147, 34.04145], [-117.31123, 34.04145], [-117.31123, 34.04137], [-117.31125, 34.04136], [-117.31125, 34.04115], [-117.31293, 34.04116]]]} Open Access 1 47371 Susan Petta Park 31095 1123 Grand Terrace, City of 165 City 2 City Agency 2 http://www.cityofgrandterrace.org/index.aspx?nid=25 City 2 1123 Grand Terrace, City of 161 City 2 City Agency 2   San Bernardino 22 2.238 Susan Petta Park 2010 Local Park 2 4
411 411 410 {"type": "Polygon", "coordinates": [[[-117.30344, 34.0362], [-117.30312, 34.03635], [-117.303, 34.03459], [-117.30316, 34.0344], [-117.30322, 34.03425], [-117.30325, 34.03409], [-117.30331, 34.03405], [-117.30333, 34.03405], [-117.30333, 34.03443], [-117.30332, 34.03444], [-117.30344, 34.0362]]]} Open Access 1 47372 Griffin Park 31098 1123 Grand Terrace, City of 165 City 2 City Agency 2 http://www.cityofgrandterrace.org/index.aspx?nid=25 City 2 1123 Grand Terrace, City of 161 City 2 City Agency 2   San Bernardino 22 1.632 Griffin Park 0 Local Park 2 4
412 412 411 {"type": "Polygon", "coordinates": [[[-117.33003, 34.06197], [-117.32998, 34.06223], [-117.329, 34.06209], [-117.32902, 34.062], [-117.32935, 34.06202], [-117.33003, 34.06197]]]} Open Access 1 47373 N Street Mini Park West 31096 1062 Colton, City of 166 City 2 City Agency 2 http://www.ci.colton.ca.us/index.aspx?NID=136 City 2 1062 Colton, City of 162 City 2 City Agency 2   San Bernardino 22 0.397 N Street MP West 0 Local Park 2 4
416 416 415 {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} Open Access 1 1286 Gutierrez Field 19573 1293 San Bernardino, City of 167 City 2 City Agency 2 http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp City 2 1293 San Bernardino, City of 163 City 2 City Agency 2   San Bernardino 22 1.988 Gutierrez Field 0 Local Recreation Area 3 4
429 429 428 {"type": "Polygon", "coordinates": [[[-117.49266, 34.11629], [-117.4928, 34.1163], [-117.49293, 34.11635], [-117.49305, 34.11641], [-117.49313, 34.11648], [-117.49322, 34.11658], [-117.49327, 34.11668], [-117.4933, 34.11678], [-117.4933, 34.11692], [-117.49327, 34.11701], [-117.49322, 34.11712], [-117.49313, 34.11722], [-117.49304, 34.11729], [-117.49292, 34.11736], [-117.4928, 34.11739], [-117.49267, 34.11741], [-117.49253, 34.11741], [-117.4923, 34.11734], [-117.49218, 34.11728], [-117.49209, 34.1172], [-117.49201, 34.1171], [-117.49197, 34.11701], [-117.49195, 34.11691], [-117.49195, 34.11678], [-117.49197, 34.11669], [-117.49202, 34.11659], [-117.49209, 34.1165], [-117.49219, 34.11642], [-117.49238, 34.11632], [-117.4925, 34.11629], [-117.49266, 34.11629]]]} Open Access 1 1717 Heritage Circle Park 19833 1109 Fontana, City of 168 City 2 City Agency 2 http://www.fontana.org/index.aspx?NID=551 City 2 1109 Fontana, City of 164 City 2 City Agency 2   San Bernardino 22 3.008 Heritage Circle Park 0 Local Park 2 4
482 482 481 {"type": "Polygon", "coordinates": [[[-117.37464, 34.10245], [-117.37387, 34.10245], [-117.37386, 34.10284], [-117.37293, 34.10284], [-117.37293, 34.10166], [-117.37464, 34.10166], [-117.37464, 34.10245]]]} Open Access 1 1930 Margaret Todd Park 21803 1273 Rialto, City of 106 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 1273 Rialto, City of 103 City 2 City Agency 2   San Bernardino 22 4.33 Margaret Todd Park 0 Local Park 2 4
495 495 494 {"type": "MultiPolygon", "coordinates": [[[[-117.24351, 34.03933], [-117.24235, 34.03893], [-117.2421, 34.03891], [-117.24212, 34.03856], [-117.24226, 34.03845], [-117.24235, 34.0376], [-117.24248, 34.03767], [-117.24256, 34.03791], [-117.24267, 34.03809], [-117.24307, 34.03844], [-117.2432, 34.03854], [-117.24351, 34.03871], [-117.24351, 34.03933]]], [[[-117.2458, 34.03942], [-117.24371, 34.03943], [-117.24371, 34.03778], [-117.2458, 34.03777], [-117.2458, 34.03942]]]]} Open Access 1 2006 Hulda Crooks Park 20142 1181 Loma Linda, City of 185 City 2 City Agency 2 http://www.lomalinda-ca.gov/ City 2 1181 Loma Linda, City of 181 City 2 City Agency 2   San Bernardino 22 11.671 Hulda Crooks 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]);