trees

8,659 rows where qSpecies_id = 11 sorted by PlotSize

✎ 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)
8523 75002 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6015627.97358 2112537.98479 37.7815043339974 -122.389561041014 (37.7815043339974, -122.389561041014) 6 2 9 28856 6
8691 47618 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
8945 38806 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   7 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
9056 251171 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:21:00 AM 3                        
9193 32309 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
9219 74232 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997684.08326 2115006.73382 37.7872715918672 -122.451816113239 (37.7872715918672, -122.451816113239) 11 6 1 54 31
9247 31823 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 201 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/2003 12:00:00 AM 17   Permit Number 46493 6009289.61762 2110714.55017 37.7761441317862 -122.41135993383 (37.7761441317862, -122.41135993383) 8 2 9 28853 34
9292 46150 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
9413 35439 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
9458 84830 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 939 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM     Permit No. 49222 6002944 2110261 37.7745408475216 -122.433278698665 (37.7745408475216, -122.433278698665) 15 5 11 29492 10
9476 41802 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 5   Permit Number 42199 6011432.49542 2107611.3986 37.7677435411696 -122.403728703313 (37.7677435411696, -122.403728703313) 8 2 8 28853 20
9832 46143 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
9835 30905 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Henry Adams St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/1997 12:00:00 AM 16   Permit Number 38599 6011349.16675 2108265.74604 37.7695355752349 -122.404062984032 (37.7695355752349, -122.404062984032) 8 2 8 28853 20
9891 53917 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 308 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/12/1988 12:00:00 AM 16   Permit Number 25579 6008884.50238 2113564.96808 37.783947970966 -122.412962925017 (37.783947970966, -122.412962925017) 7 10 9 28852 36
9920 255153 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
9927 83681 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6009001.7145 2113646.06927 37.7841772342254 -122.412563147579 (37.7841772342254, -122.412563147579) 14 10 9 28852 36
9981 75898 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2650 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6009892.14521 2105512.72299 37.761894888355 -122.408908522215 (37.761894888355, -122.408908522215) 8 4 8 28859 19
10068 49666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000245.17413 2120665.11682 37.8029543681198 -122.443361894237 (37.8029543681198, -122.443361894237) 13 9 1 57 17
10086 47615 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
10098 255141 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
10196 80809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6015599.17237 2102455.49099 37.7538184070991 -122.388956535612 (37.7538184070991, -122.388956535612) 10 3 8 28856 29
10214 255235 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 10 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
10354 43417 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 246 02nd St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2000 12:00:00 AM 10   Permit Number 43159 6013405.28311 2114204.36675 37.7859563423666 -122.39736742979 (37.7859563423666, -122.39736742979) 6 2 9 28855 6
10415 43967 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 627 Turk St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2000 12:00:00 AM     Permit Number 43534 6006999.24602912 2112908.87547401 37.7820404937398 -122.419438672428 (37.7820404937398, -122.419438672428) 7 9 9 28852 36
10465 75257 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 795 Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6007991.6501 2114435.56963 37.7862882722428 -122.416113552304 (37.7862882722428, -122.416113552304) 13 1 9 28858 36
10479 30512 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 340 Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/09/1995 12:00:00 AM 12   Permit Number 34525 6008741.77827 2113543.53334 37.7838811036663 -122.413455183303 (37.7838811036663, -122.413455183303) 7 10 9 28852 36
10562 73885 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 350 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6014508.75776 2112348.63961 37.7809223143414 -122.393419764809 (37.7809223143414, -122.393419764809) 6 2 9 28856 6
10574 80213 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1522 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6007910.8791 2109536.30897 37.7728315356664 -122.416045915185 (37.7728315356664, -122.416045915185) 8 2 9 28853 19
10617 49671 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2235 NOTES) Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2003 12:00:00 AM     Permit Number 46511 5997175.15188937 2109805.23760487 37.7729604879505 -122.453201252207 (37.7729604879505, -122.453201252207) 15 5 11 29492 16
10624 47868 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 745 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/17/2002 12:00:00 AM 8   Permit Number 45622 5993132.36213 2113446.5394 37.7827259803362 -122.467450470263 (37.7827259803362, -122.467450470263) 11 6 2 54 11
10648 255138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 16 Sidewalk: Property side : Yard Tree DPW 1                              
10777 35244 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38736 6005802.2 2120854.7 37.8037902383764 -122.424145173625 (37.8037902383764, -122.424145173625) 5 9 1 28858 32
10962 39426 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 395Bldg #9 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40929 6004623.83107143 2109808.7893301 37.7733943405421 -122.42743561187 (37.7733943405421, -122.42743561187) 7 9 11 28852 10
11164 64419 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 111 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/11/1988 12:00:00 AM     Permit Number 25267 6003583.64860345 2097735.92139782 37.740186227283 -122.430172299864 (37.740186227283, -122.430172299864) 2 7 5 63 7
11177 47475 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
11307 255155 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3066 Turk St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
11331 80222 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1032 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6010303.37801 2111828.67661 37.7792600686485 -122.407931631844 (37.7792600686485, -122.407931631844) 14 2 9 28853 34
11379 75978 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6007956.14824 2114165.55971 37.7855448944115 -122.416217249547 (37.7855448944115, -122.416217249547) 13 10 9 28858 36
11423 250609 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2201 Golden Gate Ave 34 Sidewalk: Property side : Yard Tree Private 2     5     5998802.7301 2111413.83913 37.7774704438335 -122.447687106294 (37.7774704438335, -122.447687106294) 15 6 2 29492 16
11524 64282 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 411 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/18/1988 12:00:00 AM     Permit Number 25086 6003895.1200055 2098341.81687307 37.7418675138214 -122.429138548404 (37.7418675138214, -122.429138548404) 2 7 5 63 7
11612 65947 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1005 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 11   Permit Number 28968 6007327.06617 2114853.5126 37.7873984520186 -122.418442492445 (37.7873984520186, -122.418442492445) 13 9 10 28858 21
11762 62725 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 109 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/07/1986 12:00:00 AM     Permit Number 23071 6001085.93774818 2105743.30332199 37.7620307920739 -122.439382183867 (37.7620307920739, -122.439382183867) 15 5 5 28862 3
11805 33857 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 757 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1997 12:00:00 AM 13   Permit Number 37855 6014476.10973 2103508.37921 37.7566470977886 -122.392914033755 (37.7566470977886, -122.392914033755) 10 3 8 28856 29
11830 80810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6015596.09754 2102496.67483 37.7539313187876 -122.388970044334 (37.7539313187876, -122.388970044334) 10 3 8 28856 29
11837 72084 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 262 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5988392.79943 2114246.03166 37.7846463939543 -122.48390578898 (37.7846463939543, -122.48390578898) 11 6 2 55 26
11945 47610 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12038 50316 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1055 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM     Permit Number 47021 6005825.34130744 2113438.50468071 37.7834285368624 -122.42353751819 (37.7834285368624, -122.42353751819) 7 9 11 28858 41
12380 83478 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6015481.04355 2105634.6159 37.762541056634 -122.38958707191 (37.762541056634, -122.38958707191) 10 3 8 28856 29
12394 47612 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12402 67521 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 424 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31057 5997342.043029 2093839.69948247 37.7291326429008 -122.451472187982 (37.7291326429008, -122.451472187982) 9 7 4 28861 40
12508 62227 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 228 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM     Permit Number 22352 6001110.06412505 2093217.52334826 37.7276393417973 -122.438401301148 (37.7276393417973, -122.438401301148) 9 7 6 28861 25
12535 62417 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 681 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/08/1985 12:00:00 AM 14   Permit Number 22574 5991606.81123 2110812.04557 37.7754041903679 -122.472536046893 (37.7754041903679, -122.472536046893) 11 6 2 54 26
12635 74018 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997681.3026 2115023.11514 37.7873164113684 -122.451826915892 (37.7873164113684, -122.451826915892) 11 6 1 54 31
12656 262184 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 550 Delta St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
12744 35438 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
12748 75994 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6007959.81163 2114150.16473 37.7855028295219 -122.416203484529 (37.7855028295219, -122.416203484529) 13 10 9 28858 36
12774 255134 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 12 Sidewalk: Property side : Yard Tree DPW 1                              
12801 30518 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 409 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1995 12:00:00 AM 5   Permit Number 34527 6008424.27484 2113452.85192 37.7836142820115 -122.41454721209 (37.7836142820115, -122.41454721209) 7 10 9 28852 36
12889 48521 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1(REVISED) Church St 19 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.429132262601 (37.7703294028669, -122.429132262601) 7 9 5 29492 10
12891 47614 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
12896 47476 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
12907 57882 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 285 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/11/1991 12:00:00 AM     Permit Number 16832 6008642.54194369 2113136.6674883 37.7827583753423 -122.413769716445 (37.7827583753423, -122.413769716445) 7 10 9 28852 36
13109 38799 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   9 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13122 67587 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 324 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 7   Permit Number 31153 6014294.13475 2105553.95502 37.762253696265 -122.393686543294 (37.762253696265, -122.393686543294) 10 3 8 28856 29
13134 76293 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 753 Davis St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6013060.18531 2119122.80042 37.7994419813198 -122.398906706701 (37.7994419813198, -122.398906706701) 3 1 10 28860 6
13151 68243 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 493 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/1993 12:00:00 AM 10   Permit Number 32043 6007581.69224 2091476.68313 37.7232253533521 -122.415905517524 (37.7232253533521, -122.415905517524) 9 3 7 309 28
13170 71778 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1035 Sutter St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6007638.65798 2115077.87772 37.7880320397014 -122.417380352623 (37.7880320397014, -122.417380352623) 13 1 10 28858 21
13227 70595 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 330 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/2019 12:00:00 AM 9     6004399.02118 2091228.09004 37.7223633261893 -122.426889705722 (37.7223633261893, -122.426889705722) 9 7 6 28861 5
13373 46149 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
13382 38798 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   10 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13404 46147 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
13438 41722 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 232 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42170 6009584.56743913 2109048.70213008 37.7715866403458 -122.410221977607 (37.7715866403458, -122.410221977607) 8 2 9 28853 34
13506 261535 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 791 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/16/2020 12:00:00 AM 3     5982260 2110395 37.7737136636786 -122.504837403722 (37.7737136636786, -122.504837403722) 11 6 2 55 26
13562 73666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 725 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6007366.22469 2113649.85624 37.7840957097951 -122.418221641431 (37.7840957097951, -122.418221641431) 7 9 9 28858 36
13590 38665 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
13602 32308 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
13620 259100 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2019 12:00:00 AM 3                        
13749 39003 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2180 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1999 12:00:00 AM     Permit Number 40764 6008727.07607359 2105746.22742921 37.7624707078907 -122.412954561883 (37.7624707078907, -122.412954561883) 8 4 7 28859 19
13761 33744 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1198 Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1996 12:00:00 AM     Permit Number 37802 6006363.721006 2102616.9286996 37.7537454336429 -122.420906369809 (37.7537454336429, -122.420906369809) 2 4 5 28859 19
13907 68355 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 627 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32175 5989388.74548019 2111065.82314724 37.7759723585503 -122.480227347988 (37.7759723585503, -122.480227347988) 11 6 2 55 26
13938 68635 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1762 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32540 5990632.43795796 2103398.44981419 37.7549920050668 -122.475365208722 (37.7549920050668, -122.475365208722) 1 8 4 56 12
14051 49873 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1721@ 21st AVE Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2003 12:00:00 AM 0   Permit Number 46641 5989549.03002443 2105119.85153385 37.7596556546053 -122.479237819684 (37.7596556546053, -122.479237819684) 1 8 3 56 35
14063 41563 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 181 Shipley St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2000 12:00:00 AM     Permit Number 42081 6011929.63995711 2112113.99187797 37.7801343920604 -122.402325751057 (37.7801343920604, -122.402325751057) 6 2 9 28856 34
14090 47478 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
14215 70147 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2927 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5989529.51616 2111917.79074 37.7783198039619 -122.479802747413 (37.7783198039619, -122.479802747413) 11 6 2 55 26
14363 38802 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
14416 75854 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 539 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6013512.94688 2112177.08416 37.7803958844882 -122.396852757649 (37.7803958844882, -122.396852757649) 6 2 9 28856 34
14637 36870 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
14720 75940 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 539 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6013473.22084 2112140.331 37.7802927574459 -122.396987611901 (37.7802927574459, -122.396987611901) 6 2 9 28856 34
14722 38664 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
14753 259380 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
14820 33852 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 757 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1997 12:00:00 AM 6   Permit Number 37855 6014471.03913 2103566.86369 37.75680740195 -122.392935661554 (37.75680740195, -122.392935661554) 10 3 8 28856 29
14829 76313 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6015835.10862 2112662.38098 37.7818573808501 -122.388853134261 (37.7818573808501, -122.388853134261) 6 2 9 28856 6
14864 70065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 370 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6014415.94114 2112258.25542 37.7806689825201 -122.393734537439 (37.7806689825201, -122.393734537439) 6 2 9 28856 6
14933 37507 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 844 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/2002 12:00:00 AM 7   Permit Number 44548 6008745.37016 2115468.73196 37.7891674355628 -122.413578966021 (37.7891674355628, -122.413578966021) 5 1 10 28858 21
14956 75839 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6011422.77778 2107820.32569 37.7683166647229 -122.403777018493 (37.7683166647229, -122.403777018493) 8 2 8 28853 20
15004 82837 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 604 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6004044.4214 2110838.57135 37.7761890816952 -122.429513325784 (37.7761890816952, -122.429513325784) 7 9 11 28852 10
15221 255135 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 13 Sidewalk: Property side : Yard Tree DPW 1                              
15271 62738 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 4521 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/07/1986 12:00:00 AM     Permit Number 23085 6000942.99197149 2105197.51217307 37.7605240475123 -122.439837443247 (37.7605240475123, -122.439837443247) 2 4 5 28862 3
15394 255154 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk St 18 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        

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