units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
70 rows where MNG_AGENCY = 117 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14843 | 14843 | 14842 | {"type": "Polygon", "coordinates": [[[-117.09107, 32.61913], [-117.09075, 32.61922], [-117.09068, 32.61905], [-117.091, 32.61896], [-117.09107, 32.61913]]]} | Open Access 1 | 45343 | Lancerlot Park | 21000 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/lancerlot-park | San Diego 4 | 0.155 | Lancerlot Park | 0 | Local Park 2 | 4 |
7699 | 7699 | 7698 | {"type": "Polygon", "coordinates": [[[-117.05534, 32.59767], [-117.05536, 32.59782], [-117.05532, 32.59786], [-117.05497, 32.59788], [-117.05497, 32.59767], [-117.05534, 32.59767]]]} | Open Access 1 | 7773 | Holiday Estates II Park | 20028 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-ii-park | San Diego 4 | 0.194 | Holiday Estates II Park | 0 | Local Park 2 | 4 |
7717 | 7717 | 7716 | {"type": "Polygon", "coordinates": [[[-117.05366, 32.59768], [-117.05361, 32.59768], [-117.05329, 32.59759], [-117.05329, 32.59744], [-117.0533, 32.59742], [-117.05335, 32.59739], [-117.05366, 32.59738], [-117.05366, 32.59768]]]} | Open Access 1 | 7832 | Holiday Estates I Park | 30009 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-i-park | San Diego 4 | 0.243 | Holiday Estates I Park | 0 | Local Park 2 | 4 |
7719 | 7719 | 7718 | {"type": "Polygon", "coordinates": [[[-117.05519, 32.60397], [-117.05513, 32.60401], [-117.0551, 32.60406], [-117.0551, 32.60413], [-117.05514, 32.60418], [-117.05488, 32.60426], [-117.05479, 32.60407], [-117.05481, 32.60406], [-117.05471, 32.6038], [-117.05489, 32.60376], [-117.055, 32.60402], [-117.05519, 32.60397]]]} | Open Access 1 | 7844 | Sherwood Park | 25399 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sherwood-park | San Diego 4 | 0.291 | Sherwood Park | 0 | Local Park 2 | 4 |
16088 | 16088 | 16087 | {"type": "Polygon", "coordinates": [[[-117.06918, 32.64875], [-117.06908, 32.64878], [-117.06907, 32.6488], [-117.06875, 32.64877], [-117.06877, 32.64866], [-117.06873, 32.64853], [-117.06906, 32.64844], [-117.06918, 32.64875]]]} | Open Access 1 | 45190 | Chula Vista Open Space | 17242 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 0.292 | Chula Vista OS | 0 | Local Recreation Area 3 | 4 | |
7409 | 7409 | 7408 | {"type": "Polygon", "coordinates": [[[-116.98173, 32.65204], [-116.98153, 32.65223], [-116.98135, 32.65208], [-116.98086, 32.652], [-116.98086, 32.65186], [-116.9809, 32.65183], [-116.98124, 32.65183], [-116.98138, 32.65184], [-116.98156, 32.65191], [-116.98173, 32.65204]]]} | Open Access 1 | 7795 | Mini Park | 22266 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 0.478 | MP | 0 | Local Park 2 | 4 | |
3552 | 3552 | 3551 | {"type": "Polygon", "coordinates": [[[-117.05544, 32.59946], [-117.05505, 32.59946], [-117.05504, 32.59979], [-117.05461, 32.59966], [-117.05462, 32.59923], [-117.05469, 32.59919], [-117.05504, 32.59919], [-117.05505, 32.59938], [-117.05544, 32.59939], [-117.05544, 32.59946]]]} | Open Access 1 | 7710 | Connoley Park | 17592 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/connoley-park | San Diego 4 | 0.668 | Connoley Park | 0 | Local Park 2 | 4 |
14603 | 14603 | 14602 | {"type": "Polygon", "coordinates": [[[-117.00274, 32.63678], [-117.00237, 32.63691], [-117.0021, 32.63708], [-117.00207, 32.63715], [-117.00196, 32.63715], [-117.0019, 32.63717], [-117.00187, 32.63722], [-117.00178, 32.63718], [-117.00147, 32.63726], [-117.00139, 32.63705], [-117.00171, 32.63697], [-117.00176, 32.6368], [-117.00183, 32.63678], [-117.00193, 32.63693], [-117.002, 32.63695], [-117.00263, 32.6366], [-117.00274, 32.63678]]]} | Open Access 1 | 44824 | Rancho Del Rey Finger | 24139 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | San Diego 4 | 0.747 | Rancho Del Rey Finger | None 1246 | ||
533 | 533 | 532 | {"type": "Polygon", "coordinates": [[[-117.10061, 32.63666], [-117.10052, 32.6367], [-117.1004, 32.63657], [-117.10016, 32.63639], [-117.0999, 32.63627], [-117.09961, 32.63619], [-117.0994, 32.63601], [-117.09949, 32.63592], [-117.10024, 32.63571], [-117.10061, 32.63666]]]} | Open Access 1 | 2423 | Bay Boulevard Park | 30005 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bay-boulevard | San Diego 4 | 1.27 | Bay Boulevard Park | 0 | Local Park 2 | 4 |
7708 | 7708 | 7707 | {"type": "Polygon", "coordinates": [[[-117.03368, 32.63514], [-117.03287, 32.63536], [-117.0321, 32.63482], [-117.03214, 32.63476], [-117.03243, 32.6349], [-117.03266, 32.63458], [-117.03359, 32.63505], [-117.03368, 32.63514]]]} | Open Access 1 | 7772 | Undeveloped Park | 26653 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 1.435 | Undeveloped Park | 0 | Local Park 2 | 4 | |
1354 | 1354 | 1353 | {"type": "Polygon", "coordinates": [[[-117.07857, 32.64156], [-117.07788, 32.64174], [-117.07759, 32.64098], [-117.07826, 32.64079], [-117.07857, 32.64156]]]} | Open Access 1 | 7824 | Norman Park | 22798 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/norman-park | San Diego 4 | 1.486 | Norman Park | 0 | Local Park 2 | 4 |
6761 | 6761 | 6760 | {"type": "Polygon", "coordinates": [[[-117.04643, 32.63539], [-117.04591, 32.63554], [-117.04554, 32.63452], [-117.04553, 32.63446], [-117.04616, 32.63447], [-117.04643, 32.63539]]]} | Open Access 1 | 5199 | Gayle L. McCandliss Park | 30008 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/gayle-l-mccandliss-park | San Diego 4 | 1.542 | Gayle L. McCandliss Park | 0 | Local Park 2 | 4 |
14598 | 14598 | 14597 | {"type": "Polygon", "coordinates": [[[-116.98456, 32.63845], [-116.98455, 32.63849], [-116.98452, 32.63851], [-116.98444, 32.63854], [-116.98433, 32.63855], [-116.98428, 32.63857], [-116.98425, 32.63864], [-116.98427, 32.63871], [-116.9842, 32.63876], [-116.9841, 32.63879], [-116.984, 32.63879], [-116.98397, 32.63872], [-116.98392, 32.63869], [-116.98387, 32.63868], [-116.98381, 32.6387], [-116.98374, 32.63876], [-116.98358, 32.63881], [-116.98353, 32.63879], [-116.98341, 32.63835], [-116.9834, 32.63819], [-116.98335, 32.6381], [-116.98379, 32.63786], [-116.98375, 32.63775], [-116.9838, 32.63774], [-116.9841, 32.63775], [-116.98413, 32.63785], [-116.98426, 32.638], [-116.98456, 32.63845]]]} | Open Access 1 | 44823 | Breezewood Park | 16347 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/breezewood-park | San Diego 4 | 2.13 | Breezewood Park | 0 | Local Park 2 | 4 |
7720 | 7720 | 7719 | {"type": "Polygon", "coordinates": [[[-116.97799, 32.6467], [-116.97786, 32.64678], [-116.97765, 32.64685], [-116.97688, 32.64697], [-116.97686, 32.64694], [-116.97688, 32.64646], [-116.97685, 32.6463], [-116.97678, 32.6461], [-116.9764, 32.6454], [-116.97634, 32.64518], [-116.97799, 32.6467]]]} | Open Access 1 | 7876 | Pedestrian Park | 23560 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 2.453 | Pedestrian Park | 0 | Local Park 2 | 4 | |
7677 | 7677 | 7676 | {"type": "Polygon", "coordinates": [[[-117.04162, 32.61285], [-117.04073, 32.61308], [-117.03974, 32.61333], [-117.04108, 32.612], [-117.04127, 32.61196], [-117.04162, 32.61285]]]} | Open Access 1 | 7601 | Palomar Park | 23364 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/palomar-park | San Diego 4 | 2.642 | Palomar Park | 0 | Local Park 2 | 4 |
16036 | 16036 | 16035 | {"type": "Polygon", "coordinates": [[[-117.03382, 32.61286], [-117.03349, 32.6137], [-117.03347, 32.61384], [-117.03347, 32.61412], [-117.03353, 32.61451], [-117.03347, 32.61457], [-117.033, 32.61462], [-117.0322, 32.61478], [-117.03167, 32.61487], [-117.03113, 32.61491], [-117.03111, 32.61487], [-117.03317, 32.61427], [-117.03268, 32.61309], [-117.03299, 32.61322], [-117.0333, 32.61315], [-117.03363, 32.6128], [-117.03382, 32.61286]]]} | Open Access 1 | 45160 | Greg Rogers Open Space | 19497 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 3.286 | Greg Rogers OS | 0 | Local Recreation Area 3 | 4 | |
7702 | 7702 | 7701 | {"type": "Polygon", "coordinates": [[[-117.00515, 32.63973], [-117.00476, 32.63984], [-117.00456, 32.63937], [-117.00446, 32.63933], [-117.00448, 32.63928], [-117.00448, 32.63921], [-117.00446, 32.63916], [-117.00436, 32.63903], [-117.00429, 32.63883], [-117.00427, 32.63865], [-117.00424, 32.63859], [-117.00416, 32.63852], [-117.00424, 32.63842], [-117.00404, 32.63797], [-117.00397, 32.63795], [-117.00399, 32.63788], [-117.00396, 32.63782], [-117.00386, 32.63776], [-117.00377, 32.63777], [-117.00367, 32.63752], [-117.00298, 32.6374], [-117.00298, 32.63737], [-117.00399, 32.63755], [-117.00407, 32.63752], [-117.0044, 32.63734], [-117.00451, 32.63759], [-117.00455, 32.63761], [-117.00452, 32.63768], [-117.00452, 32.63776], [-117.00455, 32.63782], [-117.00465, 32.63793], [-117.00471, 32.63815], [-117.00471, 32.63828], [-117.00475, 32.63835], [-117.00482, 32.6384], [-117.00476, 32.63855], [-117.00494, 32.63895], [-117.00486, 32.63899], [-117.00483, 32.63904], [-117.00483, 32.63912], [-117.00486, 32.63917], [-117.00495, 32.6392], [-117.00515, 32.63973]]]} | Open Access 1 | 7737 | Rancho del Rey Park | 30012 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | San Diego 4 | 3.404 | Rancho del Rey Park | 0 | Local Park 2 | 4 |
7703 | 7703 | 7702 | {"type": "Polygon", "coordinates": [[[-117.03127, 32.62184], [-117.03031, 32.62284], [-117.02944, 32.62221], [-117.02945, 32.62215], [-117.02956, 32.62203], [-117.02963, 32.62189], [-117.02967, 32.62175], [-117.02967, 32.62166], [-117.0297, 32.62163], [-117.02991, 32.62159], [-117.03006, 32.62153], [-117.03031, 32.62176], [-117.03067, 32.6214], [-117.03127, 32.62184]]]} | Open Access 1 | 7763 | Sunbow Park | 25985 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sunbow-park | San Diego 4 | 3.642 | Sunbow Park | 0 | Local Park 2 | 4 |
4194 | 4194 | 4193 | {"type": "Polygon", "coordinates": [[[-117.06893, 32.60036], [-117.06893, 32.60105], [-117.06677, 32.60104], [-117.06677, 32.60035], [-117.06893, 32.60036]]]} | Open Access 1 | 47683 | Orange Park | 31420 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/orange-park | San Diego 4 | 3.796 | Orange Park | 0 | Local Park 2 | 4 |
7712 | 7712 | 7711 | {"type": "Polygon", "coordinates": [[[-117.06959, 32.6096], [-117.06886, 32.6098], [-117.06833, 32.60844], [-117.06839, 32.60841], [-117.06829, 32.60816], [-117.06911, 32.60793], [-117.06953, 32.60903], [-117.0694, 32.60909], [-117.06959, 32.6096]]]} | Open Access 1 | 7791 | Lauderbach Park | 21083 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/lauderbach-park | San Diego 4 | 3.819 | Lauderbach 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]);