trees
7,157 rows where qSpecies_id = 36 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26244 | 256808 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1098x Geary St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
27744 | 194830 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015461.92015 | 2113453.78757 | 37.7840097130328 | -122.390199511114 | (37.7840097130328, -122.390199511114) | 6 | 2 | 9 | 28856 | 6 | |||
29274 | 7785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 320X Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/05/2015 01:39:00 PM | 3 | 3X3 | 6006210.940911 | 2111809.7702747 | 37.7789781871097 | -122.422087746504 | (37.7789781871097, -122.422087746504) | 7 | 9 | 11 | 28852 | 10 | ||
30000 | 92217 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3001 Pacific Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2009 12:00:00 AM | 3x3 | Permit Number 52643 | 5999733.7 | 2116663.4 | 37.7919375385156 | -122.444844029888 | (37.7919375385156, -122.444844029888) | 13 | 6 | 1 | 29490 | 27 | ||
31112 | 96772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | ||
31345 | 250565 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6300x Geary Blvd | 8 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 5987286.538 | 2112566.9152 | 37.7799715553521 | -122.487609637856 | (37.7799715553521, -122.487609637856) | 11 | 6 | 2 | 55 | 26 | |||
31420 | 194852 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015686.66814 | 2113218.50724 | 37.7833761496389 | -122.389405522161 | (37.7833761496389, -122.389405522161) | 6 | 2 | 9 | 28856 | 6 | |||
31530 | 14822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1234 McAllister St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003155.2525 | 2111726.3545 | 37.778576329265 | -122.432652630798 | (37.778576329265, -122.432652630798) | 15 | 9 | 11 | 29490 | 41 | |||
33267 | 26138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/05/2005 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
36431 | 20200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2005 12:00:00 AM | 3 | 3X3 | 6002780.7817 | 2112950.9036 | 37.7819173900142 | -122.434035624824 | (37.7819173900142, -122.434035624824) | 15 | 9 | 11 | 29490 | 41 | ||
39453 | 26691 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1295X Pierce St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4X4 | 6002279.47567 | 2112758.75871 | 37.781361345863 | -122.435756158103 | (37.781361345863, -122.435756158103) | 15 | 5 | 11 | 29490 | 41 | |||
48418 | 48515 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1(REVISED) Church St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.429132262601 | (37.7703294028669, -122.429132262601) | 7 | 9 | 5 | 29492 | 10 | |||
48945 | 247813 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 30th St | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6003173.72803 | 2098352.92457 | 37.7418571495882 | -122.431633678058 | (37.7418571495882, -122.431633678058) | 2 | 7 | 5 | 63 | 22 | |||
49465 | 95976 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6300 Geary Blvd | 8 | Median : | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 5987433.27753 | 2112645.56538 | 37.7801960637602 | -122.487107784765 | (37.7801960637602, -122.487107784765) | 11 | 6 | 2 | 55 | 26 | |||
50391 | 26929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1510X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002136.57459 | 2111939.91141 | 37.7791048795543 | -122.436191908743 | (37.7791048795543, -122.436191908743) | 15 | 5 | 11 | 29490 | 41 | |||
51279 | 116420 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||||
51430 | 139912 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 TURK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002261.2653 | 2112250.0543 | 37.7799635374318 | -122.435782749437 | (37.7799635374318, -122.435782749437) | 15 | 5 | 11 | 29490 | 41 | |||
51833 | 1539 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 470X Arguello Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
53840 | 133138 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2801 Leavenworth St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007294.5755 | 2122084.57406 | 37.8072513081645 | -122.419067998799 | (37.8072513081645, -122.419067998799) | 5 | 1 | 1 | 308 | 32 | |||
55807 | 206136 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 145 Irving St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5995366.2235 | 2106676.44723 | 37.7642658016568 | -122.459231901232 | (37.7642658016568, -122.459231901232) | 15 | 5 | 11 | 56 | 12 | |||
56834 | 133151 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 10ft | 6012242.89918 | 2119169.29739 | 37.7995240768369 | -122.401738093564 | (37.7995240768369, -122.401738093564) | 3 | 1 | 10 | 28860 | 6 | |||
57837 | 133247 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012741.18454 | 2118172.50482 | 37.7968149168371 | -122.399943800387 | (37.7968149168371, -122.399943800387) | 3 | 1 | 10 | 28860 | 6 | |||
60986 | 194798 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013825.11231 | 2116105.99984 | 37.7912011507655 | -122.396048238549 | (37.7912011507655, -122.396048238549) | 12 | 2 | 9 | 28855 | 6 | |||
61837 | 194635 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 Wisconsin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6012639.96603 | 2105085.05344 | 37.7608741380455 | -122.399374806508 | (37.7608741380455, -122.399374806508) | 10 | 3 | 8 | 28856 | 29 | |||
63069 | 235277 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 407 Sanchez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003619.72916 | 2105884.73369 | 37.7625629956141 | -122.430628877223 | (37.7625629956141, -122.430628877223) | 8 | 4 | 5 | 28862 | 3 | |||
65617 | 133271 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
67167 | 22756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1615 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002290.5681256 | 2112253.7211071 | 37.7799752700111 | -122.435681640416 | (37.7799752700111, -122.435681640416) | 15 | 5 | 11 | 29490 | 41 | |||
67338 | 194807 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015887.13283 | 2114046.76968 | 37.7856614834305 | -122.388769827389 | (37.7856614834305, -122.388769827389) | 6 | 2 | 9 | 28856 | 6 | |||
68019 | 195012 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 15 Reuel Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6017279.93049 | 2096066.80699 | 37.7363694019213 | -122.382699497078 | (37.7363694019213, -122.382699497078) | 10 | 3 | 8 | 58 | 1 | |||
68344 | 98787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003526.90224 | 2121166.28084 | 37.8045170283068 | -122.432041230117 | (37.8045170283068, -122.432041230117) | 13 | 9 | 1 | 57 | 17 | |||
69400 | 132681 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Laurel St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998031.33764 | 2116012.96664 | 37.7900543226976 | -122.450687268025 | (37.7900543226976, -122.450687268025) | 13 | 6 | 1 | 54 | 31 | |||
71551 | 194915 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 402 Mission Rock St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015159.56132 | 2109419.57003 | 37.7729158813044 | -122.390963519359 | (37.7729158813044, -122.390963519359) | 14 | 3 | 9 | 310 | 20 | |||
71668 | 142546 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/26/2016 09:47:00 AM | 23 | Width 0ft | 6009592.8375 | 2121191.8795 | 37.8049293448711 | -122.411051233847 | (37.8049293448711, -122.411051233847) | 3 | 1 | 10 | 308 | 23 | ||
72762 | 234048 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Duncan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006223.36561 | 2099981.50589 | 37.746501253147 | -122.421204626095 | (37.746501253147, -122.421204626095) | 2 | 7 | 7 | 28859 | 2 | |||
73132 | 133133 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 855 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6007791.37883 | 2120586.43347 | 37.8031657573499 | -122.417242466784 | (37.8031657573499, -122.417242466784) | 5 | 1 | 1 | 308 | 32 | |||
74090 | 140093 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1270 Scott St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001828.9314 | 2112838.739 | 37.7815553491718 | -122.437320547425 | (37.7815553491718, -122.437320547425) | 15 | 5 | 11 | 29490 | 41 | |||
74127 | 30146 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 410X Mansell St | 8 | Median : Cutout | Tree | DPW 1 | 12 | M | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
74375 | 112897 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1x WEBSTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004219 | 2108568 | 37.7699645303419 | -122.428747509741 | (37.7699645303419, -122.428747509741) | 7 | 9 | 5 | 28862 | 10 | ||||
74468 | 120614 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010408.11609 | 2122046.12993 | 37.8073205892499 | -122.40829014837 | (37.8073205892499, -122.40829014837) | 3 | 1 | 10 | 308 | 23 | |||
75486 | 178489 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 216 Athens St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004581.99909 | 2091998.39104 | 37.7244887479307 | -122.426312010003 | (37.7244887479307, -122.426312010003) | 9 | 7 | 6 | 28861 | 5 | |||
78178 | 234035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Webster St | 8 | : | Tree | Private 2 | 6 | Width 4ft | 6004325.70364 | 2108504.14885 | 37.7697952490784 | -122.42837387216 | (37.7697952490784, -122.42837387216) | 7 | 9 | 5 | 28862 | 10 | |||
81399 | 211637 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 605x Saint Francis Blvd | 8 | Median : Yard | Tree | DPW 1 | 15 | 5993407.09448 | 2096071.29538 | 37.7350339374534 | -122.465237545992 | (37.7350339374534, -122.465237545992) | 1 | 8 | 4 | 59 | 40 | ||||
82731 | 194616 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012083.18563 | 2112300.62114 | 37.7806554027536 | -122.401807685802 | (37.7806554027536, -122.401807685802) | 6 | 2 | 9 | 28856 | 34 | |||
86072 | 236198 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 127 Otis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007074.92452 | 2109526.04906 | 37.7727563280712 | -122.418936856963 | (37.7727563280712, -122.418936856963) | 8 | 2 | 9 | 28853 | 19 | |||
86256 | 9586 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1291 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003420.42274 | 2112074.32264 | 37.7795467977493 | -122.431760157134 | (37.7795467977493, -122.431760157134) | 15 | 9 | 11 | 29490 | 41 | |||
86271 | 17343 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X Otis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | |||
87228 | 116653 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 199x Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
90702 | 256823 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1101x Geary Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006325 | 2114183 | 37.7855009281479 | -122.421861793189 | (37.7855009281479, -122.421861793189) | 13 | 9 | 11 | 28858 | 41 | ||||
90997 | 138556 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2130 POST ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001891.5406 | 2113987.2043 | 37.784712301948 | -122.437186204497 | (37.784712301948, -122.437186204497) | 13 | 6 | 11 | 29490 | 13 | |||
92122 | 21744 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2045 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002980.1505 | 2114436.9349 | 37.7860089694907 | -122.433452128346 | (37.7860089694907, -122.433452128346) | 13 | 9 | 11 | 29490 | 13 | |||
95273 | 133237 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Front St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012816.41337 | 2118778.71493 | 37.7984836187741 | -122.399726076316 | (37.7984836187741, -122.399726076316) | 3 | 1 | 10 | 28860 | 6 | |||
100243 | 133163 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010216.41491 | 2122216.75015 | 37.8077783333804 | -122.408965621987 | (37.8077783333804, -122.408965621987) | 3 | 1 | 10 | 308 | 23 | |||
104061 | 211726 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 41 Ralston St | 8 | Back Yard : Yard | Tree | Private 2 | 7 | 5992180.41529 | 2088216.96306 | 37.7133970584078 | -122.468907185537 | (37.7133970584078, -122.468907185537) | 9 | 8 | 6 | 64 | 24 | ||||
104267 | 194836 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 541 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015284.44558 | 2113636.60725 | 37.7845018490217 | -122.390826294493 | (37.7845018490217, -122.390826294493) | 6 | 2 | 9 | 28856 | 6 | |||
104735 | 32151 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 890 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35502 | 6003602.07514471 | 2110752.33262694 | 37.7759272362097 | -122.43103736444 | (37.7759272362097, -122.43103736444) | 7 | 9 | 11 | 29492 | 10 | |||
106964 | 194993 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016666.91798 | 2096257.09731 | 37.7368580152904 | -122.384832210557 | (37.7368580152904, -122.384832210557) | 10 | 3 | 8 | 58 | 1 | |||
110451 | 133172 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010432.96946 | 2122172.52415 | 37.8076690279636 | -122.408213057611 | (37.8076690279636, -122.408213057611) | 3 | 1 | 10 | 308 | 23 | |||
114088 | 97861 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 895 Indiana St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
115397 | 236191 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 149 Otis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006721.44238 | 2108807.51435 | 37.7707634924631 | -122.420108590842 | (37.7707634924631, -122.420108590842) | 8 | 2 | 9 | 28853 | 19 | |||
115830 | 113292 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1626 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002154 | 2114089 | 37.7850067228559 | -122.436285471088 | (37.7850067228559, -122.436285471088) | 13 | 6 | 11 | 29490 | 13 | ||||
117635 | 26968 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2075X Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002720.2123 | 2114391.666 | 37.7858699216291 | -122.434348205335 | (37.7858699216291, -122.434348205335) | 13 | 9 | 11 | 29490 | 13 | |||
119171 | 178446 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300x Mansell St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6010876.55341 | 2090479.66011 | 37.7206724217895 | -122.404445611375 | (37.7206724217895, -122.404445611375) | 10 | 3 | 7 | 309 | 28 | |||
124597 | 9419 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2000 12:00:00 AM | 3 | 4X4 | 6006028.19792 | 2112479.26218 | 37.7808061399353 | -122.42276752011 | (37.7808061399353, -122.42276752011) | 7 | 9 | 11 | 28852 | 41 | ||
127286 | 133187 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6010536.30097 | 2121315.75922 | 37.8053223496175 | -122.407794999663 | (37.8053223496175, -122.407794999663) | 3 | 1 | 10 | 308 | 23 | ||||
127524 | 234055 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Brook St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005570.68759 | 2097858.48706 | 37.7406351085105 | -122.423310624296 | (37.7406351085105, -122.423310624296) | 2 | 7 | 7 | 28859 | 2 | |||
129782 | 133012 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006116.78633 | 2111802.05928 | 37.778951703695 | -122.42241291743 | (37.778951703695, -122.42241291743) | 7 | 9 | 11 | 28852 | 10 | |||
130486 | 124689 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 460 Arguello Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995612.6512 | 2113255.56441 | 37.7823444945561 | -122.458855947479 | (37.7823444945561, -122.458855947479) | 11 | 6 | 1 | 54 | 31 | |||
136112 | 133259 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013073.80221 | 2118219.38771 | 37.7969621844144 | -122.398796150316 | (37.7969621844144, -122.398796150316) | 3 | 1 | 10 | 28860 | 6 | |||
139610 | 98609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003008.4 | 2116877.5 | 37.7927117414369 | -122.433528869724 | (37.7927117414369, -122.433528869724) | 13 | 9 | 1 | 29490 | 27 | ||
140195 | 194865 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015826.7116 | 2109071.02334 | 37.7719958451713 | -122.38863141183 | (37.7719958451713, -122.38863141183) | 14 | 3 | 9 | 310 | 20 | |||
140936 | 235012 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 530 Eureka St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001522.36327 | 2102648.23303 | 37.7535573060254 | -122.437651092238 | (37.7535573060254, -122.437651092238) | 2 | 4 | 5 | 28862 | 22 | |||
143697 | 211645 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 605x Saint Francis Blvd | 8 | Median : Yard | Tree | DPW 1 | 16 | 5993570.72936 | 2096039.79519 | 37.7349568808603 | -122.46466951978 | (37.7349568808603, -122.46466951978) | 9 | 8 | 4 | 59 | 40 | ||||
145285 | 194844 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015722.72472 | 2113085.38787 | 37.7830126328712 | -122.38927148089 | (37.7830126328712, -122.38927148089) | 6 | 2 | 9 | 28856 | 6 | |||
146985 | 5998 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1675 Eddy St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002579.60353 | 2112492.8275 | 37.7806482091024 | -122.434698841508 | (37.7806482091024, -122.434698841508) | 15 | 5 | 11 | 29490 | 41 | |||
146989 | 133217 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013164.76536 | 2118358.71997 | 37.7973498254916 | -122.398491175837 | (37.7973498254916, -122.398491175837) | 3 | 1 | 10 | 28860 | 6 | |||
151965 | 98629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 6x6 | 6002271.75666 | 2120123.52327 | 37.8015826528763 | -122.436310096028 | (37.8015826528763, -122.436310096028) | 13 | 9 | 1 | 57 | 17 | ||
152503 | 98570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
153878 | 15802 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4950 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2007 12:00:00 AM | 3 | 4x4 | 6000889.9210477 | 2090200.0223298 | 37.7193414459012 | -122.438946180066 | (37.7193414459012, -122.438946180066) | 9 | 7 | 6 | 28861 | 25 | ||
154088 | 95241 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
158794 | 183892 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1390 Quintara St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989018.742 | 2101016.6519 | 37.7483585517643 | -122.480771401716 | (37.7483585517643, -122.480771401716) | 1 | 8 | 3 | 29491 | 35 | |||
159076 | 251074 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5000x Geary Blvd | 8 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | 11 | 6 | 2 | 54 | 26 | |||
161435 | 133207 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 641 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6013115.22048 | 2118726.43091 | 37.798356711839 | -122.39868843312 | (37.798356711839, -122.39868843312) | 3 | 1 | 10 | 28860 | 6 | |||
163210 | 9434 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 727 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006021.57134 | 2112421.9673 | 37.780648448312 | -122.422786371713 | (37.780648448312, -122.422786371713) | 7 | 9 | 11 | 28852 | 41 | |||
163379 | 194891 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015302.93156 | 2109087.73711 | 37.7720126957589 | -122.390444390218 | (37.7720126957589, -122.390444390218) | 14 | 3 | 9 | 310 | 20 | |||
164168 | 194817 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015735.95562 | 2114106.65654 | 37.7858175391931 | -122.389297045023 | (37.7858175391931, -122.389297045023) | 6 | 2 | 9 | 28856 | 6 | |||
165305 | 93105 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53160 | 5995888.42271 | 2113224.45495 | 37.7822749237882 | -122.457899654053 | (37.7822749237882, -122.457899654053) | 11 | 6 | 1 | 54 | 31 |
168135 | 194931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 660 China Basin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014588.48774 | 2109053.35048 | 37.7718786194353 | -122.392913319699 | (37.7718786194353, -122.392913319699) | 14 | 3 | 9 | 310 | 20 | |||
169916 | 200654 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1514 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015401.8166 | 2095245.1347 | 37.7340093188928 | -122.389135623817 | (37.7340093188928, -122.389135623817) | 10 | 3 | 8 | 58 | 1 | |||
173376 | 132660 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 20 Walnut St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998466.33507 | 2116372.94599 | 37.7910676203152 | -122.449208164718 | (37.7910676203152, -122.449208164718) | 13 | 6 | 1 | 54 | 31 | |||
175944 | 98769 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003355.72677 | 2121066.39367 | 37.8042330583593 | -122.432626458567 | (37.8042330583593, -122.432626458567) | 13 | 9 | 1 | 57 | 17 | |||
176863 | 132883 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2620 Broderick St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6000188.25103 | 2117564.60028 | 37.7944379277322 | -122.443336045028 | (37.7944379277322, -122.443336045028) | 13 | 9 | 1 | 57 | 27 | |||
177802 | 142608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 CHESTNUT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008209.8918 | 2120699.9092 | 37.8035008693891 | -122.41580222652 | (37.8035008693891, -122.41580222652) | 5 | 1 | 10 | 308 | 32 | |||
178066 | 139902 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1522 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002165.4919 | 2111939.0447 | 37.779104142687 | -122.436091810107 | (37.779104142687, -122.436091810107) | 15 | 5 | 11 | 29490 | 41 | |||
183257 | 98751 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
185392 | 15787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 MISSION ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2015 10:02:00 AM | 3 | 3X3 | 6001135 | 2090627 | 37.720527771508 | -122.438129605408 | (37.720527771508, -122.438129605408) | 9 | 7 | 6 | 28861 | 25 | ||
189099 | 42732 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 11 | Permit Number 42732 | 6013639.7099 | 2093421.36867 | 37.7289037905782 | -122.395100113884 | (37.7289037905782, -122.395100113884) | 10 | 3 | 8 | 58 | 1 | |
191555 | 194905 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 401 Mission Rock St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015281.73268 | 2109381.67848 | 37.7728186178107 | -122.390538262332 | (37.7728186178107, -122.390538262332) | 14 | 3 | 9 | 310 | 20 | |||
192790 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 8 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
193870 | 133226 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600 Front St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012871.05323 | 2118401.05303 | 37.7974496952149 | -122.399510475549 | (37.7974496952149, -122.399510475549) | 3 | 1 | 10 | 28860 | 6 | |||
194268 | 15788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2020 12:00:00 AM | 12 | 3X3 | Permit Number 785142 | 6001054.6013 | 2090473.5841 | 37.7201019532463 | -122.438396531841 | (37.7201019532463, -122.438396531841) | 9 | 7 | 6 | 28861 | 25 |
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) );