units_with_maps

Table actions

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

8 rows where COUNTY = 1, MNG_AGENCY = 600 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Arroyo Grande, City of · 8 ✖

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
3275 3275 3274 {"type": "Polygon", "coordinates": [[[-120.57874, 35.12285], [-120.57868, 35.12291], [-120.57864, 35.12286], [-120.57789, 35.12326], [-120.57772, 35.12304], [-120.57762, 35.12296], [-120.5778, 35.12286], [-120.57841, 35.12275], [-120.57845, 35.12287], [-120.57873, 35.12277], [-120.57874, 35.12285]]]} Open Access 1 48744 Kiwanis Park 33470 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 0.635 Kiwanis Park 0 Local Park 2 4
3534 3534 3533 {"type": "Polygon", "coordinates": [[[-120.60822, 35.11477], [-120.60789, 35.11477], [-120.60766, 35.11474], [-120.60738, 35.11468], [-120.60693, 35.11464], [-120.6007, 35.11463], [-120.60066, 35.1146], [-120.60065, 35.11457], [-120.60063, 35.1127], [-120.60796, 35.11271], [-120.60821, 35.11292], [-120.60822, 35.11477]]]} Open Access 1 28101 Soto Sports Complex 33130 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 36.63 Soto Sports Complex 0 Local Recreation Area 3 4
4294 4294 4293 {"type": "MultiPolygon", "coordinates": [[[[-120.56623, 35.13207], [-120.56587, 35.13226], [-120.56577, 35.13369], [-120.56583, 35.13383], [-120.56555, 35.13367], [-120.56518, 35.13334], [-120.56536, 35.13185], [-120.56516, 35.13179], [-120.56518, 35.13175], [-120.56537, 35.13179], [-120.56539, 35.13144], [-120.56574, 35.13153], [-120.56584, 35.13167], [-120.56623, 35.13207]]], [[[-120.56924, 35.13231], [-120.56897, 35.13297], [-120.5688, 35.13299], [-120.56858, 35.13313], [-120.56822, 35.13349], [-120.56811, 35.1337], [-120.56806, 35.13376], [-120.56793, 35.1337], [-120.56811, 35.13331], [-120.5681, 35.13318], [-120.56805, 35.13302], [-120.56791, 35.13283], [-120.56743, 35.13266], [-120.56727, 35.13258], [-120.56748, 35.13193], [-120.56924, 35.13231]]]]} Open Access 1 45333 Terra de Oro Park 26252 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 7.333 Terra de Oro Park 0 Local Park 2 4
12159 12159 12158 {"type": "Polygon", "coordinates": [[[-120.60711, 35.11657], [-120.60704, 35.11689], [-120.60706, 35.11725], [-120.60696, 35.11734], [-120.60688, 35.11736], [-120.60678, 35.11731], [-120.60667, 35.11716], [-120.60661, 35.11701], [-120.60662, 35.11686], [-120.60667, 35.11672], [-120.60688, 35.11652], [-120.60697, 35.11648], [-120.60701, 35.11649], [-120.60711, 35.11657]]]} Open Access 1 48743 Kingo Park 33469 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 0.756 Kingo Park 0 Local Park 2 4
12405 12405 12404 {"type": "Polygon", "coordinates": [[[-120.58744, 35.13299], [-120.58703, 35.13408], [-120.58703, 35.1342], [-120.58706, 35.13429], [-120.58711, 35.13439], [-120.58718, 35.13446], [-120.58672, 35.13481], [-120.58633, 35.13464], [-120.58594, 35.1345], [-120.58479, 35.13423], [-120.58599, 35.1326], [-120.58744, 35.13299]]]} Open Access 1 27006 Rancho Grande Park 24145 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 8.55 Rancho Grande Park 0 Local Park 2 4
12407 12407 12406 {"type": "Polygon", "coordinates": [[[-120.57814, 35.12144], [-120.57791, 35.12153], [-120.57748, 35.12096], [-120.57813, 35.12143], [-120.57814, 35.12144]]]} Open Access 1 27008 Christmas Tree Island Park 17229 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 0.222 Christmas Tree Island Park 0 Local Park 2 4
12408 12408 12407 {"type": "Polygon", "coordinates": [[[-120.55825, 35.12993], [-120.55762, 35.13046], [-120.55751, 35.13053], [-120.556, 35.12927], [-120.55616, 35.12917], [-120.55683, 35.12853], [-120.55694, 35.12862], [-120.55682, 35.12868], [-120.55676, 35.12888], [-120.5578, 35.12976], [-120.55806, 35.12975], [-120.55825, 35.12993]]]} Open Access 1 27009 Strother Park 25930 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 4.112 Strother Park 0 Local Park 2 4
12409 12409 12408 {"type": "Polygon", "coordinates": [[[-120.57744, 35.12353], [-120.57711, 35.12368], [-120.57694, 35.1235], [-120.57731, 35.1233], [-120.57744, 35.12353]]]} Open Access 1 27011 Village Green 27113 1454 Arroyo Grande, City of 611 City 2 City Agency 2 http://www.arroyogrande.org/ City 2 1454 Arroyo Grande, City of 600 City 2 City Agency 2   San Luis Obispo 1 0.248 Village Green 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]);