units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 57 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 5
MNG_AG_TYP 1
- City Agency 39
MNG_AGENCY 1
- Anaheim, City of · 39 ✖
ACCESS_TYP 1
- Open Access 39
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1399 | 1399 | 1398 | {"type": "Polygon", "coordinates": [[[-117.90621, 33.79599], [-117.90614, 33.79601], [-117.90421, 33.79601], [-117.90418, 33.79433], [-117.90616, 33.79433], [-117.90621, 33.79493], [-117.90621, 33.79599]]]} | Open Access 1 | 8773 | Ponderosa Park | 23887 | 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.563 | Ponderosa Park | 0 | Local Park 2 | 4 | |
7874 | 7874 | 7873 | {"type": "Polygon", "coordinates": [[[-117.89318, 33.82458], [-117.89251, 33.82474], [-117.89284, 33.82572], [-117.89125, 33.82609], [-117.89164, 33.82725], [-117.88952, 33.82775], [-117.88943, 33.82773], [-117.88941, 33.82765], [-117.88941, 33.82731], [-117.8894, 33.82549], [-117.88941, 33.82447], [-117.89102, 33.82409], [-117.89289, 33.82367], [-117.89318, 33.82458]]]} | Open Access 1 | 9632 | Boysen Park | 16318 | 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 | 24.382 | Boysen Park | 0 | Local Park 2 | 4 | |
7848 | 7848 | 7847 | {"type": "Polygon", "coordinates": [[[-118.00047, 33.82235], [-117.99948, 33.82236], [-117.99948, 33.82277], [-117.99945, 33.82286], [-117.99947, 33.82456], [-117.99945, 33.82459], [-117.99687, 33.82462], [-117.99682, 33.82459], [-117.99677, 33.82122], [-117.99678, 33.82121], [-117.99682, 33.8212], [-117.9976, 33.82119], [-117.99768, 33.82115], [-117.99771, 33.82112], [-117.99774, 33.82106], [-117.99774, 33.82101], [-117.9997, 33.82099], [-118.00047, 33.82235]]]} | Open Access 1 | 9746 | Reid Park | 24278 | 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 | 26.103 | Reid Park | 0 | Local Park 2 | 4 | |
8070 | 8070 | 8069 | {"type": "Polygon", "coordinates": [[[-117.99126, 33.82849], [-117.99003, 33.82913], [-117.98967, 33.82933], [-117.98907, 33.82959], [-117.98877, 33.82969], [-117.98802, 33.82985], [-117.98735, 33.8299], [-117.98591, 33.82989], [-117.98591, 33.82959], [-117.98651, 33.82954], [-117.98673, 33.8295], [-117.98693, 33.8294], [-117.98712, 33.82922], [-117.98711, 33.8292], [-117.98675, 33.829], [-117.98687, 33.82878], [-117.98689, 33.82848], [-117.99125, 33.82844], [-117.99126, 33.82849]]]} | Open Access 1 | 11918 | Schweitzer Park | 25199 | 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 | 11.667 | Schweitzer Park | 0 | Local Park 2 | 4 | |
8971 | 8971 | 8970 | {"type": "Polygon", "coordinates": [[[-117.73239, 33.85914], [-117.73185, 33.8594], [-117.73177, 33.85946], [-117.7313, 33.85968], [-117.7312, 33.85976], [-117.73115, 33.85986], [-117.73117, 33.86001], [-117.73134, 33.86024], [-117.73135, 33.86028], [-117.73135, 33.8606], [-117.73121, 33.86086], [-117.73111, 33.86091], [-117.73101, 33.86099], [-117.73095, 33.861], [-117.73082, 33.861], [-117.73071, 33.86097], [-117.73048, 33.86077], [-117.73002, 33.86076], [-117.72975, 33.86067], [-117.72967, 33.86062], [-117.72926, 33.86047], [-117.72908, 33.86032], [-117.72889, 33.86023], [-117.7288, 33.86014], [-117.72868, 33.86007], [-117.72826, 33.8597], [-117.72824, 33.8597], [-117.72805, 33.85945], [-117.72815, 33.85946], [-117.72873, 33.85927], [-117.7294, 33.85914], [-117.72983, 33.85901], [-117.73006, 33.85891], [-117.73034, 33.85877], [-117.73064, 33.85857], [-117.7308, 33.85844], [-117.7313, 33.85781], [-117.73166, 33.8578], [-117.73177, 33.85791], [-117.73181, 33.85816], [-117.73201, 33.85839], [-117.73219, 33.85865], [-117.73223, 33.85873], [-117.73227, 33.85897], [-117.73239, 33.85914]]]} | Open Access 1 | 14802 | Ronald Reagan Park | 24589 | 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 | 16.076 | Ronald Reagan Park | 0 | Local Park 2 | 4 | |
9245 | 9245 | 9244 | {"type": "Polygon", "coordinates": [[[-117.94529, 33.82876], [-117.94366, 33.82873], [-117.94365, 33.82642], [-117.94527, 33.8264], [-117.94529, 33.82876]]]} | Open Access 1 | 15371 | Chaparral Park | 17125 | 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 | 9.619 | Chaparral Park | 0 | Local Park 2 | 4 | |
9220 | 9220 | 9219 | {"type": "Polygon", "coordinates": [[[-117.93926, 33.82344], [-117.93719, 33.82346], [-117.93718, 33.82182], [-117.93722, 33.82179], [-117.93925, 33.82178], [-117.93926, 33.82344]]]} | Open Access 1 | 15409 | Willow Park | 27582 | 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.77 | Willow Park | 0 | Local Park 2 | 4 | |
2901 | 2901 | 2900 | {"type": "Polygon", "coordinates": [[[-117.89577, 33.85049], [-117.8937, 33.85049], [-117.89367, 33.84909], [-117.89575, 33.84909], [-117.89577, 33.85049]]]} | Open Access 1 | 18953 | Edison Park | 18445 | 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 | 7.389 | Edison Park | 0 | Local Park 2 | 4 | |
9920 | 9920 | 9919 | {"type": "Polygon", "coordinates": [[[-117.93062, 33.82917], [-117.93055, 33.82919], [-117.9303, 33.82908], [-117.92926, 33.82854], [-117.92857, 33.8279], [-117.92857, 33.82754], [-117.93002, 33.8277], [-117.93055, 33.82798], [-117.93062, 33.82917]]]} | Open Access 1 | 18985 | Ross Park | 24676 | 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 | 4.98 | Ross Park | 0 | Local Park 2 | 4 | |
10372 | 10372 | 10371 | {"type": "Polygon", "coordinates": [[[-117.91258, 33.83807], [-117.91185, 33.83823], [-117.91182, 33.83819], [-117.91156, 33.83744], [-117.91234, 33.83726], [-117.91259, 33.838], [-117.91259, 33.83804], [-117.91258, 33.83807]]]} | Open Access 1 | 18986 | George Washington Park | 19275 | 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 | 1.689 | George Washington Park | 0 | Local Park 2 | 4 | |
4534 | 4534 | 4533 | {"type": "Polygon", "coordinates": [[[-117.911, 33.82276], [-117.90994, 33.82301], [-117.90989, 33.82299], [-117.90958, 33.82205], [-117.91068, 33.8218], [-117.911, 33.82276]]]} | Open Access 1 | 18987 | Walnut Grove Park | 27230 | 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 | 2.893 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
2912 | 2912 | 2911 | {"type": "Polygon", "coordinates": [[[-117.91594, 33.84882], [-117.9159, 33.84886], [-117.91549, 33.84886], [-117.91544, 33.84887], [-117.91541, 33.84891], [-117.91534, 33.8489], [-117.91524, 33.84892], [-117.91517, 33.84896], [-117.91513, 33.84903], [-117.91488, 33.84904], [-117.91487, 33.84867], [-117.91533, 33.84867], [-117.91542, 33.84868], [-117.91544, 33.84872], [-117.91594, 33.84872], [-117.91594, 33.84882]]]} | Open Access 1 | 18988 | Julianna Park | 20520 | 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.607 | Julianna Park | 0 | Local Park 2 | 4 | |
2913 | 2913 | 2912 | {"type": "Polygon", "coordinates": [[[-117.88266, 33.82743], [-117.88261, 33.82743], [-117.88253, 33.82748], [-117.88251, 33.82752], [-117.8825, 33.82758], [-117.88256, 33.8277], [-117.88256, 33.82834], [-117.88256, 33.82847], [-117.8825, 33.82858], [-117.8825, 33.82862], [-117.8825, 33.82866], [-117.88254, 33.82871], [-117.88263, 33.82874], [-117.88263, 33.82903], [-117.88064, 33.82904], [-117.88065, 33.82721], [-117.88266, 33.82721], [-117.88266, 33.82743]]]} | Open Access 1 | 18989 | Juarez Park | 20515 | 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.975 | Juarez Park | 0 | Local Park 2 | 4 | |
10650 | 10650 | 10649 | {"type": "Polygon", "coordinates": [[[-117.76934, 33.83943], [-117.76919, 33.8398], [-117.76877, 33.83968], [-117.76842, 33.83961], [-117.76782, 33.83956], [-117.76746, 33.83956], [-117.76578, 33.83972], [-117.76531, 33.83981], [-117.76502, 33.83983], [-117.76473, 33.83983], [-117.76452, 33.83979], [-117.76455, 33.83963], [-117.76457, 33.83965], [-117.76481, 33.83965], [-117.76504, 33.83962], [-117.76506, 33.83962], [-117.76627, 33.83904], [-117.76643, 33.83894], [-117.76644, 33.83892], [-117.76669, 33.83878], [-117.76667, 33.83852], [-117.76725, 33.83858], [-117.76812, 33.83826], [-117.7675, 33.83775], [-117.76856, 33.83801], [-117.76925, 33.83878], [-117.76934, 33.83943]]]} | Open Access 1 | 18991 | Oak Park | 22995 | 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 | 10.905 | Oak Park | 0 | Local Park 2 | 4 | |
10651 | 10651 | 10650 | {"type": "Polygon", "coordinates": [[[-117.7439, 33.84407], [-117.74384, 33.84445], [-117.74376, 33.84462], [-117.74352, 33.84499], [-117.74343, 33.84507], [-117.74313, 33.84529], [-117.74284, 33.84545], [-117.74194, 33.84571], [-117.74176, 33.84578], [-117.74156, 33.84549], [-117.74225, 33.84516], [-117.74237, 33.84504], [-117.74221, 33.84457], [-117.74111, 33.84381], [-117.74171, 33.84336], [-117.74186, 33.84323], [-117.74193, 33.8432], [-117.742, 33.84323], [-117.74224, 33.84341], [-117.74252, 33.84356], [-117.74293, 33.84373], [-117.74317, 33.84379], [-117.74389, 33.84388], [-117.74387, 33.84405], [-117.7439, 33.84407]]]} | Open Access 1 | 18992 | Canyon Rim Park | 16825 | 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.982 | Canyon Rim Park | 0 | Local Park 2 | 4 | |
2480 | 2480 | 2479 | {"type": "Polygon", "coordinates": [[[-117.81994, 33.85368], [-117.8184, 33.85415], [-117.81795, 33.85199], [-117.81887, 33.85177], [-117.8195, 33.85168], [-117.81994, 33.85368]]]} | Open Access 1 | 18993 | Riverdale Park | 24440 | 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.669 | Riverdale Park | 0 | Local Park 2 | 4 | |
10652 | 10652 | 10651 | {"type": "Polygon", "coordinates": [[[-117.82661, 33.83646], [-117.82589, 33.83675], [-117.82503, 33.83724], [-117.82501, 33.83776], [-117.82433, 33.83779], [-117.8237, 33.83789], [-117.82352, 33.8379], [-117.823, 33.83783], [-117.82292, 33.83683], [-117.82455, 33.83597], [-117.82493, 33.83624], [-117.82608, 33.83604], [-117.82637, 33.83617], [-117.82656, 33.83616], [-117.82661, 33.83646]]]} | Open Access 1 | 18994 | Olive Hills Tennis Courts | 23124 | 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 | 10.614 | Olive Hills Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
3192 | 3192 | 3191 | {"type": "Polygon", "coordinates": [[[-117.79028, 33.84384], [-117.79035, 33.84383], [-117.79041, 33.84386], [-117.79042, 33.8439], [-117.79042, 33.844], [-117.79036, 33.84435], [-117.79019, 33.84484], [-117.7899, 33.8448], [-117.78946, 33.84472], [-117.78895, 33.84457], [-117.78843, 33.84461], [-117.7881, 33.84458], [-117.78783, 33.8445], [-117.78761, 33.84446], [-117.78755, 33.84562], [-117.78626, 33.84563], [-117.78627, 33.84548], [-117.78631, 33.84538], [-117.78653, 33.84498], [-117.78658, 33.8448], [-117.78659, 33.84467], [-117.78657, 33.84451], [-117.78645, 33.84425], [-117.78646, 33.84421], [-117.78666, 33.84415], [-117.78687, 33.8441], [-117.7873, 33.84408], [-117.78763, 33.84412], [-117.78765, 33.8441], [-117.78775, 33.84414], [-117.7882, 33.8442], [-117.78851, 33.84421], [-117.78875, 33.8442], [-117.7889, 33.84418], [-117.78998, 33.84393], [-117.79027, 33.84386], [-117.79028, 33.84384]]]} | Open Access 1 | 22115 | Imperial Park | 20180 | 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.207 | Imperial Park | 0 | Local Park 2 | 4 | |
11959 | 11959 | 11958 | {"type": "Polygon", "coordinates": [[[-117.93511, 33.84336], [-117.9335, 33.84442], [-117.93317, 33.84477], [-117.9326, 33.84477], [-117.93259, 33.84427], [-117.93218, 33.84426], [-117.93211, 33.84425], [-117.93202, 33.84419], [-117.93347, 33.84417], [-117.93346, 33.84229], [-117.93504, 33.84216], [-117.93505, 33.84335], [-117.93511, 33.84336]]]} | Open Access 1 | 24576 | Sage Park | 24783 | 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.094 | Sage Park | 0 | Local Park 2 | 4 | |
3447 | 3447 | 3446 | {"type": "Polygon", "coordinates": [[[-117.93509, 33.80131], [-117.93497, 33.80155], [-117.93486, 33.80182], [-117.93485, 33.80146], [-117.93281, 33.80149], [-117.93277, 33.79962], [-117.9344, 33.7996], [-117.93441, 33.79927], [-117.93463, 33.79924], [-117.93474, 33.79916], [-117.93476, 33.7992], [-117.93482, 33.79925], [-117.93494, 33.79927], [-117.93468, 33.79958], [-117.93481, 33.79959], [-117.93485, 33.80119], [-117.93509, 33.80131]]]} | Open Access 1 | 25269 | Stoddard Park | 25863 | 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 | 10.242 | Stoddard 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]);