trees

420 rows where qSpecies_id = 116 sorted by DBH

✎ View and edit SQL

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
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
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
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
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
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
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
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
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
24028 84127 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 88 Mill St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50980 6010360.09243836 2089687.02520781 37.7184671339256 -122.406175049692 (37.7184671339256, -122.406175049692) 10 7 8 309 39
25842 110182 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 339 ELSIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 776744 6006513.8 2097161.9 37.7387756178582 -122.420000276005 (37.7387756178582, -122.420000276005) 2 7 7 28859 2
26688 88372 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 45 Sheridan St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306 2109414 37.7725740445577 -122.411211370961 (37.7725740445577, -122.411211370961) 8 2 9 28853 34
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
30821 108222 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
38676 109314 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 1 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
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
43466 109317 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 4 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
45448 258476 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2025 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989429 2106452 37.7633064029332 -122.479750416533 (37.7633064029332, -122.479750416533) 1 8 3 56 35
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
49201 258472 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2181 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   5989030 2106439 37.7632475211429 -122.481129458533 (37.7632475211429, -122.481129458533) 1 8 3 56 35
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
51084 82685 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 35 Jennings Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52459 6012802.99497586 2089176.16957459 37.7172007679129 -122.397695078281 (37.7172007679129, -122.397695078281) 10 3 8 58 1
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
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
69699 31970 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1350 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1995 12:00:00 AM     Permit Number 35371 6009512.01927897 2101306.3823382 37.7503239226813 -122.409926287411 (37.7503239226813, -122.409926287411) 2 4 7 28859 19
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
81429 39859 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.414839630355 (37.7696326766808, -122.414839630355) 8 4 9 28853 19
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
89456 42310 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2   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
91219 108286 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1 HENRY ADAMS ST 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   6011517.4 2108140.5 37.7692010762684 -122.403472255644 (37.7692010762684, -122.403472255644) 8 2 8 28853 20
91808 88373 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 45 Sheridan St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306 2109414 37.7725740445577 -122.411211370961 (37.7725740445577, -122.411211370961) 8 2 9 28853 34
92770 258425 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2100 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989196 2106551 37.7635646915697 -122.480563525243 (37.7635646915697, -122.480563525243) 1 8 3 56 35
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
96573 258416 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1825 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5990038 2106473 37.7633994233021 -122.477645643383 (37.7633994233021, -122.477645643383) 1 8 3 56 35
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
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
104861 258421 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1899 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5989890 2106503 37.7634732054208 -122.478159715367 (37.7634732054208, -122.478159715367) 1 8 3 56 35
106666 108225 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
107491 258427 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2142 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989006 2106545 37.7635371731016 -122.481220228107 (37.7635371731016, -122.481220228107) 1 8 3 56 35
110485 44261 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
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
111371 255520 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 77 Belgrave Ave   Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 781419 5998149.61527 2104897.27011 37.7595402565853 -122.449476776674 (37.7595402565853, -122.449476776674) 15 5 11 28862 12
112047 66205 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 285 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1990 12:00:00 AM     Permit Number 29289 6010420.85602386 2100006.0506029 37.746804390663 -122.406691826217 (37.746804390663, -122.406691826217) 2 7 7 28859 2
112460 85491 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400 24th St   Sidewalk: Curb side : Cutout Tree Private 2   09/05/2007 12:00:00 AM   3x3 Permit Number 52154 6000641 2101716 37.7509474670616 -122.440632169404 (37.7509474670616, -122.440632169404) 2 4 5 28862 22
112628 83941 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 60 13th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3X3 Permit Number 50121 6008302.41836553 2108360.42350377 37.7696248364946 -122.414608304259 (37.7696248364946, -122.414608304259) 8 4 9 28853 19
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
114315 108221 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
114591 258438 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2425 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988206.1929 2106434.2769 37.7631866273281 -122.483978353246 (37.7631866273281, -122.483978353246) 1 8 3 56 35
115769 258422 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1916 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989767 2106571 37.7636527745423 -122.478590101352 (37.7636527745423, -122.478590101352) 1 8 3 56 35
116024 39860 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.414839630355 (37.7696326766808, -122.414839630355) 8 4 9 28853 19
116195 42309 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 2 Sidewalk: Curb side : Cutout Tree Private 2   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
116276 258428 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2154 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989006 2106545 37.7635371731016 -122.481220228107 (37.7635371731016, -122.481220228107) 1 8 3 56 35
116314 258437 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2435 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988177 2106369 37.763005695226 -122.484074533324 (37.763005695226, -122.484074533324) 1 8 3 56 35
116325 258433 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2555 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987757 2106384 37.7630224196739 -122.485528252067 (37.7630224196739, -122.485528252067) 1 8 3 56 35
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
127178 115617 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031) 14 3 8 28856 20
127663 258439 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2341 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988410 2106416 37.7631483069578 -122.483272121252 (37.7631483069578, -122.483272121252) 1 8 3 56 35
129342 44264 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
130826 115632 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 55x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6012114 2107494 37.7674592382642 -122.40136319642 (37.7674592382642, -122.40136319642) 14 3 8 28856 20
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
133818 52311 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400HOFFMAN 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281) 2 4 5 28862 22
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
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
139845 107411 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 3634 20th St 2 Sidewalk: Curb side : Pot Tree Private 2       3x3   6006068 2104353 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883) 2 4 5 28859 19
140476 258418 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1839 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5990060 2106509 37.7634995462716 -122.477572184802 (37.7634995462716, -122.477572184802) 1 8 3 56 35
141375 115616 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031) 14 3 8 28856 20
142005 83791 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 369 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50933 6008828.16902132 2097088.78446754 37.7387049796432 -122.411993079981 (37.7387049796432, -122.411993079981) 10 7 7 28859 2
142362 52312 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400HOFFMAN 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281) 2 4 5 28862 22
142402 99104 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 3644 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006000.9 2104423 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469) 2 4 5 28859 19
142699 52313 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400HOFFMAN 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281) 2 4 5 28862 22
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
146756 44262 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
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
155667 47386 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 400 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2002 12:00:00 AM     Permit Number 45302 5998534.7421818 2087640.83447452 37.7121802187249 -122.446903063491 (37.7121802187249, -122.446903063491) 9 7 6 28861 25
157346 39861 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.414839630355 (37.7696326766808, -122.414839630355) 8 4 9 28853 19
157496 51920 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 45 Sheridan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009316.82358159 2109402.74774996 37.7725437555109 -122.411173135945 (37.7725437555109, -122.411173135945) 8 2 9 28853 34
158584 108224 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
159322 108227 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
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
161164 109315 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 2 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
163035 99249 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 435 Paul Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2012 12:00:00 AM   3x3 Permit Number 769233 6012286.9 2091380.6 37.7232249352354 -122.399633675727 (37.7232249352354, -122.399633675727) 10 3 8 58 1
163142 258471 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2229 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988796 2106431 37.7632119492313 -122.481938191449 (37.7632119492313, -122.481938191449) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);