trees
147 rows where qSpecies_id = 138
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 142731 | 178394 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 25 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001248.99944 | 2093921.66441 | 37.7295806536223 | -122.437971416359 | (37.7295806536223, -122.437971416359) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 152404 | 194580 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.7588376178753 | -122.39630140851 | (37.7588376178753, -122.39630140851) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 162047 | 178397 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 127 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6004928.61246 | 2092474.36136 | 37.7258152443728 | -122.42514766493 | (37.7258152443728, -122.42514766493) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |
| 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 | |||
| 164530 | 211446 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000201.81389 | 2096459.5971 | 37.7364896179085 | -122.441773706798 | (37.7364896179085, -122.441773706798) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 166886 | 132402 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 93 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6008127.0764 | 2119094.13477 | 37.7990871592098 | -122.41597503153 | (37.7990871592098, -122.41597503153) | 5 | 1 | 10 | 308 | 32 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 169974 | 178395 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 61 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003678.4559 | 2093041.21797 | 37.7273010035375 | -122.429509772582 | (37.7273010035375, -122.429509772582) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 |
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) );