trees

218 rows where qSpecies_id = 175 sorted by Latitude

✎ 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)
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
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
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
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
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
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
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
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
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
175397 240929 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 147 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005793.48345 2096408.78374 37.7366671197906 -122.422437298044 (37.7366671197906, -122.422437298044) 2 7 7 28859 2
179619 197380 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 2251 Silver Ave 2 : Tree Private 2     11 Width 3ft   6012873.30802 2096314.08493 37.7368039417418 -122.397952478343 (37.7368039417418, -122.397952478343) 10 3 8 58 1
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
179638 240947 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 80 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6002399.94637 2096660.61208 37.7371665618784 -122.434188205941 (37.7371665618784, -122.434188205941) 2 7 5 63 7
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
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
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
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
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
167877 214144 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1349 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991798.36054 2098388.78808 37.7413042814624 -122.470968230225 (37.7413042814624, -122.470968230225) 1 8 4 59 40
151879 248011 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 525 Franconia St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6009911.76805 2098028.06886 37.7413447878202 -122.408312722264 (37.7413447878202, -122.408312722264) 10 7 7 28859 2
96873 248013 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 525 Franconia St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009922.12667 2098078.01565 37.7414825109224 -122.408280427599 (37.7414825109224, -122.408280427599) 10 7 7 28859 2
191824 248014 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 525 Franconia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     7 Width 4ft   6009926.50706 2098096.52796 37.7415335869952 -122.408266587028 (37.7415335869952, -122.408266587028) 10 7 7 28859 2
119846 248016 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 525 Franconia St 7 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6009938.8027 2098138.85559 37.7416504979844 -122.408227057349 (37.7416504979844, -122.408227057349) 10 7 7 28859 2
179641 248018 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 525 Franconia St 9 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   6009957.63664 2098204.23496 37.7418310701357 -122.408166545559 (37.7418310701357, -122.408166545559) 10 7 7 28859 2
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
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
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
102473 240918 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 4158 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6002863.78754 2100671.92533 37.7482070116408 -122.43287098151 (37.7482070116408, -122.43287098151) 2 4 5 28862 22
99637 240885 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 3013 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   6009432.4377 2100992.16843 37.7494567005869 -122.410179305636 (37.7494567005869, -122.410179305636) 2 4 7 28859 19
114006 240886 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 3009 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 6ft   6009453.92739 2100992.83614 37.7494597384933 -122.410105040531 (37.7494597384933, -122.410105040531) 2 4 7 28859 19
143907 240887 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 3009 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6009470.6055 2100993.60175 37.7494627754843 -122.410047420976 (37.7494627754843, -122.410047420976) 2 4 7 28859 19
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
112347 240889 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008721.46882 2101044.16868 37.7495596045891 -122.41264153967 (37.7495596045891, -122.41264153967) 2 4 7 28859 19
184737 240517 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 3012 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009425.7418 2101039.02648 37.7495849870744 -122.410205768204 (37.7495849870744, -122.410205768204) 2 4 7 28859 19
102566 240516 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 3012 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009443.5343 2101040.2901 37.7495894540026 -122.410144330097 (37.7495894540026, -122.410144330097) 2 4 7 28859 19
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
159262 240891 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008718.64971 2101088.20431 37.7496803583719 -122.41265440089 (37.7496803583719, -122.41265440089) 2 4 7 28859 19
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
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
150712 240894 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008712.70804 2101184.15131 37.7499434739162 -122.412681729505 (37.7499434739162, -122.412681729505) 2 4 7 28859 19
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
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
192445 240927 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1148 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008036.38125 2101261.79072 37.7501186717498 -122.415026003064 (37.7501186717498, -122.415026003064) 2 4 7 28859 19
96206 240896 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008710.77968 2101249.00025 37.7501214263764 -122.41269298179 (37.7501214263764, -122.41269298179) 2 4 7 28859 19
88416 240897 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008707.95115 2101292.57262 37.750240907605 -122.41270584302 (37.750240907605, -122.41270584302) 2 4 7 28859 19
157695 240898 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008707.03966 2101316.20021 37.7503057325231 -122.412710665178 (37.7503057325231, -122.412710665178) 2 4 7 28859 19
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
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
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
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
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
120728 240904 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 20 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008695.81166 2101451.46415 37.7506765068321 -122.4127590541 (37.7506765068321, -122.4127590541) 2 4 7 28859 19
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
119930 240906 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1201 Treat Ave 22 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008696.38021 2101499.73493 37.7508090794957 -122.412760500211 (37.7508090794957, -122.412760500211) 2 4 7 28859 19
183111 240926 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1200 Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009479.18585 2101981.64475 37.752176202776 -122.410087494765 (37.752176202776, -122.410087494765) 2 4 7 28859 19
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
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
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
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
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
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
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
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
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
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
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
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
184499 240932 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 4586 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000693.49124 2104675.50422 37.7590765362773 -122.44066290647 (37.7590765362773, -122.44066290647) 2 4 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
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
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
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
177511 240908 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 725 Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009319.31515 2104845.25039 37.7600300568648 -122.410842580843 (37.7600300568648, -122.410842580843) 2 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
189230 240940 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 671 Church St 52 Front Yard : Yard Tree Private 2     6 Width 3ft   6004314.46376 2105211.05218 37.7607525605073 -122.428178028592 (37.7607525605073, -122.428178028592) 2 4 5 28862 3
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
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
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
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
99376 197377 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 800 Tennessee St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 6ft   6015450.47515 2105104.21656 37.7610829992901 -122.389655751329 (37.7610829992901, -122.389655751329) 10 3 8 28856 29
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
164648 240511 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 301 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009219.87224 2106727.21512 37.7651919252958 -122.411319458036 (37.7651919252958, -122.411319458036) 8 4 7 28859 19
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
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
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
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

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