superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where MNG_AGENCY = 136 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
391 | 391 | 390 | {"type": "Polygon", "coordinates": [[[-119.00968, 36.05491], [-119.00859, 36.0549], [-119.00862, 36.05417], [-119.00899, 36.05419], [-119.00901, 36.05393], [-119.00968, 36.05396], [-119.00968, 36.05491]]]} | Open Access 1 | Fallen Heroes Park | http://www.ci.porterville.ca.us/depts/ParksandLeisure/Namethepark.cfm | 31994 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 2.312 | Fallen Heroes Park | |
422 | 422 | 421 | {"type": "MultiPolygon", "coordinates": [[[[-119.00403, 36.06926], [-118.99973, 36.06922], [-118.99968, 36.06574], [-119.00178, 36.06578], [-119.00179, 36.06635], [-119.00161, 36.06636], [-119.00162, 36.06677], [-119.0023, 36.0668], [-119.00218, 36.06695], [-119.00202, 36.06711], [-119.00186, 36.06721], [-119.00167, 36.06724], [-119.00162, 36.0673], [-119.0016, 36.06738], [-119.0017, 36.06765], [-119.0017, 36.06779], [-119.00168, 36.06791], [-119.00164, 36.06802], [-119.00183, 36.06829], [-119.0019, 36.06829], [-119.00191, 36.06827], [-119.00175, 36.06801], [-119.00178, 36.06793], [-119.0018, 36.0678], [-119.0018, 36.06764], [-119.0017, 36.06737], [-119.00171, 36.06733], [-119.0019, 36.06728], [-119.00209, 36.06717], [-119.00226, 36.067], [-119.00238, 36.06686], [-119.00258, 36.06648], [-119.00291, 36.06609], [-119.00338, 36.06573], [-119.00397, 36.06574], [-119.00403, 36.06926]]], [[[-119.00314, 36.0658], [-119.00283, 36.06604], [-119.00279, 36.0661], [-119.00289, 36.0658], [-119.00314, 36.0658]]]]} | Open Access 1 | Murray Park | 32017 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 33.878 | Murray Park | ||
2373 | 2373 | 2372 | {"type": "Polygon", "coordinates": [[[-119.06923, 36.07235], [-119.06918, 36.07236], [-119.06918, 36.07248], [-119.06778, 36.07246], [-119.06781, 36.07093], [-119.06922, 36.07094], [-119.06923, 36.07235]]]} | Open Access 1 | Burton Ballfields | 16529 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 5.409 | Burton Ballfields | ||
4979 | 4979 | 4978 | {"type": "Polygon", "coordinates": [[[-119.03889, 36.08375], [-119.03865, 36.08375], [-119.03851, 36.08388], [-119.03732, 36.08389], [-119.03726, 36.0822], [-119.03872, 36.0822], [-119.03875, 36.08265], [-119.03886, 36.08328], [-119.03889, 36.08375]]]} | Open Access 1 | Hayes Field | 19755 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 6.218 | Hayes Field | ||
6264 | 6264 | 6263 | {"type": "Polygon", "coordinates": [[[-119.02126, 36.06141], [-119.02126, 36.06169], [-119.02088, 36.06168], [-119.02089, 36.0614], [-119.02126, 36.06141]]]} | Open Access 1 | Lions Mini Park | 21315 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 0.26 | Lions MP | ||
7079 | 7079 | 7078 | {"type": "Polygon", "coordinates": [[[-119.07983, 36.03277], [-119.07974, 36.03669], [-119.07376, 36.03671], [-119.07091, 36.03428], [-119.07092, 36.03038], [-119.07471, 36.03037], [-119.07473, 36.03281], [-119.07983, 36.03277]]]} | Open Access 1 | Porterville Sports Complex and OHV Park | 23904 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 99.998 | Porterville Sports Complex and OHV Park | ||
7657 | 7657 | 7656 | {"type": "Polygon", "coordinates": [[[-119.01837, 36.08107], [-119.01831, 36.08148], [-119.01806, 36.08153], [-119.01797, 36.08153], [-119.01791, 36.0815], [-119.01788, 36.08107], [-119.01837, 36.08107]]]} | Open Access 1 | Olivewood Mini Park | 23137 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 0.478 | Olivewood MP | ||
8172 | 8172 | 8171 | {"type": "Polygon", "coordinates": [[[-119.01425, 36.0474], [-119.01298, 36.04739], [-119.01299, 36.04636], [-119.01422, 36.04637], [-119.01425, 36.0474]]]} | Open Access 1 | Pioneer Ballfields | 23710 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 3.164 | Pioneer Ballfields | ||
8464 | 8464 | 8463 | {"type": "MultiPolygon", "coordinates": [[[[-119.01269, 36.0652], [-119.0126, 36.06942], [-119.01245, 36.06942], [-119.01247, 36.06815], [-119.01237, 36.06726], [-119.01238, 36.06713], [-119.01235, 36.067], [-119.01224, 36.06693], [-119.01215, 36.06586], [-119.01215, 36.06531], [-119.01211, 36.06518], [-119.01257, 36.06518], [-119.01269, 36.0652]]], [[[-119.01304, 36.07664], [-119.013, 36.07892], [-119.01274, 36.07894], [-119.01275, 36.07919], [-119.013, 36.07919], [-119.01299, 36.08002], [-119.01262, 36.08001], [-119.01264, 36.07834], [-119.01225, 36.07832], [-119.01228, 36.07665], [-119.01219, 36.07663], [-119.01225, 36.07313], [-119.01241, 36.07313], [-119.01242, 36.07306], [-119.01275, 36.07307], [-119.01275, 36.07316], [-119.01254, 36.07318], [-119.01248, 36.07648], [-119.01238, 36.07649], [-119.01238, 36.07662], [-119.01304, 36.07664]]], [[[-119.01259, 36.07219], [-119.01257, 36.07295], [-119.01226, 36.07296], [-119.01227, 36.07219], [-119.01259, 36.07219]]], [[[-119.01261, 36.06949], [-119.01258, 36.07143], [-119.01255, 36.07208], [-119.01249, 36.07211], [-119.01227, 36.07211], [-119.01231, 36.06949], [-119.01261, 36.06949]]]]} | Open Access 1 | Rails to Trails | 24079 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 12.924 | Rails to Trails | ||
10496 | 10496 | 10495 | {"type": "MultiPolygon", "coordinates": [[[[-119.02608, 36.0563], [-119.02593, 36.05628], [-119.02515, 36.05627], [-119.02459, 36.0563], [-119.02371, 36.0565], [-119.02346, 36.05645], [-119.0228, 36.0563], [-119.02236, 36.0563], [-119.02198, 36.05627], [-119.02167, 36.0563], [-119.02138, 36.05637], [-119.02124, 36.05637], [-119.02108, 36.05635], [-119.02033, 36.05636], [-119.0198, 36.05635], [-119.01867, 36.05627], [-119.01799, 36.05625], [-119.01758, 36.05618], [-119.0172, 36.05609], [-119.01712, 36.05605], [-119.01693, 36.05606], [-119.01676, 36.0561], [-119.01677, 36.05589], [-119.01782, 36.0558], [-119.0195, 36.05579], [-119.02035, 36.05581], [-119.02096, 36.05587], [-119.02169, 36.05601], [-119.02189, 36.05603], [-119.02237, 36.05603], [-119.02295, 36.0561], [-119.0233, 36.05607], [-119.02382, 36.05612], [-119.02407, 36.05612], [-119.02497, 36.0561], [-119.02608, 36.05611], [-119.02608, 36.0563]]], [[[-119.03915, 36.06018], [-119.03825, 36.06018], [-119.0372, 36.05999], [-119.03628, 36.0598], [-119.03537, 36.05955], [-119.03473, 36.05934], [-119.0337, 36.05905], [-119.03113, 36.05818], [-119.02997, 36.05784], [-119.02982, 36.05775], [-119.02934, 36.05752], [-119.02855, 36.05703], [-119.02854, 36.05691], [-119.02849, 36.0568], [-119.02828, 36.05675], [-119.02752, 36.05662], [-119.02711, 36.05649], [-119.02663, 36.05637], [-119.02625, 36.05634], [-119.02625, 36.05617], [-119.02863, 36.05615], [-119.02872, 36.05594], [-119.03105, 36.05597], [-119.03129, 36.05628], [-119.03145, 36.05653], [-119.0318, 36.05713], [-119.03199, 36.0575], [-119.03202, 36.05761], [-119.03204, 36.05777], [-119.03213, 36.05792], [-119.03228, 36.05806], [-119.03259, 36.05818], [-119.03278, 36.05823], [-119.03301, 36.05832], [-119.0333, 36.05833], [-119.03344, 36.05835], [-119.03368, 36.05846], [-119.03433, 36.05867], [-119.03466, 36.05875], [-119.03484, 36.05874], [-119.03509, 36.0587], [-119.03521, 36.05873], [-119.03533, 36.05885], [-119.03549, 36.05895], [-119.0358, 36.05908], [-119.03687, 36.05937], [-119.0371, 36.05948], [-119.0379, 36.05979], [-119.03803, 36.05981], [-119.03816, 36.05977], [-119.03841, 36.05973], [-119.03892, 36.05972], [-119.03899, 36.0574], [-119.03896, 36.05687], [-119.03886, 36.05624], [-119.03859, 36.05431], [-119.0385, 36.05415], [-119.0384, 36.0541], [-119.03829, 36.05399], [-119.03823, 36.05384], [-119.03795, 36.05389], [-119.03772, 36.0539], [-119.03757, 36.05389], [-119.03759, 36.05323], [-119.03738, 36.05306], [-119.03737, 36.05304], [-119.03667, 36.0525], [-119.03547, 36.05204], [-119.03537, 36.05203], [-119.03537, 36.05188], [-119.03579, 36.0519], [-119.03654, 36.05197], [-119.0371, 36.0522], [-119.03767, 36.05273], [-119.03849, 36.05369], [-119.03891, 36.05472], [-119.03905, 36.05606], [-119.03918, 36.05806], [-119.03912, 36.05971], [-119.03915, 36.05972], [-119.03915, 36.06018]]]]} | Open Access 1 | Tule River Parkway | 26572 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 41.29 | Tule River Parkway | ||
10799 | 10799 | 10798 | {"type": "Polygon", "coordinates": [[[-119.05276, 36.07331], [-119.05268, 36.07539], [-119.05273, 36.08022], [-119.04966, 36.08022], [-119.04964, 36.07848], [-119.04994, 36.07838], [-119.05083, 36.07873], [-119.05212, 36.07902], [-119.05214, 36.07901], [-119.05212, 36.07443], [-119.0511, 36.07363], [-119.0506, 36.07361], [-119.05005, 36.07371], [-119.04814, 36.0737], [-119.04736, 36.07391], [-119.04723, 36.07391], [-119.04484, 36.07375], [-119.04433, 36.07501], [-119.04414, 36.07515], [-119.04407, 36.07393], [-119.04402, 36.07363], [-119.04411, 36.0734], [-119.05276, 36.07331]]]} | Open Access 1 | Veteran's Memorial Park | 27012 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 29.248 | Veteran's Memorial Park | ||
11498 | 11498 | 11497 | {"type": "Polygon", "coordinates": [[[-119.02223, 36.0768], [-119.02221, 36.07837], [-119.02222, 36.07915], [-119.02219, 36.07954], [-119.02219, 36.08023], [-119.02126, 36.08021], [-119.02101, 36.07981], [-119.02063, 36.07909], [-119.02029, 36.07837], [-119.01969, 36.07682], [-119.0201, 36.0768], [-119.02223, 36.0768]]]} | Open Access 1 | Zalud Park | 27851 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 15.304 | Zalud Park | ||
14575 | 14575 | 14574 | {"type": "MultiPolygon", "coordinates": [[[[-119.00412, 36.06444], [-119.00206, 36.06442], [-119.00204, 36.06457], [-119.00206, 36.06564], [-119.00083, 36.06562], [-119.00081, 36.06569], [-118.99981, 36.06569], [-118.99979, 36.0629], [-119.00339, 36.06294], [-119.00388, 36.06365], [-119.00412, 36.06444]]], [[[-119.00453, 36.06712], [-119.00453, 36.06755], [-119.00411, 36.06755], [-119.0041, 36.06711], [-119.00453, 36.06712]]], [[[-119.0045, 36.06776], [-119.0045, 36.06847], [-119.00412, 36.06847], [-119.00412, 36.06776], [-119.0045, 36.06776]]]]} | Restricted Access 2 | Murry Park and Porterville Municipal Golf Course | 32995 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 22.941 | Murry Park and Porterville Municipal GC |
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]);