units_with_maps

Table actions

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

7 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 287

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Whittier, City of · 7 ✖

DES_TP 1

  • Local Recreation Area · 7 ✖

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
945 945 944 {"type": "MultiPolygon", "coordinates": [[[[-118.06513, 33.99083], [-118.06488, 33.99107], [-118.06383, 33.99036], [-118.06403, 33.99015], [-118.06408, 33.99013], [-118.06412, 33.99013], [-118.06513, 33.99083]]], [[[-118.06667, 33.99189], [-118.06683, 33.99199], [-118.06684, 33.99203], [-118.06663, 33.99225], [-118.06531, 33.99136], [-118.06551, 33.99115], [-118.06556, 33.99114], [-118.06667, 33.99189]]]]} Open Access 1 6512 Whittier Boulevard Greenbelt 29861 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 2.418 Whittier Boulevard Greenbelt 0 Local Recreation Area 3 4
1110 1110 1109 {"type": "Polygon", "coordinates": [[[-118.05777, 34.02462], [-118.05596, 34.02781], [-118.0555, 34.02794], [-118.05614, 34.03005], [-118.05591, 34.03011], [-118.05443, 34.02787], [-118.05411, 34.02797], [-118.05257, 34.02758], [-118.0521, 34.02755], [-118.05374, 34.02676], [-118.05406, 34.02413], [-118.05457, 34.02336], [-118.05777, 34.02462]]]} Open Access 1 6542 Whittier Narrows Recreation Area 27481 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 37.098 Whittier Narrows Rec. Area 0 Local Recreation Area 3 4
7189 7189 7188 {"type": "Polygon", "coordinates": [[[-118.05259, 33.95681], [-118.05074, 33.95865], [-118.05065, 33.95865], [-118.04934, 33.95774], [-118.05065, 33.95647], [-118.05259, 33.95681]]]} Open Access 1 6529 York Field 27780 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 9.184 York Field 0 Local Recreation Area 3 4
7271 7271 7270 {"type": "MultiPolygon", "coordinates": [[[[-118.01971, 33.9463], [-118.01948, 33.94639], [-118.0187, 33.94601], [-118.0188, 33.94587], [-118.01971, 33.9463]]], [[[-118.02441, 33.94909], [-118.02429, 33.94915], [-118.02312, 33.94833], [-118.02309, 33.94835], [-118.02273, 33.94811], [-118.02217, 33.94776], [-118.02113, 33.94717], [-118.01977, 33.94652], [-118.01997, 33.94642], [-118.0218, 33.94729], [-118.02441, 33.94909]]], [[[-118.02875, 33.95205], [-118.02866, 33.9521], [-118.02863, 33.95209], [-118.02683, 33.95086], [-118.02585, 33.9502], [-118.02583, 33.95021], [-118.02442, 33.94925], [-118.02455, 33.94918], [-118.02875, 33.95205]]], [[[-118.0343, 33.95582], [-118.03418, 33.95593], [-118.02874, 33.95219], [-118.02897, 33.95206], [-118.03424, 33.95571], [-118.03423, 33.95572], [-118.0343, 33.95577], [-118.0343, 33.95582]]], [[[-118.03717, 33.95872], [-118.03703, 33.95885], [-118.03668, 33.95829], [-118.03638, 33.95788], [-118.03613, 33.95758], [-118.0359, 33.95733], [-118.03546, 33.9569], [-118.03488, 33.95643], [-118.03434, 33.95604], [-118.03443, 33.95594], [-118.03449, 33.95593], [-118.03464, 33.95603], [-118.03588, 33.95693], [-118.03583, 33.957], [-118.03629, 33.95748], [-118.03652, 33.95776], [-118.03685, 33.9582], [-118.03717, 33.95872]]], [[[-118.03931, 33.96332], [-118.03916, 33.96347], [-118.03773, 33.96032], [-118.03718, 33.95913], [-118.03732, 33.95899], [-118.03752, 33.95938], [-118.03931, 33.96332]]], [[[-118.04156, 33.96787], [-118.04144, 33.96798], [-118.04115, 33.9678], [-118.04095, 33.96749], [-118.04066, 33.96694], [-118.03923, 33.96375], [-118.03947, 33.96351], [-118.04096, 33.96681], [-118.04132, 33.96748], [-118.04156, 33.96787]]], [[[-118.04196, 33.96851], [-118.04195, 33.96896], [-118.04149, 33.96827], [-118.04163, 33.96827], [-118.04186, 33.96837], [-118.04196, 33.96851]]], [[[-118.04487, 33.9734], [-118.0447, 33.97344], [-118.04446, 33.97273], [-118.04436, 33.97272], [-118.04389, 33.97181], [-118.04218, 33.9693], [-118.0422, 33.96892], [-118.04223, 33.96892], [-118.04482, 33.97273], [-118.04459, 33.97273], [-118.04487, 33.9734]]], [[[-118.04525, 33.97459], [-118.04524, 33.97537], [-118.04508, 33.97537], [-118.04508, 33.97499], [-118.04498, 33.97459], [-118.04478, 33.97363], [-118.04476, 33.97359], [-118.04494, 33.97354], [-118.04499, 33.97363], [-118.04511, 33.97393], [-118.04506, 33.97395], [-118.04518, 33.97451], [-118.04509, 33.97452], [-118.04509, 33.97453], [-118.04525, 33.97454], [-118.04525, 33.97459]]], [[[-118.04667, 33.97726], [-118.04666, 33.97899], [-118.04648, 33.97899], [-118.04643, 33.97793], [-118.04625, 33.97792], [-118.04626, 33.97744], [-118.0462, 33.97719], [-118.04612, 33.97704], [-118.04609, 33.97704], [-118.04605, 33.97698], [-118.04598, 33.97698], [-118.04591, 33.97681], [-118.04549, 33.97617], [-118.04519, 33.97553], [-118.04531, 33.97554], [-118.04612, 33.97674], [-118.04615, 33.97674], [-118.04648, 33.97726], [-118.04667, 33.97726]]], [[[-118.0466, 33.97922], [-118.0466, 33.97959], [-118.04643, 33.9796], [-118.04643, 33.97921], [-118.0466, 33.97922]]], [[[-118.0466, 33.98071], [-118.04651, 33.98046], [-118.04647, 33.98028], [-118.04646, 33.98001], [-118.04647, 33.97965], [-118.0466, 33.97965], [-118.0466, 33.98071]]], [[[-118.04847, 33.98263], [-118.04817, 33.98262], [-118.0478, 33.98224], [-118.04779, 33.98214], [-118.04774, 33.98209], [-118.04768, 33.98209], [-118.04727, 33.98167], [-118.04725, 33.98168], [-118.0469, 33.98132], [-118.04673, 33.98109], [-118.04674, 33.98097], [-118.04693, 33.98097], [-118.04698, 33.98107], [-118.04714, 33.98127], [-118.04847, 33.98263]]], [[[-118.05016, 33.98446], [-118.04996, 33.98445], [-118.04937, 33.98386], [-118.04936, 33.98382], [-118.04841, 33.98285], [-118.04867, 33.98285], [-118.04936, 33.98354], [-118.04936, 33.98359], [-118.05014, 33.98437], [-118.05016, 33.9844], [-118.05016, 33.98446]]], [[[-118.05017, 33.98468], [-118.0501, 33.98461], [-118.05003, 33.98454], [-118.05016, 33.98453], [-118.05017, 33.98468]]], [[[-118.05456, 33.98908], [-118.05248, 33.98697], [-118.05247, 33.987], [-118.05037, 33.98487], [-118.05037, 33.98457], [-118.05301, 33.98724], [-118.05298, 33.98726], [-118.05304, 33.98731], [-118.05456, 33.98886], [-118.05456, 33.98908]]], [[[-118.05979, 33.99413], [-118.05964, 33.99427], [-118.05961, 33.99425], [-118.05543, 33.99001], [-118.05476, 33.98932], [-118.05476, 33.98901], [-118.05979, 33.99413]]], [[[-118.06622, 33.99876], [-118.06611, 33.99887], [-118.06562, 33.99842], [-118.06564, 33.99839], [-118.06513, 33.998], [-118.06432, 33.99751], [-118.06305, 33.99675], [-118.06303, 33.99677], [-118.06164, 33.99595], [-118.06104, 33.99554], [-118.06045, 33.99509], [-118.06004, 33.99473], [-118.05975, 33.99437], [-118.05987, 33.99425], [-118.06005, 33.99448], [-118.06015, 33.99457], [-118.06134, 33.99559], [-118.06214, 33.99609], [-118.06226, 33.99612], [-118.06225, 33.99614], [-118.0651, 33.99784], [-118.0655, 33.99813], [-118.06582, 33.99838], [-118.06622, 33.99876]]]]} Open Access 1 6509 Whittier Greenway Trail 27475 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 34.834 Whittier Greenway Trail 0 Local Recreation Area 3 4
7275 7275 7274 {"type": "Polygon", "coordinates": [[[-118.03492, 33.97189], [-118.03492, 33.97353], [-118.03427, 33.97353], [-118.03331, 33.9734], [-118.03332, 33.97241], [-118.03385, 33.9724], [-118.03385, 33.97215], [-118.03394, 33.97215], [-118.03395, 33.97189], [-118.0344, 33.9719], [-118.03441, 33.97215], [-118.03447, 33.97214], [-118.03448, 33.9719], [-118.03492, 33.97189]]]} Open Access 1 6518 Friends Park Complex 19117 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 5.686 Friends Park Complex 0 Local Recreation Area 3 4
7276 7276 7275 {"type": "Polygon", "coordinates": [[[-118.00215, 33.94886], [-118.00214, 33.9489], [-118.00206, 33.949], [-118.002, 33.94912], [-118.00178, 33.94977], [-118.00198, 33.94984], [-118.00196, 33.94995], [-118.00167, 33.9504], [-118.0013, 33.95135], [-118.00092, 33.95167], [-118.00051, 33.95194], [-118.00043, 33.9518], [-118.0004, 33.95175], [-118.0004, 33.95168], [-118.00045, 33.95164], [-118.00065, 33.95159], [-118.00085, 33.95147], [-118.00099, 33.95134], [-118.00109, 33.95121], [-118.00154, 33.95019], [-118.00168, 33.94978], [-118.00193, 33.94917], [-118.00205, 33.94898], [-118.00215, 33.94886]]]} Open Access 1 6519 La Serna Drive Open Space 20807 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 1.661 La Serna Drive OS 0 Local Recreation Area 3 4
16034 16034 16033 {"type": "Polygon", "coordinates": [[[-118.02482, 33.98022], [-118.02407, 33.9806], [-118.02376, 33.98114], [-118.02378, 33.98121], [-118.02382, 33.98125], [-118.02386, 33.98126], [-118.02393, 33.98125], [-118.02374, 33.98136], [-118.02358, 33.98126], [-118.02323, 33.98115], [-118.0225, 33.98121], [-118.0216, 33.98166], [-118.01996, 33.98163], [-118.01995, 33.98253], [-118.01676, 33.98248], [-118.01673, 33.98326], [-118.01617, 33.98356], [-118.01558, 33.98377], [-118.01405, 33.98404], [-118.01334, 33.98402], [-118.0129, 33.9839], [-118.01238, 33.98365], [-118.01159, 33.98351], [-118.01098, 33.98353], [-118.01011, 33.98279], [-118.00999, 33.982], [-118.01028, 33.98102], [-118.01084, 33.98063], [-118.01287, 33.98141], [-118.01311, 33.98104], [-118.01375, 33.98062], [-118.01378, 33.98056], [-118.01378, 33.9805], [-118.01371, 33.98042], [-118.01361, 33.9804], [-118.01256, 33.98079], [-118.01267, 33.98046], [-118.01485, 33.97894], [-118.01564, 33.97895], [-118.01564, 33.97709], [-118.01907, 33.97712], [-118.01997, 33.97662], [-118.01998, 33.97533], [-118.0235, 33.97537], [-118.0214, 33.97828], [-118.02166, 33.97931], [-118.02167, 33.97931], [-118.02174, 33.97925], [-118.02178, 33.97917], [-118.02178, 33.97915], [-118.02303, 33.97958], [-118.02325, 33.97978], [-118.02331, 33.97974], [-118.02366, 33.98006], [-118.02415, 33.97987], [-118.02482, 33.98022]]]} Open Access 1 6516 Worsham Canyon Open Space 14873 1380 Whittier, City of 291 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 154.353 Worsham Canyon OS 0 Local Recreation Area 3 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]);