units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1 and DES_TP = 1400

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

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
16427 16427 16426 {"type": "MultiPolygon", "coordinates": [[[[-118.55583, 34.03798], [-118.55572, 34.03834], [-118.55517, 34.03833], [-118.55476, 34.03835], [-118.55393, 34.03844], [-118.55365, 34.03853], [-118.55269, 34.0388], [-118.55086, 34.03926], [-118.55047, 34.03934], [-118.55001, 34.03938], [-118.54954, 34.03937], [-118.54848, 34.03928], [-118.54787, 34.03929], [-118.54788, 34.03919], [-118.54536, 34.03872], [-118.54392, 34.03887], [-118.54391, 34.03921], [-118.54177, 34.0386], [-118.54124, 34.03842], [-118.54064, 34.03816], [-118.53918, 34.03738], [-118.53794, 34.03677], [-118.53795, 34.03674], [-118.53598, 34.03579], [-118.53542, 34.03543], [-118.53468, 34.03487], [-118.5344, 34.0347], [-118.5341, 34.03456], [-118.52867, 34.03231], [-118.52815, 34.03215], [-118.52686, 34.03188], [-118.52656, 34.03176], [-118.52654, 34.03177], [-118.52486, 34.03107], [-118.52441, 34.03083], [-118.5219, 34.02944], [-118.52067, 34.02865], [-118.52039, 34.02851], [-118.51971, 34.02825], [-118.51943, 34.02808], [-118.51941, 34.028], [-118.51917, 34.02783], [-118.51907, 34.02783], [-118.51818, 34.02729], [-118.51707, 34.02675], [-118.51792, 34.02557], [-118.51861, 34.02602], [-118.51897, 34.02622], [-118.51932, 34.02639], [-118.51971, 34.02665], [-118.52001, 34.02686], [-118.52008, 34.02703], [-118.52009, 34.02722], [-118.52027, 34.02748], [-118.52039, 34.0275], [-118.52057, 34.02756], [-118.52113, 34.02756], [-118.52161, 34.02782], [-118.52185, 34.02803], [-118.52209, 34.02818], [-118.52234, 34.0284], [-118.52258, 34.02854], [-118.52283, 34.02862], [-118.52392, 34.02934], [-118.52482, 34.02988], [-118.52574, 34.0304], [-118.52621, 34.03076], [-118.52699, 34.03109], [-118.52718, 34.03109], [-118.52751, 34.03113], [-118.5281, 34.03131], [-118.52834, 34.03145], [-118.52868, 34.03169], [-118.52961, 34.03226], [-118.53042, 34.03258], [-118.53069, 34.03241], [-118.5309, 34.03248], [-118.5313, 34.03266], [-118.53192, 34.03299], [-118.53255, 34.03326], [-118.53291, 34.03344], [-118.53402, 34.03391], [-118.53482, 34.03431], [-118.53539, 34.03453], [-118.53588, 34.03479], [-118.53651, 34.035], [-118.53687, 34.03506], [-118.53715, 34.03518], [-118.53784, 34.03539], [-118.53811, 34.03551], [-118.53834, 34.0357], [-118.53857, 34.03584], [-118.53882, 34.03596], [-118.53909, 34.03605], [-118.53939, 34.03618], [-118.53973, 34.0363], [-118.54037, 34.03661], [-118.5409, 34.03697], [-118.54185, 34.03732], [-118.54249, 34.03762], [-118.54277, 34.03781], [-118.54308, 34.03797], [-118.54365, 34.03813], [-118.54399, 34.03819], [-118.5442, 34.03826], [-118.54444, 34.0383], [-118.54486, 34.03848], [-118.54487, 34.03852], [-118.5452, 34.03846], [-118.54588, 34.03865], [-118.54639, 34.03877], [-118.54736, 34.03894], [-118.54794, 34.03903], [-118.54881, 34.03909], [-118.54997, 34.0391], [-118.55042, 34.03906], [-118.55141, 34.03889], [-118.55269, 34.03862], [-118.55302, 34.03848], [-118.55385, 34.03797], [-118.55415, 34.03788], [-118.55472, 34.0378], [-118.55512, 34.03779], [-118.55568, 34.03785], [-118.55568, 34.03788], [-118.55583, 34.03798]]], [[[-118.56722, 34.04165], [-118.5663, 34.0415], [-118.56567, 34.04136], [-118.56518, 34.04127], [-118.56419, 34.04122], [-118.56383, 34.04116], [-118.56349, 34.04108], [-118.56299, 34.0409], [-118.56244, 34.0406], [-118.56207, 34.04043], [-118.56005, 34.03982], [-118.55953, 34.03964], [-118.55896, 34.03942], [-118.55764, 34.03883], [-118.55706, 34.03859], [-118.5564, 34.0384], [-118.55601, 34.03836], [-118.55601, 34.03826], [-118.55621, 34.03794], [-118.55636, 34.03797], [-118.55682, 34.0382], [-118.5576, 34.03848], [-118.55785, 34.03861], [-118.55814, 34.03869], [-118.55846, 34.03884], [-118.5589, 34.03899], [-118.55955, 34.03916], [-118.5601, 34.03938], [-118.5605, 34.03959], [-118.56097, 34.03979], [-118.56121, 34.03986], [-118.56173, 34.04004], [-118.56201, 34.04011], [-118.56227, 34.04024], [-118.56256, 34.04031], [-118.56281, 34.04041], [-118.56333, 34.04056], [-118.56392, 34.04065], [-118.5643, 34.0407], [-118.56541, 34.04096], [-118.56562, 34.04093], [-118.5668, 34.04117], [-118.56682, 34.04132], [-118.56714, 34.04138], [-118.56714, 34.04156], [-118.56722, 34.04165]]]]} Open Access 1 5469 Will Rogers State Beach 30714 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 378 Los Angeles County Department of Beaches and Harbors, County of 827 County 3 County Agency - Other 8 http://www.parks.ca.gov/?page_id=625 Los Angeles 6 90.632 Will Rogers SB 1931 None 1400  

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