superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

31 rows where ACCESS_TYP = 2 and MNG_AGENCY = 240

This data as json, copyable, CSV (advanced)

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
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
6096 6096 6095 {"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 Lemongrass Park   21155 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15 http://www.wva.org/ Private 14 2.759 Lemongrass Park  
6867 6867 6866 {"type": "Polygon", "coordinates": [[[-117.81063, 33.67059], [-117.81046, 33.67171], [-117.80973, 33.67181], [-117.80991, 33.67052], [-117.81063, 33.67059]]]} Restricted Access 2 Meadow Park   22076 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15 http://www.wva.org/ Private 14 2.23 Meadow Park  
7454 7454 7453 {"type": "Polygon", "coordinates": [[[-117.7994, 33.67836], [-117.79936, 33.6784], [-117.79915, 33.67827], [-117.79911, 33.67831], [-117.79916, 33.67836], [-117.79902, 33.6785], [-117.79914, 33.6786], [-117.79896, 33.67878], [-117.79888, 33.67874], [-117.79881, 33.6788], [-117.79868, 33.67872], [-117.79853, 33.67887], [-117.79875, 33.67905], [-117.79867, 33.67914], [-117.79862, 33.67912], [-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.79817, 33.67979], [-117.79804, 33.67983], [-117.79791, 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.7974, 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.6825], [-117.79545, 33.68174], [-117.79539, 33.6818], [-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.79454, 33.68223], [-117.79451, 33.68225], [-117.79429, 33.6821], [-117.7942, 33.68218], [-117.7941, 33.68219], [-117.79393, 33.68208], [-117.7938, 33.6822], [-117.79369, 33.68221], [-117.7936, 33.68216], [-117.79344, 33.68233], [-117.7934, 33.68233], [-117.79323, 33.6825], [-117.79323, 33.68252], [-117.79328, 33.68255], [-117.7931, 33.68274], [-117.79311, 33.68277], [-117.79295, 33.68294], [-117.79295, 33.68298], [-117.79277, 33.6831], [-117.79269, 33.6832], [-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.79164, 33.68386], [-117.79145, 33.68407], [-117.79138, 33.68404], [-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.79091, 33.6831], [-117.79088, 33.68306], [-117.79103, 33.6829], [-117.79102, 33.68287], [-117.7912, 33.68269], [-117.79111, 33.6826], [-117.79128, 33.68242], [-117.79127, 33.68239], [-117.79142, 33.68223], [-117.79141, 33.6822], [-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.68193], [-117.7928, 33.68182], [-117.79295, 33.68159], [-117.793, 33.68155], [-117.79311, 33.68147], [-117.79349, 33.68126], [-117.79373, 33.681], [-117.79372, 33.68077], [-117.79338, 33.68054], [-117.7934, 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.79584, 33.6797], [-117.7956, 33.67952], [-117.79562, 33.67946], [-117.79561, 33.67939], [-117.79552, 33.67928], [-117.79621, 33.67974], [-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.67879], [-117.79755, 33.67874], [-117.79761, 33.67868], [-117.7976, 33.67865], [-117.79773, 33.67852], [-117.79769, 33.67848], [-117.79776, 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 North Lake Park   22829 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15 http://www.wva.org/ Private 14 42.39 North Lake 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  
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  
8874 8874 8873 {"type": "Polygon", "coordinates": [[[-117.81746, 33.6734], [-117.81707, 33.67379], [-117.81593, 33.67299], [-117.8157, 33.67287], [-117.81568, 33.67285], [-117.81568, 33.67278], [-117.81649, 33.67272], [-117.81746, 33.6734]]]} Restricted Access 2 Timber Run Park   26369 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15 http://www.wva.org/ Private 14 2.05 Timber Run 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  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);