calands: units_with_maps: 11 rows where AGNCY

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

11 rows where AGNCY_NAME = 707

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
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	Local Park 2	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	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	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	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	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	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	Local Park 2	4
15365	15365	15364	{"type": "Polygon", "coordinates": [[[-118.00234, 33.92712], [-118.00162, 33.92729], [-118.0016, 33.92713], [-118.0015, 33.92688], [-118.00137, 33.92672], [-118.00117, 33.92657], [-118.00098, 33.92647], [-118.00074, 33.92575], [-118.0018, 33.92549], [-118.00234, 33.92712]]]}	Restricted Access 2	46561	Scott Avenue Elementary School Park	31906	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.025	Scott Avenue Elementary School Park	Local Park 2	4
15371	15371	15370	{"type": "Polygon", "coordinates": [[[-118.00458, 33.9266], [-118.00234, 33.92712], [-118.00169, 33.92516], [-118.00393, 33.92463], [-118.00458, 33.9266]]]}	Restricted Access 2	46567	Granada Middle School Park	31912	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	12.037	Granada Middle School Park	Local Park 2	4
15372	15372	15371	{"type": "Polygon", "coordinates": [[[-117.98787, 33.94757], [-117.98771, 33.94783], [-117.98755, 33.94804], [-117.98742, 33.94817], [-117.98728, 33.94827], [-117.98705, 33.9484], [-117.9864, 33.94818], [-117.98619, 33.94749], [-117.98701, 33.94731], [-117.98787, 33.94757]]]}	Restricted Access 2	46581	Murphy Ranch Elementary School Park	31919	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.01	Murphy Ranch Elementary School Park	Local Park 2	4
15373	15373	15372	{"type": "Polygon", "coordinates": [[[-118.00906, 33.93605], [-118.00905, 33.93665], [-118.00888, 33.93669], [-118.00796, 33.93701], [-118.00795, 33.93695], [-118.0074, 33.93695], [-118.00741, 33.93657], [-118.00719, 33.93652], [-118.00734, 33.93606], [-118.00706, 33.936], [-118.00713, 33.93579], [-118.00721, 33.93576], [-118.00718, 33.9357], [-118.00732, 33.93569], [-118.00731, 33.93533], [-118.0077, 33.93533], [-118.00906, 33.93605]]]}	Restricted Access 2	46584	Orchard Dale Elementary School Park	31921	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.701	Orchard Dale Elementary School 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]);