superunits_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1 and ACRES = "0.477"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 2

ACCESS_TYP 1

  • Open Access · 6 ✖
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
180 180 179 {"type": "Polygon", "coordinates": [[[-121.49995, 38.57528], [-121.49977, 38.5757], [-121.49934, 38.57558], [-121.49952, 38.57517], [-121.49995, 38.57528]]]} Open Access 1 Heilbron Mansion   1561 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 0.477 Heilbron Mansion  
2016 2016 2015 {"type": "Polygon", "coordinates": [[[-122.40918, 37.59933], [-122.40913, 37.5994], [-122.4085, 37.59926], [-122.40864, 37.59886], [-122.40894, 37.59893], [-122.40893, 37.59904], [-122.40903, 37.59922], [-122.40907, 37.59925], [-122.40917, 37.59926], [-122.40918, 37.59933]]]} Open Access 1 Bill Mitchell Lions Park https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/lion-bill-mitchell-park 16107 1205 Millbrae, City of 398 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 0.477 Bill Mitchell Lions Park 1977
4032 4032 4031 {"type": "Polygon", "coordinates": [[[-114.61087, 33.6142], [-114.61015, 33.61421], [-114.61015, 33.61402], [-114.61019, 33.61398], [-114.61043, 33.61396], [-114.61082, 33.61389], [-114.61085, 33.61391], [-114.61086, 33.61394], [-114.61087, 33.6142]]]} Open Access 1 Engevick Park   18675 1032 Blythe, City of 339 City 2 City Agency 2 http://www.cityofblythe.ca.gov/88/Parks-Department City 2 0.477 Engevick Park  
4744 4744 4743 {"type": "Polygon", "coordinates": [[[-118.39247, 33.86342], [-118.3922, 33.86326], [-118.39194, 33.86317], [-118.39179, 33.86314], [-118.39193, 33.86304], [-118.39206, 33.86292], [-118.39218, 33.86278], [-118.39224, 33.86266], [-118.39247, 33.86342]]]} Open Access 1 Greenwood Park   19486 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.477 Greenwood Park  
8032 8032 8031 {"type": "Polygon", "coordinates": [[[-117.9095, 33.81358], [-117.9095, 33.81395], [-117.90904, 33.81394], [-117.90899, 33.81392], [-117.90899, 33.81358], [-117.9095, 33.81358]]]} Open Access 1 Paul Revere Park Development   23533 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.477 Paul Revere Park Development  
11499 11499 11498 {"type": "Polygon", "coordinates": [[[-117.25556, 32.85351], [-117.25556, 32.85376], [-117.25554, 32.85378], [-117.2549, 32.85375], [-117.25487, 32.85374], [-117.25488, 32.85348], [-117.25556, 32.85351]]]} Open Access 1 Laureate Mini-Park   30161 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.477 Laureate Mini-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]);