units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 240
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8310 | 8310 | 8309 | {"type": "Polygon", "coordinates": [[[-117.81322, 33.67765], [-117.81281, 33.67806], [-117.81272, 33.67808], [-117.81269, 33.67807], [-117.8117, 33.6774], [-117.8122, 33.67696], [-117.81322, 33.67765]]]} | Restricted Access 2 | 12758 | Windjammer Park | 27627 | 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.035 | Windjammer 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);