superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Crest Canyon OS Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • Open Access · 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
14808 14808 14807 {"type": "Polygon", "coordinates": [[[-117.25592, 32.96027], [-117.25576, 32.9603], [-117.25577, 32.96295], [-117.25489, 32.96275], [-117.25425, 32.96275], [-117.25333, 32.96216], [-117.25287, 32.96092], [-117.25164, 32.96178], [-117.25163, 32.96119], [-117.25162, 32.96118], [-117.25161, 32.96234], [-117.25139, 32.96235], [-117.25131, 32.96232], [-117.25119, 32.96223], [-117.25095, 32.96179], [-117.25092, 32.96169], [-117.25091, 32.96152], [-117.25085, 32.96138], [-117.25076, 32.96128], [-117.25065, 32.96121], [-117.25076, 32.96024], [-117.24625, 32.9602], [-117.2462, 32.96005], [-117.24656, 32.95929], [-117.24669, 32.95799], [-117.24705, 32.95769], [-117.2471, 32.95771], [-117.24716, 32.95772], [-117.24723, 32.9577], [-117.24727, 32.95767], [-117.24735, 32.95787], [-117.2476, 32.95788], [-117.24788, 32.95773], [-117.24802, 32.95789], [-117.24817, 32.95803], [-117.24824, 32.95828], [-117.24825, 32.95854], [-117.24831, 32.95865], [-117.24859, 32.95866], [-117.24894, 32.9585], [-117.24919, 32.95857], [-117.24955, 32.95861], [-117.25082, 32.95863], [-117.25122, 32.95872], [-117.2515, 32.95886], [-117.25163, 32.95889], [-117.25203, 32.95868], [-117.25234, 32.95853], [-117.25246, 32.95831], [-117.25221, 32.95788], [-117.25222, 32.95667], [-117.25299, 32.95667], [-117.25299, 32.95648], [-117.25286, 32.95552], [-117.25357, 32.95479], [-117.25301, 32.95432], [-117.25301, 32.95292], [-117.25324, 32.95291], [-117.25327, 32.95232], [-117.25337, 32.95174], [-117.25392, 32.95174], [-117.25523, 32.9504], [-117.25589, 32.952], [-117.25589, 32.95368], [-117.25589, 32.9537], [-117.25586, 32.95371], [-117.25582, 32.95416], [-117.25588, 32.95418], [-117.25587, 32.95665], [-117.25589, 32.95807], [-117.25569, 32.95801], [-117.25561, 32.958], [-117.2555, 32.95802], [-117.25542, 32.95809], [-117.2555, 32.95898], [-117.25549, 32.95946], [-117.2557, 32.95996], [-117.25592, 32.96027]]]} Open Access 1 Crest Canyon Open Space Park   17800 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 120.267 Crest Canyon OS Park  

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