superunits_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1 and MNG_AGENCY = 124

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Dinuba, City of · 10 ✖

ACCESS_TYP 1

  • Open Access · 10 ✖
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
1106 1106 1105 {"type": "Polygon", "coordinates": [[[-119.4038, 36.54961], [-119.4038, 36.55018], [-119.40314, 36.54961], [-119.4038, 36.54961], [-119.4038, 36.54961]]]} Open Access 1 Alice Park   15361 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 0.463 Alice Park  
2898 2898 2897 {"type": "Polygon", "coordinates": [[[-119.37659, 36.53118], [-119.37658, 36.53279], [-119.37222, 36.53281], [-119.37223, 36.53119], [-119.37659, 36.53118]]]} Open Access 1 Dinuba City Park   18158 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 17.242 Dinuba City Park  
4042 4042 4041 {"type": "MultiPolygon", "coordinates": [[[[-119.38892, 36.53896], [-119.38854, 36.53924], [-119.38819, 36.53893], [-119.38857, 36.53864], [-119.38892, 36.53896]]], [[[-119.38925, 36.53853], [-119.38885, 36.53882], [-119.38862, 36.53861], [-119.38901, 36.53832], [-119.38925, 36.53853]]]]} Open Access 1 Entertainment Plaza   18686 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 0.902 Entertainment Plaza  
4531 4531 4530 {"type": "Polygon", "coordinates": [[[-119.38657, 36.53614], [-119.38603, 36.53654], [-119.38602, 36.53567], [-119.38602, 36.53567], [-119.38657, 36.53614]]]} Open Access 1 Gegory Park   19248 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 0.573 Gegory Park  
5644 5644 5643 {"type": "Polygon", "coordinates": [[[-119.39252, 36.53486], [-119.39046, 36.53481], [-119.39044, 36.53223], [-119.39123, 36.53227], [-119.39125, 36.5314], [-119.3925, 36.53145], [-119.3925, 36.53214], [-119.39181, 36.53212], [-119.39153, 36.53226], [-119.39152, 36.5337], [-119.39153, 36.53372], [-119.39251, 36.53371], [-119.39252, 36.53486]]]} Open Access 1 K/C Vista Park   20538 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 11.895 K/C Vista Park  
6462 6462 6461 {"type": "Polygon", "coordinates": [[[-119.40068, 36.54219], [-119.40059, 36.54224], [-119.39731, 36.54222], [-119.39711, 36.54217], [-119.39691, 36.54206], [-119.39631, 36.54164], [-119.396, 36.54139], [-119.39587, 36.54131], [-119.39562, 36.54123], [-119.39545, 36.5412], [-119.39525, 36.5412], [-119.3952, 36.54115], [-119.39518, 36.53913], [-119.39527, 36.53913], [-119.3953, 36.53917], [-119.39532, 36.53975], [-119.39534, 36.54109], [-119.3954, 36.54111], [-119.39571, 36.54112], [-119.39592, 36.54117], [-119.3961, 36.54126], [-119.39631, 36.5414], [-119.39697, 36.54194], [-119.39713, 36.54204], [-119.39739, 36.54212], [-119.39754, 36.54211], [-119.39778, 36.54197], [-119.39976, 36.54195], [-119.40068, 36.54197], [-119.40068, 36.54219]]]} Open Access 1 Luis Ruiz Park   21590 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 3.61 Luis Ruiz Park  
7906 7906 7905 {"type": "Polygon", "coordinates": [[[-119.40892, 36.54799], [-119.40878, 36.54804], [-119.4085, 36.54816], [-119.40838, 36.54818], [-119.40827, 36.54817], [-119.40827, 36.54693], [-119.40892, 36.54694], [-119.40892, 36.54799]]]} Open Access 1 Pamela Lane Pond Park   23378 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 1.874 Pamela Lane Pond Park  
8040 8040 8039 {"type": "Polygon", "coordinates": [[[-119.40608, 36.55069], [-119.40539, 36.55068], [-119.40539, 36.55094], [-119.4059, 36.55095], [-119.40559, 36.55117], [-119.40552, 36.55119], [-119.4053, 36.55118], [-119.40519, 36.55115], [-119.40509, 36.55108], [-119.40424, 36.55033], [-119.40602, 36.55035], [-119.40603, 36.55055], [-119.40608, 36.55069]]]} Open Access 1 Peachwood Park   23542 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 2.117 Peachwood Park  
8454 8454 8453 {"type": "Polygon", "coordinates": [[[-119.38696, 36.54747], [-119.38482, 36.54743], [-119.38476, 36.54571], [-119.38686, 36.54575], [-119.38696, 36.54747]]]} Open Access 1 R.A. Vuich Park   24065 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 8.923 R.A. Vuich Park  
8930 8930 8929 {"type": "Polygon", "coordinates": [[[-119.38148, 36.54428], [-119.38005, 36.54424], [-119.38006, 36.54373], [-119.38009, 36.54366], [-119.3802, 36.54353], [-119.38021, 36.54349], [-119.38019, 36.54346], [-119.38015, 36.54343], [-119.38004, 36.54343], [-119.38004, 36.54289], [-119.38144, 36.54293], [-119.38148, 36.54428]]]} Open Access 1 Roosevelt Park   24597 1086 Dinuba, City of 124 City 2 City Agency 2 http://www.dinuba.org/ City 2 4.616 Roosevelt 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]);