superunits_with_maps

Table actions

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

2 rows where PARK_NAME = "Piuma Ridge Park"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP

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
8213 8213 8212 {"type": "Polygon", "coordinates": [[[-118.6782, 34.06005], [-118.67818, 34.06166], [-118.67739, 34.06167], [-118.67739, 34.06315], [-118.67624, 34.06312], [-118.67625, 34.06492], [-118.67606, 34.06492], [-118.67361, 34.06522], [-118.67342, 34.06526], [-118.6733, 34.06532], [-118.67235, 34.06588], [-118.67225, 34.06598], [-118.67216, 34.06609], [-118.67203, 34.0664], [-118.67183, 34.06641], [-118.67177, 34.06417], [-118.67225, 34.06392], [-118.67224, 34.06325], [-118.67222, 34.06324], [-118.67156, 34.06326], [-118.67146, 34.06003], [-118.6782, 34.06005]]]} Open Access 1 Piuma Ridge Park   23752 215 Santa Monica Mountains Conservancy 303 State 5 State Agency 5 http://www.smmc.ca.gov Other State 5 73.26 Piuma Ridge Park  
8214 8214 8213 {"type": "MultiPolygon", "coordinates": [[[[-118.68048, 34.06325], [-118.67835, 34.06318], [-118.67835, 34.06513], [-118.67748, 34.06508], [-118.67728, 34.06512], [-118.677, 34.06527], [-118.67687, 34.06528], [-118.67676, 34.06524], [-118.67659, 34.06507], [-118.6765, 34.06501], [-118.67636, 34.06495], [-118.67625, 34.06492], [-118.67624, 34.06311], [-118.67739, 34.06314], [-118.67738, 34.06166], [-118.67818, 34.06164], [-118.6782, 34.06005], [-118.68047, 34.06006], [-118.68048, 34.06325]]], [[[-118.67835, 34.06631], [-118.67625, 34.06617], [-118.67625, 34.06509], [-118.67634, 34.06512], [-118.67642, 34.06517], [-118.67667, 34.06538], [-118.67686, 34.06544], [-118.67706, 34.06542], [-118.67737, 34.06528], [-118.67749, 34.06524], [-118.67834, 34.06529], [-118.67835, 34.06631]]]]} Open Access 1 Piuma Ridge Park   23753 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 36.883 Piuma Ridge 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]);