superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where MNG_AGENCY = 520
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3311 | 3311 | 3310 | {"type": "Polygon", "coordinates": [[[-121.30879, 37.81556], [-121.30822, 37.81573], [-121.30818, 37.81569], [-121.30813, 37.81565], [-121.30805, 37.81565], [-121.30799, 37.81566], [-121.30793, 37.81569], [-121.3079, 37.81574], [-121.30789, 37.8158], [-121.30791, 37.81585], [-121.30734, 37.81603], [-121.30732, 37.81593], [-121.30733, 37.81579], [-121.3074, 37.8156], [-121.30746, 37.81552], [-121.30758, 37.81541], [-121.30781, 37.8153], [-121.30796, 37.81526], [-121.30812, 37.81525], [-121.30836, 37.81529], [-121.30858, 37.81538], [-121.3087, 37.81547], [-121.30879, 37.81556]]]} | Open Access 1 | Crescent Park | 17794 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1.41 | Crescent Park | ||
6145 | 6145 | 6144 | {"type": "Polygon", "coordinates": [[[-121.28576, 37.81299], [-121.28485, 37.81299], [-121.28484, 37.81271], [-121.28485, 37.81246], [-121.28573, 37.81245], [-121.28576, 37.81299]]]} | Open Access 1 | Libby Park | 21204 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1.167 | Libby Park | ||
6983 | 6983 | 6982 | {"type": "Polygon", "coordinates": [[[-121.28289, 37.8229], [-121.2829, 37.82343], [-121.28288, 37.82346], [-121.28283, 37.82348], [-121.28224, 37.82348], [-121.28223, 37.82286], [-121.28282, 37.82286], [-121.28288, 37.82288], [-121.28289, 37.8229]]]} | Open Access 1 | Milestone Park | 22220 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 0.989 | Milestone Park | ||
7229 | 7229 | 7228 | {"type": "Polygon", "coordinates": [[[-121.3091, 37.80765], [-121.30911, 37.80775], [-121.30909, 37.80797], [-121.30895, 37.80814], [-121.30879, 37.80819], [-121.30868, 37.80821], [-121.3086, 37.8082], [-121.30844, 37.80816], [-121.30823, 37.80806], [-121.30817, 37.80795], [-121.30814, 37.80783], [-121.30816, 37.80769], [-121.30836, 37.80749], [-121.30858, 37.80743], [-121.30875, 37.80742], [-121.30903, 37.80757], [-121.3091, 37.80765]]]} | Open Access 1 | Mossdale Commons | 22512 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1.438 | Mossdale Commons | ||
7406 | 7406 | 7405 | {"type": "Polygon", "coordinates": [[[-121.31693, 37.81493], [-121.31608, 37.81531], [-121.31575, 37.81556], [-121.31497, 37.81624], [-121.31462, 37.8166], [-121.31447, 37.8167], [-121.31429, 37.81692], [-121.31407, 37.8175], [-121.31404, 37.81802], [-121.31398, 37.81814], [-121.31418, 37.81831], [-121.31354, 37.81883], [-121.31359, 37.81847], [-121.31385, 37.81753], [-121.31396, 37.81722], [-121.31409, 37.81697], [-121.31426, 37.81672], [-121.31449, 37.81646], [-121.31568, 37.81542], [-121.31585, 37.81523], [-121.31597, 37.81505], [-121.31607, 37.81486], [-121.31612, 37.81466], [-121.31614, 37.81444], [-121.31693, 37.81493]]]} | Open Access 1 | River Park North | 24422 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 3.212 | River Park North | ||
7955 | 7955 | 7954 | {"type": "Polygon", "coordinates": [[[-121.3127, 37.81648], [-121.31276, 37.81621], [-121.31257, 37.81614], [-121.31244, 37.81602], [-121.31184, 37.81476], [-121.31185, 37.8146], [-121.31152, 37.81452], [-121.31159, 37.81438], [-121.31169, 37.81427], [-121.31182, 37.81418], [-121.31198, 37.81411], [-121.31221, 37.81406], [-121.31238, 37.81407], [-121.3125, 37.81409], [-121.31273, 37.81418], [-121.31289, 37.81429], [-121.31301, 37.81447], [-121.31361, 37.81574], [-121.31363, 37.81587], [-121.31359, 37.81606], [-121.31349, 37.81622], [-121.31338, 37.81632], [-121.31325, 37.8164], [-121.3131, 37.81645], [-121.31294, 37.81648], [-121.3127, 37.81648]]]} | Open Access 1 | Park West | 23440 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 6.742 | Park West | ||
10007 | 10007 | 10006 | {"type": "Polygon", "coordinates": [[[-121.28206, 37.81478], [-121.28188, 37.81479], [-121.28152, 37.81473], [-121.28094, 37.81473], [-121.2807, 37.81471], [-121.28073, 37.81452], [-121.28072, 37.81413], [-121.28206, 37.81413], [-121.28207, 37.81422], [-121.28206, 37.81478]]]} | No Public Access 3 | Stormwater Basin | 25901 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1.998 | Stormwater Basin | ||
10310 | 10310 | 10309 | {"type": "Polygon", "coordinates": [[[-121.30538, 37.81017], [-121.3049, 37.8104], [-121.30435, 37.8098], [-121.30479, 37.80954], [-121.30538, 37.81017]]]} | Open Access 1 | The Green | 26281 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1.02 | The Green | ||
10647 | 10647 | 10646 | {"type": "Polygon", "coordinates": [[[-121.28105, 37.82109], [-121.2784, 37.82109], [-121.27841, 37.81998], [-121.27951, 37.81998], [-121.27952, 37.81938], [-121.28096, 37.81938], [-121.28105, 37.82109]]]} | Open Access 1 | Valverde Park | 26815 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 9.118 | Valverde Park | ||
11377 | 11377 | 11376 | {"type": "Polygon", "coordinates": [[[-121.2814, 37.82711], [-121.28042, 37.82713], [-121.28035, 37.82717], [-121.28021, 37.82736], [-121.27993, 37.82725], [-121.27981, 37.82734], [-121.27945, 37.82729], [-121.27851, 37.82729], [-121.2785, 37.82719], [-121.27836, 37.82719], [-121.27838, 37.82644], [-121.28137, 37.82643], [-121.2814, 37.82711]]]} | Open Access 1 | Woodfield Park | 27709 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 5.761 | Woodfield Park | ||
12335 | 12335 | 12334 | {"type": "Polygon", "coordinates": [[[-121.30121, 37.826], [-121.30039, 37.8261], [-121.29978, 37.82615], [-121.2988, 37.82617], [-121.29874, 37.82611], [-121.29874, 37.82524], [-121.29879, 37.82509], [-121.29878, 37.82501], [-121.29874, 37.82497], [-121.29934, 37.82496], [-121.29995, 37.82493], [-121.30093, 37.82482], [-121.30121, 37.826]]]} | Open Access 1 | Lathrop Generations Center | http://www.kla-ca.com/portfolio/lathrop-generations-center/ | 32370 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 6.76 | Lathrop Generations Ctr. | 2014 |
13544 | 13544 | 13543 | {"type": "Polygon", "coordinates": [[[-121.27616, 37.81964], [-121.27616, 37.81998], [-121.27581, 37.81998], [-121.27581, 37.81963], [-121.27616, 37.81964]]]} | Open Access 1 | Lathrop Skate Park | 30965 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 0.287 | Lathrop Skate Park |
Advanced export
JSON shape: default, array, newline-delimited
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]);