calands: units_with_maps: 132 rows where ACCESS_TYP = 1 and AGNCY

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

132 rows where ACCESS_TYP = 1 and AGNCY_NAME = 298

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
963	963	962	{"type": "Polygon", "coordinates": [[[-118.13204, 33.83966], [-118.13203, 33.84296], [-118.1306, 33.84295], [-118.13062, 33.83966], [-118.13204, 33.83966]]]}	Open Access 1	6576	Pan American Park	23383	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	11.97	Pan American Park	0	Local Park 2	4
965	965	964	{"type": "Polygon", "coordinates": [[[-118.17515, 33.78271], [-118.17514, 33.78433], [-118.17425, 33.78433], [-118.17426, 33.78271], [-118.17515, 33.78271]]]}	Open Access 1	6588	Douglas MacArthur Park	18245	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	3.648	Douglas MacArthur Park	0	Local Park 2	4
967	967	966	{"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]}	Open Access 1	6603	Houghton Park	20109	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	26.14	Houghton Park	0	Local Park 2	4
969	969	968	{"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19542, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19734, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19821, 33.7671], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76709], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]}	Open Access 1	6608	Santa Cruz Park	25082	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	2.096	Santa Cruz Park	0	Local Park 2	4
970	970	969	{"type": "Polygon", "coordinates": [[[-118.19511, 33.76865], [-118.19493, 33.76865], [-118.19494, 33.76918], [-118.19389, 33.76918], [-118.19389, 33.76817], [-118.1949, 33.76817], [-118.19491, 33.76828], [-118.19494, 33.76834], [-118.19502, 33.76837], [-118.19511, 33.76837], [-118.19511, 33.76865]]]}	Open Access 1	6609	Lincoln Park	21264	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	2.816	Lincoln Park	0	Local Park 2	4
971	971	970	{"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84873], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]}	Open Access 1	6612	51st St Greenbelt	29907	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	1.011	51st St Greenbelt	2008	Local Recreation Area 3	4
972	972	971	{"type": "Polygon", "coordinates": [[[-118.18037, 33.84032], [-118.18037, 33.84033], [-118.17814, 33.84152], [-118.17816, 33.84104], [-118.17814, 33.8409], [-118.17808, 33.84071], [-118.17988, 33.83974], [-118.18009, 33.84001], [-118.18012, 33.84], [-118.18037, 33.84032]]]}	Open Access 1	6613	Bixby Knolls Park	16130	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	4.268	Bixby Knolls Park	0	Local Park 2	4
973	973	972	{"type": "Polygon", "coordinates": [[[-118.15882, 33.78532], [-118.15882, 33.78581], [-118.15806, 33.78532], [-118.15684, 33.78532], [-118.15684, 33.78449], [-118.15846, 33.78449], [-118.15846, 33.78475], [-118.15833, 33.78476], [-118.15833, 33.78497], [-118.15846, 33.78497], [-118.15846, 33.7853], [-118.15849, 33.78532], [-118.15882, 33.78532]]]}	Open Access 1	6614	Orizaba Park	23204	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	3.776	Orizaba Park	0	Local Park 2	4
977	977	976	{"type": "Polygon", "coordinates": [[[-118.1256, 33.75282], [-118.12556, 33.75298], [-118.12512, 33.75279], [-118.1256, 33.75282], [-118.1256, 33.75282]]]}	Open Access 1	6656	Treasure Island Park	26519	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	0.102	Treasure Island Park	0	Local Park 2	4
981	981	980	{"type": "Polygon", "coordinates": [[[-118.15763, 33.85724], [-118.15761, 33.85725], [-118.15761, 33.85746], [-118.15552, 33.85747], [-118.15552, 33.85685], [-118.1555, 33.85684], [-118.15551, 33.85637], [-118.15762, 33.85637], [-118.15763, 33.85724]]]}	Open Access 1	6678	Davenport Park	28713	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	5.858	Davenport Park	0	Local Park 2	4
982	982	981	{"type": "Polygon", "coordinates": [[[-118.1171, 33.74531], [-118.11692, 33.74554], [-118.11665, 33.7454], [-118.11684, 33.74516], [-118.1171, 33.74531]]]}	Open Access 1	6681	Alamitos Park	15315	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	0.225	Alamitos Park	0	Local Park 2	4
1120	1120	1119	{"type": "MultiPolygon", "coordinates": [[[[-118.13088, 33.75291], [-118.13072, 33.75313], [-118.12914, 33.75219], [-118.12927, 33.75199], [-118.13088, 33.75291]]], [[[-118.13211, 33.75514], [-118.13039, 33.75789], [-118.13018, 33.75781], [-118.1303, 33.75771], [-118.13125, 33.75618], [-118.13149, 33.75596], [-118.13175, 33.7552], [-118.13179, 33.75507], [-118.1318, 33.7548], [-118.13162, 33.75434], [-118.13155, 33.75402], [-118.13074, 33.7533], [-118.13079, 33.75324], [-118.13095, 33.75332], [-118.13107, 33.7532], [-118.13126, 33.75329], [-118.13114, 33.75345], [-118.13128, 33.75352], [-118.13152, 33.75325], [-118.13174, 33.75337], [-118.1315, 33.75376], [-118.13193, 33.75398], [-118.13176, 33.75425], [-118.13211, 33.75514]]]]}	Open Access 1	6585	Bayshore Beach	29929	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	4.159	Bayshore Beach	0	Local Park 2	4
1124	1124	1123	{"type": "Polygon", "coordinates": [[[-118.17408, 33.83155], [-118.17408, 33.83229], [-118.1721, 33.83229], [-118.1721, 33.83155], [-118.17408, 33.83155]]]}	Open Access 1	6590	Somerset Park	25602	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	3.726	Somerset Park	0	Local Park 2	4
1125	1125	1124	{"type": "Polygon", "coordinates": [[[-118.19523, 33.85437], [-118.19505, 33.85468], [-118.19468, 33.85468], [-118.19486, 33.85437], [-118.19523, 33.85437]]]}	Open Access 1	6599	Burton W. Chace Park	28711	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	0.287	Burton W. Chace Park	0	Local Park 2	4
1126	1126	1125	{"type": "MultiPolygon", "coordinates": [[[[-118.19262, 33.86033], [-118.1925, 33.86059], [-118.19247, 33.86057], [-118.19244, 33.8605], [-118.1922, 33.86042], [-118.19216, 33.86047], [-118.19211, 33.86043], [-118.19206, 33.86043], [-118.19206, 33.86014], [-118.19229, 33.86016], [-118.19238, 33.86019], [-118.19262, 33.86033]]], [[[-118.19495, 33.86197], [-118.1949, 33.86207], [-118.19487, 33.86207], [-118.19485, 33.86197], [-118.1935, 33.86102], [-118.19314, 33.86081], [-118.19274, 33.86062], [-118.19263, 33.86064], [-118.19277, 33.86047], [-118.19278, 33.86047], [-118.19475, 33.86186], [-118.19494, 33.86194], [-118.19494, 33.86196], [-118.19495, 33.86197]]], [[[-118.19511, 33.86172], [-118.19507, 33.86179], [-118.195, 33.86182], [-118.19478, 33.86171], [-118.19288, 33.86037], [-118.19326, 33.86055], [-118.19364, 33.86077], [-118.195, 33.86172], [-118.19508, 33.86171], [-118.19511, 33.86172]]]]}	Open Access 1	6601	South Street Parkway	25680	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	1.42	South Street Parkway	0	Local Recreation Area 3	4
1127	1127	1126	{"type": "Polygon", "coordinates": [[[-118.15552, 33.87377], [-118.15359, 33.87378], [-118.15358, 33.87208], [-118.15446, 33.87208], [-118.15457, 33.87214], [-118.15466, 33.87229], [-118.15471, 33.87236], [-118.15487, 33.87246], [-118.15506, 33.8725], [-118.15552, 33.8725], [-118.15552, 33.87377]]]}	Open Access 1	6602	Ramona Park	24119	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	7.46	Ramona Park	0	Local Park 2	4
1134	1134	1133	{"type": "Polygon", "coordinates": [[[-118.22322, 33.79713], [-118.2227, 33.79832], [-118.22143, 33.79833], [-118.22142, 33.79884], [-118.21988, 33.79884], [-118.21988, 33.7972], [-118.22031, 33.7972], [-118.22032, 33.79714], [-118.22322, 33.79713]]]}	Open Access 1	6632	Hudson Park	20134	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	11.236	Hudson Park	0	Local Park 2	4
1135	1135	1134	{"type": "Polygon", "coordinates": [[[-118.16446, 33.76279], [-118.1643, 33.76333], [-118.15256, 33.76088], [-118.15255, 33.76085], [-118.15103, 33.76079], [-118.15064, 33.7607], [-118.15091, 33.75983], [-118.15284, 33.76035], [-118.15644, 33.76123], [-118.1582, 33.76158], [-118.15995, 33.76196], [-118.16349, 33.76263], [-118.16446, 33.76279]]]}	Open Access 1	6644	Bluff Park	16198	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	18.611	Bluff Park	0	Local Park 2	4
1136	1136	1135	{"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10633, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77647], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10787, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]}	Open Access 1	6659	Rancho Los Alamitos Historic Site	24152	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2		Los Angeles 6	7.405	Rancho Los Alamitos Historic Site	0	Local Historic or Cultural Area 19	4
2391	2391	2390	{"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]}	Open Access 1	45873	21st to Hill Mini Park	28944	1184	Long Beach, City of 298	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1184	Long Beach, City of 294	City 2	City Agency 2	http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470	Los Angeles 6	0.91	21st to Hill MP	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]);