units_with_maps

Table actions

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

8 rows where COUNTY = 29, DES_TP = 2 and MNG_AGENCY = 126

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Exeter, City of · 8 ✖

DES_TP 1

  • Local Park · 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
321 321 320 {"type": "Polygon", "coordinates": [[[-119.13639, 36.29924], [-119.13605, 36.29935], [-119.13609, 36.29885], [-119.13612, 36.2988], [-119.13639, 36.29924]]]} Open Access 1 1102 Rose Garden Park 24609 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.24 Rose Garden Park 0 Local Park 2 4
375 375 374 {"type": "Polygon", "coordinates": [[[-119.14513, 36.29259], [-119.14488, 36.29215], [-119.14512, 36.29206], [-119.14512, 36.29206], [-119.14513, 36.29259]]]} Open Access 1 1107 Schelling Park 25182 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.159 Schelling Park 0 Local Park 2 4
3501 3501 3500 {"type": "Polygon", "coordinates": [[[-119.15405, 36.28292], [-119.15402, 36.28378], [-119.154, 36.28381], [-119.15397, 36.28382], [-119.1536, 36.28384], [-119.15339, 36.28389], [-119.15291, 36.28409], [-119.15238, 36.28439], [-119.15231, 36.28439], [-119.15223, 36.28438], [-119.15214, 36.28431], [-119.15212, 36.28424], [-119.15214, 36.28415], [-119.15247, 36.28379], [-119.15262, 36.28359], [-119.15273, 36.2834], [-119.15277, 36.28326], [-119.15278, 36.28291], [-119.15281, 36.28287], [-119.15284, 36.28286], [-119.15398, 36.28287], [-119.15403, 36.28289], [-119.15405, 36.28292]]]} Open Access 1 25965 Unger Park 26654 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 4.139 Unger Park 0 Local Park 2 4
6105 6105 6104 {"type": "MultiPolygon", "coordinates": [[[[-119.14509, 36.29642], [-119.14504, 36.29714], [-119.14485, 36.29711], [-119.14467, 36.29705], [-119.1445, 36.29691], [-119.14436, 36.29668], [-119.14509, 36.29642]]], [[[-119.14507, 36.2973], [-119.14507, 36.2973], [-119.14505, 36.29811], [-119.14489, 36.29781], [-119.14499, 36.29776], [-119.14472, 36.2973], [-119.14507, 36.2973]]]]} Open Access 1 1068 Brickhouse Park 16374 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 1.103 Brickhouse Park 0 Local Park 2 4
6119 6119 6118 {"type": "MultiPolygon", "coordinates": [[[[-119.13766, 36.29738], [-119.13719, 36.29754], [-119.137, 36.2972], [-119.13758, 36.29722], [-119.13766, 36.29738]]], [[[-119.13809, 36.29723], [-119.13774, 36.29735], [-119.13767, 36.29721], [-119.13767, 36.29721], [-119.13809, 36.29723]]]]} Open Access 1 1089 Joyner Park 20511 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.418 Joyner Park 0 Local Park 2 4
6122 6122 6121 {"type": "Polygon", "coordinates": [[[-119.14066, 36.29626], [-119.14043, 36.29634], [-119.14029, 36.2961], [-119.14007, 36.29618], [-119.14, 36.29606], [-119.14046, 36.29589], [-119.14066, 36.29626]]]} Open Access 1 1093 Mixture Park 22334 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.336 Mixture Park 0 Local Park 2 4
6128 6128 6127 {"type": "Polygon", "coordinates": [[[-119.1364, 36.29781], [-119.13612, 36.29792], [-119.13613, 36.29737], [-119.1364, 36.29781], [-119.1364, 36.29781]]]} Open Access 1 1111 Water Tower Park 27297 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 0.193 Water Tower Park 0 Local Park 2 4
12323 12323 12322 {"type": "Polygon", "coordinates": [[[-119.15477, 36.30086], [-119.15469, 36.30203], [-119.15456, 36.30314], [-119.15421, 36.30314], [-119.15375, 36.30313], [-119.15371, 36.30308], [-119.15387, 36.30084], [-119.15477, 36.30086]]]} Open Access 1 25986 Schroth Park 25195 1103 Exeter, City of 129 City 2 City Agency 2 http://www.cityofexeter.com/ City 2 1103 Exeter, City of 126 City 2 City Agency 2   Tulare 29 5.011 Schroth 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]);