units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,164 rows where ACCESS_TYP = 1 and COUNTY = 4 sorted by map descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
DES_TP >30
- Local Park 626
- Local Recreation Area 277
- Local Other or Unknown 70
- Local Conservation Area 40
- Private Conservation 23
- State Conservation Area 19
- State Park 15
- Private Recreation or Education 8
- National Wildlife Refuge 7
- National Public Lands 4
- Local Historic or Cultural Area 3
- State Resource Management Area 3
- State Other or Unknown 3
- Conservation Area 2
- State Recreation Area 2
- State Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 16
- City Agency 928
- County Agency 105
- State Agency 46
- Non Profit - Land Trust 22
- Port/Harbor District 19
- Federal Agency 14
- Water District 9
- Non Profit - Conservation 5
- Non Profit - Other 5
- Recreation/Parks District 4
- Special District - Other 2
- Open Space District 1
- Irrigation District 1
- Commercial 1
- Utility 1
- Fire District 1
ACCESS_TYP 1
- Open Access · 1,164 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2923 | 2923 | 2922 | {"type": "Polygon", "coordinates": [[[-117.38407, 33.19427], [-117.38367, 33.19457], [-117.38305, 33.19382], [-117.3833, 33.19374], [-117.38352, 33.19359], [-117.38407, 33.19427]]]} | Open Access 1 | 19842 | Rotary Park | 24693 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 1.164 | Rotary Park | 0 | Local Park 2 | 4 | |
8689 | 8689 | 8688 | {"type": "Polygon", "coordinates": [[[-117.38395, 33.2121], [-117.38144, 33.21404], [-117.38138, 33.21398], [-117.38224, 33.2126], [-117.38183, 33.21211], [-117.37985, 33.212], [-117.37987, 33.21189], [-117.37992, 33.21175], [-117.38008, 33.21151], [-117.38061, 33.21105], [-117.3808, 33.21095], [-117.381, 33.21089], [-117.38129, 33.21087], [-117.38156, 33.21092], [-117.38176, 33.211], [-117.38233, 33.21135], [-117.38252, 33.21142], [-117.38268, 33.21145], [-117.3828, 33.21145], [-117.38306, 33.2114], [-117.38321, 33.21132], [-117.3832, 33.21167], [-117.38395, 33.2121]]]} | Open Access 1 | 14051 | Capistrano Park | 16835 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#21 | San Diego 4 | 12.004 | Capistrano Park | 0 | Local Park 2 | 4 |
8228 | 8228 | 8227 | {"type": "Polygon", "coordinates": [[[-117.38275, 33.19269], [-117.38235, 33.19291], [-117.38201, 33.19252], [-117.3824, 33.19229], [-117.38275, 33.19269]]]} | Open Access 1 | 12668 | Strand Beach Park (Seagaze Park) | 25906 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#42 | San Diego 4 | 0.6 | Strand Beach Park (Seagaze Park) | None 687 | ||
1488 | 1488 | 1487 | {"type": "Polygon", "coordinates": [[[-117.38198, 33.1918], [-117.3816, 33.19202], [-117.38153, 33.19195], [-117.38151, 33.19189], [-117.38155, 33.19186], [-117.38052, 33.19067], [-117.38086, 33.19047], [-117.38198, 33.1918]]]} | Open Access 1 | 12699 | Tyson Street Park | 26633 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#43 | San Diego 4 | 1.725 | Tyson Street Park | 0 | Local Park 2 | 4 |
5897 | 5897 | 5896 | {"type": "Polygon", "coordinates": [[[-117.37222, 33.20456], [-117.37148, 33.20494], [-117.37038, 33.20345], [-117.37099, 33.20314], [-117.37115, 33.20337], [-117.37129, 33.2033], [-117.37222, 33.20456]]]} | Open Access 1 | 738 | Joe Balderrama Park and Center | 29101 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#26 | San Diego 4 | 3.787 | Joe Balderrama Park and Ctr. | 0 | Local Recreation Area 3 | 4 |
15140 | 15140 | 15139 | {"type": "Polygon", "coordinates": [[[-117.36976, 33.19608], [-117.36957, 33.19609], [-117.36957, 33.19581], [-117.36976, 33.19581], [-117.36976, 33.19608]]]} | Open Access 1 | 45965 | Cesar Chavez Park | 29114 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#34 | San Diego 4 | 0.138 | Cesar Chavez Park | 0 | Local Park 2 | 4 |
1594 | 1594 | 1593 | {"type": "Polygon", "coordinates": [[[-117.36963, 33.17804], [-117.36862, 33.17865], [-117.36726, 33.17705], [-117.36809, 33.17656], [-117.36871, 33.17696], [-117.36963, 33.17804]]]} | Open Access 1 | 12164 | Buccaneer Beach Park | 16468 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#47 | San Diego 4 | 6.084 | Buccaneer Beach Park | 0 | Local Park 2 | 4 |
354 | 354 | 353 | {"type": "Polygon", "coordinates": [[[-117.36947, 33.17694], [-117.36912, 33.17714], [-117.36883, 33.1768], [-117.3692, 33.17658], [-117.36947, 33.17694]]]} | Open Access 1 | 976 | Buccaneer Beach Access | 16467 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 0.466 | Buccaneer Beach Access | 0 | Local Recreation Area 3 | 4 | |
348 | 348 | 347 | {"type": "Polygon", "coordinates": [[[-117.36928, 33.20142], [-117.36901, 33.20156], [-117.36883, 33.20131], [-117.36877, 33.20118], [-117.36877, 33.20102], [-117.36884, 33.20085], [-117.36928, 33.20142]]]} | Open Access 1 | 954 | Women's Club Park | 27676 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#27 | San Diego 4 | 0.431 | Women's Club Park | 0 | Local Park 2 | 4 |
3945 | 3945 | 3944 | {"type": "Polygon", "coordinates": [[[-117.36791, 33.19918], [-117.36736, 33.19918], [-117.36709, 33.1993], [-117.36675, 33.19957], [-117.36642, 33.19973], [-117.36586, 33.19975], [-117.36586, 33.19902], [-117.36583, 33.19901], [-117.36582, 33.19886], [-117.3658, 33.19885], [-117.36579, 33.19846], [-117.3658, 33.19845], [-117.3658, 33.19825], [-117.36584, 33.19824], [-117.36584, 33.19795], [-117.36591, 33.19718], [-117.3661, 33.19717], [-117.36633, 33.19713], [-117.36658, 33.19704], [-117.3669, 33.19685], [-117.36694, 33.19684], [-117.367, 33.19687], [-117.36718, 33.19706], [-117.36758, 33.19753], [-117.36777, 33.19778], [-117.36785, 33.19792], [-117.3679, 33.19812], [-117.36791, 33.19918]]]} | Open Access 1 | 5770 | Ron Ortega Recreation Park | 24587 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#29 | San Diego 4 | 11.869 | Ron Ortega Rec. Park | 0 | Local Recreation Area 3 | 4 |
333 | 333 | 332 | {"type": "Polygon", "coordinates": [[[-117.36415, 33.18341], [-117.36312, 33.1846], [-117.36238, 33.18376], [-117.36324, 33.18324], [-117.36415, 33.18341]]]} | Open Access 1 | 961 | Marshall Street Swim Center & Park | 21898 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#46 | San Diego 4 | 3.024 | Marshall Street Swim Ctr. & Park | 0 | Local Park 2 | 4 |
7599 | 7599 | 7598 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35773, 33.16507], [-117.35761, 33.1652], [-117.35715, 33.1652], [-117.35715, 33.16625], [-117.35629, 33.16543], [-117.35617, 33.16533], [-117.35607, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16478], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.3576, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | 7307 | Buena Vista Lagoon and Nature Center | 16487 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://bvaudubon.org/nature-center/ | San Diego 4 | 3.999 | Buena Vista Lagoon and Nature Ctr. | 0 | Private Recreation or Education 65 | 4 |
754 | 754 | 753 | {"type": "Polygon", "coordinates": [[[-117.35498, 33.1614], [-117.35452, 33.16157], [-117.35394, 33.16158], [-117.35354, 33.16109], [-117.35435, 33.16062], [-117.35498, 33.1614]]]} | Open Access 1 | 4943 | Magee Park | 29993 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/magee.asp | San Diego 4 | 2.038 | Magee Park | 0 | Local Park 2 | 4 |
5266 | 5266 | 5265 | {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} | Open Access 1 | 949 | North County Humane Society and SPCA Dog Park | 29112 | 3361 | San Diego Humane Society and SPCA 803 | Non Profit 6 | Non Profit - Other 22 | http://www.sdhumane.org/ | Non Governmental Organization 10 | 3361 | San Diego Humane Society and SPCA 783 | Non Profit 6 | Non Profit - Other 20 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp | San Diego 4 | 2.32 | North County Humane Society and SPCA Dog Park | 0 | Private Recreation or Education 65 | 4 |
7815 | 7815 | 7814 | {"type": "Polygon", "coordinates": [[[-117.35386, 33.16562], [-117.35275, 33.16562], [-117.35275, 33.16525], [-117.35327, 33.16513], [-117.35386, 33.16562]]]} | Open Access 1 | 12484 | Maxton Brown Park | 21968 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/brown.asp | San Diego 4 | 0.947 | Maxton Brown Park | 0 | Local Park 2 | 4 |
10689 | 10689 | 10688 | {"type": "Polygon", "coordinates": [[[-117.35304, 33.1914], [-117.35291, 33.19183], [-117.35226, 33.19212], [-117.3519, 33.1927], [-117.35141, 33.1937], [-117.3516, 33.19417], [-117.35188, 33.19442], [-117.35222, 33.19467], [-117.35004, 33.19593], [-117.34742, 33.19266], [-117.3481, 33.19219], [-117.34927, 33.19368], [-117.35173, 33.19232], [-117.35239, 33.19167], [-117.35285, 33.19113], [-117.35304, 33.1914]]]} | Open Access 1 | 19840 | Skylark/ John currasco Park | 25538 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#35 | San Diego 4 | 21.938 | Skylark/ John currasco Park | 0 | Local Park 2 | 4 |
1454 | 1454 | 1453 | {"type": "Polygon", "coordinates": [[[-117.35047, 33.16003], [-117.34995, 33.16035], [-117.34918, 33.15942], [-117.34972, 33.15911], [-117.35047, 33.16003]]]} | Open Access 1 | 12582 | Rotary Park | 24686 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.857 | Rotary Park | 0 | Local Park 2 | 4 | |
8144 | 8144 | 8143 | {"type": "Polygon", "coordinates": [[[-117.34865, 33.20849], [-117.34781, 33.2094], [-117.34673, 33.20972], [-117.34594, 33.20913], [-117.34634, 33.20881], [-117.34648, 33.20864], [-117.34654, 33.20853], [-117.34673, 33.20775], [-117.34746, 33.20617], [-117.34817, 33.2049], [-117.34822, 33.20486], [-117.3483, 33.20489], [-117.34855, 33.20525], [-117.34865, 33.20535], [-117.34865, 33.20849]]]} | Open Access 1 | 12325 | Buddy Todd Memorial Park | 16481 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#24 | San Diego 4 | 17.845 | Buddy Todd Memorial Park | 0 | Local Park 2 | 4 |
790 | 790 | 789 | {"type": "Polygon", "coordinates": [[[-117.34745, 33.23316], [-117.34696, 33.23302], [-117.34672, 33.23298], [-117.34621, 33.23294], [-117.34596, 33.23294], [-117.34546, 33.23299], [-117.34496, 33.2331], [-117.34461, 33.2331], [-117.34461, 33.23301], [-117.34463, 33.23293], [-117.3447, 33.23278], [-117.34516, 33.23227], [-117.34534, 33.23204], [-117.34538, 33.23202], [-117.34544, 33.23201], [-117.34575, 33.23212], [-117.34589, 33.23215], [-117.34615, 33.23218], [-117.34697, 33.23217], [-117.34712, 33.23219], [-117.34727, 33.23226], [-117.34736, 33.23232], [-117.34747, 33.23243], [-117.34755, 33.23253], [-117.34759, 33.23266], [-117.3476, 33.23276], [-117.34758, 33.2329], [-117.34745, 33.23316]]]} | Open Access 1 | 5134 | Marlado Highlands Park | 21877 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#11 | San Diego 4 | 5.8 | Marlado Highlands Park | 0 | Local Park 2 | 4 |
7792 | 7792 | 7791 | {"type": "Polygon", "coordinates": [[[-117.34567, 33.22133], [-117.34531, 33.22156], [-117.34498, 33.22181], [-117.34466, 33.22207], [-117.34437, 33.22235], [-117.34432, 33.2223], [-117.34451, 33.22209], [-117.34469, 33.22184], [-117.34484, 33.22158], [-117.34494, 33.22133], [-117.34501, 33.22129], [-117.34538, 33.22134], [-117.34567, 33.22133]]]} | Open Access 1 | 47674 | Alex Road Skate Park | 31416 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/alexpark.asp | San Diego 4 | 0.81 | Alex Road Skate 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]);