units_with_maps

Table actions

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

22 rows where AGNCY_LEV = 2 and MNG_AGENCY = 290

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Hermosa Beach, City of · 22 ✖
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
955 955 954 {"type": "Polygon", "coordinates": [[[-118.38819, 33.85698], [-118.38808, 33.85702], [-118.38796, 33.85679], [-118.38808, 33.85675], [-118.38819, 33.85698]]]} Open Access 1 6103 Moondust Park 22451 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.081 Moondust Park 0 Local Park 2 4
4442 4442 4441 {"type": "Polygon", "coordinates": [[[-118.39438, 33.86006], [-118.39427, 33.86008], [-118.39421, 33.85979], [-118.39432, 33.85977], [-118.39438, 33.86006]]]} Open Access 1 46500 Eighth Street and Valley Drive Green Space 33371 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.086 Eighth Street and Valley Drive Green Space   None 396  
4443 4443 4442 {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38594, 33.85816], [-118.38594, 33.85816]]]} Open Access 1 46502 Third Street & Prospect Avenue Park 29786 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.012 Third Street & Prospect Avenue Park 0 Local Park 2 4
6320 6320 6319 {"type": "Polygon", "coordinates": [[[-118.40237, 33.86403], [-118.40186, 33.86413], [-118.40176, 33.86383], [-118.40163, 33.86384], [-118.40157, 33.86359], [-118.40218, 33.86348], [-118.40237, 33.86403]]]} Open Access 1 6113 Noble Park 22778 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.848 Noble Park 0 Local Park 2 4
6967 6967 6966 {"type": "Polygon", "coordinates": [[[-118.38992, 33.85746], [-118.38985, 33.85749], [-118.38978, 33.85725], [-118.38985, 33.85722], [-118.38992, 33.85746]]]} Open Access 1 6104 Ocean View Parkette 29776 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.051 Ocean View Parkette 0 Local Park 2 4
7008 7008 7007 {"type": "Polygon", "coordinates": [[[-118.38814, 33.85983], [-118.38758, 33.8599], [-118.38754, 33.85963], [-118.38812, 33.85955], [-118.38814, 33.85967], [-118.38814, 33.85983]]]} Open Access 1 6102 Fort Lots-o-Fun Park 19006 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.41 Fort Lots-o-Fun Park 0 Local Park 2 4
7067 7067 7066 {"type": "MultiPolygon", "coordinates": [[[[-118.39374, 33.85407], [-118.39363, 33.85402], [-118.39346, 33.85391], [-118.3936, 33.85387], [-118.39374, 33.85407]]], [[[-118.39448, 33.85549], [-118.39417, 33.85555], [-118.39408, 33.85529], [-118.39387, 33.85486], [-118.39328, 33.85395], [-118.39335, 33.85394], [-118.39338, 33.85394], [-118.39353, 33.85406], [-118.39367, 33.85413], [-118.39379, 33.85422], [-118.39392, 33.85436], [-118.39413, 33.85469], [-118.39434, 33.85508], [-118.39448, 33.85549]]], [[[-118.39453, 33.85565], [-118.39456, 33.85576], [-118.39461, 33.85604], [-118.39464, 33.85632], [-118.39463, 33.85675], [-118.39457, 33.85718], [-118.39443, 33.85769], [-118.39418, 33.85847], [-118.39408, 33.85904], [-118.39407, 33.85951], [-118.39417, 33.8601], [-118.39386, 33.86016], [-118.3938, 33.85992], [-118.39375, 33.85956], [-118.39374, 33.85913], [-118.39376, 33.85892], [-118.39385, 33.85843], [-118.39415, 33.85749], [-118.39423, 33.85718], [-118.39429, 33.85684], [-118.39431, 33.8566], [-118.3943, 33.85627], [-118.39428, 33.85609], [-118.39417, 33.85589], [-118.39404, 33.85575], [-118.3942, 33.8557], [-118.39453, 33.85565]]], [[[-118.39536, 33.86445], [-118.39504, 33.86451], [-118.39389, 33.86032], [-118.39421, 33.86026], [-118.39536, 33.86445]]], [[[-118.40176, 33.87623], [-118.40145, 33.87635], [-118.40139, 33.87605], [-118.40129, 33.87574], [-118.40112, 33.8754], [-118.4009, 33.87508], [-118.40072, 33.87486], [-118.40029, 33.87447], [-118.39989, 33.87415], [-118.39942, 33.87374], [-118.39899, 33.87331], [-118.39879, 33.87309], [-118.39837, 33.87256], [-118.39797, 33.87194], [-118.39776, 33.87156], [-118.39764, 33.8713], [-118.39609, 33.86793], [-118.39589, 33.8674], [-118.39571, 33.86687], [-118.39512, 33.86478], [-118.3954, 33.86473], [-118.39594, 33.86669], [-118.39617, 33.86737], [-118.39642, 33.868], [-118.39798, 33.87137], [-118.39825, 33.87186], [-118.39856, 33.87234], [-118.39882, 33.87268], [-118.399, 33.87291], [-118.3995, 33.87344], [-118.39994, 33.87385], [-118.40047, 33.87428], [-118.40052, 33.87427], [-118.40074, 33.87446], [-118.401, 33.87472], [-118.40112, 33.87486], [-118.40138, 33.87522], [-118.40155, 33.87554], [-118.4017, 33.87597], [-118.40176, 33.87623]]], [[[-118.40194, 33.8771], [-118.4016, 33.87711], [-118.40149, 33.8765], [-118.40178, 33.87638], [-118.40194, 33.8771]]]]} Open Access 1 6097 Hermosa Valley Greenbelt Park 19872 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 19.084 Hermosa Valley Greenbelt Park 0 Local Park 2 4
7068 7068 7067 {"type": "Polygon", "coordinates": [[[-118.39638, 33.85776], [-118.39602, 33.85783], [-118.39598, 33.8577], [-118.39474, 33.85792], [-118.39461, 33.85742], [-118.39467, 33.85718], [-118.39472, 33.8568], [-118.39603, 33.85656], [-118.39615, 33.85698], [-118.39618, 33.85699], [-118.39638, 33.85776]]]} Open Access 1 6098 South Park 25671 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 4.48 South Park 0 Local Park 2 4
7071 7071 7070 {"type": "Polygon", "coordinates": [[[-118.39692, 33.86182], [-118.39538, 33.86211], [-118.39546, 33.86244], [-118.39494, 33.86254], [-118.39468, 33.86158], [-118.39513, 33.8615], [-118.39504, 33.86115], [-118.39458, 33.86123], [-118.39451, 33.86096], [-118.39635, 33.86062], [-118.39665, 33.86175], [-118.3969, 33.86171], [-118.39692, 33.86182]]]} Open Access 1 6105 Clark Stadium and Building 29774 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 6.2 Clark Stadium and Building   None 578  
7072 7072 7071 {"type": "Polygon", "coordinates": [[[-118.39247, 33.86342], [-118.3922, 33.86326], [-118.39194, 33.86317], [-118.39179, 33.86314], [-118.39193, 33.86304], [-118.39206, 33.86292], [-118.39218, 33.86278], [-118.39224, 33.86266], [-118.39247, 33.86342]]]} Open Access 1 6107 Greenwood Park 19486 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.477 Greenwood Park 0 Local Park 2 4
7073 7073 7072 {"type": "Polygon", "coordinates": [[[-118.40324, 33.87754], [-118.40315, 33.87758], [-118.40301, 33.87736], [-118.40313, 33.87732], [-118.40324, 33.87754]]]} Open Access 1 6109 Shaffer Park 29777 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.073 Shaffer Park 0 Local Park 2 4
7074 7074 7073 {"type": "Polygon", "coordinates": [[[-118.4027, 33.87389], [-118.40098, 33.87456], [-118.40068, 33.8743], [-118.3998, 33.87356], [-118.39936, 33.87311], [-118.39916, 33.87289], [-118.39918, 33.87288], [-118.40182, 33.87287], [-118.40205, 33.87309], [-118.40239, 33.87335], [-118.4027, 33.87389]]]} Open Access 1 6110 Valley Park 26797 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 9.047 Valley Park 0 Local Park 2 4
7079 7079 7078 {"type": "Polygon", "coordinates": [[[-118.40772, 33.87286], [-118.40805, 33.87357], [-118.40912, 33.87571], [-118.40966, 33.87693], [-118.40916, 33.87712], [-118.40823, 33.87745], [-118.40805, 33.87708], [-118.40801, 33.87707], [-118.40813, 33.87703], [-118.40816, 33.8771], [-118.40822, 33.87711], [-118.40823, 33.87709], [-118.40822, 33.87708], [-118.40836, 33.87708], [-118.40837, 33.87706], [-118.40666, 33.87357], [-118.40626, 33.87284], [-118.40629, 33.87284], [-118.40629, 33.87283], [-118.40491, 33.87024], [-118.40366, 33.86737], [-118.40335, 33.86655], [-118.40196, 33.86259], [-118.40194, 33.86259], [-118.40145, 33.86122], [-118.40147, 33.86121], [-118.39993, 33.85693], [-118.39788, 33.85239], [-118.3992, 33.85195], [-118.39906, 33.85149], [-118.39933, 33.85141], [-118.3994, 33.85192], [-118.39969, 33.85292], [-118.40028, 33.85445], [-118.40058, 33.85514], [-118.4014, 33.85734], [-118.40174, 33.85811], [-118.4023, 33.85951], [-118.40309, 33.86178], [-118.40365, 33.86348], [-118.40422, 33.86503], [-118.40487, 33.86666], [-118.40569, 33.86859], [-118.40699, 33.87144], [-118.40772, 33.87286]]]} Open Access 1 6096 Hermosa City Beach 19869 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 91.811 Hermosa City Beach 0 Local Park 2 4
7080 7080 7079 {"type": "Polygon", "coordinates": [[[-118.38718, 33.85905], [-118.38653, 33.85914], [-118.38641, 33.85852], [-118.38712, 33.85872], [-118.38718, 33.85905]]]} Open Access 1 6101 Edith Rodaway Friendship Park 18449 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.806 Edith Rodaway Friendship Park 0 Local Park 2 4
15291 15291 15290 {"type": "Polygon", "coordinates": [[[-118.38722, 33.85852], [-118.3872, 33.85858], [-118.38658, 33.8584], [-118.3866, 33.85834], [-118.38722, 33.85852]]]} Open Access 1 46495 Fifth Street & Prospect Avenue Park 29780 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.102 Fifth Street & Prospect Avenue Park 0 Local Park 2 4
15314 15314 15313 {"type": "Polygon", "coordinates": [[[-118.39417, 33.8568], [-118.39413, 33.85701], [-118.3936, 33.85718], [-118.39348, 33.85693], [-118.39387, 33.8568], [-118.39391, 33.85688], [-118.39417, 33.8568]]]} Open Access 1 46494 Bi-Centennial Park 29778 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.395 Bi-Centennial Park 0 Local Park 2 4
15315 15315 15314 {"type": "Polygon", "coordinates": [[[-118.39163, 33.86965], [-118.39122, 33.86971], [-118.39117, 33.86944], [-118.39157, 33.86938], [-118.39163, 33.86965]]]} Open Access 1 46497 Seaview Parkette 29782 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.287 Seaview Parkette 0 Local Park 2 4
15316 15316 15315 {"type": "Polygon", "coordinates": [[[-118.3888, 33.86582], [-118.38873, 33.86578], [-118.38873, 33.86578], [-118.38878, 33.86576], [-118.3888, 33.86582]]]} Open Access 1 46498 Scout Park 29783 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.004 Scout Park 0 Local Park 2 4
15327 15327 15326 {"type": "Polygon", "coordinates": [[[-118.39424, 33.8571], [-118.39415, 33.8575], [-118.39414, 33.8575], [-118.39387, 33.85836], [-118.39388, 33.85822], [-118.39385, 33.85801], [-118.39379, 33.85777], [-118.39397, 33.85771], [-118.39411, 33.85726], [-118.39407, 33.85716], [-118.39424, 33.8571]]]} Open Access 1 46503 Ardmore Park 29787 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.354 Ardmore Park 0 Local Park 2 4
15328 15328 15327 {"type": "Polygon", "coordinates": [[[-118.39599, 33.85309], [-118.39592, 33.85328], [-118.39582, 33.85331], [-118.39579, 33.85324], [-118.39582, 33.85314], [-118.39599, 33.85309]]]} Open Access 1 46504 Kay Etow Parkette 29788 1134 Hermosa Beach, City of 294 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 1134 Hermosa Beach, City of 290 City 2 City Agency 2   Los Angeles 6 0.065 Kay Etow Parkette 0 Local Park 2 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]);