units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Plaza Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328 | 328 | 327 | {"type": "Polygon", "coordinates": [[[-119.29146, 34.27945], [-119.29013, 34.27946], [-119.29013, 34.27839], [-119.29145, 34.27838], [-119.29146, 34.27945]]]} | Open Access 1 | 18656 | Plaza Park | 23788 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 3.582 | Plaza Park | 0 | Local Park 2 | 4 | |
443 | 443 | 442 | {"type": "Polygon", "coordinates": [[[-119.39303, 36.32471], [-119.39295, 36.32489], [-119.3927, 36.32484], [-119.39045, 36.32479], [-119.39025, 36.32471], [-119.39042, 36.32429], [-119.39019, 36.32419], [-119.39003, 36.32446], [-119.38997, 36.3248], [-119.38972, 36.3248], [-119.38943, 36.32484], [-119.38905, 36.325], [-119.38869, 36.32501], [-119.38834, 36.32486], [-119.38818, 36.32466], [-119.38794, 36.32414], [-119.3879, 36.32397], [-119.38792, 36.32382], [-119.38827, 36.32255], [-119.38842, 36.32226], [-119.38852, 36.32213], [-119.38869, 36.32201], [-119.38888, 36.32191], [-119.38905, 36.32185], [-119.38952, 36.32175], [-119.38983, 36.32163], [-119.38997, 36.32155], [-119.39026, 36.32131], [-119.39047, 36.32109], [-119.39063, 36.32115], [-119.39073, 36.32123], [-119.39297, 36.3245], [-119.39303, 36.32471]]]} | Open Access 1 | 1382 | Plaza Park | 23789 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 30.735 | Plaza Park | 0 | Local Park 2 | 4 | |
654 | 654 | 653 | {"type": "Polygon", "coordinates": [[[-120.06046, 36.72073], [-120.06043, 36.72244], [-120.06028, 36.72262], [-120.0601, 36.72247], [-120.06012, 36.72077], [-120.06031, 36.72063], [-120.06046, 36.72073]]]} | Open Access 1 | 3218 | Plaza Park | 23786 | 1151 | Kerman, City of 212 | City 2 | City Agency 2 | http://cityofkerman.net/parks-and-recreation-department/ | City 2 | 1151 | Kerman, City of 208 | City 2 | City Agency 2 | Fresno 9 | 1.535 | Plaza Park | 0 | Local Park 2 | 4 | |
1485 | 1485 | 1484 | {"type": "Polygon", "coordinates": [[[-122.87059, 38.61102], [-122.86967, 38.61115], [-122.86952, 38.61059], [-122.87043, 38.61044], [-122.87059, 38.61102]]]} | Open Access 1 | 10319 | Plaza Park | 23784 | 1131 | Healdsburg, City of 374 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | Sonoma 16 | 1.301 | Plaza Park | 0 | Local Park 2 | 4 | |
1654 | 1654 | 1653 | {"type": "Polygon", "coordinates": [[[-117.81031, 33.69008], [-117.81012, 33.69032], [-117.80993, 33.69052], [-117.80959, 33.69081], [-117.80948, 33.69084], [-117.80944, 33.69081], [-117.80937, 33.69085], [-117.8087, 33.69041], [-117.80827, 33.69084], [-117.80889, 33.69125], [-117.80878, 33.69129], [-117.80616, 33.68949], [-117.8066, 33.68956], [-117.80696, 33.68958], [-117.80853, 33.68961], [-117.80899, 33.68965], [-117.80982, 33.68985], [-117.81029, 33.69002], [-117.81031, 33.69008]]]} | Open Access 1 | 12568 | Plaza Park | 23785 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.975 | Plaza Park | 0 | Local Park 2 | 4 | |
1716 | 1716 | 1715 | {"type": "Polygon", "coordinates": [[[-122.01159, 37.54533], [-122.01151, 37.54542], [-122.01126, 37.54529], [-122.01121, 37.54529], [-122.01094, 37.54515], [-122.01092, 37.54508], [-122.01075, 37.54499], [-122.01066, 37.545], [-122.01051, 37.54492], [-122.01035, 37.54512], [-122.01046, 37.54522], [-122.01042, 37.54527], [-122.01034, 37.54524], [-122.0101, 37.5453], [-122.01001, 37.54541], [-122.00973, 37.54527], [-122.00993, 37.54502], [-122.00997, 37.54503], [-122.01024, 37.5447], [-122.01, 37.54457], [-122.01005, 37.54451], [-122.01048, 37.54474], [-122.0105, 37.54479], [-122.01071, 37.54489], [-122.01076, 37.54489], [-122.01103, 37.54503], [-122.01105, 37.54508], [-122.01125, 37.54518], [-122.01129, 37.54517], [-122.01159, 37.54533]]]} | Open Access 1 | 12873 | Plaza Park | 23782 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.095 | Plaza Park | 1973 | Local Park 2 | 4 | |
2399 | 2399 | 2398 | {"type": "Polygon", "coordinates": [[[-119.18097, 34.19734], [-119.18096, 34.19804], [-119.17997, 34.19803], [-119.17997, 34.19733], [-119.18097, 34.19734]]]} | Open Access 1 | 18651 | Plaza Park | 23787 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 1.751 | Plaza Park | 0 | Local Park 2 | 4 | |
9443 | 9443 | 9442 | {"type": "Polygon", "coordinates": [[[-121.83952, 39.72835], [-121.83882, 39.72882], [-121.8382, 39.72828], [-121.83889, 39.7278], [-121.83952, 39.72835]]]} | Open Access 1 | 15822 | Plaza Park | 23781 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 1.59 | Plaza Park | 0 | Local Park 2 | 4 | |
12856 | 12856 | 12855 | {"type": "Polygon", "coordinates": [[[-117.92264, 33.87229], [-117.9222, 33.87229], [-117.9222, 33.87199], [-117.92264, 33.87199], [-117.92264, 33.87229]]]} | Open Access 1 | 30307 | Plaza Park | 23783 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 0.337 | Plaza Park | 0 | Local Park 2 | 4 | |
12964 | 12964 | 12963 | {"type": "Polygon", "coordinates": [[[-115.5347, 32.97881], [-115.53469, 32.97938], [-115.53399, 32.9788], [-115.5347, 32.97881], [-115.5347, 32.97881]]]} | Open Access 1 | 30428 | Plaza Park | 23790 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 0.521 | Plaza Park | 0 | Local Park 2 | 4 | |
15305 | 15305 | 15304 | {"type": "Polygon", "coordinates": [[[-118.10762, 34.09685], [-118.10762, 34.09685], [-118.10657, 34.09656], [-118.10761, 34.09622], [-118.10765, 34.09626], [-118.10762, 34.09685]]]} | Open Access 1 | 46474 | Plaza Park | 29747 | 3358 | Archdiocese of Los Angeles 1151 | Non Profit 6 | Non Profit - Other 22 | http://www.la-archdiocese.org/Pages/default.aspx | Non Governmental Organization 10 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.869 | Plaza 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]);