units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Magnolia Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
633 | 633 | 632 | {"type": "Polygon", "coordinates": [[[-117.66073, 34.11968], [-117.65845, 34.11969], [-117.65844, 34.11797], [-117.66066, 34.11796], [-117.6607, 34.11798], [-117.66072, 34.11801], [-117.66073, 34.11968]]]} | Open Access 1 | 2515 | Magnolia Park | 21683 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 9.94 | Magnolia Park | 0 | Local Park 2 | 4 | |
882 | 882 | 881 | {"type": "Polygon", "coordinates": [[[-117.81385, 33.72], [-117.81345, 33.7204], [-117.81339, 33.72042], [-117.81202, 33.71949], [-117.81161, 33.71927], [-117.81158, 33.71924], [-117.81158, 33.71921], [-117.81203, 33.71876], [-117.81258, 33.71914], [-117.81266, 33.71912], [-117.81276, 33.71915], [-117.81285, 33.71914], [-117.81306, 33.71928], [-117.81319, 33.71915], [-117.81343, 33.71932], [-117.81345, 33.71932], [-117.81351, 33.71938], [-117.81359, 33.7194], [-117.81359, 33.71943], [-117.81383, 33.71959], [-117.8136, 33.71983], [-117.81385, 33.72]]]} | Open Access 1 | 5704 | Magnolia Park | 21682 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | Orange 3 | 4.21 | Magnolia Park | 0 | Local Park 2 | 4 | |
4923 | 4923 | 4922 | {"type": "Polygon", "coordinates": [[[-117.89357, 33.80521], [-117.89357, 33.80566], [-117.89286, 33.80565], [-117.89286, 33.80521], [-117.89357, 33.80521]]]} | Open Access 1 | 30342 | Magnolia Park | 21677 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 0.793 | Magnolia Park | 0 | Local Park 2 | 4 | |
6695 | 6695 | 6694 | {"type": "Polygon", "coordinates": [[[-117.97529, 33.79588], [-117.97536, 33.7959], [-117.97538, 33.79594], [-117.9754, 33.79782], [-117.97538, 33.79784], [-117.97535, 33.79785], [-117.97515, 33.7978], [-117.97503, 33.79779], [-117.97413, 33.79779], [-117.9741, 33.79649], [-117.97479, 33.79616], [-117.97529, 33.79588]]]} | Open Access 1 | 4975 | Magnolia Park | 21678 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 5.275 | Magnolia Park | 0 | Local Park 2 | 4 | |
7765 | 7765 | 7764 | {"type": "Polygon", "coordinates": [[[-122.6821, 38.33061], [-122.6821, 38.33102], [-122.68208, 38.33113], [-122.68194, 38.33135], [-122.68174, 38.33153], [-122.68168, 38.33162], [-122.68157, 38.33183], [-122.68154, 38.33206], [-122.68144, 38.33214], [-122.677, 38.33216], [-122.67668, 38.33221], [-122.67656, 38.33217], [-122.67654, 38.33211], [-122.67642, 38.3318], [-122.67635, 38.33147], [-122.67634, 38.33107], [-122.67642, 38.331], [-122.67968, 38.33097], [-122.6798, 38.33099], [-122.67989, 38.331], [-122.67996, 38.33096], [-122.67998, 38.33091], [-122.67995, 38.33077], [-122.67994, 38.33029], [-122.6812, 38.33029], [-122.68121, 38.33054], [-122.68152, 38.33054], [-122.68153, 38.33061], [-122.6821, 38.33061]]]} | Open Access 1 | 8478 | Magnolia Park | 21681 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 18.043 | Magnolia Park | 1962 | Local Park 2 | 4 | |
10801 | 10801 | 10800 | {"type": "Polygon", "coordinates": [[[-122.05974, 37.39012], [-122.05972, 37.39013], [-122.05957, 37.39053], [-122.05962, 37.39055], [-122.0596, 37.39065], [-122.05955, 37.39068], [-122.05951, 37.39065], [-122.05951, 37.39061], [-122.05933, 37.39043], [-122.05928, 37.39043], [-122.05925, 37.39041], [-122.05927, 37.39039], [-122.05926, 37.39036], [-122.05906, 37.39016], [-122.05901, 37.39017], [-122.05895, 37.39011], [-122.05897, 37.3901], [-122.05896, 37.39007], [-122.05878, 37.38989], [-122.05875, 37.38989], [-122.05871, 37.38987], [-122.05869, 37.38983], [-122.05874, 37.3898], [-122.05876, 37.38982], [-122.05883, 37.38977], [-122.05887, 37.38977], [-122.0597, 37.39005], [-122.05974, 37.39008], [-122.05974, 37.39012]]]} | Open Access 1 | 48648 | Magnolia Park | 33395 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | https://www.mountainview.gov/depts/cs/parks/parks/city_parks.asp | Santa Clara 19 | 0.931 | Magnolia Park | 0 | Local Park 2 | 4 |
12037 | 12037 | 12036 | {"type": "Polygon", "coordinates": [[[-121.11992, 37.74925], [-121.11961, 37.74925], [-121.11954, 37.74919], [-121.11954, 37.74898], [-121.11992, 37.74898], [-121.11992, 37.74925]]]} | Open Access 1 | 24713 | Magnolia Park | 21680 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.246 | Magnolia Park | 0 | Local Park 2 | 4 | |
12525 | 12525 | 12524 | {"type": "Polygon", "coordinates": [[[-121.72575, 37.97404], [-121.72569, 37.97406], [-121.72465, 37.97407], [-121.72451, 37.97406], [-121.72427, 37.97399], [-121.72408, 37.97389], [-121.72409, 37.9738], [-121.72417, 37.97367], [-121.72421, 37.97357], [-121.72423, 37.97342], [-121.72424, 37.97315], [-121.72421, 37.97291], [-121.72426, 37.97283], [-121.72556, 37.97283], [-121.72563, 37.97287], [-121.72563, 37.97324], [-121.72566, 37.97336], [-121.72574, 37.97348], [-121.72578, 37.97364], [-121.72578, 37.97393], [-121.72575, 37.97404]]]} | Open Access 1 | 29024 | Magnolia Park | 21679 | 1229 | Oakley, City of 255 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | Contra Costa 12 | 4.467 | Magnolia 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]);