units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 240 and MNG_AG_TYP = 15 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
DES_TP 2
MNG_AG_TYP 1
- Home Owners Association · 31 ✖
MNG_AGENCY 1
- Woodbridge Village Association · 31 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13959 | 13959 | 13958 | {"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 | 36667 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 0.596 | Woodspring Pool | 0 | Private Conservation 16 | 2 | |
13656 | 13656 | 13655 | {"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 | 36127 | Pebblewood Park | 32338 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 0.639 | Pebblewood Park | 0 | Private Recreation or Education 65 | 4 | |
14162 | 14162 | 14161 | {"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 | 43056 | Springvale Park | 32390 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 0.993 | Springvale Park | 0 | Private Recreation or Education 65 | 4 | |
14156 | 14156 | 14155 | {"type": "Polygon", "coordinates": [[[-117.79819, 33.68454], [-117.79776, 33.68497], [-117.79759, 33.68482], [-117.79737, 33.68467], [-117.79719, 33.68459], [-117.7975, 33.68426], [-117.79758, 33.68423], [-117.79763, 33.68416], [-117.79819, 33.68454]]]} | Restricted Access 2 | 43051 | Arbor Park | 32386 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.002 | Arbor Park | 0 | Private Recreation or Education 65 | 4 | |
8275 | 8275 | 8274 | {"type": "Polygon", "coordinates": [[[-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], [-117.79237, 33.66731], [-117.79218, 33.66751], [-117.79216, 33.6676], [-117.79219, 33.66769]]]} | Restricted Access 2 | 12665 | Springbrook Park | 25745 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.032 | Springbrook Park | 0 | Private Recreation or Education 65 | 4 | |
6878 | 6878 | 6877 | {"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 | 5540 | Blue Jay Park | 16177 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.077 | Blue Jay Park | 0 | Private Recreation or Education 65 | 4 | |
8312 | 8312 | 8311 | {"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.80207, 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 | 12760 | Wintermist Park | 27654 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.725 | Wintermist Park | 0 | Private Recreation or Education 65 | 4 | |
14161 | 14161 | 14160 | {"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.68651], [-117.7909, 33.68644], [-117.79053, 33.68618], [-117.79049, 33.68611], [-117.79049, 33.68605], [-117.79051, 33.68602], [-117.79104, 33.68549], [-117.79108, 33.68549], [-117.79157, 33.68583]]]} | Restricted Access 2 | 43055 | Shorebird Park | 32393 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.924 | Shorebird Park | 0 | Private Recreation or Education 65 | 4 | |
1692 | 1692 | 1691 | {"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 | 12755 | Wildwood Park | 27526 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.939 | Wildwood Park | 0 | Private Recreation or Education 65 | 4 | |
8122 | 8122 | 8121 | {"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 | 12293 | Daybreak Park | 17962 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.95 | Daybreak Park | 0 | Private Recreation or Education 65 | 4 | |
8130 | 8130 | 8129 | {"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 | 12308 | Firwood Park | 18917 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.968 | Firwood Park | 0 | Private Recreation or Education 65 | 4 | |
8272 | 8272 | 8271 | {"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 | 12661 | Smokestone Park | 25574 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.973 | Smokestone Park | 0 | Private Recreation or Education 65 | 4 | |
8274 | 8274 | 8273 | {"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 | 12664 | Springacre Park | 25743 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.987 | Springacre Park | 0 | Private Recreation or Education 65 | 4 | |
14147 | 14147 | 14146 | {"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 | 43040 | Peppergrass Park | 32359 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.988 | Peppergrass Park | 0 | Private Recreation or Education 65 | 4 | |
779 | 779 | 778 | {"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 | 5060 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.997 | Birdsong Park | 0 | Private Recreation or Education 65 | 4 | |
1604 | 1604 | 1603 | {"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 | 12272 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Clearbrook Park | 0 | Private Recreation or Education 65 | 4 | |
8128 | 8128 | 8127 | {"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 | 12306 | Fallbrook Park | 18834 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Fallbrook Park | 0 | Private Recreation or Education 65 | 4 | |
1796 | 1796 | 1795 | {"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 | 15483 | Woodpine Park | 27731 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.007 | Woodpine Park | 0 | Private Recreation or Education 65 | 4 | |
1592 | 1592 | 1591 | {"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 | 12155 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.011 | Ashwood Park | 0 | Private Recreation or Education 65 | 4 | |
13721 | 13721 | 13720 | {"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 | 36137 | Woodflower Park | 32361 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.012 | Woodflower Park | 0 | Private Recreation or Education 65 | 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]);