superunits_with_maps

Table actions

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

17 rows where MNG_AGENCY = 611

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Rancho Santa Margarita Landscape and Recreation Corporation · 17 ✖

ACCESS_TYP 1

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
13103 13103 13102 {"type": "Polygon", "coordinates": [[[-117.59448, 33.64807], [-117.59356, 33.64867], [-117.59295, 33.64803], [-117.59281, 33.64785], [-117.59262, 33.64744], [-117.59259, 33.64733], [-117.5926, 33.6472], [-117.59254, 33.64711], [-117.59244, 33.64701], [-117.59231, 33.64683], [-117.59263, 33.64662], [-117.59273, 33.64661], [-117.59289, 33.64651], [-117.59295, 33.6466], [-117.59307, 33.64694], [-117.59381, 33.64679], [-117.59389, 33.64704], [-117.59401, 33.64733], [-117.59423, 33.64767], [-117.59448, 33.64798], [-117.59448, 33.64807]]]} Restricted Access 2 Monte Vista Park   31707 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 6.02 Monte Vista Park  
14196 14196 14195 {"type": "MultiPolygon", "coordinates": [[[[-117.56834, 33.65338], [-117.56831, 33.65345], [-117.56817, 33.65353], [-117.56768, 33.65384], [-117.56738, 33.65406], [-117.56728, 33.65414], [-117.56682, 33.65472], [-117.56663, 33.6549], [-117.56639, 33.65508], [-117.56617, 33.65519], [-117.56594, 33.65527], [-117.56562, 33.6553], [-117.56637, 33.65377], [-117.56695, 33.65295], [-117.56755, 33.65213], [-117.56775, 33.65229], [-117.56794, 33.65253], [-117.56804, 33.65272], [-117.56834, 33.65338]]], [[[-117.59395, 33.64177], [-117.59353, 33.64184], [-117.5933, 33.64212], [-117.59332, 33.64226], [-117.5917, 33.6425], [-117.59138, 33.64242], [-117.59072, 33.64304], [-117.59072, 33.64277], [-117.59123, 33.64229], [-117.59111, 33.64158], [-117.59158, 33.64113], [-117.59308, 33.64092], [-117.59309, 33.64101], [-117.59313, 33.64108], [-117.59311, 33.64112], [-117.59339, 33.64129], [-117.59383, 33.64123], [-117.59395, 33.64177]]]]} Restricted Access 2 Central Park   31698 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 16.485 Central Park  
14214 14214 14213 {"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 Altistima Park   31699 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 10.96 Altistima Park  
14215 14215 14214 {"type": "Polygon", "coordinates": [[[-117.6149, 33.62502], [-117.61475, 33.62515], [-117.61437, 33.62539], [-117.61365, 33.62567], [-117.61349, 33.62596], [-117.61261, 33.62537], [-117.61271, 33.62521], [-117.61294, 33.62465], [-117.61307, 33.62394], [-117.61309, 33.62356], [-117.61317, 33.6235], [-117.61351, 33.6235], [-117.61393, 33.62344], [-117.6149, 33.62502]]]} Restricted Access 2 Arroyo Vista Park   31700 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 8.484 Arroyo Vista Park  
14216 14216 14215 {"type": "Polygon", "coordinates": [[[-117.61738, 33.6086], [-117.6171, 33.60943], [-117.61703, 33.60972], [-117.6166, 33.61002], [-117.61646, 33.61014], [-117.61636, 33.61027], [-117.61619, 33.61057], [-117.61601, 33.6108], [-117.61571, 33.61109], [-117.61551, 33.61123], [-117.61516, 33.61158], [-117.61508, 33.6117], [-117.61502, 33.61175], [-117.61494, 33.61174], [-117.61488, 33.61166], [-117.61486, 33.61157], [-117.61492, 33.61126], [-117.61479, 33.61102], [-117.61483, 33.6109], [-117.61483, 33.61084], [-117.61473, 33.61064], [-117.61462, 33.61052], [-117.61466, 33.61046], [-117.61474, 33.61], [-117.61492, 33.61003], [-117.61502, 33.61], [-117.61515, 33.60987], [-117.6153, 33.60971], [-117.61543, 33.60951], [-117.61546, 33.60936], [-117.61543, 33.60918], [-117.61543, 33.60909], [-117.61549, 33.60905], [-117.6157, 33.60916], [-117.61596, 33.60923], [-117.61608, 33.60923], [-117.6162, 33.60917], [-117.61636, 33.60902], [-117.61667, 33.60882], [-117.61685, 33.6088], [-117.61698, 33.60876], [-117.61713, 33.60866], [-117.61721, 33.60856], [-117.61738, 33.6086]]]} Restricted Access 2 Canada Vista Park   31701 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 9.228 Canada Vista Park  
14217 14217 14216 {"type": "Polygon", "coordinates": [[[-117.58827, 33.64485], [-117.58825, 33.64492], [-117.58764, 33.6453], [-117.58743, 33.64541], [-117.5874, 33.64546], [-117.58739, 33.64554], [-117.58742, 33.64563], [-117.58736, 33.64567], [-117.58731, 33.64558], [-117.58728, 33.64541], [-117.58733, 33.64503], [-117.58713, 33.64495], [-117.58695, 33.64442], [-117.58746, 33.64426], [-117.58748, 33.64432], [-117.58742, 33.64441], [-117.58749, 33.64465], [-117.58757, 33.64469], [-117.58764, 33.64468], [-117.58767, 33.64479], [-117.58817, 33.6447], [-117.58827, 33.64485]]]} Restricted Access 2 Cielo Vista Park   31702 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 1.807 Cielo Vista Park  
14218 14218 14217 {"type": "Polygon", "coordinates": [[[-117.5736, 33.65402], [-117.57343, 33.65417], [-117.5736, 33.65432], [-117.57357, 33.65435], [-117.57336, 33.65429], [-117.57315, 33.65447], [-117.57355, 33.65506], [-117.57341, 33.65512], [-117.57322, 33.65516], [-117.57297, 33.65519], [-117.57268, 33.65517], [-117.57253, 33.65514], [-117.57245, 33.6551], [-117.57244, 33.65506], [-117.57271, 33.6545], [-117.57276, 33.65426], [-117.57276, 33.65406], [-117.5728, 33.65404], [-117.5733, 33.65397], [-117.5736, 33.6539], [-117.5736, 33.65402]]]} Restricted Access 2 Country Hollow Lane Park   31703 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 2.259 Country Hollow Lane Park  
14219 14219 14218 {"type": "Polygon", "coordinates": [[[-117.57184, 33.65254], [-117.57178, 33.65266], [-117.5717, 33.65293], [-117.57159, 33.65371], [-117.57151, 33.65374], [-117.57123, 33.6537], [-117.57087, 33.6536], [-117.56993, 33.65329], [-117.5699, 33.65165], [-117.57005, 33.65139], [-117.57051, 33.65143], [-117.57051, 33.65186], [-117.57112, 33.65187], [-117.57158, 33.65227], [-117.5717, 33.65245], [-117.57184, 33.65254]]]} Restricted Access 2 Ike Arnold Park   31704 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 7.919 Ike Arnold Park  
14220 14220 14219 {"type": "Polygon", "coordinates": [[[-117.58699, 33.65131], [-117.58579, 33.65233], [-117.58528, 33.65279], [-117.58509, 33.65331], [-117.58538, 33.65387], [-117.58551, 33.65408], [-117.58575, 33.65428], [-117.58525, 33.65458], [-117.58486, 33.6548], [-117.58434, 33.65504], [-117.58375, 33.65426], [-117.58358, 33.65366], [-117.58381, 33.65303], [-117.58382, 33.65279], [-117.58375, 33.65253], [-117.58364, 33.65246], [-117.58365, 33.65238], [-117.58376, 33.65231], [-117.58387, 33.65199], [-117.58392, 33.65176], [-117.58388, 33.65147], [-117.58379, 33.65111], [-117.58369, 33.65095], [-117.58307, 33.65039], [-117.58331, 33.65015], [-117.5833, 33.65009], [-117.58318, 33.65001], [-117.58317, 33.64988], [-117.58311, 33.64983], [-117.5831, 33.64969], [-117.58317, 33.64961], [-117.58318, 33.64956], [-117.58329, 33.64944], [-117.58295, 33.64919], [-117.58296, 33.64906], [-117.58304, 33.64902], [-117.58374, 33.64904], [-117.58405, 33.64903], [-117.58456, 33.64899], [-117.58456, 33.64902], [-117.58434, 33.64924], [-117.5844, 33.65004], [-117.58525, 33.65084], [-117.58637, 33.65039], [-117.58677, 33.65103], [-117.58699, 33.65131]]]} Restricted Access 2 Lago Santa Margarita Beach Club   31705 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 27.596 Lago Santa Margarita Beach Club  
14221 14221 14220 {"type": "Polygon", "coordinates": [[[-117.6146, 33.61524], [-117.61435, 33.61562], [-117.6143, 33.61567], [-117.61429, 33.61572], [-117.61404, 33.61604], [-117.61313, 33.61556], [-117.61374, 33.61518], [-117.61402, 33.61493], [-117.6146, 33.61524]]]} Restricted Access 2 Mesa Linda Park   31706 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 2.036 Mesa Linda Park  
14224 14224 14223 {"type": "Polygon", "coordinates": [[[-117.62105, 33.64782], [-117.62093, 33.64797], [-117.62089, 33.64829], [-117.621, 33.64844], [-117.62085, 33.64863], [-117.6208, 33.64888], [-117.62072, 33.64897], [-117.62073, 33.64903], [-117.62007, 33.64904], [-117.61982, 33.64919], [-117.61975, 33.64932], [-117.61974, 33.64947], [-117.6198, 33.64963], [-117.61979, 33.64967], [-117.61926, 33.64984], [-117.6186, 33.65011], [-117.61846, 33.6501], [-117.61847, 33.64988], [-117.61856, 33.64955], [-117.61859, 33.64919], [-117.6184, 33.64832], [-117.61834, 33.64789], [-117.61841, 33.64783], [-117.61868, 33.64784], [-117.61918, 33.6478], [-117.61974, 33.64774], [-117.6204, 33.64757], [-117.62096, 33.64735], [-117.62103, 33.64744], [-117.62105, 33.64782]]]} Restricted Access 2 Solana Park   31708 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 11.273 Solana Park  
14225 14225 14224 {"type": "Polygon", "coordinates": [[[-117.57006, 33.63818], [-117.56954, 33.63885], [-117.56851, 33.63819], [-117.56793, 33.63796], [-117.56772, 33.63797], [-117.56754, 33.638], [-117.56734, 33.63809], [-117.56714, 33.63821], [-117.56675, 33.6382], [-117.56672, 33.63751], [-117.56682, 33.63751], [-117.56741, 33.63745], [-117.56825, 33.63745], [-117.56912, 33.63771], [-117.57006, 33.63818]]]} Restricted Access 2 Swim & Racquet Complex   31709 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 5.564 Swim & Racquet Complex  
14226 14226 14225 {"type": "Polygon", "coordinates": [[[-117.57401, 33.6383], [-117.57347, 33.63793], [-117.57352, 33.63773], [-117.57354, 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 Sycamore Canyon Drive Park   31710 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 1.561 Sycamore Canyon Drive Park  
14227 14227 14226 {"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.60122, 33.62776], [-117.60132, 33.6278], [-117.60137, 33.62789], [-117.60124, 33.62796], [-117.60164, 33.62872]]]} Restricted Access 2 Tijeras Creek Park   31711 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 4.435 Tijeras Creek Park  
14228 14228 14227 {"type": "Polygon", "coordinates": [[[-117.58219, 33.65585], [-117.58216, 33.65592], [-117.58162, 33.65612], [-117.58116, 33.65619], [-117.58071, 33.65618], [-117.58049, 33.65614], [-117.58023, 33.65606], [-117.57994, 33.65594], [-117.57971, 33.65579], [-117.5795, 33.65562], [-117.57929, 33.65535], [-117.5792, 33.65521], [-117.57913, 33.65507], [-117.57908, 33.65486], [-117.57907, 33.65458], [-117.57909, 33.65425], [-117.58132, 33.65415], [-117.58219, 33.65585]]]} Restricted Access 2 Trabuco Mesa Park   31712 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 12.062 Trabuco Mesa Park  
14229 14229 14228 {"type": "Polygon", "coordinates": [[[-117.5971, 33.63467], [-117.59708, 33.63469], [-117.59704, 33.63464], [-117.59698, 33.63462], [-117.59688, 33.63463], [-117.59683, 33.6347], [-117.59679, 33.63483], [-117.59669, 33.63486], [-117.59628, 33.63476], [-117.59581, 33.63472], [-117.59577, 33.63471], [-117.59574, 33.63468], [-117.59571, 33.63444], [-117.59569, 33.63441], [-117.59561, 33.63437], [-117.59564, 33.63431], [-117.59571, 33.63431], [-117.59579, 33.63427], [-117.5958, 33.63425], [-117.59583, 33.63408], [-117.59591, 33.63399], [-117.59601, 33.63391], [-117.59614, 33.63384], [-117.59682, 33.63362], [-117.59663, 33.63306], [-117.59655, 33.6329], [-117.59639, 33.63268], [-117.59603, 33.63231], [-117.59616, 33.63221], [-117.59659, 33.63264], [-117.59675, 33.63288], [-117.59679, 33.63298], [-117.59718, 33.63409], [-117.59717, 33.63434], [-117.5971, 33.63467]]]} Restricted Access 2 Vista Verde Park   31713 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 4.149 Vista Verde Park  
14230 14230 14229 {"type": "Polygon", "coordinates": [[[-117.57444, 33.64923], [-117.5744, 33.64929], [-117.57435, 33.64931], [-117.57435, 33.64936], [-117.57416, 33.64937], [-117.57379, 33.64929], [-117.5735, 33.64935], [-117.57367, 33.64963], [-117.57381, 33.64979], [-117.57379, 33.64982], [-117.57383, 33.65015], [-117.57356, 33.65015], [-117.57353, 33.6499], [-117.57342, 33.64976], [-117.57325, 33.64939], [-117.573, 33.6491], [-117.57296, 33.64904], [-117.57295, 33.64897], [-117.57295, 33.6489], [-117.57311, 33.64844], [-117.57314, 33.64821], [-117.57315, 33.64777], [-117.57312, 33.6473], [-117.57329, 33.64725], [-117.57335, 33.64753], [-117.57338, 33.64755], [-117.57342, 33.64771], [-117.57383, 33.64748], [-117.5741, 33.64778], [-117.574, 33.64784], [-117.574, 33.6479], [-117.57396, 33.64794], [-117.57384, 33.64799], [-117.5738, 33.64804], [-117.5738, 33.6481], [-117.57385, 33.64819], [-117.57398, 33.64812], [-117.57435, 33.64858], [-117.57438, 33.64859], [-117.57441, 33.64872], [-117.57443, 33.64874], [-117.57444, 33.64887], [-117.57444, 33.64923]]]} Restricted Access 2 Walden Park   31714 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15 http://www.samlarc.org/ Private 14 5.766 Walden Park  

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