trees
320 rows where qSpecies_id = 145 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194098 | 17635 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 193764 | 68365 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 945 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32186 | 6010298.82314684 | 2116844.8632649 | 37.7930330672197 | -122.408301287665 | (37.7930330672197, -122.408301287665) | 3 | 1 | 10 | 28857 | 4 | ||
| 193306 | 200357 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014316.3111 | 2096732.35884 | 37.7380326962502 | -122.392992601233 | (37.7380326962502, -122.392992601233) | 10 | 3 | 8 | 58 | 1 | |||
| 193074 | 129776 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012790.20467 | 2119250.54506 | 37.7997776901326 | -122.399849916536 | (37.7997776901326, -122.399849916536) | 3 | 1 | 10 | 28860 | 6 | |||
| 191693 | 108433 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222x Cumberland St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004156.24554 | 2104544.03717 | 37.7589121426212 | -122.428677685352 | (37.7589121426212, -122.428677685352) | 2 | 4 | 5 | 28862 | 3 | |
| 191283 | 142921 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 546 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009942.6265 | 2119419.3871 | 37.800082128353 | -122.409715557637 | (37.800082128353, -122.409715557637) | 3 | 1 | 10 | 308 | 23 | |||
| 191015 | 17644 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 190958 | 129820 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012651.85549 | 2117070.09364 | 37.7937829775554 | -122.400175437873 | (37.7937829775554, -122.400175437873) | 4 | 1 | 10 | 28860 | 6 | |||
| 190830 | 228848 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004199.57922 | 2104548.6925 | 37.7589273774242 | -122.428528149056 | (37.7589273774242, -122.428528149056) | 2 | 4 | 5 | 28862 | 3 | |||
| 190315 | 15111 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6013962.82131 | 2116101.4847 | 37.7911964140348 | -122.395571449475 | (37.7911964140348, -122.395571449475) | 12 | 2 | 9 | 28855 | 6 | |||
| 188850 | 49226 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 500 Howard St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 188828 | 129845 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 485 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6011739.20457 | 2118363.85261 | 37.797284398923 | -122.403424371842 | (37.797284398923, -122.403424371842) | 3 | 1 | 10 | 308 | 4 | |||
| 187145 | 129765 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006424.31939 | 2118660.78506 | 37.7978014110634 | -122.421836357588 | (37.7978014110634, -122.421836357588) | 13 | 9 | 10 | 28858 | 32 | |||
| 187134 | 177154 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.7256153880361 | -122.423636416303 | (37.7256153880361, -122.423636416303) | 9 | 7 | 6 | 309 | 5 | |||
| 187111 | 96321 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6011919 | 2120150.9 | 37.8022012393453 | -122.402927984504 | (37.8022012393453, -122.402927984504) | 3 | 1 | 10 | 28860 | 6 | |||
| 186435 | 97169 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 290 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009519.6482 | 2110372.42586 | 37.7752176376301 | -122.410540028225 | (37.7752176376301, -122.410540028225) | 8 | 2 | 9 | 28853 | 34 | |||
| 186238 | 129779 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012731.79119 | 2119371.92723 | 37.8001077197496 | -122.400060579146 | (37.8001077197496, -122.400060579146) | 3 | 1 | 10 | 28860 | 6 | |||
| 186221 | 129792 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011937.51445 | 2120075.46294 | 37.8019951413282 | -122.402858606545 | (37.8019951413282, -122.402858606545) | 3 | 1 | 10 | 28860 | 6 | |||
| 184119 | 228850 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004169.71901 | 2104547.0578 | 37.7589211990752 | -122.428631303115 | (37.7589211990752, -122.428631303115) | 2 | 4 | 5 | 28862 | 3 | |||
| 184001 | 129821 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 504 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012337.50928 | 2117203.47544 | 37.7941316797929 | -122.401272488432 | (37.7941316797929, -122.401272488432) | 3 | 1 | 10 | 28860 | 4 | |||
| 183416 | 50615 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | 2 | 4 | 5 | 28862 | 3 | |||
| 182985 | 200349 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 11 | : | Tree | Private 2 | 8 | Width 4ft | 6014526.62987 | 2097016.75387 | 37.7388252669773 | -122.392285304228 | (37.7388252669773, -122.392285304228) | 10 | 3 | 8 | 58 | 1 | |||
| 182143 | 227934 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1731 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005814.85418 | 2107243.32997 | 37.7664174935056 | -122.423133300469 | (37.7664174935056, -122.423133300469) | 8 | 4 | 5 | 28853 | 19 | |||
| 182062 | 100700 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 7 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 180511 | 200352 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 16 | : | Tree | Private 2 | 14 | Width 5ft | 6014405.80816 | 2096853.92235 | 37.7383714555731 | -122.392691664697 | (37.7383714555731, -122.392691664697) | 10 | 3 | 8 | 58 | 1 | |||
| 180495 | 200337 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 9 | : | Tree | Private 2 | 10 | Width 4ft | 6015484.25752 | 2098301.13552 | 37.7424050435698 | -122.389063899405 | (37.7424050435698, -122.389063899405) | 10 | 3 | 8 | 58 | 1 | |||
| 180476 | 129773 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012883.50017 | 2119263.61 | 37.7998187639863 | -122.399527995233 | (37.7998187639863, -122.399527995233) | 3 | 1 | 10 | 28860 | 6 | |||
| 180124 | 129818 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012648.53437 | 2117119.11483 | 37.7939173929283 | -122.400190373809 | (37.7939173929283, -122.400190373809) | 4 | 1 | 10 | 28860 | 6 | |||
| 179889 | 200347 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 9 | : | Tree | Private 2 | 11 | Width 4ft | 6014556.03183 | 2097054.78425 | 37.7389313231291 | -122.392186304173 | (37.7389313231291, -122.392186304173) | 10 | 3 | 8 | 58 | 1 | |||
| 178875 | 129839 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012727.89407 | 2118536.52905 | 37.7978136994111 | -122.400015365729 | (37.7978136994111, -122.400015365729) | 3 | 1 | 10 | 28860 | 6 | |||
| 178768 | 15113 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6013991.51326 | 2116128.24604 | 37.7912714903321 | -122.395474051105 | (37.7912714903321, -122.395474051105) | 12 | 2 | 9 | 28855 | 6 | |||
| 178568 | 129817 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012643.50693 | 2117148.0023 | 37.793996430738 | -122.400209799159 | (37.793996430738, -122.400209799159) | 4 | 1 | 10 | 28860 | 6 | |||
| 176976 | 129829 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012523.94966 | 2117203.16491 | 37.7941412269928 | -122.400627358876 | (37.7941412269928, -122.400627358876) | 3 | 1 | 10 | 28860 | 4 | |||
| 175740 | 32406 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | 12 | 2 | 9 | 28855 | 6 | |||
| 173894 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 400x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5988116 | 2090625 | 37.7197732605649 | -122.48313145165 | (37.7197732605649, -122.48313145165) | 1 | 8 | 4 | 64 | 14 | |||
| 172376 | 129777 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012748.89649 | 2119266.86751 | 37.7998202046943 | -122.399994005922 | (37.7998202046943, -122.399994005922) | 3 | 1 | 10 | 28860 | 6 | |||
| 171204 | 129782 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012716.05958 | 2119492.70449 | 37.8004384679276 | -122.400123503796 | (37.8004384679276, -122.400123503796) | 3 | 1 | 10 | 28860 | 6 | |||
| 170900 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 4 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 170852 | 51593 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.7736892328814 | -122.448566745533 | (37.7736892328814, -122.448566745533) | 15 | 5 | 11 | 29492 | 16 | |
| 170707 | 200364 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 6 | : | Tree | Private 2 | 13 | Width 5ft | 6014077.79977 | 2096412.7772 | 37.7371419393345 | -122.393794896313 | (37.7371419393345, -122.393794896313) | 10 | 3 | 8 | 58 | 1 | |||
| 168767 | 142327 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999940 | 2110256 | 37.7743562446262 | -122.443669726916 | (37.7743562446262, -122.443669726916) | 15 | 5 | 11 | 29492 | 16 | |||
| 167306 | 200346 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | 10 | 3 | 8 | 58 | 1 | |||
| 166454 | 129833 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012379.77908 | 2117177.70394 | 37.7940632755513 | -122.401124417756 | (37.7940632755513, -122.401124417756) | 3 | 1 | 10 | 28860 | 4 | |||
| 165976 | 50616 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | 2 | 4 | 5 | 28862 | 3 | |||
| 165029 | 129803 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6010302.01456 | 2116853.58579 | 37.7930571958732 | -122.408290860643 | (37.7930571958732, -122.408290860643) | 3 | 1 | 10 | 28857 | 4 | |||
| 164754 | 66490 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 280 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2015 12:00:00 AM | 3 | Permit Number 775748 | 6010181.76408 | 2110999.12752 | 37.7769755118394 | -122.408293821201 | (37.7769755118394, -122.408293821201) | 8 | 2 | 9 | 28853 | 34 | |
| 164665 | 208168 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2590 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991441.45062 | 2097800.63089 | 37.7396687033598 | -122.472159425416 | (37.7396687033598, -122.472159425416) | 1 | 8 | 4 | 29491 | 40 | |||
| 163545 | 96319 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6011919 | 2120150.9 | 37.8022012393453 | -122.402927984504 | (37.8022012393453, -122.402927984504) | 3 | 1 | 10 | 28860 | 6 | |||
| 163498 | 200355 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 19 | : | Tree | Private 2 | 11 | Width 5ft | 6014345.08354 | 2096773.39107 | 37.7381469605042 | -122.392895989784 | (37.7381469605042, -122.392895989784) | 10 | 3 | 8 | 58 | 1 | |||
| 163484 | 208173 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.7443394340168 | -122.460502016448 | (37.7443394340168, -122.460502016448) | 1 | 8 | 4 | 59 | 40 | |||
| 162528 | 15119 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014087.04677 | 2116219.82682 | 37.7915282629576 | -122.395149922854 | (37.7915282629576, -122.395149922854) | 12 | 2 | 9 | 28855 | 6 | |||
| 162059 | 129754 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2407 Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003179.18897 | 2116177.33789 | 37.7907989640458 | -122.432887890589 | (37.7907989640458, -122.432887890589) | 13 | 9 | 1 | 29490 | 27 | |||
| 162056 | 228849 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004184.64448 | 2104547.65023 | 37.7589236704217 | -122.428579726085 | (37.7589236704217, -122.428579726085) | 2 | 4 | 5 | 28862 | 3 | |||
| 161885 | 129848 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012543.75409 | 2118806.63113 | 37.7985450667665 | -122.400671529986 | (37.7985450667665, -122.400671529986) | 3 | 1 | 10 | 28860 | 6 | |||
| 160863 | 129781 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012720.0769 | 2119456.93183 | 37.8003404688016 | -122.40010708848 | (37.8003404688016, -122.40010708848) | 3 | 1 | 10 | 28860 | 6 | |||
| 160698 | 140288 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998467.9884 | 2110034.371 | 37.7736636426957 | -122.44874570038 | (37.7736636426957, -122.44874570038) | 15 | 5 | 11 | 29492 | 16 | |||
| 160674 | 200336 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511 | (37.7424425848476, -122.38903282511) | 10 | 3 | 8 | 58 | 1 | |||
| 158867 | 64146 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 465 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24921 | 6002780.16143913 | 2098575.90057442 | 37.7424470739996 | -122.433010428517 | (37.7424470739996, -122.433010428517) | 2 | 7 | 5 | 63 | 22 | ||
| 158425 | 129805 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6010365.08882 | 2116862.85785 | 37.793086186442 | -122.408073273289 | (37.793086186442, -122.408073273289) | 3 | 1 | 10 | 28857 | 4 | |||
| 158167 | 17659 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 157192 | 129757 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2315 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6003704.65718 | 2116456.32668 | 37.7915947858084 | -122.431089717742 | (37.7915947858084, -122.431089717742) | 13 | 9 | 1 | 29490 | 27 | |||
| 156702 | 200367 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 9 | : | Tree | Private 2 | 17 | Width 5ft | 6014030.85339 | 2096351.68064 | 37.7369715717905 | -122.393952936896 | (37.7369715717905, -122.393952936896) | 10 | 3 | 8 | 58 | 1 | |||
| 156135 | 129772 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012910.45018 | 2119266.99952 | 37.7998295729323 | -122.399434975651 | (37.7998295729323, -122.399434975651) | 3 | 1 | 10 | 28860 | 6 | |||
| 155881 | 108653 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 155747 | 129836 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012782.07244 | 2118635.55361 | 37.7980886176578 | -122.399834849323 | (37.7980886176578, -122.399834849323) | 3 | 1 | 10 | 28860 | 6 | |||
| 155249 | 100145 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
| 154946 | 208171 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 158 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994395.10908 | 2099344.18308 | 37.744077400365 | -122.462058921884 | (37.744077400365, -122.462058921884) | 1 | 8 | 4 | 59 | 40 | |||
| 154440 | 208174 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | 1 | 8 | 4 | 59 | 40 | |||
| 153980 | 7766 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 325X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.422123721721 | (37.7788345313197, -122.422123721721) | 7 | 9 | 11 | 28852 | 10 | |||
| 153804 | 108695 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 511 Alvarado St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | 2 | 4 | 5 | 28862 | 22 | |
| 153275 | 129770 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012963.29649 | 2119273.7997 | 37.7998511899251 | -122.399252584145 | (37.7998511899251, -122.399252584145) | 3 | 1 | 10 | 28860 | 6 | |||
| 151268 | 17647 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 650X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 150690 | 129823 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012601.68821 | 2117444.33686 | 37.7948077631249 | -122.400375321165 | (37.7948077631249, -122.400375321165) | 3 | 1 | 10 | 28860 | 4 | |||
| 150606 | 200358 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 3 | : | Tree | Private 2 | 12 | Width 5ft | 6014239.8641 | 2096632.70057 | 37.7377548084229 | -122.393249946754 | (37.7377548084229, -122.393249946754) | 10 | 3 | 8 | 58 | 1 | |||
| 150172 | 129834 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012777.11642 | 2118676.94706 | 37.7982019978752 | -122.399854906882 | (37.7982019978752, -122.399854906882) | 3 | 1 | 10 | 28860 | 6 | |||
| 150134 | 200363 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 5 | : | Tree | Private 2 | 8 | Width 5ft | 6014137.38405 | 2096492.68968 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | 10 | 3 | 8 | 58 | 1 | |||
| 149516 | 49588 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2333 REVISED Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2003 12:00:00 AM | 16 | Permit Number 46464 | 6003709.90767 | 2116419.21464 | 37.7914931831193 | -122.431068901134 | (37.7914931831193, -122.431068901134) | 13 | 9 | 1 | 29490 | 27 | ||
| 149502 | 129783 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012712.81893 | 2119514.81479 | 37.8004989968021 | -122.400136271497 | (37.8004989968021, -122.400136271497) | 3 | 1 | 10 | 28860 | 6 | |||
| 149057 | 39386 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | 13 | 9 | 1 | 57 | 27 | ||
| 148471 | 108655 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 145404 | 129841 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012688.55113 | 2118531.3338 | 37.7977972409088 | -122.400151139076 | (37.7977972409088, -122.400151139076) | 3 | 1 | 10 | 28860 | 6 | |||
| 145087 | 106001 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015262.44728 | 2104479.57944 | 37.7593574521144 | -122.390262422266 | (37.7593574521144, -122.390262422266) | 10 | 3 | 8 | 28856 | 29 | |||
| 144675 | 108036 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010078.268 | 2119414.52002 | 37.8000763647164 | -122.4092458402 | (37.8000763647164, -122.4092458402) | 3 | 1 | 10 | 308 | 23 | |||||
| 143864 | 142927 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 501 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6011089.2103 | 2118971.3611 | 37.7989161437823 | -122.405716341604 | (37.7989161437823, -122.405716341604) | 3 | 1 | 10 | 308 | 23 | |||
| 143226 | 108037 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010078.268 | 2119414.52002 | 37.8000763647164 | -122.4092458402 | (37.8000763647164, -122.4092458402) | 3 | 1 | 10 | 308 | 23 | |||||
| 143003 | 49225 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 500 Howard St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 142325 | 228852 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004131.71858 | 2104545.14122 | 37.7589137859482 | -122.428762589748 | (37.7589137859482, -122.428762589748) | 2 | 4 | 5 | 28862 | 3 | |||
| 142001 | 29752 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3x3 | 6009988.1989 | 2119378.2609 | 37.7999717596155 | -122.409554954705 | (37.7999717596155, -122.409554954705) | 3 | 1 | 10 | 308 | 23 | |||
| 141939 | 15117 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014044.26076 | 2116180.71375 | 37.7914184881275 | -122.395295221814 | (37.7914184881275, -122.395295221814) | 12 | 2 | 9 | 28855 | 6 | |||
| 141871 | 108654 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 141698 | 129750 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.8002175638503 | -122.441506243943 | (37.8002175638503, -122.441506243943) | 13 | 9 | 1 | 57 | 17 | |||
| 141508 | 200338 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 21 | : | Tree | Private 2 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | 10 | 3 | 8 | 58 | 1 | |||
| 140150 | 129768 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011131.65669 | 2118977.19841 | 37.7989345451634 | -122.405569873672 | (37.7989345451634, -122.405569873672) | 3 | 1 | 10 | 308 | 23 | |||
| 139182 | 106002 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015261.96303 | 2104498.62679 | 37.7594097251897 | -122.390265427813 | (37.7594097251897, -122.390265427813) | 10 | 3 | 8 | 28856 | 29 | |||
| 139160 | 129789 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011950.17532 | 2119985.5388 | 37.8017489384237 | -122.402808465741 | (37.8017489384237, -122.402808465741) | 3 | 1 | 10 | 28860 | 6 | |||
| 137482 | 100694 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 1 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 136630 | 129791 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011942.54079 | 2120045.79904 | 37.8019139721219 | -122.402839125451 | (37.8019139721219, -122.402839125451) | 3 | 1 | 10 | 28860 | 6 | |||
| 136315 | 39385 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000567.4477 | 2117199.73959 | 37.7934577323376 | -122.441997780973 | (37.7934577323376, -122.441997780973) | 13 | 9 | 1 | 57 | 27 | ||
| 136267 | 200360 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 5 | : | Tree | Private 2 | 6 | Width 5ft | 6014196.6239 | 2096573.24629 | 37.737589156905 | -122.393395290662 | (37.737589156905, -122.393395290662) | 10 | 3 | 8 | 58 | 1 | |||
| 135786 | 200342 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 779844 | 6015273.79393 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | 10 | 3 | 8 | 58 | 1 |
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) );