superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 62 sorted by PARK_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8908 | 8908 | 8907 | {"type": "Polygon", "coordinates": [[[-117.7957, 33.87147], [-117.79535, 33.87176], [-117.79514, 33.87188], [-117.79406, 33.87241], [-117.79388, 33.87247], [-117.7938, 33.87221], [-117.79385, 33.87218], [-117.79387, 33.87176], [-117.79437, 33.8717], [-117.79459, 33.87144], [-117.79459, 33.87131], [-117.79516, 33.87131], [-117.7957, 33.87147]]]} | Open Access 1 | Roland Bigonger Park | 24570 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 2.611 | Roland Bigonger Park | ||
15444 | 15444 | 15443 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84093, 33.89378], [-117.84122, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | Rose Drive Elementary School Recreational Facilities | 31157 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 7.309 | Rose Drive Elementary School Recreational Facilities | ||
9156 | 9156 | 9155 | {"type": "Polygon", "coordinates": [[[-117.76807, 33.90058], [-117.76805, 33.90172], [-117.76745, 33.90161], [-117.76653, 33.90194], [-117.76642, 33.90185], [-117.76624, 33.90176], [-117.7661, 33.90172], [-117.7659, 33.90171], [-117.76563, 33.90173], [-117.7652, 33.90185], [-117.76499, 33.90186], [-117.76471, 33.90183], [-117.76465, 33.90179], [-117.76466, 33.90151], [-117.76463, 33.90124], [-117.76433, 33.90031], [-117.76436, 33.90029], [-117.76471, 33.90019], [-117.76495, 33.90081], [-117.7652, 33.9008], [-117.76521, 33.90031], [-117.76541, 33.90052], [-117.76653, 33.90065], [-117.7669, 33.90065], [-117.76755, 33.90058], [-117.76807, 33.90058]]]} | Open Access 1 | San Antonio Park | 24835 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 10.616 | San Antonio Park | ||
9370 | 9370 | 9369 | {"type": "Polygon", "coordinates": [[[-117.83526, 33.88072], [-117.83504, 33.88073], [-117.83485, 33.88092], [-117.83488, 33.88194], [-117.83481, 33.8822], [-117.83483, 33.88223], [-117.8348, 33.88225], [-117.83477, 33.88229], [-117.83476, 33.88236], [-117.83478, 33.88241], [-117.83474, 33.88245], [-117.83475, 33.88274], [-117.83437, 33.88275], [-117.83436, 33.88088], [-117.83456, 33.88087], [-117.8348, 33.88066], [-117.83481, 33.88051], [-117.83523, 33.8805], [-117.83525, 33.88052], [-117.83526, 33.88056], [-117.83526, 33.88072]]]} | Open Access 1 | Saratoga Park | 25161 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 2.601 | Saratoga Park | ||
9556 | 9556 | 9555 | {"type": "Polygon", "coordinates": [[[-117.77905, 33.87882], [-117.77899, 33.87886], [-117.77897, 33.87889], [-117.77884, 33.87888], [-117.77866, 33.87907], [-117.7788, 33.87926], [-117.77873, 33.8794], [-117.77866, 33.87938], [-117.77855, 33.87943], [-117.77852, 33.87952], [-117.77834, 33.87979], [-117.77858, 33.87992], [-117.77866, 33.87993], [-117.77865, 33.88007], [-117.77848, 33.88004], [-117.77807, 33.87987], [-117.77775, 33.8798], [-117.77746, 33.87979], [-117.77705, 33.87987], [-117.77672, 33.87957], [-117.77618, 33.87996], [-117.77617, 33.88009], [-117.77613, 33.88012], [-117.77582, 33.87979], [-117.77583, 33.87973], [-117.77588, 33.87966], [-117.77626, 33.87941], [-117.77649, 33.87921], [-117.77674, 33.87891], [-117.77683, 33.87877], [-117.77722, 33.87883], [-117.77755, 33.87877], [-117.77803, 33.87858], [-117.77865, 33.8787], [-117.77875, 33.87841], [-117.77886, 33.87848], [-117.77905, 33.87882]]]} | Open Access 1 | Shapell Park | 25361 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.814 | Shapell Park | ||
10447 | 10447 | 10446 | {"type": "Polygon", "coordinates": [[[-117.76123, 33.88455], [-117.76003, 33.88457], [-117.76003, 33.88439], [-117.75976, 33.88438], [-117.75977, 33.88407], [-117.75945, 33.88382], [-117.75828, 33.88381], [-117.75824, 33.88297], [-117.75902, 33.88303], [-117.75936, 33.88297], [-117.75965, 33.88264], [-117.75941, 33.88235], [-117.75956, 33.88227], [-117.75966, 33.88224], [-117.75991, 33.88219], [-117.76004, 33.88218], [-117.76019, 33.88218], [-117.76041, 33.88222], [-117.76057, 33.88229], [-117.76074, 33.88239], [-117.76099, 33.88258], [-117.76121, 33.88268], [-117.76122, 33.88271], [-117.76121, 33.88302], [-117.76123, 33.88455]]]} | Open Access 1 | Travis Ranch Park | 26515 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 11.803 | Travis Ranch Park | ||
13621 | 13621 | 13620 | {"type": "Polygon", "coordinates": [[[-117.82853, 33.89184], [-117.82817, 33.89197], [-117.82799, 33.89201], [-117.82759, 33.89206], [-117.82747, 33.89209], [-117.82732, 33.89215], [-117.82719, 33.89224], [-117.82688, 33.89253], [-117.82632, 33.89311], [-117.82612, 33.89323], [-117.82593, 33.89329], [-117.82571, 33.8933], [-117.82521, 33.89324], [-117.82534, 33.8932], [-117.82536, 33.89213], [-117.82549, 33.89178], [-117.8255, 33.89028], [-117.82852, 33.89025], [-117.82853, 33.89184]], [[-117.8274, 33.89046], [-117.82742, 33.89038], [-117.82738, 33.89037], [-117.82737, 33.89044], [-117.8274, 33.89046]]]} | Open Access 1 | Veterans Park | 31086 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 17.978 | Veterans Park | ||
10951 | 10951 | 10950 | {"type": "Polygon", "coordinates": [[[-117.82627, 33.9047], [-117.82616, 33.90487], [-117.82525, 33.90443], [-117.82487, 33.90428], [-117.82447, 33.90415], [-117.82406, 33.90405], [-117.82441, 33.90353], [-117.82466, 33.90333], [-117.82472, 33.90307], [-117.82625, 33.90306], [-117.82627, 33.9047]]]} | Open Access 1 | Vista Del Verde Park | 27172 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.7 | Vista Del Verde Park | ||
13815 | 13815 | 13814 | {"type": "Polygon", "coordinates": [[[-117.81163, 33.90348], [-117.81127, 33.90335], [-117.81104, 33.90329], [-117.81069, 33.90324], [-117.8101, 33.90324], [-117.81004, 33.90322], [-117.81001, 33.90318], [-117.80999, 33.90318], [-117.80995, 33.90325], [-117.80988, 33.9033], [-117.80931, 33.90356], [-117.80928, 33.9036], [-117.80922, 33.90359], [-117.80926, 33.90352], [-117.80943, 33.90341], [-117.80943, 33.90339], [-117.8097, 33.90319], [-117.80979, 33.90305], [-117.80979, 33.90293], [-117.80973, 33.90281], [-117.80962, 33.90273], [-117.80944, 33.90265], [-117.80953, 33.9025], [-117.8095, 33.90244], [-117.8095, 33.90239], [-117.80973, 33.90208], [-117.80977, 33.902], [-117.80979, 33.90187], [-117.80974, 33.90173], [-117.81006, 33.9018], [-117.81038, 33.90185], [-117.81121, 33.90181], [-117.81124, 33.90227], [-117.8113, 33.90257], [-117.81128, 33.9026], [-117.81142, 33.90304], [-117.81163, 33.90348]]]} | Open Access 1 | Vista Del Verde Park II | 31337 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.318 | Vista Del Verde Park II | ||
13623 | 13623 | 13622 | {"type": "Polygon", "coordinates": [[[-117.72318, 33.87548], [-117.72311, 33.87587], [-117.7229, 33.87584], [-117.72266, 33.87578], [-117.72254, 33.87582], [-117.72248, 33.87589], [-117.72204, 33.87581], [-117.72218, 33.87558], [-117.72251, 33.87523], [-117.72255, 33.87523], [-117.72297, 33.87543], [-117.72318, 33.87548]]]} | Open Access 1 | Vista Lampara Park | 31088 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1.193 | Vista Lampara 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]);