Street_Tree_List

Data source: data.sfgov.org

347 rows where qSpecies = 155

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1748 17869 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 2132 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1992 12:00:00 AM 12 3X3   6003712.3639 2115281.4031 37.788369180682295 -122.430979161307 (37.7883691806823, -122.430979161307)
2842 36843 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
4011 159210 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 221 Foote Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 08:50:00 AM 3 Width 0ft   5998496.560769999 2088461.7916599999 37.71443219875 -122.447094072659 (37.71443219875, -122.447094072659)
4118 159211 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 209 Foote Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 09:04:00 AM 3 Width 0ft   5998530.42986 2088425.22535 37.714333731083705 -122.44697437828998 (37.7143337310837, -122.44697437829)
4122 216725 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 15 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 08:13:00 AM 3 Width 3ft   5995301.59886 2090016.3450200001 37.7185175715201 -122.458249508816 (37.7185175715201, -122.458249508816)
4292 216904 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 242 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 08:52:00 AM 3 Width 3ft   5994565.97342 2087471.1429299999 37.7114867508906 -122.46060790712299 (37.7114867508906, -122.460607907123)
4391 43330 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 345 Madrid St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 10:55:00 AM 3 3x3 Permit Number 43087 6003248.07835 2091845.00305 37.723992087443904 -122.430912250911 (37.7239920874439, -122.430912250911)
4398 62391 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 239 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 11:14:00 AM 3   Permit Number 22541 6000966.42413 2093436.7300599997 37.7282330617995 -122.438913567729 (37.7282330617995, -122.438913567729)
4406 170515 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 227 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:09:00 AM 3 Width 3ft   6001017.73881 2093400.96927 37.7281377903136 -122.438733609782 (37.7281377903136, -122.438733609782)
4421 170514 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 233 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:11:00 AM 3 Width 3ft   6001001.3973900005 2093412.5948700001 37.7281687818638 -122.43879093525699 (37.7281687818638, -122.438790935257)
4427 251739 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 142 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:37:00 AM 3 3x3   6001760.0 2087388.0 37.7116697228473 -122.435737565176 (37.7116697228473, -122.435737565176)
4428 253149 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 374 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 10:27:00 AM 3 3x3 Permit Number 46728 6003548.0 2091427.0 37.722861333032604 -122.429845667808 (37.7228613330326, -122.429845667808)
4429 160538 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 762 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:54:00 AM 3 Width 0ft   6001968.73126 2089389.7304599998 37.7171778865305 -122.435159216538 (37.7171778865305, -122.435159216538)
4436 160539 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 766 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:48:00 AM 3 Width 0ft   6001957.37061 2089373.1576 37.717131736014 -122.435197300138 (37.717131736014, -122.435197300138)
4629 34972 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1997 12:00:00 AM     Permit Number 38555          
4827 160418 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 645 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/25/2017 04:39:00 PM 3 Width 0ft   6002625.21582 2089488.7759200002 37.7174871004251 -122.43289713470199 (37.7174871004251, -122.432897134702)
5126 210064 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 281 Ralston St 4 Side Yard : Cutout 18 Tree 1 Private 1     4 Width 3ft   5992187.95019 2089731.22021 37.7175552771373 -122.46899127483299 (37.7175552771373, -122.468991274833)
5129 253815 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 144 Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5991858.0 2093861.0 37.728875565325 -122.470432347955 (37.728875565325, -122.470432347955)
5158 253816 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 144 Paloma Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x2   5991858.0 2093861.0 37.728875565325 -122.470432347955 (37.728875565325, -122.470432347955)
5335 43483 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
6782 42639 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1651 Union St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/2014 12:00:00 AM 8 3x3 Permit Number 42688 6005258.416780001 2118846.41372 37.798245281357204 -122.425883928195 (37.7982452813572, -122.425883928195)
6915 102775 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1472 Filbert St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6005927.98196 2119334.63139 37.7996236191964 -122.423601759118 (37.7996236191964, -122.423601759118)
7495 22650 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1251 Turk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/02/2014 12:00:00 AM 30 5x6 Permit Number 771274 6003965.2704 2112486.0639 37.7807082067095 -122.42990467410401 (37.7807082067095, -122.429904674104)
8070 34969 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1997 12:00:00 AM     Permit Number 38555          
8248 43488 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
8331 102773 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1472 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6005974.83524 2119343.13722 37.7996496185934 -122.42344023457501 (37.7996496185934, -122.423440234575)
9365 43485 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
10743 34971 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1997 12:00:00 AM     Permit Number 38555          
11215 75214 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 125 Excelsior Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/08/1992 12:00:00 AM 14 4x5   6002868.59368 2092460.8085599998 37.725661442297294 -122.432268027453 (37.7256614422973, -122.432268027453)
11454 43480 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
11466 43487 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
11714 36835 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
12567 43481 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
12651 73720 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 157 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/1985 12:00:00 AM 22 3x3   6001432.84153 2093102.8758 37.7273429002463 -122.437277252154 (37.7273429002463, -122.437277252154)
12777 34970 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1997 12:00:00 AM     Permit Number 38555          
12818 72149 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 157 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/1985 12:00:00 AM 22 3x3   6001449.82558 2093091.8640599998 37.727313630005895 -122.437217750315 (37.7273136300059, -122.437217750315)
12848 36855 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
12861 75133 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 125 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/08/1992 12:00:00 AM 14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.43216085884501 (37.7256104849218, -122.432160858845)
13339 187694 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600 Owens St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2107701.0 37.7681417222521 -122.394290422795 (37.7681417222521, -122.394290422795)
13341 187692 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600 Owens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2107701.0 37.7681417222521 -122.394290422795 (37.7681417222521, -122.394290422795)
13343 187696 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600 Owens St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2107701.0 37.7681417222521 -122.394290422795 (37.7681417222521, -122.394290422795)
13347 187693 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600 Owens St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2107701.0 37.7681417222521 -122.394290422795 (37.7681417222521, -122.394290422795)
13349 187695 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600 Owens St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2107701.0 37.7681417222521 -122.394290422795 (37.7681417222521, -122.394290422795)
13350 187691 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1600 Owens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2107701.0 37.7681417222521 -122.394290422795 (37.7681417222521, -122.394290422795)
13648 25580 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1511 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3X3   6016141.48149 2097069.66658 37.7390600907376 -122.386705539738 (37.7390600907376, -122.386705539738)
13876 36845 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13966 43484 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
14707 43482 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
15932 36841 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16937 43486 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2000 12:00:00 AM     Permit Number 43169          
17102 36842 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
17915 42604 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 2000 Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42672 6005206.416391299 2116498.11175578 37.791794500383794 -122.425896619276 (37.7917945003838, -122.425896619276)
22254 16148 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 383 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/21/1998 12:00:00 AM 3 3X3   5999549.4531 2094641.0103799999 37.7314590136113 -122.443898565568 (37.7314590136113, -122.443898565568)
23544 65192 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 271 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1989 12:00:00 AM 16   Permit Number 27176 6002926.25519 2091846.82738 37.7239788566282 -122.432024872357 (37.7239788566282, -122.432024872357)
24376 210090 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 131 Mangels Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6000546.30943 2095204.5369799999 37.7330631388516 -122.440492654935 (37.7330631388516, -122.440492654935)
24426 11480 DPW Maintained 3 Melaleuca linariifolia :: Flaxleaf Paperbark 155 10X Jennings St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2008 12:00:00 AM 1 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
26567 65184 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 233 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1989 12:00:00 AM 17   Permit Number 27168 6003041.22151 2092024.75933 37.7244739352114 -122.43164014959 (37.7244739352114, -122.43164014959)
26635 244296 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 250 Hickory St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   6005711.4099 2110512.9234 37.7753891740707 -122.423723593584 (37.7753891740707, -122.423723593584)
27061 66077 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1809 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/08/1990 12:00:00 AM 14   Permit Number 29121 6008672.537140001 2119157.14373 37.7992908178675 -122.41409200673799 (37.7992908178675, -122.414092006738)
27298 231986 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 166 Albion St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     31 Width 3ft   6005888.6432300005 2106279.59613 37.7637754723889 -122.422809579624 (37.7637754723889, -122.422809579624)
30131 55549 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 96 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50803 6000472.03915397 2104921.57169603 37.7597395637692 -122.441446447904 (37.7597395637692, -122.441446447904)
30356 131206 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 12 Greenwich St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6012268.92363 2120560.78169 37.8033462081302 -122.401745899659 (37.8033462081302, -122.401745899659)
30669 232024 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 219 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6007566.480359999 2097638.67227 37.740143981551 -122.41639435302099 (37.740143981551, -122.416394353021)
31086 65191 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 367 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1989 12:00:00 AM 20   Permit Number 27175 6002591.9069300005 2091314.8257799998 37.7224991382206 -122.433142666707 (37.7224991382206, -122.433142666707)
31402 244120 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1727 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5998297.7039 2108923.1313 37.7706027242734 -122.449254662385 (37.7706027242734, -122.449254662385)
31928 232027 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 3532 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006676.818519999 2104392.6839400004 37.7586388911 -122.41994960868601 (37.7586388911, -122.419949608686)
32585 232007 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 355 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6003584.95113 2099499.92863 37.74502985795979 -122.430293617171 (37.7450298579598, -122.430293617171)
33209 210071 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1596 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5992790.86821 2104639.17073 37.7585235782077 -122.46799104974 (37.7585235782077, -122.46799104974)
33556 131201 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1839 Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008667.622830001 2119201.03957 37.7994110689178 -122.414112119191 (37.7994110689178, -122.414112119191)
33657 231989 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 101 Albion St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6005907.9663 2106595.9986 37.764645329042004 -122.422765234049 (37.764645329042, -122.422765234049)
33666 131202 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1809 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008673.3875 2119141.8846299998 37.7992489679307 -122.41408798408199 (37.7992489679307, -122.414087984082)
34049 70535 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1364 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/16/1994 12:00:00 AM 10     6001296.3816 2110780.432 37.7758734704185 -122.43901535306999 (37.7758734704185, -122.43901535307)
35677 231997 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 16 Dearborn St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6005803.227080001 2105927.09883 37.762802778238395 -122.423079951801 (37.7628027782384, -122.423079951801)
35721 210066 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 281 Ralston St 2 : 4 Tree 1 Private 1     4 Width 3ft   5992186.75081 2089801.16852 37.7177472688886 -122.469000508172 (37.7177472688886, -122.469000508172)
36426 131198 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1847 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008654.162280001 2119281.7666599997 37.799631969391996 -122.414164412051 (37.799631969392, -122.414164412051)
36536 193534 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 243 Texas St 1 : 4 Tree 1 Private 1     26 Width 3ft   6013767.79609 2105950.44315 37.763313103927295 -122.39553474273599 (37.7633131039273, -122.395534742736)
38242 232021 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 718 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 2ft   6001840.14171 2099739.7642599996 37.745589405329795 -122.436344007671 (37.7455894053298, -122.436344007671)
38756 232008 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 183 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 2ft   6004714.61319 2099561.7741 37.7452635935488 -122.426391848218 (37.7452635935488, -122.426391848218)
39380 232013 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 218 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6007541.27515 2097642.62297 37.7401534118588 -122.41648178241199 (37.7401534118588, -122.416481782412)
40284 72154 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 251 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/1985 12:00:00 AM 22     6000880.62926 2093500.16908 37.7284023690599 -122.439214708412 (37.7284023690599, -122.439214708412)
40565 56306 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 159 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/1973 12:00:00 AM 12   Permit Number 12440 5993020.091109999 2114419.18617 37.7853901200585 -122.46790964501699 (37.7853901200585, -122.467909645017)
40679 231992 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 106 Albion St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6005871.723119999 2106561.10049 37.764547462130295 -122.422888109301 (37.7645474621303, -122.422888109301)
40971 231993 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 140 Albion St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 3ft   6005880.971530001 2106406.6784900003 37.7641239776661 -122.422845145987 (37.7641239776661, -122.422845145987)
41029 210068 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 341 Hugo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   5994666.48761 2107001.2960200002 37.765117498308 -122.46167562634301 (37.765117498308, -122.461675626343)
41207 131194 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1650 Green St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6005216.47237 2118540.6397 37.797403333342 -122.426007290031 (37.797403333342, -122.426007290031)
41422 232028 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 3532 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006663.73639 2104390.69372 37.758632689376704 -122.41999471149201 (37.7586326893767, -122.419994711492)
41935 141099 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 700 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5996978.7548 2112482.2963 37.7802997333106 -122.454073992998 (37.7802997333106, -122.454073992998)
42360 72161 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 362 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1989 12:00:00 AM 29     6002558.54368 2091345.46237 37.7225813668208 -122.433260183829 (37.7225813668208, -122.433260183829)
45543 232005 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 210 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6004441.28755 2099300.3070400003 37.7445302107969 -122.42731834058 (37.7445302107969, -122.42731834058)
46827 131196 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1990 Beach St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   6000726.62757 2120985.8701400002 37.803862514301706 -122.441718853545 (37.8038625143017, -122.441718853545)
47109 247446 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 845 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002968.6623 2109908.338 37.7735739239622 -122.433168183701 (37.7735739239622, -122.433168183701)
47259 232022 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 281 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   5999002.3739599995 2106518.0038 37.7640391320235 -122.44664413642599 (37.7640391320235, -122.446644136426)
47560 210085 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 224 Acadia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6001434.36658 2095084.51158 37.7327841043881 -122.43741382050501 (37.7327841043881, -122.437413820505)
47576 210063 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 830 Mount Vernon Ave 1 : 4 Tree 1 Private 1     10 Width 3ft   5997086.66101 2090487.45579 37.7199135450448 -122.452113288813 (37.7199135450448, -122.452113288813)
47637 210075 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1440 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5994786.708769999 2105353.06074 37.760598790816495 -122.461140331862 (37.7605987908165, -122.461140331862)
48380 95810 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 691 Tennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/2011 12:00:00 AM   3x3 Permit Number 767553 6015464.0 2105840.0 37.763104051991604 -122.38966036521799 (37.7631040519916, -122.389660365218)
48510 65202 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 415 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1989 12:00:00 AM 29   Permit Number 27188 6004121.8153800005 2090701.65991 37.7209021868562 -122.42781045049999 (37.7209021868562, -122.4278104505)
48705 210091 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 274 Mangels Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999602.831119999 2095247.2819599998 37.733126738012295 -122.443757568082 (37.7331267380123, -122.443757568082)
48872 66078 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1839 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/08/1990 12:00:00 AM 13   Permit Number 29122 6008662.81422 2119229.31619 37.7994884394025 -122.414130760324 (37.7994884394025, -122.414130760324)
48900 232001 Undocumented 2 Melaleuca linariifolia :: Flaxleaf Paperbark 155 1317 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   6010087.26335 2101509.32172 37.7509133720555 -122.407951354875 (37.7509133720555, -122.407951354875)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 80.541ms · Data source: data.sfgov.org