superunits_with_maps

Table actions

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

9 rows where ACCESS_TYP = 1, MNG_AGENCY = 222 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 9 ✖

MNG_AGENCY 1

  • Bell Gardens, City of · 9 ✖

ACCESS_TYP 1

  • Open Access · 9 ✖
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
1925 1925 1924 {"type": "Polygon", "coordinates": [[[-118.14718, 33.96609], [-118.14712, 33.96647], [-118.14626, 33.96637], [-118.14632, 33.96599], [-118.14718, 33.96609]]]} Open Access 1 Bell Gardens Skate Park   15973 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 0.846 Bell Gardens Skate Park  
1926 1926 1925 {"type": "Polygon", "coordinates": [[[-118.14779, 33.96666], [-118.14653, 33.96905], [-118.14636, 33.96903], [-118.14574, 33.96873], [-118.14515, 33.96857], [-118.14451, 33.96848], [-118.14396, 33.96847], [-118.14355, 33.96862], [-118.14334, 33.96843], [-118.14472, 33.96729], [-118.14589, 33.96643], [-118.14633, 33.96643], [-118.14769, 33.96663], [-118.14779, 33.96666]]]} Open Access 1 Bell Gardens Veterans Park   15974 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 15.747 Bell Gardens Veterans Park  
3446 3446 3445 {"type": "Polygon", "coordinates": [[[-118.15515, 33.96751], [-118.15498, 33.96776], [-118.15456, 33.96756], [-118.15464, 33.96745], [-118.15515, 33.96751]]]} Open Access 1 Darwell Park   17932 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 0.258 Darwell Park  
3911 3911 3910 {"type": "Polygon", "coordinates": [[[-118.13578, 33.97095], [-118.13573, 33.97131], [-118.13556, 33.97129], [-118.1354, 33.97125], [-118.13522, 33.97117], [-118.13518, 33.97112], [-118.13518, 33.97109], [-118.13521, 33.97105], [-118.13551, 33.97089], [-118.13555, 33.97093], [-118.13578, 33.97095]]]} Open Access 1 Hannon Park   19644 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 0.422 Hannon Park  
5544 5544 5543 {"type": "Polygon", "coordinates": [[[-118.15253, 33.95835], [-118.15242, 33.95897], [-118.15215, 33.95902], [-118.14896, 33.96015], [-118.1485, 33.95921], [-118.14857, 33.95917], [-118.14838, 33.95879], [-118.1518, 33.95694], [-118.15197, 33.95717], [-118.15187, 33.95827], [-118.15253, 33.95835]]]} Open Access 1 John Anson Ford Park   20427 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 16.872 John Anson Ford Park  
5626 5626 5625 {"type": "Polygon", "coordinates": [[[-118.17025, 33.95555], [-118.17024, 33.95602], [-118.17013, 33.95601], [-118.17003, 33.95606], [-118.17004, 33.95617], [-118.16923, 33.95659], [-118.16909, 33.95662], [-118.17025, 33.95555]]]} Open Access 1 Julia Russ Asmus Park   20517 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 0.755 Julia Russ Asmus Park  
6702 6702 6701 {"type": "Polygon", "coordinates": [[[-118.16696, 33.97193], [-118.16688, 33.97253], [-118.16625, 33.97247], [-118.16632, 33.97187], [-118.16696, 33.97193]]]} Open Access 1 Marlow Park   21881 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 0.981 Marlow Park  
12453 12453 12452 {"type": "Polygon", "coordinates": [[[-118.15556, 33.95835], [-118.15538, 33.95925], [-118.15264, 33.95897], [-118.15242, 33.95897], [-118.15252, 33.95836], [-118.15187, 33.95828], [-118.15197, 33.95717], [-118.1518, 33.95694], [-118.15268, 33.95647], [-118.15296, 33.95675], [-118.15505, 33.95697], [-118.15527, 33.9572], [-118.15526, 33.95753], [-118.15531, 33.95757], [-118.15543, 33.95776], [-118.15532, 33.9583], [-118.15556, 33.95835]]]} Open Access 1 Bell Gardens Sports Center at Ford Park   29495 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 19.002 Bell Gardens Sports Ctr. at Ford Park  
12457 12457 12456 {"type": "Polygon", "coordinates": [[[-118.16062, 33.9611], [-118.16055, 33.96157], [-118.16034, 33.96154], [-118.16041, 33.96108], [-118.16062, 33.9611]]]} Open Access 1 Gallant Park   29499 1023 Bell Gardens, City of 222 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 0.256 Gallant 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]);