units_with_maps

Table actions

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

4 rows where AGNCY_LEV = 2, AGNCY_NAME = 24 and DES_TP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Conservation Area · 4 ✖

ACCESS_TYP 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
1048 1048 1047 {"type": "Polygon", "coordinates": [[[-118.51707, 34.12476], [-118.51169, 34.12287], [-118.50522, 34.11808], [-118.50208, 34.11085], [-118.50114, 34.10951], [-118.50141, 34.10932], [-118.50238, 34.11073], [-118.5055, 34.11792], [-118.50867, 34.12028], [-118.50994, 34.11967], [-118.51004, 34.12128], [-118.51187, 34.12264], [-118.51704, 34.12445], [-118.51707, 34.12476]]]} Open Access 1 6371 Westridge-Canyonback Wilderness Park of LA 27417 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 20.346 Westridge-Canyonback Wilderness Park of LA 0 Local Conservation Area 4 2
3058 3058 3057 {"type": "Polygon", "coordinates": [[[-118.34268, 34.26987], [-118.34212, 34.26999], [-118.34206, 34.26981], [-118.34091, 34.26925], [-118.33938, 34.26836], [-118.33771, 34.26708], [-118.33809, 34.26706], [-118.33825, 34.26717], [-118.33934, 34.26732], [-118.33933, 34.26743], [-118.34229, 34.26782], [-118.34195, 34.26956], [-118.34268, 34.26987]]]} Open Access 1 12696 Tujunga Ponds Wildlife Sanctuary 26562 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 12.885 Tujunga Ponds Wildlife Sanctuary 0 Local Conservation Area 4 2
7010 7010 7009 {"type": "Polygon", "coordinates": [[[-118.31996, 33.71882], [-118.31992, 33.71892], [-118.31987, 33.71898], [-118.31931, 33.71943], [-118.31914, 33.71952], [-118.31826, 33.71986], [-118.31801, 33.71998], [-118.31765, 33.72021], [-118.31693, 33.72077], [-118.3164, 33.7211], [-118.31544, 33.72053], [-118.3148, 33.72061], [-118.31405, 33.72094], [-118.31274, 33.72104], [-118.3129, 33.72084], [-118.31202, 33.71937], [-118.31156, 33.71925], [-118.31157, 33.71814], [-118.31151, 33.71788], [-118.31141, 33.71763], [-118.31133, 33.7175], [-118.31115, 33.71727], [-118.31097, 33.71709], [-118.31084, 33.71699], [-118.31054, 33.71683], [-118.31, 33.71662], [-118.31115, 33.71474], [-118.31773, 33.71644], [-118.31775, 33.71647], [-118.31794, 33.71655], [-118.31807, 33.71666], [-118.31897, 33.71778], [-118.31913, 33.71793], [-118.31938, 33.71815], [-118.31973, 33.71838], [-118.31958, 33.71856], [-118.31996, 33.71882]]]} Open Access 1 5947 White Point Nature Preserve 27463 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 95.019 White Point Nature Preserve 0 Local Conservation Area 4 2
7174 7174 7173 {"type": "Polygon", "coordinates": [[[-118.46153, 33.97503], [-118.46151, 33.97515], [-118.46145, 33.97532], [-118.4613, 33.97553], [-118.46123, 33.97559], [-118.46107, 33.97571], [-118.46039, 33.97608], [-118.45986, 33.97557], [-118.46056, 33.97514], [-118.46066, 33.97505], [-118.46076, 33.9749], [-118.4608, 33.97475], [-118.46078, 33.97459], [-118.46074, 33.97448], [-118.45889, 33.97201], [-118.45771, 33.97025], [-118.45651, 33.969], [-118.45648, 33.969], [-118.45458, 33.96645], [-118.45481, 33.96634], [-118.45481, 33.96632], [-118.45505, 33.9662], [-118.45681, 33.96886], [-118.45712, 33.96873], [-118.45717, 33.96881], [-118.45702, 33.96889], [-118.45708, 33.96897], [-118.45727, 33.96889], [-118.45758, 33.96936], [-118.45745, 33.96943], [-118.4575, 33.96952], [-118.45759, 33.96948], [-118.45794, 33.96993], [-118.45787, 33.96998], [-118.45787, 33.96999], [-118.45794, 33.97007], [-118.45801, 33.97002], [-118.45837, 33.97047], [-118.45829, 33.97051], [-118.45829, 33.97053], [-118.45836, 33.9706], [-118.45843, 33.97057], [-118.45879, 33.97101], [-118.45871, 33.97106], [-118.45871, 33.97107], [-118.45878, 33.97115], [-118.45885, 33.97111], [-118.45921, 33.97156], [-118.45913, 33.97159], [-118.45913, 33.97161], [-118.4592, 33.97169], [-118.45928, 33.97165], [-118.45963, 33.9721], [-118.45955, 33.97214], [-118.45955, 33.97215], [-118.45962, 33.97223], [-118.4597, 33.9722], [-118.46005, 33.97264], [-118.45997, 33.97268], [-118.45997, 33.9727], [-118.46004, 33.97277], [-118.46013, 33.97273], [-118.46047, 33.97319], [-118.4604, 33.97323], [-118.46045, 33.97331], [-118.46055, 33.97328], [-118.46093, 33.97378], [-118.46086, 33.97382], [-118.46086, 33.97383], [-118.46092, 33.97391], [-118.461, 33.97387], [-118.46135, 33.97431], [-118.46128, 33.97437], [-118.4614, 33.97453], [-118.46148, 33.97468], [-118.46153, 33.97487], [-118.46153, 33.97503]]]} Open Access 1 6319 Ballona Lagoon Marine Preserve 15788 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ Los Angeles 6 16.006 Ballona Lagoon Marine Preserve 0 Local Conservation Area 4 2

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