superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1 and PARK_NAME = "La Jolla Open Space"

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
5821 5821 5820 {"type": "MultiPolygon", "coordinates": [[[[-117.23727, 32.8639], [-117.23644, 32.86425], [-117.23638, 32.8638], [-117.23635, 32.86319], [-117.23639, 32.86239], [-117.23655, 32.86237], [-117.23654, 32.86199], [-117.23666, 32.86171], [-117.23669, 32.86284], [-117.23727, 32.8639]]], [[[-117.23873, 32.83257], [-117.23825, 32.83268], [-117.2382, 32.83254], [-117.23868, 32.83244], [-117.23873, 32.83257]]], [[[-117.24528, 32.86108], [-117.24497, 32.8612], [-117.24448, 32.86133], [-117.24432, 32.8614], [-117.24396, 32.86163], [-117.24375, 32.86184], [-117.24361, 32.86209], [-117.24352, 32.86238], [-117.24351, 32.86265], [-117.24338, 32.86178], [-117.24345, 32.86156], [-117.24359, 32.86139], [-117.24371, 32.86131], [-117.24394, 32.86122], [-117.24476, 32.86117], [-117.24528, 32.86108]]], [[[-117.24407, 32.87689], [-117.24399, 32.87689], [-117.24384, 32.87595], [-117.24384, 32.87559], [-117.24407, 32.87542], [-117.24407, 32.87689]]], [[[-117.2441, 32.87161], [-117.24408, 32.87504], [-117.24394, 32.87515], [-117.24395, 32.87196], [-117.24389, 32.8716], [-117.2441, 32.87161]]], [[[-117.24598, 32.85902], [-117.24599, 32.85969], [-117.24598, 32.85977], [-117.24591, 32.85992], [-117.24578, 32.86005], [-117.24495, 32.86044], [-117.24472, 32.86048], [-117.24414, 32.86051], [-117.24598, 32.85902]]], [[[-117.25853, 32.81943], [-117.25847, 32.81962], [-117.25844, 32.81989], [-117.25701, 32.82021], [-117.25684, 32.8197], [-117.25762, 32.81909], [-117.25817, 32.8182], [-117.25853, 32.81943]]]]} Open Access 1 La Jolla Open Space   20766 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 13.053 La Jolla OS  
5822 5822 5821 {"type": "Polygon", "coordinates": [[[-118.8615, 34.18768], [-118.85967, 34.18766], [-118.85966, 34.1829], [-118.86011, 34.18335], [-118.86033, 34.18412], [-118.86058, 34.18455], [-118.86139, 34.18635], [-118.86149, 34.18669], [-118.8615, 34.18768]]]} Open Access 1 La Jolla Open Space   20767 1347 Thousand Oaks, City of 422 City 2 City Agency 2 http://www.ci.thousand-oaks.ca.us/ City 2 14.257 La Jolla OS  

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