units_with_maps

Table actions

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

6 rows where DES_TP = 2, MNG_AGENCY = 318 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 6 ✖

MNG_AGENCY 1

  • Westlake Village, City of · 6 ✖

DES_TP 1

  • Local Park · 6 ✖

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
1117 1117 1116 {"type": "Polygon", "coordinates": [[[-118.8142, 34.14568], [-118.81406, 34.14569], [-118.81405, 34.14662], [-118.81274, 34.14662], [-118.81275, 34.14609], [-118.81279, 34.14583], [-118.81279, 34.14544], [-118.81276, 34.14532], [-118.81276, 34.14505], [-118.81406, 34.14506], [-118.81406, 34.14511], [-118.81404, 34.14512], [-118.81403, 34.14559], [-118.81419, 34.14559], [-118.8142, 34.14568]]]} Open Access 1 7104 Berniece Bennett Park 16031 1377 Westlake Village, City of 321 City 2 City Agency 2 http://www.wlv.org/index.aspx?nid=194 City 2 1377 Westlake Village, City of 318 City 2 City Agency 2   Los Angeles 6 5.128 Berniece Bennett Park 0 Local Park 2 4
1253 1253 1252 {"type": "Polygon", "coordinates": [[[-118.79537, 34.15242], [-118.79497, 34.15286], [-118.79441, 34.15335], [-118.79391, 34.15297], [-118.79391, 34.15293], [-118.79386, 34.15288], [-118.79379, 34.15286], [-118.79376, 34.15286], [-118.79359, 34.15274], [-118.79355, 34.15277], [-118.79327, 34.15256], [-118.79328, 34.1525], [-118.7939, 34.15196], [-118.79424, 34.15222], [-118.79482, 34.15185], [-118.79537, 34.15242]]]} Open Access 1 7100 Russell Ranch Park 24743 1377 Westlake Village, City of 321 City 2 City Agency 2 http://www.wlv.org/index.aspx?nid=194 City 2 1377 Westlake Village, City of 318 City 2 City Agency 2   Los Angeles 6 4.205 Russell Ranch Park 0 Local Park 2 4
1254 1254 1253 {"type": "Polygon", "coordinates": [[[-118.79338, 34.16493], [-118.79331, 34.16496], [-118.79273, 34.16504], [-118.7925, 34.16505], [-118.79222, 34.16501], [-118.7921, 34.16497], [-118.79177, 34.16483], [-118.79154, 34.16466], [-118.79143, 34.16454], [-118.79197, 34.16423], [-118.79206, 34.16433], [-118.79216, 34.1644], [-118.79235, 34.16448], [-118.79248, 34.16451], [-118.79273, 34.1645], [-118.79324, 34.16438], [-118.79327, 34.1644], [-118.79335, 34.16463], [-118.79338, 34.16493]]]} Open Access 1 7101 Canyon Oaks Park 16822 1377 Westlake Village, City of 321 City 2 City Agency 2 http://www.wlv.org/index.aspx?nid=194 City 2 1377 Westlake Village, City of 318 City 2 City Agency 2   Los Angeles 6 2.489 Canyon Oaks Park 0 Local Park 2 4
1255 1255 1254 {"type": "Polygon", "coordinates": [[[-118.83685, 34.13445], [-118.83636, 34.13472], [-118.83618, 34.13484], [-118.83602, 34.13497], [-118.83556, 34.13457], [-118.83442, 34.13387], [-118.83461, 34.13313], [-118.83489, 34.13312], [-118.83581, 34.13331], [-118.83628, 34.1336], [-118.83641, 34.13392], [-118.83685, 34.13445]]]} Open Access 1 7102 Three Springs Park 26334 1377 Westlake Village, City of 321 City 2 City Agency 2 http://www.wlv.org/index.aspx?nid=194 City 2 1377 Westlake Village, City of 318 City 2 City Agency 2   Los Angeles 6 6.208 Three Springs Park 0 Local Park 2 4
1691 1691 1690 {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80459, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.80331, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14431], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14253], [-118.8046, 34.14314], [-118.80376, 34.14324], [-118.80375, 34.14354], [-118.80397, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.14419], [-118.80576, 34.14426]]]} Open Access 1 12745 Westlake Village City Parkland 27404 1377 Westlake Village, City of 321 City 2 City Agency 2 http://www.wlv.org/index.aspx?nid=194 City 2 1377 Westlake Village, City of 318 City 2 City Agency 2   Los Angeles 6 24.679 Westlake Village City Parkland 2018 Local Park 2 4
7531 7531 7530 {"type": "Polygon", "coordinates": [[[-118.81947, 34.1388], [-118.81884, 34.13894], [-118.81893, 34.13921], [-118.81876, 34.13925], [-118.81839, 34.13851], [-118.81834, 34.13845], [-118.81827, 34.1384], [-118.81813, 34.13838], [-118.81806, 34.13839], [-118.81796, 34.13843], [-118.81782, 34.13844], [-118.81774, 34.13841], [-118.81762, 34.13841], [-118.81751, 34.13844], [-118.81733, 34.13856], [-118.81717, 34.13861], [-118.81698, 34.1386], [-118.81681, 34.13854], [-118.81671, 34.13854], [-118.81665, 34.13856], [-118.81655, 34.13865], [-118.8162, 34.13842], [-118.81601, 34.13821], [-118.81629, 34.13814], [-118.81671, 34.13813], [-118.81875, 34.13823], [-118.81896, 34.13828], [-118.81917, 34.13839], [-118.81927, 34.13847], [-118.81938, 34.13859], [-118.81945, 34.13871], [-118.81947, 34.1388]]]} Open Access 1 7106 Foxfield Park 19037 1377 Westlake Village, City of 321 City 2 City Agency 2 http://www.wlv.org/index.aspx?nid=194 City 2 1377 Westlake Village, City of 318 City 2 City Agency 2   Los Angeles 6 3.506 Foxfield Park 0 Local Park 2 4

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