calands: units_with_maps: 18 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG

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

18 rows where ACCESS_TYP = 1, DES_TP = 2 and 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	DES_TP	GAP_STS
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	Local Park 2	4
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	Local Park 2	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	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	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	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	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	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	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	Local Park 2	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	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	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	Local Park 2	4
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	Local Park 2	4
7272	7272	7271	{"type": "MultiPolygon", "coordinates": [[[[-118.03213, 33.99081], [-118.03186, 33.9908], [-118.03187, 33.99053], [-118.03212, 33.99053], [-118.03213, 33.99081]]], [[[-118.03399, 33.98995], [-118.03398, 33.99019], [-118.0325, 33.99019], [-118.03251, 33.98994], [-118.03399, 33.98995]]], [[[-118.03322, 33.98945], [-118.03321, 33.98986], [-118.03274, 33.98986], [-118.03275, 33.98944], [-118.03322, 33.98945]]], [[[-118.03607, 33.99067], [-118.03607, 33.99067], [-118.03508, 33.99066], [-118.03587, 33.99044], [-118.03606, 33.99043], [-118.03607, 33.99067]]], [[[-118.03783, 33.99604], [-118.03756, 33.99644], [-118.03728, 33.99647], [-118.03727, 33.99604], [-118.03757, 33.99584], [-118.03783, 33.99604]]], [[[-118.0374, 33.99507], [-118.03728, 33.99507], [-118.03728, 33.99483], [-118.03734, 33.99483], [-118.0374, 33.99507]]], [[[-118.03924, 33.99587], [-118.0392, 33.99627], [-118.0389, 33.9963], [-118.03892, 33.99616], [-118.03906, 33.99613], [-118.03913, 33.99609], [-118.03915, 33.99605], [-118.03917, 33.99586], [-118.03924, 33.99587]]], [[[-118.04615, 34.00015], [-118.04611, 34.00027], [-118.04606, 34.00029], [-118.046, 34.00034], [-118.04595, 34.00041], [-118.04595, 34.00044], [-118.04593, 34.00044], [-118.04593, 34.00008], [-118.04615, 34.00015]]]]}	Open Access 1	6511	Hellman Park	14853	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.lamountains.com/parks.asp?parkid=633	Los Angeles 6	2.862	Hellman Park	Local Park 2	4
7277	7277	7276	{"type": "MultiPolygon", "coordinates": [[[[-118.02526, 33.97531], [-118.02514, 33.97531], [-118.02508, 33.97529], [-118.02501, 33.97525], [-118.0248, 33.97503], [-118.02465, 33.97492], [-118.02451, 33.97485], [-118.02428, 33.97479], [-118.02398, 33.97478], [-118.02376, 33.97483], [-118.02355, 33.97493], [-118.02329, 33.97515], [-118.02311, 33.97521], [-118.02293, 33.97521], [-118.02284, 33.97519], [-118.02272, 33.97512], [-118.02266, 33.97508], [-118.0226, 33.97499], [-118.02256, 33.97492], [-118.02256, 33.97481], [-118.02264, 33.97467], [-118.02282, 33.97456], [-118.02301, 33.97449], [-118.02382, 33.97435], [-118.02401, 33.97426], [-118.02419, 33.97412], [-118.02422, 33.97407], [-118.02452, 33.97422], [-118.02454, 33.97418], [-118.02429, 33.97405], [-118.02438, 33.97388], [-118.0244, 33.97378], [-118.02486, 33.97402], [-118.02476, 33.97432], [-118.02526, 33.97531]]], [[[-118.02494, 33.97539], [-118.02494, 33.97539], [-118.02274, 33.97536], [-118.02275, 33.97529], [-118.02285, 33.97532], [-118.02297, 33.97534], [-118.02308, 33.97534], [-118.02324, 33.97531], [-118.02341, 33.97522], [-118.02361, 33.97505], [-118.02372, 33.97499], [-118.02389, 33.97493], [-118.02416, 33.9749], [-118.02436, 33.97494], [-118.02455, 33.97503], [-118.02494, 33.97539]]]]}	Open Access 1	6535	William Penn Park	27556	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.653	William Penn Park	Local Park 2	4
7278	7278	7277	{"type": "Polygon", "coordinates": [[[-118.02298, 33.96402], [-118.02183, 33.96545], [-118.01994, 33.9644], [-118.02109, 33.96296], [-118.02298, 33.96402]]]}	Open Access 1	6536	Michigan Park	22200	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.972	Michigan Park	Local Park 2	4
7279	7279	7278	{"type": "Polygon", "coordinates": [[[-118.03492, 33.98096], [-118.03491, 33.98163], [-118.03392, 33.98163], [-118.03394, 33.98096], [-118.03492, 33.98096]]]}	Open Access 1	6537	Central Park	17064	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.688	Central Park	Local Park 2	4
15307	15307	15306	{"type": "Polygon", "coordinates": [[[-118.03796, 33.97412], [-118.03796, 33.97439], [-118.0375, 33.97439], [-118.0375, 33.97412], [-118.03796, 33.97412]]]}	Open Access 1	46560	Whittier Depot Park	29863	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.321	Whittier Depot Park	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]);