superunits_with_maps

Table actions

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

16 rows where ACCESS_TYP = 1 and MNG_AGENCY = 443

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Bellflower, City of · 16 ✖

ACCESS_TYP 1

  • Open Access · 16 ✖
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
3162 3162 3161 {"type": "Polygon", "coordinates": [[[-118.1436, 33.87107], [-118.14301, 33.87107], [-118.14301, 33.87038], [-118.14299, 33.87036], [-118.14299, 33.86965], [-118.1436, 33.86965], [-118.1436, 33.87107]]]} Open Access 1 Constitution Park   17598 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 2.155 Constitution Park  
6675 6675 6674 {"type": "Polygon", "coordinates": [[[-118.13963, 33.87665], [-118.13948, 33.87676], [-118.1383, 33.87688], [-118.135, 33.87693], [-118.13403, 33.8769], [-118.13403, 33.8767], [-118.13963, 33.87665]]]} Open Access 1 Palm Park   23342 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 2.951 Palm Park  
8799 8799 8798 {"type": "Polygon", "coordinates": [[[-118.10976, 33.89657], [-118.10921, 33.89657], [-118.10917, 33.89262], [-118.10876, 33.89261], [-118.10872, 33.89076], [-118.10871, 33.88801], [-118.10911, 33.88804], [-118.10912, 33.88798], [-118.10968, 33.88802], [-118.10976, 33.89657]]]} Open Access 1 Riverview Park   24462 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 16.983 Riverview Park  
11048 11048 11047 {"type": "Polygon", "coordinates": [[[-118.12265, 33.88198], [-118.12224, 33.88198], [-118.12224, 33.88163], [-118.12243, 33.88163], [-118.12244, 33.88151], [-118.12265, 33.88151], [-118.12265, 33.88198]]]} Open Access 1 Library Garden   29593 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 0.431 Library Garden  
11049 11049 11048 {"type": "Polygon", "coordinates": [[[-118.13381, 33.88421], [-118.13338, 33.88421], [-118.13337, 33.88456], [-118.13196, 33.88456], [-118.13194, 33.88387], [-118.12959, 33.88388], [-118.12959, 33.88297], [-118.1338, 33.88296], [-118.13381, 33.88421]]]} Open Access 1 John S. Simms Park   29594 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 12.575 John S. Simms Park  
11050 11050 11049 {"type": "Polygon", "coordinates": [[[-118.12631, 33.88386], [-118.12581, 33.88386], [-118.12581, 33.88372], [-118.1263, 33.88372], [-118.12631, 33.88386]]]} Open Access 1 Pirate Park   29595 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 0.177 Pirate Park  
11051 11051 11050 {"type": "Polygon", "coordinates": [[[-118.11139, 33.88013], [-118.10936, 33.88013], [-118.10932, 33.87973], [-118.10926, 33.87934], [-118.109, 33.87837], [-118.1088, 33.87837], [-118.10858, 33.87736], [-118.1097, 33.87741], [-118.11138, 33.87844], [-118.11139, 33.88013]]]} Open Access 1 Ruth R. Caruthers Park   29596 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 14.108 Ruth R. Caruthers Park  
11052 11052 11051 {"type": "Polygon", "coordinates": [[[-118.10916, 33.88013], [-118.10866, 33.88013], [-118.10864, 33.87975], [-118.10856, 33.87932], [-118.10854, 33.87735], [-118.10858, 33.87736], [-118.10899, 33.87907], [-118.10911, 33.8796], [-118.10916, 33.88013]]]} Open Access 1 Bellflower Skate Park   29599 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 2.327 Bellflower Skate Park  
11056 11056 11055 {"type": "Polygon", "coordinates": [[[-118.12797, 33.90613], [-118.12547, 33.90613], [-118.12545, 33.90302], [-118.12551, 33.90298], [-118.12584, 33.90303], [-118.12612, 33.90308], [-118.12613, 33.90449], [-118.12796, 33.90449], [-118.12797, 33.90613]]]} Open Access 1 T. Mayne Thompson Park and Bellflower Aquatic Center   29597 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 12.886 T. Mayne Thompson Park and Bellflower Aquatic Ctr.  
11057 11057 11056 {"type": "Polygon", "coordinates": [[[-118.13986, 33.90515], [-118.13955, 33.90516], [-118.13954, 33.90499], [-118.13954, 33.905], [-118.13986, 33.90515]]]} Open Access 1 Van Ruiten/Birkhall Pocket Park   29598 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 0.066 Van Ruiten/Birkhall PP  
12490 12490 12489 {"type": "MultiPolygon", "coordinates": [[[[-118.11714, 33.88168], [-118.11705, 33.88172], [-118.11518, 33.88074], [-118.11387, 33.87997], [-118.10923, 33.87712], [-118.10987, 33.87717], [-118.11517, 33.88042], [-118.11714, 33.88145], [-118.11714, 33.88168]]], [[[-118.12513, 33.88586], [-118.11962, 33.88303], [-118.11818, 33.88229], [-118.11864, 33.88221], [-118.12292, 33.8844], [-118.12415, 33.88503], [-118.1244, 33.88538], [-118.12513, 33.88572], [-118.12513, 33.88586]]], [[[-118.13228, 33.8892], [-118.13165, 33.8892], [-118.12539, 33.88599], [-118.12539, 33.88567], [-118.13228, 33.8892]]], [[[-118.13385, 33.89032], [-118.13216, 33.88946], [-118.13216, 33.88942], [-118.1327, 33.88942], [-118.13384, 33.89], [-118.13385, 33.89032]]], [[[-118.14254, 33.89477], [-118.13411, 33.89046], [-118.13411, 33.89013], [-118.14253, 33.89445], [-118.14254, 33.89477]]]]} Open Access 1 Bellflower Bike Trail   29575 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 24.963 Bellflower Bike Trail  
12491 12491 12490 {"type": "Polygon", "coordinates": [[[-118.11833, 33.88205], [-118.11787, 33.88208], [-118.11776, 33.88205], [-118.11754, 33.88194], [-118.11747, 33.88184], [-118.11747, 33.88161], [-118.11833, 33.88205]]]} Open Access 1 Bellflower Bike Trail Plaza   29576 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 0.44 Bellflower Bike Trail Plaza  
12502 12502 12501 {"type": "Polygon", "coordinates": [[[-118.13836, 33.89292], [-118.13773, 33.89292], [-118.13773, 33.89231], [-118.13835, 33.89263], [-118.13836, 33.89292]]]} Open Access 1 Flora Vista Dog Park   29570 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 0.719 Flora Vista Dog Park  
12503 12503 12502 {"type": "Polygon", "coordinates": [[[-118.11099, 33.9097], [-118.1104, 33.90971], [-118.10974, 33.90773], [-118.11031, 33.90763], [-118.11099, 33.9097]]]} Open Access 1 H. Byrum Zinn Community Park and Trail   29571 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 3.095 H. Byrum Zinn Community Park and Trail  
12510 12510 12509 {"type": "MultiPolygon", "coordinates": [[[[-118.10904, 33.88598], [-118.10883, 33.88598], [-118.10867, 33.88576], [-118.10866, 33.88024], [-118.109, 33.88024], [-118.109, 33.88234], [-118.10903, 33.88235], [-118.10899, 33.88344], [-118.10902, 33.88416], [-118.10904, 33.88598]]], [[[-118.10902, 33.88748], [-118.10884, 33.88749], [-118.10875, 33.88743], [-118.10869, 33.88737], [-118.10867, 33.8867], [-118.10874, 33.8867], [-118.10902, 33.88706], [-118.10902, 33.88748]]]]} Open Access 1 Caruthers Park North https://www.bellflower.org/home/index.asp?page=132 29601 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 5.515 Caruthers Park North  
12522 12522 12521 {"type": "Polygon", "coordinates": [[[-118.12195, 33.89644], [-118.12189, 33.89649], [-118.12166, 33.89649], [-118.12171, 33.89622], [-118.12195, 33.89622], [-118.12195, 33.89644]]]} Open Access 1 Chevron Pocket Park   29600 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 0.178 Chevron PP  

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