trees

1,521 rows where qSpecies_id = 37 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)
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                              
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                    
2934 70681 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 366 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6010590.1917 2106606.8545 37.7649382022496 -122.406571346991 (37.7649382022496, -122.406571346991) 8 4 8 28853 19
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                    
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                    
7332 81252 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 877 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011897.37583 2104298.81412 37.7586738828079 -122.40188784325 (37.7586738828079, -122.40188784325) 10 3 8 28856 29
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                    
7711 121707 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6     6014418.63388 2103271.30813 37.7559929588317 -122.393096220215 (37.7559929588317, -122.393096220215) 10 3 8 28856 29
8036 121715 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2016 12:00:00 AM 3   Permit Number 779222 6014429.69222 2103112.88568 37.7555585790683 -122.393046892403 (37.7555585790683, -122.393046892403) 10 3 8 28856 29
8204 72246 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 418 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6002360.66039 2091027.79889 37.7216979061151 -122.433921526363 (37.7216979061151, -122.433921526363) 9 7 6 28861 5
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                    
9186 59095 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 671 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1980 12:00:00 AM 13   Permit Number 18396 5994079.76607 2110941.26812 37.7759018291206 -122.463990963797 (37.7759018291206, -122.463990963797) 11 6 2 54 11
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
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                    
9524 71574 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 970 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6015483.05138 2104523.27151 37.759489655143 -122.389502510438 (37.759489655143, -122.389502510438) 10 3 8 28856 29
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
10450 114373 Property Tree 8 Liquidambar styraciflua :: American Sweet Gum 37 805 GONZALEZ DR 1 Front Yard : Yard Tree Private 2     18     5988302 2089566 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
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                    
10550 72745 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 630 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6014368.47068 2104204.35874 37.7585521280858 -122.39333499383 (37.7585521280858, -122.39333499383) 10 3 8 28856 29
10691 121718 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4     6014431.62012 2103050.15485 37.7553864407519 -122.393035836129 (37.7553864407519, -122.393035836129) 10 3 8 28856 29
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
11649 76428 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 300 Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6015359.03097 2115547.59056 37.7897531109548 -122.390701840925 (37.7897531109548, -122.390701840925) 6 2 9 28855 6
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                    
16537 79734 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 278 Clara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011401.45456 2111396.60649 37.7781351201838 -122.404102493055 (37.7781351201838, -122.404102493055) 14 2 9 28856 34
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                    
18018 72759 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 620 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6014364.38031 2104253.03754 37.7586855622993 -122.393352546787 (37.7586855622993, -122.393352546787) 10 3 8 28856 29
18131 69952 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 565 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5997087.15611 2114145.30542 37.7848721322932 -122.453819112066 (37.7848721322932, -122.453819112066) 11 6 1 54 31
18408 58671 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 624 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/1979 12:00:00 AM 5   Permit Number 17896 6014367.3263 2104224.98671 37.7586087044554 -122.393340395162 (37.7586087044554, -122.393340395162) 10 3 8 28856 29
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                    
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                    
19529 33862 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 281 Clara St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/1997 12:00:00 AM 7   Permit Number 37859 6011395.19215 2111355.67015 37.778022368579 -122.404121275373 (37.778022368579, -122.404121275373) 14 2 9 28856 34
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
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
22765 191519 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1301 Minnesota St 72 Front Yard : Yard Tree Private 2     7     6015362.35528 2102287.9269 37.7533451820439 -122.38976380757 (37.7533451820439, -122.38976380757) 10 3 8 28856 29
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
23556 85317 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1278 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0     5989890.9 2106671.2 37.7639350894557 -122.478168901115 (37.7639350894557, -122.478168901115) 1 8 3 56 35
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
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
27158 108999 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 699X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3   Permit Number 773694 6011413 2108471 37.7701027222045 -122.403856631371 (37.7701027222045, -122.403856631371) 14 2 9 28853 34
28452 31991 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 215 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 12   Permit Number 35392 5994587.26751 2113998.16217 37.7843244751458 -122.462457175798 (37.7843244751458, -122.462457175798) 11 6 2 54 11
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
28740 59607 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1069 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/1981 12:00:00 AM 17   Permit Number 19009 6015565.58616 2104116.66963 37.7583777891326 -122.38918867044 (37.7583777891326, -122.38918867044) 10 3 8 28856 29
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
29663 33828 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1121 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1997 12:00:00 AM 7   Permit Number 37844 6015588.22624 2103756.71192 37.757390677059 -122.389085237613 (37.757390677059, -122.389085237613) 10 3 8 28856 29
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
34783 41824 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1540 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 3   Permit Number 42210 6001764.9422 2111535.9598 37.7779746089121 -122.437448599675 (37.7779746089121, -122.437448599675) 15 5 11 29490 41
36300 59610 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1060 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/1981 12:00:00 AM 19   Permit Number 19012 6015498.92125 2104246.5894 37.7587308251729 -122.389428301996 (37.7587308251729, -122.389428301996) 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
36588 45763 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3954 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2001 12:00:00 AM 5   Permit Number 44411 5995817.4754 2115534.84751 37.7886145656939 -122.45831237779 (37.7886145656939, -122.45831237779) 11 6 1 54 31
37222 38387 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1150 Phelps St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1998 12:00:00 AM 13   Permit Number 40446 6014272.48503 2096672.22783 37.7378651543499 -122.393139924574 (37.7378651543499, -122.393139924574) 10 3 8 58 1
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
38598 38281 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 660 Mississippi St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3   Permit Number 40367 6014095.62624 2104027.41968 37.7580511292617 -122.394266231921 (37.7580511292617, -122.394266231921) 10 3 8 28856 29
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
39301 191549 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3     6014417.54899 2103314.92047 37.7561126486868 -122.393103023604 (37.7561126486868, -122.393103023604) 10 3 8 28856 29
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
39993 66278 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2566 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/1990 12:00:00 AM 18   Permit Number 29386 6002437.3174 2116458.12302 37.7915278222894 -122.435474821927 (37.7915278222894, -122.435474821927) 13 9 1 29490 27
40317 227544 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 288 Bemis St 1 Sidewalk: Property side : Yard Tree Private 2     10     6002936.87727 2096251.7785 37.7360744584526 -122.432302602791 (37.7360744584526, -122.432302602791) 2 7 5 63 7
40693 121706 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2     6014418.47587 2103299.96349 37.7560716315206 -122.393098771612 (37.7560716315206, -122.393098771612) 10 3 8 28856 29
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
41788 43679 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 540 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM 6   Permit Number 43322 5994712.92003 2111843.24303 37.7784148808037 -122.461866155284 (37.7784148808037, -122.461866155284) 11 6 2 54 11
43173 59108 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 616 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1980 12:00:00 AM 12   Permit Number 18411 5993182.92211 2111277.08736 37.7767721716598 -122.467117773819 (37.7767721716598, -122.467117773819) 11 6 2 54 11
43321 108260 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 45 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.54469 37.7686143220373 -122.430103370918 (37.7686143220373, -122.430103370918) 7 9 5 28862 3
43577 58941 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1366 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/1980 12:00:00 AM 13   Permit Number 18219 6011964.85898 2102013.4641 37.7524025792275 -122.401493839477 (37.7524025792275, -122.401493839477) 10 3 8 28856 29
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
45237 45471 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 790 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2001 12:00:00 AM 4   Permit Number 44250 5987593.64371 2110560.66619 37.7744808674341 -122.486399898495 (37.7744808674341, -122.486399898495) 11 6 2 55 26
45535 33646 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 491 Linden St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 9   Permit Number 37738 6005091.8882 2110750.3935 37.776006217968 -122.425883573067 (37.776006217968, -122.425883573067) 7 9 11 28852 10
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
46132 208154 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 523 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2     5     5997951.24674 2095236.71061 37.7330033708131 -122.449466749514 (37.7330033708131, -122.449466749514) 9 7 4 59 40
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
48250 43801 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 525 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 5   Permit Number 43431 5988746.62136 2111728.08723 37.7777534179982 -122.482497134509 (37.7777534179982, -122.482497134509) 11 6 2 55 26
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
50245 121714 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     3     6014427.84636 2103131.04516 37.7556083385691 -122.393054546547 (37.7556083385691, -122.393054546547) 10 3 8 28856 29
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

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