units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where COUNTY = 4 and MNG_AGENCY = 42 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 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 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
8894 | 8894 | 8893 | {"type": "Polygon", "coordinates": [[[-117.24144, 33.05991], [-117.24138, 33.05992], [-117.24142, 33.06043], [-117.24142, 33.06076], [-117.24122, 33.06079], [-117.24096, 33.06088], [-117.24074, 33.06103], [-117.24066, 33.06111], [-117.24057, 33.06111], [-117.23958, 33.06051], [-117.23968, 33.0605], [-117.23967, 33.05988], [-117.23974, 33.05987], [-117.23978, 33.05985], [-117.23991, 33.05995], [-117.24043, 33.05995], [-117.24045, 33.05849], [-117.24067, 33.05831], [-117.24096, 33.0583], [-117.24124, 33.05853], [-117.24144, 33.05991]]]} | Open Access 1 | 14550 | Sun Vista | 25983 | 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 | 7.726 | Sun Vista | None 744 | ||
110 | 110 | 109 | {"type": "Polygon", "coordinates": [[[-117.29125, 33.04677], [-117.29115, 33.04685], [-117.29116, 33.04711], [-117.29104, 33.04713], [-117.29093, 33.0472], [-117.29088, 33.04731], [-117.29089, 33.04741], [-117.29079, 33.04744], [-117.29081, 33.04755], [-117.29009, 33.04705], [-117.29007, 33.04643], [-117.29016, 33.04643], [-117.29017, 33.04645], [-117.29118, 33.04635], [-117.29125, 33.04677]]]} | Open Access 1 | 297 | Encinitas Viewpoint Park | 18667 | 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 | 2.45 | Encinitas Viewpoint Park | 0 | Local Park 2 | 4 |
266 | 266 | 265 | {"type": "Polygon", "coordinates": [[[-117.28081, 33.05885], [-117.28072, 33.06063], [-117.27954, 33.06063], [-117.27953, 33.06014], [-117.27857, 33.06014], [-117.27858, 33.05993], [-117.27819, 33.05883], [-117.28081, 33.05885]]]} | Open Access 1 | 744 | Quail Gardens Undeveloped Park | 24040 | 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 | 9.379 | Quail Gardens Undeveloped Park | 0 | Local Park 2 | 4 | |
301 | 301 | 300 | {"type": "Polygon", "coordinates": [[[-117.2813, 33.01875], [-117.28074, 33.01904], [-117.28068, 33.01906], [-117.28053, 33.01907], [-117.28027, 33.01903], [-117.28002, 33.01906], [-117.27986, 33.01914], [-117.2798, 33.01919], [-117.27976, 33.01926], [-117.27965, 33.01933], [-117.2796, 33.01935], [-117.2795, 33.01935], [-117.27944, 33.01933], [-117.27935, 33.01927], [-117.27932, 33.01921], [-117.27927, 33.01904], [-117.27927, 33.01893], [-117.27929, 33.01887], [-117.27934, 33.01882], [-117.2794, 33.01878], [-117.27944, 33.01868], [-117.27943, 33.01853], [-117.27938, 33.01846], [-117.27929, 33.01839], [-117.27928, 33.01833], [-117.27929, 33.01831], [-117.27943, 33.01819], [-117.27953, 33.01814], [-117.27967, 33.01811], [-117.27998, 33.01812], [-117.28015, 33.01814], [-117.28044, 33.01822], [-117.28055, 33.01822], [-117.28074, 33.01816], [-117.28091, 33.018], [-117.28097, 33.018], [-117.28102, 33.01804], [-117.2811, 33.01824], [-117.28128, 33.01869], [-117.2813, 33.01875]]]} | Open Access 1 | 1037 | Glen Park | 19323 | 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 | 4.507 | Glen Park | 0 | Local Park 2 | 4 |
604 | 604 | 603 | {"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]} | Open Access 1 | 2084 | Indian Head Canyon | 20201 | 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 | 55.677 | Indian Head Canyon | 0 | Local Recreation Area 3 | 4 | |
706 | 706 | 705 | {"type": "Polygon", "coordinates": [[[-117.30499, 33.07463], [-117.30401, 33.07487], [-117.30385, 33.0744], [-117.30375, 33.07426], [-117.30364, 33.0739], [-117.30366, 33.07387], [-117.3037, 33.07385], [-117.30399, 33.07382], [-117.30463, 33.07368], [-117.30468, 33.07371], [-117.30499, 33.07463]]]} | Open Access 1 | 4023 | Leucadia Oaks Park | 21186 | 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 | 2.7 | Leucadia Oaks Park | 0 | Local Park 2 | 4 |
1158 | 1158 | 1157 | {"type": "Polygon", "coordinates": [[[-117.29614, 33.0581], [-117.2955, 33.0581], [-117.29432, 33.0581], [-117.29458, 33.05748], [-117.29524, 33.05748], [-117.29525, 33.05731], [-117.29581, 33.05731], [-117.29614, 33.0581]]]} | Open Access 1 | 7357 | Orpheus Park | 23224 | 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 | 2.741 | Orpheus Park | 0 | Local Park 2 | 4 |
1921 | 1921 | 1920 | {"type": "Polygon", "coordinates": [[[-117.25318, 33.05161], [-117.253, 33.05162], [-117.25266, 33.05167], [-117.25237, 33.05103], [-117.2519, 33.05104], [-117.2519, 33.05092], [-117.25227, 33.05079], [-117.24994, 33.04553], [-117.25052, 33.04565], [-117.25318, 33.05161]]]} | Open Access 1 | 14888 | Undeveloped Community Park | 26652 | 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 | 8.458 | Undeveloped Community 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 |
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 |
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 | ||
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 |
5445 | 5445 | 5444 | {"type": "Polygon", "coordinates": [[[-117.25804, 33.06686], [-117.25751, 33.06687], [-117.2568, 33.0669], [-117.25684, 33.06657], [-117.25692, 33.06651], [-117.25694, 33.06643], [-117.25702, 33.06636], [-117.25717, 33.06634], [-117.25721, 33.06619], [-117.2573, 33.06607], [-117.258, 33.0662], [-117.25802, 33.06622], [-117.25804, 33.06631], [-117.25804, 33.06686]]]} | Open Access 1 | 11954 | Scott Valley Park | 25206 | 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 | 2.043 | Scott Valley 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]);