units_with_maps

Table actions

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

1 row where LABEL_NAME = "Sycamore Canyon OS" and MNG_AGENCY = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Diego, City of · 1 ✖

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
15982 15982 15981 {"type": "Polygon", "coordinates": [[[-117.0175, 32.93461], [-117.01661, 32.93524], [-117.01593, 32.93601], [-117.01482, 32.93714], [-117.01291, 32.93726], [-117.01246, 32.93879], [-117.01046, 32.94042], [-117.01047, 32.94045], [-117.01043, 32.94106], [-117.00988, 32.94128], [-117.00943, 32.94128], [-117.00852, 32.94152], [-117.00802, 32.94204], [-117.00245, 32.94396], [-117.00152, 32.94443], [-117.00145, 32.94445], [-116.99968, 32.94358], [-116.99946, 32.94345], [-116.99672, 32.94117], [-116.99658, 32.9411], [-116.99641, 32.94106], [-116.99629, 32.94105], [-116.9951, 32.94118], [-116.99422, 32.94116], [-116.99405, 32.94117], [-116.99386, 32.94121], [-116.99279, 32.9416], [-116.99262, 32.94171], [-116.99205, 32.94221], [-116.99184, 32.94231], [-116.9916, 32.94237], [-116.99137, 32.94239], [-116.99125, 32.94238], [-116.99076, 32.94233], [-116.99076, 32.94243], [-116.9903, 32.94238], [-116.98828, 32.94257], [-116.98707, 32.94283], [-116.98565, 32.94286], [-116.98527, 32.94284], [-116.98493, 32.94279], [-116.98446, 32.94268], [-116.98345, 32.94253], [-116.98208, 32.94262], [-116.98199, 32.94262], [-116.98078, 32.9421], [-116.98075, 32.94212], [-116.98032, 32.93986], [-116.98048, 32.93978], [-116.98109, 32.94034], [-116.98159, 32.94012], [-116.98354, 32.93871], [-116.98424, 32.93807], [-116.98441, 32.93658], [-116.98442, 32.93604], [-116.98403, 32.93561], [-116.98356, 32.9343], [-116.98363, 32.93403], [-116.9895, 32.93403], [-116.98937, 32.91955], [-116.99056, 32.91958], [-116.99768, 32.91928], [-116.99807, 32.91935], [-117.0124, 32.91959], [-117.01119, 32.92107], [-117.00748, 32.92448], [-117.00707, 32.92542], [-117.00736, 32.92672], [-117.00645, 32.92984], [-117.00694, 32.92996], [-117.00769, 32.93041], [-117.00803, 32.93069], [-117.00809, 32.93102], [-117.00837, 32.93133], [-117.0092, 32.93179], [-117.00955, 32.93191], [-117.01011, 32.93233], [-117.01037, 32.93244], [-117.01052, 32.93265], [-117.0106, 32.93284], [-117.0108, 32.93306], [-117.01116, 32.93322], [-117.01157, 32.93342], [-117.01172, 32.93371], [-117.01176, 32.93396], [-117.01186, 32.93407], [-117.01224, 32.93429], [-117.01247, 32.93448], [-117.01272, 32.93527], [-117.01306, 32.93561], [-117.01307, 32.93561], [-117.01319, 32.93516], [-117.01319, 32.93497], [-117.01339, 32.93481], [-117.01347, 32.93481], [-117.01366, 32.93476], [-117.01386, 32.93489], [-117.01418, 32.935], [-117.01441, 32.93479], [-117.01507, 32.93487], [-117.0153, 32.93482], [-117.01555, 32.93453], [-117.01572, 32.93439], [-117.01587, 32.9345], [-117.01637, 32.93459], [-117.01654, 32.93466], [-117.01714, 32.9347], [-117.0175, 32.93461]], [[-117.00331, 32.92925], [-117.00318, 32.92919], [-117.00306, 32.9292], [-117.00303, 32.92925], [-117.00302, 32.9293], [-117.00307, 32.92938], [-117.00314, 32.9294], [-117.00319, 32.9294], [-117.00324, 32.92939], [-117.00329, 32.92934], [-117.00331, 32.9293], [-117.00331, 32.92925]]]} Open Access 1 46804 Sycamore Canyon Open Space 30259 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 1371.936 Sycamore Canyon OS 0 Local Recreation Area 3 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]);