units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AGENCY = 75 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
DES_TP 9
- Local Park 28
- Local Recreation Area 10
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 45
MNG_AGENCY 1
- Oceanside, City of · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
15141 | 15141 | 15140 | {"type": "Polygon", "coordinates": [[[-117.32181, 33.23522], [-117.32171, 33.23556], [-117.32162, 33.23557], [-117.32159, 33.23552], [-117.32146, 33.23545], [-117.32138, 33.23537], [-117.32154, 33.23522], [-117.32176, 33.23511], [-117.32181, 33.23522]]]} | Open Access 1 | 45966 | Mission Wells Historical Lot | 29115 | 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#9 | San Diego 4 | 0.286 | Mission Wells Historical Lot | 0 | Local Other or Unknown 14 | 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 |
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 | |
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 | ||
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 |
8190 | 8190 | 8189 | {"type": "MultiPolygon", "coordinates": [[[[-117.36414, 33.17398], [-117.36407, 33.17403], [-117.36394, 33.17406], [-117.36377, 33.17399], [-117.36364, 33.17388], [-117.36356, 33.17374], [-117.36354, 33.17333], [-117.36357, 33.1733], [-117.36414, 33.17398]]], [[[-117.36467, 33.17459], [-117.36444, 33.17473], [-117.36397, 33.17424], [-117.36424, 33.17407], [-117.36467, 33.17459]]]]} | Open Access 1 | 12435 | Lion's Club Park | 21310 | 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#49 | San Diego 4 | 1.021 | Lion's Club Park | 0 | Local Park 2 | 4 |
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 | |
8147 | 8147 | 8146 | {"type": "Polygon", "coordinates": [[[-117.32183, 33.23493], [-117.32157, 33.23502], [-117.32141, 33.23512], [-117.32132, 33.2352], [-117.32114, 33.23539], [-117.32106, 33.23554], [-117.32101, 33.2357], [-117.32099, 33.23434], [-117.32144, 33.23434], [-117.32144, 33.23451], [-117.32183, 33.23474], [-117.32183, 33.23493]]]} | Open Access 1 | 12328 | Heritage Park | 19853 | 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#10 | San Diego 4 | 1.507 | Heritage Park | 0 | Local Park 2 | 4 |
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 |
7698 | 7698 | 7697 | {"type": "Polygon", "coordinates": [[[-117.29518, 33.19613], [-117.29514, 33.19645], [-117.29493, 33.19636], [-117.29482, 33.19634], [-117.29471, 33.19633], [-117.29434, 33.19634], [-117.29392, 33.1964], [-117.29352, 33.19651], [-117.29318, 33.19664], [-117.29279, 33.19648], [-117.29342, 33.19591], [-117.2937, 33.19615], [-117.29393, 33.19577], [-117.29432, 33.19594], [-117.2945, 33.196], [-117.29487, 33.19608], [-117.29518, 33.19613]]]} | Open Access 1 | 47625 | Oceanside Open Space 1 | 31363 | 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 | 2.401 | Oceanside OS 1 | None 638 | |||
459 | 459 | 458 | {"type": "Polygon", "coordinates": [[[-117.26352, 33.2475], [-117.26338, 33.24756], [-117.26307, 33.24774], [-117.26289, 33.24789], [-117.26274, 33.24797], [-117.26268, 33.24799], [-117.26264, 33.24797], [-117.26261, 33.24793], [-117.26219, 33.24649], [-117.26249, 33.24656], [-117.26272, 33.24654], [-117.26296, 33.24672], [-117.26296, 33.24678], [-117.26298, 33.24681], [-117.26308, 33.24687], [-117.26352, 33.2475]]]} | Open Access 1 | 1841 | Spring Creek Park | 25737 | 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#7 | San Diego 4 | 2.688 | Spring Creek Park | 0 | Local Park 2 | 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 |
8129 | 8129 | 8128 | {"type": "Polygon", "coordinates": [[[-117.33965, 33.22712], [-117.33962, 33.22818], [-117.33865, 33.22819], [-117.33856, 33.22817], [-117.33841, 33.22811], [-117.33811, 33.22786], [-117.33811, 33.22781], [-117.33835, 33.22759], [-117.33845, 33.22745], [-117.33851, 33.22726], [-117.33851, 33.22713], [-117.33965, 33.22712]]]} | Open Access 1 | 12307 | Fireside Park | 18913 | 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#12 | San Diego 4 | 3.486 | Fireside Park | 0 | Local Park 2 | 4 |
6094 | 6094 | 6093 | {"type": "Polygon", "coordinates": [[[-117.3428, 33.19775], [-117.34138, 33.19797], [-117.34133, 33.19795], [-117.34131, 33.19791], [-117.34131, 33.19675], [-117.34171, 33.19675], [-117.34172, 33.19655], [-117.34243, 33.19709], [-117.34263, 33.1971], [-117.3428, 33.19775]]]} | Open Access 1 | 978 | Joseph Carrasco Park | 20493 | 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 | 3.641 | Joseph Carrasco 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 |
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside School 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 |
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 |
7573 | 7573 | 7572 | {"type": "Polygon", "coordinates": [[[-117.3089, 33.19722], [-117.30873, 33.19753], [-117.30863, 33.19778], [-117.30859, 33.19791], [-117.3079, 33.19824], [-117.30632, 33.1981], [-117.30633, 33.19708], [-117.30688, 33.19709], [-117.30689, 33.19715], [-117.30761, 33.19717], [-117.30788, 33.19715], [-117.30815, 33.19706], [-117.30845, 33.19704], [-117.30861, 33.19705], [-117.30886, 33.19712], [-117.3089, 33.19717], [-117.3089, 33.19722]]]} | Open Access 1 | 7487 | Palisades Park | 23331 | 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#36 | San Diego 4 | 6.288 | Palisades 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]);