superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 16 and PARK_URL = "http://www.parks.ca.gov/?page_id=835"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles, County of · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
6550 6550 6549 {"type": "MultiPolygon", "coordinates": [[[[-118.67646, 34.03707], [-118.67629, 34.03715], [-118.67638, 34.03729], [-118.67622, 34.03728], [-118.6754, 34.0376], [-118.67481, 34.0378], [-118.67474, 34.03767], [-118.67555, 34.03741], [-118.6763, 34.03706], [-118.67642, 34.03702], [-118.67646, 34.03707]]], [[[-118.68069, 34.03475], [-118.68034, 34.03486], [-118.67997, 34.03502], [-118.67962, 34.0352], [-118.6793, 34.03539], [-118.67884, 34.03574], [-118.67771, 34.0367], [-118.67744, 34.03647], [-118.67726, 34.03661], [-118.67677, 34.03691], [-118.67665, 34.03693], [-118.67654, 34.03698], [-118.67647, 34.03688], [-118.67663, 34.03681], [-118.67677, 34.03672], [-118.67699, 34.03656], [-118.67734, 34.03625], [-118.6779, 34.03553], [-118.67822, 34.03495], [-118.67858, 34.0341], [-118.67889, 34.03394], [-118.67915, 34.03376], [-118.67926, 34.03353], [-118.67958, 34.03389], [-118.67912, 34.03417], [-118.67883, 34.03473], [-118.67917, 34.03516], [-118.67947, 34.03501], [-118.67978, 34.03488], [-118.67983, 34.03492], [-118.6801, 34.03483], [-118.68027, 34.0348], [-118.68066, 34.03468], [-118.68069, 34.03475]]], [[[-118.68268, 34.03131], [-118.682, 34.03166], [-118.68189, 34.0319], [-118.68113, 34.03114], [-118.68152, 34.03111], [-118.68266, 34.03076], [-118.68268, 34.03131]]]]} Open Access 1 Malibu Lagoon State Beach http://www.parks.ca.gov/?page_id=835 21710 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 9.808 Malibu Lagoon SB 1951

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