trees

218 rows where qSpecies_id = 175 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)
7663 36879 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2400 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 6   Permit Number 39539 6000815.69964 2116580.40998 37.7917713587016 -122.441094358926 (37.7917713587016, -122.441094358926) 13 6 1 29490 27
12553 58942 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1372 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1980 12:00:00 AM 10   Permit Number 18220 6011965.36067 2101992.52974 37.752345126031 -122.401490633396 (37.752345126031, -122.401490633396) 10 3 8 28856 29
17902 113640 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 1 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
20427 46507 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 675 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM 7   Permit Number 44677 6009082.35488 2111157.53331 37.7773488321059 -122.412108228226 (37.7773488321059, -122.412108228226) 8 2 9 28853 34
22296 113639 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 3 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
29247 197378 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1401 25th St 1 Sidewalk: Property side : Yard Tree Private 2     8     6014417.43137 2101975.95141 37.7524361194401 -122.393009750404 (37.7524361194401, -122.393009750404) 10 3 8 28856 1
32884 34475 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1725 Taylor St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM 5   Permit Number 38203 6008703.71619 2118937.2294 37.7986887388648 -122.413968550512 (37.7986887388648, -122.413968550512) 5 1 10 308 21
72435 36875 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2400 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 6   Permit Number 39539 6000811.56481 2116611.03172 37.7918552024927 -122.441110863301 (37.7918552024927, -122.441110863301) 13 6 1 29490 27
76271 36878 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2400 Divisadero St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 6   Permit Number 39539 6000806.76312 2116642.34595 37.7919409096927 -122.441129724752 (37.7919409096927, -122.441129724752) 13 6 1 29490 27
79238 34472 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1725 Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM 6   Permit Number 38203 6008700.38514 2118953.79893 37.7987340476021 -122.413981249836 (37.7987340476021, -122.413981249836) 5 1 10 308 21
91741 36877 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2400 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 7   Permit Number 39539 6000814.63294 2116594.68212 37.7918104855159 -122.441099074089 (37.7918104855159, -122.441099074089) 13 6 1 29490 27
112931 46508 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 675 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM 5   Permit Number 44677 6009091.30835 2111167.9463 37.777377926079 -122.412077991228 (37.777377926079, -122.412077991228) 8 2 9 28853 34
113295 113637 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 1 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
115499 113638 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 2 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
116430 36876 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2400 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 6   Permit Number 39539 6000808.4477 2116625.0074 37.7918933985134 -122.441122651606 (37.7918933985134, -122.441122651606) 13 6 1 29490 27
154144 38496 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1520 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1998 12:00:00 AM 7   Permit Number 40490 6005695.28325 2118608.46159 37.79761660398 -122.424355304657 (37.79761660398, -122.424355304657) 13 9 1 57 17
174218 113641 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 2 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
187607 34468 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1725 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM 6   Permit Number 41458 6008697.37022 2118963.2326 37.7987597807915 -122.413992350181 (37.7987597807915, -122.413992350181) 5 1 10 308 21
18031 38980 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 300x San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/17/1998 12:00:00 AM 6 3x3 Permit Number 40762 6010859.20416 2106814.33172 37.7655229342682 -122.405655510691 (37.7655229342682, -122.405655510691) 8 4 8 28853 19
19057 251711 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 3 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
22270 38984 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 300x San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1998 12:00:00 AM 4 3x3 Permit Number 40762 6010859.35781 2106780.294 37.7654294829959 -122.405652581617 (37.7654294829959, -122.405652581617) 8 4 8 28853 19
36594 251713 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 5 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
52533 251712 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 4 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
52874 96395 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 800 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2011 12:00:00 AM 7 3x3 Permit Number 767136 6015448.2444 2105163.74172 37.761246318881 -122.389667624156 (37.761246318881, -122.389667624156) 10 3 8 28856 29
54464 251710 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 2 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
59833 4403 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1044 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004378.89078 2102815.58991 37.7541788320093 -122.427784518551 (37.7541788320093, -122.427784518551) 2 4 5 28862 22
78922 96394 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 800 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2011 12:00:00 AM 8 3x3 Permit Number 767136 6015448.02055 2105186.64964 37.7613092066883 -122.389669998384 (37.7613092066883, -122.389669998384) 10 3 8 28856 29
95096 251715 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 7 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
100335 251709 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 1 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
108536 258481 Undocumented 4 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1721x Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008705 2118812 37.7983449620815 -122.413955244514 (37.7983449620815, -122.413955244514) 5 1 10 308 21
112344 94983 Permitted Site 7 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 480 ELLIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2010 12:00:00 AM   3x3 Permit Number 54004 6008557 2113884 37.78480556642 -122.414118544888 (37.78480556642, -122.414118544888) 7 10 9 28852 36
113142 96393 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 800 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2011 12:00:00 AM 4 3x3 Permit Number 767136 6015446.34816 2105205.82612 37.7613617684412 -122.389677121926 (37.7613617684412, -122.389677121926) 10 3 8 28856 29
116990 96391 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 800 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2011 12:00:00 AM 6 3x3 Permit Number 767136 6015443.33438 2105260.58125 37.7615119471268 -122.389691369876 (37.7615119471268, -122.389691369876) 10 3 8 28856 29
130383 251714 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 902 Market St 6 Front Yard : Cutout Tree DPW 1       3x3   6010270 2113565 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922) 14 2 9 28852 36
158338 258480 Undocumented 4 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1721x Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008705 2118812 37.7983449620815 -122.413955244514 (37.7983449620815, -122.413955244514) 5 1 10 308 21
168030 38986 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 300x San Bruno Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1998 12:00:00 AM 5 3x3 Permit Number 40762 6010873.0726 2106579.57544 37.764879122199 -122.405591006845 (37.764879122199, -122.405591006845) 8 4 8 28853 19
173830 98139 Property Tree 8 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 556 Laidley St   Back Yard : Yard Tree Private 2       3x3   6003085 2096041 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062) 2 7 5 63 7
175533 96392 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 800 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2011 12:00:00 AM 6 3x3 Permit Number 767136 6015444.53946 2105235.26093 37.7614424898011 -122.389685433429 (37.7614424898011, -122.389685433429) 10 3 8 28856 29
48408 38390 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2435 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1998 12:00:00 AM 5 3x5 Permit Number 40447 6006235.29717 2119188.71841 37.7992403209449 -122.422527961414 (37.7992403209449, -122.422527961414) 13 9 1 28858 32
66232 240899 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     9 3x5   6008706.04279 2101335.66338 37.7503591180827 -122.412715488225 (37.7503591180827, -122.412715488225) 2 4 7 28859 19
132466 34777 Permitted Site 7 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1148 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2002 12:00:00 AM 12 4xt Permit Number 45651 6008035.00461404 2101235.83901924 37.7500473368591 -122.415028926905 (37.7500473368591, -122.415028926905) 2 4 7 28859 19
97798 36119 Permitted Site 7 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1374 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2016 12:00:00 AM 3 5x3 Permit Number 43440 5991487.33915366 2106070.76020768 37.7623789807661 -122.472603569045 (37.7623789807661, -122.472603569045) 1 8 11 56 12
47420 103279 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 221 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2013 12:00:00 AM 3 5x6 Permit Number 770111 6004127.45538 2092231.09561 37.7251019992539 -122.427899880877 (37.7251019992539, -122.427899880877) 9 7 6 28861 5
93062 240916 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 64 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 6x10   6004904.76782 2096171.47798 37.7359653572213 -122.425493090943 (37.7359653572213, -122.425493090943) 2 7 5 28859 2
59498 38389 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2435 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1998 12:00:00 AM 6 6x5 Permit Number 40447 6006233.73845 2119201.43676 37.7992751543766 -122.422534259363 (37.7992751543766, -122.422534259363) 13 9 1 28858 32
11926 197450 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6009244.39331 2111101.4918 37.7772040457577 -122.411543721977 (37.7772040457577, -122.411543721977) 8 2 9 28853 34
35791 197455 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 12 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009137.47043 2110995.28328 37.7769064241241 -122.4119060966 (37.7769064241241, -122.4119060966) 8 2 9 28853 34
35995 179418 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 416 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6012204.41611 2086714.82751 37.7104090627014 -122.399591381259 (37.7104090627014, -122.399591381259) 10 3 8 309 1
52999 179419 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 416 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6012202.51453 2086708.25139 37.7103908999794 -122.399597492152 (37.7103908999794, -122.399597492152) 10 3 8 309 1
88055 197457 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 15 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009096.316 2110957.37076 37.7768000163312 -122.412045782913 (37.7768000163312, -122.412045782913) 8 2 9 28853 34
98641 197453 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 10 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6009170.60283 2111027.24083 37.7769960307789 -122.411793739793 (37.7769960307789, -122.411793739793) 8 2 9 28853 34
101619 197454 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 11 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6009151.50306 2111008.98278 37.7769448269774 -122.41185852156 (37.7769448269774, -122.41185852156) 8 2 9 28853 34
112346 240946 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 192 Laidley St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6004126.6518 2097259.6464 37.7389092249709 -122.428260878632 (37.7389092249709, -122.428260878632) 2 7 5 63 7
131614 197448 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6009272.74588 2111128.58634 37.7772800312881 -122.411447555674 (37.7772800312881, -122.411447555674) 8 2 9 28853 34
134025 197449 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6009262.53236 2111115.69015 37.7772440485182 -122.411481976333 (37.7772440485182, -122.411481976333) 8 2 9 28853 34
134960 197456 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 13 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009124.38702 2110985.06111 37.7768776224341 -122.411950633731 (37.7768776224341, -122.411950633731) 8 2 9 28853 34
140843 136359 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1725 Taylor St 13 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008708.52224 2118897.84426 37.7985808669576 -122.413949132363 (37.7985808669576, -122.413949132363) 5 1 10 308 21
145117 136358 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1725 Taylor St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008706.64463 2118922.43677 37.7986482864407 -122.413957370134 (37.7986482864407, -122.413957370134) 5 1 10 308 21
154513 197451 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 668 Natoma St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6009234.52734 2111091.20385 37.7771752440663 -122.41157712459 (37.7771752440663, -122.41157712459) 8 2 9 28853 34
155384 240907 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 355 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6007123.31174 2096296.95431 37.7364349894799 -122.417831571267 (37.7364349894799, -122.417831571267) 2 7 7 28859 2
160139 214145 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 763 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5994412.31981 2089911.68569 37.7181790612911 -122.46131577523 (37.7181790612911, -122.46131577523) 9 8 6 28861 24
176330 136360 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1725 Taylor St 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6008711.32926 2118885.42513 37.7985469247543 -122.413938540155 (37.7985469247543, -122.413938540155) 5 1 10 308 21
184785 240922 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 25 Conrad St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6001848.30609 2096993.36955 37.7380489119203 -122.436119279702 (37.7380489119203, -122.436119279702) 2 7 5 63 7
185459 240921 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 301 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6001181.68085 2096585.46393 37.7368910024193 -122.438394913397 (37.7368910024193, -122.438394913397) 2 7 5 63 7
5919 240924 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009473.34401 2102092.1266 37.7524792338537 -122.410115496035 (37.7524792338537, -122.410115496035) 2 4 7 28859 19
6352 197375 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 300 San Bruno Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010873.43891 2106555.26332 37.7648123871029 -122.405588027383 (37.7648123871029, -122.405588027383) 8 4 8 28853 19
9126 240925 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 Florida St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009473.40771 2102070.45596 37.7524197346826 -122.410113745957 (37.7524197346826, -122.410113745957) 2 4 7 28859 19
10743 240930 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 4621 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000546.64601 2104633.37076 37.7589524846917 -122.441167742697 (37.7589524846917, -122.441167742697) 2 4 5 28862 38
25339 240928 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 3380 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007637.32467 2104441.25017 37.7588263098068 -122.416631173298 (37.7588263098068, -122.416631173298) 2 4 7 28859 19
28175 240514 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 457 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6005714.78028 2107820.47236 37.7679965411359 -122.423520473904 (37.7679965411359, -122.423520473904) 8 4 5 28853 19
30608 214146 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 201 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996074.92383 2094212.21086 37.7300828278489 -122.455879614453 (37.7300828278489, -122.455879614453) 9 7 4 28861 40
35555 240931 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 4596 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000667.48938 2104674.07897 37.7590711421385 -122.440752730779 (37.7590711421385, -122.440752730779) 2 4 5 28862 3
37868 136353 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1508 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005781.66694 2118620.21558 37.7976537549681 -122.424057229776 (37.7976537549681, -122.424057229776) 13 9 1 57 17
39779 124080 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 701 Funston Ave 8 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5991937.65647 2110107.38371 37.7734885240998 -122.471340232044 (37.7734885240998, -122.471340232044) 11 6 2 54 11
42502 240923 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 828 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009093.2856 2104203.13194 37.758254269047 -122.411578943013 (37.758254269047, -122.411578943013) 2 4 7 28859 19
44388 240933 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 43 Yukon St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000253.26444 2104774.2655 37.7593226312454 -122.442192504878 (37.7593226312454, -122.442192504878) 2 4 5 28862 3
51457 197376 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 300 San Bruno Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010875.09874 2106538.07352 37.7647652806152 -122.405581075631 (37.7647652806152, -122.405581075631) 8 4 8 28853 19
56305 240515 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 457 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005735.72646 2107821.05877 37.767999333532 -122.423448064975 (37.767999333532, -122.423448064975) 8 4 5 28853 19
56482 240942 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 671 Church St 54 Front Yard : Yard Tree Private 2     5 Width 3ft   6004290.97855 2105224.44216 37.7607879973784 -122.428260207767 (37.7607879973784, -122.428260207767) 2 4 5 28862 3
57756 240937 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2500 Market St 1 Front Yard : Yard Tree Private 2     7 Width 3ft   6001979.1428 2105813.01717 37.7622730002231 -122.436297928215 (37.7622730002231, -122.436297928215) 15 5 5 28862 3
62406 119522 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 790 31st Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5986359.69309 2110558.27509 37.7744022999761 -122.490668135755 (37.7744022999761, -122.490668135755) 11 6 2 55 26
67923 240938 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 671 Church St 50 Front Yard : Yard Tree Private 2     6 Width 3ft   6004312.93129 2105220.54809 37.7607785473089 -122.428184005481 (37.7607785473089, -122.428184005481) 2 4 5 28862 3
68571 240913 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 85 Sycamore St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006349.99918 2105832.52537 37.7625739412505 -122.421182140339 (37.7625739412505, -122.421182140339) 8 4 7 28859 19
69095 240513 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 301 Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009217.99202 2106783.58967 37.7653466113932 -122.411329944146 (37.7653466113932, -122.411329944146) 8 4 7 28859 19
73039 240915 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 315 Lexington St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006533.58338 2104305.2413 37.7583907231708 -122.420438775123 (37.7583907231708, -122.420438775123) 2 4 7 28859 19
74328 240920 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 83 Bemis St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003674.03568 2096782.40891 37.7375732191201 -122.429791784672 (37.7375732191201, -122.429791784672) 2 7 5 63 7
75488 240943 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 671 Church St 55 Front Yard : Yard Tree Private 2     5 Width 3ft   6004289.81829 2105251.99931 37.7608635971022 -122.428266184633 (37.7608635971022, -122.428266184633) 2 4 5 28862 3
76460 240936 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2500 Market St 2 Front Yard : Yard Tree Private 2     7 Width 3ft   6001978.22314 2105823.15955 37.7623007964742 -122.436301834857 (37.7623007964742, -122.436301834857) 15 5 5 28862 3
79756 240934 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 4069 19th St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6002570.92304 2104708.12559 37.7592728411839 -122.434172195294 (37.7592728411839, -122.434172195294) 2 4 5 28862 3
91701 240512 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 301 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009219.21952 2106751.79124 37.7652593690624 -122.41132345194 (37.7652593690624, -122.41132345194) 8 4 7 28859 19
103776 240941 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 671 Church St 53 Front Yard : Yard Tree Private 2     5 Width 3ft   6004292.85412 2105210.63706 37.7607501979839 -122.4282527371 (37.7607501979839, -122.4282527371) 2 4 5 28862 3
111952 240919 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 556 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002989.39478 2095969.72486 37.7353029813381 -122.432100892951 (37.7353029813381, -122.432100892951) 2 7 5 63 7
122164 240945 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 192 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004100.4699 2097291.61636 37.738995525713 -122.428353681499 (37.738995525713, -122.428353681499) 2 7 5 63 7
131703 240914 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 85 Sycamore St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006391.17124 2105833.44907 37.7625787985022 -122.421039806442 (37.7625787985022, -122.421039806442) 8 4 7 28859 19
144750 240939 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 671 Church St 51 Front Yard : Yard Tree Private 2     6 Width 3ft   6004310.3515 2105242.11152 37.7608376093901 -122.428194464629 (37.7608376093901, -122.428194464629) 2 4 5 28862 3
148240 240912 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 85 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006337.23732 2105831.0184 37.7625690840066 -122.421226172049 (37.7625690840066, -122.421226172049) 8 4 7 28859 19
150221 240917 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 83 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005893.634 2099040.45784 37.7438987545233 -122.422277954379 (37.7438987545233, -122.422277954379) 2 7 7 28859 2
151741 240944 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 88 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004279.64168 2097645.58275 37.7399775737156 -122.427759401399 (37.7399775737156, -122.427759401399) 2 7 5 63 7
154875 248251 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 104 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006828.21507 2098946.74431 37.7436941111088 -122.419039736691 (37.7436941111088, -122.419039736691) 2 7 7 28859 2
159435 197379 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1516 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6014025.29232 2102006.07579 37.7524970440096 -122.394367951529 (37.7524970440096, -122.394367951529) 10 3 8 28856 29

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