units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, DES_TP = 4 and LABEL_NAME = "River Wilderness Park"

This data as json, copyable, CSV (advanced)

DES_TP 1

  • Local Conservation Area · 2 ✖

ACCESS_TYP 1

  • Open Access · 2 ✖
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
3641 3641 3640 {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} Open Access 1 29516 River Wilderness Park 24431 1018 Azusa, City of 147 City 2 City Agency 2 http://www.ci.azusa.ca.us/index.aspx?NID=249 City 2 1018 Azusa, City of 143 City 2 City Agency 2   Los Angeles 6 1.847 River Wilderness Park 0 Local Conservation Area 4 2
12657 12657 12656 {"type": "MultiPolygon", "coordinates": [[[[-117.89687, 34.1626], [-117.89652, 34.16309], [-117.89636, 34.16321], [-117.89621, 34.16328], [-117.89607, 34.16332], [-117.89588, 34.16334], [-117.89572, 34.16332], [-117.89551, 34.16325], [-117.89533, 34.16313], [-117.89522, 34.163], [-117.89514, 34.16285], [-117.89501, 34.16266], [-117.89489, 34.16254], [-117.89472, 34.1624], [-117.89463, 34.1624], [-117.89436, 34.16223], [-117.89405, 34.16211], [-117.89319, 34.1619], [-117.89315, 34.16185], [-117.89312, 34.16172], [-117.89306, 34.16161], [-117.89294, 34.16146], [-117.8928, 34.16136], [-117.89233, 34.16111], [-117.89207, 34.16104], [-117.89153, 34.16095], [-117.89136, 34.16094], [-117.89105, 34.16098], [-117.89046, 34.16113], [-117.89029, 34.16111], [-117.89028, 34.16113], [-117.89005, 34.16112], [-117.89005, 34.15966], [-117.89127, 34.15925], [-117.89224, 34.15922], [-117.89264, 34.15949], [-117.89276, 34.15977], [-117.89324, 34.15995], [-117.89368, 34.16002], [-117.89387, 34.16008], [-117.89416, 34.1602], [-117.89441, 34.16033], [-117.89459, 34.16034], [-117.8961, 34.16015], [-117.8966, 34.15994], [-117.8966, 34.16153], [-117.89594, 34.16239], [-117.89645, 34.16255], [-117.89687, 34.1626]]], [[[-117.8957, 34.16384], [-117.89546, 34.1639], [-117.8952, 34.16394], [-117.89433, 34.16395], [-117.8932, 34.16241], [-117.89005, 34.16241], [-117.89005, 34.16128], [-117.89046, 34.16131], [-117.89059, 34.16129], [-117.89099, 34.16119], [-117.89118, 34.16117], [-117.89138, 34.16116], [-117.8917, 34.16119], [-117.89194, 34.16124], [-117.89227, 34.16133], [-117.89254, 34.16143], [-117.89292, 34.16192], [-117.89309, 34.16205], [-117.89327, 34.16213], [-117.89369, 34.16221], [-117.89394, 34.16229], [-117.89427, 34.16243], [-117.89453, 34.16259], [-117.8947, 34.16275], [-117.89484, 34.16291], [-117.89496, 34.16313], [-117.89504, 34.16336], [-117.89514, 34.16349], [-117.89526, 34.16359], [-117.89539, 34.16365], [-117.89552, 34.16376], [-117.8957, 34.16384]]], [[[-117.89267, 34.16401], [-117.89243, 34.16404], [-117.89223, 34.16412], [-117.89222, 34.16349], [-117.89233, 34.1637], [-117.89267, 34.16401]]], [[[-117.89812, 34.16211], [-117.89703, 34.16364], [-117.89674, 34.16391], [-117.89656, 34.16403], [-117.89638, 34.16413], [-117.89617, 34.16422], [-117.89596, 34.16429], [-117.89459, 34.16456], [-117.89305, 34.16475], [-117.89289, 34.16481], [-117.89224, 34.1651], [-117.89224, 34.16445], [-117.89235, 34.16437], [-117.8925, 34.16431], [-117.89269, 34.16428], [-117.89515, 34.16422], [-117.89538, 34.16419], [-117.89558, 34.16415], [-117.8958, 34.16408], [-117.89598, 34.164], [-117.89628, 34.16382], [-117.89656, 34.1636], [-117.89669, 34.16347], [-117.89685, 34.16327], [-117.89704, 34.1629], [-117.89727, 34.16258], [-117.89736, 34.16249], [-117.8975, 34.16238], [-117.8977, 34.16226], [-117.89788, 34.16211], [-117.89812, 34.16211]]], [[[-117.89881, 34.16211], [-117.8988, 34.16512], [-117.89253, 34.16513], [-117.89299, 34.16492], [-117.89312, 34.16488], [-117.89462, 34.1647], [-117.89601, 34.16442], [-117.89642, 34.16427], [-117.89667, 34.16413], [-117.89686, 34.164], [-117.89703, 34.16386], [-117.89719, 34.16369], [-117.89831, 34.16211], [-117.89881, 34.16211]]]]} Open Access 1 29515 River Wilderness Park 24432 2177 Watershed Conservation Authority 860 Special District 4 Conservation District 31 https://www.wca.ca.gov/ Special District 4 2177 Watershed Conservation Authority 838 Special District 4 Conservation District 30   Los Angeles 6 70.516 River Wilderness Park 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]);