units_with_maps

Table actions

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

144 rows where LAYER = 2, MNG_AGENCY = 294 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 144 ✖

MNG_AGENCY 1

  • Long Beach, City of · 144 ✖
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
968 968 967 {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} Restricted Access 2 6607 Heartwell Golf Course 33019 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 36.514 Heartwell GC 0 Local Recreation Area 3 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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