units_with_maps

Table actions

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

143 rows where COUNTY = 3, DES_TP = 65 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Private Recreation or Education · 143 ✖

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
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
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
801 801 800 {"type": "Polygon", "coordinates": [[[-117.96358, 33.88243], [-117.96358, 33.8825], [-117.96344, 33.88286], [-117.96216, 33.88253], [-117.96201, 33.8825], [-117.96195, 33.88252], [-117.96179, 33.88286], [-117.96169, 33.88291], [-117.96154, 33.8829], [-117.96146, 33.88298], [-117.9612, 33.8838], [-117.96112, 33.88384], [-117.9608, 33.88378], [-117.96076, 33.88375], [-117.96074, 33.8837], [-117.96106, 33.88283], [-117.96104, 33.8828], [-117.96086, 33.88272], [-117.96083, 33.88261], [-117.96097, 33.88214], [-117.96093, 33.88209], [-117.96088, 33.88205], [-117.95971, 33.88173], [-117.95964, 33.88171], [-117.95962, 33.88168], [-117.95968, 33.88149], [-117.95974, 33.88142], [-117.95979, 33.8814], [-117.96346, 33.88234], [-117.96354, 33.88238], [-117.96358, 33.88243]]]} Restricted Access 2 5203 McDermont Park 22019 6062 Amerige Heights Community Association 263 Private 7 Home Owners Association 16 http://www.amerigeheights.org/ Private 14 6062 Amerige Heights Community Association 259 Private 7 Home Owners Association 15   Orange 3 7.049 McDermont Park 0 Private Recreation or Education 65 4
840 840 839 {"type": "Polygon", "coordinates": [[[-117.95755, 33.88747], [-117.95754, 33.88755], [-117.95748, 33.88761], [-117.95743, 33.88762], [-117.9565, 33.88761], [-117.95641, 33.88756], [-117.95633, 33.88746], [-117.95631, 33.88741], [-117.95629, 33.88728], [-117.9563, 33.88721], [-117.95632, 33.88719], [-117.9564, 33.88717], [-117.95751, 33.88743], [-117.95755, 33.88747]]]} Restricted Access 2 4941 Mackey Neighborhood Park 21637 6062 Amerige Heights Community Association 263 Private 7 Home Owners Association 16 http://www.amerigeheights.org/ Private 14 6062 Amerige Heights Community Association 259 Private 7 Home Owners Association 15   Orange 3 0.97 Mackey Neighborhood Park 0 Private Recreation or Education 65 4
1455 1455 1454 {"type": "Polygon", "coordinates": [[[-117.96503, 33.88478], [-117.96434, 33.88483], [-117.96427, 33.88423], [-117.96499, 33.88417], [-117.96503, 33.88478]]]} Restricted Access 2 9773 Reiswig Park 24286 6062 Amerige Heights Community Association 263 Private 7 Home Owners Association 16 http://www.amerigeheights.org/ Private 14 6062 Amerige Heights Community Association 259 Private 7 Home Owners Association 15   Orange 3 1.084 Reiswig 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
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
1607 1607 1606 {"type": "Polygon", "coordinates": [[[-117.79116, 33.71292], [-117.79129, 33.71293], [-117.79145, 33.71298], [-117.79158, 33.71304], [-117.79169, 33.71312], [-117.79176, 33.71321], [-117.79182, 33.71332], [-117.79186, 33.71344], [-117.79186, 33.71356], [-117.79184, 33.71366], [-117.79179, 33.71378], [-117.79173, 33.71387], [-117.79161, 33.71397], [-117.79149, 33.71404], [-117.79138, 33.71409], [-117.79123, 33.71411], [-117.79109, 33.71412], [-117.79096, 33.7141], [-117.79082, 33.71405], [-117.79071, 33.714], [-117.79061, 33.71391], [-117.79052, 33.71381], [-117.79046, 33.7137], [-117.79043, 33.71357], [-117.79043, 33.71347], [-117.79046, 33.71335], [-117.79052, 33.71324], [-117.79058, 33.71315], [-117.79068, 33.71306], [-117.79081, 33.71299], [-117.79092, 33.71295], [-117.79116, 33.71292]]]} Restricted Access 2 12278 Colorado Park 17543 6008 Harvard Square Maintenance Association 393 Private 7 Home Owners Association 16 http://www.progressivecm.com/harvardsquare/ Private 14 6008 Harvard Square Maintenance Association 387 Private 7 Home Owners Association 15   Orange 3 3.401 Colorado Park 0 Private Recreation or Education 65 4
1646 1646 1645 {"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 12487 Meadow Park 22076 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.231 Meadow Park 0 Private Recreation or Education 65 4
1665 1665 1664 {"type": "Polygon", "coordinates": [[[-117.78817, 33.666], [-117.78729, 33.66687], [-117.78636, 33.66624], [-117.78725, 33.66535], [-117.78817, 33.666]]]} Restricted Access 2 12583 Royal Oak Park 24713 6014 Oak Creek Village Maintenance Association 405 Private 7 Home Owners Association 16   Private 14 6014 Oak Creek Village Maintenance Association 399 Private 7 Home Owners Association 15   Orange 3 3.524 Royal Oak Park 0 Private Recreation or Education 65 4
1680 1680 1679 {"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 12685 Timber Run Park 26369 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.05 Timber Run Park 0 Private Recreation or Education 65 4
1690 1690 1689 {"type": "Polygon", "coordinates": [[[-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293], [-117.77074, 33.643], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.6436], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64305], [-117.76951, 33.64304], [-117.7695, 33.643]]]} Restricted Access 2 12733 Valley View Park 26809 6019 Quail Hill Community Association 408 Private 7 Home Owners Association 16 http://www.quailhillhoa.org/ Private 14 6019 Quail Hill Community Association 402 Private 7 Home Owners Association 15   Orange 3 2.461 Valley View 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
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
3339 3339 3338 {"type": "Polygon", "coordinates": [[[-117.60164, 33.62872], [-117.60116, 33.62884], [-117.60031, 33.6291], [-117.60029, 33.62905], [-117.60002, 33.62892], [-117.60004, 33.62855], [-117.60049, 33.62742], [-117.60127, 33.62756], [-117.60121, 33.62777], [-117.60132, 33.6278], [-117.60137, 33.62789], [-117.60123, 33.62795], [-117.60164, 33.62872]]]} Restricted Access 2 30283 Tijeras Creek Park 31711 6061 Rancho Santa Margarita Landscape and Recreation Corporation 622 Private 7 Home Owners Association 16 http://www.samlarc.org/ Private 14 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15   Orange 3 4.432 Tijeras Creek Park 0 Private Recreation or Education 65 4
3340 3340 3339 {"type": "Polygon", "coordinates": [[[-117.61896, 33.65906], [-117.61894, 33.6595], [-117.61887, 33.65976], [-117.61872, 33.66002], [-117.61856, 33.66021], [-117.61813, 33.66053], [-117.61788, 33.66066], [-117.61763, 33.66075], [-117.61746, 33.66081], [-117.6173, 33.66083], [-117.61687, 33.66083], [-117.61685, 33.66021], [-117.61663, 33.65975], [-117.61673, 33.65943], [-117.6167, 33.65921], [-117.6166, 33.65904], [-117.6166, 33.65897], [-117.61643, 33.65896], [-117.6163, 33.65897], [-117.61627, 33.65881], [-117.61631, 33.65879], [-117.6165, 33.65864], [-117.61666, 33.65855], [-117.61678, 33.6585], [-117.61689, 33.65848], [-117.61715, 33.65846], [-117.61722, 33.65837], [-117.61758, 33.65853], [-117.61801, 33.65868], [-117.61827, 33.65875], [-117.6187, 33.6588], [-117.61873, 33.65889], [-117.61879, 33.65897], [-117.61896, 33.65906]]]} Restricted Access 2 30288 Altistima Park 31699 6061 Rancho Santa Margarita Landscape and Recreation Corporation 622 Private 7 Home Owners Association 16 http://www.samlarc.org/ Private 14 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15   Orange 3 10.958 Altistima Park 0 Private Recreation or Education 65 4
3512 3512 3511 {"type": "Polygon", "coordinates": [[[-117.8, 33.63663], [-117.79999, 33.63665], [-117.80001, 33.63696], [-117.79993, 33.63714], [-117.79993, 33.63721], [-117.79994, 33.63725], [-117.79977, 33.63733], [-117.79914, 33.63718], [-117.79908, 33.63712], [-117.799, 33.63711], [-117.799, 33.63679], [-117.79894, 33.63605], [-117.79896, 33.63585], [-117.79913, 33.63589], [-117.79912, 33.63598], [-117.79915, 33.63606], [-117.79936, 33.6362], [-117.79941, 33.63622], [-117.79964, 33.63623], [-117.79976, 33.63628], [-117.79994, 33.63648], [-117.79998, 33.63654], [-117.8, 33.63663]]]} Restricted Access 2 36116 HOA Community Park 31986 6028 Turtle Rock Ridge Association 652 Private 7 Home Owners Association 16   Private 14 6028 Turtle Rock Ridge Association 641 Private 7 Home Owners Association 15   Orange 3 2.684 HOA Community Park 0 Private Recreation or Education 65 4
3513 3513 3512 {"type": "Polygon", "coordinates": [[[-117.81397, 33.68873], [-117.81343, 33.68929], [-117.81316, 33.68912], [-117.81251, 33.68866], [-117.81295, 33.68837], [-117.81303, 33.68829], [-117.81307, 33.68822], [-117.81318, 33.68818], [-117.81397, 33.68873]]]} Restricted Access 2 36118 Santa Clara Park 32396 6018 Paseo Westpark Maintenance Association 653 Private 7 Home Owners Association 16   Private 14 6018 Paseo Westpark Maintenance Association 642 Private 7 Home Owners Association 15   Orange 3 2.033 Santa Clara Park 0 Private Recreation or Education 65 4
3645 3645 3644 {"type": "Polygon", "coordinates": [[[-117.79483, 33.69375], [-117.79469, 33.69392], [-117.79427, 33.6937], [-117.79404, 33.69368], [-117.79394, 33.69373], [-117.79388, 33.69369], [-117.79382, 33.69366], [-117.7934, 33.69365], [-117.79317, 33.69361], [-117.79308, 33.69363], [-117.79302, 33.69354], [-117.79273, 33.69351], [-117.79275, 33.69331], [-117.79295, 33.69313], [-117.7933, 33.69336], [-117.79337, 33.6933], [-117.79342, 33.69335], [-117.79353, 33.69337], [-117.79356, 33.69347], [-117.79397, 33.69357], [-117.79436, 33.69362], [-117.79461, 33.69359], [-117.79483, 33.69375]]]} Restricted Access 2 43072 Deer Spring Park 32389 6006 Deerfield Community Association 668 Private 7 Home Owners Association 16 http://www.accellpmassoc.com/Deerfield/ Private 14 6006 Deerfield Community Association 656 Private 7 Home Owners Association 15   Orange 3 1.165 Deer Spring Park 0 Private Recreation or Education 65 4
3709 3709 3708 {"type": "Polygon", "coordinates": [[[-117.57401, 33.6383], [-117.57347, 33.63793], [-117.57352, 33.63773], [-117.57355, 33.63752], [-117.57353, 33.63731], [-117.57346, 33.637], [-117.57336, 33.63681], [-117.57324, 33.63663], [-117.57376, 33.63658], [-117.57401, 33.6383]]]} Restricted Access 2 30292 Sycamore Canyon Drive Park 31710 6061 Rancho Santa Margarita Landscape and Recreation Corporation 622 Private 7 Home Owners Association 16 http://www.samlarc.org/ Private 14 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15   Orange 3 1.561 Sycamore Canyon Drive Park 0 Private Recreation or Education 65 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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