units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, AGNCY_NAME = 345 and DES_TP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

DES_TP 1

  • Local Park · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
1307 1307 1306 {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.27169], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65006, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64705, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64205, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.2663], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65458, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65201, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.6557, 34.26352], [-118.65602, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.2667], [-118.65643, 34.26684], [-118.65636, 34.26695], [-118.65626, 34.2677], [-118.65595, 34.26773], [-118.65595, 34.26945], [-118.6562, 34.26962], [-118.65629, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} Open Access 1 10485 Corriganville Park 8979 2117 Rancho Simi Open Space Conservation Agency 345 Special District 4 Open Space District 6   Special District 4 2117 Rancho Simi Open Space Conservation Agency 342 Special District 4 Open Space District 6 http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html Ventura 8 178.572 Corriganville 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]);