units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where DES_TP = 2 and MNG_AGENCY = 14 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 63
MNG_AGENCY 1
- Fresno, City of · 63 ✖
DES_TP 1
- Local Park · 63 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
452 | 452 | 451 | {"type": "Polygon", "coordinates": [[[-119.85339, 36.81645], [-119.85338, 36.81746], [-119.85112, 36.81746], [-119.85113, 36.81553], [-119.85196, 36.81553], [-119.85339, 36.81645]]]} | Open Access 1 | 1444 | Logan Park | 21400 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 9.082 | Logan Park | 0 | Local Park 2 | 4 | |
473 | 473 | 472 | {"type": "Polygon", "coordinates": [[[-119.7814, 36.78136], [-119.78138, 36.78318], [-119.77927, 36.78318], [-119.77929, 36.78137], [-119.7814, 36.78136]]]} | Open Access 1 | 1521 | Manchester Park | 21731 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 9.421 | Manchester Park | 0 | Local Park 2 | 4 | |
481 | 481 | 480 | {"type": "Polygon", "coordinates": [[[-119.68579, 36.78219], [-119.68225, 36.78221], [-119.68223, 36.77949], [-119.68575, 36.77947], [-119.68579, 36.78219]]]} | Open Access 1 | 1650 | Melody Park | 22111 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 23.499 | Melody Park | 0 | Local Park 2 | 4 | |
501 | 501 | 500 | {"type": "Polygon", "coordinates": [[[-119.82816, 36.75561], [-119.82654, 36.75563], [-119.82655, 36.75724], [-119.82652, 36.75731], [-119.82644, 36.75736], [-119.82178, 36.75742], [-119.81757, 36.7535], [-119.81589, 36.75199], [-119.81569, 36.75175], [-119.81557, 36.75157], [-119.81551, 36.75137], [-119.81553, 36.75121], [-119.81561, 36.75107], [-119.8158, 36.75094], [-119.8159, 36.75082], [-119.81596, 36.75072], [-119.816, 36.75057], [-119.81604, 36.7505], [-119.81612, 36.75045], [-119.81624, 36.75042], [-119.81624, 36.75039], [-119.82394, 36.75033], [-119.82395, 36.75035], [-119.82412, 36.75037], [-119.8243, 36.75041], [-119.82446, 36.75049], [-119.82463, 36.75061], [-119.82561, 36.75163], [-119.82719, 36.7537], [-119.82734, 36.75394], [-119.82816, 36.75561]]]} | Open Access 1 | 2033 | Roeding Park | 24557 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 144.652 | Roeding Park | 0 | Local Park 2 | 4 | |
513 | 513 | 512 | {"type": "Polygon", "coordinates": [[[-119.7453, 36.72622], [-119.7453, 36.72842], [-119.74397, 36.72843], [-119.74397, 36.72726], [-119.74285, 36.72727], [-119.74292, 36.7271], [-119.74286, 36.72663], [-119.7421, 36.72662], [-119.7421, 36.72625], [-119.7453, 36.72622]]]} | Open Access 1 | 1712 | Mosqueda Park | 22510 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 10.646 | Mosqueda Park | 0 | Local Park 2 | 4 | |
517 | 517 | 516 | {"type": "Polygon", "coordinates": [[[-119.77001, 36.80122], [-119.76779, 36.80122], [-119.76779, 36.79947], [-119.76789, 36.79945], [-119.76789, 36.79825], [-119.76891, 36.79825], [-119.76891, 36.79772], [-119.77, 36.79772], [-119.77001, 36.80122]]]} | Open Access 1 | 2141 | Rotary Park West | 24703 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.219 | Rotary Park West | 0 | Local Park 2 | 4 | |
524 | 524 | 523 | {"type": "Polygon", "coordinates": [[[-119.89185, 36.82504], [-119.89184, 36.82616], [-119.88975, 36.82617], [-119.88977, 36.82508], [-119.89185, 36.82504]]]} | Open Access 1 | 2261 | Stallion Park | 25780 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 5.628 | Stallion Park | 0 | Local Park 2 | 4 | |
526 | 526 | 525 | {"type": "Polygon", "coordinates": [[[-119.81988, 36.72408], [-119.81985, 36.72531], [-119.81777, 36.72532], [-119.8178, 36.7241], [-119.81988, 36.72408]]]} | Open Access 1 | 1766 | Neilson Park | 22690 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.258 | Neilson Park | 0 | Local Park 2 | 4 | |
530 | 530 | 529 | {"type": "Polygon", "coordinates": [[[-119.80634, 36.85317], [-119.80522, 36.8539], [-119.80515, 36.85384], [-119.80519, 36.85369], [-119.8057, 36.85332], [-119.80577, 36.85314], [-119.80578, 36.85299], [-119.80575, 36.85279], [-119.80586, 36.8528], [-119.80601, 36.85278], [-119.80606, 36.85298], [-119.80629, 36.85309], [-119.80634, 36.85317]]]} | Open Access 1 | 1748 | Spano Park | 25714 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.962 | Spano Park | 0 | Local Park 2 | 4 | |
538 | 538 | 537 | {"type": "Polygon", "coordinates": [[[-119.74277, 36.8014], [-119.74277, 36.80312], [-119.74078, 36.80312], [-119.74079, 36.8014], [-119.74277, 36.8014]]]} | Open Access 1 | 2652 | Vinland Park | 27143 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.364 | Vinland Park | 0 | Local Park 2 | 4 | |
542 | 542 | 541 | {"type": "Polygon", "coordinates": [[[-119.72964, 36.73869], [-119.72964, 36.73915], [-119.72751, 36.73913], [-119.72751, 36.7387], [-119.72964, 36.73869]]]} | Open Access 1 | 2756 | Willow-Balch Park | 27572 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.327 | Willow-Balch Park | 0 | Local Park 2 | 4 | |
635 | 635 | 634 | {"type": "Polygon", "coordinates": [[[-119.77627, 36.79171], [-119.77626, 36.7921], [-119.77622, 36.79217], [-119.77614, 36.79222], [-119.77607, 36.79223], [-119.77477, 36.79223], [-119.77479, 36.79156], [-119.7761, 36.79158], [-119.77621, 36.79162], [-119.77627, 36.79171]]]} | Open Access 1 | 2573 | University Park | 26686 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.376 | University Park | 0 | Local Park 2 | 4 | |
1393 | 1393 | 1392 | {"type": "Polygon", "coordinates": [[[-119.75015, 36.71483], [-119.75014, 36.7177], [-119.74792, 36.71771], [-119.74793, 36.71426], [-119.74995, 36.71425], [-119.74995, 36.71483], [-119.75015, 36.71483]]]} | Open Access 1 | 12202 | Calwa Park | 16743 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 18.484 | Calwa Park | 0 | Local Park 2 | 4 | |
3347 | 3347 | 3346 | {"type": "Polygon", "coordinates": [[[-119.78805, 36.73876], [-119.78766, 36.73903], [-119.78676, 36.73821], [-119.78714, 36.73794], [-119.78805, 36.73876]]]} | Open Access 1 | 24154 | Eaton Plaza | 18412 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.379 | Eaton Plaza | 0 | Local Park 2 | 4 | |
3519 | 3519 | 3518 | {"type": "Polygon", "coordinates": [[[-119.90601, 36.84991], [-119.90514, 36.85098], [-119.90334, 36.8516], [-119.89998, 36.85175], [-119.8968, 36.85271], [-119.8963, 36.85226], [-119.89313, 36.85186], [-119.89311, 36.85193], [-119.89311, 36.85227], [-119.89279, 36.85211], [-119.8925, 36.852], [-119.89239, 36.85197], [-119.89231, 36.85193], [-119.89166, 36.85179], [-119.89119, 36.85175], [-119.89085, 36.85175], [-119.89017, 36.85181], [-119.88985, 36.85188], [-119.88952, 36.85198], [-119.88916, 36.85211], [-119.88936, 36.85126], [-119.88934, 36.85125], [-119.88939, 36.851], [-119.89048, 36.85117], [-119.89102, 36.85119], [-119.89182, 36.85127], [-119.89197, 36.85126], [-119.89206, 36.8513], [-119.89216, 36.8513], [-119.89237, 36.85134], [-119.8925, 36.85132], [-119.89259, 36.85135], [-119.89281, 36.85138], [-119.893, 36.85138], [-119.8931, 36.85136], [-119.89311, 36.85138], [-119.89352, 36.85142], [-119.8942, 36.85139], [-119.89439, 36.85135], [-119.89457, 36.85124], [-119.89461, 36.85124], [-119.89479, 36.85133], [-119.89495, 36.85136], [-119.89599, 36.85117], [-119.89622, 36.8511], [-119.89647, 36.85107], [-119.89672, 36.851], [-119.8968, 36.85091], [-119.89685, 36.85089], [-119.89709, 36.85087], [-119.89718, 36.85083], [-119.89729, 36.85082], [-119.8974, 36.85077], [-119.89761, 36.85052], [-119.89793, 36.85047], [-119.89817, 36.85016], [-119.89815, 36.85013], [-119.89822, 36.85009], [-119.89888, 36.84987], [-119.89952, 36.84974], [-119.89995, 36.84962], [-119.90022, 36.84965], [-119.90068, 36.84957], [-119.90181, 36.84954], [-119.90254, 36.84948], [-119.90325, 36.84925], [-119.90334, 36.84931], [-119.90346, 36.84927], [-119.90349, 36.84934], [-119.90349, 36.8494], [-119.90346, 36.84947], [-119.90341, 36.84952], [-119.9029, 36.84981], [-119.90261, 36.84989], [-119.90094, 36.85005], [-119.90107, 36.85103], [-119.90151, 36.85099], [-119.90155, 36.85107], [-119.9025, 36.85122], [-119.90255, 36.85131], [-119.90264, 36.85128], [-119.90258, 36.85115], [-119.9016, 36.851], [-119.90159, 36.85098], [-119.90337, 36.85082], [-119.90449, 36.85024], [-119.90397, 36.84955], [-119.90351, 36.84925], [-119.90358, 36.84923], [-119.90444, 36.84977], [-119.90533, 36.84896], [-119.90567, 36.84919], [-119.90538, 36.8495], [-119.90601, 36.84991]]]} | Open Access 1 | 28049 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 49.154 | Riverbottom Park | 0 | Local Park 2 | 4 | |
3520 | 3520 | 3519 | {"type": "Polygon", "coordinates": [[[-119.90449, 36.85024], [-119.90337, 36.85082], [-119.90162, 36.85099], [-119.90163, 36.851], [-119.90259, 36.85115], [-119.90265, 36.85128], [-119.90254, 36.85131], [-119.9025, 36.85122], [-119.90154, 36.85107], [-119.9015, 36.85099], [-119.90107, 36.85103], [-119.90094, 36.85005], [-119.90261, 36.84989], [-119.9029, 36.84981], [-119.90342, 36.84952], [-119.90346, 36.84947], [-119.90349, 36.8494], [-119.90349, 36.84934], [-119.90346, 36.84927], [-119.90351, 36.84925], [-119.90397, 36.84955], [-119.90449, 36.85024]]]} | Open Access 1 | 28050 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.705 | Riverbottom Park | 0 | Local Park 2 | 4 | |
3574 | 3574 | 3573 | {"type": "Polygon", "coordinates": [[[-119.81233, 36.72147], [-119.81183, 36.72183], [-119.81139, 36.72146], [-119.81147, 36.72147], [-119.81233, 36.72147]]]} | Open Access 1 | 47305 | Pride Pocket Park | 31012 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.403 | Pride PP | 0 | Local Park 2 | 4 | |
3609 | 3609 | 3608 | {"type": "Polygon", "coordinates": [[[-119.70709, 36.71049], [-119.70709, 36.71064], [-119.70641, 36.71063], [-119.70641, 36.71049], [-119.70643, 36.71047], [-119.70707, 36.71047], [-119.70709, 36.71049]]]} | Open Access 1 | 47306 | Rabe Pocket Park | 31013 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.268 | Rabe PP | 0 | Local Park 2 | 4 | |
3613 | 3613 | 3612 | {"type": "Polygon", "coordinates": [[[-119.74954, 36.87775], [-119.74952, 36.87906], [-119.74763, 36.87907], [-119.74752, 36.87875], [-119.7474, 36.87848], [-119.74723, 36.87819], [-119.74707, 36.87796], [-119.7471, 36.87785], [-119.74718, 36.87783], [-119.74738, 36.87779], [-119.74766, 36.87779], [-119.74779, 36.87776], [-119.74954, 36.87775]]]} | Open Access 1 | 47310 | Beamer Neighborhood Park | 31017 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.928 | Beamer Neighborhood Park | 0 | Local Park 2 | 4 | |
3614 | 3614 | 3613 | {"type": "Polygon", "coordinates": [[[-119.69873, 36.71265], [-119.69869, 36.71268], [-119.69834, 36.7127], [-119.69828, 36.71268], [-119.6982, 36.71257], [-119.6981, 36.71246], [-119.69839, 36.71238], [-119.69873, 36.71238], [-119.69873, 36.71265]]]} | Open Access 1 | 47311 | Centex Pocket Park | 31018 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.393 | Centex PP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);