superunits_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, ACRES = "1.21" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

  • City Agency · 4 ✖

ACCESS_TYP 1

  • Open Access · 4 ✖
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
3333 3333 3332 {"type": "Polygon", "coordinates": [[[-122.24787, 37.52556], [-122.24764, 37.52556], [-122.24737, 37.52561], [-122.24712, 37.52573], [-122.24692, 37.52589], [-122.24683, 37.526], [-122.24678, 37.5261], [-122.24609, 37.52759], [-122.24642, 37.52771], [-122.24643, 37.52775], [-122.246, 37.52784], [-122.24583, 37.52772], [-122.246, 37.5275], [-122.24612, 37.52732], [-122.24622, 37.52709], [-122.24632, 37.52674], [-122.2464, 37.52653], [-122.24692, 37.52562], [-122.24707, 37.52552], [-122.24725, 37.52548], [-122.2478, 37.52546], [-122.24787, 37.52556]]]} Open Access 1 Cringle Park   17821 1271 Redwood City, City of 391 City 2 City Agency 2 http://www.redwoodcity.org/parks/ City 2 1.21 Cringle Park 1973
7865 7865 7864 {"type": "Polygon", "coordinates": [[[-122.49561, 37.68954], [-122.49554, 37.68957], [-122.4952, 37.68961], [-122.49487, 37.68846], [-122.49527, 37.68839], [-122.49561, 37.68954]]]} Open Access 1 Palisades Park   23329 1078 Daly City, City of 421 City 2 City Agency 2 http://www.dalycity.org/ City 2 1.21 Palisades Park  
9126 9126 9125 {"type": "Polygon", "coordinates": [[[-121.62762, 36.68194], [-121.6272, 36.68289], [-121.6267, 36.68273], [-121.62672, 36.68263], [-121.62654, 36.68235], [-121.62762, 36.68194]]]} Open Access 1 Salinas holding 5   24803 1291 Salinas, City of 54 City 2 City Agency 2 http://www.ci.salinas.ca.us/services/recreation/recreation.cfm City 2 1.21 Salinas holding 5  
13672 13672 13671 {"type": "Polygon", "coordinates": [[[-117.9718, 33.64249], [-117.9714, 33.64286], [-117.97112, 33.64322], [-117.97106, 33.64322], [-117.97105, 33.64195], [-117.9718, 33.64249]]]} Open Access 1 Banning/Magnolia Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/banning-magnolia-park.cfm 31160 1141 Huntington Beach, City of 122 City 2 City Agency 2 http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm City 2 1.21 Banning/Magnolia 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]);