trees
147 rows where qSpecies_id = 138 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 171157 | 233959 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 101 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005908.69578 | 2106579.49211 | 37.7646000472828 | -122.422761537821 | (37.7646000472828, -122.422761537821) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 78839 | 233962 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 341 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003741.08663 | 2098630.21283 | 37.7426506619089 | -122.429691709917 | (37.7426506619089, -122.429691709917) | 2 | 7 | 5 | 63 | 22 | |||
| 101306 | 233963 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998658.62775 | 2106938.30224 | 37.7651735242683 | -122.447863309551 | (37.7651735242683, -122.447863309551) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 36806 | 233967 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 26 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998528.05079 | 2106918.36073 | 37.7651113055593 | -122.448313505688 | (37.7651113055593, -122.448313505688) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 154576 | 233974 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002049.59534 | 2107034.31873 | 37.7656303987394 | -122.436141661111 | (37.7656303987394, -122.436141661111) | 15 | 5 | 5 | 28862 | 3 | |||
| 27249 | 233975 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3786 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001886.12679 | 2106432.54375 | 37.7639687834587 | -122.436663982853 | (37.7639687834587, -122.436663982853) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 53162 | 251473 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 32nd Ave | 1 | 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 | |
| 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 | |
| 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 | |
| 163653 | 255505 | Permitted Site 7 | Pittosporum eugenioides :: Tarata 138 | 51 Rosewood Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781973 | 5994862.1784 | 2095632.68066 | 37.7339134131461 | -122.460175070614 | (37.7339134131461, -122.460175070614) | 9 | 8 | 4 | 59 | 40 | |
| 140658 | 26015 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1638 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1997 12:00:00 AM | 3 | 3X3 | 6014725.62148 | 2095748.62781 | 37.7353543002582 | -122.391508646128 | (37.7353543002582, -122.391508646128) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 111577 | 2776 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 331 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 5994564.22313 | 2110735.25562 | 37.775364081338 | -122.462300169147 | (37.775364081338, -122.462300169147) | 11 | 6 | 2 | 54 | 11 | |||
| 138281 | 28135 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 412 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X4 | 6006927.15214 | 2097902.80661 | 37.740833262446 | -122.418623621291 | (37.740833262446, -122.418623621291) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 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 | ||
| 87836 | 52011 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 427 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 48229 | 5984051.86025 | 2112939.27176 | 37.7808047486161 | -122.498827177749 | (37.7808047486161, -122.498827177749) | 11 | 6 | 2 | 55 | 26 | |||
| 110081 | 55823 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1973 12:00:00 AM | 9 | Permit Number 11871 | 5992391.10091 | 2114722.33212 | 37.7861861336889 | -122.470107824331 | (37.7861861336889, -122.470107824331) | 11 | 6 | 2 | 54 | 11 | ||
| 166031 | 62163 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 80 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 11 | Permit Number 22278 | 6000618.37391 | 2092117.41472 | 37.7245907157774 | -122.440022226756 | (37.7245907157774, -122.440022226756) | 9 | 7 | 6 | 28861 | 25 | |
| 82379 | 64213 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1625 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1988 12:00:00 AM | 5 | Permit Number 25004 | 6013920.481 | 2092092.5018 | 37.7252706002708 | -122.394036471321 | (37.7252706002708, -122.394036471321) | 10 | 3 | 8 | 58 | 1 | ||
| 26897 | 81877 | Permitted Site 7 | Pittosporum eugenioides :: Tarata 138 | 1380 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773644 | 5992433.71699481 | 2106077.08224854 | 37.7624510738005 | -122.469330889187 | (37.7624510738005, -122.469330889187) | 1 | 8 | 11 | 56 | 12 |
| 35400 | 919 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1249 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 10:57:00 AM | 3 | 3X3 | 6002980.09082 | 2094114.94313 | 37.7302096448399 | -122.432000656304 | (37.7302096448399, -122.432000656304) | 9 | 7 | 6 | 28861 | 25 | ||
| 93583 | 9335 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 179 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000859.3677258 | 2098666.8406914 | 37.74258763525 | -122.439658461234 | (37.74258763525, -122.439658461234) | 2 | 7 | 5 | 63 | 7 |
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) );