trees
1,626 rows where qSpecies_id = 53 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134743 | 107366 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 851 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008079.7 | 2114773.8 | 37.7872219209064 | -122.415832880524 | (37.7872219209064, -122.415832880524) | 13 | 1 | 9 | 28858 | 36 | |||
14581 | 4695 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 4x8 | 6008940.69941 | 2120350.97779 | 37.802583847399 | -122.4132485365 | (37.802583847399, -122.4132485365) | 3 | 1 | 10 | 308 | 23 | |||
160258 | 6989 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 848 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15x3.5 | 6003368.38608 | 2110385.91832 | 37.7749079085756 | -122.431819586637 | (37.7749079085756, -122.431819586637) | 15 | 9 | 11 | 29492 | 10 | |||
115162 | 7181 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 847 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003442.40326 | 2111287.35095 | 37.7773872150711 | -122.431627916454 | (37.7773872150711, -122.431627916454) | 15 | 9 | 11 | 29492 | 10 | |||
169641 | 12630 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 841 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5992831.38337 | 2114795.44702 | 37.7864123300728 | -122.468589897945 | (37.7864123300728, -122.468589897945) | 11 | 6 | 2 | 54 | 11 | |||
36315 | 4701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456692 | (37.8025035109944, -122.41317456692) | 3 | 1 | 10 | 308 | 23 | |||
3916 | 261241 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 840 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2020 12:00:00 AM | 3 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||
16842 | 261242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 840 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2020 12:00:00 AM | 3 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||
77397 | 16979 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6003018.00984 | 2109974.66323 | 37.7737588358485 | -122.43300222285 | (37.7737588358485, -122.43300222285) | 15 | 5 | 11 | 29492 | 10 | |||
161897 | 253634 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830 Oak St | 1 | Sidewalk: Property side : Cutout | tree | DPW 1 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | |||||
34686 | 101290 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 830 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769326 | 6001055.4 | 2088979.9 | 37.7160006775821 | -122.438286819162 | (37.7160006775821, -122.438286819162) | 9 | 7 | 6 | 28861 | 5 | ||||
129746 | 117649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 82 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5996392 | 2111672 | 37.778041211542 | -122.456045238979 | (37.778041211542, -122.456045238979) | 11 | 6 | 2 | 54 | 16 | |||
124574 | 16977 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 815 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003104.00504 | 2109876.24546 | 37.7734934823641 | -122.432697720336 | (37.7734934823641, -122.432697720336) | 15 | 5 | 11 | 29492 | 9 | |||
67556 | 9975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
168672 | 9974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
142871 | 18385 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 16x5 | 6010402.1602537 | 2104496.7929466 | 37.759133928444 | -122.407072960308 | (37.759133928444, -122.407072960308) | 10 | 4 | 7 | 28859 | 19 | |||
14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 | |||
162520 | 10628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 805 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 6 | 3X4 | 6003942.23141 | 2110755.32974 | 37.775954734286 | -122.429860889744 | (37.775954734286, -122.429860889744) | 7 | 9 | 11 | 29492 | 10 | ||
53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
57261 | 111200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 801x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | ||||
19494 | 20113 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
62158 | 20114 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
87820 | 20116 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
129832 | 20115 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
50094 | 253202 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800 Oak St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |||
43985 | 111817 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6000817 | 2105938 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | 15 | 5 | 5 | 28862 | 3 | |||
129122 | 111818 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 ORD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000817 | 2105938 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | 15 | 5 | 5 | 28862 | 3 | ||||
100751 | 116905 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 Beaver St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
139038 | 104320 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778510 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | |
127071 | 104321 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 BEAVER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | Permit Number 778510 | 6002416.6 | 2106828.4 | 37.7650858403074 | -122.434857547122 | (37.7650858403074, -122.434857547122) | 15 | 5 | 5 | 28862 | 3 | ||
129417 | 18412 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 799X Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6010481.3464666 | 2104567.7087473 | 37.7593330783471 | -122.406804093165 | (37.7593330783471, -122.406804093165) | 10 | 4 | 8 | 28859 | 19 | |||
191709 | 52838 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 795on Trenton Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48857 | 6010309.20673902 | 2118158.51574656 | 37.7966406195852 | -122.408358059553 | (37.7966406195852, -122.408358059553) | 3 | 1 | 10 | 308 | 4 | ||||
79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
182236 | 117650 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 79 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5996337 | 2111626 | 37.7779117506286 | -122.456232175702 | (37.7779117506286, -122.456232175702) | 11 | 6 | 2 | 54 | 16 | |||
96003 | 4693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 781 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009263.30605 | 2120079.28345 | 37.801855948749 | -122.412112938993 | (37.801855948749, -122.412112938993) | 3 | 1 | 10 | 308 | 23 | |||
159917 | 122820 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 776 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009771.51732552 | 2115777.23613944 | 37.7900720800575 | -122.410050397484 | (37.7900720800575, -122.410050397484) | 5 | 1 | 10 | 28857 | 21 | ||||
181935 | 17311 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 77 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006769.4589066 | 2109244.8738273 | 37.7719670827617 | -122.419973541884 | (37.7719670827617, -122.419973541884) | 8 | 2 | 9 | 28853 | 19 | |||
4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
113469 | 117124 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
3804 | 117402 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
12765 | 117400 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
56447 | 117399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
150414 | 117403 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
158673 | 117398 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
185775 | 117401 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
87883 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | 5992930 | 2110298 | 37.7740692588728 | -122.467921468059 | (37.7740692588728, -122.467921468059) | 11 | 6 | 2 | 54 | 11 | ||||
154248 | 18380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 756 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010387.2722525 | 2104782.2318449 | 37.7599168463595 | -122.407144570806 | (37.7599168463595, -122.407144570806) | 10 | 4 | 8 | 28859 | 19 | |||
140272 | 93200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 756 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5998607 | 2107901 | 37.7678138979087 | -122.448111199872 | (37.7678138979087, -122.448111199872) | 15 | 5 | 11 | 29492 | 9 | ||||
99484 | 116156 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 755 SANSOME ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012110 | 2118369 | 37.7973192357085 | -122.402141679915 | (37.7973192357085, -122.402141679915) | 3 | 1 | 10 | 308 | 4 | ||||
57914 | 106105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744x MONTGOMERY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011751.6 | 2117873.5 | 37.7959387009634 | -122.403346966666 | (37.7959387009634, -122.403346966666) | 3 | 1 | 10 | 28860 | 4 | |||||
25882 | 40606 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48110 | 6011762.49765618 | 2117875.03517526 | 37.7959435248288 | -122.403309366526 | (37.7959435248288, -122.403309366526) | 3 | 1 | 10 | 28860 | 4 | |||
124076 | 7165 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 735 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003427.15007 | 2110890.32808 | 37.776296224072 | -122.431652329724 | (37.776296224072, -122.431652329724) | 15 | 9 | 11 | 29492 | 10 | |||
51820 | 12942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | 2 | 4 | 5 | 28859 | 19 | |||
36005 | 111369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993485 | 2106687 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | 11 | 8 | 11 | 56 | 12 | ||||
122874 | 94039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009288 | 2119899 | 37.801362320674 | -122.412014738208 | (37.801362320674, -122.412014738208) | 3 | 1 | 10 | 308 | 4 | |||
127504 | 4686 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6009336.3456 | 2120034.69791 | 37.8017376257964 | -122.411857034683 | (37.8017376257964, -122.411857034683) | 3 | 1 | 10 | 308 | 23 | |||
51714 | 7156 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | 7 | 9 | 11 | 29492 | 10 | |||
35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
64713 | 7152 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
111324 | 7153 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003550.62034 | 2110877.34065 | 37.7762675615733 | -122.431224284875 | (37.7762675615733, -122.431224284875) | 7 | 9 | 11 | 29492 | 10 | |||
140945 | 4683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 707 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009355.02929 | 2119856.39151 | 37.8012490888204 | -122.41177977375 | (37.8012490888204, -122.41177977375) | 3 | 1 | 10 | 308 | 4 | |||
29407 | 16958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6003566.56897 | 2110004.67754 | 37.7738723476787 | -122.431106813505 | (37.7738723476787, -122.431106813505) | 15 | 9 | 11 | 29492 | 10 | |||
140971 | 16959 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003588.88104 | 2109980.45883 | 37.7738071133695 | -122.431027903554 | (37.7738071133695, -122.431027903554) | 15 | 9 | 11 | 29492 | 10 | |||
124571 | 98660 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008942.64461 | 2120384.58796 | 37.8026762417443 | -122.41324418324 | (37.8026762417443, -122.41324418324) | 3 | 1 | 10 | 308 | 23 | |||
38510 | 19240 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 8x6 | 6002037.68577 | 2110909.98609 | 37.7762713444054 | -122.436460270394 | (37.7762713444054, -122.436460270394) | 15 | 5 | 11 | 29492 | 10 | |||
65399 | 7150 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003528.61787 | 2110726.18593 | 37.7758512811844 | -122.431289605258 | (37.7758512811844, -122.431289605258) | 15 | 9 | 11 | 29492 | 10 | |||
38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
105584 | 113009 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
107825 | 113010 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
118914 | 113002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
162574 | 113000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173238 | 113007 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
173558 | 113006 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
176974 | 113008 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
184217 | 113003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
64331 | 5481 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
20131 | 113298 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
68154 | 113299 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
159895 | 113553 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3x3 | 6009263 | 2115423 | 37.7890709188275 | -122.411784791395 | (37.7890709188275, -122.411784791395) | 5 | 1 | 10 | 28857 | 21 | |||
54802 | 17309 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
66600 | 17310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
187641 | 17308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
63978 | 119667 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 699x Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
37409 | 112110 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
52578 | 112111 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
126231 | 112107 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
145725 | 112106 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
184105 | 112108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
93569 | 7144 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 685X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
148453 | 52589 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 774039 | 5997878.20498734 | 2108284.16023065 | 37.7688242695831 | -122.450659631577 | (37.7688242695831, -122.450659631577) | 15 | 5 | 11 | 29492 | 9 | |||
70605 | 7148 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 670X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6003788.041 | 2110084.01472 | 37.7741027355458 | -122.430346367315 | (37.7741027355458, -122.430346367315) | 7 | 9 | 11 | 29492 | 10 | |||
181257 | 109235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002570.3 | 2095716.9 | 37.7345850124828 | -122.433531794387 | (37.7345850124828, -122.433531794387) | 2 | 7 | 5 | 63 | 7 | ||||
11231 | 57646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | 7 | 9 | 11 | 28852 | 10 |
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) );