units_with_maps

Table actions

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

10 rows where AGNCY_NAME = 226, DES_TP = 2 and MNG_AGENCY = 222

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Bell Gardens, City of · 10 ✖

DES_TP 1

  • Local Park · 10 ✖
Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
630 630 629 {"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.95918], [-118.14838, 33.95879], [-118.1518, 33.95694], [-118.15197, 33.95717], [-118.15187, 33.95827], [-118.15253, 33.95835]]]} Open Access 1 2494 John Anson Ford Park 20427 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 16.866 John Anson Ford Park 0 Local Park 2 4
698 698 697 {"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 3785 Bell Gardens Veterans Park 15974 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 15.747 Bell Gardens Veterans Park 0 Local Park 2 4
4407 4407 4406 {"type": "Polygon", "coordinates": [[[-118.14787, 33.95964], [-118.14683, 33.9602], [-118.14653, 33.95978], [-118.14761, 33.9592], [-118.14787, 33.95964]]]} Restricted Access 2 46199 Community Garden 32757 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 1.546 Community Garden 0 Local Park 2 4
10841 10841 10840 {"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 20617 Marlow Park 21881 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 0.981 Marlow Park 0 Local Park 2 4
11879 11879 11878 {"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 24483 Julia Russ Asmus Park 20517 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 0.754 Julia Russ Asmus Park 0 Local Park 2 4
11891 11891 11890 {"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.97106], [-118.13551, 33.97089], [-118.13555, 33.97093], [-118.13578, 33.97095]]]} Open Access 1 24485 Hannon Park 19644 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 0.422 Hannon Park 0 Local Park 2 4
12118 12118 12117 {"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 25057 Darwell Park 17932 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 0.258 Darwell Park 0 Local Park 2 4
15225 15225 15224 {"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 46200 Gallant Park 29499 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 0.256 Gallant Park 0 Local Park 2 4
15233 15233 15232 {"type": "Polygon", "coordinates": [[[-118.15556, 33.95835], [-118.15538, 33.95925], [-118.15264, 33.95897], [-118.15242, 33.95897], [-118.15252, 33.95835], [-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 46198 Bell Gardens Sports Center at Ford Park 29495 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 18.992 Bell Gardens Sports Ctr. at Ford Park 0 Local Park 2 4
15728 15728 15727 {"type": "Polygon", "coordinates": [[[-118.15633, 33.9544], [-118.15556, 33.95835], [-118.15532, 33.95831], [-118.15543, 33.95776], [-118.15531, 33.95757], [-118.15526, 33.95754], [-118.15527, 33.9572], [-118.15505, 33.95697], [-118.15296, 33.95675], [-118.15268, 33.95647], [-118.15483, 33.95531], [-118.15633, 33.9544]]]} Restricted Access 2 46197 Bell Gardens Golf Course at Ford Park 33117 1023 Bell Gardens, City of 226 City 2 City Agency 2 http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx City 2 1023 Bell Gardens, City of 222 City 2 City Agency 2   Los Angeles 6 12.793 Bell Gardens GC at Ford Park 0 Local Park 2 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);