units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where DES_TP = 2 and MNG_AGENCY = 57 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 49
MNG_AGENCY 1
- Anaheim, City of · 49 ✖
DES_TP 1
- Local Park · 49 ✖
ACCESS_TYP 1
- Open Access 49
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12157 | 12157 | 12156 | {"type": "Polygon", "coordinates": [[[-117.94727, 33.81898], [-117.94727, 33.81912], [-117.94726, 33.81914], [-117.94693, 33.81915], [-117.94689, 33.81912], [-117.94689, 33.81897], [-117.94692, 33.81894], [-117.94723, 33.81894], [-117.94726, 33.81895], [-117.94727, 33.81898]]]} | Open Access 1 | 48741 | Circle Park | 33467 | 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 | https://www.anaheim.net/facilities/facility/details/Circle-Park-444 | Orange 3 | 0.194 | Circle Park | 0 | Local Park 2 | 4 |
3430 | 3430 | 3429 | {"type": "Polygon", "coordinates": [[[-117.91342, 33.83503], [-117.91294, 33.83515], [-117.91282, 33.83479], [-117.91293, 33.83476], [-117.91288, 33.83459], [-117.91329, 33.8345], [-117.9133, 33.83457], [-117.91331, 33.83469], [-117.91342, 33.83503]]]} | Open Access 1 | 48740 | Friendship Plaza | 33466 | 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 | https://www.anaheim.net/facilities/facility/details/Friendship-Plaza-86 | Orange 3 | 0.663 | Friendship Plaza | 0 | Local Park 2 | 4 |
14950 | 14950 | 14949 | {"type": "Polygon", "coordinates": [[[-117.92815, 33.83616], [-117.92787, 33.83623], [-117.92791, 33.83637], [-117.92783, 33.83639], [-117.92776, 33.8362], [-117.92757, 33.83624], [-117.92744, 33.83587], [-117.928, 33.83575], [-117.92815, 33.83616]]]} | Open Access 1 | 45555 | Founders' Park | 28381 | 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.648 | Founders' Park | 0 | Local Park 2 | 4 | |
14853 | 14853 | 14852 | {"type": "Polygon", "coordinates": [[[-117.90684, 33.83022], [-117.90683, 33.83026], [-117.90596, 33.83046], [-117.90591, 33.83044], [-117.90591, 33.83039], [-117.90594, 33.83034], [-117.90592, 33.83019], [-117.90585, 33.83018], [-117.9058, 33.83014], [-117.9058, 33.8301], [-117.90582, 33.83006], [-117.90674, 33.82985], [-117.90677, 33.82996], [-117.90673, 33.83006], [-117.90674, 33.83011], [-117.90684, 33.83022]]]} | Open Access 1 | 45355 | Colony Park | 17534 | 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.952 | Colony Park | 0 | Local Park 2 | 4 | |
14852 | 14852 | 14851 | {"type": "Polygon", "coordinates": [[[-117.76165, 33.86608], [-117.76134, 33.8665], [-117.76099, 33.86678], [-117.76044, 33.86699], [-117.75997, 33.86736], [-117.75959, 33.86755], [-117.7591, 33.86766], [-117.75773, 33.86767], [-117.75736, 33.86769], [-117.75638, 33.86789], [-117.75598, 33.868], [-117.75557, 33.86803], [-117.75557, 33.86773], [-117.75555, 33.86772], [-117.75275, 33.86818], [-117.7545, 33.86471], [-117.75434, 33.86164], [-117.75405, 33.86148], [-117.75317, 33.86103], [-117.75291, 33.86085], [-117.75259, 33.86073], [-117.75223, 33.86065], [-117.75184, 33.8606], [-117.75135, 33.86059], [-117.75148, 33.86042], [-117.75152, 33.86008], [-117.75124, 33.85984], [-117.75101, 33.85984], [-117.75082, 33.85989], [-117.75033, 33.85989], [-117.75015, 33.86015], [-117.75007, 33.86015], [-117.74998, 33.86019], [-117.74956, 33.8602], [-117.74955, 33.8597], [-117.75288, 33.85971], [-117.7532, 33.85848], [-117.75327, 33.8585], [-117.75334, 33.85849], [-117.75339, 33.85845], [-117.75342, 33.8584], [-117.75342, 33.85836], [-117.75337, 33.85825], [-117.75333, 33.85806], [-117.75445, 33.8579], [-117.75487, 33.85754], [-117.75408, 33.857], [-117.75407, 33.85678], [-117.75414, 33.85612], [-117.75405, 33.85598], [-117.75405, 33.85478], [-117.75353, 33.85504], [-117.75329, 33.85472], [-117.75308, 33.8545], [-117.75282, 33.85434], [-117.75243, 33.85469], [-117.75227, 33.85464], [-117.75224, 33.85462], [-117.75219, 33.85452], [-117.75209, 33.85448], [-117.75202, 33.8545], [-117.75192, 33.85454], [-117.75183, 33.85454], [-117.7523, 33.85425], [-117.75258, 33.85411], [-117.75266, 33.85397], [-117.75251, 33.85264], [-117.75263, 33.85212], [-117.75262, 33.85122], [-117.75275, 33.8512], [-117.75232, 33.84957], [-117.75165, 33.84849], [-117.75082, 33.84817], [-117.75065, 33.84817], [-117.75054, 33.84828], [-117.74889, 33.84894], [-117.74869, 33.84889], [-117.74854, 33.84892], [-117.74821, 33.8489], [-117.74721, 33.84934], [-117.74668, 33.84977], [-117.7462, 33.85002], [-117.7458, 33.85035], [-117.74536, 33.85046], [-117.74508, 33.85036], [-117.74475, 33.85061], [-117.74384, 33.85085], [-117.74384, 33.85086], [-117.74492, 33.85126], [-117.7452, 33.85131], [-117.74528, 33.85136], [-117.7454, 33.85137], [-117.74545, 33.8514], [-117.74548, 33.85143], [-117.74527, 33.85174], [-117.74486, 33.85158], [-117.74459, 33.8515], [-117.7435, 33.85136], [-117.74302, 33.85123], [-117.74242, 33.85102], [-117.74256, 33.85085], [-117.74257, 33.85075], [-117.74255, 33.85053], [-117.74258, 33.85011], [-117.74266, 33.84987], [-117.74276, 33.84968], [-117.74304, 33.84939], [-117.74327, 33.84922], [-117.74417, 33.84919], [-117.74421, 33.84906], [-117.74381, 33.84893], [-117.74381, 33.84887], [-117.74365, 33.8487], [-117.74349, 33.84848], [-117.74339, 33.84829], [-117.74325, 33.84824], [-117.74324, 33.84785], [-117.74321, 33.84774], [-117.74308, 33.84763], [-117.7431, 33.84762], [-117.74312, 33.84756], [-117.7433, 33.84766], [-117.74335, 33.84764], [-117.7435, 33.84742], [-117.74378, 33.8471], [-117.74385, 33.84697], [-117.74391, 33.84678], [-117.74391, 33.84659], [-117.74385, 33.84628], [-117.74383, 33.84614], [-117.74387, 33.84592], [-117.74391, 33.84581], [-117.74392, 33.84573], [-117.74391, 33.84562], [-117.7438, 33.84535], [-117.74361, 33.8451], [-117.74366, 33.84506], [-117.74371, 33.84505], [-117.74385, 33.84513], [-117.74388, 33.84517], [-117.74391, 33.84523], [-117.74389, 33.84535], [-117.7439, 33.84541], [-117.74395, 33.84545], [-117.74401, 33.84547], [-117.74413, 33.84545], [-117.74418, 33.8454], [-117.74441, 33.84536], [-117.74448, 33.84531], [-117.74442, 33.84515], [-117.74433, 33.84502], [-117.74432, 33.84492], [-117.74411, 33.84468], [-117.74394, 33.84459], [-117.74399, 33.84447], [-117.74405, 33.84415], [-117.74431, 33.84413], [-117.74426, 33.84392], [-117.74437, 33.84399], [-117.74444, 33.84401], [-117.74451, 33.84415], [-117.74467, 33.84444], [-117.74535, 33.84514], [-117.74544, 33.84521], [-117.7464, 33.84704], [-117.74718, 33.84711], [-117.74749, 33.84634], [-117.74927, 33.8474], [-117.75018, 33.84739], [-117.75017, 33.84673], [-117.75037, 33.84653], [-117.75048, 33.84638], [-117.75055, 33.84631], [-117.75062, 33.84626], [-117.75077, 33.8462], [-117.75091, 33.84616], [-117.75134, 33.84613], [-117.75162, 33.84627], [-117.75163, 33.8466], [-117.75215, 33.84713], [-117.75235, 33.84739], [-117.7527, 33.84739], [-117.75282, 33.84727], [-117.75289, 33.84726], [-117.75291, 33.84718], [-117.75342, 33.84667], [-117.75395, 33.84664], [-117.75418, 33.8466], [-117.7543, 33.84663], [-117.75436, 33.84669], [-117.75445, 33.84718], [-117.75325, 33.84851], [-117.75353, 33.84861], [-117.7546, 33.8491], [-117.75372, 33.8497], [-117.75379, 33.8504], [-117.75416, 33.8508], [-117.75739, 33.84813], [-117.75745, 33.84842], [-117.75751, 33.84858], [-117.75762, 33.84878], [-117.75776, 33.84898], [-117.75791, 33.84913], [-117.75809, 33.84927], [-117.75836, 33.84944], [-117.75855, 33.84952], [-117.75644, 33.85073], [-117.75489, 33.85167], [-117.75527, 33.85288], [-117.75557, 33.85402], [-117.75511, 33.85425], [-117.75571, 33.85594], [-117.7559, 33.85658], [-117.75669, 33.85816], [-117.75716, 33.85972], [-117.75757, 33.86043], [-117.75872, 33.8604], [-117.7589, 33.86054], [-117.75915, 33.86112], [-117.75867, 33.86113], [-117.75861, 33.86107], [-117.75827, 33.86126], [-117.75844, 33.86147], [-117.75864, 33.86137], [-117.75896, 33.86182], [-117.75946, 33.8618], [-117.75964, 33.86208], [-117.76001, 33.86241], [-117.75965, 33.86262], [-117.76042, 33.86425], [-117.76056, 33.86463], [-117.76069, 33.8655], [-117.76093, 33.86573], [-117.76144, 33.86572], [-117.76133, 33.86606], [-117.76165, 33.86608]]]} | Open Access 1 | 45353 | Deer Canyon Park | 129 | 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 | http://www.anaheim.net/comm_svc/parks/parkDetail.asp?dir=park_deer_canyon_preserve | Orange 3 | 287.457 | Deer Canyon Park | 0 | Local Park 2 | 4 |
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 | |
4924 | 4924 | 4923 | {"type": "Polygon", "coordinates": [[[-117.74708, 33.86458], [-117.74635, 33.86471], [-117.74625, 33.86471], [-117.74606, 33.86465], [-117.74576, 33.86448], [-117.74595, 33.86423], [-117.74609, 33.8641], [-117.74621, 33.86402], [-117.74676, 33.86381], [-117.74708, 33.86458]]]} | Open Access 1 | 30343 | Roosevelt Park | 24596 | 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.848 | Roosevelt 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 | |
4922 | 4922 | 4921 | {"type": "Polygon", "coordinates": [[[-117.91223, 33.83697], [-117.91193, 33.83704], [-117.91187, 33.83683], [-117.91216, 33.83677], [-117.91223, 33.83697]]]} | Open Access 1 | 30341 | Colony Square | 17539 | 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.163 | Colony Square | 0 | Local Park 2 | 4 | |
4921 | 4921 | 4920 | {"type": "Polygon", "coordinates": [[[-117.92104, 33.8216], [-117.92098, 33.82164], [-117.92092, 33.82159], [-117.92078, 33.82154], [-117.92025, 33.82105], [-117.92021, 33.82099], [-117.92044, 33.82094], [-117.92051, 33.82104], [-117.92104, 33.8216]]]} | Open Access 1 | 30340 | Cottonwood Park | 17687 | 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.387 | Cottonwood Park | 0 | Local Park 2 | 4 | |
3655 | 3655 | 3654 | {"type": "Polygon", "coordinates": [[[-118.01025, 33.8141], [-118.00963, 33.8145], [-118.00962, 33.81458], [-118.00903, 33.81457], [-118.00903, 33.81504], [-118.00862, 33.81504], [-118.00641, 33.81368], [-118.00641, 33.81364], [-118.00708, 33.81363], [-118.00708, 33.81327], [-118.00725, 33.81327], [-118.00727, 33.81363], [-118.00876, 33.81362], [-118.00878, 33.81408], [-118.01021, 33.81405], [-118.01025, 33.8141]]]} | Open Access 1 | 29596 | Hansen Park | 19648 | 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 | 6.605 | Hansen 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);