trees

218 rows where qSpecies_id = 175

✎ 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)
1154 197414 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1110 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6014981.73944 2109803.00942 37.7739588520651 -122.391605444662 (37.7739588520651, -122.391605444662) 14 3 9 310 20
4747 197441 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1300 04th St 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015039.64568 2108796.242 37.7711977058453 -122.391334743299 (37.7711977058453, -122.391334743299) 14 3 9 310 20
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
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
8409 197436 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1300 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015031.80159 2108941.72055 37.7715967224486 -122.391372048095 (37.7715967224486, -122.391372048095) 14 3 9 310 20
8818 197404 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1155 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015051.04014 2109607.02256 37.7734245621155 -122.39135201659 (37.7734245621155, -122.39135201659) 14 3 9 310 20
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
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
12310 197401 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1155 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015056.14247 2109498.92263 37.7731280268706 -122.391326808588 (37.7731280268706, -122.391326808588) 14 3 9 310 20
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
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
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
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
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
24106 197438 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1300 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015034.67097 2108883.60182 37.7714373005145 -122.391358059129 (37.7714373005145, -122.391358059129) 14 3 9 310 20
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
27319 197432 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 04th St 13 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015019.54428 2109161.1913 37.7721986602722 -122.391429792676 (37.7721986602722, -122.391429792676) 14 3 9 310 20
27914 197445 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 577 Nelson Rising Ln 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6013675.59633 2108064.32122 37.7691122166786 -122.396001777755 (37.7691122166786, -122.396001777755) 14 3 9 310 20
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
28330 136357 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 456 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6007973.2563 2114063.63072 37.7852659840951 -122.416150839088 (37.7852659840951, -122.416150839088) 7 10 9 28858 36
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
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
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
34955 240903 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008699.59316 2101430.06174 37.7506179528532 -122.412744464408 (37.7506179528532, -122.412744464408) 2 4 7 28859 19
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
35652 240901 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008702.87271 2101385.26076 37.7504951234628 -122.412729956536 (37.7504951234628, -122.412729956536) 2 4 7 28859 19
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
36023 197442 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1300 04th St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015041.42072 2108767.34362 37.7711184557895 -122.391326582849 (37.7711184557895, -122.391326582849) 14 3 9 310 20
36313 136356 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 400 Leavenworth St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6008467.36905 2113992.78863 37.7850992389805 -122.414436340073 (37.7850992389805, -122.414436340073) 7 10 9 28852 36
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
37111 197402 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1155 04th St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015055.01936 2109528.18581 37.7732083147396 -122.391332739634 (37.7732083147396, -122.391332739634) 14 3 9 310 20
37698 240909 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 725 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009321.39191 2104824.59162 37.7599734490221 -122.41083393924 (37.7599734490221, -122.41083393924) 2 4 7 28859 19
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
40977 240905 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 21 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008695.45219 2101477.07086 37.7507467969474 -122.412762107295 (37.7507467969474, -122.412762107295) 2 4 7 28859 19
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
44418 240895 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008713.19989 2101208.21335 37.7500095705047 -122.41268172949 (37.7500095705047, -122.41268172949) 2 4 7 28859 19
45343 197431 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 04th St 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015017.15645 2109191.48818 37.7722817162658 -122.391440170853 (37.7722817162658, -122.391440170853) 14 3 9 310 20
46626 197412 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1110 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6014968.08623 2109861.17095 37.7741177928286 -122.391656741087 (37.7741177928286, -122.391656741087) 14 3 9 310 20
46825 240902 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 18 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008701.46806 2101407.50971 37.7505561352606 -122.412736386671 (37.7505561352606, -122.412736386671) 2 4 7 28859 19
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
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
48454 197398 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1255 04th St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015068.90313 2109281.03348 37.7725304597531 -122.391267433543 (37.7725304597531, -122.391267433543) 14 3 9 310 20
49481 240890 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008720.49083 2101064.55739 37.749615532544 -122.412646362752 (37.749615532544, -122.412646362752) 2 4 7 28859 19
49544 197434 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1300 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015028.191 2108995.68449 37.7717446951044 -122.391388310536 (37.7717446951044, -122.391388310536) 14 3 9 310 20
50420 197403 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1155 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015051.73928 2109577.98183 37.7733448615187 -122.391347567643 (37.7733448615187, -122.391347567643) 14 3 9 310 20
51340 136352 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 301 Euclid Ave 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   5997962.80043 2113889.01187 37.7842185814711 -122.450771195452 (37.7842185814711, -122.450771195452) 15 6 1 54 31
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
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
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
54092 197405 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1145 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015047.0197 2109662.59609 37.7735769315563 -122.391369809678 (37.7735769315563, -122.391369809678) 14 3 9 310 20
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
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
56514 197407 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1101 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015042.44961 2109744.00575 37.7738002107574 -122.39139131067 (37.7738002107574, -122.39139131067) 14 3 9 310 20
56632 197385 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1350 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015094.6551 2108827.79856 37.7712874060154 -122.391146668097 (37.7712874060154, -122.391146668097) 14 3 9 310 20
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
59075 197429 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 04th St 10 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015013.85039 2109250.55837 37.7724437264277 -122.391455737212 (37.7724437264277, -122.391455737212) 14 3 9 310 20
59180 240893 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008715.08963 2101164.19704 37.7498888176188 -122.412672083351 (37.7498888176188, -122.412672083351) 2 4 7 28859 19
59230 240911 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1051 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009458.35478 2103057.57846 37.7551293083888 -122.410235489878 (37.7551293083888, -122.410235489878) 2 4 7 28859 19
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
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
60591 240888 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008723.38535 2101024.2236 37.7495049474174 -122.412633502442 (37.7495049474174, -122.412633502442) 2 4 7 28859 19
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
66029 197424 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015005.72101 2109404.95283 37.7728672081818 -122.39149465358 (37.7728672081818, -122.39149465358) 14 3 9 310 20
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
66426 197387 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1350 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015092.10625 2108889.4468 37.771456537021 -122.391159794592 (37.771456537021, -122.391159794592) 14 3 9 310 20
67503 197388 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1350 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6015090.38751 2108917.06799 37.7715322833264 -122.391167670865 (37.7715322833264, -122.391167670865) 14 3 9 310 20
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
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
72739 197426 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 04th St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015010.27752 2109333.53408 37.772671361033 -122.391473898118 (37.772671361033, -122.391473898118) 14 3 9 310 20
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
73769 240900 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008703.81283 2101363.0213 37.7504341116489 -122.412725133468 (37.7504341116489, -122.412725133468) 2 4 7 28859 19
73990 240910 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 725 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009324.1679 2104803.20752 37.7599148887933 -122.410822828117 (37.7599148887933, -122.410822828117) 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
75853 197410 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1101 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015033.4092 2109848.12885 37.7740856078918 -122.391429863703 (37.7740856078918, -122.391429863703) 14 3 9 310 20
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
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
78467 197433 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 04th St 15 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015022.47536 2109102.12836 37.7720366491947 -122.391415524027 (37.7720366491947, -122.391415524027) 14 3 9 310 20
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
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
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
82329 240892 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008719.07534 2101109.02745 37.749737557951 -122.412654400905 (37.749737557951, -122.412654400905) 2 4 7 28859 19
82466 197381 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 500 Berry St 5 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6012346.20487 2108477.39645 37.770172376184 -122.400629116167 (37.770172376184, -122.400629116167) 14 2 8 28856 20
84846 197392 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1255 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015078.69031 2109108.13979 37.7720562751075 -122.391221490795 (37.7720562751075, -122.391221490795) 14 3 9 310 20
85941 197417 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1110 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6014986.84616 2109711.37392 37.7737075248119 -122.391581371605 (37.7737075248119, -122.391581371605) 14 3 9 310 20
86143 248020 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 525 Franconia St 11 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6009961.95945 2098221.90279 37.7418798242092 -122.408152844395 (37.7418798242092, -122.408152844395) 10 7 7 28859 2
86458 214143 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1374 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5991484.96158 2106064.67269 37.7623621284382 -122.472611348256 (37.7623621284382, -122.472611348256) 1 8 11 56 12
87741 197447 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 577 Nelson Rising Ln 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013720.003 2108087.26166 37.769177676536 -122.395849784245 (37.769177676536, -122.395849784245) 14 3 9 310 20
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

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