trees
1,794 rows where qSpecies_id = 95 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92555 | 9315 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
122652 | 9318 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
125252 | 9316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
148302 | 9320 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
26580 | 194561 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 999 Kansas St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011649.57806 | 2103809.76096 | 37.7573172186375 | -122.402710453142 | (37.7573172186375, -122.402710453142) | 10 | 3 | 8 | 28856 | 29 | ||||
149139 | 253275 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 998 Douglass St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | 3x3 | 6001226 | 2100921 | 37.7487978830785 | -122.438552231639 | (37.7487978830785, -122.438552231639) | 2 | 4 | 5 | 28862 | 22 | ||
193069 | 253276 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 998 Douglass St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | 3x3 | 6001226 | 2100921 | 37.7487978830785 | -122.438552231639 | (37.7487978830785, -122.438552231639) | 2 | 4 | 5 | 28862 | 22 | ||
89783 | 62806 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 998 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23165 | 6001478.75963757 | 2111822.72775324 | 37.7787457270266 | -122.438459155796 | (37.7787457270266, -122.438459155796) | 15 | 5 | 11 | 29490 | 41 | ||
30553 | 132343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6010257.55272 | 2121964.32975 | 37.8070875542059 | -122.408805433819 | (37.8070875542059, -122.408805433819) | 3 | 1 | 10 | 308 | 23 | |||
31422 | 132346 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | 6010313.38408 | 2121972.38767 | 37.8071128062815 | -122.408612785551 | (37.8071128062815, -122.408612785551) | 3 | 1 | 10 | 308 | 23 | |||
63601 | 132347 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6010337.00106 | 2121976.02828 | 37.8071241251481 | -122.40853131059 | (37.8071241251481, -122.40853131059) | 3 | 1 | 10 | 308 | 23 | |||
73170 | 132348 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6010354.50875 | 2121976.87258 | 37.8071274238595 | -122.408470780824 | (37.8071274238595, -122.408470780824) | 3 | 1 | 10 | 308 | 23 | |||
73594 | 132350 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 4ft | 6010382.56388 | 2121982.30602 | 37.8071439138247 | -122.408374073129 | (37.8071439138247, -122.408374073129) | 3 | 1 | 10 | 308 | 23 | |||
85811 | 132353 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6010444.3802 | 2121991.12026 | 37.8071715769765 | -122.408160765609 | (37.8071715769765, -122.408160765609) | 3 | 1 | 10 | 308 | 23 | |||
87326 | 132341 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6010253.82078 | 2121967.79388 | 37.8070968568117 | -122.408818593599 | (37.8070968568117, -122.408818593599) | 3 | 1 | 10 | 308 | 23 | |||
89685 | 132352 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6010400.48539 | 2121983.74228 | 37.8071488610029 | -122.408312153001 | (37.8071488610029, -122.408312153001) | 3 | 1 | 10 | 308 | 23 | |||
115169 | 132342 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6010256.82175 | 2121967.73266 | 37.8070968568061 | -122.408808203739 | (37.8070968568061, -122.408808203739) | 3 | 1 | 10 | 308 | 23 | |||
128411 | 132349 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6010357.97788 | 2121979.4044 | 37.8071345698829 | -122.408458953812 | (37.8071345698829, -122.408458953812) | 3 | 1 | 10 | 308 | 23 | |||
136144 | 132351 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6010391.05696 | 2121984.73538 | 37.8071510598406 | -122.40834485234 | (37.8071510598406, -122.40834485234) | 3 | 1 | 10 | 308 | 23 | |||
155732 | 132344 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6010271.51992 | 2121966.31562 | 37.8070937892227 | -122.408757237352 | (37.8070937892227, -122.408757237352) | 3 | 1 | 10 | 308 | 23 | |||
169889 | 132340 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6010250.3347 | 2121963.67978 | 37.8070853652562 | -122.408830367525 | (37.8070853652562, -122.408830367525) | 3 | 1 | 10 | 308 | 23 | |||
188059 | 132345 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 North Point St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 4ft | 6010293.68664 | 2121970.09812 | 37.807105416558 | -122.408680791404 | (37.807105416558, -122.408680791404) | 3 | 1 | 10 | 308 | 23 | |||
74668 | 178379 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010067.80159 | 2089489.05977 | 37.717907207937 | -122.407171435816 | (37.717907207937, -122.407171435816) | 10 | 7 | 8 | 309 | 39 | |||
159191 | 67468 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30989 | 5996784.33302359 | 2098587.30616541 | 37.7421364707665 | -122.453742919924 | (37.7421364707665, -122.453742919924) | 9 | 7 | 4 | 59 | 40 | ||
170039 | 66650 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 987 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1991 12:00:00 AM | Permit Number 29864 | 6009988.37334471 | 2103470.11092484 | 37.756291725608 | -122.408431620376 | (37.756291725608, -122.408431620376) | 2 | 4 | 7 | 28859 | 19 | ||
169471 | 10350 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 981 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001468.92612 | 2109016.3918 | 37.7710396733632 | -122.438292073219 | (37.7710396733632, -122.438292073219) | 15 | 5 | 11 | 29492 | 9 | |||
158702 | 16839 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 97X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1999 12:00:00 AM | 75 | 3X3 | 6006555.51402 | 2110416.39536 | 37.7751717443167 | -122.420796779971 | (37.7751717443167, -122.420796779971) | 7 | 9 | 11 | 28852 | 10 | ||
175736 | 22833 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 97 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 5999264.9387203 | 2099127.2089421 | 37.7437608164767 | -122.44520460183 | (37.7437608164767, -122.44520460183) | 2 | 7 | 5 | 63 | 22 | |||
151428 | 211432 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 965 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998407.05988 | 2095671.52023 | 37.7342233191399 | -122.447922184575 | (37.7342233191399, -122.447922184575) | 9 | 7 | 4 | 59 | 40 | |||
161739 | 10346 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 959 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001539.009 | 2109027.09783 | 37.7710730553048 | -122.438050421808 | (37.7710730553048, -122.438050421808) | 15 | 5 | 11 | 29492 | 9 | |||
133436 | 181777 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 941 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5990249.7448 | 2099014.9698 | 37.7429339272529 | -122.476368471557 | (37.7429339272529, -122.476368471557) | 1 | 8 | 3 | 29491 | 35 | |||
71884 | 13374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 940 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x10 | 6009133.6559802 | 2090011.862437 | 37.7192903922619 | -122.41043727411 | (37.7192903922619, -122.41043727411) | 9 | 3 | 7 | 309 | 28 | |||
95232 | 132327 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 940 Green St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6008522.89173 | 2119019.43388 | 37.798904294645 | -122.414600083225 | (37.798904294645, -122.414600083225) | 5 | 1 | 10 | 308 | 32 | |||
187125 | 97314 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 939 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990332.7 | 2099029.1 | 37.7429775357045 | -122.47608267022 | (37.7429775357045, -122.47608267022) | 1 | 8 | 3 | 29491 | 35 | ||||
155228 | 59897 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 935 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19364 | 6009972.36860378 | 2103760.42694535 | 37.7570879720238 | -122.408507448602 | (37.7570879720238, -122.408507448602) | 2 | 4 | 7 | 28859 | 19 | ||
51215 | 139636 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 932 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000950.5576 | 2112049.201 | 37.7793375058125 | -122.440302654193 | (37.7793375058125, -122.440302654193) | 15 | 5 | 11 | 29490 | 41 | |||
182250 | 13373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 930 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X10 | 6009096.55006 | 2089989.80349 | 37.7192277427566 | -122.410563978962 | (37.7192277427566, -122.410563978962) | 9 | 3 | 7 | 309 | 28 | |||
98568 | 132324 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 93 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008139.89535 | 2119097.87736 | 37.7990981561251 | -122.415930938671 | (37.7990981561251, -122.415930938671) | 5 | 1 | 10 | 308 | 32 | ||||
110357 | 68762 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 93 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32685 | 6003698.93163887 | 2105058.11986312 | 37.7602977987445 | -122.430295967154 | (37.7602977987445, -122.430295967154) | 2 | 4 | 5 | 28862 | 3 | ||
136759 | 59579 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 927 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1981 12:00:00 AM | Permit Number 18970 | 6003789.07687713 | 2102877.39607129 | 37.7543151544522 | -122.429828648461 | (37.7543151544522, -122.429828648461) | 2 | 4 | 5 | 28862 | 22 | ||
190943 | 132287 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 926 Taylor St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6009134.27648 | 2116171.69815 | 37.7911194401688 | -122.412283098711 | (37.7911194401688, -122.412283098711) | 5 | 1 | 10 | 28857 | 21 | |||
122446 | 59904 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 917 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | 20 | 3x5 | Permit Number 19372 | 6009966.82850106 | 2103860.92095406 | 37.7573635957508 | -122.408533697213 | (37.7573635957508, -122.408533697213) | 2 | 4 | 7 | 28859 | 19 |
70609 | 233553 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 916 Alvarado St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 3ft | 6000357.83918 | 2102588.4411 | 37.7533268502794 | -122.441673968381 | (37.7533268502794, -122.441673968381) | 2 | 4 | 5 | 28862 | 22 | |||
115167 | 63674 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 911 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24326 | 5999505.51324752 | 2111590.21998339 | 37.7779948811468 | -122.445268639971 | (37.7779948811468, -122.445268639971) | 15 | 5 | 11 | 54 | 16 | ||
23939 | 233545 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 91 Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001696.74822 | 2099105.93964 | 37.7438409236316 | -122.436794475402 | (37.7438409236316, -122.436794475402) | 2 | 7 | 5 | 63 | 22 | |||
131460 | 233543 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 91 Gold Mine Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001553.31466 | 2099095.46636 | 37.7438040136364 | -122.437289684382 | (37.7438040136364, -122.437289684382) | 2 | 7 | 5 | 63 | 22 | |||
169878 | 233544 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 91 Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001580.78817 | 2099098.04809 | 37.743812664228 | -122.437194872452 | (37.743812664228, -122.437194872452) | 2 | 7 | 5 | 63 | 22 | |||
11291 | 78733 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 901.2 Huron Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5997045.64692 | 2086908.46309 | 37.7100841106663 | -122.451996982198 | (37.7100841106663, -122.451996982198) | 9 | 7 | 6 | 28861 | 25 | |||
504 | 78734 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997023.15719 | 2086886.03529 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | 9 | 7 | 6 | 28861 | 25 | |||
116879 | 65462 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 901 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28340 | 5995002.55717105 | 2089937.23341469 | 37.7182831614911 | -122.459277439941 | (37.7182831614911, -122.459277439941) | 9 | 8 | 6 | 28861 | 24 | ||
43700 | 194557 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900x Carolina St | 69 | Median : Yard | Tree | DPW 1 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.399644211933 | (37.7546723295715, -122.399644211933) | 10 | 3 | 8 | 28856 | 29 | ||||
49160 | 132325 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900 Green St | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008540.25783 | 2119021.27466 | 37.7989103246077 | -122.414540120931 | (37.7989103246077, -122.414540120931) | 5 | 1 | 10 | 308 | 32 | |||
192087 | 132326 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900 Green St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6008538.05329 | 2119021.31977 | 37.7989103246178 | -122.414547752584 | (37.7989103246178, -122.414547752584) | 5 | 1 | 10 | 308 | 32 | |||
66929 | 1334 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 90 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999221.7125604 | 2099877.5074891 | 37.7458184880896 | -122.445408004998 | (37.7458184880896, -122.445408004998) | 2 | 7 | 5 | 63 | 22 | |||
54105 | 194555 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012324.08252 | 2103973.55648 | 37.7578046017164 | -122.400389241774 | (37.7578046017164, -122.400389241774) | 10 | 3 | 8 | 28856 | 29 | |||
164552 | 194556 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012370.12074 | 2103943.11707 | 37.7577235889979 | -122.400227883634 | (37.7577235889979, -122.400227883634) | 10 | 3 | 8 | 28856 | 29 | |||
91249 | 68114 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 9 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31860 | 6006758.25542917 | 2099860.24648368 | 37.7461984425313 | -122.419346431514 | (37.7461984425313, -122.419346431514) | 2 | 7 | 7 | 28859 | 2 | ||
122591 | 178369 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Moneta Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5997905.97472 | 2088046.7198 | 37.7132587453721 | -122.449105480147 | (37.7132587453721, -122.449105480147) | 9 | 7 | 6 | 28861 | 25 | ||||
25035 | 11455 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Jade Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 6000702.8384041 | 2098560.6268459 | 37.7422870867037 | -122.440192077523 | (37.7422870867037, -122.440192077523) | 2 | 7 | 5 | 63 | 7 | ||||
80139 | 233519 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 899 Hampshire St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6010216.48713 | 2104106.2032 | 37.7580510645138 | -122.407687569327 | (37.7580510645138, -122.407687569327) | 10 | 4 | 7 | 28859 | 19 | |||
126262 | 233520 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 899 Hampshire St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6010216.38194 | 2104115.77543 | 37.7580773418214 | -122.407688608045 | (37.7580773418214, -122.407688608045) | 10 | 4 | 7 | 28859 | 19 | |||
150950 | 233521 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 899 Hampshire St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6010216.52212 | 2104122.65134 | 37.7580962293748 | -122.407688608051 | (37.7580962293748, -122.407688608051) | 10 | 4 | 7 | 28859 | 19 | |||
102295 | 211417 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 892 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998740.9762 | 2096158.55469 | 37.735579681155 | -122.446802766944 | (37.735579681155, -122.446802766944) | 9 | 7 | 4 | 59 | 40 | |||
104272 | 211418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 892 Foerster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998733.74685 | 2096161.12228 | 37.7355863181538 | -122.446827946161 | (37.7355863181538, -122.446827946161) | 9 | 7 | 4 | 59 | 40 | |||
49431 | 67556 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 890 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1995 12:00:00 AM | Permit Number 31105 | 6003602.07514471 | 2110752.33262694 | 37.7759272362097 | -122.43103736444 | (37.7759272362097, -122.43103736444) | 7 | 9 | 11 | 29492 | 10 | ||
23124 | 211419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 890 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998718.20092 | 2096172.32368 | 37.7356161864214 | -122.446882499938 | (37.7356161864214, -122.446882499938) | 9 | 7 | 4 | 59 | 40 | |||
81777 | 194562 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 889 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011315.22024 | 2104197.07336 | 37.7583620186233 | -122.40389405447 | (37.7583620186233, -122.40389405447) | 10 | 3 | 8 | 28856 | 29 | ||||
42991 | 211420 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 884 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998694.26303 | 2096188.53472 | 37.7356593305005 | -122.446966428261 | (37.7356593305005, -122.446966428261) | 9 | 7 | 4 | 59 | 40 | |||
106922 | 55944 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 88 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23659 | 6007320.31270833 | 2098871.4635855 | 37.7435151059243 | -122.41733284358 | (37.7435151059243, -122.41733284358) | 2 | 7 | 7 | 28859 | 2 | ||
27918 | 233578 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 878 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000785.56931 | 2102019.64805 | 37.7517894430431 | -122.440154008017 | (37.7517894430431, -122.440154008017) | 2 | 4 | 5 | 28862 | 22 | |||
22975 | 44428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | |
29456 | 44432 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
41816 | 44422 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
53065 | 44430 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002242.73231 | 2086958.14042 | 37.7105168311469 | -122.434038405862 | (37.7105168311469, -122.434038405862) | 9 | 7 | 6 | 28861 | 5 | |
57997 | 44419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002078.76238 | 2086879.79851 | 37.7102924143218 | -122.434599522549 | (37.7102924143218, -122.434599522549) | 9 | 7 | 6 | 28861 | 5 | |
82780 | 44427 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
85575 | 44435 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
92641 | 44418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002034.50312 | 2086862.32419 | 37.7102419210068 | -122.434751242692 | (37.7102419210068, -122.434751242692) | 9 | 7 | 6 | 28861 | 5 | |
121881 | 44429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002292.23602 | 2086990.00901 | 37.7106071446722 | -122.433869586918 | (37.7106071446722, -122.433869586918) | 9 | 7 | 6 | 28861 | 5 | |
144843 | 44434 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002147.41851 | 2086908.48033 | 37.7103750656342 | -122.434364282404 | (37.7103750656342, -122.434364282404) | 9 | 7 | 6 | 28861 | 5 | |
150367 | 44421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002090.25454 | 2086883.74706 | 37.7103039085691 | -122.434560085477 | (37.7103039085691, -122.434560085477) | 9 | 7 | 6 | 28861 | 5 | |
160852 | 44424 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
186383 | 251738 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | ||||
186446 | 44425 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002264.41887 | 2086971.04816 | 37.7105535037251 | -122.433964374559 | (37.7105535037251, -122.433964374559) | 9 | 7 | 6 | 28861 | 5 | |
187397 | 44423 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002132.44633 | 2086900.81583 | 37.7103531707288 | -122.4344154817 | (37.7103531707288, -122.4344154817) | 9 | 7 | 6 | 28861 | 5 | |
191044 | 44433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002157.33037 | 2086913.45824 | 37.7103892965003 | -122.434330380639 | (37.7103892965003, -122.434330380639) | 9 | 7 | 6 | 28861 | 5 | |
169603 | 61117 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 858 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20965 | 6007941.19441974 | 2102928.68119709 | 37.7546902263284 | -122.415473162557 | (37.7546902263284, -122.415473162557) | 2 | 4 | 7 | 28859 | 19 | ||
118548 | 64949 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 855 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1992 12:00:00 AM | Permit Number 25980 | 6000877.59992491 | 2102564.82101666 | 37.7532915955721 | -122.439874838937 | (37.7532915955721, -122.439874838937) | 2 | 4 | 5 | 28862 | 22 | ||
170784 | 61120 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 852 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | 3x3 | Permit Number 20968 | 6007939.33353128 | 2102962.26711257 | 37.7547823410171 | -122.415481975691 | (37.7547823410171, -122.415481975691) | 2 | 4 | 7 | 28859 | 19 | |
180227 | 10333 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 849 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002068.30214 | 2109102.87346 | 37.7713112029881 | -122.436225005803 | (37.7713112029881, -122.436225005803) | 15 | 5 | 11 | 29492 | 9 | |||
22121 | 132286 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 841 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6009132.2753 | 2115857.39392 | 37.7902563248256 | -122.412267798542 | (37.7902563248256, -122.412267798542) | 5 | 1 | 10 | 28858 | 21 | |||
164625 | 132285 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 841 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009123.78815 | 2115921.15925 | 37.7904309326946 | -122.412301672392 | (37.7904309326946, -122.412301672392) | 5 | 1 | 10 | 28858 | 21 | |||
160764 | 15082 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 84 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996031.3031413 | 2089045.3531152 | 37.7158933597021 | -122.455657089572 | (37.7158933597021, -122.455657089572) | 9 | 8 | 6 | 28861 | 24 | |||
173552 | 233576 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 835 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000983.28565 | 2101989.44565 | 37.7517177688651 | -122.439468114857 | (37.7517177688651, -122.439468114857) | 2 | 4 | 5 | 28862 | 22 | |||
168128 | 63755 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 832 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24429 | 6002579.84478406 | 2109569.92728925 | 37.7726226680298 | -122.434488959034 | (37.7726226680298, -122.434488959034) | 15 | 5 | 11 | 29492 | 9 | ||
31851 | 233577 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 829 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6001011.85937 | 2101991.3944 | 37.7517247457985 | -122.439369443051 | (37.7517247457985, -122.439369443051) | 2 | 4 | 5 | 28862 | 22 | |||
58354 | 61096 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 824 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20935 | 6007930.64938321 | 2103119.00141964 | 37.7552122096322 | -122.415523103949 | (37.7552122096322, -122.415523103949) | 2 | 4 | 7 | 28859 | 19 | ||
151169 | 118271 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 823 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5984456.89588 | 2110208.90743 | 37.773331703689 | -122.49722437399 | (37.773331703689, -122.49722437399) | 11 | 6 | 2 | 55 | 26 | |||
188286 | 61116 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 822 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20963 | 6007930.02908725 | 2103130.19672131 | 37.7552429145151 | -122.415526041698 | (37.7552429145151, -122.415526041698) | 2 | 4 | 7 | 28859 | 19 |
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) );