trees
3,247 rows where qSpecies_id = 22 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181409 | 129057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011354.55314 | 2117688.13829 | 37.7954075587569 | -122.404707776336 | (37.7954075587569, -122.404707776336) | 3 | 1 | 10 | 28857 | 4 | |
| 181157 | 33594 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 208 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37702 | 6006803.38226824 | 2097943.62645623 | 37.7409383755984 | -122.419054466757 | (37.7409383755984, -122.419054466757) | 2 | 7 | 7 | 28859 | 2 | |||
| 180985 | 83462 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 740 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50126 | 6009282.81123 | 2110260.47862 | 37.7748969762353 | -122.411351393861 | (37.7748969762353, -122.411351393861) | 8 | 2 | 9 | 28853 | 34 | |
| 180873 | 225762 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 576 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6003615.33246 | 2104928.33027 | 37.7599366919407 | -122.430575836132 | (37.7599366919407, -122.430575836132) | 2 | 4 | 5 | 28862 | 3 | |||
| 180837 | 219115 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 409 Bella Vista Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5997400.88581 | 2096335.81192 | 37.7359897405315 | -122.451448728489 | (37.7359897405315, -122.451448728489) | 9 | 7 | 4 | 59 | 40 | |||
| 180713 | 192437 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Langton St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6010237.3697 | 2110691.53515 | 37.7761340485805 | -122.408079765481 | (37.7761340485805, -122.408079765481) | 8 | 2 | 9 | 28853 | 34 | |||
| 180660 | 228234 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 690 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002369.34107 | 2104210.51812 | 37.7578950878951 | -122.434833777072 | (37.7578950878951, -122.434833777072) | 2 | 4 | 5 | 28862 | 3 | |||
| 180630 | 128986 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006340.65697 | 2110948.65096 | 37.7766210773467 | -122.421577830361 | (37.7766210773467, -122.421577830361) | 7 | 9 | 11 | 28852 | 10 | |||
| 180523 | 39581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011726.24536 | 2106360.66695 | 37.764325718987 | -122.402624687477 | (37.764325718987, -122.402624687477) | 8 | 3 | 8 | 28856 | 29 | |
| 180457 | 86906 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 133 College Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49871 | 6004619.8 | 2096005.1 | 37.7354924154795 | -122.426466496055 | (37.7354924154795, -122.426466496055) | 2 | 7 | 5 | 28861 | 2 | ||
| 180308 | 190396 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012031.32912 | 2100905.98791 | 37.7493653986954 | -122.401186158933 | (37.7493653986954, -122.401186158933) | 10 | 3 | 8 | 58 | 1 | |||
| 180276 | 190422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 18 | : | Tree | Private 2 | 5 | Width 3ft | 6017797.18223 | 2096994.03226 | 37.7389439406012 | -122.380975565973 | (37.7389439406012, -122.380975565973) | 10 | 3 | 8 | 58 | 1 | |||
| 180273 | 138045 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 17 WILMOT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003246.2591 | 2115012.2452 | 37.7876037198821 | -122.432572574253 | (37.7876037198821, -122.432572574253) | 13 | 9 | 11 | 29490 | 27 | |||
| 180271 | 31874 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35313 | 6015646.39129 | 2113195.50947 | 37.7833107698248 | -122.389543258739 | (37.7833107698248, -122.389543258739) | 6 | 2 | 9 | 28856 | 6 | ||
| 180142 | 219136 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 36 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001883.53233 | 2094797.82199 | 37.7320224460723 | -122.435840438579 | (37.7320224460723, -122.435840438579) | 9 | 7 | 4 | 63 | 40 | |||
| 180111 | 256895 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Congo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768867 | 6000183.68977 | 2096091.89275 | 37.7354789553486 | -122.441809987085 | (37.7354789553486, -122.441809987085) | 9 | 7 | 4 | 63 | 40 | |||
| 180019 | 225708 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3321 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006127.80711 | 2103145.57193 | 37.7551836652175 | -122.421759761421 | (37.7551836652175, -122.421759761421) | 2 | 4 | 5 | 28859 | 19 | |||
| 180015 | 49941 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2474@ ULLOA 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 1 | Permit Number 46699 | 5988007.7004 | 2098472.4797 | 37.7413141115718 | -122.484080972394 | (37.7413141115718, -122.484080972394) | 1 | 8 | 3 | 29491 | 35 | |
| 179987 | 228200 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 195 Eureka St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001449.0586 | 2104742.18651 | 37.7593026276384 | -122.438054577564 | (37.7593026276384, -122.438054577564) | 2 | 4 | 5 | 28862 | 3 | |||
| 179850 | 226147 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 104 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004701.74568 | 2103008.07558 | 37.7547256108238 | -122.426681712308 | (37.7547256108238, -122.426681712308) | 2 | 4 | 5 | 28862 | 22 | |||
| 179810 | 51605 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47902 | 5994151.59939184 | 2087413.0796794 | 37.7113034743583 | -122.462035873495 | (37.7113034743583, -122.462035873495) | 9 | 8 | 6 | 28861 | 24 | |||
| 179655 | 30914 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | 9 | 8 | 6 | 28861 | 24 | |||
| 179647 | 226160 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997815.89337 | 2106775.03182 | 37.7646770202555 | -122.450766337324 | (37.7646770202555, -122.450766337324) | 15 | 5 | 11 | 29492 | 9 | |||
| 179485 | 98802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | |
| 179459 | 226247 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3388 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005816.50215 | 2103176.18646 | 37.7552501655856 | -122.422838522483 | (37.7552501655856, -122.422838522483) | 2 | 4 | 5 | 28859 | 19 | |||
| 179431 | 192499 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1600 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012885.79895 | 2105214.3484 | 37.7612428519957 | -122.398533646311 | (37.7612428519957, -122.398533646311) | 10 | 3 | 8 | 28856 | 29 | |||
| 179401 | 190375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1200 De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012209.08291 | 2102692.77955 | 37.7542814554469 | -122.400696986193 | (37.7542814554469, -122.400696986193) | 10 | 3 | 8 | 28856 | 29 | |||
| 179319 | 109789 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 179268 | 226188 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 627 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008706.7555 | 2095910.98404 | 37.7354641830093 | -122.412329646702 | (37.7354641830093, -122.412329646702) | 10 | 7 | 7 | 28859 | 2 | |||
| 179242 | 225747 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003740.09444 | 2102804.53814 | 37.754112329828 | -122.429992845196 | (37.754112329828, -122.429992845196) | 2 | 4 | 5 | 28862 | 22 | |||
| 179197 | 128890 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997463.97068 | 2116280.29604 | 37.7907558451418 | -122.452669602227 | (37.7907558451418, -122.452669602227) | 11 | 6 | 1 | 54 | 31 | |||
| 179162 | 225667 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 325 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006845.73875 | 2097155.01084 | 37.7387753977721 | -122.418852096759 | (37.7387753977721, -122.418852096759) | 2 | 7 | 7 | 28859 | 2 | |||
| 179123 | 226289 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004526.65567 | 2096812.88976 | 37.7377051577776 | -122.426846041809 | (37.7377051577776, -122.426846041809) | 2 | 7 | 5 | 63 | 7 | |||
| 179010 | 19064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 178 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2014 12:54:00 PM | 6 | 3X3 | 5995196.63012 | 2087463.05702 | 37.7115008117791 | -122.45842762225 | (37.7115008117791, -122.45842762225) | 9 | 8 | 6 | 28861 | 24 | ||
| 178902 | 228249 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 453 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003334.62012 | 2103874.66228 | 37.7570276648125 | -122.431471462841 | (37.7570276648125, -122.431471462841) | 2 | 4 | 5 | 28862 | 3 | |||
| 178826 | 6457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1199 Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2012 12:00:00 AM | 3 | 3x3 | 6018005.95547 | 2096720.88256 | 37.7382054470215 | -122.380234739537 | (37.7382054470215, -122.380234739537) | 10 | 3 | 8 | 58 | 1 | ||
| 178729 | 26816 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001075.1559 | 2114260.1397 | 37.7854152717832 | -122.440030195581 | (37.7854152717832, -122.440030195581) | 15 | 6 | 1 | 29490 | 27 | |||
| 178535 | 225980 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006321.75049 | 2107973.89763 | 37.7684520513461 | -122.421431924342 | (37.7684520513461, -122.421431924342) | 8 | 4 | 7 | 28853 | 19 | |||
| 178504 | 116724 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180X PERALTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009777 | 2100122 | 37.7470867174475 | -122.408926407614 | (37.7470867174475, -122.408926407614) | 2 | 7 | 7 | 28859 | 2 | ||||
| 178408 | 63450 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 264 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1987 12:00:00 AM | Permit Number 24038 | 6001425.5560901 | 2104288.57469022 | 37.7580557831848 | -122.438103366584 | (37.7580557831848, -122.438103366584) | 2 | 4 | 5 | 28862 | 3 | ||
| 178406 | 44278 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 519 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51023 | 6000579.6276 | 2110777.62 | 37.7758249413896 | -122.441494580589 | (37.7758249413896, -122.441494580589) | 15 | 5 | 11 | 29492 | 16 | |
| 178345 | 190489 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015419.98604 | 2113488.70595 | 37.7841032649961 | -122.390347029604 | (37.7841032649961, -122.390347029604) | 6 | 2 | 9 | 28856 | 6 | |||
| 178254 | 49964 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1770X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46714 | 6004517.12801131 | 2114993.0452944 | 37.7876229893912 | -122.428174248262 | (37.7876229893912, -122.428174248262) | 13 | 9 | 11 | 28858 | 27 | |
| 178249 | 104101 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 178144 | 192469 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6014870.03943 | 2103923.77532 | 37.7578095596756 | -122.39158071238 | (37.7578095596756, -122.39158071238) | 10 | 3 | 8 | 28856 | 29 | |||
| 177985 | 110155 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008584.20475 | 2118266.76798 | 37.7968411050867 | -122.414334635748 | (37.7968411050867, -122.414334635748) | 5 | 1 | 10 | 308 | 21 | |
| 177946 | 33016 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
| 177880 | 190433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 32 | : | Tree | Private 2 | 3 | Width 3ft | 6017527.81682 | 2097194.77168 | 37.7394802593972 | -122.381920875742 | (37.7394802593972, -122.381920875742) | 10 | 3 | 8 | 58 | 1 | |||
| 177770 | 33011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
| 177768 | 139671 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 837 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000964.7714 | 2111640.049 | 37.7782148875912 | -122.440224133775 | (37.7782148875912, -122.440224133775) | 15 | 5 | 11 | 29490 | 41 | |||
| 177704 | 137908 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004761.6994 | 2115376.8766 | 37.7886907286838 | -122.427355432093 | (37.7886907286838, -122.427355432093) | 13 | 9 | 11 | 28858 | 27 | |||
| 177649 | 35469 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 430 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.7805889355944 | -122.418577996505 | (37.7805889355944, -122.418577996505) | 7 | 9 | 9 | 28852 | 36 | |||
| 177638 | 176540 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1340 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011857.96847 | 2088639.5018 | 37.7156745159485 | -122.400923922912 | (37.7156745159485, -122.400923922912) | 10 | 7 | 8 | 309 | 39 | |||
| 177604 | 94292 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 177570 | 138035 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Wilmot St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003034.7695 | 2114994.2932 | 37.7875424326343 | -122.433303002686 | (37.7875424326343, -122.433303002686) | 13 | 9 | 11 | 29490 | 27 | |||
| 177551 | 226070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2948 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009420.07022 | 2104543.52376 | 37.7592072329445 | -122.410472810166 | (37.7592072329445, -122.410472810166) | 2 | 4 | 7 | 28859 | 19 | |||
| 177392 | 219110 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 45 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993942.77446 | 2102207.53523 | 37.7519133858187 | -122.463830774294 | (37.7519133858187, -122.463830774294) | 1 | 8 | 4 | 29491 | 12 | |||
| 177355 | 50057 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 263 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46787 | 6001476.85926758 | 2104302.64300932 | 37.7580973289309 | -122.437926946281 | (37.7580973289309, -122.437926946281) | 2 | 4 | 5 | 28862 | 3 | ||
| 177338 | 30604 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 158 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34570 | 6007811.28392093 | 2109845.83214339 | 37.7736758128298 | -122.416412355511 | (37.7736758128298, -122.416412355511) | 8 | 2 | 9 | 28853 | 19 | ||
| 177317 | 225730 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001609.60492 | 2102308.42229 | 37.7526292272692 | -122.4373250619 | (37.7526292272692, -122.4373250619) | 2 | 4 | 5 | 28862 | 22 | |||
| 177192 | 5603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1126 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | 3 | 3x3 | 6005088.25831 | 2101777.30613 | 37.7513680486157 | -122.425257470357 | (37.7513680486157, -122.425257470357) | 2 | 4 | 5 | 28862 | 22 | ||
| 177145 | 98236 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1299X 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
| 177075 | 176535 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 561 Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010836.25177 | 2092120.05921 | 37.72517436679 | -122.404700345243 | (37.72517436679, -122.404700345243) | 10 | 3 | 7 | 309 | 28 | |||
| 177071 | 111815 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 292 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5993105.14930812 | 2113535.88816838 | 37.7829697365941 | -122.467551113949 | (37.7829697365941, -122.467551113949) | 11 | 6 | 2 | 54 | 11 | ||||
| 177060 | 116640 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
| 177036 | 129014 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6011826.76829 | 2120892.13124 | 37.8042313289751 | -122.403299326499 | (37.8042313289751, -122.403299326499) | 3 | 1 | 10 | 28860 | 6 | |||
| 176904 | 190611 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008250.0486 | 2110605.54207 | 37.7757864606069 | -122.41494837717 | (37.7757864606069, -122.41494837717) | 8 | 2 | 9 | 28853 | 34 | |
| 176885 | 120474 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988469.71157 | 2115060.56996 | 37.7868873618402 | -122.483699443255 | (37.7868873618402, -122.483699443255) | 11 | 6 | 1 | 55 | 33 | |||
| 176882 | 39403 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 176812 | 176528 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004578.32338 | 2090490.71188 | 37.7203487836515 | -122.426217428296 | (37.7203487836515, -122.426217428296) | 9 | 7 | 6 | 28861 | 5 | |||
| 176671 | 116017 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6002644.26893 | 2105609.7942 | 37.761752768149 | -122.433982982543 | (37.761752768149, -122.433982982543) | 15 | 4 | 5 | 28862 | 3 | ||
| 176491 | 64619 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3373 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25524 | 6005880.40542778 | 2103131.16346045 | 37.7551301483211 | -122.422614326457 | (37.7551301483211, -122.422614326457) | 2 | 4 | 5 | 28859 | 19 | ||
| 176485 | 6626 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.82562 | 2097781.51455 | 37.7410389949512 | -122.38523606192 | (37.7410389949512, -122.38523606192) | 10 | 3 | 8 | 58 | 1 | ||
| 176481 | 124621 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Euclid Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996108.02491 | 2113845.04242 | 37.7839915057802 | -122.457184839405 | (37.7839915057802, -122.457184839405) | 11 | 6 | 1 | 54 | 31 | |||
| 176232 | 190534 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014826.57924 | 2111683.78541 | 37.7791144279252 | -122.392273741653 | (37.7791144279252, -122.392273741653) | 6 | 2 | 9 | 28856 | 20 | |||
| 176185 | 187408 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Leland Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6010703.7606 | 2087207.6456 | 37.7116784782683 | -122.404812664008 | (37.7116784782683, -122.404812664008) | 9 | 7 | 8 | 309 | 39 | |||
| 176098 | 14416 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10X Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2000 12:00:00 AM | 8 | 3X3 | 5998974.44495 | 2113166.80204 | 37.7822934388942 | -122.447219282802 | (37.7822934388942, -122.447219282802) | 15 | 5 | 1 | 54 | 16 | ||
| 176070 | 225760 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 360 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003550.26823 | 2106184.38514 | 37.7633818310345 | -122.430890503488 | (37.7633818310345, -122.430890503488) | 15 | 4 | 5 | 28862 | 3 | |||
| 176034 | 226268 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 603 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6000055.17885 | 2101557.9802 | 37.7504802054938 | -122.442646644547 | (37.7504802054938, -122.442646644547) | 2 | 4 | 5 | 28862 | 22 | |||
| 175978 | 228344 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003262.92712 | 2097108.59296 | 37.7384455570072 | -122.4312364574 | (37.7384455570072, -122.4312364574) | 2 | 7 | 5 | 63 | 7 | |||
| 175973 | 247000 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 415 Valley St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6003159.75235 | 2099193.72668 | 37.7441650051229 | -122.431742019398 | (37.7441650051229, -122.431742019398) | 2 | 7 | 5 | 63 | 22 | |||
| 175945 | 192505 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012737.16506 | 2105623.97857 | 37.7623593243396 | -122.399076464519 | (37.7623593243396, -122.399076464519) | 10 | 3 | 8 | 28856 | 29 | |||
| 175927 | 108710 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011387.70807 | 2106529.33414 | 37.7647699346052 | -122.40380746864 | (37.7647699346052, -122.40380746864) | 8 | 3 | 8 | 28853 | 20 |
| 175876 | 226154 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 226 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004902.96468 | 2100201.88454 | 37.747031835159 | -122.425786113464 | (37.747031835159, -122.425786113464) | 2 | 7 | 5 | 63 | 22 | |||
| 175873 | 112198 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771994 | 6001873.5131 | 2116702.41623 | 37.7921665513862 | -122.437443074554 | (37.7921665513862, -122.437443074554) | 13 | 6 | 1 | 29490 | 27 | |
| 175866 | 19108 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1719X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6001455.73444 | 2092112.4954 | 37.7246248422313 | -122.437127233124 | (37.7246248422313, -122.437127233124) | 9 | 7 | 6 | 28861 | 25 | |||
| 175766 | 14581 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1157 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 5999382.22391 | 2108862.87518 | 37.7704992495005 | -122.445498975466 | (37.7704992495005, -122.445498975466) | 15 | 5 | 11 | 29492 | 9 | |||
| 175640 | 24374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 214 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2001 12:00:00 AM | 3 | 3X3 | 6005312.22082 | 2108489.88376 | 37.7698118541611 | -122.424960516937 | (37.7698118541611, -122.424960516937) | 8 | 4 | 5 | 28853 | 19 | ||
| 175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 | ||
| 175575 | 115255 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 345 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772821 | 5995728.7 | 2090517.8 | 37.7199189816113 | -122.456809453119 | (37.7199189816113, -122.456809453119) | 9 | 8 | 6 | 28861 | 24 | |||
| 175455 | 14549 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 825 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 5999198.91902 | 2109993.62318 | 37.7735935296919 | -122.446214376762 | (37.7735935296919, -122.446214376762) | 15 | 5 | 11 | 29492 | 16 | |||
| 175247 | 225718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 133 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004622.20971 | 2095992.90001 | 37.7354590532752 | -122.426457296372 | (37.7354590532752, -122.426457296372) | 2 | 7 | 5 | 28861 | 2 | |||
| 175216 | 40432 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 101 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1999 12:00:00 AM | Permit Number 41526 | 6007627.96125429 | 2098166.4451197 | 37.7415965860949 | -122.416219146331 | (37.7415965860949, -122.416219146331) | 2 | 7 | 7 | 28859 | 2 | ||
| 175065 | 88036 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2301X Lyon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51052 | 5999283.551 | 2116709.73148 | 37.7920390527161 | -122.446404876309 | (37.7920390527161, -122.446404876309) | 11 | 6 | 1 | 29490 | 30 | |
| 175024 | 129038 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013256.5667 | 2117739.00297 | 37.7956533434856 | -122.398130017998 | (37.7956533434856, -122.398130017998) | 3 | 1 | 10 | 28860 | 6 | |||
| 175012 | 225674 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 718 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008885.6038 | 2096893.34242 | 37.7381715605701 | -122.411780690648 | (37.7381715605701, -122.411780690648) | 10 | 7 | 7 | 28859 | 2 | |||
| 174909 | 228207 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001473.08391 | 2104293.2134 | 37.7580712228198 | -122.437939327652 | (37.7580712228198, -122.437939327652) | 2 | 4 | 5 | 28862 | 3 | |||
| 174857 | 53142 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1498@ KEITH Underwood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
| 174717 | 96088 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2120 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | 3 | Permit Number 767147 | 6004491.55029 | 2116740.24376 | 37.7924189083474 | -122.428387320643 | (37.7924189083474, -122.428387320643) | 13 | 9 | 1 | 28858 | 27 | ||
| 174694 | 219080 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1215 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5995445.55275 | 2107287.29251 | 37.7659475851396 | -122.459001757518 | (37.7659475851396, -122.459001757518) | 15 | 5 | 11 | 56 | 12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );