units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 62
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency 10
MNG_AGENCY 1
- Yorba Linda, City of · 10 ✖
ACCESS_TYP 1
- Open Access 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12877 | 12877 | 12876 | {"type": "Polygon", "coordinates": [[[-117.77905, 33.87882], [-117.77899, 33.87886], [-117.77897, 33.87889], [-117.77884, 33.87887], [-117.77865, 33.87908], [-117.7788, 33.87926], [-117.77873, 33.8794], [-117.77866, 33.87938], [-117.77855, 33.87943], [-117.77852, 33.87952], [-117.77833, 33.8798], [-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.77747, 33.87979], [-117.77705, 33.87987], [-117.77672, 33.87956], [-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.87871], [-117.77875, 33.87841], [-117.77886, 33.87848], [-117.77905, 33.87882]]]} | Open Access 1 | 30321 | Shapell Park | 25361 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.801 | Shapell Park | 0 | Local Park 2 | 4 | |
12878 | 12878 | 12877 | {"type": "Polygon", "coordinates": [[[-117.77337, 33.88169], [-117.77357, 33.88214], [-117.77368, 33.88232], [-117.77387, 33.88252], [-117.77413, 33.88273], [-117.77419, 33.88281], [-117.77421, 33.88288], [-117.77418, 33.88292], [-117.77414, 33.88294], [-117.77301, 33.88328], [-117.773, 33.88273], [-117.77295, 33.88171], [-117.77337, 33.88169]]]} | Open Access 1 | 30322 | Las Palomas Tennis Park | 21062 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 2.926 | Las Palomas Tennis Park | 0 | Local Recreation Area 3 | 4 | |
12879 | 12879 | 12878 | {"type": "Polygon", "coordinates": [[[-117.79103, 33.87264], [-117.79058, 33.87268], [-117.79038, 33.87272], [-117.78998, 33.87288], [-117.7898, 33.87298], [-117.78901, 33.87354], [-117.78878, 33.87377], [-117.78863, 33.87392], [-117.78844, 33.87421], [-117.78833, 33.87443], [-117.78827, 33.87456], [-117.78824, 33.8747], [-117.78822, 33.87493], [-117.7885, 33.875], [-117.7883, 33.87576], [-117.78825, 33.8761], [-117.78828, 33.87713], [-117.78837, 33.87859], [-117.78835, 33.87892], [-117.78827, 33.87923], [-117.78813, 33.87954], [-117.78793, 33.87983], [-117.78776, 33.88001], [-117.78746, 33.88041], [-117.78723, 33.88029], [-117.78719, 33.88026], [-117.78718, 33.88022], [-117.78783, 33.87925], [-117.78794, 33.87899], [-117.78799, 33.87872], [-117.78794, 33.87714], [-117.7879, 33.87682], [-117.78785, 33.87532], [-117.78781, 33.87462], [-117.78804, 33.87408], [-117.78829, 33.87372], [-117.78846, 33.87353], [-117.78873, 33.87327], [-117.78921, 33.87291], [-117.78964, 33.87252], [-117.79025, 33.87217], [-117.79062, 33.87192], [-117.79087, 33.87211], [-117.79093, 33.87217], [-117.79099, 33.87225], [-117.79102, 33.87235], [-117.79103, 33.87264]]]} | Open Access 1 | 30323 | Kingsbriar Park | 20666 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 10.664 | Kingsbriar Park | 0 | Local Park 2 | 4 | |
12880 | 12880 | 12879 | {"type": "MultiPolygon", "coordinates": [[[[-117.78339, 33.89132], [-117.7834, 33.89134], [-117.7833, 33.89222], [-117.78322, 33.89345], [-117.78315, 33.89373], [-117.78307, 33.89389], [-117.78277, 33.89428], [-117.78215, 33.89503], [-117.7819, 33.89535], [-117.78168, 33.89575], [-117.78164, 33.89576], [-117.78107, 33.89563], [-117.78114, 33.89559], [-117.78122, 33.89531], [-117.78126, 33.89513], [-117.78162, 33.89495], [-117.78177, 33.89483], [-117.78198, 33.89464], [-117.78245, 33.89414], [-117.78284, 33.89367], [-117.78296, 33.89343], [-117.78298, 33.89329], [-117.78302, 33.89126], [-117.78332, 33.89128], [-117.78339, 33.89132]]], [[[-117.78372, 33.8898], [-117.78373, 33.88987], [-117.78369, 33.89009], [-117.7835, 33.89064], [-117.78338, 33.8911], [-117.7833, 33.89114], [-117.78299, 33.8911], [-117.78304, 33.89069], [-117.7832, 33.89066], [-117.78318, 33.89033], [-117.78322, 33.89027], [-117.78322, 33.89021], [-117.78338, 33.8901], [-117.78335, 33.88975], [-117.78364, 33.88976], [-117.78372, 33.8898]]]]} | Open Access 1 | 30324 | Rio Del Oro Park | 24375 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.004 | Rio Del Oro Park | 0 | Local Park 2 | 4 | |
12881 | 12881 | 12880 | {"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 | 30325 | Vista Del Verde Park | 27172 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.7 | Vista Del Verde Park | 0 | Local Park 2 | 4 | |
12978 | 12978 | 12977 | {"type": "Polygon", "coordinates": [[[-117.792, 33.87101], [-117.79198, 33.87115], [-117.79198, 33.87145], [-117.79161, 33.87165], [-117.79163, 33.87218], [-117.79114, 33.8722], [-117.79107, 33.87209], [-117.7909, 33.87194], [-117.79159, 33.87124], [-117.792, 33.87101]]]} | Open Access 1 | 30446 | Brookmont Park | 16425 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 1.44 | Brookmont Park | 0 | Local Park 2 | 4 | |
12979 | 12979 | 12978 | {"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.88088], [-117.8348, 33.88065], [-117.83481, 33.88051], [-117.83523, 33.8805], [-117.83525, 33.88052], [-117.83526, 33.88056], [-117.83526, 33.88072]]]} | Open Access 1 | 30447 | Saratoga Park | 25161 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 2.599 | Saratoga Park | 0 | Local Park 2 | 4 | |
14499 | 14499 | 14498 | {"type": "Polygon", "coordinates": [[[-117.71955, 33.87588], [-117.71947, 33.87591], [-117.7194, 33.87599], [-117.7188, 33.87579], [-117.71887, 33.87567], [-117.71897, 33.87556], [-117.71909, 33.87547], [-117.71923, 33.8754], [-117.71937, 33.87564], [-117.71949, 33.87563], [-117.71955, 33.87588]]]} | Open Access 1 | 47384 | Las Brisas Park | 31107 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 0.613 | Las Brisas Park | 0 | Local Park 2 | 4 | |
14500 | 14500 | 14499 | {"type": "Polygon", "coordinates": [[[-117.79417, 33.89983], [-117.7939, 33.89981], [-117.79385, 33.89608], [-117.79364, 33.89607], [-117.79352, 33.88884], [-117.79402, 33.88884], [-117.79412, 33.89626], [-117.79398, 33.89627], [-117.79399, 33.89652], [-117.79412, 33.89653], [-117.79417, 33.89983]]]} | Open Access 1 | 47385 | Gun Club Road Linear Park | 31110 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 11.42 | Gun Club Road Linear Park | 0 | Local Park 2 | 4 | |
14501 | 14501 | 14500 | {"type": "Polygon", "coordinates": [[[-117.76291, 33.90357], [-117.76253, 33.90422], [-117.76227, 33.90392], [-117.76216, 33.90382], [-117.76203, 33.90375], [-117.76188, 33.9037], [-117.76165, 33.90367], [-117.7617, 33.90353], [-117.76291, 33.90357]]]} | Open Access 1 | 47386 | Casino Ridge Park | 31111 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 0.986 | Casino Ridge 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]);