trees
147 rows where qSpecies_id = 138 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44747 | 30819 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 Lippard Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34679 | 6001850.40599 | 2095237.97524 | 37.7332291240165 | -122.435986447137 | (37.7332291240165, -122.435986447137) | 9 | 7 | 5 | 63 | 40 | ||
| 67396 | 194588 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1998 Revere Ave | 9 | : | Tree | Private 2 | 15 | Width 3ft | 6013005.45188 | 2095968.50669 | 37.7358624145277 | -122.397471367135 | (37.7358624145277, -122.397471367135) | 10 | 3 | 8 | 58 | 1 | |||
| 102389 | 132368 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999060.82328 | 2119520.36984 | 37.7997435923452 | -122.44737790227 | (37.7997435923452, -122.44737790227) | 13 | 9 | 1 | 57 | 17 | |||
| 118614 | 132377 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6008207.47508 | 2117062.00893 | 37.7935119650452 | -122.415552871766 | (37.7935119650452, -122.415552871766) | 5 | 1 | 10 | 28858 | 21 | ||||
| 145526 | 26412 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996536.01908 | 2116115.1957 | 37.7902493101054 | -122.455868309095 | (37.7902493101054, -122.455868309095) | 11 | 6 | 1 | 54 | 31 | |||
| 7200 | 26411 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996554.84409 | 2116119.62648 | 37.7902625562289 | -122.455803496757 | (37.7902625562289, -122.455803496757) | 11 | 6 | 1 | 54 | 31 | |||
| 57567 | 194586 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015412.99907 | 2098039.7697 | 37.7416834365362 | -122.389292044817 | (37.7416834365362, -122.389292044817) | 10 | 3 | 8 | 58 | 1 | |||
| 62400 | 132367 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 5999061.27495 | 2119513.94993 | 37.7997259908076 | -122.447375876998 | (37.7997259908076, -122.447375876998) | 13 | 9 | 1 | 57 | 17 | |||
| 126437 | 30820 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 Lippard Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | 7 | Permit Number 34679 | 6001842.2487 | 2095205.88919 | 37.7331405596841 | -122.436012353906 | (37.7331405596841, -122.436012353906) | 9 | 7 | 5 | 63 | 40 | ||
| 45486 | 26410 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996557.37762 | 2116117.21494 | 37.7902560801893 | -122.455794556583 | (37.7902560801893, -122.455794556583) | 11 | 6 | 1 | 54 | 31 | |||
| 70489 | 132376 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6008205.53038 | 2117047.83844 | 37.7934729470596 | -122.41555859686 | (37.7934729470596, -122.41555859686) | 5 | 1 | 10 | 28858 | 21 | ||||
| 103701 | 132390 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005781.12616 | 2119669.33652 | 37.8005343437344 | -122.424133750381 | (37.8005343437344, -122.424133750381) | 13 | 9 | 1 | 28858 | 32 | |||
| 191721 | 132366 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5999060.87332 | 2119508.71315 | 37.7997115890667 | -122.44737688965 | (37.7997115890667, -122.44737688965) | 13 | 9 | 1 | 57 | 17 | |||
| 7343 | 132389 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005789.48501 | 2119659.27806 | 37.8005071977157 | -122.424104109619 | (37.8005071977157, -122.424104109619) | 13 | 9 | 1 | 28858 | 32 | |||
| 105402 | 194585 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015429.91647 | 2098027.47569 | 37.741650617592 | -122.389232691343 | (37.741650617592, -122.389232691343) | 10 | 3 | 8 | 58 | 1 | |||
| 147385 | 132375 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008208.36982 | 2117045.10307 | 37.793465596011 | -122.415548578397 | (37.793465596011, -122.415548578397) | 5 | 1 | 10 | 28858 | 21 | ||||
| 155946 | 26409 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996561.54746 | 2116120.98746 | 37.790266677821 | -122.455780402146 | (37.790266677821, -122.455780402146) | 11 | 6 | 1 | 54 | 31 | |||
| 183720 | 132401 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2745 Larkin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6006539.02476 | 2120646.91478 | 37.8032612878284 | -122.421580578682 | (37.8032612878284, -122.421580578682) | 5 | 9 | 1 | 28858 | 32 | ||||
| 188528 | 178398 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 300 Gaven St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6008862.12496 | 2094845.75943 | 37.7325480233545 | -122.411717230865 | (37.7325480233545, -122.411717230865) | 9 | 3 | 7 | 309 | 28 | |||
| 1832 | 132380 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1680 Taylor St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008764.12173 | 2118820.69014 | 37.7983721433051 | -122.4137512797 | (37.7983721433051, -122.4137512797) | 3 | 1 | 10 | 308 | 21 | |||
| 8454 | 247630 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6009492.89578 | 2096949.07994 | 37.7383586537362 | -122.409684901541 | (37.7383586537362, -122.409684901541) | 10 | 7 | 7 | 28859 | 2 | ||||
| 27218 | 123936 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1 08th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 3ft | 5993306.8177 | 2114889.70076 | 37.7866985773087 | -122.466951883723 | (37.7866985773087, -122.466951883723) | 11 | 6 | 1 | 54 | 11 | |||
| 46550 | 132399 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 5 | Side Yard : Yard | Tree | Private 2 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | 5 | 9 | 1 | 28858 | 32 | ||||
| 81447 | 132374 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008210.17068 | 2117040.38905 | 37.7934527536983 | -122.415542013359 | (37.7934527536983, -122.415542013359) | 5 | 1 | 10 | 28858 | 21 | ||||
| 112854 | 132388 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6005798.70292 | 2119672.07683 | 37.800542860316 | -122.424073122581 | (37.800542860316, -122.424073122581) | 13 | 9 | 1 | 28858 | 32 | |||
| 175166 | 194584 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015435.57046 | 2098024.51696 | 37.7416428069711 | -122.389212935026 | (37.7416428069711, -122.389212935026) | 10 | 3 | 8 | 58 | 1 | |||
| 178657 | 247548 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 815 Buena Vista Ave West | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 6000113.77952 | 2108396.7627 | 37.7692611579062 | -122.442935049924 | (37.7692611579062, -122.442935049924) | 15 | 5 | 11 | 29492 | 9 | |||
| 189760 | 132394 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 6006476.08021 | 2120921.35396 | 37.8040112783592 | -122.421817906176 | (37.8040112783592, -122.421817906176) | 5 | 9 | 1 | 28858 | 32 | ||||
| 8297 | 20395 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 262X Sunset Blvd | 40 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 16054 | 247629 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | 6009493.3855 | 2096955.46231 | 37.7383762057861 | -122.409683658684 | (37.7383762057861, -122.409683658684) | 10 | 7 | 7 | 28859 | 2 | ||||
| 20855 | 132373 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008208.92851 | 2117034.44521 | 37.7934363635562 | -122.415545890356 | (37.7934363635562, -122.415545890356) | 5 | 1 | 10 | 28858 | 21 | ||||
| 38648 | 132379 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1680 Taylor St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6008770.01559 | 2118776.57909 | 37.7982513562644 | -122.413727763334 | (37.7982513562644, -122.413727763334) | 3 | 1 | 10 | 308 | 21 | |||
| 46646 | 132387 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005806.0966 | 2119662.42569 | 37.8005167781868 | -122.424046850703 | (37.8005167781868, -122.424046850703) | 13 | 9 | 1 | 28858 | 32 | |||
| 58819 | 178400 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 802 Excelsior Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6004451.61665 | 2091406.41613 | 37.7228559442383 | -122.426720588195 | (37.7228559442383, -122.426720588195) | 9 | 7 | 6 | 28861 | 5 | |||
| 103490 | 132393 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 4 | Side Yard : Yard | Tree | Private 2 | 17 | 6006475.56322 | 2120927.38496 | 37.8040278087899 | -122.42182012391 | (37.8040278087899, -122.42182012391) | 5 | 9 | 1 | 28858 | 32 | ||||
| 111302 | 122244 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 47 Lake St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990784.64686 | 2114787.26997 | 37.7862714344765 | -122.475670418927 | (37.7862714344765, -122.475670418927) | 11 | 6 | 1 | 54 | 33 | |||
| 111410 | 233970 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 59 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998449.53316 | 2106863.19401 | 37.7649553424266 | -122.448581104347 | (37.7649553424266, -122.448581104347) | 15 | 5 | 11 | 29492 | 9 | |||
| 111427 | 132403 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 93 MacOndray Ln | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6008160.59399 | 2119098.20458 | 37.7991002182567 | -122.415859337341 | (37.7991002182567, -122.415859337341) | 5 | 1 | 10 | 308 | 32 | ||||
| 138698 | 132398 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | 6006507.37075 | 2120957.56173 | 37.8041124601724 | -122.421712196283 | (37.8041124601724, -122.421712196283) | 5 | 9 | 1 | 28858 | 32 | ||||
| 145472 | 233966 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998617.81903 | 2106930.99425 | 37.76515112575 | -122.448003930257 | (37.76515112575, -122.448003930257) | 15 | 5 | 11 | 29492 | 9 | |||
| 166977 | 132406 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2671 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6007315.11916 | 2121861.54657 | 37.8066400884465 | -122.418981073917 | (37.8066400884465, -122.418981073917) | 5 | 1 | 1 | 28858 | 32 | ||||
| 2040 | 194583 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015441.64874 | 2098018.63828 | 37.7416270022859 | -122.389191507809 | (37.7416270022859, -122.389191507809) | 10 | 3 | 8 | 58 | 1 | |||
| 12344 | 247628 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6009493.85882 | 2096962.27736 | 37.7383949449624 | -122.409682503062 | (37.7383949449624, -122.409682503062) | 10 | 7 | 7 | 28859 | 2 | ||||
| 14231 | 178399 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 339 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6004188.88481 | 2091298.12563 | 37.7225437445683 | -122.42762108566 | (37.7225437445683, -122.42762108566) | 9 | 7 | 6 | 28861 | 5 | |||
| 23820 | 251475 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 32nd Ave | 3 | Front Yard : Yard | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659 | 2114437 | 37.7850112101602 | -122.493377758762 | (37.7850112101602, -122.493377758762) | 11 | 6 | 1 | 55 | 33 | |
| 30701 | 233973 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 242 Upper Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5999494.67763 | 2106185.26835 | 37.7631536325665 | -122.444917488449 | (37.7631536325665, -122.444917488449) | 15 | 5 | 5 | 29492 | 9 | |||
| 33095 | 132372 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008211.08199 | 2117028.50784 | 37.793420182046 | -122.415538018574 | (37.793420182046, -122.415538018574) | 5 | 1 | 10 | 28858 | 21 | ||||
| 41291 | 132397 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 3 | Side Yard : Yard | Tree | Private 2 | 16 | 6006502.73263 | 2120950.76111 | 37.8040935258618 | -122.421727763529 | (37.8040935258618, -122.421727763529) | 5 | 9 | 1 | 28858 | 32 | ||||
| 75424 | 233965 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998630.02357 | 2106931.63106 | 37.7651535718969 | -122.447961763741 | (37.7651535718969, -122.447961763741) | 15 | 5 | 11 | 29492 | 9 | |||
| 75786 | 132400 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2745 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6006513.74992 | 2120658.41667 | 37.8032914438996 | -122.421668860656 | (37.8032914438996, -122.421668860656) | 5 | 9 | 1 | 28858 | 32 | ||||
| 86472 | 132386 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005813.32494 | 2119673.13314 | 37.8005465862138 | -122.424022599558 | (37.8005465862138, -122.424022599558) | 13 | 9 | 1 | 28858 | 32 | |||
| 101309 | 132392 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 3 | Side Yard : Yard | Tree | Private 2 | 16 | 6006479.36293 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | 5 | 9 | 1 | 28858 | 32 | ||||
| 104902 | 132383 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008731.67478 | 2118716.17732 | 37.7980833548266 | -122.413856159533 | (37.7980833548266, -122.413856159533) | 5 | 1 | 10 | 308 | 21 | |||
| 106522 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 273 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
| 116106 | 247639 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 360 Bradford St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6009456.29127 | 2096556.43991 | 37.7372784977969 | -122.409783755028 | (37.7372784977969, -122.409783755028) | 10 | 7 | 7 | 28859 | 2 | |||
| 130439 | 233969 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 59 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998431.96444 | 2106860.62027 | 37.7649472710115 | -122.448641684483 | (37.7649472710115, -122.448641684483) | 15 | 5 | 11 | 29492 | 9 | |||
| 140645 | 249601 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2200 Golden Gate Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5998898.09787 | 2111497.4092 | 37.7777053557513 | -122.447363215433 | (37.7777053557513, -122.447363215433) | 15 | 6 | 2 | 54 | 16 | |||
| 150829 | 132405 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2671 Leavenworth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6007317.65081 | 2121868.01026 | 37.8066579786473 | -122.418972771382 | (37.8066579786473, -122.418972771382) | 5 | 1 | 1 | 28858 | 32 | ||||
| 184853 | 122245 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 47 Lake St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990779.80056 | 2114787.3723 | 37.7862714344884 | -122.475687193172 | (37.7862714344884, -122.475687193172) | 11 | 6 | 1 | 54 | 33 | |||
| 131137 | 211443 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 29 | Median : Yard | Tree | DPW 1 | 15 | 5993804.85557 | 2096543.20667 | 37.7363526187711 | -122.463896598346 | (37.7363526187711, -122.463896598346) | 1 | 8 | 4 | 59 | 40 | ||||
| 119809 | 211442 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 28 | Median : Yard | Tree | DPW 1 | 10 | 5993811.3668 | 2096539.98499 | 37.7363441480681 | -122.463873852703 | (37.7363441480681, -122.463873852703) | 1 | 8 | 4 | 59 | 40 | ||||
| 51257 | 211441 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 27 | Median : Yard | Tree | DPW 1 | 7 | 5993812.00301 | 2096546.48985 | 37.7363620454614 | -122.463872125093 | (37.7363620454614, -122.463872125093) | 1 | 8 | 4 | 59 | 40 | ||||
| 103817 | 211440 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 26 | Median : Yard | Tree | DPW 1 | 10 | 5993816.62133 | 2096536.73465 | 37.7363355262473 | -122.463855449888 | (37.7363355262473, -122.463855449888) | 1 | 8 | 4 | 59 | 40 | ||||
| 109713 | 211439 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 25 | Median : Yard | Tree | DPW 1 | 10 | 5993818.11195 | 2096542.33136 | 37.7363509793232 | -122.463850702347 | (37.7363509793232, -122.463850702347) | 1 | 8 | 4 | 59 | 40 | ||||
| 772 | 132391 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 2 | Side Yard : Yard | Tree | Private 2 | 31 | 6006489.42377 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | 5 | 9 | 1 | 28858 | 32 | ||||
| 6178 | 247627 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6009494.82009 | 2096968.41626 | 37.7384118549208 | -122.409679612627 | (37.7384118549208, -122.409679612627) | 10 | 7 | 7 | 28859 | 2 | ||||
| 7497 | 132404 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2671 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6007312.64985 | 2121879.37275 | 37.8066888955423 | -122.418990884623 | (37.8066888955423, -122.418990884623) | 5 | 1 | 1 | 28858 | 32 | ||||
| 7920 | 194579 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 588 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013514.83137 | 2104327.63621 | 37.7588431577105 | -122.396295924418 | (37.7588431577105, -122.396295924418) | 10 | 3 | 8 | 28856 | 29 | |||
| 8856 | 194577 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 580 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6013511.64038 | 2104375.7087 | 37.7589749767275 | -122.396310329764 | (37.7589749767275, -122.396310329764) | 10 | 3 | 8 | 28856 | 29 | |||
| 44431 | 178393 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 73 Capistrano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6001400.33163 | 2093764.09074 | 37.7291565971988 | -122.437436967259 | (37.7291565971988, -122.437436967259) | 9 | 7 | 6 | 28861 | 25 | ||||
| 54264 | 194578 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 586 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013510.77458 | 2104373.03233 | 37.7589675798212 | -122.396313136545 | (37.7589675798212, -122.396313136545) | 10 | 3 | 8 | 28856 | 29 | |||
| 70730 | 132371 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6008212.29618 | 2117019.56331 | 37.7933956908179 | -122.415533183814 | (37.7933956908179, -122.415533183814) | 5 | 1 | 10 | 28858 | 21 | ||||
| 71260 | 233964 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998642.1251 | 2106932.60313 | 37.7651569326801 | -122.447919977648 | (37.7651569326801, -122.447919977648) | 15 | 5 | 11 | 29492 | 9 | |||
| 90214 | 233968 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 59 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998414.25263 | 2106859.15364 | 37.7649422312277 | -122.448702839263 | (37.7649422312277, -122.448702839263) | 15 | 5 | 11 | 29492 | 9 | |||
| 101257 | 200714 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1494 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015811.8614 | 2095290.2381 | 37.7341558860556 | -122.387721105608 | (37.7341558860556, -122.387721105608) | 10 | 3 | 8 | 58 | 1 | |||
| 105710 | 211435 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 29 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992967.24158 | 2098952.48262 | 37.7429195780791 | -122.466967656341 | (37.7429195780791, -122.466967656341) | 1 | 8 | 4 | 59 | 40 | |||
| 105760 | 132396 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 2 | Side Yard : Yard | Tree | Private 2 | 40 | 6006504.32212 | 2120945.10898 | 37.8040780961887 | -122.421721861273 | (37.8040780961887, -122.421721861273) | 5 | 9 | 1 | 28858 | 32 | ||||
| 107243 | 251474 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 32nd Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659 | 2114437 | 37.7850112101602 | -122.493377758762 | (37.7850112101602, -122.493377758762) | 11 | 6 | 1 | 55 | 33 | |
| 122667 | 233960 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 329 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009458.35232 | 2099567.98952 | 37.7455476723052 | -122.409989165578 | (37.7455476723052, -122.409989165578) | 2 | 7 | 7 | 28859 | 2 | |||
| 122832 | 233961 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 107 Valley St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6005126.40352 | 2099291.88165 | 37.744545799654 | -122.424948746605 | (37.744545799654, -122.424948746605) | 2 | 7 | 5 | 63 | 22 | |||
| 127358 | 211448 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 4140 19th Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5992076.26551 | 2088333.24605 | 37.7137103255345 | -122.469275618901 | (37.7137103255345, -122.469275618901) | 9 | 8 | 6 | 64 | 24 | |||
| 133149 | 132362 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3455 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998243.11414 | 2115825.02859 | 37.7895504145686 | -122.449940991703 | (37.7895504145686, -122.449940991703) | 13 | 6 | 1 | 54 | 31 | |||
| 135405 | 132385 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6005829.91288 | 2119675.1182 | 37.8005529731893 | -122.423965339721 | (37.8005529731893, -122.423965339721) | 13 | 9 | 1 | 28858 | 32 | |||
| 138004 | 194575 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 568 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013510.83994 | 2104426.47875 | 37.7591143356749 | -122.396316656512 | (37.7591143356749, -122.396316656512) | 10 | 3 | 8 | 28856 | 29 | |||
| 148763 | 123354 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 706 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994755.71822 | 2110691.45516 | 37.7752548415612 | -122.461634571421 | (37.7752548415612, -122.461634571421) | 11 | 6 | 2 | 54 | 11 | |||
| 150075 | 211434 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 910 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5992028.49384 | 2105269.75757 | 37.7602109483078 | -122.470673588023 | (37.7602109483078, -122.470673588023) | 1 | 8 | 4 | 56 | 12 | |||
| 165064 | 132360 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2801 Pierce St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6001534.76184 | 2118041.80057 | 37.7958248873699 | -122.43871117439 | (37.7958248873699, -122.43871117439) | 13 | 9 | 1 | 57 | 17 | |||
| 167221 | 233972 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 242 Upper Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999499.27806 | 2106191.48034 | 37.7631709516944 | -122.444902023732 | (37.7631709516944, -122.444902023732) | 15 | 5 | 5 | 29492 | 9 | |||
| 177641 | 132363 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1 Maple St | 2 | Front Yard : Yard | Tree | Private 2 | 19 | 5996514.49254 | 2116105.13934 | 37.7902204625654 | -122.455942061589 | (37.7902204625654, -122.455942061589) | 11 | 6 | 1 | 54 | 31 | ||||
| 187031 | 132382 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008728.03476 | 2118737.75818 | 37.7981424061004 | -122.413870282493 | (37.7981424061004, -122.413870282493) | 5 | 1 | 10 | 308 | 21 | |||
| 67029 | 187083 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2600 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985170.5104 | 2097012.8962 | 37.7371408955553 | -122.493783302335 | (37.7371408955553, -122.493783302335) | 1 | 8 | 3 | 29491 | 35 | |||
| 150851 | 211438 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 18 | Median : Yard | Tree | DPW 1 | 14 | 5993827.4148 | 2096523.27288 | 37.736299185562 | -122.463817155848 | (37.736299185562, -122.463817155848) | 1 | 8 | 4 | 59 | 40 | ||||
| 122568 | 194589 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 11 Bridgeview Way | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6016121.54622 | 2108188.95403 | 37.7695902108346 | -122.387549998659 | (37.7695902108346, -122.387549998659) | 14 | 3 | 9 | 310 | 20 | ||||
| 163790 | 211452 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 Lippard Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001868.44075 | 2095314.06759 | 37.7334390806456 | -122.435929538915 | (37.7334390806456, -122.435929538915) | 9 | 7 | 5 | 63 | 40 | |||
| 137648 | 211437 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 200x Terrace Dr | 13 | Median : Yard | Tree | DPW 1 | 15 | 5993819.38034 | 2096502.32779 | 37.7362412125478 | -122.463843414267 | (37.7362412125478, -122.463843414267) | 1 | 8 | 4 | 59 | 40 | ||||
| 127832 | 211451 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 Lippard Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001863.37782 | 2095280.79376 | 37.7333474307441 | -122.435944662819 | (37.7333474307441, -122.435944662819) | 9 | 7 | 5 | 63 | 40 | |||
| 168549 | 132378 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008205.50053 | 2117066.58011 | 37.7935244053907 | -122.415560027676 | (37.7935244053907, -122.415560027676) | 5 | 1 | 10 | 28858 | 21 | ||||
| 173279 | 132369 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 5999059.80174 | 2119527.53037 | 37.7997631948618 | -122.447381952832 | (37.7997631948618, -122.447381952832) | 13 | 9 | 1 | 57 | 17 | |||
| 3358 | 233971 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 175 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999325.70012 | 2106527.04149 | 37.7640824109973 | -122.44552650036 | (37.7640824109973, -122.44552650036) | 15 | 5 | 5 | 29492 | 9 | |||
| 4207 | 247626 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6009494.96271 | 2096975.40444 | 37.7384310509429 | -122.409679612625 | (37.7384310509429, -122.409679612625) | 10 | 7 | 7 | 28859 | 2 |
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) );