units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 57 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 5
MNG_AG_TYP 1
- City Agency 59
MNG_AGENCY 1
- Anaheim, City of · 59 ✖
ACCESS_TYP 1
- Open Access 59
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
794 | 794 | 793 | {"type": "Polygon", "coordinates": [[[-117.98034, 33.82842], [-117.97815, 33.82845], [-117.97813, 33.82675], [-117.9773, 33.82676], [-117.97729, 33.82592], [-117.97784, 33.8259], [-117.97784, 33.82578], [-117.97812, 33.82576], [-117.97812, 33.8256], [-117.97826, 33.82558], [-117.97827, 33.82525], [-117.97837, 33.82523], [-117.97838, 33.825], [-117.97961, 33.82499], [-117.97962, 33.82579], [-117.9803, 33.82579], [-117.98034, 33.82842]]]} | Open Access 1 | 5169 | Maxwell Park | 21970 | 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 | 19.293 | Maxwell 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 | |
3560 | 3560 | 3559 | {"type": "Polygon", "coordinates": [[[-117.97816, 33.85487], [-117.97665, 33.85405], [-117.97656, 33.85345], [-117.97814, 33.85344], [-117.97816, 33.85487]]]} | Open Access 1 | 36526 | Anaheim holding 3 | 15468 | 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 | 3.956 | Anaheim holding 3 | 0 | Local Other or Unknown 14 | 4 | |
6285 | 6285 | 6284 | {"type": "Polygon", "coordinates": [[[-117.96637, 33.84338], [-117.96522, 33.84339], [-117.96505, 33.84338], [-117.96434, 33.84339], [-117.96128, 33.84344], [-117.96128, 33.84194], [-117.96123, 33.83994], [-117.96283, 33.83992], [-117.96287, 33.83993], [-117.9629, 33.83997], [-117.963, 33.84154], [-117.96311, 33.84171], [-117.96324, 33.84183], [-117.96353, 33.84201], [-117.96386, 33.8421], [-117.96457, 33.8421], [-117.96568, 33.84206], [-117.96602, 33.84198], [-117.96637, 33.84197], [-117.96637, 33.84338]]]} | Open Access 1 | 1378 | Brookhurst Park | 16423 | 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.893 | Brookhurst Park | 0 | Local Park 2 | 4 | |
634 | 634 | 633 | {"type": "Polygon", "coordinates": [[[-117.9554, 33.84805], [-117.95368, 33.84806], [-117.95368, 33.8491], [-117.95233, 33.8491], [-117.95213, 33.8491], [-117.95203, 33.84908], [-117.95185, 33.84902], [-117.95176, 33.84896], [-117.95128, 33.84856], [-117.95129, 33.84853], [-117.95147, 33.84836], [-117.95159, 33.84822], [-117.95174, 33.84797], [-117.95186, 33.84769], [-117.95191, 33.84749], [-117.95192, 33.84719], [-117.95194, 33.84716], [-117.95198, 33.84715], [-117.95536, 33.84711], [-117.95538, 33.84713], [-117.95539, 33.84716], [-117.9554, 33.84805]]]} | Open Access 1 | 2521 | John Marshall Park | 20457 | 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 | 13.948 | John Marshall Park | 0 | Local Park 2 | 4 | |
6634 | 6634 | 6633 | {"type": "Polygon", "coordinates": [[[-117.95445, 33.81559], [-117.95025, 33.8156], [-117.95024, 33.81368], [-117.95027, 33.81366], [-117.95059, 33.81366], [-117.95079, 33.81364], [-117.95144, 33.81352], [-117.95347, 33.81352], [-117.95433, 33.81349], [-117.95441, 33.8135], [-117.95443, 33.81353], [-117.95445, 33.81559]]]} | Open Access 1 | 5403 | Modjeska Park | 22343 | 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 | 21.845 | Modjeska 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 | |
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 |
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 | |
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 | |
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 | |
3781 | 3781 | 3780 | {"type": "Polygon", "coordinates": [[[-117.93457, 33.80691], [-117.93442, 33.80719], [-117.93423, 33.80745], [-117.93415, 33.80743], [-117.93406, 33.80742], [-117.93397, 33.80743], [-117.9339, 33.8074], [-117.93378, 33.8074], [-117.93373, 33.80741], [-117.93365, 33.80747], [-117.93366, 33.80767], [-117.93284, 33.80768], [-117.93284, 33.80692], [-117.93457, 33.80691]]]} | Open Access 1 | 8684 | Energy Field Park | 18673 | 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.549 | Energy Field Park | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 |
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]);