trees
218 rows where qSpecies_id = 175 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||
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 | |||
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 | |||
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 |
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 | |||
117972 | 136355 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1639 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002367.63804 | 2121224.4246 | 37.8046108851334 | -122.436057126653 | (37.8046108851334, -122.436057126653) | 13 | 9 | 1 | 57 | 17 | |||
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 | |
181174 | 136354 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1508 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005758.24578 | 2118617.72057 | 37.7976455819407 | -122.424138095904 | (37.7976455819407, -122.424138095904) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 |
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
186115 | 240510 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 180 Guerrero St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005414.72148 | 2107962.30986 | 37.7683690520207 | -122.424568435908 | (37.7683690520207, -122.424568435908) | 8 | 4 | 5 | 28853 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );