units_with_maps

Table actions

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

30 rows where AGNCY_NAME = 291 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 30 ✖

MNG_AGENCY 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
1093 1093 1092 {"type": "Polygon", "coordinates": [[[-117.99593, 33.93932], [-117.99532, 33.9402], [-117.99459, 33.93977], [-117.99392, 33.93977], [-117.99376, 33.94011], [-117.99329, 33.94011], [-117.99324, 33.94009], [-117.99322, 33.94006], [-117.99324, 33.93934], [-117.99593, 33.93932]]]} Open Access 1 6524 Leffingwell Ranch Park 21137 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 3.953 Leffingwell Ranch Park 0 Local Park 2 4
1106 1106 1105 {"type": "MultiPolygon", "coordinates": [[[[-118.01025, 33.96928], [-118.00905, 33.97078], [-118.0088, 33.97086], [-118.00826, 33.97078], [-118.00887, 33.97002], [-118.00795, 33.9695], [-118.00792, 33.9694], [-118.00843, 33.96896], [-118.00845, 33.96883], [-118.00937, 33.96935], [-118.00969, 33.96896], [-118.01025, 33.96928]]], [[[-118.01077, 33.9639], [-118.01053, 33.9642], [-118.01004, 33.96394], [-118.01029, 33.9636], [-118.01076, 33.96386], [-118.01077, 33.9639]]]]} Open Access 1 6522 Arroyo Pescadero 28934 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 http://www.habitatauthority.org/trails/ Los Angeles 6 6.285 Arroyo Pescadero   None 100  
1107 1107 1106 {"type": "MultiPolygon", "coordinates": [[[[-118.05395, 33.99771], [-118.05385, 33.99785], [-118.05376, 33.9978], [-118.05374, 33.99776], [-118.05379, 33.99767], [-118.05387, 33.99761], [-118.05395, 33.99771]]], [[[-118.05481, 33.99824], [-118.05455, 33.99845], [-118.05418, 33.99801], [-118.0541, 33.99797], [-118.05419, 33.99786], [-118.05447, 33.99773], [-118.05481, 33.99824]]], [[[-118.05463, 33.99697], [-118.05456, 33.99704], [-118.05445, 33.99709], [-118.05438, 33.99708], [-118.05432, 33.99701], [-118.05462, 33.99687], [-118.05463, 33.99697]]]]} Open Access 1 6513 Hoover Fountain and Park 20078 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 0.789 Hoover Fountain and Park 0 Local Park 2 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
1111 1111 1110 {"type": "Polygon", "coordinates": [[[-118.01451, 33.95008], [-118.01401, 33.9514], [-118.01307, 33.95088], [-118.01304, 33.95089], [-118.01275, 33.95073], [-118.01441, 33.95002], [-118.01451, 33.95008]]]} Open Access 1 6532 Anaconda Park 15464 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.703 Anaconda Park 0 Local Park 2 4
1703 1703 1702 {"type": "MultiPolygon", "coordinates": [[[[-118.0454, 33.98641], [-118.0454, 33.98717], [-118.04443, 33.98717], [-118.04443, 33.9864], [-118.0454, 33.98641]]], [[[-118.04592, 33.9864], [-118.04592, 33.98717], [-118.04548, 33.98716], [-118.04548, 33.9864], [-118.04592, 33.9864]]], [[[-118.04752, 33.98641], [-118.04752, 33.98724], [-118.04609, 33.98725], [-118.0461, 33.98641], [-118.04752, 33.98641]]]]} Open Access 1 6540 Founders Memorial Park 19019 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.781 Founders Memorial Park 0 Local Park 2 4
1704 1704 1703 {"type": "MultiPolygon", "coordinates": [[[[-118.05718, 33.99178], [-118.05479, 33.99178], [-118.05477, 33.99], [-118.05543, 33.99001], [-118.05718, 33.99178]]], [[[-118.05829, 33.99261], [-118.05747, 33.99178], [-118.05572, 33.99], [-118.05744, 33.98999], [-118.05804, 33.99178], [-118.05829, 33.99261]]]]} Open Access 1 6541 Palm Park 23346 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 12.607 Palm Park 0 Local Park 2 4
3199 3199 3198 {"type": "Polygon", "coordinates": [[[-118.04432, 33.97678], [-118.04324, 33.97681], [-118.04324, 33.97595], [-118.04431, 33.97595], [-118.04432, 33.97678]]]} Open Access 1 22156 J.G. Whittier Park 20294 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.326 J.G. Whittier Park 0 Local Park 2 4
4432 4432 4431 {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97833], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} Restricted Access 2 46559 Whittier Dog Park 29862 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 0.849 Whittier Dog Park 0 Local Park 2 4
4499 4499 4498 {"type": "MultiPolygon", "coordinates": [[[[-118.03255, 33.97371], [-118.03203, 33.9737], [-118.03203, 33.97351], [-118.03246, 33.97351], [-118.03249, 33.97355], [-118.03255, 33.97359], [-118.03255, 33.97371]]], [[[-118.03556, 33.97383], [-118.03511, 33.97384], [-118.0351, 33.9737], [-118.03556, 33.9737], [-118.03556, 33.97383]]], [[[-118.03609, 33.9737], [-118.03608, 33.97384], [-118.03563, 33.97384], [-118.03562, 33.97371], [-118.03609, 33.9737]]], [[[-118.03723, 33.98024], [-118.03676, 33.98024], [-118.03676, 33.98001], [-118.03723, 33.98002], [-118.03723, 33.98024]]], [[[-118.03912, 33.97384], [-118.03866, 33.97384], [-118.03865, 33.97371], [-118.03912, 33.97371], [-118.03912, 33.97384]]], [[[-118.03965, 33.97385], [-118.03919, 33.97384], [-118.03919, 33.97371], [-118.03965, 33.97371], [-118.03965, 33.97385]]], [[[-118.04028, 33.97371], [-118.04027, 33.97385], [-118.03981, 33.97384], [-118.03981, 33.97371], [-118.04028, 33.97371]]], [[[-118.0408, 33.97384], [-118.04035, 33.97385], [-118.04034, 33.97371], [-118.0408, 33.97371], [-118.0408, 33.97384]]], [[[-118.04143, 33.97385], [-118.04096, 33.97384], [-118.04097, 33.97371], [-118.04142, 33.97371], [-118.04143, 33.97385]]], [[[-118.04196, 33.97385], [-118.04149, 33.97385], [-118.04149, 33.97371], [-118.04196, 33.97371], [-118.04196, 33.97385]]], [[[-118.04312, 33.97387], [-118.04306, 33.97383], [-118.04264, 33.97382], [-118.04225, 33.97382], [-118.04219, 33.97387], [-118.04218, 33.97373], [-118.04223, 33.97369], [-118.04311, 33.97369], [-118.04312, 33.97387]]]]} Open Access 1 6534 Unnamed site - Whittier, City of 29858 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.108   0 Local Other or Unknown 14 4
7150 7150 7149 {"type": "Polygon", "coordinates": [[[-118.0032, 33.93615], [-118.00318, 33.93794], [-118.00101, 33.9369], [-118.00093, 33.93678], [-118.00093, 33.93533], [-118.00095, 33.93532], [-118.003, 33.93532], [-118.00301, 33.93615], [-118.0032, 33.93615]]]} Open Access 1 6525 Parnell Park 23471 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 11.568 Parnell Park 0 Local Park 2 4
7181 7181 7180 {"type": "Polygon", "coordinates": [[[-118.00272, 33.96169], [-118.00267, 33.96172], [-118.00217, 33.96176], [-118.0021, 33.96173], [-118.002, 33.96147], [-118.00205, 33.96143], [-118.00216, 33.96141], [-118.00237, 33.96144], [-118.00269, 33.96162], [-118.00271, 33.96164], [-118.00272, 33.96169]]]} Open Access 1 6523 Pat Nixon Fountain and Park 23503 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 0.433 Pat Nixon Fountain and Park 0 Local Park 2 4
7184 7184 7183 {"type": "Polygon", "coordinates": [[[-117.9869, 33.95804], [-117.98647, 33.95805], [-117.9864, 33.95809], [-117.98534, 33.9581], [-117.98445, 33.95834], [-117.98413, 33.95852], [-117.98303, 33.95922], [-117.98195, 33.95881], [-117.98125, 33.95823], [-117.98154, 33.95805], [-117.98175, 33.95808], [-117.98243, 33.95767], [-117.9827, 33.95744], [-117.9834, 33.95729], [-117.98337, 33.95714], [-117.98383, 33.95702], [-117.98396, 33.95707], [-117.98483, 33.95676], [-117.98529, 33.95633], [-117.98569, 33.9564], [-117.98619, 33.95691], [-117.98671, 33.95678], [-117.98673, 33.95685], [-117.98678, 33.95718], [-117.98678, 33.9572], [-117.98673, 33.95723], [-117.98675, 33.95738], [-117.98681, 33.95741], [-117.9869, 33.95804]]]} Open Access 1 6521 Murphy Ranch Park 22609 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 19.408 Murphy Ranch Park 0 Local Park 2 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
7190 7190 7189 {"type": "Polygon", "coordinates": [[[-118.02931, 33.95594], [-118.0286, 33.95664], [-118.02858, 33.95668], [-118.02856, 33.95668], [-118.0283, 33.9565], [-118.02902, 33.95578], [-118.02909, 33.95578], [-118.02931, 33.95594]]]} Open Access 1 6530 Laurel Park 21103 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 0.838 Laurel Park 0 Local Park 2 4
7195 7195 7194 {"type": "MultiPolygon", "coordinates": [[[[-118.03963, 33.98542], [-118.03962, 33.98623], [-118.03916, 33.98622], [-118.03917, 33.98541], [-118.03963, 33.98542]]], [[[-118.04078, 33.98623], [-118.03971, 33.98623], [-118.0397, 33.98582], [-118.04077, 33.98583], [-118.04078, 33.98623]]]]} Open Access 1 6539 Broadway Park 16409 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.033 Broadway Park 0 Local Park 2 4
7198 7198 7197 {"type": "Polygon", "coordinates": [[[-118.0358, 33.96005], [-118.03541, 33.96044], [-118.03449, 33.95981], [-118.03489, 33.95943], [-118.0358, 33.96005]]]} Open Access 1 6531 Kennedy Park 20601 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.527 Kennedy Park 0 Local Park 2 4
7246 7246 7245 {"type": "MultiPolygon", "coordinates": [[[[-118.07201, 33.99374], [-118.07172, 33.99428], [-118.07171, 33.9943], [-118.07171, 33.9943], [-118.07201, 33.99374]]], [[[-118.0717, 33.99431], [-118.0717, 33.99431], [-118.07163, 33.99444], [-118.07136, 33.99471], [-118.0712, 33.9946], [-118.07149, 33.9943], [-118.07164, 33.9944], [-118.0717, 33.99431]]], [[[-118.07229, 33.99322], [-118.07171, 33.99283], [-118.07171, 33.99283], [-118.07197, 33.99299], [-118.07229, 33.99322]]]]} Open Access 1 6528 Pío Pico State Historic Park 28084 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 0.216 Pío Pico SHP 1917 None 596  
7262 7262 7261 {"type": "Polygon", "coordinates": [[[-118.03725, 33.96882], [-118.03725, 33.96957], [-118.03679, 33.96957], [-118.0368, 33.96954], [-118.0368, 33.96881], [-118.03725, 33.96882]]]} Open Access 1 6533 Lee Owens Park 21134 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 0.873 Lee Owens Park 0 Local Park 2 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]);