units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, ACRES = "99.15" and MNG_AGENCY = 28

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 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
12495 12495 12494 {"type": "Polygon", "coordinates": [[[-122.52068, 37.57395], [-122.5207, 37.57409], [-122.52068, 37.57423], [-122.52049, 37.57446], [-122.52045, 37.5746], [-122.52045, 37.57474], [-122.52041, 37.57488], [-122.52041, 37.57516], [-122.52039, 37.57534], [-122.52036, 37.57543], [-122.52028, 37.57555], [-122.52011, 37.5756], [-122.51993, 37.57562], [-122.51977, 37.57568], [-122.51955, 37.57583], [-122.51938, 37.57596], [-122.51928, 37.57608], [-122.51913, 37.57616], [-122.51896, 37.57617], [-122.51879, 37.57615], [-122.51857, 37.57594], [-122.5184, 37.57591], [-122.51827, 37.576], [-122.51823, 37.57613], [-122.51813, 37.57625], [-122.51807, 37.57638], [-122.51807, 37.57665], [-122.51792, 37.57706], [-122.51791, 37.57719], [-122.51796, 37.57749], [-122.5179, 37.57762], [-122.51782, 37.57797], [-122.51776, 37.57816], [-122.5177, 37.57843], [-122.51745, 37.579], [-122.51746, 37.57938], [-122.51754, 37.57964], [-122.51755, 37.57985], [-122.51739, 37.58021], [-122.51736, 37.58083], [-122.51732, 37.58094], [-122.51717, 37.58118], [-122.51792, 37.58123], [-122.5179, 37.58134], [-122.51788, 37.58139], [-122.51781, 37.58143], [-122.51776, 37.58149], [-122.51763, 37.58155], [-122.51756, 37.58159], [-122.51742, 37.58163], [-122.51707, 37.58186], [-122.51697, 37.58198], [-122.5169, 37.58202], [-122.51679, 37.58224], [-122.51678, 37.5823], [-122.51679, 37.58252], [-122.51686, 37.58256], [-122.51689, 37.58262], [-122.51688, 37.58273], [-122.51683, 37.58286], [-122.51683, 37.58292], [-122.51681, 37.58309], [-122.51685, 37.58315], [-122.51683, 37.58321], [-122.51688, 37.58343], [-122.51699, 37.58362], [-122.51714, 37.58378], [-122.51722, 37.58394], [-122.51722, 37.58401], [-122.51732, 37.58413], [-122.51736, 37.58426], [-122.51738, 37.5845], [-122.51734, 37.58463], [-122.51735, 37.58474], [-122.51733, 37.58489], [-122.51728, 37.58502], [-122.51721, 37.58515], [-122.51649, 37.58524], [-122.51604, 37.58525], [-122.51123, 37.58564], [-122.51071, 37.58567], [-122.51024, 37.58562], [-122.50897, 37.58527], [-122.50853, 37.58519], [-122.50822, 37.58515], [-122.5083, 37.58473], [-122.50945, 37.58484], [-122.50993, 37.58514], [-122.5102, 37.58521], [-122.51044, 37.58524], [-122.51072, 37.58526], [-122.51099, 37.58498], [-122.51182, 37.5849], [-122.5124, 37.58521], [-122.51398, 37.58507], [-122.5145, 37.58471], [-122.51438, 37.58321], [-122.51384, 37.58307], [-122.51344, 37.58178], [-122.5137, 37.58153], [-122.51392, 37.58135], [-122.51579, 37.57957], [-122.51601, 37.57904], [-122.51579, 37.57652], [-122.51668, 37.57545], [-122.51754, 37.57485], [-122.51768, 37.57465], [-122.51773, 37.57453], [-122.51776, 37.57432], [-122.51774, 37.57417], [-122.5177, 37.57405], [-122.51761, 37.5739], [-122.51747, 37.57374], [-122.51676, 37.57321], [-122.51655, 37.57299], [-122.51597, 37.57218], [-122.51591, 37.57184], [-122.51591, 37.5715], [-122.51594, 37.5714], [-122.516, 37.57076], [-122.51611, 37.57074], [-122.51612, 37.57058], [-122.5161, 37.57038], [-122.51606, 37.57026], [-122.51596, 37.57005], [-122.5159, 37.56996], [-122.51539, 37.56936], [-122.51636, 37.56913], [-122.51627, 37.56923], [-122.5163, 37.56937], [-122.5164, 37.56949], [-122.51656, 37.56953], [-122.51691, 37.56956], [-122.51709, 37.56956], [-122.51724, 37.56962], [-122.51736, 37.56972], [-122.51737, 37.56986], [-122.51732, 37.57], [-122.51706, 37.57037], [-122.51696, 37.57048], [-122.51694, 37.57062], [-122.51689, 37.57075], [-122.51699, 37.57086], [-122.51713, 37.57095], [-122.51728, 37.57101], [-122.51762, 37.57096], [-122.51778, 37.57101], [-122.51793, 37.57094], [-122.51808, 37.57102], [-122.51824, 37.57107], [-122.51837, 37.57117], [-122.51845, 37.57129], [-122.51831, 37.57154], [-122.51804, 37.57171], [-122.51818, 37.57178], [-122.51825, 37.57191], [-122.5184, 37.57198], [-122.51851, 37.57209], [-122.51865, 37.57216], [-122.51874, 37.57228], [-122.51852, 37.5725], [-122.51835, 37.57253], [-122.51817, 37.57255], [-122.51771, 37.57273], [-122.51764, 37.57286], [-122.5178, 37.5731], [-122.51798, 37.57314], [-122.51813, 37.57321], [-122.5183, 37.57323], [-122.51845, 37.57316], [-122.51854, 37.57328], [-122.51856, 37.57342], [-122.51851, 37.57354], [-122.51852, 37.57356], [-122.51868, 37.57356], [-122.51876, 37.57344], [-122.51886, 37.57333], [-122.51902, 37.5734], [-122.51905, 37.57354], [-122.51898, 37.57365], [-122.51898, 37.57366], [-122.51913, 37.57371], [-122.51929, 37.57366], [-122.51938, 37.57354], [-122.51955, 37.57354], [-122.51971, 37.57361], [-122.51987, 37.57356], [-122.52004, 37.57357], [-122.5202, 37.57364], [-122.52025, 37.57377], [-122.52024, 37.57391], [-122.52057, 37.57384], [-122.52068, 37.57395]]]} Open Access 1 46890 Devil's Slide Trail 30387 324 San Mateo County Parks and Recreation Dept., County of 28 County 3 County Agency - Parks 7 http://www.co.sanmateo.ca.us/portal/site/parks/ County 3 324 San Mateo County Parks and Recreation Dept., County of 28 County 3 County Agency - Parks 7 http://parks.smcgov.org/devils-slide-trail San Mateo 15 99.15 Devil's Slide Trail 0 Local Recreation Area 3 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]);