1,521 rows where qSpecies_id = 37

View and edit SQL

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)
71 227799 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1265 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2020 12:00:00 AM 17 6x6   5997473.24622 2105221.8097 37.760392645519 -122.451839397566 (37.760392645519, -122.451839397566) 15 5 11 29492 12
933 191132 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 853 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012171.3747 2104414.8785 37.759007857755 -122.400948379065 (37.759007857755, -122.400948379065) 10 3 8 28856 29
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                              
1581 19590 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
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                    
2138 228020 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1112 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5998182.13932 2106442.54702 37.7637850591596 -122.449475636595 (37.7637850591596, -122.449475636595) 15 5 11 29492 9
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
2864 227812 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 79 Piedmont St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x15   5999345.2069 2106945.6167 37.765232827359 -122.445489132637 (37.765232827359, -122.445489132637) 15 5 5 29492 9
2898 191530 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016138.64503 2107209.62915 37.7669021444474 -122.387422526024 (37.7669021444474, -122.387422526024) 14 3 9 310 20
2921 124004 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 145 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2020 12:00:00 AM 3 Width 4ft   5993946.73385 2114533.02839 37.7857561658631 -122.464712034275 (37.7857561658631, -122.464712034275) 11 6 2 54 11
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
3180 191527 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016025.61335 2107205.30438 37.7668840087222 -122.387813186138 (37.7668840087222, -122.387813186138) 14 3 9 310 20
3451 142202 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 300 LYON ST 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000252.2157 2110108.2355 37.7739683228777 -122.442579106401 (37.7739683228777, -122.442579106401) 15 5 11 29492 16
3677 95316 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2870@Divisadero Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2011 12:00:00 AM 4 3x3 Permit Number 54638 6000971.60034 2116251.73043 37.7908777689321 -122.440531359949 (37.7908777689321, -122.440531359949) 13 6 1 29490 27
3896 227738 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1240 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1991 12:00:00 AM 9 Width 4ft Permit Number 30100 5997494.2501 2105433.95534 37.7609763468939 -122.451782059502 (37.7609763468939, -122.451782059502) 15 5 11 29492 12
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
4255 19806 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY23 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 60ST                      
4267 4458 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1420 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/1999 12:00:00 AM 3 3X3   6004503.18681 2100562.97231 37.7480006990827 -122.427194227854 (37.7480006990827, -122.427194227854) 2 4 5 63 22
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
5451 227724 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 937 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1979 12:00:00 AM 18 Width 4ft Permit Number 17591 5999190.54097 2106890.47379 37.7650725879622 -122.446020116632 (37.7650725879622, -122.446020116632) 15 5 11 29492 9
5532 227753 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201X Powhattan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007829.3265 2098181.77554 37.7416500006593 -122.415523976565 (37.7416500006593, -122.415523976565) 2 7 7 28859 2
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
5921 227756 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201X Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007867.24029 2098177.26821 37.7416397555584 -122.415392564015 (37.7416397555584, -122.415392564015) 2 7 7 28859 2
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                    
6181 227892 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 11 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003807.3589 2108238.1096 37.7690354253758 -122.430147830752 (37.7690354253758, -122.430147830752) 7 9 5 28862 3
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                    
7015 23789 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Webster St 4 Median : Cutout Tree DPW 1     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.430519258933 (37.7812424081927, -122.430519258933) 15 9 11 29490 41
7219 100493 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
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                    
7443 191114 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1201 22nd St 5 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6014324.84977 2103848.63349 37.7575729597541 -122.393460960954 (37.7575729597541, -122.393460960954) 10 3 8 28856 29
7558 225711 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 220 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 5x5   6006136.54015 2101854.84256 37.7516401124236 -122.421637890685 (37.7516401124236, -122.421637890685) 2 4 5 28859 19
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
7762 227806 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1235 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5997433.43236 2105521.01823 37.7612119162092 -122.451998681919 (37.7612119162092, -122.451998681919) 15 5 11 29492 12
7866 191127 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 14 Southern Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6012309.59663 2104032.19634 37.7579648060593 -122.400443459212 (37.7579648060593, -122.400443459212) 10 3 8 28856 29
7960 228004 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1039 Cole St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5998111.03938 2106633.51885 37.7643053520281 -122.449735311348 (37.7643053520281, -122.449735311348) 15 5 11 29492 9
7994 200267 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 4 Median : Cutout Tree DPW 1     1 Width 5ft   6014763.42943 2089103.48734 37.7171101711671 -122.39091365107 (37.7171101711671, -122.39091365107) 10 3 8 58 1
8010 2406 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2729 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6009835.50998 2101434.53387 37.7506939230859 -122.408816669975 (37.7506939230859, -122.408816669975) 2 4 7 28859 19
8015 35369 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 628 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 8 5x9 Permit Number 780712 6010944.29074 2105222.09895 37.76115577964 -122.405249080092 (37.76115577964, -122.405249080092) 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
8225 227755 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201X Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007852.28017 2098178.64056 37.7416426828781 -122.415444388362 (37.7416426828781, -122.415444388362) 2 7 7 28859 2
8331 191528 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.387720466935 (37.76689343092, -122.387720466935) 14 3 9 310 20
8467 227792 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 234 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1983 12:00:00 AM 18 Width 3ft Permit Number 20294 6004387.52295 2097025.09932 37.7382799693533 -122.427342203202 (37.7382799693533, -122.427342203202) 2 7 5 63 7
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                    
8852 248572 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 196 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998334.1825 2107625.9113 37.7670429747654 -122.449035020083 (37.7670429747654, -122.449035020083) 15 5 11 29492 9
8889 227748 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 899 Jarboe Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6009090.18719 2096911.91378 37.7382340283696 -122.411074651796 (37.7382340283696, -122.411074651796) 10 7 7 28859 2
8897 191138 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 770 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 3ft   6011596.13889 2113930.29234 37.7851029064102 -122.403607318248 (37.7851029064102, -122.403607318248) 12 2 9 28853 6
8954 208076 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 442 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   5998485.7432 2094410.13539 37.7307643520895 -122.447559384561 (37.7307643520895, -122.447559384561) 9 7 4 59 40
9169 208142 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 40 Garcia Ave 2 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5995206.6173 2099521.98382 37.7446122856405 -122.459265799391 (37.7446122856405, -122.459265799391) 1 8 4 59 40
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                    
9372 208097 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1578 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992786.16766 2104723.32687 37.7587543775304 -122.468013427586 (37.7587543775304, -122.468013427586) 1 8 4 56 12
9374 124022 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 301 Funston Ave 6 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5991822 2113404 37.7825334415324 -122.471980622767 (37.7825334415324, -122.471980622767) 11 6 2 54 11
9436 115038 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 788 HARRISON ST 4 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 4x4 Permit Number 777510 6012725 2112521 37.7812963087062 -122.399602805279 (37.7812963087062, -122.399602805279) 6 2 9 28856 34
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
9586 191511 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 2 : Tree Private 2   09/27/2001 12:00:00 AM 5 Width 3ft Permit Number 44376 6012652.22642 2112454.21838 37.7811088850041 -122.399849876973 (37.7811088850041, -122.399849876973) 6 2 9 28856 34
9761 19588 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 11 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
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
10079 140408 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1395 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003217.0783 2112984.5587 37.7820345494787 -122.432528645817 (37.7820345494787, -122.432528645817) 15 9 11 29490 41
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                    
10231 228002 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1033 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5998104.33903 2106671.65488 37.764409680579 -122.449761234305 (37.764409680579, -122.449761234305) 15 5 11 29492 9
10235 191533 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016236.27796 2107216.03359 37.7669251365154 -122.387085273085 (37.7669251365154, -122.387085273085) 14 3 9 310 20
10294 129716 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006809.35 2120459.56601 37.8027621146536 -122.420631800213 (37.8027621146536, -122.420631800213) 5 1 1 28858 32
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
10435 1664 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1400X Fell St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6000454.8566 2109968.1462 37.7735952220186 -122.441868082855 (37.7735952220186, -122.441868082855) 15 5 11 29492 16
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                    
10521 123551 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 69 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5994236.53379 2115140.07553 37.7874396553249 -122.463753492359 (37.7874396553249, -122.463753492359) 11 6 1 54 11
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
10676 26756 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1399 Post St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6005569.26951 2114444.1495 37.7861753317646 -122.424494982868 (37.7861753317646, -122.424494982868) 13 9 1 28858 41
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
10733 123473 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 625 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995601.02022 2111940.74017 37.7787336686397 -122.458800964288 (37.7787336686397, -122.458800964288) 11 6 2 54 11
10741 19589 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
10822 227716 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 810 Clayton St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5998663.42523 2107521.35267 37.7667747077998 -122.447888696528 (37.7667747077998, -122.447888696528) 15 5 11 29492 9
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
11219 140380 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1405 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003187.4853 2113207.0518 37.7826437814696 -122.432646922023 (37.7826437814696, -122.432646922023) 15 9 11 29490 41
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
11273 248466 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 144 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5998292.5435 2107918.5956 37.7678442300261 -122.449200130602 (37.7678442300261, -122.449200130602) 15 5 11 29492 9
11397 191531 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016181.25153 2107212.70143 37.7669129399083 -122.387275369984 (37.7669129399083, -122.387275369984) 14 3 9 310 20
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
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
11872 227964 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 221 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6005458.52467 2102332.5968 37.7529136594399 -122.424016529154 (37.7529136594399, -122.424016529154) 2 4 5 28859 19
12148 227749 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 899 Jarboe Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6009066.20939 2096913.93044 37.7382382210078 -122.411157697894 (37.7382382210078, -122.411157697894) 10 7 7 28859 2
12201 140276 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.7734578744037 -122.450331271992 (37.7734578744037, -122.450331271992) 15 5 11 29492 16
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
12842 23729 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800X Webster St 4 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 6   6003943.6522 2111620.2321 37.7783296231018 -122.429917683229 (37.7783296231018, -122.429917683229) 7 9 11 29490 41
12974 191523 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1060 Tennessee St 3 Sidewalk: Curb side : Yard Tree Private 2     10 Width 7ft   6015501.46651 2104207.8933 37.7586247150714 -122.389416796942 (37.7586247150714, -122.389416796942) 10 3 8 28856 29
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                    
13561 129718 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1087 Chestnut St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006845.74669 2120464.39586 37.8027774273877 -122.420506191927 (37.8027774273877, -122.420506191927) 5 1 1 28858 32

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