superunits_with_maps

Table actions

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

21 rows where ACCESS_TYP = 1, MNG_AGENCY = 290 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 21 ✖

MNG_AGENCY 1

  • Hermosa Beach, City of · 21 ✖

ACCESS_TYP 1

  • Open Access · 21 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
3426 3426 3425 {"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 Fort Lots-o-Fun Park   19006 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.409 Fort Lots-o-Fun Park  
3863 3863 3862 {"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 Edith Rodaway Friendship Park   18449 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.805 Edith Rodaway Friendship Park  
4744 4744 4743 {"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 Greenwood Park   19486 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.477 Greenwood Park  
5075 5075 5074 {"type": "Polygon", "coordinates": [[[-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.8771], [-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.87282], [-118.40491, 33.87024], [-118.40366, 33.86737], [-118.40335, 33.86655], [-118.40197, 33.8626], [-118.40194, 33.86259], [-118.40145, 33.86122], [-118.40147, 33.8612], [-118.39993, 33.85693], [-118.39788, 33.85239], [-118.39919, 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], [-118.40805, 33.87357], [-118.40912, 33.87571], [-118.40966, 33.87693]]]} Open Access 1 Hermosa City Beach   19869 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 91.817 Hermosa City Beach  
5077 5077 5076 {"type": "MultiPolygon", "coordinates": [[[[-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.39374, 33.85407], [-118.39363, 33.85402], [-118.39346, 33.85391], [-118.3936, 33.85387], [-118.39374, 33.85407]]], [[[-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.4003, 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.87427], [-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 Hermosa Valley Greenbelt Park   19872 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 19.082 Hermosa Valley Greenbelt Park  
7180 7180 7179 {"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 Moondust Park   22451 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.081 Moondust Park  
7402 7402 7401 {"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 Noble Park   22778 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.849 Noble Park  
9809 9809 9808 {"type": "Polygon", "coordinates": [[[-118.39638, 33.85776], [-118.39602, 33.85783], [-118.39597, 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.85697], [-118.39618, 33.85699], [-118.39638, 33.85776]]]} Open Access 1 South Park   25671 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 4.481 South Park  
10568 10568 10567 {"type": "Polygon", "coordinates": [[[-118.4027, 33.87389], [-118.40098, 33.87456], [-118.40068, 33.8743], [-118.3998, 33.87356], [-118.39936, 33.87311], [-118.39917, 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 Valley Park   26797 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 9.047 Valley Park  
12530 12530 12529 {"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 Ocean View Parkette   29776 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.051 Ocean View Parkette  
12538 12538 12537 {"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 Shaffer Park   29777 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.073 Shaffer Park  
12549 12549 12548 {"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 Bi-Centennial Park   29778 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.395 Bi-Centennial Park  
12641 12641 12640 {"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 Fifth Street & Prospect Avenue Park   29780 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.102 Fifth Street & Prospect Avenue Park  
12651 12651 12650 {"type": "Polygon", "coordinates": [[[-118.39692, 33.86182], [-118.39539, 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 Clark Stadium and Building   29774 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 6.215 Clark Stadium and Building  
12652 12652 12651 {"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 Seaview Parkette   29782 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.287 Seaview Parkette  
12654 12654 12653 {"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 Scout Park   29783 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.004 Scout Park  
12655 12655 12654 {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38575, 33.85816], [-118.38594, 33.85816]]]} Open Access 1 Third Street & Prospect Avenue Park   29786 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.012 Third Street & Prospect Avenue Park  
12656 12656 12655 {"type": "Polygon", "coordinates": [[[-118.39424, 33.8571], [-118.39415, 33.8575], [-118.39387, 33.85836], [-118.39388, 33.85821], [-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 Ardmore Park   29787 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.367 Ardmore Park  
12657 12657 12656 {"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 Kay Etow Parkette   29788 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.065 Kay Etow Parkette  
13093 13093 13092 {"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 Eighth Street and Valley Drive Green Space   33371 1134 Hermosa Beach, City of 290 City 2 City Agency 2 http://www.hermosabch.org/index.aspx?page=115 City 2 0.086 Eighth Street and Valley Drive Green Space  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);