units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 1, COUNTY = 3 and MNG_AGENCY = 149
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 24
ACCESS_TYP 1
- Open Access · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
376 | 376 | 375 | {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.77031], [-118.01061, 33.77047], [-118.01056, 33.77071], [-118.01055, 33.77119], [-118.01052, 33.77121], [-118.01012, 33.77121], [-118.01011, 33.76991], [-118.01073, 33.76991], [-118.01093, 33.77007]]]} | Open Access 1 | 1108 | Goldenwest Park | 19378 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 1.77 | Goldenwest Park | 0 | Local Park 2 | 4 | |
1119 | 1119 | 1118 | {"type": "Polygon", "coordinates": [[[-118.03598, 33.76355], [-118.03598, 33.76445], [-118.03394, 33.76445], [-118.03395, 33.76355], [-118.03598, 33.76355]]]} | Open Access 1 | 7118 | Bolsa Chica Park | 16246 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 4.623 | Bolsa Chica Park | 0 | Local Park 2 | 4 | |
1359 | 1359 | 1358 | {"type": "Polygon", "coordinates": [[[-117.98493, 33.73923], [-117.98486, 33.73923], [-117.98483, 33.73916], [-117.98475, 33.73912], [-117.98469, 33.73912], [-117.98453, 33.73917], [-117.98374, 33.73918], [-117.98369, 33.73915], [-117.98368, 33.73912], [-117.98367, 33.73806], [-117.98359, 33.73775], [-117.98359, 33.73768], [-117.9837, 33.7376], [-117.98491, 33.7376], [-117.98493, 33.73923]]]} | Open Access 1 | 7937 | Park West Park | 23441 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 5.013 | Park West Park | 0 | Local Park 2 | 4 | |
3392 | 3392 | 3391 | {"type": "Polygon", "coordinates": [[[-117.97892, 33.75922], [-117.97849, 33.75922], [-117.97848, 33.75856], [-117.97873, 33.75856], [-117.97873, 33.75838], [-117.97892, 33.75838], [-117.97892, 33.75922]]]} | Open Access 1 | 24627 | Blakey Park | 16154 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 0.823 | Blakey Park | 0 | Local Park 2 | 4 | |
5353 | 5353 | 5352 | {"type": "Polygon", "coordinates": [[[-117.99946, 33.76634], [-117.99897, 33.76634], [-117.99892, 33.76292], [-117.99942, 33.76295], [-117.99946, 33.76634]]]} | Open Access 1 | 24628 | Frank G. Fry Park | 33129 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 4.263 | Frank G. Fry Park | 0 | Local Park 2 | 4 | |
5355 | 5355 | 5354 | {"type": "Polygon", "coordinates": [[[-117.76603, 33.89034], [-117.76555, 33.89036], [-117.76559, 33.89099], [-117.76508, 33.89098], [-117.76459, 33.89093], [-117.7651, 33.88981], [-117.76432, 33.88951], [-117.76449, 33.8892], [-117.76455, 33.88903], [-117.7646, 33.88859], [-117.76459, 33.88828], [-117.76455, 33.88802], [-117.76447, 33.88778], [-117.76412, 33.8871], [-117.76407, 33.88694], [-117.76405, 33.88673], [-117.76424, 33.88674], [-117.76429, 33.88698], [-117.76439, 33.8872], [-117.76453, 33.88742], [-117.76492, 33.88793], [-117.76515, 33.88849], [-117.76528, 33.88861], [-117.76553, 33.8887], [-117.76599, 33.88867], [-117.76603, 33.89034]]]} | Open Access 1 | 24629 | Arroyo Park | 15621 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 8.695 | Arroyo Park | 0 | Local Park 2 | 4 | |
5367 | 5367 | 5366 | {"type": "Polygon", "coordinates": [[[-117.98542, 33.76027], [-117.98532, 33.76028], [-117.98534, 33.76166], [-117.9837, 33.76167], [-117.98369, 33.76028], [-117.98492, 33.76027], [-117.98493, 33.76004], [-117.98542, 33.76004], [-117.98542, 33.76027]]]} | Open Access 1 | 5689 | Liberty Park | 21213 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 6.085 | Liberty Park | 0 | Local Park 2 | 4 | |
5446 | 5446 | 5445 | {"type": "Polygon", "coordinates": [[[-118.0157, 33.75577], [-118.01563, 33.7558], [-118.01536, 33.7558], [-118.01535, 33.75541], [-118.01243, 33.75543], [-118.01244, 33.75415], [-118.01342, 33.75414], [-118.01343, 33.75402], [-118.0149, 33.754], [-118.01514, 33.75458], [-118.01555, 33.75525], [-118.0157, 33.75577]]]} | Open Access 1 | 11958 | Buckingham Park | 16474 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 10.007 | Buckingham Park | 0 | Local Park 2 | 4 | |
5850 | 5850 | 5849 | {"type": "Polygon", "coordinates": [[[-117.96021, 33.73828], [-117.95756, 33.7383], [-117.95755, 33.7378], [-117.9591, 33.73779], [-117.95911, 33.73774], [-117.96021, 33.73773], [-117.96021, 33.73828]]]} | Open Access 1 | 184 | Elden F Gillespie Park | 18549 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 3.525 | Elden F Gillespie Park | 0 | Local Park 2 | 4 | |
6476 | 6476 | 6475 | {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02338, 33.76144], [-118.02313, 33.76143], [-118.02311, 33.76064], [-118.02425, 33.7615], [-118.02432, 33.76159], [-118.02437, 33.76169], [-118.02439, 33.76189], [-118.02439, 33.76206]]]} | Open Access 1 | 2087 | Indian Village Park | 20212 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 1.81 | Indian Village Park | 0 | Local Park 2 | 4 | |
6567 | 6567 | 6566 | {"type": "Polygon", "coordinates": [[[-117.99828, 33.74354], [-117.99677, 33.74355], [-117.99676, 33.74265], [-117.99827, 33.74264], [-117.99828, 33.74354]]]} | Open Access 1 | 3565 | Land Park | 21001 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 3.453 | Land Park | 0 | Local Park 2 | 4 | |
6887 | 6887 | 6886 | {"type": "Polygon", "coordinates": [[[-117.99996, 33.73891], [-117.99964, 33.73891], [-117.99932, 33.73914], [-117.9991, 33.73934], [-117.99859, 33.73889], [-117.99857, 33.7375], [-117.99908, 33.7375], [-117.99908, 33.73789], [-117.99928, 33.73813], [-117.99961, 33.73829], [-117.99995, 33.73829], [-117.99996, 33.73891]]]} | Open Access 1 | 5625 | College Park | 17512 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 3.925 | College Park | 0 | Local Park 2 | 4 | |
6931 | 6931 | 6930 | {"type": "Polygon", "coordinates": [[[-117.97222, 33.75408], [-117.97204, 33.75409], [-117.97208, 33.75394], [-117.97207, 33.75393], [-117.9702, 33.75394], [-117.97018, 33.75223], [-117.97209, 33.75222], [-117.97218, 33.75229], [-117.9722, 33.75392], [-117.97222, 33.75393], [-117.97222, 33.75408]]]} | Open Access 1 | 5827 | Westminster Park | 27407 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 8.735 | Westminster Park | 0 | Local Park 2 | 4 | |
8185 | 8185 | 8184 | {"type": "Polygon", "coordinates": [[[-118.00358, 33.75773], [-118.00072, 33.75774], [-118.00071, 33.75692], [-118.00358, 33.75691], [-118.00358, 33.75773]]]} | Open Access 1 | 12611 | Sigler Park | 25473 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 5.986 | Sigler Park | 0 | Local Park 2 | 4 | |
10657 | 10657 | 10656 | {"type": "Polygon", "coordinates": [[[-117.96085, 33.73497], [-117.9595, 33.73555], [-117.95934, 33.73531], [-117.95943, 33.73526], [-117.95952, 33.73515], [-117.95957, 33.73499], [-117.95957, 33.73468], [-117.95962, 33.73466], [-117.96075, 33.73465], [-117.96085, 33.73497]]]} | Open Access 1 | 19009 | Cloverdale Park | 17443 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 2.022 | Cloverdale Park | 0 | Local Park 2 | 4 | |
10665 | 10665 | 10664 | {"type": "Polygon", "coordinates": [[[-117.98055, 33.73309], [-117.98057, 33.73437], [-117.98053, 33.73444], [-117.98051, 33.73446], [-117.97954, 33.73448], [-117.97937, 33.73446], [-117.97905, 33.73439], [-117.97882, 33.73429], [-117.9786, 33.73423], [-117.97831, 33.73419], [-117.97799, 33.73419], [-117.97799, 33.73393], [-117.9781, 33.73392], [-117.97807, 33.73309], [-117.97804, 33.73042], [-117.97867, 33.73041], [-117.97873, 33.73325], [-117.97886, 33.73328], [-117.979, 33.73329], [-117.97921, 33.73326], [-117.98005, 33.73309], [-117.98055, 33.73309]]]} | Open Access 1 | 19007 | Russel C. Paris Park | 24737 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 12.074 | Russel C. Paris Park | 0 | Local Park 2 | 4 | |
10669 | 10669 | 10668 | {"type": "Polygon", "coordinates": [[[-117.96817, 33.74006], [-117.96818, 33.7406], [-117.96816, 33.7407], [-117.96686, 33.74072], [-117.96685, 33.74018], [-117.96725, 33.74018], [-117.96738, 33.74023], [-117.96746, 33.74024], [-117.96755, 33.7402], [-117.96758, 33.74017], [-117.96759, 33.7401], [-117.96783, 33.74011], [-117.96784, 33.74006], [-117.96817, 33.74006]]]} | Open Access 1 | 19010 | Coronet Park | 17651 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 1.909 | Coronet Park | 0 | Local Park 2 | 4 | |
10670 | 10670 | 10669 | {"type": "Polygon", "coordinates": [[[-117.95924, 33.74856], [-117.95924, 33.74929], [-117.95809, 33.74929], [-117.95808, 33.74857], [-117.95924, 33.74856]]]} | Open Access 1 | 19012 | Newcastle Park | 22720 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 2.116 | Newcastle Park | 0 | Local Park 2 | 4 | |
10671 | 10671 | 10670 | {"type": "Polygon", "coordinates": [[[-117.95312, 33.74927], [-117.95338, 33.74966], [-117.95344, 33.74985], [-117.95344, 33.74992], [-117.95343, 33.74995], [-117.95339, 33.74996], [-117.95254, 33.74998], [-117.95229, 33.75004], [-117.952, 33.75019], [-117.95194, 33.75017], [-117.95192, 33.75005], [-117.95191, 33.74935], [-117.95195, 33.7492], [-117.95209, 33.749], [-117.95272, 33.749], [-117.95272, 33.74927], [-117.95312, 33.74927]]]} | Open Access 1 | 19013 | Bowling Green Park | 16310 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 3.177 | Bowling Green Park | 0 | Local Park 2 | 4 | |
12704 | 12704 | 12703 | {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02338, 33.76144], [-118.02313, 33.76143], [-118.02311, 33.76064], [-118.02425, 33.7615], [-118.02432, 33.76159], [-118.02437, 33.76169], [-118.02439, 33.76189], [-118.02439, 33.76206]]]} | Open Access 1 | 30234 | Virginia Boos Park | 27156 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 1.81 | Virginia Boos 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]);