units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where DES_TP = 65 and MNG_AGENCY = 240 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
MNG_AG_TYP 1
MNG_AGENCY 1
- Woodbridge Village Association · 30 ✖
DES_TP 1
- Private Recreation or Education · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13718 | 13718 | 13717 | {"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 | 36125 | HOA Community Park | 31874 | 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.944 | HOA Community 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 | |
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 | |
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 | |
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 | |
8121 | 8121 | 8120 | {"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 | 12288 | Crestbrook Park | 17805 | 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.069 | Crestbrook 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 | |
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 | |
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 | |
705 | 705 | 704 | {"type": "Polygon", "coordinates": [[[-117.79528, 33.68552], [-117.79478, 33.68601], [-117.79345, 33.68511], [-117.79387, 33.68468], [-117.79439, 33.68492], [-117.79528, 33.68552]]]} | Restricted Access 2 | 3955 | Lemongrass Park | 21155 | 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.759 | Lemongrass Park | 0 | Private Recreation or Education 65 | 4 | |
8088 | 8088 | 8087 | {"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 | 12162 | Briarglen Park | 16371 | 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.017 | Briarglen Park | 0 | Private Recreation or Education 65 | 4 | |
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 | |
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 | |
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 | |
8222 | 8222 | 8221 | {"type": "Polygon", "coordinates": [[[-117.7994, 33.67836], [-117.79936, 33.6784], [-117.79916, 33.67826], [-117.79911, 33.67831], [-117.79916, 33.67836], [-117.79902, 33.67851], [-117.79914, 33.6786], [-117.79896, 33.67878], [-117.79888, 33.67873], [-117.79881, 33.6788], [-117.79868, 33.67871], [-117.79852, 33.67887], [-117.79875, 33.67905], [-117.79867, 33.67914], [-117.79862, 33.67911], [-117.79856, 33.67919], [-117.7987, 33.6793], [-117.79868, 33.67944], [-117.79886, 33.67956], [-117.79873, 33.67966], [-117.79857, 33.67972], [-117.79816, 33.67979], [-117.79804, 33.67983], [-117.7979, 33.6799], [-117.7978, 33.67999], [-117.79776, 33.68006], [-117.7977, 33.68032], [-117.79748, 33.68048], [-117.79742, 33.68063], [-117.79741, 33.68072], [-117.79743, 33.681], [-117.79741, 33.68108], [-117.79733, 33.68121], [-117.79731, 33.6813], [-117.79736, 33.68148], [-117.79737, 33.68158], [-117.79746, 33.68164], [-117.79737, 33.68173], [-117.7972, 33.68202], [-117.79666, 33.68258], [-117.79659, 33.68258], [-117.79655, 33.68256], [-117.79658, 33.68251], [-117.79546, 33.68174], [-117.79539, 33.68181], [-117.79541, 33.68183], [-117.79533, 33.68196], [-117.79522, 33.68209], [-117.79502, 33.68225], [-117.79486, 33.68232], [-117.79471, 33.68232], [-117.7946, 33.68228], [-117.79453, 33.68223], [-117.79451, 33.68225], [-117.79429, 33.6821], [-117.7942, 33.68218], [-117.7941, 33.68219], [-117.79393, 33.68207], [-117.7938, 33.6822], [-117.79369, 33.68221], [-117.7936, 33.68216], [-117.79344, 33.68233], [-117.79341, 33.68232], [-117.79323, 33.6825], [-117.79323, 33.68252], [-117.79328, 33.68255], [-117.79309, 33.68275], [-117.79311, 33.68277], [-117.79295, 33.68294], [-117.79295, 33.68298], [-117.79277, 33.6831], [-117.79269, 33.68321], [-117.7929, 33.68337], [-117.79283, 33.68337], [-117.79276, 33.6834], [-117.79271, 33.68344], [-117.79269, 33.68351], [-117.79258, 33.68351], [-117.79237, 33.68372], [-117.79223, 33.68364], [-117.79203, 33.68383], [-117.79203, 33.68376], [-117.79199, 33.68372], [-117.79193, 33.6837], [-117.79185, 33.68371], [-117.79169, 33.68387], [-117.79165, 33.68386], [-117.79145, 33.68407], [-117.79138, 33.68403], [-117.79116, 33.68429], [-117.79044, 33.68381], [-117.79045, 33.68371], [-117.79046, 33.68369], [-117.79062, 33.68355], [-117.79082, 33.68328], [-117.79092, 33.68309], [-117.79088, 33.68306], [-117.79104, 33.68289], [-117.79102, 33.68287], [-117.79121, 33.68268], [-117.79111, 33.6826], [-117.79129, 33.68241], [-117.79127, 33.68239], [-117.79143, 33.68223], [-117.79141, 33.6822], [-117.79147, 33.68215], [-117.7915, 33.68211], [-117.79184, 33.68202], [-117.79197, 33.68202], [-117.79216, 33.68207], [-117.79234, 33.68207], [-117.7925, 33.68204], [-117.79264, 33.68197], [-117.7927, 33.68194], [-117.7928, 33.68182], [-117.79295, 33.68159], [-117.793, 33.68155], [-117.79311, 33.68147], [-117.79349, 33.68126], [-117.79374, 33.681], [-117.79373, 33.68077], [-117.79338, 33.68054], [-117.79341, 33.68049], [-117.79327, 33.6804], [-117.7934, 33.68042], [-117.7935, 33.68039], [-117.79378, 33.68012], [-117.79404, 33.68029], [-117.79445, 33.6799], [-117.79501, 33.68028], [-117.79533, 33.68024], [-117.79585, 33.6797], [-117.7956, 33.67952], [-117.79562, 33.67946], [-117.79561, 33.67939], [-117.79552, 33.67928], [-117.79621, 33.67975], [-117.79638, 33.67943], [-117.79645, 33.67935], [-117.79662, 33.67923], [-117.79675, 33.67916], [-117.79683, 33.67921], [-117.79697, 33.67908], [-117.79714, 33.67919], [-117.79723, 33.67911], [-117.79729, 33.67913], [-117.79738, 33.67904], [-117.79745, 33.67907], [-117.79754, 33.67897], [-117.79746, 33.67891], [-117.79759, 33.67878], [-117.79755, 33.67874], [-117.79762, 33.67867], [-117.7976, 33.67865], [-117.79773, 33.67852], [-117.79769, 33.67848], [-117.79777, 33.6784], [-117.7977, 33.67835], [-117.79769, 33.67828], [-117.79764, 33.67819], [-117.79746, 33.67802], [-117.79741, 33.67794], [-117.79737, 33.67782], [-117.79737, 33.67772], [-117.79745, 33.67763], [-117.79755, 33.67759], [-117.79787, 33.67728], [-117.79834, 33.67754], [-117.79874, 33.67781], [-117.79906, 33.67805], [-117.7994, 33.67836]]]} | Restricted Access 2 | 12526 | North Lake Park | 22829 | 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 | 42.339 | North Lake Park | 0 | Private Recreation or Education 65 | 4 | |
10368 | 10368 | 10367 | {"type": "Polygon", "coordinates": [[[-117.79989, 33.68697], [-117.79927, 33.6872], [-117.79887, 33.68726], [-117.79854, 33.68729], [-117.79848, 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.79881, 33.68622], [-117.79989, 33.68697]]]} | Restricted Access 2 | 18302 | Arrowhead Park | 15607 | 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.518 | Arrowhead 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 | |
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 | |
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 |
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]);