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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 | |
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 | |
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 | |
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 |
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 | |
5084 | 5084 | 5083 | {"type": "Polygon", "coordinates": [[[-117.91582, 33.83142], [-117.9148, 33.83166], [-117.91469, 33.83133], [-117.9157, 33.83108], [-117.91582, 33.83142]]]} | Open Access 1 | 4287 | Little Peoples Park | 21352 | 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.933 | Little Peoples 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 | |
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 | |
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 | |
868 | 868 | 867 | {"type": "Polygon", "coordinates": [[[-117.90715, 33.83743], [-117.90706, 33.83744], [-117.90704, 33.8374], [-117.90695, 33.83742], [-117.90686, 33.83739], [-117.90676, 33.83739], [-117.90674, 33.83733], [-117.90666, 33.83734], [-117.90666, 33.8374], [-117.90662, 33.83743], [-117.90654, 33.83742], [-117.90641, 33.83707], [-117.90577, 33.83514], [-117.90619, 33.83504], [-117.90682, 33.83698], [-117.90702, 33.83706], [-117.90715, 33.83743]]]} | Open Access 1 | 5616 | Citrus Park | 17283 | 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.785 | Citrus 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 | |
4126 | 4126 | 4125 | {"type": "Polygon", "coordinates": [[[-117.95235, 33.82235], [-117.95064, 33.82235], [-117.95063, 33.8223], [-117.95024, 33.8223], [-117.95024, 33.82151], [-117.95235, 33.82148], [-117.95235, 33.82235]]]} | Open Access 1 | 2074 | Barton Park | 15844 | 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.503 | Barton Park | 0 | Local Park 2 | 4 | |
1202 | 1202 | 1201 | {"type": "Polygon", "coordinates": [[[-117.97826, 33.84135], [-117.97825, 33.84136], [-117.97826, 33.84163], [-117.97826, 33.84221], [-117.97824, 33.84225], [-117.97636, 33.84226], [-117.9763, 33.84225], [-117.97627, 33.84222], [-117.97626, 33.84138], [-117.97826, 33.84133], [-117.97826, 33.84135]]]} | Open Access 1 | 8374 | Peter Marshall Park | 23627 | 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.555 | Peter Marshall 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 | |
1262 | 1262 | 1261 | {"type": "MultiPolygon", "coordinates": [[[[-117.89776, 33.83845], [-117.89744, 33.83852], [-117.8974, 33.83843], [-117.89723, 33.83847], [-117.89726, 33.83856], [-117.89642, 33.83876], [-117.89596, 33.83739], [-117.89613, 33.83735], [-117.89625, 33.83769], [-117.89741, 33.83742], [-117.89776, 33.83845]]], [[[-117.89914, 33.83875], [-117.89831, 33.83894], [-117.89807, 33.83828], [-117.89891, 33.83808], [-117.89914, 33.83875]]]]} | Open Access 1 | 5693 | Lincoln Park | 21261 | 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 | 5.389 | Lincoln Park | 0 | Local Park 2 | 4 | |
883 | 883 | 882 | {"type": "Polygon", "coordinates": [[[-117.92915, 33.8519], [-117.92914, 33.85374], [-117.92542, 33.85307], [-117.92542, 33.85294], [-117.92772, 33.85294], [-117.92915, 33.8519]]]} | Open Access 1 | 5707 | Manzanita Park | 21768 | 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.245 | Manzanita 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 | |
7656 | 7656 | 7655 | {"type": "Polygon", "coordinates": [[[-117.93923, 33.81516], [-117.93707, 33.81517], [-117.93707, 33.81567], [-117.9365, 33.81567], [-117.93647, 33.81432], [-117.93738, 33.81432], [-117.93744, 33.81431], [-117.93752, 33.81427], [-117.93923, 33.81427], [-117.93923, 33.81516]]]} | Open Access 1 | 7530 | Palm Lane Park | 23341 | 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.859 | Palm Lane 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]);