units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 4, AGNCY_WEB = "http://www.co.monterey.ca.us/parks/" and MNG_AGENCY = 23

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Monterey, County of · 3 ✖

ACCESS_TYP 1

  • Unknown Access · 3 ✖
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
5339 5339 5338 {"type": "Polygon", "coordinates": [[[-121.76487, 36.22671], [-121.76455, 36.22693], [-121.76407, 36.227], [-121.76385, 36.22719], [-121.76369, 36.22707], [-121.76348, 36.22697], [-121.76368, 36.22607], [-121.76441, 36.22592], [-121.76478, 36.22637], [-121.76487, 36.22671]]]} Unknown Access 4 15853 First Growth 18915 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 2.843 First Growth   None 434  
9431 9431 9430 {"type": "Polygon", "coordinates": [[[-121.81231, 36.23946], [-121.8123, 36.24002], [-121.81077, 36.23999], [-121.81078, 36.23944], [-121.81113, 36.23944], [-121.81114, 36.23898], [-121.81198, 36.23899], [-121.81197, 36.23945], [-121.81231, 36.23946]]]} Unknown Access 4 15771 Falotico 18839 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 3.051 Falotico   None 778  
15772 15772 15771 {"type": "Polygon", "coordinates": [[[-121.75829, 36.65049], [-121.75826, 36.65096], [-121.75819, 36.65109], [-121.75816, 36.6512], [-121.75807, 36.65183], [-121.75806, 36.65201], [-121.75811, 36.65229], [-121.75831, 36.65285], [-121.75843, 36.65362], [-121.75848, 36.65401], [-121.75847, 36.65412], [-121.75819, 36.65486], [-121.75817, 36.65494], [-121.7579, 36.65558], [-121.75703, 36.65555], [-121.7571, 36.65542], [-121.75709, 36.6554], [-121.75624, 36.65543], [-121.74772, 36.65543], [-121.74657, 36.6554], [-121.74183, 36.65517], [-121.74167, 36.65507], [-121.74157, 36.65493], [-121.74153, 36.6547], [-121.74153, 36.65457], [-121.74156, 36.65448], [-121.74185, 36.65405], [-121.74188, 36.65398], [-121.74188, 36.65391], [-121.74182, 36.6538], [-121.74175, 36.65374], [-121.7415, 36.65361], [-121.74136, 36.65358], [-121.7414, 36.65302], [-121.74138, 36.65188], [-121.7413, 36.6513], [-121.74126, 36.65109], [-121.7412, 36.65089], [-121.74076, 36.651], [-121.73974, 36.65121], [-121.73931, 36.65132], [-121.73901, 36.65136], [-121.7388, 36.65134], [-121.73865, 36.65131], [-121.73791, 36.65105], [-121.73768, 36.65101], [-121.73745, 36.651], [-121.73629, 36.64792], [-121.73691, 36.64783], [-121.73739, 36.64771], [-121.73761, 36.64764], [-121.73829, 36.64735], [-121.73875, 36.64718], [-121.73943, 36.64698], [-121.73976, 36.64691], [-121.73998, 36.64689], [-121.74017, 36.6469], [-121.74104, 36.64702], [-121.74115, 36.64706], [-121.74168, 36.64713], [-121.74321, 36.64687], [-121.74484, 36.64683], [-121.74556, 36.64678], [-121.74671, 36.6468], [-121.74781, 36.64724], [-121.74861, 36.64695], [-121.74939, 36.64676], [-121.75021, 36.64666], [-121.75056, 36.64656], [-121.75106, 36.64636], [-121.75164, 36.64623], [-121.75172, 36.6462], [-121.75216, 36.64585], [-121.75221, 36.64584], [-121.75256, 36.64579], [-121.75285, 36.6457], [-121.75302, 36.64571], [-121.75319, 36.64569], [-121.75354, 36.64548], [-121.754, 36.64537], [-121.75433, 36.64539], [-121.75485, 36.64523], [-121.75516, 36.64547], [-121.75558, 36.64614], [-121.75605, 36.6466], [-121.7564, 36.64714], [-121.75641, 36.64714], [-121.75651, 36.64702], [-121.75654, 36.64705], [-121.75668, 36.64717], [-121.75683, 36.64733], [-121.75708, 36.64767], [-121.75727, 36.64819], [-121.75747, 36.64839], [-121.75753, 36.64849], [-121.75766, 36.64884], [-121.75789, 36.64906], [-121.75795, 36.64914], [-121.75795, 36.64921], [-121.75785, 36.64936], [-121.75786, 36.64948], [-121.75811, 36.64986], [-121.75814, 36.64996], [-121.75815, 36.6501], [-121.75825, 36.65034], [-121.75826, 36.65042], [-121.75829, 36.65049]]]} Unknown Access 4 15914 Fort Ord National Monument 19009 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 401.403 Fort Ord NM 2012 National Monument or Landmark 80 3

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