units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 42 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME, YR_EST, GAP_STS
DES_TP 14
- Local Other or Unknown 21
- Local Park 19
- Local Recreation Area 6
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 57
MNG_AGENCY 1
- Encinitas, City of · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13419 | 13419 | 13418 | {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} | Open Access 1 | 35537 | Encinitas holding 36 | 18658 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.044 | Encinitas holding 36 | 0 | Local Other or Unknown 14 | 4 | |
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
13552 | 13552 | 13551 | {"type": "Polygon", "coordinates": [[[-117.28549, 33.07638], [-117.28536, 33.07638], [-117.28543, 33.07582], [-117.28549, 33.07638], [-117.28549, 33.07638]]]} | Open Access 1 | 35868 | Encinitas holding 17 | 18648 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.092 | Encinitas holding 17 | 0 | Local Other or Unknown 14 | 4 | |
6149 | 6149 | 6148 | {"type": "Polygon", "coordinates": [[[-117.31046, 33.07653], [-117.30964, 33.07651], [-117.30962, 33.07645], [-117.31043, 33.07647], [-117.31046, 33.07653]]]} | Open Access 1 | 1160 | Grandview | 19428 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.131 | Grandview | None 495 | ||
2321 | 2321 | 2320 | {"type": "Polygon", "coordinates": [[[-117.30275, 33.06426], [-117.30274, 33.0643], [-117.3027, 33.06432], [-117.30238, 33.06438], [-117.30234, 33.06435], [-117.30232, 33.06423], [-117.30268, 33.06416], [-117.30273, 33.06419], [-117.30275, 33.06426]]]} | Open Access 1 | 17033 | Leucadia Roadside Park | 21187 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 0.165 | Leucadia Roadside Park | 0 | Local Park 2 | 4 |
8136 | 8136 | 8135 | {"type": "Polygon", "coordinates": [[[-117.2968, 33.04049], [-117.29618, 33.04056], [-117.29616, 33.04042], [-117.29669, 33.04039], [-117.2968, 33.04049]]]} | Open Access 1 | 12319 | H Street Viewpoint | 19582 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.181 | H Street Viewpoint | None 678 | ||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} | Open Access 1 | 709 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.184 | Swami's Bluff Parcels | None 27 | ||
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | 35531 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.21 | 0 | Local Other or Unknown 14 | 4 | ||
8140 | 8140 | 8139 | {"type": "Polygon", "coordinates": [[[-117.29635, 33.03919], [-117.2957, 33.03926], [-117.29568, 33.03904], [-117.29629, 33.03898], [-117.29635, 33.03919]]]} | Open Access 1 | 12335 | I Street Viewpoint | 20169 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.357 | I Street Viewpoint | None 679 | ||
13417 | 13417 | 13416 | {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07542], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} | Open Access 1 | 35529 | Encinitas holding 31 | 18657 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.384 | Encinitas holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13553 | 13553 | 13552 | {"type": "Polygon", "coordinates": [[[-117.25074, 33.0247], [-117.25039, 33.02472], [-117.25041, 33.02454], [-117.25054, 33.02417], [-117.25072, 33.02415], [-117.25075, 33.02464], [-117.25074, 33.0247]]]} | Open Access 1 | 35869 | Encinitas holding 18 | 18649 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.403 | Encinitas holding 18 | 0 | Local Other or Unknown 14 | 4 | |
7949 | 7949 | 7948 | {"type": "Polygon", "coordinates": [[[-117.29603, 33.03791], [-117.29483, 33.03802], [-117.29481, 33.0378], [-117.29594, 33.0377], [-117.29603, 33.03791]]]} | Open Access 1 | 12338 | J Street Viewpoint | 20290 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.676 | J Street Viewpoint | None 661 | ||
13424 | 13424 | 13423 | {"type": "Polygon", "coordinates": [[[-117.25303, 33.03045], [-117.25301, 33.031], [-117.25251, 33.03099], [-117.25221, 33.03096], [-117.25225, 33.0308], [-117.25224, 33.03072], [-117.25259, 33.0307], [-117.25258, 33.03044], [-117.25299, 33.03041], [-117.25303, 33.03045]]]} | Open Access 1 | 35543 | Encinitas holding 40 | 18660 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.88 | Encinitas holding 40 | 0 | Local Other or Unknown 14 | 4 | |
6681 | 6681 | 6680 | {"type": "Polygon", "coordinates": [[[-117.29165, 33.03944], [-117.29132, 33.03948], [-117.29118, 33.03833], [-117.29147, 33.03831], [-117.29165, 33.03944]]]} | Open Access 1 | 4957 | Mildred Macpherson Mini-Park | 22214 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 0.914 | Mildred Macpherson Mini-Park | 0 | Local Park 2 | 4 |
9275 | 9275 | 9274 | {"type": "Polygon", "coordinates": [[[-117.23595, 33.05083], [-117.23587, 33.05124], [-117.23545, 33.05139], [-117.23553, 33.05113], [-117.23514, 33.05103], [-117.23532, 33.05054], [-117.23565, 33.05063], [-117.23571, 33.05071], [-117.23576, 33.05074], [-117.2359, 33.05074], [-117.23595, 33.05083]]]} | Open Access 1 | 15445 | Wiro Park | 27660 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 1.035 | Wiro Park | 0 | Local Park 2 | 4 |
2174 | 2174 | 2173 | {"type": "Polygon", "coordinates": [[[-117.30158, 33.05598], [-117.30134, 33.05605], [-117.30127, 33.05586], [-117.30122, 33.05575], [-117.30097, 33.05535], [-117.30078, 33.05482], [-117.30076, 33.05468], [-117.30103, 33.05461], [-117.30138, 33.05554], [-117.30158, 33.05598]]]} | Open Access 1 | 16270 | Stone Steps Beach | 25877 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 1.07 | Stone Steps Beach | 0 | Local Park 2 | 4 |
13520 | 13520 | 13519 | {"type": "Polygon", "coordinates": [[[-117.25124, 33.02661], [-117.2512, 33.02671], [-117.25099, 33.02698], [-117.25086, 33.02705], [-117.25075, 33.02708], [-117.25046, 33.02687], [-117.25028, 33.0268], [-117.25038, 33.0265], [-117.25079, 33.02648], [-117.2509, 33.02644], [-117.25108, 33.02634], [-117.25123, 33.02631], [-117.25125, 33.02646], [-117.25124, 33.02661]]]} | Open Access 1 | 35815 | Encinitas holding 27 | 18654 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.158 | Encinitas holding 27 | 0 | Local Other or Unknown 14 | 4 | |
12549 | 12549 | 12548 | {"type": "Polygon", "coordinates": [[[-117.27771, 33.05534], [-117.27694, 33.05549], [-117.27667, 33.05524], [-117.27649, 33.05488], [-117.27664, 33.05484], [-117.27689, 33.05484], [-117.27712, 33.0549], [-117.27729, 33.05498], [-117.27753, 33.05517], [-117.27771, 33.05526], [-117.27771, 33.05534]]]} | Open Access 1 | 36585 | Las Verdes Park | 28588 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 1.212 | Las Verdes Park | 0 | Local Park 2 | 4 |
13506 | 13506 | 13505 | {"type": "Polygon", "coordinates": [[[-117.2513, 33.02732], [-117.25128, 33.02869], [-117.25071, 33.02869], [-117.25069, 33.02867], [-117.25069, 33.02864], [-117.25071, 33.02859], [-117.25095, 33.02831], [-117.25101, 33.0282], [-117.25103, 33.02811], [-117.251, 33.02801], [-117.25087, 33.02786], [-117.25082, 33.02777], [-117.25085, 33.02767], [-117.25083, 33.02746], [-117.25096, 33.0274], [-117.2513, 33.02732]]]} | Open Access 1 | 35789 | Encinitas holding 11 | 18646 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.401 | Encinitas holding 11 | 0 | Local Other or Unknown 14 | 4 | |
5076 | 5076 | 5075 | {"type": "Polygon", "coordinates": [[[-117.22622, 33.05283], [-117.22608, 33.05351], [-117.22591, 33.05411], [-117.22568, 33.05481], [-117.22537, 33.05473], [-117.22596, 33.05276], [-117.22622, 33.05283]]]} | Open Access 1 | 4282 | Little Oaks Equestrian Park | 21350 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 1.691 | Little Oaks Equestrian Park | 0 | Local Recreation Area 3 | 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]);