units_with_maps

Table actions

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

10 rows where COUNTY = 29, DES_TP = 2 and MNG_AGENCY = 124

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Dinuba, City of · 10 ✖

DES_TP 1

  • Local Park · 10 ✖

ACCESS_TYP 1

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
308 308 307 {"type": "Polygon", "coordinates": [[[-119.38657, 36.53614], [-119.38603, 36.53654], [-119.38602, 36.53567], [-119.38657, 36.53614], [-119.38657, 36.53614]]]} Open Access 1 1054 Gegory Park 19248 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 0.573 Gegory Park 0 Local Park 2 4
3503 3503 3502 {"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 25970 Alice Park 15361 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 0.464 Alice Park 0 Local Park 2 4
4213 4213 4212 {"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 44963 Dinuba City Park 18158 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 17.244 Dinuba City Park 0 Local Park 2 4
5022 5022 5021 {"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.53371], [-119.39153, 36.53372], [-119.39251, 36.53371], [-119.39252, 36.53486]]]} Open Access 1 1050 K/C Vista Park 20538 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 11.888 K/C Vista Park 0 Local Park 2 4
6109 6109 6108 {"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 1057 R.A. Vuich Park 24065 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 8.925 R.A. Vuich Park 0 Local Park 2 4
6111 6111 6110 {"type": "Polygon", "coordinates": [[[-119.38148, 36.54428], [-119.38005, 36.54424], [-119.38005, 36.54373], [-119.38008, 36.54366], [-119.3802, 36.54353], [-119.38021, 36.54349], [-119.3802, 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 1062 Roosevelt Park 24597 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 4.617 Roosevelt Park 0 Local Park 2 4
12307 12307 12306 {"type": "Polygon", "coordinates": [[[-119.40608, 36.55069], [-119.40539, 36.55068], [-119.40538, 36.55095], [-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 25966 Peachwood Park 23542 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 2.112 Peachwood Park 0 Local Park 2 4
12308 12308 12307 {"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 25967 Entertainment Plaza 18686 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 0.902 Entertainment Plaza 0 Local Park 2 4
12309 12309 12308 {"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.54108], [-119.3954, 36.54111], [-119.39571, 36.54112], [-119.39592, 36.54117], [-119.39611, 36.54126], [-119.39631, 36.5414], [-119.39697, 36.54194], [-119.39713, 36.54205], [-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 25968 Luis Ruiz Park 21590 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 3.603 Luis Ruiz Park 0 Local Park 2 4
12310 12310 12309 {"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 25969 Pamela Lane Pond Park 23378 1086 Dinuba, City of 127 City 2 City Agency 2 http://www.dinuba.org/ City 2 1086 Dinuba, City of 124 City 2 City Agency 2   Tulare 29 1.875 Pamela Lane Pond 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]);