superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 57 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL ▼ | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1308 | 1308 | 1307 | {"type": "Polygon", "coordinates": [[[-117.87341, 33.82129], [-117.87227, 33.82329], [-117.87158, 33.82441], [-117.87159, 33.82526], [-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.87118, 33.82505], [-117.87069, 33.82502], [-117.8712, 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 | Anaheim Coves | 15465 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 29.091 | Anaheim Coves | ||
1318 | 1318 | 1317 | {"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.75951, 33.84902], [-117.76021, 33.84861], [-117.76209, 33.85038]]]} | Open Access 1 | Anaheim holding 1 | 15466 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 5.206 | Anaheim holding 1 | ||
1319 | 1319 | 1318 | {"type": "Polygon", "coordinates": [[[-117.7455, 33.84239], [-117.74527, 33.84244], [-117.74511, 33.84249], [-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 | Anaheim holding 2 | 15467 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 3.08 | Anaheim holding 2 | ||
1322 | 1322 | 1321 | {"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 | Anaheim holding 3 | 15468 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 3.955 | Anaheim holding 3 | ||
1332 | 1332 | 1331 | {"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.78248, 33.84499], [-117.78356, 33.84518]]]} | Open Access 1 | Anaheim holding 4 | 15469 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 4.264 | Anaheim holding 4 | ||
1786 | 1786 | 1785 | {"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 | Barton Park | 15844 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 4.502 | Barton Park | ||
2193 | 2193 | 2192 | {"type": "Polygon", "coordinates": [[[-117.89318, 33.82458], [-117.89252, 33.82475], [-117.89284, 33.82572], [-117.89126, 33.82609], [-117.89164, 33.82725], [-117.88952, 33.82775], [-117.88943, 33.82773], [-117.88941, 33.82765], [-117.88941, 33.82731], [-117.8894, 33.82549], [-117.88941, 33.82447], [-117.89102, 33.82409], [-117.89289, 33.82367], [-117.89318, 33.82458]]]} | Open Access 1 | Boysen Park | 16318 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 24.4 | Boysen Park | ||
2280 | 2280 | 2279 | {"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.9631, 33.8417], [-117.96324, 33.84183], [-117.96353, 33.84201], [-117.96386, 33.8421], [-117.96457, 33.8421], [-117.96567, 33.84206], [-117.96602, 33.84198], [-117.96637, 33.84197], [-117.96637, 33.84338]]]} | Open Access 1 | Brookhurst Park | 16423 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 26.893 | Brookhurst Park | ||
2436 | 2436 | 2435 | {"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 | Colony Square | 17539 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.163 | Colony Square | ||
2602 | 2602 | 2601 | {"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.84517], [-117.74237, 33.84503], [-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 | Canyon Rim Park | 16825 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.985 | Canyon Rim Park | ||
2834 | 2834 | 2833 | {"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 | Chaparral Park | 17125 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 9.618 | Chaparral Park | ||
2959 | 2959 | 2958 | {"type": "Polygon", "coordinates": [[[-117.90715, 33.83743], [-117.90706, 33.83744], [-117.90704, 33.8374], [-117.90695, 33.83742], [-117.90685, 33.83739], [-117.90676, 33.83739], [-117.90674, 33.83733], [-117.90667, 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.83697], [-117.90702, 33.83706], [-117.90715, 33.83743]]]} | Open Access 1 | Citrus Park | 17283 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 2.787 | Citrus Park | ||
3109 | 3109 | 3108 | {"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 | Colony Park | 17534 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.953 | Colony Park | ||
3224 | 3224 | 3223 | {"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.92052, 33.82104], [-117.92104, 33.8216]]]} | Open Access 1 | Cottonwood Park | 17687 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.387 | Cottonwood Park | ||
3859 | 3859 | 3858 | {"type": "Polygon", "coordinates": [[[-117.89577, 33.85049], [-117.8937, 33.85049], [-117.89367, 33.84909], [-117.89575, 33.84909], [-117.89577, 33.85049]]]} | Open Access 1 | Edison Park | 18445 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 7.387 | Edison Park | ||
4030 | 4030 | 4029 | {"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.93389, 33.8074], [-117.93377, 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 | Energy Field Park | 18673 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 2.55 | Energy Field Park | ||
4083 | 4083 | 4082 | {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77422, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77383, 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.85679], [-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 | Eucalyptus Park | 18740 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 9.906 | Eucalyptus Park | ||
4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-117.91259, 33.83804], [-117.91258, 33.83808], [-117.91185, 33.83823], [-117.91182, 33.83819], [-117.91156, 33.83744], [-117.91234, 33.83726], [-117.91259, 33.83804]]]} | Open Access 1 | George Washington Park | 19275 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1.678 | George Washington Park | ||
4880 | 4880 | 4879 | {"type": "Polygon", "coordinates": [[[-118.01025, 33.8141], [-118.00963, 33.8145], [-118.00962, 33.81458], [-118.00903, 33.81458], [-118.00903, 33.81504], [-118.00862, 33.81504], [-118.00641, 33.81368], [-118.00641, 33.81364], [-118.00707, 33.81363], [-118.00708, 33.81327], [-118.00725, 33.81327], [-118.00728, 33.81363], [-118.00876, 33.81362], [-118.00878, 33.81408], [-118.01021, 33.81405], [-118.01025, 33.8141]]]} | Open Access 1 | Hansen Park | 19648 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 6.621 | Hansen Park | ||
5331 | 5331 | 5330 | {"type": "Polygon", "coordinates": [[[-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.78762, 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.79026, 33.84386], [-117.79028, 33.84384], [-117.79035, 33.84383], [-117.79041, 33.84386]]]} | Open Access 1 | Imperial Park | 20180 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.219 | Imperial Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);