trees

1,521 rows where qSpecies_id = 37 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)
1055 35449 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1114 32669 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
1179 251578 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 6 Median : Cutout Tree DPW 1                              
1619 95785 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 347 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767529                    
1648 35048 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
1759 35455 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
2525 261765 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 301 Funston Ave 8 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5991822 2113404 37.7825334415324 -122.471980622767 (37.7825334415324, -122.471980622767) 11 6 2 54 11
4084 259522 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 309 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994311 2099921 37.7456563517477 -122.462391578862 (37.7456563517477, -122.462391578862) 1 8 4 29491 40
5065 35446 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
5174 35453 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
5179 261766 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 301 Funston Ave 7 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5991822 2113404 37.7825334415324 -122.471980622767 (37.7825334415324, -122.471980622767) 11 6 2 54 11
5740 37326 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 517 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39837 6002947.90722614 2103845.15191447 37.756924711117 -122.432806753551 (37.756924711117, -122.432806753551) 2 4 5 28862 3
6154 35450 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
6797 35457 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
7338 35458 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
8645 35454 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
9213 35448 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
9360 35444 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
9902 258348 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1760 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM   3x3 Permit Number 25361 6009198 2119365 37.7998910391876 -122.412288414988 (37.7998910391876, -122.412288414988) 3 1 10 308 4
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10105 35452 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
10329 97503 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2105 Funston Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2011 12:00:00 AM     Permit Number 768347 5992229 2101082.8 37.7487262458818 -122.469675321985 (37.7487262458818, -122.469675321985) 1 8 4 29491 40
10497 35451 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
11208 117135 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 660 Mississippi St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6014096.85518034 2104132.8866965 37.7583407871762 -122.394269365711 (37.7583407871762, -122.394269365711) 10 3 8 28856 29
11270 32664 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
11427 173646 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 380 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003542 2106028 37.7629519666094 -122.43090793912 (37.7629519666094, -122.43090793912) 15 4 5 28862 3
12586 37973 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 630 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40203                    
12658 41678 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 4 Mars St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42133 5999656.32726227 2105735.31763117 37.761927403993 -122.444326061687 (37.761927403993, -122.444326061687) 15 5 5 28862 3
13454 35445 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
14558 46532 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 881PERMIT) Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2002 12:00:00 AM     Permit Number 44684 5998680.49722421 2107051.08092489 37.765484436098 -122.447795788427 (37.765484436098, -122.447795788427) 15 5 11 29492 9
15277 37971 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 620 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40201                    
15848 35456 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
16975 35442 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
16978 37972 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 624 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40202                    
16995 35459 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 15 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
17283 51586 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 5REVISED Buena Vista Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2005 12:00:00 AM     Permit Number 47879 6001458.32672553 2108232.67146529 37.7688871692043 -122.43827258221 (37.7688871692043, -122.43827258221) 15 5 5 29492 3
17365 35447 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 19 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
17582 35443 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 16 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
18523 35047 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 700 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
18732 95666 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 800 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110 2090446 37.7204811172617 -122.41054968459 (37.7204811172617, -122.41054968459) 9 3 7 309 28
19069 35460 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
19911 103161 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1201X Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
21977 48660 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1518 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2008 12:00:00 AM   3x3 Permit Number 51136 5993396.16596973 2105141.2714508 37.7599371524818 -122.465934158818 (37.7599371524818, -122.465934158818) 1 8 4 56 12
22407 52650 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1187@ RIVOLI Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2006 12:00:00 AM     Permit Number 48734 5997369.46824352 2105989.04982963 37.7624933485057 -122.452253677885 (37.7624933485057, -122.452253677885) 15 5 11 29492 12
22949 97501 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2105 Funston Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           5992229 2101082.8 37.7487262458818 -122.469675321985 (37.7487262458818, -122.469675321985) 1 8 4 29491 40
23885 100248 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 15 Castenada Ave 2 Sidewalk: Property side : Yard Tree Private 2   07/31/2012 12:00:00 AM     Permit Number 768792 5994535.8 2101777 37.750765401507 -122.461748809074 (37.750765401507, -122.461748809074) 1 8 4 29491 40
26910 111776 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
27036 32667 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
28497 50460 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1798 08th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM     Permit Number 47103 5993770.16230084 2103266.48951861 37.7548110540457 -122.464504569218 (37.7548110540457, -122.464504569218) 1 8 4 56 12
28910 62460 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 360 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/1985 12:00:00 AM     Permit Number 22628 5994209.59395504 2092281.24653849 37.724673635737 -122.462188261081 (37.724673635737, -122.462188261081) 9 8 4 28861 24
31190 254431 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1400X Junipero Serra Blvd 27 Median : Cutout Tree DPW 1       6X6   5991386.4673518 2088368.501669 37.71376724375 -122.471662357701 (37.71376724375, -122.471662357701) 1 8 4 64 14
31373 32662 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
32845 69079 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1256 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM   3x3 Permit Number 33087 5992094.79631072 2106892.73003089 37.764671035074 -122.470562489037 (37.764671035074, -122.470562489037) 11 8 11 56 12
33271 92232 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 654 Minnesota St   Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM   3x3 Permit Number 49975 6015152 2105524 37.7622190790018 -122.390717392856 (37.7622190790018, -122.390717392856) 10 3 8 28856 29
36528 107066 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1758 12th Ave 1 Front Yard : Yard Tree Private 2   07/24/2014 12:00:00 AM     Permit Number 773344 5992506.32742 2103625.79831 37.7557246862805 -122.468901366602 (37.7557246862805, -122.468901366602) 1 8 4 56 12
37547 37755 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1182 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/01/1998 12:00:00 AM     Permit Number 40102 6008642.9285748 2101663.94572247 37.7512569652384 -122.412956950531 (37.7512569652384, -122.412956950531) 2 4 7 28859 19
37688 44786 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2818 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM     Permit Number 43882. Basin expansion 5'9" x 8'7" 6009323.53333837 2103374.60250597 37.7559922269102 -122.410724131124 (37.7559922269102, -122.410724131124) 2 4 7 28859 19
38307 45693 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 399 04th St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/27/2001 12:00:00 AM     Permit Number 44376 6012660.71426976 2112434.35553992 37.7810548194134 -122.399819117907 (37.7810548194134, -122.399819117907) 6 2 9 28856 34
38831 117133 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 660 Mississippi St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6014096.85518034 2104132.8866965 37.7583407871762 -122.394269365711 (37.7583407871762, -122.394269365711) 10 3 8 28856 29
38927 50459 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1798 08th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM     Permit Number 47103 5993770.16230084 2103266.48951861 37.7548110540457 -122.464504569218 (37.7548110540457, -122.464504569218) 1 8 4 56 12
39757 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 201 Gonzalez Dr   Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
40816 45691 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 399 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/27/2001 12:00:00 AM     Permit Number 44376 6012660.71426976 2112434.35553992 37.7810548194134 -122.399819117907 (37.7810548194134, -122.399819117907) 6 2 9 28856 34
41133 62560 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 900X Page St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/08/1986 12:00:00 AM     Permit Number 22760 6002239.76573177 2109514.87514883 37.7724521979542 -122.435661387293 (37.7724521979542, -122.435661387293) 15 5 11 29492 9
44622 103163 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1201X Fillmore St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
45149 92905 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 5300 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2009 12:00:00 AM       6014342 2093555 37.7293097445839 -122.392681572331 (37.7293097445839, -122.392681572331) 10 3 8 58 1
45737 52268 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 244 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48433 6004938.09310689 2099915.7288881 37.7462481025481 -122.42564427901 (37.7462481025481, -122.42564427901) 2 7 5 63 22
46267 50462 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1798 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM     Permit Number 47103 5993770.16230084 2103266.48951861 37.7548110540457 -122.464504569218 (37.7548110540457, -122.464504569218) 1 8 4 56 12
46429 34995 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 21 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40965 6004109.16234729 2102931.20405913 37.7544810193688 -122.42872554735 (37.7544810193688, -122.42872554735) 2 4 5 28862 22
48254 41201 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 500 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
48776 35415 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1496 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38868 6003922.18786228 2099560.28460641 37.7452146776724 -122.429131815599 (37.7452146776724, -122.429131815599) 2 7 5 63 22
49266 41676 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 4 Mars St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42133 5999656.32726227 2105735.31763117 37.761927403993 -122.444326061687 (37.761927403993, -122.444326061687) 15 5 5 28862 3
50400 53168 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 200@ DOLORES 29th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49086 6005262.81392251 2099055.78685749 37.7439052414634 -122.424460276459 (37.7439052414634, -122.424460276459) 2 7 5 63 22
51195 88593 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 115 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM   3x3 Permit Number 51537 6004415 2101011 37.7492258917596 -122.427531088347 (37.7492258917596, -122.427531088347) 2 4 5 28862 22
51398 42064 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 3125 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/2001 12:00:00 AM     Permit Number 42374 6008884.76165611 2100531.31488982 37.7481605856471 -122.412040626823 (37.7481605856471, -122.412040626823) 2 4 7 28859 2
51700 37465 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 236 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39936 6010201.25104789 2099964.34261176 37.7466775803069 -122.407448262702 (37.7466775803069, -122.407448262702) 2 7 7 28859 2
51872 251580 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 788 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012749.64869 2112405.52034 37.7809806021178 -122.39950942242 (37.7809806021178, -122.39950942242) 6 2 9 28856 34
52197 32668 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
52618 38273 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 645 22nd St 13 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40367 6014125.41454299 2103884.52035605 37.7576604143577 -122.394153206319 (37.7576604143577, -122.394153206319) 10 3 8 28856 29
52685 107412 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1227 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997428 2105607 37.761447689258 -122.452023673629 (37.761447689258, -122.452023673629) 15 5 11 29492 12
53621 258239 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
53720 52344 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 733 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2005 12:00:00 AM     Permit Number 48488 5998540.65318208 2108052.92753039 37.7682272594267 -122.448351626603 (37.7682272594267, -122.448351626603) 15 5 11 29492 9
53807 50193 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 4981 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2003 12:00:00 AM     Permit Number 46899 5997529.52751085 2105596.18065646 37.761423797033 -122.451671753369 (37.761423797033, -122.451671753369) 15 5 11 29492 12
54759 102523 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 2192 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.469388612726 (37.7472806432819, -122.469388612726) 1 8 4 29491 40
54778 39631 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1578 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41026 5997930.04124721 2105225.66494664 37.7604293831671 -122.450259840819 (37.7604293831671, -122.450259840819) 15 5 11 29492 12
55042 38278 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 645 Texas St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40367 6014125.41454299 2103884.52035605 37.7576604143577 -122.394153206319 (37.7576604143577, -122.394153206319) 10 3 8 28856 29
55461 98269 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2700 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscape plot Permit Number 768491 6009963 2103401 37.7561005415225 -122.40851449565 (37.7561005415225, -122.40851449565) 2 4 7 28859 19
56961 53166 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 200@ DOLORES 29th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49086 6005262.81392251 2099055.78685749 37.7439052414634 -122.424460276459 (37.7439052414634, -122.424460276459) 2 7 5 63 22
56963 46130 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 144 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2001 12:00:00 AM     Permit Number 44480 5998294.90485878 2107939.22220742 37.7679010005107 -122.44919344916 (37.7679010005107, -122.44919344916) 15 5 11 29492 9
57265 39513 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 10 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40964 6004053.55723632 2102994.83081039 37.7546525762409 -122.428922380275 (37.7546525762409, -122.428922380275) 2 4 5 28862 22
57928 100247 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 15 Castenada Ave 1 Sidewalk: Property side : Yard Tree Private 2   07/31/2012 12:00:00 AM     Permit Number 768792 5994535.8 2101777 37.750765401507 -122.461748809074 (37.750765401507, -122.461748809074) 1 8 4 29491 40
58767 98349 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 225 Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002759 2109307 37.7719109027838 -122.4338504464 (37.7719109027838, -122.4338504464) 15 5 11 29492 9
60985 92903 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 5300 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2009 12:00:00 AM       6014342 2093555 37.7293097445839 -122.392681572331 (37.7293097445839, -122.392681572331) 10 3 8 58 1
61461 87093 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 3975 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2007 12:00:00 AM   3x3 Permit Number 50046 6003177 2104745 37.7594084694279 -122.432078722509 (37.7594084694279, -122.432078722509) 2 4 5 28862 3
61665 88592 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 115 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM   3x3 Permit Number 51537 6004415 2101011 37.7492258917596 -122.427531088347 (37.7492258917596, -122.427531088347) 2 4 5 28862 22
62049 32663 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
62600 34912 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 218 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 38515 6004873.60731086 2104005.13217632 37.7574730093691 -122.426158345984 (37.7574730093691, -122.426158345984) 2 4 5 28862 3
62695 121721 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 17 Sidewalk: Curb side : Cutout Tree Private 2           6014452 2103050 37.7553871476328 -122.39296534494 (37.7553871476328, -122.39296534494) 10 3 8 28856 29
64033 122499 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 396 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x5   6003831 2109101 37.7714060511358 -122.430127623444 (37.7714060511358, -122.430127623444) 7 9 11 29492 10
65109 38269 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 645 Texas St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40367 6014125.41454299 2103884.52035605 37.7576604143577 -122.394153206319 (37.7576604143577, -122.394153206319) 10 3 8 28856 29
65434 33497 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 10 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/1996 12:00:00 AM     Permit Number 37588 6007021.25591613 2099725.96970318 37.7458445577406 -122.418427487036 (37.7458445577406, -122.418427487036) 2 7 7 28859 2

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