units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
70 rows where ACCESS_TYP = 1, COUNTY = 20 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 4
ACCESS_TYP 1
- Open Access · 70 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
82 | 82 | 81 | {"type": "Polygon", "coordinates": [[[-115.57468, 32.84244], [-115.57468, 32.84326], [-115.5737, 32.84326], [-115.57371, 32.84244], [-115.57468, 32.84244]]]} | Open Access 1 | 263 | Freddie White Park | 19078 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 2.047 | Freddie White Park | 0 | Local Park 2 | 4 | |
401 | 401 | 400 | {"type": "Polygon", "coordinates": [[[-115.52412, 32.9724], [-115.52322, 32.9724], [-115.52322, 32.97086], [-115.52412, 32.97086], [-115.52412, 32.9724]]]} | Open Access 1 | 1270 | Guadalupe Park | 19557 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 3.577 | Guadalupe Park | 0 | Local Park 2 | 4 | |
477 | 477 | 476 | {"type": "Polygon", "coordinates": [[[-115.54149, 32.97992], [-115.54149, 32.98078], [-115.53953, 32.98078], [-115.53954, 32.97992], [-115.54149, 32.97992]]]} | Open Access 1 | 1566 | Gonzalez Park | 19400 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 4.312 | Gonzalez Park | 0 | Local Park 2 | 4 | |
571 | 571 | 570 | {"type": "Polygon", "coordinates": [[[-115.38124, 32.81265], [-115.38119, 32.81269], [-115.38034, 32.81269], [-115.38033, 32.8111], [-115.38123, 32.8111], [-115.38124, 32.81265]]]} | Open Access 1 | 1910 | Holt Park | 20057 | 1139 | Holtville, City of 213 | City 2 | City Agency 2 | http://www.holtville.ca.gov/section.php?id=61 | City 2 | 1139 | Holtville, City of 209 | City 2 | City Agency 2 | Imperial 20 | 3.67 | Holt Park | 0 | Local Park 2 | 4 | |
764 | 764 | 763 | {"type": "Polygon", "coordinates": [[[-115.57217, 32.8486], [-115.57216, 32.8494], [-115.57122, 32.84939], [-115.57122, 32.8486], [-115.57217, 32.8486]]]} | Open Access 1 | 5617 | Eager Park | 18336 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 1.933 | Eager Park | 0 | Local Park 2 | 4 | |
803 | 803 | 802 | {"type": "Polygon", "coordinates": [[[-115.54406, 32.79085], [-115.54196, 32.79085], [-115.54196, 32.78986], [-115.54406, 32.78986], [-115.54406, 32.79085]]]} | Open Access 1 | 5217 | McGee Park | 22034 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 5.333 | McGee Park | 0 | Local Park 2 | 4 | |
1333 | 1333 | 1332 | {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} | Open Access 1 | 7580 | Palo Verde County Park | 23359 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 13.919 | Palo Verde County Park | 0 | Local Park 2 | 4 | |
3229 | 3229 | 3228 | {"type": "Polygon", "coordinates": [[[-115.54648, 32.75841], [-115.54632, 32.75839], [-115.54615, 32.75839], [-115.54607, 32.75841], [-115.54563, 32.7584], [-115.54563, 32.75772], [-115.54595, 32.75773], [-115.54596, 32.75769], [-115.54603, 32.7577], [-115.54609, 32.75769], [-115.5461, 32.75773], [-115.54647, 32.75773], [-115.54648, 32.75841]]]} | Open Access 1 | 48108 | Legacy Park | 32620 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 1.479 | Legacy Park | 0 | Local Park 2 | 4 |
3236 | 3236 | 3235 | {"type": "Polygon", "coordinates": [[[-115.58573, 32.7835], [-115.58573, 32.78513], [-115.58476, 32.78513], [-115.58479, 32.78468], [-115.58479, 32.7835], [-115.58573, 32.7835]]]} | Open Access 1 | 48109 | Wildflower Park | 32621 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 3.973 | Wildflower Park | 0 | Local Park 2 | 4 |
3348 | 3348 | 3347 | {"type": "Polygon", "coordinates": [[[-115.49341, 32.67129], [-115.49223, 32.6713], [-115.49224, 32.66997], [-115.4934, 32.66997], [-115.49341, 32.67129]]]} | Open Access 1 | 30419 | Rockwood Plaza Park | 24539 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.996 | Rockwood Plaza Park | 0 | Local Park 2 | 4 | |
3440 | 3440 | 3439 | {"type": "Polygon", "coordinates": [[[-115.48246, 32.68055], [-115.48244, 32.68268], [-115.48183, 32.68268], [-115.4818, 32.68052], [-115.48243, 32.68051], [-115.48246, 32.68055]]]} | Open Access 1 | 48748 | Meadows Park | 33474 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.51 | Meadows Park | 0 | Local Park 2 | 4 | |
3444 | 3444 | 3443 | {"type": "Polygon", "coordinates": [[[-115.49283, 32.68887], [-115.49278, 32.68897], [-115.49196, 32.68892], [-115.49199, 32.68869], [-115.49221, 32.68849], [-115.49283, 32.68887]]]} | Open Access 1 | 48749 | Robert F. Kennedy Park | 33475 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 0.625 | Robert F. Kennedy Park | 0 | Local Park 2 | 4 | |
3561 | 3561 | 3560 | {"type": "Polygon", "coordinates": [[[-115.5415, 32.73581], [-115.53914, 32.73583], [-115.53914, 32.73493], [-115.53916, 32.7349], [-115.5392, 32.73489], [-115.54145, 32.73486], [-115.54148, 32.73488], [-115.54149, 32.73491], [-115.5415, 32.73581]]]} | Open Access 1 | 28351 | Margarito "Tito" Huerta Jr. Park | 21805 | 2278 | Heber Public Utility District 661 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | Imperial 20 | 5.726 | Margarito "Tito" Huerta Jr. Park | 0 | Local Park 2 | 4 | |
3575 | 3575 | 3574 | {"type": "Polygon", "coordinates": [[[-115.53957, 32.78512], [-115.53661, 32.78511], [-115.53661, 32.78462], [-115.53957, 32.78458], [-115.53957, 32.78512]]]} | Open Access 1 | 29144 | Gomez Park | 19389 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 3.926 | Gomez Park | 0 | Local Park 2 | 4 | |
3894 | 3894 | 3893 | {"type": "Polygon", "coordinates": [[[-115.51739, 33.12589], [-115.51739, 33.12786], [-115.5166, 33.12786], [-115.5166, 33.12588], [-115.51739, 33.12589]]]} | Open Access 1 | 25432 | Calipatria Little League Park/ Radamacher Park | 16731 | 1449 | Calipatria, City of 695 | City 2 | City Agency 2 | http://www.calipatria.com/ | City 2 | 1449 | Calipatria, City of 685 | City 2 | City Agency 2 | Imperial 20 | 3.962 | Calipatria Little League Park/ Radamacher Park | 0 | Local Park 2 | 4 | |
4490 | 4490 | 4489 | {"type": "Polygon", "coordinates": [[[-115.56564, 32.84427], [-115.56515, 32.84427], [-115.56515, 32.84344], [-115.56564, 32.84344], [-115.56564, 32.84427]]]} | Open Access 1 | 5643 | Evans Park | 18756 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 1.035 | Evans Park | 0 | Local Park 2 | 4 | |
4552 | 4552 | 4551 | {"type": "Polygon", "coordinates": [[[-115.51739, 33.12364], [-115.51739, 33.12561], [-115.5166, 33.12561], [-115.5166, 33.12363], [-115.51739, 33.12364]]]} | Open Access 1 | 25433 | Caldwell Park | 16677 | 1449 | Calipatria, City of 695 | City 2 | City Agency 2 | http://www.calipatria.com/ | City 2 | 1449 | Calipatria, City of 685 | City 2 | City Agency 2 | Imperial 20 | 3.955 | Caldwell Park | 0 | Local Park 2 | 4 | |
5121 | 5121 | 5120 | {"type": "Polygon", "coordinates": [[[-115.52025, 32.67254], [-115.52024, 32.67333], [-115.51786, 32.67332], [-115.51784, 32.67254], [-115.52025, 32.67254]]]} | Open Access 1 | 26508 | Nosotros Park | 22908 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 4.815 | Nosotros Park | 0 | Local Park 2 | 4 | |
5232 | 5232 | 5231 | {"type": "Polygon", "coordinates": [[[-115.67682, 32.77663], [-115.67556, 32.77481], [-115.67435, 32.77444], [-115.67435, 32.77433], [-115.67607, 32.77424], [-115.67688, 32.77433], [-115.67741, 32.77427], [-115.68059, 32.77846], [-115.68065, 32.77892], [-115.68081, 32.77894], [-115.68079, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-115.69029, 32.78595], [-115.68677, 32.78484], [-115.68075, 32.78206], [-115.68075, 32.78136], [-115.68028, 32.78091], [-115.67977, 32.7807], [-115.67682, 32.77663]], [[-115.68079, 32.78028], [-115.68077, 32.78028], [-115.68076, 32.78078], [-115.68079, 32.78081], [-115.68079, 32.78028]]]} | Open Access 1 | 48074 | Sunbeam Lake Park | 32576 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam | Imperial 20 | 154.391 | Sunbeam Lake Park | 0 | Local Park 2 | 4 |
5233 | 5233 | 5232 | {"type": "Polygon", "coordinates": [[[-115.69473, 32.7933], [-115.69278, 32.7933], [-115.69278, 32.79285], [-115.69341, 32.79284], [-115.69339, 32.79247], [-115.69472, 32.79247], [-115.69473, 32.7933]]]} | Open Access 1 | 48075 | Robert Bates Memorial Park | 32577 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.seeleywaterdistrict.com/updates/robert-bates-memorial-park-upgrades | Imperial 20 | 3.525 | Robert Bates Memorial Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);