calands: units_with_maps: 15 rows where AGNCY_NAME = 304, DES_TP = 2 and MNG

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

15 rows where AGNCY_NAME = 304, DES_TP = 2 and MNG_AGENCY = 300

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
1008	1008	1007	{"type": "Polygon", "coordinates": [[[-118.24404, 33.83769], [-118.24404, 33.83815], [-118.24268, 33.83816], [-118.24268, 33.83844], [-118.24232, 33.83844], [-118.24231, 33.83816], [-118.24103, 33.83817], [-118.24103, 33.83635], [-118.2436, 33.83634], [-118.2436, 33.83723], [-118.24403, 33.83724], [-118.24361, 33.83726], [-118.24361, 33.83768], [-118.24404, 33.83769]]]}	Open Access 1	6245	Dolphin Park	18192	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	12.671	Dolphin Park	Local Park 2	4
2201	2201	2200	{"type": "Polygon", "coordinates": [[[-118.26317, 33.8491], [-118.2621, 33.84957], [-118.26194, 33.84955], [-118.26186, 33.84959], [-118.26169, 33.84923], [-118.26131, 33.84865], [-118.26125, 33.84853], [-118.26111, 33.84745], [-118.26112, 33.84744], [-118.2611, 33.84742], [-118.26107, 33.84723], [-118.26207, 33.84748], [-118.26249, 33.84755], [-118.26298, 33.84762], [-118.26317, 33.8491]]]}	Open Access 1	6240	Del Amo Park	18022	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	8.624	Del Amo Park	Local Park 2	4
3133	3133	3132	{"type": "Polygon", "coordinates": [[[-118.27833, 33.8369], [-118.27827, 33.8369], [-118.27808, 33.83715], [-118.27783, 33.83715], [-118.27782, 33.83677], [-118.27827, 33.83669], [-118.27833, 33.8369]]]}	Open Access 1	48036	Reflections Mini Park	32529	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2	http://ci.carson.ca.us/communityservices/Parks_Rec_Parks.aspx#Reflections	Los Angeles 6	0.436	Reflections MP	Local Park 2	4
7133	7133	7132	{"type": "Polygon", "coordinates": [[[-118.24836, 33.84879], [-118.24832, 33.84883], [-118.24633, 33.84884], [-118.24631, 33.84881], [-118.24631, 33.84826], [-118.24634, 33.84812], [-118.24633, 33.84802], [-118.24666, 33.84785], [-118.24675, 33.84787], [-118.24836, 33.84786], [-118.24836, 33.84879]]]}	Open Access 1	6239	Dr. Thomas G. Mills Memorial Park	18268	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	4.97	Dr. Thomas G. Mills Memorial Park	Local Park 2	4
7142	7142	7141	{"type": "Polygon", "coordinates": [[[-118.25871, 33.87287], [-118.25868, 33.8729], [-118.25858, 33.87292], [-118.25806, 33.87298], [-118.25752, 33.87298], [-118.25714, 33.87295], [-118.25708, 33.87153], [-118.25716, 33.87152], [-118.25716, 33.8713], [-118.25647, 33.87131], [-118.25645, 33.87071], [-118.25686, 33.8707], [-118.25685, 33.87032], [-118.25857, 33.87027], [-118.25862, 33.87029], [-118.25863, 33.87031], [-118.25869, 33.87184], [-118.25871, 33.87287]]]}	Open Access 1	6235	Stevenson Park	25844	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	11.809	Stevenson Park	Local Park 2	4
7144	7144	7143	{"type": "MultiPolygon", "coordinates": [[[[-118.26409, 33.88086], [-118.26278, 33.8809], [-118.26311, 33.88234], [-118.26181, 33.88237], [-118.26148, 33.88095], [-118.2614, 33.88072], [-118.26125, 33.88003], [-118.26387, 33.87995], [-118.26409, 33.88086]]], [[[-118.26463, 33.87993], [-118.2645, 33.88113], [-118.26446, 33.88116], [-118.26438, 33.88116], [-118.26434, 33.88112], [-118.26415, 33.88034], [-118.26418, 33.88007], [-118.26416, 33.88002], [-118.26406, 33.87995], [-118.26463, 33.87993]]]]}	Open Access 1	6236	Vernon M. Hemingway Memorial Park	27003	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	11.928	Vernon M. Hemingway Memorial Park	Local Park 2	4
7145	7145	7144	{"type": "Polygon", "coordinates": [[[-118.2689, 33.87422], [-118.26878, 33.87562], [-118.26841, 33.87564], [-118.2685, 33.8756], [-118.26855, 33.87556], [-118.2686, 33.87545], [-118.26862, 33.87537], [-118.26869, 33.87443], [-118.26868, 33.87423], [-118.2689, 33.87422]]]}	Open Access 1	6237	Walnut Street Park	27244	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	0.677	Walnut Street Park	Local Park 2	4
7146	7146	7145	{"type": "Polygon", "coordinates": [[[-118.23663, 33.85793], [-118.23508, 33.85798], [-118.23505, 33.85798], [-118.23501, 33.85795], [-118.23484, 33.85606], [-118.23486, 33.856], [-118.2349, 33.85599], [-118.23655, 33.85594], [-118.23663, 33.85793]]]}	Open Access 1	6238	James Anderson, Jr. Memorial Park	20342	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	8.451	James Anderson, Jr. Memorial Park	Local Park 2	4
7149	7149	7148	{"type": "Polygon", "coordinates": [[[-118.21586, 33.83428], [-118.21542, 33.83545], [-118.21543, 33.83546], [-118.21549, 33.83546], [-118.21548, 33.83549], [-118.21407, 33.83549], [-118.21407, 33.83547], [-118.21282, 33.83546], [-118.21342, 33.83428], [-118.21586, 33.83428]]]}	Open Access 1	6246	Dominguez Park	18195	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	7.645	Dominguez Park	Local Park 2	4
7151	7151	7150	{"type": "Polygon", "coordinates": [[[-118.25765, 33.82779], [-118.25509, 33.8278], [-118.25506, 33.82778], [-118.25505, 33.82696], [-118.2551, 33.82691], [-118.25713, 33.82691], [-118.25713, 33.82443], [-118.25715, 33.82439], [-118.2572, 33.82437], [-118.25765, 33.82437], [-118.25765, 33.82779]]]}	Open Access 1	6248	John D. Calas, Sr. Park	20433	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	9.224	John D. Calas, Sr. Park	Local Park 2	4
7153	7153	7152	{"type": "Polygon", "coordinates": [[[-118.2786, 33.83441], [-118.27563, 33.83442], [-118.27564, 33.83526], [-118.27468, 33.83526], [-118.27464, 33.83522], [-118.27464, 33.83353], [-118.27836, 33.83352], [-118.2786, 33.83441]]]}	Open Access 1	6250	Carson Park	16921	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	10.804	Carson Park	Local Park 2	4
7154	7154	7153	{"type": "Polygon", "coordinates": [[[-118.27119, 33.81246], [-118.27117, 33.81496], [-118.27118, 33.81506], [-118.27114, 33.8152], [-118.2711, 33.81522], [-118.27103, 33.81523], [-118.27069, 33.81501], [-118.27055, 33.81496], [-118.27043, 33.81493], [-118.26943, 33.81494], [-118.2694, 33.81493], [-118.2694, 33.81477], [-118.26951, 33.81241], [-118.27119, 33.81246]]]}	Open Access 1	6251	Scott Park	25204	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	11.27	Scott Park	Local Park 2	4
7155	7155	7154	{"type": "Polygon", "coordinates": [[[-118.28502, 33.80964], [-118.28351, 33.80964], [-118.28353, 33.80794], [-118.28418, 33.80794], [-118.28423, 33.80795], [-118.28431, 33.808], [-118.28433, 33.80812], [-118.28442, 33.80834], [-118.28493, 33.8094], [-118.28502, 33.80964]]]}	Open Access 1	6252	Carriage Crest Park	16908	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	4.845	Carriage Crest Park	Local Park 2	4
7952	7952	7951	{"type": "Polygon", "coordinates": [[[-118.24147, 33.82799], [-118.24141, 33.82854], [-118.24084, 33.82854], [-118.24088, 33.8284], [-118.2413, 33.82838], [-118.24146, 33.82798], [-118.24147, 33.82799]]]}	Open Access 1	6247	Friendship Mini Park	19118	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	0.285	Friendship MP	Local Park 2	4
15244	15244	15243	{"type": "Polygon", "coordinates": [[[-118.2527, 33.8336], [-118.25218, 33.8336], [-118.25202, 33.83339], [-118.25212, 33.83333], [-118.25215, 33.83328], [-118.25216, 33.83322], [-118.25213, 33.83305], [-118.25213, 33.83285], [-118.25216, 33.83281], [-118.25265, 33.8328], [-118.25269, 33.83282], [-118.2527, 33.8336]]]}	Open Access 1	46442	Perry Park	29716	1048	Carson, City of 304	City 2	City Agency 2	http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp	City 2	1048	Carson, City of 300	City 2	City Agency 2		Los Angeles 6	1.149	Perry 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]);