units_with_maps

Table actions

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

5 rows where AGNCY_ID = 309 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 5 ✖

ACCESS_TYP 1

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
2617 2617 2616 {"type": "Polygon", "coordinates": [[[-119.08056, 37.77893], [-119.08015, 37.77893], [-119.08014, 37.77847], [-119.08056, 37.77847], [-119.08056, 37.77893]]]} Open Access 1 20758 Gull Lake Park 19565 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3   Mono 32 0.46 Gull Lake Park 0 Local Park 2 4
3005 3005 3004 {"type": "Polygon", "coordinates": [[[-119.23087, 38.25634], [-119.23087, 38.25734], [-119.22976, 38.25733], [-119.22976, 38.25693], [-119.22956, 38.25692], [-119.22955, 38.25733], [-119.2293, 38.25733], [-119.22918, 38.25664], [-119.23039, 38.25651], [-119.2304, 38.25634], [-119.23087, 38.25634]]]} Open Access 1 20746 Bridgeport Park 16379 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3   Mono 32 3.04 Bridgeport Park 0 Local Park 2 4
3008 3008 3007 {"type": "Polygon", "coordinates": [[[-118.47965, 37.81962], [-118.47816, 37.81962], [-118.47799, 37.81836], [-118.47927, 37.81839], [-118.47928, 37.81904], [-118.47965, 37.81904], [-118.47965, 37.81962]]]} Open Access 1 20760 Ida Lynn Parkinson Park 20172 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3   Mono 32 4.112 Ida Lynn Parkinson Park 0 Local Park 2 4
3200 3200 3199 {"type": "Polygon", "coordinates": [[[-119.481, 38.51311], [-119.48038, 38.51423], [-119.47906, 38.51378], [-119.47937, 38.51311], [-119.481, 38.51311]]]} Open Access 1 22167 Walker Community Park 27216 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3   Mono 32 3.404 Walker Community Park 0 Local Park 2 4
11365 11365 11364 {"type": "MultiPolygon", "coordinates": [[[[-119.16832, 38.0706], [-119.16636, 38.07249], [-119.15922, 38.07252], [-119.15476, 38.0725], [-119.15483, 38.06891], [-119.15251, 38.0689], [-119.15263, 38.06163], [-119.15029, 38.06162], [-119.15033, 38.05992], [-119.14571, 38.05989], [-119.14584, 38.05813], [-119.14633, 38.05813], [-119.14622, 38.05823], [-119.14651, 38.05845], [-119.14666, 38.05834], [-119.14678, 38.05841], [-119.14691, 38.05847], [-119.147, 38.05834], [-119.14676, 38.0582], [-119.14666, 38.0581], [-119.14653, 38.05787], [-119.1465, 38.05773], [-119.14652, 38.05558], [-119.14659, 38.05531], [-119.14679, 38.05508], [-119.14685, 38.05508], [-119.14735, 38.05615], [-119.14751, 38.05641], [-119.14779, 38.05677], [-119.14778, 38.05681], [-119.14767, 38.05688], [-119.14752, 38.05702], [-119.14741, 38.05717], [-119.14734, 38.05736], [-119.14731, 38.0575], [-119.14733, 38.05756], [-119.14737, 38.05759], [-119.14748, 38.05762], [-119.14754, 38.05761], [-119.1476, 38.05757], [-119.14764, 38.05749], [-119.14763, 38.05745], [-119.14759, 38.0574], [-119.14754, 38.05738], [-119.14759, 38.05726], [-119.14772, 38.05708], [-119.14789, 38.05695], [-119.14794, 38.05694], [-119.14852, 38.05738], [-119.14881, 38.05756], [-119.14921, 38.05775], [-119.1496, 38.0579], [-119.14993, 38.058], [-119.15042, 38.058], [-119.15042, 38.05793], [-119.15006, 38.05786], [-119.14977, 38.05778], [-119.14951, 38.05769], [-119.14949, 38.05765], [-119.14983, 38.0571], [-119.14989, 38.05691], [-119.14991, 38.0568], [-119.14991, 38.05659], [-119.14987, 38.05639], [-119.14974, 38.05614], [-119.14962, 38.05598], [-119.14962, 38.05596], [-119.14978, 38.05583], [-119.14994, 38.05578], [-119.15, 38.05574], [-119.15003, 38.05569], [-119.15004, 38.05564], [-119.15, 38.05556], [-119.14991, 38.05552], [-119.14983, 38.05552], [-119.14976, 38.05554], [-119.14972, 38.05558], [-119.14967, 38.05567], [-119.14964, 38.05571], [-119.14946, 38.05582], [-119.14899, 38.05561], [-119.14876, 38.05555], [-119.14853, 38.05552], [-119.14834, 38.05552], [-119.14804, 38.05555], [-119.14782, 38.05561], [-119.14744, 38.05574], [-119.14739, 38.05574], [-119.14736, 38.05572], [-119.14701, 38.05495], [-119.14723, 38.05487], [-119.14745, 38.05484], [-119.15046, 38.05484], [-119.15045, 38.05468], [-119.14976, 38.05468], [-119.14976, 38.05435], [-119.15961, 38.05435], [-119.15952, 38.058], [-119.16592, 38.05802], [-119.1679, 38.06431], [-119.1678, 38.06439], [-119.16782, 38.06444], [-119.16795, 38.06447], [-119.16842, 38.06598], [-119.16832, 38.0706]]], [[[-119.1463, 38.05698], [-119.14585, 38.05698], [-119.14587, 38.05481], [-119.14624, 38.05452], [-119.14626, 38.05452], [-119.14659, 38.05477], [-119.14669, 38.05489], [-119.14649, 38.05511], [-119.14643, 38.0552], [-119.14638, 38.05529], [-119.14632, 38.05548], [-119.1463, 38.05698]]], [[[-119.14907, 38.05435], [-119.14907, 38.05468], [-119.14733, 38.05468], [-119.14733, 38.05435], [-119.14907, 38.05435]]], [[[-119.14945, 38.0561], [-119.14957, 38.05624], [-119.14964, 38.05638], [-119.14969, 38.05651], [-119.14971, 38.05664], [-119.1497, 38.05678], [-119.14968, 38.05691], [-119.14963, 38.05704], [-119.14956, 38.05717], [-119.14931, 38.05756], [-119.14925, 38.05758], [-119.14901, 38.05746], [-119.14869, 38.05728], [-119.14848, 38.05714], [-119.14819, 38.05689], [-119.14801, 38.05672], [-119.14777, 38.05644], [-119.14758, 38.05616], [-119.14747, 38.05594], [-119.1475, 38.0559], [-119.14792, 38.05575], [-119.14811, 38.05571], [-119.14834, 38.05568], [-119.1486, 38.05569], [-119.14877, 38.05572], [-119.14893, 38.05577], [-119.1491, 38.05584], [-119.14926, 38.05594], [-119.14926, 38.05597], [-119.14913, 38.05607], [-119.14909, 38.05609], [-119.14902, 38.0561], [-119.14896, 38.05612], [-119.14891, 38.05616], [-119.14889, 38.05622], [-119.14889, 38.05626], [-119.14892, 38.05632], [-119.14896, 38.05635], [-119.14906, 38.05638], [-119.14915, 38.05636], [-119.1492, 38.05632], [-119.14923, 38.05628], [-119.14924, 38.05623], [-119.14928, 38.05619], [-119.1494, 38.0561], [-119.14945, 38.0561]]], [[[-119.16861, 38.05803], [-119.16853, 38.06167], [-119.16847, 38.06376], [-119.16685, 38.05859], [-119.16695, 38.05851], [-119.16694, 38.05846], [-119.1668, 38.05843], [-119.16667, 38.05802], [-119.16861, 38.05803]]], [[[-119.17772, 38.05081], [-119.16862, 38.05077], [-119.16845, 38.04352], [-119.17302, 38.04354], [-119.17759, 38.04363], [-119.17772, 38.05081]]]]} Open Access 1 22164 Conway Ranch 6766 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3 http://www.monocounty.org/static/index.cfm?contentID=828 Mono 32 825.845 Conway Ranch 0 Local Park 2 4

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]);