units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where COUNTY = 20, DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 | |
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 |
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | 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 | |
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 | |
5576 | 5576 | 5575 | {"type": "Polygon", "coordinates": [[[-115.38799, 32.80773], [-115.38799, 32.80773], [-115.38527, 32.80861], [-115.38529, 32.80805], [-115.38575, 32.80776], [-115.38593, 32.80758], [-115.38606, 32.80752], [-115.38613, 32.80752], [-115.38626, 32.80747], [-115.38633, 32.80732], [-115.38658, 32.80735], [-115.38676, 32.80729], [-115.38696, 32.80727], [-115.3875, 32.80728], [-115.38775, 32.80735], [-115.38787, 32.80744], [-115.38799, 32.80773]]]} | Open Access 1 | 48782 | Earl Walker Park | 33508 | 2436 | Holtville Community Redevelopment Agency 810 | City 2 | City Agency 2 | City 2 | 1139 | Holtville, City of 209 | City 2 | City Agency 2 | http://www.holtville.ca.gov/section.php?id=61 | Imperial 20 | 4.792 | Earl Walker Park | 0 | Local Park 2 | 4 | |
6481 | 6481 | 6480 | {"type": "Polygon", "coordinates": [[[-115.57585, 32.85382], [-115.57585, 32.85465], [-115.57488, 32.85465], [-115.57488, 32.85381], [-115.57585, 32.85382]]]} | Open Access 1 | 2303 | C A Irving Park | 16624 | 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.089 | C A Irving Park | 0 | Local Park 2 | 4 | |
6644 | 6644 | 6643 | {"type": "Polygon", "coordinates": [[[-115.52958, 32.97543], [-115.52929, 32.97631], [-115.52654, 32.97631], [-115.52654, 32.97543], [-115.52958, 32.97543]]]} | Open Access 1 | 4656 | Hinojosa Park | 20003 | 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 | 6.523 | Hinojosa 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]);