trees
147 rows where qSpecies_id = 138 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 12357 | 178396 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 55 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6003704.97004 | 2093083.05909 | 37.7274173910959 | -122.429421095829 | (37.7274173910959, -122.429421095829) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 52950 | 211445 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000197.7982 | 2096452.6133 | 37.736470213222 | -122.441787089628 | (37.736470213222, -122.441787089628) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 85702 | 132381 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008727.87126 | 2118754.69526 | 37.7981889019448 | -122.413872046978 | (37.7981889019448, -122.413872046978) | 5 | 1 | 10 | 308 | 21 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 91207 | 132384 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005841.24215 | 2119667.51872 | 37.8005327465563 | -122.4239255951 | (37.8005327465563, -122.4239255951) | 13 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 |
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) );