units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 57 sorted by DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14832 | 14832 | 14831 | {"type": "Polygon", "coordinates": [[[-117.87341, 33.82129], [-117.87227, 33.82329], [-117.87158, 33.82441], [-117.87159, 33.82527], [-117.87155, 33.82545], [-117.87154, 33.82901], [-117.86945, 33.82901], [-117.86949, 33.82941], [-117.86947, 33.83085], [-117.86906, 33.83254], [-117.86714, 33.83252], [-117.86853, 33.82927], [-117.86873, 33.8287], [-117.86935, 33.82841], [-117.87049, 33.82854], [-117.87093, 33.82834], [-117.87094, 33.82811], [-117.87059, 33.82753], [-117.87062, 33.82706], [-117.87077, 33.82658], [-117.87092, 33.82626], [-117.87085, 33.82545], [-117.87105, 33.82527], [-117.87119, 33.82504], [-117.87069, 33.82502], [-117.87121, 33.82417], [-117.87138, 33.82369], [-117.87165, 33.82305], [-117.872, 33.82273], [-117.87245, 33.82211], [-117.87272, 33.82158], [-117.87341, 33.82129]]]} | Open Access 1 | 45358 | Anaheim Coves | 15465 | 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 | 29.073 | Anaheim Coves | None 1274 | |||
14679 | 14679 | 14678 | {"type": "Polygon", "coordinates": [[[-117.9095, 33.81358], [-117.9095, 33.81395], [-117.90904, 33.81394], [-117.90899, 33.81392], [-117.90899, 33.81358], [-117.9095, 33.81358]]]} | Open Access 1 | 44986 | Paul Revere Park Development | 23533 | 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.478 | Paul Revere Park Development | None 1255 | |||
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 | |
4813 | 4813 | 4812 | {"type": "MultiPolygon", "coordinates": [[[[-117.91074, 33.8344], [-117.9097, 33.83464], [-117.90958, 33.83429], [-117.91063, 33.83404], [-117.91074, 33.8344]]], [[[-117.91175, 33.83527], [-117.91127, 33.83537], [-117.9112, 33.83526], [-117.91055, 33.83541], [-117.91028, 33.8346], [-117.9103, 33.83456], [-117.91076, 33.83445], [-117.9108, 33.83457], [-117.91083, 33.83459], [-117.91099, 33.8346], [-117.91111, 33.83496], [-117.91163, 33.83486], [-117.91175, 33.83527]]]]} | Open Access 1 | 48752 | Unknown Park - Anaheim, City of | 33479 | 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.033 | 0 | Local Other or Unknown 14 | 4 | ||
13914 | 13914 | 13913 | {"type": "Polygon", "coordinates": [[[-117.7455, 33.84239], [-117.74526, 33.84244], [-117.74511, 33.8425], [-117.74493, 33.84267], [-117.74482, 33.8429], [-117.74482, 33.84306], [-117.74493, 33.84329], [-117.74499, 33.84337], [-117.7443, 33.84341], [-117.74474, 33.84199], [-117.74489, 33.84174], [-117.74538, 33.84107], [-117.74549, 33.84113], [-117.7455, 33.84239]]]} | Open Access 1 | 36519 | Anaheim holding 2 | 15467 | 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.08 | Anaheim holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13937 | 13937 | 13936 | {"type": "Polygon", "coordinates": [[[-117.78356, 33.84518], [-117.78356, 33.84564], [-117.78066, 33.84564], [-117.78019, 33.84566], [-117.78021, 33.84548], [-117.78026, 33.84543], [-117.78065, 33.84536], [-117.78158, 33.84505], [-117.78172, 33.84502], [-117.78206, 33.84499], [-117.7823, 33.845], [-117.78247, 33.84499], [-117.78356, 33.84518]]]} | Open Access 1 | 36544 | Anaheim holding 4 | 15469 | 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.264 | Anaheim holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13998 | 13998 | 13997 | {"type": "Polygon", "coordinates": [[[-117.76209, 33.85038], [-117.76198, 33.85034], [-117.76192, 33.85035], [-117.76201, 33.85075], [-117.76133, 33.85022], [-117.76105, 33.85004], [-117.76077, 33.8499], [-117.76053, 33.84979], [-117.76024, 33.84969], [-117.75984, 33.84959], [-117.75914, 33.84946], [-117.759, 33.84933], [-117.75885, 33.84913], [-117.75933, 33.84883], [-117.7595, 33.84902], [-117.76021, 33.84861], [-117.76209, 33.85038]]]} | Open Access 1 | 36682 | Anaheim holding 1 | 15466 | 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.203 | Anaheim holding 1 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
14694 | 14694 | 14693 | {"type": "Polygon", "coordinates": [[[-117.87789, 33.85315], [-117.87828, 33.85347], [-117.87829, 33.85352], [-117.87826, 33.85357], [-117.87816, 33.8536], [-117.87802, 33.8536], [-117.87749, 33.85356], [-117.87737, 33.85357], [-117.877, 33.85366], [-117.87768, 33.85322], [-117.8778, 33.85322], [-117.87789, 33.85315]]]} | Open Access 1 | 45056 | Miraloma Park and Community Center | 28051 | 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/2206/Miraloma-Park-Family-Resource-Center | Orange 3 | 0.744 | Miraloma Park and Community Ctr. | 2015 | Local Recreation Area 3 | 4 |
149 | 149 | 148 | {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77421, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77384, 33.85862], [-117.77368, 33.85847], [-117.77332, 33.85794], [-117.77303, 33.85744], [-117.77303, 33.85684], [-117.77418, 33.8563], [-117.77437, 33.85656], [-117.77436, 33.85678], [-117.77438, 33.8569], [-117.77443, 33.85701], [-117.77465, 33.85731], [-117.77471, 33.85734], [-117.77478, 33.85736], [-117.7749, 33.85735], [-117.77568, 33.85853]]]} | Open Access 1 | 381 | Eucalyptus Park | 18740 | 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.905 | Eucalyptus 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 | |
646 | 646 | 645 | {"type": "Polygon", "coordinates": [[[-117.92364, 33.84736], [-117.92392, 33.8483], [-117.92397, 33.84862], [-117.924, 33.84983], [-117.92398, 33.84989], [-117.92393, 33.84991], [-117.92388, 33.8499], [-117.92081, 33.84838], [-117.9201, 33.84805], [-117.91997, 33.84795], [-117.91993, 33.84787], [-117.91994, 33.84743], [-117.91996, 33.84738], [-117.92002, 33.84735], [-117.92356, 33.84733], [-117.92364, 33.84736]]]} | Open Access 1 | 3194 | La Palma Park | 20780 | 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.03 | La Palma 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 | |
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 | |
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 | |
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 | |
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 | |
1363 | 1363 | 1362 | {"type": "Polygon", "coordinates": [[[-117.92015, 33.83653], [-117.9208, 33.83845], [-117.92079, 33.83849], [-117.91739, 33.83929], [-117.91733, 33.83928], [-117.91671, 33.83737], [-117.91673, 33.83732], [-117.91696, 33.83724], [-117.92011, 33.83652], [-117.92015, 33.83653]]]} | Open Access 1 | 8146 | Pearson Park | 23549 | 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 | 18.827 | Pearson Park | 0 | Local Park 2 | 4 | |
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 |
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]);