calands: units_with_maps: 48 rows where MNG

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

48 rows where MNG_AGENCY = 287

Search:

descending

This data as json, copyable, CSV (advanced)

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
3975	3975	3974	{"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]}	Restricted Access 2	46582	Ocean View Elementary School Park	31920	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	5.333	Ocean View Elementary School 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
4830	4830	4829	{"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.01511, 33.95485], [-118.01456, 33.95558], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]}	Restricted Access 2	46570	East Whittier Middle School Park	31913	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	10.453	East Whittier Middle School Park	0	Local Park 2	4
5721	5721	5720	{"type": "Polygon", "coordinates": [[[-118.03804, 33.95602], [-118.03719, 33.95686], [-118.03667, 33.9565], [-118.03649, 33.95641], [-118.03662, 33.95617], [-118.03671, 33.9562], [-118.03678, 33.95608], [-118.03691, 33.95609], [-118.03698, 33.95594], [-118.03709, 33.95597], [-118.03726, 33.95566], [-118.03687, 33.95551], [-118.03656, 33.95547], [-118.03544, 33.95494], [-118.03587, 33.95451], [-118.03804, 33.95602]]]}	Restricted Access 2	46576	Laurel Elementary School Park	31914	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	4.34	Laurel Elementary School Park	0	Local Park 2	4
5722	5722	5721	{"type": "Polygon", "coordinates": [[[-118.00903, 33.93231], [-118.00901, 33.93505], [-118.00717, 33.93505], [-118.00718, 33.93474], [-118.00684, 33.93474], [-118.00684, 33.93436], [-118.00787, 33.93437], [-118.00787, 33.93381], [-118.00782, 33.9337], [-118.00791, 33.93347], [-118.00798, 33.93313], [-118.00801, 33.93308], [-118.00808, 33.93307], [-118.00826, 33.93307], [-118.00832, 33.93305], [-118.00837, 33.93301], [-118.00852, 33.93231], [-118.00903, 33.93231]]]}	Restricted Access 2	46577	Hillview Middle School Park	31915	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	8.349	Hillview Middle School Park	0	Local Park 2	4
5723	5723	5722	{"type": "Polygon", "coordinates": [[[-118.0221, 33.92802], [-118.02161, 33.92867], [-118.02021, 33.92797], [-118.02072, 33.92729], [-118.0221, 33.92802]]]}	Restricted Access 2	46578	La Colima Elementary School Park	31916	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	3.236	La Colima Elementary School Park	0	Local Park 2	4
5724	5724	5723	{"type": "Polygon", "coordinates": [[[-118.02929, 33.94516], [-118.02862, 33.94584], [-118.02768, 33.94519], [-118.02852, 33.94479], [-118.02853, 33.94477], [-118.02849, 33.94475], [-118.02862, 33.94468], [-118.02929, 33.94516]]]}	Restricted Access 2	46579	Mulberry Elementary School Park	31917	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	2.31	Mulberry Elementary School Park	0	Local Park 2	4
5725	5725	5724	{"type": "Polygon", "coordinates": [[[-117.99673, 33.93815], [-117.99599, 33.93932], [-117.99462, 33.93933], [-117.9946, 33.93877], [-117.99468, 33.93871], [-117.99477, 33.93872], [-117.99483, 33.93869], [-117.99485, 33.93866], [-117.99484, 33.93805], [-117.99631, 33.93805], [-117.99648, 33.93807], [-117.99673, 33.93815]]]}	Restricted Access 2	46580	Leffingwell Elementary School Park	31918	2370	East Whittier City School District 707	Special District 4	School District 14	http://ewcsd.org/	Special District 4	1380	Whittier, City of 287	City 2	City Agency 2		Los Angeles 6	5.265	Leffingwell Elementary School Park	0	Local Park 2	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

Advanced export

JSON shape: default, array, newline-delimited

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