units_with_maps

Table actions

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

5 rows where COUNTY = 14, DES_TP = 3 and MNG_AGENCY = 452

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Gonzales, City of · 5 ✖

DES_TP 1

  • Local Recreation Area · 5 ✖

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
4912 4912 4911 {"type": "Polygon", "coordinates": [[[-121.43969, 36.50708], [-121.43926, 36.50741], [-121.4391, 36.50716], [-121.43964, 36.50699], [-121.43969, 36.50708]]]} Open Access 1 48012 Gonzales Open Space 32441 1122 Gonzales, City of 458 City 2 City Agency 2 http://www.ci.gonzales.ca.us/parks-and-facilities.php City 2 1122 Gonzales, City of 452 City 2 City Agency 2 https://gonzalesca.gov/services/recreation/parks-and-facilities Monterey 14 0.264 Gonzales OS 0 Local Recreation Area 3 4
11172 11172 11171 {"type": "Polygon", "coordinates": [[[-121.44034, 36.50658], [-121.43969, 36.50708], [-121.43963, 36.50699], [-121.4391, 36.50716], [-121.43901, 36.50699], [-121.43895, 36.50682], [-121.43983, 36.50615], [-121.44034, 36.50658]]]} Open Access 1 48011 Gonzales Skate Park 32440 1122 Gonzales, City of 458 City 2 City Agency 2 http://www.ci.gonzales.ca.us/parks-and-facilities.php City 2 1122 Gonzales, City of 452 City 2 City Agency 2 https://gonzalesca.gov/services/recreation/parks-and-facilities Monterey 14 1.749 Gonzales Skate Park 0 Local Recreation Area 3 4
11173 11173 11172 {"type": "Polygon", "coordinates": [[[-121.45022, 36.52464], [-121.44796, 36.52635], [-121.44766, 36.5261], [-121.44786, 36.52605], [-121.4486, 36.52549], [-121.44879, 36.52532], [-121.44888, 36.52519], [-121.44891, 36.5251], [-121.44892, 36.52502], [-121.44893, 36.52492], [-121.44889, 36.52465], [-121.44871, 36.52387], [-121.44804, 36.52224], [-121.44781, 36.52196], [-121.4481, 36.52194], [-121.44855, 36.52235], [-121.44874, 36.52277], [-121.44934, 36.52335], [-121.44943, 36.52347], [-121.44946, 36.52384], [-121.44951, 36.52401], [-121.4496, 36.52418], [-121.44972, 36.52434], [-121.44995, 36.52451], [-121.45022, 36.52464]]]} Open Access 1 48014 Canyon Creek Park & Tot Lot 32443 1122 Gonzales, City of 458 City 2 City Agency 2 http://www.ci.gonzales.ca.us/parks-and-facilities.php City 2 1122 Gonzales, City of 452 City 2 City Agency 2 https://gonzalesca.gov/services/recreation/parks-and-facilities Monterey 14 7.244 Canyon Creek Park & Tot Lot 0 Local Recreation Area 3 4
11175 11175 11174 {"type": "Polygon", "coordinates": [[[-121.44046, 36.50847], [-121.44022, 36.50866], [-121.43992, 36.50833], [-121.43926, 36.50741], [-121.44005, 36.5068], [-121.44003, 36.5072], [-121.4403, 36.50798], [-121.44023, 36.50804], [-121.44046, 36.50847]]]} Open Access 1 48013 Gonzales Community Pool & Open Space 32442 1122 Gonzales, City of 458 City 2 City Agency 2 http://www.ci.gonzales.ca.us/parks-and-facilities.php City 2 1122 Gonzales, City of 452 City 2 City Agency 2 https://gonzalesca.gov/services/recreation/parks-and-facilities Monterey 14 2.285 Gonzales Community Pool & OS 0 Local Recreation Area 3 4
11177 11177 11176 {"type": "Polygon", "coordinates": [[[-121.43838, 36.50656], [-121.43813, 36.50675], [-121.43795, 36.5066], [-121.43784, 36.50649], [-121.4377, 36.5061], [-121.43803, 36.50603], [-121.43813, 36.50635], [-121.43838, 36.50656]]]} Open Access 1 48010 Toots Vosti Memorial Recreation Center 32439 1122 Gonzales, City of 458 City 2 City Agency 2 http://www.ci.gonzales.ca.us/parks-and-facilities.php City 2 1122 Gonzales, City of 452 City 2 City Agency 2 https://gonzalesca.gov/services/recreation/parks-and-facilities Monterey 14 0.576 Toots Vosti Memorial Rec. Ctr. 0 Local Recreation Area 3 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]);