superunits_with_maps

Table actions

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

9 rows where ACCESS_TYP = 1 and MNG_AGENCY = 519

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Newman, 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
825 825 824 {"type": "Polygon", "coordinates": [[[-121.01284, 37.31283], [-121.01284, 37.31283], [-121.01186, 37.31375], [-121.01186, 37.31311], [-121.01183, 37.31294], [-121.01178, 37.3128], [-121.01165, 37.31266], [-121.01165, 37.31256], [-121.0119, 37.3125], [-121.01229, 37.31248], [-121.01272, 37.3125], [-121.01282, 37.31253], [-121.01284, 37.31283]]]} Open Access 1 Joe M Barba Park   33559 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 2.031 Joe M Barba Park  
1311 1311 1310 {"type": "Polygon", "coordinates": [[[-121.01423, 37.32012], [-121.01422, 37.32074], [-121.01419, 37.32091], [-121.01419, 37.32123], [-121.01408, 37.32125], [-121.01408, 37.32153], [-121.01412, 37.32161], [-121.01413, 37.32195], [-121.01309, 37.32191], [-121.01304, 37.32011], [-121.01423, 37.32012]]]} Open Access 1 Barrigton Park   15834 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 4.855 Barrigton Park  
5268 5268 5267 {"type": "Polygon", "coordinates": [[[-121.03023, 37.31264], [-121.02963, 37.31279], [-121.02953, 37.31256], [-121.02944, 37.31257], [-121.02919, 37.31193], [-121.02926, 37.31189], [-121.02919, 37.3117], [-121.0298, 37.31154], [-121.03023, 37.31264]]]} Open Access 1 Howard B Hill Jr Park   20114 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1.936 Howard B Hill Jr Park  
5485 5485 5484 {"type": "Polygon", "coordinates": [[[-121.02647, 37.307], [-121.02645, 37.30777], [-121.02504, 37.30767], [-121.02505, 37.30685], [-121.02578, 37.30686], [-121.02639, 37.30693], [-121.02647, 37.307]]]} Open Access 1 Janet Carlsen Park   20361 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 2.904 Janet Carlsen Park  
6255 6255 6254 {"type": "Polygon", "coordinates": [[[-121.03293, 37.31843], [-121.03291, 37.31976], [-121.03108, 37.31974], [-121.03104, 37.31842], [-121.03293, 37.31843]]]} Open Access 1 Lions Park   21321 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 5.972 Lions Park  
7361 7361 7360 {"type": "Polygon", "coordinates": [[[-121.02895, 37.31704], [-121.02791, 37.31731], [-121.02765, 37.31665], [-121.02793, 37.31657], [-121.02778, 37.31619], [-121.02855, 37.316], [-121.02895, 37.31704]]]} Open Access 1 Newman holding 1   22729 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 2.644 Newman holding 1  
8187 8187 8186 {"type": "Polygon", "coordinates": [[[-121.02666, 37.31484], [-121.0256, 37.31511], [-121.02521, 37.31406], [-121.02625, 37.31381], [-121.02666, 37.31484]]]} Open Access 1 Pioneer Park   23726 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 2.919 Pioneer Park  
11829 11829 11828 {"type": "Polygon", "coordinates": [[[-121.00767, 37.32011], [-121.00763, 37.32015], [-121.0075, 37.3202], [-121.00728, 37.32031], [-121.00714, 37.3204], [-121.00611, 37.32119], [-121.0058, 37.32142], [-121.00573, 37.3214], [-121.00563, 37.32134], [-121.00471, 37.32071], [-121.00468, 37.32066], [-121.00639, 37.31905], [-121.00678, 37.31931], [-121.00761, 37.31931], [-121.00767, 37.32011]]]} Open Access 1 Sherman Park   28473 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 9.035 Sherman Park  
13565 13565 13564 {"type": "Polygon", "coordinates": [[[-121.03563, 37.30465], [-121.03559, 37.3065], [-121.03527, 37.3065], [-121.0351, 37.30646], [-121.03494, 37.30641], [-121.03479, 37.30634], [-121.03459, 37.3062], [-121.03448, 37.30609], [-121.0344, 37.30596], [-121.03433, 37.30583], [-121.03429, 37.30562], [-121.0343, 37.30547], [-121.03434, 37.30532], [-121.03445, 37.30511], [-121.03456, 37.30499], [-121.03469, 37.30488], [-121.03485, 37.30479], [-121.03502, 37.30472], [-121.0352, 37.30467], [-121.03539, 37.30465], [-121.03563, 37.30465]]]} Open Access 1 Alfred A. "Bush" Rose, Jr. Park   30997 1223 Newman, City of 519 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 4.82 Alfred A. "Bush" Rose, Jr. 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]);