superunits_with_maps

Table actions

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

1 row where MNG_AG_LEV = 3, MNG_AG_TYP = 3 and PARK_URL = "http://www.sdparks.org/content/sdparks/en/park-pages/GoodanSycamore.html"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 1 ✖

MNG_AGENCY 1

ACCESS_TYP 1

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
12251 12251 12250 {"type": "MultiPolygon", "coordinates": [[[[-116.98966, 32.91956], [-116.98937, 32.91957], [-116.9895, 32.9339], [-116.98365, 32.93398], [-116.98356, 32.9343], [-116.98402, 32.93561], [-116.98442, 32.93603], [-116.98441, 32.93658], [-116.98424, 32.93807], [-116.98354, 32.93871], [-116.98159, 32.94012], [-116.98109, 32.94034], [-116.98049, 32.93979], [-116.98034, 32.93986], [-116.98058, 32.9412], [-116.97817, 32.94117], [-116.97813, 32.943], [-116.97815, 32.943], [-116.97847, 32.94277], [-116.97891, 32.9428], [-116.97894, 32.94363], [-116.97912, 32.94418], [-116.9781, 32.9459], [-116.97938, 32.9459], [-116.98105, 32.94585], [-116.98105, 32.94859], [-116.97935, 32.94853], [-116.97058, 32.94833], [-116.97082, 32.94447], [-116.97098, 32.94105], [-116.96183, 32.94088], [-116.96174, 32.93344], [-116.95747, 32.93346], [-116.95777, 32.92622], [-116.96202, 32.92623], [-116.96229, 32.91927], [-116.96218, 32.91552], [-116.95771, 32.9155], [-116.95773, 32.9085], [-116.96197, 32.90851], [-116.96182, 32.9035], [-116.97162, 32.90168], [-116.97156, 32.91577], [-116.9809, 32.91574], [-116.98072, 32.90852], [-116.98502, 32.90855], [-116.98502, 32.90763], [-116.98936, 32.90765], [-116.98938, 32.90859], [-116.98505, 32.90856], [-116.98507, 32.9103], [-116.98943, 32.91034], [-116.98966, 32.91956]]], [[[-116.96655, 32.94369], [-116.9663, 32.94401], [-116.96603, 32.94429], [-116.96578, 32.9445], [-116.96516, 32.94497], [-116.96477, 32.94521], [-116.96302, 32.94614], [-116.96296, 32.94615], [-116.96292, 32.94612], [-116.96269, 32.94583], [-116.96241, 32.94553], [-116.96213, 32.94526], [-116.96188, 32.94506], [-116.96186, 32.94452], [-116.96109, 32.94453], [-116.96052, 32.94424], [-116.959, 32.94362], [-116.95841, 32.94333], [-116.95808, 32.94313], [-116.95775, 32.94291], [-116.95774, 32.94223], [-116.96099, 32.94226], [-116.96099, 32.94127], [-116.96649, 32.9413], [-116.96655, 32.94369]]], [[[-116.9654, 32.94517], [-116.96539, 32.94575], [-116.96341, 32.94681], [-116.96315, 32.94645], [-116.96315, 32.94639], [-116.96318, 32.94636], [-116.965, 32.94542], [-116.9654, 32.94517]]], [[[-116.98432, 32.90496], [-116.98062, 32.90494], [-116.98042, 32.90307], [-116.9843, 32.90304], [-116.98432, 32.90496]]], [[[-116.98934, 32.90675], [-116.98501, 32.90674], [-116.98498, 32.90496], [-116.98929, 32.90498], [-116.98934, 32.90675]]]]} Open Access 1 Goodan Ranch Sycamore Canyon Preserve http://www.sdparks.org/content/sdparks/en/park-pages/GoodanSycamore.html 29238 319 San Diego, County of 101 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 2572.264 Goodan Ranch Sycamore Canyon Preserve  

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