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 rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Woodbridge Village Association · 11 ✖
ACCESS_TYP 1
- Restricted Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3836 | 3836 | 3835 | {"type": "Polygon", "coordinates": [[[-117.81503, 33.66922], [-117.8143, 33.66981], [-117.81368, 33.66911], [-117.81433, 33.66861], [-117.81503, 33.66922]]]} | Restricted Access 2 | Echo Run Park | 18421 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.05 | Echo Run 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 | ||
3321 | 3321 | 3320 | {"type": "Polygon", "coordinates": [[[-117.78826, 33.67677], [-117.78752, 33.67755], [-117.78658, 33.67687], [-117.78681, 33.67669], [-117.78706, 33.67673], [-117.78726, 33.67673], [-117.78759, 33.67667], [-117.78789, 33.67665], [-117.78817, 33.67669], [-117.78825, 33.67673], [-117.78826, 33.67677]]]} | Restricted Access 2 | Crestbrook Park | 17805 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.068 | Crestbrook 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 | ||
2241 | 2241 | 2240 | {"type": "Polygon", "coordinates": [[[-117.7966, 33.66983], [-117.79631, 33.67068], [-117.79544, 33.67047], [-117.79574, 33.66964], [-117.79578, 33.66962], [-117.7966, 33.66983]]]} | Restricted Access 2 | Briarglen Park | 16371 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.016 | Briarglen 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 | ||
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 | ||
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 | ||
1587 | 1587 | 1586 | {"type": "Polygon", "coordinates": [[[-117.79989, 33.68697], [-117.79927, 33.6872], [-117.79887, 33.68726], [-117.79854, 33.68729], [-117.79849, 33.68702], [-117.79851, 33.68686], [-117.79845, 33.68645], [-117.79837, 33.68625], [-117.79871, 33.68622], [-117.79873, 33.68615], [-117.79871, 33.68595], [-117.79882, 33.68594], [-117.79893, 33.68597], [-117.79882, 33.68623], [-117.79989, 33.68697]]]} | Restricted Access 2 | Arrowhead Park | 15607 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.521 | Arrowhead Park | ||
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 | ||
228 | 228 | 227 | {"type": "MultiPolygon", "coordinates": [[[[-117.79757, 33.68517], [-117.79737, 33.68538], [-117.7968, 33.68499], [-117.797, 33.68478], [-117.79757, 33.68517]]], [[[-117.79923, 33.69094], [-117.79815, 33.69104], [-117.79804, 33.69013], [-117.79871, 33.69009], [-117.79915, 33.69018], [-117.79923, 33.69094]]]]} | Restricted Access 2 | HOA Community Park | 31874 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.944 | HOA Community 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]);