trees
861 rows where qSpecies_id = 18 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5696 | 227632 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 71 Clarendon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997917 | 2104594 | 37.7586942433209 | -122.450259411288 | (37.7586942433209, -122.450259411288) | 15 | 5 | 4 | 28862 | 38 | |||
| 6731 | 227631 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 75 Clarendon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5997891 | 2104591 | 37.7586845181064 | -122.450349114488 | (37.7586845181064, -122.450349114488) | 15 | 5 | 4 | 28862 | 38 | |||
| 47462 | 247480 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.7728446187699 | -122.434043773953 | (37.7728446187699, -122.434043773953) | 15 | 5 | 11 | 29492 | 9 | |||
| 61944 | 207077 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | 1 | 8 | 4 | 29491 | 40 | |||
| 62165 | 227651 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001694.86954 | 2103534.27623 | 37.75599997444 | -122.43711796243 | (37.75599997444, -122.43711796243) | 2 | 4 | 5 | 28862 | 3 | |||
| 81946 | 207074 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994502.24516 | 2100385.66213 | 37.7469432078786 | -122.461763972133 | (37.7469432078786, -122.461763972133) | 1 | 8 | 4 | 29491 | 40 | |||
| 93478 | 129444 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1338 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008418.05988 | 2116953.62618 | 37.7932262072758 | -122.414816555443 | (37.7932262072758, -122.414816555443) | 5 | 1 | 10 | 28858 | 21 | |||
| 102631 | 207098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6000468.8354 | 2095254.59465 | 37.7331961737441 | -122.440764091915 | (37.7331961737441, -122.440764091915) | 9 | 7 | 5 | 63 | 40 | ||||
| 139123 | 129420 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003293.36064 | 2117882.88889 | 37.7954884446923 | -122.432614743086 | (37.7954884446923, -122.432614743086) | 13 | 9 | 1 | 29490 | 27 | |||
| 143341 | 129445 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 24 Priest St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008315.59279 | 2117230.60537 | 37.793980966003 | -122.415190714801 | (37.793980966003, -122.415190714801) | 5 | 1 | 10 | 28858 | 21 | |||
| 157479 | 207076 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | 1 | 8 | 4 | 29491 | 40 | |||
| 188836 | 207073 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994505.45248 | 2100370.55426 | 37.746901910105 | -122.461751786336 | (37.746901910105, -122.461751786336) | 1 | 8 | 4 | 29491 | 40 | |||
| 4194 | 143382 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.7983941790308 | -122.425829789965 | (37.7983941790308, -122.425829789965) | 13 | 9 | 1 | 57 | 17 | |||
| 11467 | 82943 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.58601 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | 8 | 2 | 9 | 28853 | 34 | |
| 24287 | 247479 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002709.4266 | 2109671.5189 | 37.7729089683714 | -122.434047985824 | (37.7729089683714, -122.434047985824) | 15 | 5 | 11 | 29492 | 9 | |||
| 26534 | 227625 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4283 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002039.82763 | 2101169.84079 | 37.749527401673 | -122.435755824069 | (37.749527401673, -122.435755824069) | 2 | 4 | 5 | 28862 | 22 | |||
| 31268 | 30586 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481 | (37.7726573855875, -122.43410610481) | 15 | 5 | 11 | 29492 | 9 | |
| 33337 | 108294 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | |||
| 35814 | 51087 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.420299857748 | (37.7966452201661, -122.420299857748) | 13 | 9 | 10 | 28858 | 32 | ||
| 48165 | 50231 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | 1 | 8 | 3 | 56 | 35 | |
| 48383 | 129395 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3383 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998662.11007 | 2115556.58452 | 37.7888373034598 | -122.448471976104 | (37.7888373034598, -122.448471976104) | 13 | 6 | 1 | 54 | 31 | |||
| 54124 | 129398 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3729 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997021.62902 | 2114999.75252 | 37.7872144597187 | -122.454107547129 | (37.7872144597187, -122.454107547129) | 11 | 6 | 1 | 54 | 31 | |||
| 54297 | 227624 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4283 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002006.21213 | 2101168.55205 | 37.7495219535904 | -122.435871975115 | (37.7495219535904, -122.435871975115) | 2 | 4 | 5 | 28862 | 22 | |||
| 63082 | 191270 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014244.47605 | 2110787.29844 | 37.7766205377503 | -122.394224707529 | (37.7766205377503, -122.394224707529) | 6 | 2 | 9 | 28856 | 20 | |||
| 65178 | 176949 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 59 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012531.85348 | 2087734.51235 | 37.7132271620641 | -122.398531186662 | (37.7132271620641, -122.398531186662) | 10 | 3 | 8 | 309 | 1 | |||
| 74339 | 227660 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 195 Beacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.7397481278718 | -122.431788568281 | (37.7397481278718, -122.431788568281) | 2 | 7 | 5 | 63 | 7 | |||
| 81548 | 227664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006352.61358 | 2109543.15644 | 37.7727626017523 | -122.421436630498 | (37.7727626017523, -122.421436630498) | 8 | 2 | 9 | 28853 | 19 | |||
| 88043 | 191269 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | 6 | 2 | 9 | 28856 | 6 | ||||
| 96564 | 227615 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005000.95492 | 2099622.04361 | 37.7454452619845 | -122.42540601408 | (37.7454452619845, -122.42540601408) | 2 | 7 | 5 | 63 | 22 | |||
| 102200 | 129447 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008246.65377 | 2115911.69756 | 37.7903556945065 | -122.415335839278 | (37.7903556945065, -122.415335839278) | 5 | 1 | 10 | 28858 | 21 | |||
| 108655 | 129419 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003276.06747 | 2117879.65532 | 37.7954785854301 | -122.432674349259 | (37.7954785854301, -122.432674349259) | 13 | 9 | 1 | 29490 | 27 | |||
| 123047 | 176932 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 56 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012552.9526 | 2087748.4178 | 37.7132665190974 | -122.398459235523 | (37.7132665190974, -122.398459235523) | 10 | 3 | 8 | 309 | 1 | |||
| 139715 | 227639 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 326 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6006173.90943 | 2101141.69074 | 37.7496840680694 | -122.42145802088 | (37.7496840680694, -122.42145802088) | 2 | 4 | 5 | 28859 | 19 | |||
| 146895 | 237492 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 211 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003664.29273 | 2100964.29837 | 37.7490551703622 | -122.43012371454 | (37.7490551703622, -122.43012371454) | 2 | 4 | 5 | 28862 | 22 | |||
| 158460 | 227655 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003762.03013 | 2108315.13286 | 37.7692443450787 | -122.430310116133 | (37.7692443450787, -122.430310116133) | 7 | 9 | 5 | 28862 | 3 | |||
| 164304 | 142249 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 619 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004863.0676 | 2110879.3064 | 37.7763472473304 | -122.426684306291 | (37.7763472473304, -122.426684306291) | 7 | 9 | 11 | 28852 | 10 | |||
| 165110 | 44092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.7904857364673 | -122.429415161181 | (37.7904857364673, -122.429415161181) | 13 | 9 | 1 | 29490 | 27 | |
| 170972 | 139749 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 CLEARY CT | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004687.008 | 2113628.2842 | 37.7838853065296 | -122.427489231919 | (37.7838853065296, -122.427489231919) | 7 | 9 | 11 | 28858 | 41 | |||
| 1319 | 227653 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.431282651989 | (37.7563447763019, -122.431282651989) | 2 | 4 | 5 | 28862 | 3 | |||
| 31738 | 207091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 520 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991320.33113 | 2097065.30066 | 37.7376426638631 | -122.47252460502 | (37.7376426638631, -122.47252460502) | 1 | 8 | 4 | 29491 | 40 | |||
| 34048 | 176951 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 63 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012562.34064 | 2087723.35892 | 37.7131982353775 | -122.398425029786 | (37.7131982353775, -122.398425029786) | 10 | 3 | 8 | 309 | 1 | |||
| 43906 | 227618 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009077.39378 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | 10 | 7 | 7 | 28859 | 2 | |||
| 44221 | 176952 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.7132316640827 | -122.398126845197 | (37.7132316640827, -122.398126845197) | 10 | 3 | 8 | 309 | 1 | |||
| 45087 | 114222 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 2x2 | 6012512.59554 | 2087744.07842 | 37.7132523556976 | -122.398598420002 | (37.7132523556976, -122.398598420002) | 10 | 3 | 8 | 309 | 1 | |||
| 50235 | 191277 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014120.49796 | 2110919.75939 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | 6 | 2 | 9 | 28856 | 20 | |||
| 52238 | 244059 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.448006327683 | (37.7708917674934, -122.448006327683) | 15 | 5 | 11 | 29492 | 9 | |||
| 59713 | 35365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | 10 | 3 | 8 | 28856 | 29 | |
| 64446 | 35364 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011875.91601 | 2103641.32434 | 37.7568673633546 | -122.401915842767 | (37.7568673633546, -122.401915842767) | 10 | 3 | 8 | 28856 | 29 | |
| 76260 | 54994 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.27029 | 37.7751993713132 | -122.474798135923 | (37.7751993713132, -122.474798135923) | 11 | 6 | 2 | 54 | 26 | ||
| 77140 | 176941 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 19 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012299.34717 | 2087880.59933 | 37.7136153319601 | -122.39934506234 | (37.7136153319601, -122.39934506234) | 10 | 3 | 8 | 309 | 1 | |||
| 86110 | 101282 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2001 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5989468.7375 | 2106475.7724 | 37.7633739839128 | -122.479614718585 | (37.7633739839128, -122.479614718585) | 1 | 8 | 3 | 56 | 35 | |||
| 92914 | 176945 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 31 Lois Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012378.54553 | 2087831.41605 | 37.7134846982415 | -122.399067872395 | (37.7134846982415, -122.399067872395) | 10 | 3 | 8 | 309 | 1 | |||
| 93109 | 247493 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 806 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | 15 | 5 | 11 | 29492 | 9 | |||
| 93308 | 129397 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3729 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997011.37773 | 2114998.84972 | 37.7872113930486 | -122.454142948961 | (37.7872113930486, -122.454142948961) | 11 | 6 | 1 | 54 | 31 | |||
| 94052 | 247481 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002713.0909 | 2109626.0822 | 37.7727844183865 | -122.434032062031 | (37.7727844183865, -122.434032062031) | 15 | 5 | 11 | 29492 | 9 | |||
| 94275 | 176947 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 39 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012433.06951 | 2087793.94789 | 37.713384856409 | -122.398876788934 | (37.713384856409, -122.398876788934) | 10 | 3 | 8 | 309 | 1 | |||
| 102234 | 176960 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 242 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012452.5611 | 2087695.00166 | 37.7131142557927 | -122.398802478857 | (37.7131142557927, -122.398802478857) | 10 | 3 | 8 | 309 | 1 | |||
| 105173 | 176930 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 78 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012665.08159 | 2087756.95669 | 37.7132962111247 | -122.398072275235 | (37.7132962111247, -122.398072275235) | 10 | 3 | 8 | 309 | 1 | |||
| 106447 | 129408 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003263.17406 | 2116138.42129 | 37.7906968721156 | -122.432594525436 | (37.7906968721156, -122.432594525436) | 13 | 9 | 1 | 29490 | 27 | |||
| 109753 | 54086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.7916772707399 | -122.433147915142 | (37.7916772707399, -122.433147915142) | 13 | 9 | 1 | 29490 | 27 | ||
| 112166 | 176942 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 19 Lois Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012304.75704 | 2087878.11069 | 37.7136088001665 | -122.399326189163 | (37.7136088001665, -122.399326189163) | 10 | 3 | 8 | 309 | 1 | |||
| 115877 | 191267 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6015157.46118 | 2113744.49366 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | 6 | 2 | 9 | 28856 | 6 | ||||
| 119184 | 191279 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014488.65143 | 2110553.2747 | 37.7759915303161 | -122.393363646226 | (37.7759915303161, -122.393363646226) | 6 | 2 | 9 | 28856 | 20 | |||
| 130306 | 129460 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 468 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011856.71365 | 2118087.11906 | 37.7965311177706 | -122.402998283841 | (37.7965311177706, -122.402998283841) | 3 | 1 | 10 | 28860 | 4 | |||
| 131351 | 61519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | 5 | 1 | 1 | 28858 | 32 | ||
| 133271 | 62984 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 7 | Permit Number 33034 | 5984571.8482 | 2106766.3839 | 37.7638862475145 | -122.496572656852 | (37.7638862475145, -122.496572656852) | 1 | 8 | 3 | 56 | 35 | |
| 138875 | 181607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1255 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5987053.8771 | 2106742.5422 | 37.7639658865787 | -122.487986427971 | (37.7639658865787, -122.487986427971) | 1 | 8 | 3 | 56 | 35 | |||
| 144360 | 111668 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3PL | 6004109.02078 | 2116034.23701 | 37.790458739741 | -122.429660507029 | (37.790458739741, -122.429660507029) | 13 | 9 | 1 | 29490 | 27 | |||
| 147267 | 129461 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 468 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011829.88032 | 2118083.51366 | 37.7965197197689 | -122.403090879839 | (37.7965197197689, -122.403090879839) | 3 | 1 | 10 | 28860 | 4 | |||
| 151775 | 176950 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 59 Lois Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012544.33708 | 2087727.46225 | 37.7132084993531 | -122.398487544387 | (37.7132084993531, -122.398487544387) | 10 | 3 | 8 | 309 | 1 | |||
| 175651 | 129401 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | 15 | 6 | 1 | 54 | 31 | |||
| 191951 | 176948 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 43 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012470.82697 | 2087771.09267 | 37.7133242043273 | -122.398744682131 | (37.7133242043273, -122.398744682131) | 10 | 3 | 8 | 309 | 1 | |||
| 132569 | 227622 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221 | (37.748648223551, -122.43700910221) | 2 | 4 | 5 | 28862 | 22 | |||
| 8222 | 240694 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 316 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004685.09774 | 2109764.27844 | 37.7732755894234 | -122.427220510535 | (37.7732755894234, -122.427220510535) | 7 | 9 | 11 | 28852 | 10 | |||
| 8667 | 54838 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.7734387411862 | -122.447706373612 | (37.7734387411862, -122.447706373612) | 15 | 5 | 11 | 29492 | 16 | ||
| 11930 | 4545 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 20925 | 15425 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6006866.3108 | 2106096.3931 | 37.7633275539022 | -122.419415122194 | (37.7633275539022, -122.419415122194) | 8 | 4 | 7 | 28859 | 19 | |||
| 25109 | 25180 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3226 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999422.34121 | 2104738.79635 | 37.7591778511874 | -122.445063681349 | (37.7591778511874, -122.445063681349) | 2 | 4 | 5 | 28862 | 3 | ||
| 29176 | 129412 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003281.29754 | 2115999.00202 | 37.790315090121 | -122.432521856625 | (37.790315090121, -122.432521856625) | 13 | 9 | 1 | 29490 | 27 | |||
| 31494 | 4538 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 32655 | 25179 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3226 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999420.68533 | 2104753.24612 | 37.7592174321694 | -122.445070446966 | (37.7592174321694, -122.445070446966) | 2 | 4 | 5 | 28862 | 3 | ||
| 34535 | 176943 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 19 Lois Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012322.95001 | 2087866.52725 | 37.7135780083003 | -122.399262494668 | (37.7135780083003, -122.399262494668) | 10 | 3 | 8 | 309 | 1 | |||
| 35676 | 66298 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2920 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1990 12:00:00 AM | 6 | 3x3 | Permit Number 29409 | 6014606.2975 | 2089345.5816 | 37.7177661944335 | -122.391473700889 | (37.7177661944335, -122.391473700889) | 10 | 3 | 8 | 58 | 1 | |
| 39091 | 191280 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014475.48285 | 2110565.83203 | 37.7760252782883 | -122.393410079138 | (37.7760252782883, -122.393410079138) | 6 | 2 | 9 | 28856 | 20 | |||
| 39393 | 129411 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003275.40801 | 2116033.98168 | 37.7904108013651 | -122.432544733549 | (37.7904108013651, -122.432544733549) | 13 | 9 | 1 | 29490 | 27 | |||
| 41810 | 191276 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.7769306051104 | -122.394602513603 | (37.7769306051104, -122.394602513603) | 6 | 2 | 9 | 28856 | 20 | |||
| 42036 | 1713 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085 | -122.40074798855 | (37.796643729085, -122.40074798855) | 3 | 1 | 10 | 28860 | 4 | |||
| 42195 | 1714 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.7965506870182 | -122.400732648813 | (37.7965506870182, -122.400732648813) | 3 | 1 | 10 | 28860 | 4 | |||
| 42307 | 4533 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 45 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2016 03:02:00 PM | 6 | 5x5 | 6005057.0165 | 2113679.5647 | 37.7840470307287 | -122.42621279071 | (37.7840470307287, -122.42621279071) | 7 | 9 | 11 | 28858 | 41 | ||
| 42397 | 4516 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
| 51728 | 191273 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014193.41583 | 2110841.84159 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | 6 | 2 | 9 | 28856 | 20 | |||
| 52515 | 191285 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.3938874078 | (37.776017035092, -122.3938874078) | 6 | 2 | 9 | 310 | 20 | |||
| 60028 | 4518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
| 73992 | 191281 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014459.12873 | 2110582.79031 | 37.776070933269 | -122.393467839873 | (37.776070933269, -122.393467839873) | 6 | 2 | 9 | 28856 | 20 | |||
| 75837 | 191287 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014360.2734 | 2110545.30097 | 37.7759625028975 | -122.393807184665 | (37.7759625028975, -122.393807184665) | 6 | 2 | 9 | 310 | 20 | |||
| 76762 | 247478 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002704.2967 | 2109689.8401 | 37.7729589827195 | -122.434067040661 | (37.7729589827195, -122.434067040661) | 15 | 5 | 11 | 29492 | 9 | |||
| 81296 | 191274 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014170.53603 | 2110866.45323 | 37.7768337688053 | -122.394486033405 | (37.7768337688053, -122.394486033405) | 6 | 2 | 9 | 28856 | 20 | |||
| 86008 | 176946 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 33 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012391.32203 | 2087821.98143 | 37.7134595046344 | -122.399023050197 | (37.7134595046344, -122.399023050197) | 10 | 3 | 8 | 309 | 1 | |||
| 86778 | 176920 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 671 London St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6001061.12784 | 2089906.70665 | 37.7185458066272 | -122.438333380903 | (37.7185458066272, -122.438333380903) | 9 | 7 | 6 | 28861 | 5 | ||||
| 94349 | 94202 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232 | 2118962 | 37.7987302484859 | -122.415602598872 | (37.7987302484859, -122.415602598872) | 5 | 1 | 10 | 308 | 32 |
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) );