units_with_maps

Table actions

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

18 rows where COUNTY = 9 and MNG_AGENCY = 227

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Sanger, City of · 18 ✖

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
650 650 649 {"type": "Polygon", "coordinates": [[[-119.55793, 36.70659], [-119.55742, 36.70665], [-119.55736, 36.70639], [-119.55787, 36.70633], [-119.55793, 36.70659]]]} Open Access 1 5005 Brehler Square 16348 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.342 Brehler Square 0 Local Park 2 4
684 684 683 {"type": "Polygon", "coordinates": [[[-119.55782, 36.71066], [-119.5568, 36.71078], [-119.55654, 36.70916], [-119.55755, 36.70903], [-119.55768, 36.70985], [-119.55776, 36.71025], [-119.55782, 36.71066]]]} Open Access 1 5180 Sanger Park 25029 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 4.119 Sanger Park 0 Local Park 2 4
773 773 772 {"type": "Polygon", "coordinates": [[[-119.5519, 36.71753], [-119.54989, 36.71755], [-119.54989, 36.71592], [-119.5519, 36.7159], [-119.5519, 36.71753]]]} Open Access 1 5034 Cesar Chavez Park 17099 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 8.027 Cesar Chavez Park 0 Local Park 2 4
778 778 777 {"type": "Polygon", "coordinates": [[[-119.56757, 36.70218], [-119.56564, 36.70219], [-119.56545, 36.7022], [-119.56545, 36.70126], [-119.566, 36.70128], [-119.56757, 36.70129], [-119.56757, 36.70218]]]} Open Access 1 5059 Greenwood Park 19488 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 4.693 Greenwood Park 0 Local Park 2 4
1821 1821 1820 {"type": "Polygon", "coordinates": [[[-119.55015, 36.70314], [-119.54831, 36.70337], [-119.54807, 36.70231], [-119.54992, 36.70206], [-119.55015, 36.70314]]]} Open Access 1 13864 Faller Park 18836 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 4.974 Faller Park 0 Local Park 2 4
3307 3307 3306 {"type": "Polygon", "coordinates": [[[-119.55896, 36.70194], [-119.55845, 36.702], [-119.55836, 36.70146], [-119.55886, 36.7014], [-119.55896, 36.70194]]]} Open Access 1 48237 Galoostian Park 32795 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.676 Galoostian Park 0 Local Park 2 4
3323 3323 3322 {"type": "Polygon", "coordinates": [[[-119.55823, 36.70605], [-119.55806, 36.70607], [-119.55799, 36.70574], [-119.55816, 36.70572], [-119.55823, 36.70605]]]} Open Access 1 48241 Sam Gutierrez Park 32799 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.145 Sam Gutierrez Park 0 Local Park 2 4
4317 4317 4316 {"type": "Polygon", "coordinates": [[[-119.56205, 36.69122], [-119.56182, 36.69155], [-119.56176, 36.69169], [-119.56172, 36.69187], [-119.56172, 36.69212], [-119.56167, 36.69216], [-119.56118, 36.69217], [-119.56117, 36.69118], [-119.56202, 36.69118], [-119.56205, 36.69122]]]} Open Access 1 48247 Catherine Park 32810 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 1.557 Catherine Park 0 Local Park 2 4
5267 5267 5266 {"type": "Polygon", "coordinates": [[[-119.57202, 36.71036], [-119.572, 36.71146], [-119.56979, 36.71145], [-119.56979, 36.71118], [-119.57163, 36.71036], [-119.57202, 36.71036]]]} Open Access 1 5076 Jenni Park 20388 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 4.105 Jenni Park 0 Local Park 2 4
5963 5963 5962 {"type": "Polygon", "coordinates": [[[-119.5626, 36.70623], [-119.56221, 36.70623], [-119.56221, 36.70595], [-119.5626, 36.70595], [-119.5626, 36.70623]]]} Open Access 1 48245 Civic Center Park 32800 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.261 Civic Ctr. Park 0 Local Park 2 4
6747 6747 6746 {"type": "Polygon", "coordinates": [[[-119.54741, 36.69454], [-119.54701, 36.6948], [-119.54683, 36.69498], [-119.54676, 36.6951], [-119.54671, 36.69523], [-119.54669, 36.69535], [-119.5467, 36.69551], [-119.54537, 36.69551], [-119.54538, 36.69359], [-119.54672, 36.69359], [-119.54669, 36.69231], [-119.54738, 36.69231], [-119.54741, 36.69454]]]} Open Access 1 5093 John F Kennedy Park 20436 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 10.475 John F Kennedy Park 0 Local Park 2 4
6752 6752 6751 {"type": "Polygon", "coordinates": [[[-119.56084, 36.69569], [-119.56077, 36.69571], [-119.55876, 36.6957], [-119.55876, 36.69465], [-119.56081, 36.69468], [-119.56084, 36.69569]]]} Open Access 1 5117 Lincoln Park 21271 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 5.283 Lincoln Park 0 Local Park 2 4
9301 9301 9300 {"type": "Polygon", "coordinates": [[[-119.57408, 36.69451], [-119.57404, 36.69586], [-119.57131, 36.69585], [-119.5713, 36.69449], [-119.57408, 36.69451]]]} Open Access 1 15497 Rotary Park 24695 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 9.129 Rotary Park 0 Local Park 2 4
11511 11511 11510 {"type": "Polygon", "coordinates": [[[-119.57971, 36.70417], [-119.57968, 36.7042], [-119.57953, 36.70418], [-119.57918, 36.70408], [-119.57894, 36.70405], [-119.57891, 36.70402], [-119.57891, 36.7038], [-119.5797, 36.70379], [-119.57971, 36.70417]]]} Open Access 1 48215 Audry Park 32755 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.636 Audry Park 0 Local Park 2 4
11513 11513 11512 {"type": "Polygon", "coordinates": [[[-119.54752, 36.70767], [-119.54752, 36.70767], [-119.54749, 36.70896], [-119.54747, 36.70878], [-119.54743, 36.70866], [-119.54738, 36.70854], [-119.54729, 36.70842], [-119.54713, 36.70825], [-119.54676, 36.70799], [-119.54658, 36.70779], [-119.54752, 36.70767]]]} Open Access 1 48216 Sanger Skate Park 32756 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2 https://www.ci.sanger.ca.us/Facilities/Facility/Details/Sanger-Skate-Park-11 Fresno 9 1.139 Sanger Skate Park 0 Local Recreation Area 3 4
11533 11533 11532 {"type": "Polygon", "coordinates": [[[-119.54486, 36.70648], [-119.54482, 36.70651], [-119.54449, 36.70651], [-119.54409, 36.70657], [-119.54394, 36.70635], [-119.54438, 36.70628], [-119.54482, 36.70626], [-119.54486, 36.70648]]]} Open Access 1 48238 Medrano Park 33385 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.484 Medrano Park 0 Local Park 2 4
11535 11535 11534 {"type": "Polygon", "coordinates": [[[-119.55396, 36.70525], [-119.55347, 36.70532], [-119.55338, 36.7049], [-119.55387, 36.70483], [-119.55396, 36.70525]]]} Open Access 1 48239 Sanger Youth Center 32797 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 0.522 Sanger Youth Ctr. 0 Local Recreation Area 3 4
13367 13367 13366 {"type": "Polygon", "coordinates": [[[-119.56516, 36.71472], [-119.56512, 36.71475], [-119.56462, 36.71475], [-119.56419, 36.71469], [-119.56403, 36.71468], [-119.56388, 36.7147], [-119.56374, 36.71474], [-119.56358, 36.71482], [-119.56175, 36.71607], [-119.56161, 36.71611], [-119.5616, 36.7161], [-119.56505, 36.71374], [-119.56506, 36.71397], [-119.56515, 36.71397], [-119.56516, 36.71472]]]} Open Access 1 35451 Sanger holding 1 25028 1315 Sanger, City of 231 City 2 City Agency 2 http://www.ci.sanger.ca.us/parks-rec.asp City 2 1315 Sanger, City of 227 City 2 City Agency 2   Fresno 9 2.274 Sanger holding 1 0 Local Other or Unknown 14 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]);