units_with_maps

Table actions

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

18 rows where DES_TP = 2, GAP_STS = 4 and MNG_AGENCY = 131

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Dana Point, City of · 18 ✖

DES_TP 1

  • Local Park · 18 ✖

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
330 330 329 {"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 887 Palisades Gazebo Park 23328 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.658 Palisades Gazebo Park 0 Local Park 2 4
901 901 900 {"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 5800 Sunset Park 26053 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 2.612 Sunset Park 0 Local Park 2 4
1570 1570 1569 {"type": "Polygon", "coordinates": [[[-117.70667, 33.47812], [-117.70659, 33.4798], [-117.70661, 33.48059], [-117.7065, 33.48059], [-117.70648, 33.48064], [-117.70605, 33.48082], [-117.7061, 33.48092], [-117.70599, 33.48106], [-117.70598, 33.48127], [-117.70515, 33.48177], [-117.70498, 33.48203], [-117.70498, 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.70496, 33.48078], [-117.70474, 33.48046], [-117.70532, 33.48034], [-117.70567, 33.4801], [-117.7056, 33.47961], [-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.70604, 33.47811], [-117.70667, 33.47812]]]} Open Access 1 12042 Sea Canyon Park 25231 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 21.33 Sea Canyon Park 0 Local Park 2 4
2704 2704 2703 {"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 18351 Dana Crest Park 17909 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 2.927 Dana Crest Park 0 Local Park 2 4
3705 3705 3704 {"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 30259 Crystal Cove Park 17844 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 1.606 Crystal Cove Park 0 Local Park 2 4
7743 7743 7742 {"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.66451, 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 8509 Pines Park 23690 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 5.806 Pines Park 0 Local Park 2 4
8213 8213 8212 {"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 12475 Louise Leyden Park 21549 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.521 Louise Leyden Park 0 Local Park 2 4
8954 8954 8953 {"type": "Polygon", "coordinates": [[[-117.69074, 33.4777], [-117.68943, 33.47835], [-117.68941, 33.47669], [-117.69008, 33.47658], [-117.69013, 33.47658], [-117.69016, 33.47665], [-117.69026, 33.47692], [-117.69036, 33.47712], [-117.69074, 33.4777]]]} Open Access 1 14752 Thunderbird Park 26337 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 3.805 Thunderbird Park 0 Local Park 2 4
11965 11965 11964 {"type": "Polygon", "coordinates": [[[-117.68421, 33.46825], [-117.68397, 33.46869], [-117.68382, 33.46877], [-117.6837, 33.46897], [-117.68367, 33.46911], [-117.68367, 33.46923], [-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.6834, 33.4695], [-117.68334, 33.46947], [-117.68327, 33.46922], [-117.6832, 33.46913], [-117.68299, 33.46891], [-117.68297, 33.46882], [-117.68303, 33.46865], [-117.6823, 33.46841], [-117.68245, 33.46806], [-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.68364, 33.46725], [-117.68357, 33.46736], [-117.68341, 33.46749], [-117.68333, 33.46762], [-117.68374, 33.46775], [-117.68368, 33.46791], [-117.68373, 33.46793], [-117.68366, 33.46808], [-117.68421, 33.46825]]]} Open Access 1 24585 Del Obispo Park 18043 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 7.065 Del Obispo Park 0 Local Park 2 4
11966 11966 11965 {"type": "Polygon", "coordinates": [[[-117.69807, 33.46235], [-117.69807, 33.46339], [-117.69794, 33.46341], [-117.69795, 33.46533], [-117.69789, 33.46539], [-117.6979, 33.46445], [-117.69788, 33.46429], [-117.69782, 33.46425], [-117.69786, 33.46418], [-117.69785, 33.46412], [-117.69791, 33.4641], [-117.6979, 33.46398], [-117.69774, 33.46365], [-117.69764, 33.46368], [-117.69743, 33.46356], [-117.69742, 33.4635], [-117.69737, 33.46345], [-117.69742, 33.46337], [-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.46318], [-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 24586 Heritage Park 19847 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 5.919 Heritage Park 0 Local Park 2 4
12727 12727 12726 {"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.6935, 33.48513], [-117.69358, 33.4852], [-117.69371, 33.48528], [-117.69382, 33.48532]]]} Open Access 1 30266 Dana Woods Park 17915 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 4.753 Dana Woods Park 0 Local Park 2 4
12814 12814 12813 {"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.47571], [-117.67937, 33.47553], [-117.67953, 33.47496], [-117.67961, 33.47464], [-117.68103, 33.47492]]]]} Open Access 1 30257 Creekside Park 17773 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 6.647 Creekside Park 0 Local Park 2 4
12816 12816 12815 {"type": "Polygon", "coordinates": [[[-117.68886, 33.46637], [-117.68881, 33.46642], [-117.6888, 33.46647], [-117.68882, 33.46662], [-117.68869, 33.46661], [-117.68873, 33.46658], [-117.68874, 33.46654], [-117.68871, 33.46649], [-117.68865, 33.46646], [-117.68867, 33.46638], [-117.68848, 33.46613], [-117.68824, 33.46605], [-117.68831, 33.46585], [-117.68878, 33.46598], [-117.68886, 33.46637]]]} Open Access 1 30260 Sea View Park 25237 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.501 Sea View Park 0 Local Park 2 4
12817 12817 12816 {"type": "Polygon", "coordinates": [[[-117.69767, 33.46954], [-117.69752, 33.46954], [-117.69752, 33.46919], [-117.69767, 33.46919], [-117.69766, 33.46937], [-117.69767, 33.46954]]]} Open Access 1 30261 Shipwreck Park 25414 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.131 Shipwreck Park 0 Local Park 2 4
12818 12818 12817 {"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 30262 La Plaza Park 20793 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.781 La Plaza Park 0 Local Park 2 4
12820 12820 12819 {"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 30264 Lantern Village Community Park 21017 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 0.285 Lantern Village Community Park 0 Local Park 2 4
12821 12821 12820 {"type": "Polygon", "coordinates": [[[-117.72107, 33.48182], [-117.71992, 33.48188], [-117.71981, 33.48185], [-117.71968, 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.71672, 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 30265 Sea Terrace Park 25236 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 27.329 Sea Terrace Park 0 Local Park 2 4
12864 12864 12863 {"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.7098, 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.4618], [-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.46122], [-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 44544 Dana Point Park 17912 1079 Dana Point, City of 134 City 2 City Agency 2 http://www.danapoint.org/index.aspx?page=170 City 2 1079 Dana Point, City of 131 City 2 City Agency 2   Orange 3 9.325 Dana Point Park 0 Local Park 2 4

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