superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where ACCESS_TYP = 2 and MNG_AGENCY = 240 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
MNG_AG_TYP 1
MNG_AGENCY 1
- Woodbridge Village Association · 31 ✖
ACCESS_TYP 1
- Restricted Access · 31 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1448 | 1448 | 1447 | {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} | Restricted Access 2 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 0.596 | Woodspring Pool | ||
13209 | 13209 | 13208 | {"type": "Polygon", "coordinates": [[[-117.79818, 33.68706], [-117.79785, 33.68708], [-117.79776, 33.68632], [-117.79809, 33.68629], [-117.79818, 33.68706]]]} | Restricted Access 2 | Pebblewood Park | 32338 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 0.639 | Pebblewood Park | ||
12340 | 12340 | 12339 | {"type": "Polygon", "coordinates": [[[-117.79882, 33.68189], [-117.7987, 33.68209], [-117.79851, 33.68228], [-117.79844, 33.68228], [-117.79798, 33.68197], [-117.79784, 33.68182], [-117.7983, 33.68154], [-117.79882, 33.68189]]]} | Restricted Access 2 | Springvale Park | 32390 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 0.993 | Springvale Park | ||
12336 | 12336 | 12335 | {"type": "Polygon", "coordinates": [[[-117.79819, 33.68454], [-117.79776, 33.68497], [-117.79759, 33.68481], [-117.79737, 33.68467], [-117.79719, 33.68459], [-117.7975, 33.68427], [-117.79758, 33.68423], [-117.79763, 33.68416], [-117.79819, 33.68454]]]} | Restricted Access 2 | Arbor Park | 32386 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.002 | Arbor Park | ||
9855 | 9855 | 9854 | {"type": "Polygon", "coordinates": [[[-117.79238, 33.66725], [-117.79237, 33.66731], [-117.79218, 33.66751], [-117.79216, 33.6676], [-117.79219, 33.66769], [-117.79215, 33.66773], [-117.79143, 33.66723], [-117.7918, 33.66686], [-117.792, 33.667], [-117.79215, 33.66702], [-117.7922, 33.66712], [-117.79238, 33.66725]]]} | Restricted Access 2 | Springbrook Park | 25745 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.033 | Springbrook Park | ||
2074 | 2074 | 2073 | {"type": "Polygon", "coordinates": [[[-117.80159, 33.68926], [-117.80114, 33.68972], [-117.80084, 33.68974], [-117.80076, 33.68915], [-117.80078, 33.68909], [-117.80112, 33.68894], [-117.80159, 33.68926]]]} | Restricted Access 2 | Blue Jay Park | 16177 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.076 | Blue Jay Park | ||
11342 | 11342 | 11341 | {"type": "Polygon", "coordinates": [[[-117.80304, 33.6655], [-117.80296, 33.66592], [-117.80301, 33.66599], [-117.80294, 33.66604], [-117.80285, 33.66622], [-117.80277, 33.66631], [-117.80242, 33.66649], [-117.80227, 33.66661], [-117.80216, 33.66673], [-117.80208, 33.66688], [-117.80202, 33.66707], [-117.80206, 33.6668], [-117.80218, 33.66645], [-117.80241, 33.66541], [-117.80304, 33.6655]]]} | Restricted Access 2 | Wintermist Park | 27654 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.725 | Wintermist Park | ||
12342 | 12342 | 12341 | {"type": "Polygon", "coordinates": [[[-117.79157, 33.68583], [-117.79135, 33.68606], [-117.79155, 33.68624], [-117.79146, 33.68659], [-117.79126, 33.68658], [-117.79104, 33.68668], [-117.79103, 33.68659], [-117.79098, 33.6865], [-117.7909, 33.68644], [-117.79053, 33.68618], [-117.79049, 33.68611], [-117.79049, 33.68605], [-117.79052, 33.68602], [-117.79104, 33.68549], [-117.79108, 33.68549], [-117.79157, 33.68583]]]} | Restricted Access 2 | Shorebird Park | 32393 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.926 | Shorebird Park | ||
11225 | 11225 | 11224 | {"type": "Polygon", "coordinates": [[[-117.78759, 33.68347], [-117.78758, 33.6835], [-117.78705, 33.68403], [-117.78624, 33.68348], [-117.78675, 33.68297], [-117.78688, 33.68301], [-117.78707, 33.68309], [-117.78757, 33.68342], [-117.78759, 33.68347]]]} | Restricted Access 2 | Wildwood Park | 27526 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.939 | Wildwood Park | ||
3469 | 3469 | 3468 | {"type": "Polygon", "coordinates": [[[-117.81073, 33.67563], [-117.81009, 33.67625], [-117.80942, 33.67578], [-117.8094, 33.67575], [-117.80941, 33.67571], [-117.81, 33.67513], [-117.81073, 33.67563]]]} | Restricted Access 2 | Daybreak Park | 17962 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.95 | Daybreak Park | ||
4240 | 4240 | 4239 | {"type": "Polygon", "coordinates": [[[-117.79209, 33.67836], [-117.79147, 33.67898], [-117.79106, 33.6787], [-117.79096, 33.6786], [-117.79068, 33.6782], [-117.79081, 33.67818], [-117.79087, 33.67825], [-117.79093, 33.67826], [-117.79103, 33.67825], [-117.79107, 33.67821], [-117.79118, 33.67803], [-117.79136, 33.67785], [-117.79209, 33.67836]]]} | Restricted Access 2 | Firwood Park | 18917 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.968 | Firwood Park | ||
9675 | 9675 | 9674 | {"type": "Polygon", "coordinates": [[[-117.80743, 33.67464], [-117.80703, 33.67504], [-117.80686, 33.67516], [-117.80683, 33.6752], [-117.80683, 33.67526], [-117.80617, 33.67479], [-117.80694, 33.67401], [-117.80706, 33.67411], [-117.80724, 33.67441], [-117.80733, 33.67453], [-117.80742, 33.6746], [-117.80743, 33.67464]]]} | Restricted Access 2 | Smokestone Park | 25574 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.973 | Smokestone Park | ||
9839 | 9839 | 9838 | {"type": "Polygon", "coordinates": [[[-117.81298, 33.67241], [-117.81313, 33.67272], [-117.81315, 33.67281], [-117.81317, 33.67293], [-117.81317, 33.67305], [-117.81313, 33.67319], [-117.81302, 33.67338], [-117.81295, 33.67343], [-117.81267, 33.67371], [-117.81262, 33.67374], [-117.81258, 33.67374], [-117.81254, 33.67373], [-117.81203, 33.67338], [-117.81298, 33.67241]]]} | Restricted Access 2 | Springacre Park | 25743 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.986 | Springacre Park | ||
8424 | 8424 | 8423 | {"type": "Polygon", "coordinates": [[[-117.78441, 33.67651], [-117.78378, 33.67714], [-117.78305, 33.67663], [-117.78367, 33.67601], [-117.78441, 33.67651]]]} | Restricted Access 2 | Peppergrass Park | 32359 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.987 | Peppergrass Park | ||
2033 | 2033 | 2032 | {"type": "Polygon", "coordinates": [[[-117.80378, 33.68325], [-117.80318, 33.68385], [-117.8024, 33.68332], [-117.80299, 33.68272], [-117.80378, 33.68325]]]} | Restricted Access 2 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.997 | Birdsong Park | ||
4170 | 4170 | 4169 | {"type": "Polygon", "coordinates": [[[-117.78342, 33.67945], [-117.78277, 33.68011], [-117.78207, 33.67962], [-117.78272, 33.67895], [-117.78282, 33.67903], [-117.78298, 33.67918], [-117.78308, 33.67921], [-117.78342, 33.67945]]]} | Restricted Access 2 | Fallbrook Park | 18834 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 1.999 | Fallbrook Park | ||
3027 | 3027 | 3026 | {"type": "Polygon", "coordinates": [[[-117.81184, 33.66673], [-117.81155, 33.66748], [-117.81149, 33.66751], [-117.81146, 33.66746], [-117.81132, 33.66739], [-117.81062, 33.66726], [-117.81077, 33.66651], [-117.81184, 33.66673]]]} | Restricted Access 2 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.0 | Clearbrook Park | ||
11399 | 11399 | 11398 | {"type": "Polygon", "coordinates": [[[-117.80523, 33.68667], [-117.8047, 33.68721], [-117.80468, 33.6872], [-117.8047, 33.68714], [-117.80468, 33.68707], [-117.80463, 33.68704], [-117.80447, 33.68703], [-117.80433, 33.68695], [-117.80385, 33.68661], [-117.80384, 33.68655], [-117.80393, 33.68641], [-117.80406, 33.68628], [-117.80409, 33.68622], [-117.80433, 33.68608], [-117.80523, 33.68667]]]} | Restricted Access 2 | Woodpine Park | 27731 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.006 | Woodpine Park | ||
1638 | 1638 | 1637 | {"type": "Polygon", "coordinates": [[[-117.78781, 33.67973], [-117.78686, 33.68064], [-117.78636, 33.68028], [-117.7873, 33.67937], [-117.78781, 33.67973]]]} | Restricted Access 2 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.01 | Ashwood Park | ||
8425 | 8425 | 8424 | {"type": "Polygon", "coordinates": [[[-117.80027, 33.66991], [-117.80018, 33.67024], [-117.80008, 33.67049], [-117.80006, 33.67053], [-117.80003, 33.67054], [-117.79893, 33.67026], [-117.79915, 33.66963], [-117.80027, 33.66991]]]} | Restricted Access 2 | Woodflower Park | 32361 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.012 | Woodflower 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]);