units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1, LABEL_NAME = "Sycamore Park" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
MNG_AGENCY 9
ACCESS_TYP 1
- Open Access · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4925 | 4925 | 4924 | {"type": "Polygon", "coordinates": [[[-117.74506, 33.86256], [-117.7448, 33.86264], [-117.74461, 33.86278], [-117.7441, 33.86378], [-117.74344, 33.86362], [-117.74303, 33.86354], [-117.74299, 33.86348], [-117.74303, 33.86311], [-117.74291, 33.86265], [-117.7428, 33.86269], [-117.74284, 33.86263], [-117.74282, 33.86234], [-117.74273, 33.86205], [-117.74257, 33.86115], [-117.74311, 33.86118], [-117.74313, 33.86121], [-117.74333, 33.86122], [-117.74374, 33.862], [-117.7438, 33.86207], [-117.74386, 33.86211], [-117.74397, 33.86212], [-117.74386, 33.86191], [-117.74483, 33.86225], [-117.74497, 33.86239], [-117.74506, 33.86256]]]} | Open Access 1 | 30344 | Sycamore Park | 26132 | 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 | 8.695 | Sycamore Park | 0 | Local Park 2 | 4 | |
5360 | 5360 | 5359 | {"type": "Polygon", "coordinates": [[[-117.232, 33.58521], [-117.23159, 33.58549], [-117.23057, 33.58454], [-117.23045, 33.58446], [-117.23025, 33.58435], [-117.23005, 33.58418], [-117.2305, 33.58383], [-117.23135, 33.58462], [-117.23141, 33.58463], [-117.23189, 33.585], [-117.232, 33.58521]]]} | Open Access 1 | 24651 | Sycamore Park | 26139 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 2.664 | Sycamore Park | 0 | Local Park 2 | 4 | |
6698 | 6698 | 6697 | {"type": "MultiPolygon", "coordinates": [[[[-122.5344, 37.89556], [-122.53396, 37.89601], [-122.53375, 37.89591], [-122.53361, 37.89611], [-122.53349, 37.89606], [-122.53363, 37.89585], [-122.53227, 37.89517], [-122.53196, 37.89507], [-122.53173, 37.89503], [-122.53152, 37.895], [-122.53118, 37.89501], [-122.531, 37.89503], [-122.53086, 37.89505], [-122.53044, 37.89524], [-122.53025, 37.89529], [-122.53024, 37.89515], [-122.53066, 37.89496], [-122.53085, 37.8949], [-122.5312, 37.89486], [-122.53158, 37.89486], [-122.53183, 37.8949], [-122.53226, 37.89501], [-122.53375, 37.89573], [-122.53418, 37.89542], [-122.5344, 37.89556]]], [[[-122.53434, 37.8965], [-122.53379, 37.89724], [-122.53403, 37.89746], [-122.53432, 37.89757], [-122.53415, 37.89771], [-122.53339, 37.89737], [-122.5336, 37.89711], [-122.53368, 37.89713], [-122.53367, 37.89674], [-122.53434, 37.8965]]], [[[-122.53605, 37.89687], [-122.53568, 37.89713], [-122.53549, 37.89697], [-122.5355, 37.89695], [-122.5354, 37.89687], [-122.53527, 37.89696], [-122.53552, 37.89725], [-122.53545, 37.89731], [-122.53548, 37.89735], [-122.5355, 37.89735], [-122.53575, 37.89764], [-122.53571, 37.89767], [-122.5347, 37.89651], [-122.53454, 37.89643], [-122.53478, 37.89635], [-122.53541, 37.89677], [-122.53548, 37.89681], [-122.53576, 37.89661], [-122.53605, 37.89687]]]]} | Open Access 1 | 4983 | Sycamore Park | 26136 | 1204 | Mill Valley, City of 227 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | Marin 23 | 4.005 | Sycamore Park | 0 | Local Park 2 | 4 | |
7099 | 7099 | 7098 | {"type": "Polygon", "coordinates": [[[-118.40198, 33.92796], [-118.40129, 33.92797], [-118.40129, 33.92752], [-118.40198, 33.92752], [-118.40198, 33.92796]]]} | Open Access 1 | 6151 | Sycamore Park | 26134 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.773 | Sycamore Park | 0 | Local Park 2 | 4 | |
8282 | 8282 | 8281 | {"type": "Polygon", "coordinates": [[[-117.76768, 33.70259], [-117.7671, 33.70293], [-117.76688, 33.70316], [-117.76682, 33.70343], [-117.76653, 33.70353], [-117.76634, 33.7037], [-117.76633, 33.70385], [-117.76636, 33.704], [-117.76646, 33.70411], [-117.76663, 33.70424], [-117.76638, 33.70419], [-117.76624, 33.70418], [-117.76602, 33.70419], [-117.7657, 33.70423], [-117.76538, 33.70434], [-117.76519, 33.70443], [-117.76502, 33.70455], [-117.76534, 33.70415], [-117.76561, 33.70363], [-117.76534, 33.70351], [-117.76541, 33.70338], [-117.76568, 33.70347], [-117.76587, 33.70308], [-117.76592, 33.70249], [-117.76603, 33.70223], [-117.76621, 33.70202], [-117.76652, 33.7022], [-117.76673, 33.70199], [-117.76685, 33.70205], [-117.7673, 33.7022], [-117.7675, 33.70235], [-117.76768, 33.70259]]]} | Open Access 1 | 12671 | Sycamore Park | 26135 | 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 | 6.61 | Sycamore Park | 0 | Local Park 2 | 4 | |
8865 | 8865 | 8864 | {"type": "Polygon", "coordinates": [[[-117.69397, 33.60743], [-117.69287, 33.60917], [-117.69277, 33.60937], [-117.69267, 33.60972], [-117.69267, 33.61031], [-117.69272, 33.6107], [-117.69286, 33.61099], [-117.69256, 33.61117], [-117.69249, 33.61102], [-117.69244, 33.61084], [-117.69237, 33.61078], [-117.69229, 33.61076], [-117.69217, 33.61041], [-117.69216, 33.6103], [-117.69218, 33.60972], [-117.69224, 33.60938], [-117.69171, 33.60924], [-117.69175, 33.60919], [-117.69241, 33.60802], [-117.69326, 33.60776], [-117.69348, 33.60733], [-117.6935, 33.60734], [-117.69351, 33.60736], [-117.69377, 33.60734], [-117.69397, 33.60743]]]} | Open Access 1 | 14623 | Sycamore Park | 26137 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 7.009 | Sycamore Park | 0 | Local Park 2 | 4 | |
10957 | 10957 | 10956 | {"type": "Polygon", "coordinates": [[[-121.76742, 38.55516], [-121.76738, 38.55617], [-121.76502, 38.55612], [-121.76505, 38.55511], [-121.76742, 38.55516]]]} | Open Access 1 | 21016 | Sycamore Park | 26133 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 5.732 | Sycamore Park | 0 | Local Park 2 | 4 | |
10974 | 10974 | 10973 | {"type": "Polygon", "coordinates": [[[-121.51064, 38.67132], [-121.51064, 38.67156], [-121.51061, 38.67177], [-121.51045, 38.67217], [-121.5104, 38.67237], [-121.51039, 38.67252], [-121.51039, 38.67298], [-121.50966, 38.67298], [-121.50959, 38.67305], [-121.50953, 38.67303], [-121.50944, 38.67305], [-121.50937, 38.67298], [-121.50865, 38.67298], [-121.50858, 38.67305], [-121.50851, 38.67303], [-121.50843, 38.67305], [-121.50836, 38.67297], [-121.50796, 38.67298], [-121.50796, 38.67234], [-121.50922, 38.67233], [-121.50934, 38.67231], [-121.50949, 38.67226], [-121.5096, 38.67221], [-121.50972, 38.67212], [-121.50982, 38.67201], [-121.50988, 38.6719], [-121.50992, 38.67174], [-121.50991, 38.67116], [-121.5104, 38.67115], [-121.51041, 38.67122], [-121.51047, 38.67128], [-121.51055, 38.67131], [-121.51064, 38.67132]]]} | Open Access 1 | 21041 | Sycamore Park | 26138 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.836 | Sycamore Park | 0 | Local Park 2 | 4 | |
11872 | 11872 | 11871 | {"type": "Polygon", "coordinates": [[[-122.20452, 39.52046], [-122.20244, 39.52043], [-122.20242, 39.51893], [-122.20184, 39.51891], [-122.20182, 39.51795], [-122.20446, 39.51791], [-122.20452, 39.52046]]]} | Open Access 1 | 24480 | Sycamore Park | 26140 | 1424 | Willows, City of 986 | City 2 | City Agency 2 | http://www.cityofwillows.org/index.asp?Type=B_BASIC&SEC={015394F5-8E1E-4589-8D14-61CADB23BEE6} | City 2 | 1424 | Willows, City of 950 | City 2 | City Agency 2 | Glenn 55 | 13.591 | Sycamore 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]);