units_with_maps

Table actions

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

1 row where MNG_AGENCY = 27, MNG_AG_TYP = 6 and PARK_URL = "http://lamountains.com/parks.asp?parkid=18"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Open Space District · 1 ✖

MNG_AGENCY 1

  • Mountains Recreation and Conservation Authority · 1 ✖

DES_TP 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
16425 16425 16424 {"type": "MultiPolygon", "coordinates": [[[[-118.87476, 34.32819], [-118.87476, 34.3296], [-118.87476, 34.3296], [-118.8745, 34.32941], [-118.87438, 34.32854], [-118.87476, 34.32819]]], [[[-118.87476, 34.34063], [-118.83068, 34.35903], [-118.83065, 34.35145], [-118.82257, 34.3514], [-118.81336, 34.35143], [-118.79638, 34.35155], [-118.79639, 34.33534], [-118.79708, 34.33551], [-118.79766, 34.33597], [-118.79782, 34.33615], [-118.7982, 34.33682], [-118.79853, 34.33734], [-118.79889, 34.33755], [-118.79951, 34.33766], [-118.79964, 34.3377], [-118.79977, 34.33777], [-118.79985, 34.33783], [-118.79994, 34.33793], [-118.80017, 34.33832], [-118.80083, 34.33894], [-118.80102, 34.33904], [-118.80117, 34.33908], [-118.80169, 34.33916], [-118.80201, 34.33917], [-118.8023, 34.33914], [-118.80336, 34.33892], [-118.80367, 34.3389], [-118.80402, 34.33892], [-118.80631, 34.33943], [-118.80843, 34.34012], [-118.8094, 34.34026], [-118.81059, 34.3402], [-118.81103, 34.34015], [-118.81172, 34.34013], [-118.81306, 34.34003], [-118.81336, 34.33993], [-118.81424, 34.33951], [-118.8144, 34.33947], [-118.81505, 34.33942], [-118.81527, 34.33937], [-118.81549, 34.33928], [-118.81571, 34.33914], [-118.81642, 34.33885], [-118.81661, 34.33881], [-118.81678, 34.33881], [-118.8173, 34.33863], [-118.8181, 34.33844], [-118.81881, 34.33861], [-118.81923, 34.33882], [-118.81948, 34.33886], [-118.81961, 34.33885], [-118.8197, 34.33881], [-118.81978, 34.33874], [-118.81995, 34.33839], [-118.82026, 34.33791], [-118.82043, 34.33772], [-118.8206, 34.33758], [-118.82077, 34.33748], [-118.82093, 34.33741], [-118.82199, 34.33706], [-118.82225, 34.33692], [-118.82248, 34.33685], [-118.82349, 34.33673], [-118.82375, 34.33675], [-118.82413, 34.33683], [-118.82437, 34.33684], [-118.82521, 34.33664], [-118.82566, 34.33659], [-118.82603, 34.3366], [-118.82663, 34.33668], [-118.82685, 34.33668], [-118.8282, 34.33638], [-118.82933, 34.33626], [-118.82956, 34.33627], [-118.82977, 34.33634], [-118.82991, 34.33642], [-118.83035, 34.33678], [-118.83053, 34.33683], [-118.83065, 34.33691], [-118.83084, 34.33696], [-118.83104, 34.33695], [-118.83181, 34.33698], [-118.83247, 34.33669], [-118.83293, 34.33644], [-118.83324, 34.33641], [-118.83355, 34.33632], [-118.83373, 34.33632], [-118.83389, 34.33637], [-118.83419, 34.33654], [-118.83438, 34.3366], [-118.83456, 34.33662], [-118.83517, 34.33662], [-118.83554, 34.33668], [-118.8369, 34.33709], [-118.83757, 34.33727], [-118.83784, 34.33742], [-118.83807, 34.33749], [-118.83894, 34.33741], [-118.83996, 34.33753], [-118.84067, 34.33751], [-118.84149, 34.33755], [-118.84209, 34.33737], [-118.84252, 34.33728], [-118.84265, 34.33721], [-118.84276, 34.33704], [-118.84285, 34.33697], [-118.84318, 34.33688], [-118.84337, 34.33677], [-118.84348, 34.33675], [-118.84357, 34.33678], [-118.84386, 34.33695], [-118.8451, 34.33738], [-118.84567, 34.33764], [-118.8458, 34.33769], [-118.84603, 34.33771], [-118.84651, 34.33765], [-118.84669, 34.33765], [-118.84762, 34.3378], [-118.84815, 34.33779], [-118.84824, 34.33777], [-118.84833, 34.33773], [-118.84863, 34.33751], [-118.84863, 34.33703], [-118.84938, 34.33701], [-118.85002, 34.33668], [-118.85021, 34.33662], [-118.85039, 34.33662], [-118.85119, 34.33669], [-118.85135, 34.33667], [-118.8515, 34.33664], [-118.85164, 34.33658], [-118.85293, 34.33585], [-118.85356, 34.3356], [-118.85395, 34.33535], [-118.85437, 34.33533], [-118.85474, 34.33525], [-118.85486, 34.33525], [-118.85501, 34.33528], [-118.85555, 34.33554], [-118.85574, 34.3356], [-118.85599, 34.33562], [-118.85635, 34.33555], [-118.85642, 34.33556], [-118.85649, 34.33562], [-118.85655, 34.33579], [-118.85655, 34.33591], [-118.85649, 34.33608], [-118.85656, 34.33625], [-118.85667, 34.3364], [-118.85688, 34.33658], [-118.85726, 34.33647], [-118.85734, 34.33642], [-118.85734, 34.32241], [-118.86439, 34.3224], [-118.86461, 34.32118], [-118.8643, 34.32035], [-118.8656, 34.31828], [-118.86643, 34.31659], [-118.86568, 34.31512], [-118.87466, 34.31512], [-118.87466, 34.32032], [-118.87399, 34.32033], [-118.87399, 34.32149], [-118.87366, 34.3215], [-118.87366, 34.32238], [-118.87476, 34.32239], [-118.87476, 34.32803], [-118.87424, 34.3285], [-118.87438, 34.32946], [-118.87471, 34.32972], [-118.87476, 34.32977], [-118.87476, 34.33065], [-118.87474, 34.3307], [-118.87476, 34.33071], [-118.87476, 34.34063]], [[-118.84181, 34.34823], [-118.8418, 34.34822], [-118.84069, 34.3482], [-118.84066, 34.34907], [-118.84178, 34.3491], [-118.84181, 34.34823]]]]} Open Access 1 45301 Happy Camp Canyon Regional Park 19656 331 Ventura, County of 202 County 3 County Agency 3 http://www.ventura.org/general-services-agency/parks-department County 3 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://lamountains.com/parks.asp?parkid=18 Ventura 8 3383.679 Happy Camp Canyon RP 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]);