units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where COUNTY = 20 and MNG_AGENCY = 596
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency 23
MNG_AGENCY 1
- Calexico, City of · 23 ✖
ACCESS_TYP 1
- Open Access 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3253 | 3253 | 3252 | {"type": "Polygon", "coordinates": [[[-115.50404, 32.66996], [-115.50403, 32.67085], [-115.50251, 32.67088], [-115.50227, 32.67028], [-115.50227, 32.66996], [-115.50404, 32.66996]]]} | Open Access 1 | 29193 | American Legion Softball Field | 15453 | 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.933 | American Legion Softball Field | 0 | Local Recreation Area 3 | 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 | |
3445 | 3445 | 3444 | {"type": "Polygon", "coordinates": [[[-115.49103, 32.68828], [-115.49059, 32.68816], [-115.48997, 32.68793], [-115.48965, 32.68785], [-115.48947, 32.68784], [-115.48945, 32.68778], [-115.48946, 32.68677], [-115.49041, 32.68677], [-115.49042, 32.6874], [-115.49103, 32.6874], [-115.49103, 32.68828]]]} | Open Access 1 | 48750 | Kennedy Gardens Large | 33476 | 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.152 | Kennedy Gardens Large | None 281 | |||
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 | |
6702 | 6702 | 6701 | {"type": "Polygon", "coordinates": [[[-115.51038, 32.67404], [-115.50945, 32.67403], [-115.50936, 32.674], [-115.50953, 32.67367], [-115.51038, 32.67399], [-115.51038, 32.67404]]]} | Open Access 1 | 30416 | Rio Vista Park | 24390 | 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.53 | Rio Vista Park | 0 | Local Park 2 | 4 | |
7056 | 7056 | 7055 | {"type": "Polygon", "coordinates": [[[-115.48239, 32.66837], [-115.48238, 32.66977], [-115.48154, 32.66977], [-115.48155, 32.66838], [-115.48239, 32.66837]]]} | Open Access 1 | 30417 | Rancho Elegante Field | 24144 | 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.013 | Rancho Elegante Field | 0 | Local Recreation Area 3 | 4 | |
7143 | 7143 | 7142 | {"type": "Polygon", "coordinates": [[[-115.51108, 32.67915], [-115.51108, 32.67942], [-115.50737, 32.67942], [-115.50737, 32.67915], [-115.51108, 32.67915]]]} | Open Access 1 | 34893 | Williams Greenbelt Park | 27562 | 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 | 2.591 | Williams Greenbelt Park | 0 | Local Park 2 | 4 | |
12346 | 12346 | 12345 | {"type": "Polygon", "coordinates": [[[-115.50729, 32.67527], [-115.50728, 32.67704], [-115.50583, 32.67704], [-115.50582, 32.67663], [-115.50535, 32.67663], [-115.50535, 32.67518], [-115.50677, 32.67518], [-115.50704, 32.67524], [-115.50729, 32.67527]]]} | Open Access 1 | 26509 | Rodriguez Park | 24554 | 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 | 8.68 | Rodriguez Park | 0 | Local Park 2 | 4 | |
12374 | 12374 | 12373 | {"type": "Polygon", "coordinates": [[[-115.51124, 32.68437], [-115.5097, 32.68436], [-115.50971, 32.68397], [-115.50976, 32.68386], [-115.50977, 32.68381], [-115.50975, 32.68376], [-115.50971, 32.68372], [-115.50961, 32.68369], [-115.50961, 32.6831], [-115.51116, 32.6831], [-115.51122, 32.68312], [-115.51125, 32.68319], [-115.51124, 32.68437]]]} | Open Access 1 | 26510 | Las Casitas Park | 21046 | 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 | 5.16 | Las Casitas Park | 0 | Local Park 2 | 4 | |
12375 | 12375 | 12374 | {"type": "Polygon", "coordinates": [[[-115.50228, 32.67811], [-115.50131, 32.67812], [-115.50131, 32.67728], [-115.50227, 32.67728], [-115.50228, 32.67811]]]} | Open Access 1 | 26511 | Heber Park | 19789 | 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 | 2.082 | Heber Park | 0 | Local Park 2 | 4 | |
12376 | 12376 | 12375 | {"type": "Polygon", "coordinates": [[[-115.49853, 32.66622], [-115.4981, 32.66622], [-115.4981, 32.66614], [-115.49807, 32.66612], [-115.49765, 32.66611], [-115.49765, 32.66571], [-115.49797, 32.66571], [-115.49821, 32.66584], [-115.49835, 32.66594], [-115.49842, 32.66601], [-115.4985, 32.66613], [-115.49853, 32.66622]]]} | Open Access 1 | 26512 | Border Friendship Park | 16279 | 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.77 | Border Friendship Park | 0 | Local Park 2 | 4 | |
12377 | 12377 | 12376 | {"type": "Polygon", "coordinates": [[[-115.4951, 32.68835], [-115.49502, 32.68837], [-115.49434, 32.68837], [-115.49434, 32.68816], [-115.49426, 32.6881], [-115.49414, 32.6881], [-115.49333, 32.6882], [-115.49332, 32.68849], [-115.49316, 32.68847], [-115.49329, 32.68831], [-115.49329, 32.68821], [-115.493, 32.68811], [-115.49259, 32.6878], [-115.49268, 32.6876], [-115.49399, 32.68757], [-115.49406, 32.68737], [-115.49423, 32.68748], [-115.49405, 32.68769], [-115.49413, 32.68785], [-115.49449, 32.68813], [-115.4951, 32.68835]]]} | Open Access 1 | 26513 | Kennedy Gardens Park | 20600 | 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 | 2.535 | Kennedy Gardens Park | 0 | Local Park 2 | 4 | |
12378 | 12378 | 12377 | {"type": "Polygon", "coordinates": [[[-115.48727, 32.67578], [-115.48625, 32.6758], [-115.48625, 32.67464], [-115.48727, 32.67463], [-115.48727, 32.67578]]]} | Open Access 1 | 26514 | Crummett Park | 17840 | 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.03 | Crummett Park | 0 | Local Park 2 | 4 | |
12379 | 12379 | 12378 | {"type": "Polygon", "coordinates": [[[-115.48306, 32.66602], [-115.48305, 32.66656], [-115.48268, 32.66655], [-115.48269, 32.66605], [-115.48306, 32.66602]]]} | Open Access 1 | 26515 | Cortez Park | 17665 | 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.5 | Cortez Park | 0 | Local Park 2 | 4 | |
12380 | 12380 | 12379 | {"type": "Polygon", "coordinates": [[[-115.48523, 32.67692], [-115.48429, 32.67693], [-115.48429, 32.67653], [-115.48441, 32.67652], [-115.4844, 32.67626], [-115.48472, 32.67626], [-115.48476, 32.67631], [-115.48522, 32.67631], [-115.48523, 32.67692]]]} | Open Access 1 | 26516 | Lioness Park | 21312 | 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 | 1.466 | Lioness Park | 0 | Local Park 2 | 4 | |
12745 | 12745 | 12744 | {"type": "Polygon", "coordinates": [[[-115.48238, 32.67698], [-115.48238, 32.67704], [-115.4816, 32.67704], [-115.48102, 32.67713], [-115.48102, 32.67576], [-115.48238, 32.67576], [-115.48238, 32.67698]]]} | Open Access 1 | 30420 | Villa Santa Fe Park | 27106 | 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.566 | Villa Santa Fe Park | 0 | Local Park 2 | 4 | |
12753 | 12753 | 12752 | {"type": "Polygon", "coordinates": [[[-115.4824, 32.68317], [-115.4824, 32.68418], [-115.48237, 32.68422], [-115.48019, 32.68423], [-115.4802, 32.68316], [-115.4824, 32.68317]]]} | Open Access 1 | 30421 | Joel Riesen Field | 20424 | 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 | 6.015 | Joel Riesen Field | 0 | Local Recreation Area 3 | 4 | |
12862 | 12862 | 12861 | {"type": "Polygon", "coordinates": [[[-115.48658, 32.686], [-115.4865, 32.68606], [-115.48618, 32.68603], [-115.48621, 32.68558], [-115.48631, 32.68558], [-115.48639, 32.68554], [-115.48651, 32.68559], [-115.48658, 32.686]]]} | Open Access 1 | 30422 | Victoria Park | 27083 | 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.428 | Victoria 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]);