trees
147 rows where qSpecies_id = 138 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 50279 | 132365 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1 Dicha Aly | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5998327.23711 | 2113735.99188 | 37.7838192833694 | -122.449499349909 | (37.7838192833694, -122.449499349909) | 15 | 6 | 1 | 54 | 31 | |||
| 89795 | 132361 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3455 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998256.93852 | 2115827.32672 | 37.7895575156245 | -122.449893326728 | (37.7895575156245, -122.449893326728) | 13 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 86982 | 132364 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1 Maple St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 5996506.6886 | 2116107.76814 | 37.7902272326358 | -122.455969252601 | (37.7902272326358, -122.455969252601) | 11 | 6 | 1 | 54 | 31 | ||||
| 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 | |
| 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 | |||||
| 86516 | 211436 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 220x Vasquez Ave | 1 | Median : Cutout | Tree | DPW 1 | 34 | Width 6ft | 5994537.09641 | 2099112.75591 | 37.7434501331166 | -122.461551189851 | (37.7434501331166, -122.461551189851) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 164671 | 211450 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 186 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994246.46565 | 2099200.24413 | 37.7436736209515 | -122.462562455004 | (37.7436736209515, -122.462562455004) | 1 | 8 | 4 | 59 | 40 | |||
| 29721 | 211444 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 230 Terrace Walk | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993933.81499 | 2096496.45972 | 37.7362316941337 | -122.463447343823 | (37.7362316941337, -122.463447343823) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 158630 | 211449 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1554 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993091.38036 | 2104901.42473 | 37.759261008817 | -122.466970818352 | (37.759261008817, -122.466970818352) | 1 | 8 | 4 | 56 | 12 | |||
| 185221 | 211447 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 4140 19th Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992076.98829 | 2088316.96105 | 37.7136656526261 | -122.469271936146 | (37.7136656526261, -122.469271936146) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 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 |
| 169303 | 123101 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 507 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992491.93935 | 2111979.13383 | 37.7786598912114 | -122.469559186337 | (37.7786598912114, -122.469559186337) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||
| 19908 | 123898 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992390.46097 | 2114751.88478 | 37.7862672401432 | -122.470112191039 | (37.7862672401432, -122.470112191039) | 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 | |||
| 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 | |||
| 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 | |||
| 109868 | 120792 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 547 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5989370.9651 | 2111615.14329 | 37.7774796059968 | -122.48032907033 | (37.7774796059968, -122.48032907033) | 11 | 6 | 2 | 55 | 26 | |||
| 55531 | 120791 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 539 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5989368.66682 | 2111666.19394 | 37.7776196433358 | -122.480340758299 | (37.7776196433358, -122.480340758299) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 |
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) );