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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
6905 | 6905 | 6904 | {"type": "Polygon", "coordinates": [[[-117.79702, 33.84624], [-117.79632, 33.84674], [-117.79598, 33.84814], [-117.79646, 33.8488], [-117.79614, 33.84902], [-117.79607, 33.84906], [-117.79591, 33.84911], [-117.79554, 33.84916], [-117.79516, 33.84918], [-117.79479, 33.84923], [-117.79436, 33.84937], [-117.79431, 33.84936], [-117.79412, 33.84912], [-117.79412, 33.84897], [-117.79428, 33.84881], [-117.79445, 33.84832], [-117.79463, 33.84711], [-117.79442, 33.84652], [-117.7941, 33.84654], [-117.79412, 33.84558], [-117.79501, 33.84557], [-117.79542, 33.84516], [-117.7956, 33.84509], [-117.79581, 33.84495], [-117.7966, 33.84558], [-117.79687, 33.84559], [-117.79688, 33.8459], [-117.79702, 33.84624]]]} | Open Access 1 | 5749 | Pelanconi Park | 23566 | 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.924 | Pelanconi Park | 0 | Local Park 2 | 4 | |
6907 | 6907 | 6906 | {"type": "Polygon", "coordinates": [[[-117.8803, 33.84433], [-117.88029, 33.84459], [-117.87961, 33.84466], [-117.87825, 33.84498], [-117.87823, 33.84546], [-117.87708, 33.84548], [-117.87706, 33.84556], [-117.87658, 33.84557], [-117.87656, 33.84532], [-117.87648, 33.84473], [-117.87645, 33.84441], [-117.87642, 33.84389], [-117.87648, 33.84387], [-117.87646, 33.84365], [-117.87665, 33.84365], [-117.87666, 33.84368], [-117.8767, 33.84373], [-117.87677, 33.84377], [-117.87683, 33.84377], [-117.87697, 33.84372], [-117.87813, 33.8437], [-117.8789, 33.8437], [-117.87959, 33.84372], [-117.87971, 33.84372], [-117.88014, 33.84366], [-117.88021, 33.84366], [-117.88024, 33.84368], [-117.88026, 33.84382], [-117.88026, 33.84432], [-117.8803, 33.84433]]]} | Open Access 1 | 5759 | Pioneer Park | 23717 | 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.403 | Pioneer Park | 0 | Local Park 2 | 4 | |
5301 | 5301 | 5300 | {"type": "Polygon", "coordinates": [[[-117.86937, 33.84275], [-117.86936, 33.84278], [-117.86919, 33.84278], [-117.86918, 33.84293], [-117.8687, 33.84295], [-117.86874, 33.84437], [-117.86727, 33.84438], [-117.86726, 33.84355], [-117.86728, 33.84338], [-117.86741, 33.84303], [-117.86744, 33.84286], [-117.86744, 33.84196], [-117.86746, 33.84193], [-117.86925, 33.84194], [-117.86928, 33.84197], [-117.86929, 33.84202], [-117.86929, 33.84212], [-117.86925, 33.84232], [-117.8693, 33.84244], [-117.86936, 33.84248], [-117.86936, 33.84274], [-117.86937, 33.84275]]]} | Open Access 1 | 5771 | Rio Vista Park | 24387 | 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.892 | Rio Vista Park | 0 | Local Park 2 | 4 | |
16939 | 16939 | 16938 | {"type": "Polygon", "coordinates": [[[-117.75925, 33.83512], [-117.75902, 33.83501], [-117.75905, 33.83527], [-117.75901, 33.83542], [-117.75876, 33.83587], [-117.75867, 33.83597], [-117.75863, 33.83596], [-117.75855, 33.83612], [-117.7584, 33.83617], [-117.75822, 33.83657], [-117.75777, 33.83667], [-117.75783, 33.8369], [-117.75747, 33.83742], [-117.75797, 33.83775], [-117.75844, 33.83779], [-117.75899, 33.8384], [-117.7588, 33.83852], [-117.75838, 33.83852], [-117.75767, 33.83848], [-117.75766, 33.83877], [-117.75741, 33.83883], [-117.75722, 33.83893], [-117.75708, 33.83899], [-117.75678, 33.83919], [-117.7564, 33.83885], [-117.75604, 33.83904], [-117.75625, 33.83918], [-117.75575, 33.83918], [-117.75561, 33.83901], [-117.75552, 33.83882], [-117.75549, 33.83868], [-117.75555, 33.83836], [-117.75555, 33.83827], [-117.75551, 33.83816], [-117.75537, 33.83814], [-117.75402, 33.83827], [-117.75383, 33.83834], [-117.7536, 33.83821], [-117.75039, 33.83796], [-117.74954, 33.83782], [-117.74881, 33.83817], [-117.74873, 33.83822], [-117.74829, 33.83792], [-117.74822, 33.83784], [-117.74908, 33.83672], [-117.74895, 33.83667], [-117.74914, 33.83659], [-117.75055, 33.83685], [-117.75117, 33.83657], [-117.75182, 33.83693], [-117.75247, 33.83692], [-117.75296, 33.83669], [-117.75324, 33.83602], [-117.7534, 33.83596], [-117.75389, 33.83609], [-117.75478, 33.83609], [-117.75501, 33.83575], [-117.75632, 33.83536], [-117.75675, 33.83559], [-117.75707, 33.83506], [-117.75724, 33.83437], [-117.75849, 33.83402], [-117.75907, 33.83465], [-117.75915, 33.83478], [-117.75921, 33.83494], [-117.75925, 33.83512]]]} | Open Access 1 | 6042 | Oak Canyon Nature Center | 22958 | 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 | 58.559 | Oak Canyon Nature Ctr. | 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 | |
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 | |
7753 | 7753 | 7752 | {"type": "Polygon", "coordinates": [[[-117.80655, 33.85401], [-117.80228, 33.85403], [-117.80225, 33.85223], [-117.80226, 33.85213], [-117.80233, 33.85205], [-117.80271, 33.85193], [-117.80299, 33.85174], [-117.80328, 33.85162], [-117.80466, 33.8513], [-117.80467, 33.85302], [-117.80654, 33.85303], [-117.80655, 33.85401]]]} | Open Access 1 | 8328 | Peralta Canyon Park | 23604 | 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.245 | Peralta Canyon 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 | |
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]);