superunits_with_maps

Table actions

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

2 rows where MNG_AGENCY = 713 and MNG_AG_LEV = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles Department of Public Works, County of · 2 ✖

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
1109 1109 1108 {"type": "Polygon", "coordinates": [[[-118.20389, 33.83208], [-118.20324, 33.83744], [-118.20316, 33.83872], [-118.20316, 33.83916], [-118.20311, 33.8393], [-118.20288, 33.84212], [-118.20281, 33.84232], [-118.20272, 33.84362], [-118.20264, 33.84403], [-118.20264, 33.84624], [-118.20261, 33.84653], [-118.20155, 33.84653], [-118.20155, 33.84626], [-118.20186, 33.84297], [-118.20215, 33.83915], [-118.20219, 33.83906], [-118.2025, 33.83476], [-118.2025, 33.83437], [-118.20269, 33.83211], [-118.20269, 33.83186], [-118.20277, 33.83167], [-118.20294, 33.83065], [-118.20296, 33.83039], [-118.20389, 33.83208]]]} Open Access 1 Dominguez Gap Wetlands   32867 375 Los Angeles Department of Public Works, County of 713 County 3 County Agency - Other 8 http://dpw.lacounty.gov/ County 3 39.282 Dominguez Gap Wetlands 2008
12743 12743 12742 {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09109, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.79589], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.80441], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]], [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]]} Open Access 1 San Gabriel River Trail   29917 375 Los Angeles Department of Public Works, County of 713 County 3 County Agency - Other 8 http://dpw.lacounty.gov/ County 3 41.912 San Gabriel River Trail  

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