units_with_maps

Table actions

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

2 rows where DES_TP = 3, LABEL_NAME = "Torrey Highlands OS" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 2 ✖

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
15994 15994 15993 {"type": "Polygon", "coordinates": [[[-117.16556, 32.97451], [-117.16556, 32.97866], [-117.16552, 32.98475], [-117.16546, 32.98475], [-117.16541, 32.98473], [-117.1654, 32.9847], [-117.16542, 32.9821], [-117.16532, 32.98209], [-117.16514, 32.98174], [-117.16518, 32.98138], [-117.16514, 32.9809], [-117.16506, 32.98077], [-117.16491, 32.98058], [-117.16551, 32.98008], [-117.16548, 32.97961], [-117.16516, 32.97967], [-117.16508, 32.97979], [-117.16475, 32.98], [-117.16438, 32.98015], [-117.16375, 32.98012], [-117.16375, 32.98036], [-117.16396, 32.98045], [-117.16429, 32.98083], [-117.16439, 32.98088], [-117.16465, 32.98076], [-117.16496, 32.98097], [-117.16498, 32.98137], [-117.16494, 32.98177], [-117.16499, 32.98186], [-117.16487, 32.98195], [-117.16501, 32.98209], [-117.16466, 32.9821], [-117.16435, 32.9825], [-117.16448, 32.98258], [-117.16432, 32.98287], [-117.16419, 32.98317], [-117.1641, 32.98354], [-117.16402, 32.98406], [-117.16377, 32.98397], [-117.16375, 32.984], [-117.16401, 32.98413], [-117.16399, 32.98434], [-117.16396, 32.98443], [-117.16389, 32.98457], [-117.16381, 32.98468], [-117.16365, 32.98481], [-117.16288, 32.98524], [-117.16278, 32.98512], [-117.1627, 32.9851], [-117.16244, 32.98556], [-117.16245, 32.98569], [-117.16197, 32.98572], [-117.16183, 32.9857], [-117.16218, 32.98523], [-117.16288, 32.98474], [-117.16306, 32.98465], [-117.16322, 32.98453], [-117.16341, 32.98424], [-117.16351, 32.98391], [-117.16353, 32.98378], [-117.16347, 32.98362], [-117.16328, 32.98321], [-117.16372, 32.9829], [-117.16409, 32.98247], [-117.16432, 32.98201], [-117.16453, 32.98185], [-117.16464, 32.98161], [-117.16465, 32.9812], [-117.16457, 32.9811], [-117.16478, 32.98101], [-117.16478, 32.98099], [-117.16475, 32.98096], [-117.16454, 32.98106], [-117.16445, 32.98094], [-117.16417, 32.9808], [-117.16355, 32.98085], [-117.16333, 32.98094], [-117.16323, 32.98132], [-117.16285, 32.98129], [-117.16141, 32.98173], [-117.16138, 32.98169], [-117.16082, 32.98166], [-117.16049, 32.98175], [-117.16, 32.98192], [-117.15945, 32.9813], [-117.15916, 32.98109], [-117.15937, 32.98087], [-117.1596, 32.98037], [-117.16, 32.9804], [-117.16031, 32.98029], [-117.16054, 32.98012], [-117.16114, 32.9798], [-117.16182, 32.97945], [-117.16197, 32.97887], [-117.16174, 32.9786], [-117.16148, 32.97846], [-117.16121, 32.97836], [-117.16104, 32.97818], [-117.16138, 32.97809], [-117.16138, 32.97804], [-117.16094, 32.97796], [-117.16097, 32.9779], [-117.16125, 32.97768], [-117.16141, 32.97766], [-117.16141, 32.97753], [-117.16342, 32.9775], [-117.16351, 32.97712], [-117.16332, 32.97654], [-117.16228, 32.97606], [-117.16171, 32.97586], [-117.16066, 32.9759], [-117.16012, 32.97608], [-117.15985, 32.97635], [-117.15962, 32.97639], [-117.15915, 32.97601], [-117.159, 32.97596], [-117.15836, 32.97618], [-117.15828, 32.97654], [-117.15802, 32.97661], [-117.15787, 32.97643], [-117.15709, 32.97633], [-117.15522, 32.97674], [-117.15479, 32.97712], [-117.15468, 32.97706], [-117.15456, 32.97698], [-117.15446, 32.97688], [-117.15438, 32.97676], [-117.15409, 32.97588], [-117.15413, 32.97567], [-117.15447, 32.97565], [-117.15487, 32.97543], [-117.15617, 32.97516], [-117.15718, 32.97467], [-117.15775, 32.97417], [-117.15853, 32.97386], [-117.15901, 32.97417], [-117.15957, 32.9746], [-117.16025, 32.97458], [-117.16133, 32.97423], [-117.16189, 32.9742], [-117.16242, 32.97401], [-117.16302, 32.97374], [-117.16322, 32.97339], [-117.16342, 32.97324], [-117.16395, 32.97391], [-117.1645, 32.97406], [-117.16499, 32.97412], [-117.16556, 32.97451]]]} Open Access 1 930 Torrey Highlands Open Space 10619 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 113.331 Torrey Highlands OS 0 Local Recreation Area 3 4
16010 16010 16009 {"type": "Polygon", "coordinates": [[[-117.15282, 32.96061], [-117.15281, 32.96064], [-117.15278, 32.96063], [-117.15275, 32.96076], [-117.15258, 32.96073], [-117.15252, 32.96074], [-117.1522, 32.96084], [-117.15188, 32.96087], [-117.15171, 32.96095], [-117.15163, 32.96106], [-117.15162, 32.96111], [-117.15151, 32.96124], [-117.15136, 32.9615], [-117.1513, 32.96146], [-117.15119, 32.96127], [-117.15114, 32.96097], [-117.15113, 32.96071], [-117.15108, 32.96065], [-117.15099, 32.96062], [-117.15095, 32.96052], [-117.15093, 32.96021], [-117.15098, 32.96011], [-117.15118, 32.95994], [-117.15127, 32.95991], [-117.15172, 32.96017], [-117.15204, 32.96021], [-117.15235, 32.96028], [-117.15264, 32.96043], [-117.15277, 32.96057], [-117.15279, 32.9606], [-117.15282, 32.96061]]]} Open Access 1 1760 Torrey Highlands Open Space 10619 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 3.557 Torrey Highlands 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]);