trees
420 rows where qSpecies_id = 116 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1282 | 65048 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1994 12:00:00 AM | Permit Number 27001 | 6008641.92550277 | 2097033.56507471 | 37.7385429081789 | -122.412633121744 | (37.7385429081789, -122.412633121744) | 10 | 7 | 7 | 28859 | 2 | ||
| 2544 | 49162 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
| 5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 7183 | 42736 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 8465 | 70057 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1799 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6014037.25831 | 2095146.84971 | 37.7336637097057 | -122.393846481427 | (37.7336637097057, -122.393846481427) | 10 | 3 | 8 | 58 | 1 | |||
| 8894 | 63236 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 3634 20th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | 2 | 4 | 5 | 28859 | 19 | |
| 10106 | 49071 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 11289 | 34055 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 12705 | 66435 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 154 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2016 12:00:00 AM | 3 | Permit Number 776442 | 6005832.64379623 | 2096619.46427693 | 37.7372478105316 | -122.422316867971 | (37.7372478105316, -122.422316867971) | 2 | 7 | 7 | 28859 | 2 | |
| 13617 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | 9 | 3 | 7 | 309 | 28 | |||
| 13922 | 34080 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 17192 | 72214 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1799 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6014033.56934 | 2095149.8862 | 37.7336718422767 | -122.393859447849 | (37.7336718422767, -122.393859447849) | 10 | 3 | 8 | 58 | 1 | |||
| 20538 | 42308 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | ||
| 21711 | 35380 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 528 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/14/2015 12:00:00 AM | 4 | Permit Number 775347 | 6011191.99901 | 2105854.03053 | 37.7629047676749 | -122.404436841188 | (37.7629047676749, -122.404436841188) | 8 | 3 | 8 | 28856 | 29 | |
| 28105 | 63543 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1715 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33376 | 6001376.18344652 | 2111778.57795299 | 37.7786186676026 | -122.438810841545 | (37.7786186676026, -122.438810841545) | 15 | 5 | 11 | 29490 | 41 | ||
| 34216 | 34084 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 40188 | 64622 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 350 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25527 | 6006698.09280064 | 2104074.24597744 | 37.7577657327882 | -122.419853436478 | (37.7577657327882, -122.419853436478) | 2 | 4 | 7 | 28859 | 19 | ||
| 45490 | 34052 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 45906 | 34053 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 50033 | 49161 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
| 60510 | 34081 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 |
| 61309 | 67821 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 669 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1993 12:00:00 AM | Permit Number 31477 | 6014155.20534869 | 2104021.00071857 | 37.7580368157249 | -122.394059730987 | (37.7580368157249, -122.394059730987) | 10 | 3 | 8 | 28856 | 29 | ||
| 63135 | 179969 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 623 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781359 | 6010613.39722 | 2091824.02196 | 37.7243490517445 | -122.405449895106 | (37.7243490517445, -122.405449895106) | 10 | 3 | 7 | 309 | 28 |
| 64915 | 34083 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 66523 | 49072 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 68761 | 40438 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 400 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/1999 12:00:00 AM | Permit Number 41530 | 6007160.84774193 | 2097270.742449 | 37.7391109088923 | -122.417770796303 | (37.7391109088923, -122.417770796303) | 2 | 7 | 7 | 28859 | 2 | ||
| 72268 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 74715 | 68587 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 32485 | 6003450.61209517 | 2097770.88653532 | 37.7402746975659 | -122.430634780555 | (37.7402746975659, -122.430634780555) | 2 | 7 | 5 | 63 | 7 | ||
| 77367 | 49070 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 78460 | 67800 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31444 | 6001831.31402978 | 2100620.67337741 | 37.7480076719463 | -122.436437569325 | (37.7480076719463, -122.436437569325) | 2 | 4 | 5 | 28862 | 22 | ||
| 81340 | 41897 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2500 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42262 | 6001987.05760353 | 2105790.14936536 | 37.762210660505 | -122.436268917311 | (37.762210660505, -122.436268917311) | 15 | 4 | 5 | 28862 | 3 | ||
| 82601 | 63573 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1500@Polk Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 6 | Permit Number 49344 | 6006306.38676 | 2118003.57118 | 37.7959902160323 | -122.422197721351 | (37.7959902160323, -122.422197721351) | 13 | 9 | 10 | 28858 | 32 | |
| 88237 | 67807 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | 2 | 4 | 5 | 28862 | 22 | ||
| 89349 | 49073 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 94691 | 69068 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33076 | 5991768.06854816 | 2105844.04694914 | 37.7617727319168 | -122.471616117782 | (37.7617727319168, -122.471616117782) | 1 | 8 | 4 | 56 | 12 | ||
| 96948 | 37726 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40090 | 6010246.00158069 | 2101670.73784629 | 37.7513654710612 | -122.407413798897 | (37.7513654710612, -122.407413798897) | 2 | 4 | 7 | 28859 | 19 | ||
| 97236 | 47561 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
| 97320 | 34082 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 102201 | 40735 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 84 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41714 | 6009129.35799057 | 2096983.96477733 | 37.7384340613324 | -122.410944305546 | (37.7384340613324, -122.410944305546) | 10 | 7 | 7 | 28859 | 2 | ||
| 102795 | 34050 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 103389 | 36792 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Donner Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015166.6448 | 2090882.8824 | 37.7220184063671 | -122.389644123655 | (37.7220184063671, -122.389644123655) | 10 | 3 | 8 | 58 | 1 |
| 108310 | 63197 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 472 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 14 | Permit Number 23738 | 5984415.83341 | 2112620.01213 | 37.7799494956437 | -122.497544458973 | (37.7799494956437, -122.497544458973) | 11 | 6 | 2 | 55 | 26 | |
| 109210 | 34079 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 110955 | 49074 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 110970 | 65602 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.91359 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | 9 | 7 | 6 | 28861 | 5 | |
| 112826 | 42735 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 114997 | 49998 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1101X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014225.48172 | 2105233.17299 | 37.7613690835438 | -122.393901534339 | (37.7613690835438, -122.393901534339) | 10 | 3 | 8 | 28856 | 29 |
| 118808 | 42738 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 123424 | 67713 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 557 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | Permit Number 31325 | 6014732.24235944 | 2112894.33120186 | 37.7824330740175 | -122.392684800601 | (37.7824330740175, -122.392684800601) | 6 | 2 | 9 | 28856 | 6 | ||
| 129962 | 34076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 130983 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 135898 | 34049 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 136184 | 43754 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 367 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 14 | Permit Number 43390 | 5991197.85001 | 2112958.02747 | 37.781272787853 | -122.474107339564 | (37.781272787853, -122.474107339564) | 11 | 6 | 2 | 54 | 26 | |
| 136772 | 34047 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 137854 | 42733 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 143055 | 49075 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 147492 | 254374 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 343 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781359 | 6010747.56272 | 2091896.11912 | 37.7245545163839 | -122.404991175416 | (37.7245545163839, -122.404991175416) | 10 | 3 | 7 | 309 | 28 |
| 147565 | 47560 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
| 149786 | 34054 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 152907 | 50801 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | 9 | 7 | 4 | 28861 | 40 | ||
| 153581 | 49076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 155074 | 42737 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 159508 | 42739 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 160298 | 34051 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 163325 | 34077 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 173273 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6007547 | 2093670 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | 9 | 3 | 7 | 309 | 28 | |||||
| 175473 | 48927 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46117 | 6009515.72884218 | 2101239.2044667 | 37.7501396750607 | -122.409908717805 | (37.7501396750607, -122.409908717805) | 2 | 4 | 7 | 28859 | 19 | ||
| 176061 | 34654 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2000 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38332 | 5988619.0903 | 2105142.8889 | 37.7596648557466 | -122.482455667505 | (37.7596648557466, -122.482455667505) | 1 | 8 | 3 | 56 | 35 | |
| 176157 | 63531 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 645 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24143 | 6007924.14567941 | 2104175.72058203 | 37.7581133535123 | -122.415620410353 | (37.7581133535123, -122.415620410353) | 2 | 4 | 7 | 28859 | 19 | ||
| 181143 | 82360 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 415-421 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) | 8 | 4 | 7 | 28853 | 19 |
| 181206 | 34048 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 183562 | 34085 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 189294 | 69181 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1335 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 12 | Permit Number 33220 | 5982114.4178 | 2105957.0803 | 37.7615198518733 | -122.505012044902 | (37.7615198518733, -122.505012044902) | 1 | 8 | 3 | 56 | 35 | |
| 189828 | 38219 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 118 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2000 12:00:00 AM | Permit Number 40340 | 6000363.19569215 | 2109305.86913973 | 37.7717715527779 | -122.44213760158 | (37.7717715527779, -122.44213760158) | 15 | 5 | 11 | 29492 | 9 | ||
| 190621 | 63542 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | Permit Number 24157 | 6008220.8181992 | 2104530.13411616 | 37.7591031640479 | -122.414619465951 | (37.7591031640479, -122.414619465951) | 2 | 4 | 7 | 28859 | 19 | ||
| 190785 | 80165 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 415-421 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) | 8 | 4 | 7 | 28853 | 19 |
| 524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
| 1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
| 2455 | 215422 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993781.00975 | 2092831.61045 | 37.7261601145848 | -122.46370973814 | (37.7261601145848, -122.46370973814) | 9 | 8 | 4 | 59 | 40 | |||
| 2655 | 197996 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014434.42252 | 2089286.69966 | 37.7175949749992 | -122.392063685205 | (37.7175949749992, -122.392063685205) | 10 | 3 | 8 | 58 | 1 | |||
| 3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
| 3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 4227 | 109316 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 1516 BROADWAY | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006331.3 | 2118082.2 | 37.7962075161748 | -122.422117105361 | (37.7962075161748, -122.422117105361) | 13 | 9 | 10 | 28858 | 32 | ||||
| 4646 | 215421 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2085 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993516.19097 | 2101401.96684 | 37.7496769094628 | -122.465247440321 | (37.7496769094628, -122.465247440321) | 1 | 8 | 4 | 29491 | 40 | |||
| 6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 7744 | 225194 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778605 | 6007219.63733 | 2103836.19178 | 37.7571414587344 | -122.418032839538 | (37.7571414587344, -122.418032839538) | 2 | 4 | 7 | 28859 | 19 | ||
| 8935 | 136742 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000053.33945 | 2118542.13589 | 37.7971142876507 | -122.443873120143 | (37.7971142876507, -122.443873120143) | 13 | 9 | 1 | 57 | 17 | |||
| 9271 | 225190 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 10207 | 258475 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2033 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989468 | 2106464 | 37.7633416172482 | -122.479616407921 | (37.7633416172482, -122.479616407921) | 1 | 8 | 3 | 56 | 35 | ||||
| 11511 | 225198 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007149.23047 | 2103831.77129 | 37.7571253581517 | -122.418276020715 | (37.7571253581517, -122.418276020715) | 2 | 4 | 7 | 28859 | 19 | ||
| 11548 | 225197 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | 2 | 4 | 7 | 28859 | 19 | ||
| 12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
| 12573 | 182665 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2618 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985884.1902 | 2102331.3321 | 37.7517856167847 | -122.491707219971 | (37.7517856167847, -122.491707219971) | 1 | 8 | 3 | 56 | 35 | |||
| 13706 | 225187 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 14414 | 11584 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4001 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 5982142.6866342 | 2105549.2773534 | 37.7604018044904 | -122.504884056543 | (37.7604018044904, -122.504884056543) | 1 | 8 | 3 | 56 | 35 | |||
| 14508 | 246217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | 15 | 5 | 11 | 29492 | 9 | |||
| 16424 | 197993 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014330.76175 | 2089346.27019 | 37.7177527880479 | -122.392426160549 | (37.7177527880479, -122.392426160549) | 10 | 3 | 8 | 58 | 1 | |||
| 17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 20099 | 241180 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004770.13014 | 2108408.30025 | 37.7695572102182 | -122.426829784767 | (37.7695572102182, -122.426829784767) | 7 | 9 | 5 | 28862 | 10 |
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) );