superunits_with_maps

Table actions

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

22 rows where MNG_AGENCY = 131 and MNG_AG_LEV = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Dana Point, City of · 22 ✖
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
2617 2617 2616 {"type": "MultiPolygon", "coordinates": [[[[-117.68, 33.4774], [-117.67968, 33.47877], [-117.67924, 33.47862], [-117.67947, 33.47751], [-117.67952, 33.47734], [-117.68, 33.4774]]], [[[-117.68103, 33.47492], [-117.68036, 33.47591], [-117.68023, 33.47625], [-117.68017, 33.47633], [-117.67999, 33.47724], [-117.67954, 33.47718], [-117.67983, 33.47572], [-117.67937, 33.47553], [-117.67953, 33.47496], [-117.67961, 33.47464], [-117.68103, 33.47492]]]]} Open Access 1 Creekside Park   17773 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 6.65 Creekside Park  
3364 3364 3363 {"type": "Polygon", "coordinates": [[[-117.69339, 33.46661], [-117.69327, 33.46682], [-117.69286, 33.4667], [-117.69222, 33.46655], [-117.69079, 33.46631], [-117.69087, 33.46607], [-117.69253, 33.46636], [-117.69294, 33.46646], [-117.69339, 33.46661]]]} Open Access 1 Crystal Cove Park   17844 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1.606 Crystal Cove Park  
3419 3419 3418 {"type": "Polygon", "coordinates": [[[-117.70402, 33.48479], [-117.70386, 33.48502], [-117.70378, 33.48506], [-117.70372, 33.48512], [-117.70364, 33.4853], [-117.70341, 33.48565], [-117.70336, 33.48567], [-117.70303, 33.48554], [-117.70273, 33.48536], [-117.70262, 33.48526], [-117.70238, 33.48501], [-117.70271, 33.4848], [-117.70287, 33.48448], [-117.70286, 33.48428], [-117.70303, 33.48435], [-117.70339, 33.48456], [-117.70402, 33.48479]]]} Open Access 1 Dana Crest Park   17909 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 2.928 Dana Crest Park  
3420 3420 3419 {"type": "Polygon", "coordinates": [[[-117.69747, 33.47613], [-117.69739, 33.47621], [-117.69661, 33.47623], [-117.69665, 33.47578], [-117.69677, 33.47563], [-117.69673, 33.47537], [-117.69664, 33.47519], [-117.69692, 33.47509], [-117.69713, 33.47505], [-117.69731, 33.47504], [-117.69737, 33.47509], [-117.6974, 33.47572], [-117.69747, 33.47613]]]} Open Access 1 Dana Point holding 1   17911 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 2.085 Dana Point holding 1  
3429 3429 3428 {"type": "Polygon", "coordinates": [[[-117.71104, 33.46017], [-117.71103, 33.46132], [-117.71091, 33.46132], [-117.71082, 33.46129], [-117.71053, 33.46117], [-117.71035, 33.46112], [-117.71006, 33.46109], [-117.70981, 33.46111], [-117.70924, 33.46126], [-117.70911, 33.46123], [-117.70902, 33.46126], [-117.70898, 33.46133], [-117.709, 33.46143], [-117.70887, 33.46176], [-117.70813, 33.46154], [-117.70793, 33.46151], [-117.70785, 33.46153], [-117.70771, 33.46161], [-117.70757, 33.46179], [-117.70768, 33.46192], [-117.70724, 33.46192], [-117.70717, 33.46174], [-117.70713, 33.46155], [-117.7071, 33.46152], [-117.70708, 33.46145], [-117.70709, 33.46123], [-117.70715, 33.46108], [-117.70718, 33.46086], [-117.70724, 33.46071], [-117.70752, 33.46051], [-117.70763, 33.46051], [-117.70792, 33.46064], [-117.70826, 33.46076], [-117.70852, 33.46079], [-117.70925, 33.46045], [-117.70975, 33.46033], [-117.71008, 33.46028], [-117.71032, 33.46031], [-117.71078, 33.46019], [-117.71104, 33.46017]]]} Open Access 1 Dana Point Park   17912 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 9.327 Dana Point Park  
3432 3432 3431 {"type": "Polygon", "coordinates": [[[-117.69382, 33.48532], [-117.69353, 33.48567], [-117.69361, 33.4864], [-117.69369, 33.48736], [-117.69286, 33.48735], [-117.69295, 33.48446], [-117.69315, 33.48458], [-117.69326, 33.48469], [-117.69343, 33.48503], [-117.69351, 33.48513], [-117.69359, 33.48521], [-117.69371, 33.48528], [-117.69382, 33.48532]]]} Open Access 1 Dana Woods Park   17915 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 4.754 Dana Woods Park  
3535 3535 3534 {"type": "Polygon", "coordinates": [[[-117.68421, 33.46825], [-117.68397, 33.46869], [-117.68382, 33.46877], [-117.6837, 33.46897], [-117.68367, 33.4691], [-117.68367, 33.46924], [-117.68372, 33.46931], [-117.68378, 33.46937], [-117.68384, 33.46939], [-117.68377, 33.46957], [-117.68374, 33.46963], [-117.68367, 33.46966], [-117.68349, 33.46961], [-117.68341, 33.46955], [-117.68339, 33.4695], [-117.68334, 33.46947], [-117.68327, 33.46922], [-117.6832, 33.46913], [-117.68299, 33.46891], [-117.68297, 33.46882], [-117.68302, 33.46865], [-117.6823, 33.46841], [-117.68245, 33.46807], [-117.68241, 33.46804], [-117.68258, 33.46752], [-117.68277, 33.4667], [-117.68405, 33.46714], [-117.68398, 33.46729], [-117.68372, 33.46723], [-117.68365, 33.46725], [-117.68357, 33.46736], [-117.68341, 33.46749], [-117.68333, 33.46761], [-117.68374, 33.46775], [-117.68368, 33.4679], [-117.68373, 33.46793], [-117.68367, 33.46808], [-117.68421, 33.46825]]]} Open Access 1 Del Obispo Park   18043 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 7.075 Del Obispo Park  
5058 5058 5057 {"type": "Polygon", "coordinates": [[[-117.69807, 33.46235], [-117.69807, 33.46339], [-117.69794, 33.46342], [-117.69795, 33.46533], [-117.69789, 33.46539], [-117.6979, 33.46445], [-117.69788, 33.4643], [-117.69782, 33.46425], [-117.69786, 33.46418], [-117.69785, 33.46412], [-117.69791, 33.46409], [-117.6979, 33.46398], [-117.69775, 33.46365], [-117.69764, 33.46368], [-117.69743, 33.46356], [-117.69742, 33.4635], [-117.69737, 33.46345], [-117.69742, 33.46336], [-117.69733, 33.46325], [-117.69717, 33.46316], [-117.69702, 33.46313], [-117.69679, 33.46322], [-117.69672, 33.46317], [-117.69662, 33.46317], [-117.69659, 33.46319], [-117.69656, 33.46324], [-117.69646, 33.46323], [-117.69625, 33.4633], [-117.69608, 33.46344], [-117.69602, 33.46343], [-117.69596, 33.46343], [-117.69589, 33.4635], [-117.6958, 33.46349], [-117.69567, 33.46318], [-117.69558, 33.46257], [-117.69807, 33.46235]]]} Open Access 1 Heritage Park   19847 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 5.924 Heritage Park  
5832 5832 5831 {"type": "Polygon", "coordinates": [[[-117.69929, 33.46711], [-117.69929, 33.46832], [-117.69903, 33.46831], [-117.69903, 33.46717], [-117.69929, 33.46711]]]} Open Access 1 La Plaza Park   20793 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.781 La Plaza Park  
5992 5992 5991 {"type": "Polygon", "coordinates": [[[-117.70075, 33.46947], [-117.70035, 33.46948], [-117.70034, 33.46925], [-117.70036, 33.4692], [-117.7004, 33.46919], [-117.70074, 33.4692], [-117.70075, 33.46947]]]} Open Access 1 Lantern Village Community Park   21017 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.285 Lantern Village Community Park  
6431 6431 6430 {"type": "Polygon", "coordinates": [[[-117.67782, 33.46207], [-117.67771, 33.46227], [-117.67737, 33.46213], [-117.67731, 33.46208], [-117.67725, 33.46196], [-117.67719, 33.46188], [-117.67715, 33.46174], [-117.67713, 33.4617], [-117.67707, 33.46167], [-117.67701, 33.46168], [-117.67691, 33.46179], [-117.67689, 33.46179], [-117.67697, 33.46153], [-117.67782, 33.46207]]]} Open Access 1 Louise Leyden Park   21549 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.521 Louise Leyden Park  
6952 6952 6951 {"type": "Polygon", "coordinates": [[[-117.6661, 33.45584], [-117.666, 33.45591], [-117.66581, 33.45611], [-117.66574, 33.45613], [-117.66504, 33.45562], [-117.66492, 33.45549], [-117.66473, 33.45521], [-117.66459, 33.45484], [-117.6645, 33.45471], [-117.6644, 33.45458], [-117.66401, 33.45421], [-117.6645, 33.45387], [-117.66441, 33.45367], [-117.66424, 33.45343], [-117.66542, 33.45415], [-117.6657, 33.45434], [-117.66557, 33.45451], [-117.6655, 33.45479], [-117.66555, 33.455], [-117.66577, 33.45522], [-117.6661, 33.45584]]]} Open Access 1 Pines Park   23690 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 5.809 Pines Park  
7863 7863 7862 {"type": "Polygon", "coordinates": [[[-117.67006, 33.45754], [-117.67005, 33.45792], [-117.66979, 33.45796], [-117.66978, 33.45783], [-117.66974, 33.45773], [-117.66967, 33.45761], [-117.66935, 33.45735], [-117.66951, 33.45716], [-117.67006, 33.45754]]]} Open Access 1 Palisades Gazebo Park   23328 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.658 Palisades Gazebo Park  
9143 9143 9142 {"type": "Polygon", "coordinates": [[[-117.70675, 33.46393], [-117.70659, 33.46394], [-117.70652, 33.46399], [-117.70619, 33.46387], [-117.70587, 33.46371], [-117.70634, 33.46368], [-117.70652, 33.46366], [-117.70675, 33.46368], [-117.70675, 33.46393]]]} Open Access 1 Samson Overview Gazebo   24820 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.448 Samson Overview Gazebo  
9430 9430 9429 {"type": "Polygon", "coordinates": [[[-117.70667, 33.47812], [-117.70659, 33.4798], [-117.70661, 33.48059], [-117.7065, 33.48059], [-117.70648, 33.48064], [-117.70606, 33.48082], [-117.7061, 33.48092], [-117.70599, 33.48106], [-117.70598, 33.48127], [-117.70516, 33.48177], [-117.70498, 33.48203], [-117.70499, 33.48205], [-117.70527, 33.48218], [-117.70526, 33.4822], [-117.70495, 33.48207], [-117.70448, 33.48277], [-117.70436, 33.48264], [-117.7042, 33.48253], [-117.70378, 33.48232], [-117.70377, 33.48229], [-117.70379, 33.4821], [-117.70378, 33.48197], [-117.70368, 33.48173], [-117.70382, 33.48156], [-117.70391, 33.48138], [-117.70399, 33.48129], [-117.70468, 33.48092], [-117.70495, 33.48079], [-117.70474, 33.48046], [-117.70532, 33.48034], [-117.70566, 33.4801], [-117.7056, 33.47962], [-117.70465, 33.47939], [-117.70402, 33.47921], [-117.70363, 33.47905], [-117.70294, 33.47912], [-117.70342, 33.47872], [-117.70333, 33.47797], [-117.70384, 33.47804], [-117.70408, 33.4781], [-117.70587, 33.47808], [-117.70605, 33.47811], [-117.70667, 33.47812]]]} Open Access 1 Sea Canyon Park   25231 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 21.353 Sea Canyon Park  
9434 9434 9433 {"type": "Polygon", "coordinates": [[[-117.72107, 33.48182], [-117.71992, 33.48188], [-117.71981, 33.48185], [-117.71967, 33.48178], [-117.7184, 33.48061], [-117.7183, 33.48054], [-117.71813, 33.48049], [-117.71728, 33.48048], [-117.7172, 33.4809], [-117.71683, 33.48091], [-117.71572, 33.48073], [-117.71567, 33.47938], [-117.7164, 33.47922], [-117.71675, 33.47889], [-117.71691, 33.47864], [-117.71672, 33.47833], [-117.7167, 33.47823], [-117.71671, 33.47795], [-117.71642, 33.47769], [-117.71618, 33.47762], [-117.71581, 33.4774], [-117.71645, 33.47698], [-117.71594, 33.47642], [-117.71656, 33.47609], [-117.71766, 33.47762], [-117.71836, 33.47867], [-117.719, 33.47961], [-117.71934, 33.48003], [-117.72033, 33.48114], [-117.72107, 33.48182]]]} Open Access 1 Sea Terrace Park   25236 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 27.341 Sea Terrace Park  
9435 9435 9434 {"type": "Polygon", "coordinates": [[[-117.68886, 33.46637], [-117.6888, 33.46647], [-117.68882, 33.46662], [-117.68869, 33.46661], [-117.68873, 33.46658], [-117.68874, 33.46653], [-117.68871, 33.46649], [-117.68865, 33.46646], [-117.68867, 33.46638], [-117.68849, 33.46613], [-117.68824, 33.46605], [-117.68831, 33.46585], [-117.68878, 33.46598], [-117.68886, 33.46637]]]} Open Access 1 Sea View Park   25237 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.503 Sea View Park  
9593 9593 9592 {"type": "Polygon", "coordinates": [[[-117.69767, 33.46954], [-117.69752, 33.46954], [-117.69752, 33.46919], [-117.69767, 33.46919], [-117.69767, 33.46954]]]} Open Access 1 Shipwreck Park   25414 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 0.136 Shipwreck Park  
10127 10127 10126 {"type": "Polygon", "coordinates": [[[-117.66184, 33.46377], [-117.66182, 33.46383], [-117.66178, 33.46386], [-117.66149, 33.46387], [-117.66112, 33.46385], [-117.66082, 33.46378], [-117.66056, 33.4637], [-117.66027, 33.46356], [-117.66001, 33.46338], [-117.65999, 33.46335], [-117.65999, 33.46331], [-117.66022, 33.46318], [-117.66036, 33.46312], [-117.66068, 33.46302], [-117.66079, 33.46302], [-117.66101, 33.46308], [-117.66132, 33.46306], [-117.66136, 33.46309], [-117.66141, 33.46315], [-117.66184, 33.46377]]]} Open Access 1 Sunset Park   26053 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 2.612 Sunset Park  
10173 10173 10172 {"type": "Polygon", "coordinates": [[[-117.68367, 33.46985], [-117.68351, 33.46991], [-117.68335, 33.46994], [-117.68231, 33.47077], [-117.68152, 33.47151], [-117.6814, 33.47167], [-117.68113, 33.47206], [-117.6809, 33.47254], [-117.6804, 33.47396], [-117.68031, 33.4743], [-117.68003, 33.47407], [-117.68027, 33.47329], [-117.68061, 33.47236], [-117.68083, 33.47192], [-117.68118, 33.47141], [-117.68141, 33.47112], [-117.68185, 33.4707], [-117.68267, 33.47009], [-117.68317, 33.46968], [-117.68367, 33.46985]]]} Open Access 1 Sycamore Creek Trail   26124 1079 Dana Point, City of 131 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 4.795 Sycamore Creek Trail  

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