trees
147 rows where qSpecies_id = 138 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 8297 | 20395 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 262X Sunset Blvd | 40 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 |
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) );