trees
320 rows where qSpecies_id = 145 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1024 | 200362 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 3 | : | Tree | Private 2 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.393495590258 | (37.7374749933851, -122.393495590258) | 10 | 3 | 8 | 58 | 1 | |||
| 10946 | 200359 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 5ft | 6014213.14362 | 2096595.32013 | 37.7376506849368 | -122.393339717964 | (37.7376506849368, -122.393339717964) | 10 | 3 | 8 | 58 | 1 | |||
| 32545 | 200348 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 10 | : | Tree | Private 2 | 9 | Width 4ft | 6014546.28219 | 2097041.88556 | 37.738895364638 | -122.392219112326 | (37.738895364638, -122.392219112326) | 10 | 3 | 8 | 58 | 1 | |||
| 34905 | 200353 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 17 | : | Tree | Private 2 | 11 | Width 5ft | 6014392.43301 | 2096834.63166 | 37.738317744462 | -122.392736560653 | (37.738317744462, -122.392736560653) | 10 | 3 | 8 | 58 | 1 | |||
| 39193 | 200350 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 12 | : | Tree | Private 2 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.7387556252824 | -122.392345164903 | (37.7387556252824, -122.392345164903) | 10 | 3 | 8 | 58 | 1 | |||
| 45782 | 200361 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 1 | : | Tree | Private 2 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.393444381967 | (37.7375336444497, -122.393444381967) | 10 | 3 | 8 | 58 | 1 | |||
| 54518 | 200335 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 7 | : | Tree | Purchasing Dept 18 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | 10 | 3 | 8 | 58 | 1 | |||
| 74537 | 200366 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 8 | : | Tree | Private 2 | 12 | Width 5ft | 6014047.10627 | 2096372.45752 | 37.7370295240776 | -122.393898196954 | (37.7370295240776, -122.393898196954) | 10 | 3 | 8 | 58 | 1 | |||
| 76139 | 200345 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 3 | : | Tree | Private 2 | 6 | Width 4ft | 6014658.54117 | 2097192.95407 | 37.7393164002222 | -122.391841530176 | (37.7393164002222, -122.391841530176) | 10 | 3 | 8 | 58 | 1 | |||
| 77597 | 200340 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 23 | : | Tree | Private 2 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.389683204014 | (37.7417134289277, -122.389683204014) | 10 | 3 | 8 | 58 | 1 | |||
| 107333 | 200344 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 40 | : | Tree | Private 2 | 4 | Width 4ft | 6015132.05324 | 2097828.30985 | 37.7410872318817 | -122.390248699517 | (37.7410872318817, -122.390248699517) | 10 | 3 | 8 | 58 | 1 | |||
| 107948 | 200343 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 39 | : | Tree | Private 2 | 8 | Width 4ft | 6015141.18947 | 2097840.20057 | 37.7411203881093 | -122.390217940008 | (37.7411203881093, -122.390217940008) | 10 | 3 | 8 | 58 | 1 | |||
| 114103 | 200341 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 24 | : | Tree | Private 2 | 8 | Width 2ft | 6015282.07626 | 2098027.62068 | 37.7416428186622 | -122.389743887597 | (37.7416428186622, -122.389743887597) | 10 | 3 | 8 | 58 | 1 | |||
| 114333 | 200365 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 7 | : | Tree | Private 2 | 6 | Width 5ft | 6014060.81183 | 2096393.54047 | 37.7370881751809 | -122.393852285648 | (37.7370881751809, -122.393852285648) | 10 | 3 | 8 | 58 | 1 | |||
| 114788 | 200339 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 22 | : | Tree | Private 2 | 5 | Width 2ft | 6015308.33502 | 2098065.16508 | 37.7417473639376 | -122.389655714464 | (37.7417473639376, -122.389655714464) | 10 | 3 | 8 | 58 | 1 | |||
| 132986 | 200334 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 4 | : | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.7425659089002 | -122.388913512973 | (37.7425659089002, -122.388913512973) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 46691 | 258502 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 3321 16th St | 2 | Front Yard : Yard | Tree | Private 2 | 6004551.31558 | 2106568.33958 | 37.7644927464624 | -122.427455559127 | (37.7644927464624, -122.427455559127) | 8 | 4 | 5 | 28862 | 3 | |||||
| 65204 | 100696 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 3 | 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 | |||
| 70762 | 100699 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 6 | 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 | |||
| 73225 | 100695 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 2 | 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 | |||
| 98870 | 100701 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 8 | 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 | |||
| 100518 | 100698 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 5 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 845 | 35702 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 1180 | 35696 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 4161 | 7768 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 325X Fulton St | 3 | 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 | |||
| 4226 | 35703 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 4373 | 35701 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 4732 | 35697 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 4846 | 35692 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 5266 | 35698 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 6671 | 35694 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 6777 | 228843 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 709 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007452.72902 | 2097768.34677 | 37.7404936415683 | -122.416796844595 | (37.7404936415683, -122.416796844595) | 2 | 7 | 7 | 28859 | 2 | |||
| 7472 | 35704 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 8045 | 260674 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
| 8118 | 35693 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 10517 | 129837 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012785.65581 | 2118614.39014 | 37.7980307075983 | -122.399820962885 | (37.7980307075983, -122.399820962885) | 3 | 1 | 10 | 28860 | 6 | |||
| 11205 | 17641 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 11339 | 35700 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 12841 | 260672 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
| 12984 | 38495 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.24733 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) | 13 | 9 | 10 | 28858 | 32 |
| 14526 | 15114 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014005.1464 | 2116140.60731 | 37.7913061897683 | -122.39542774681 | (37.7913061897683, -122.39542774681) | 12 | 2 | 9 | 28855 | 6 | |||
| 14628 | 96325 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768012 | 6011919 | 2120150.9 | 37.8022012393453 | -122.402927984504 | (37.8022012393453, -122.402927984504) | 3 | 1 | 10 | 28860 | 6 | |
| 16053 | 260673 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
| 17394 | 35705 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 17489 | 35695 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 17537 | 35699 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 18253 | 35690 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
| 19163 | 129769 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6013010.632 | 2119281.7619 | 37.7998756901686 | -122.399089343701 | (37.7998756901686, -122.399089343701) | 3 | 1 | 10 | 28860 | 6 | |||
| 19355 | 260675 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
| 19550 | 7767 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 325X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2010 12:00:00 AM | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.422123721721 | (37.7788345313197, -122.422123721721) | 7 | 9 | 11 | 28852 | 10 | |||
| 20881 | 17660 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 5 | 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 | |||
| 22737 | 140286 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998499.0219 | 2110040.6876 | 37.7736827610161 | -122.448638806221 | (37.7736827610161, -122.448638806221) | 15 | 5 | 11 | 29492 | 16 | |||
| 24469 | 227936 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 167 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6004844.7517 | 2099277.52267 | 37.7444904598682 | -122.42592162061 | (37.7444904598682, -122.42592162061) | 2 | 7 | 5 | 63 | 22 | |||
| 24804 | 49224 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 500 Howard St | 13 | 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 | |||
| 26081 | 129751 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2320 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000742.15542 | 2119656.12238 | 37.8002122659526 | -122.441569636242 | (37.8002122659526, -122.441569636242) | 13 | 9 | 1 | 57 | 17 | |||
| 27316 | 108490 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1198 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773696 | 6009647.20295 | 2110306.76017 | 37.7750444852375 | -122.410094148747 | (37.7750444852375, -122.410094148747) | 8 | 2 | 9 | 28853 | 34 |
| 27842 | 15115 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014020.20981 | 2116155.23725 | 37.7913471979732 | -122.395376652733 | (37.7913471979732, -122.395376652733) | 12 | 2 | 9 | 28855 | 6 | |||
| 28094 | 129831 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012476.45918 | 2117195.30949 | 37.7941170091435 | -122.40079112993 | (37.7941170091435, -122.40079112993) | 3 | 1 | 10 | 28860 | 4 | |||
| 28803 | 27659 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014051.97429 | 2116162.83492 | 37.7913698260154 | -122.395267279985 | (37.7913698260154, -122.395267279985) | 12 | 2 | 9 | 28855 | 6 | |||
| 29034 | 129824 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012608.14 | 2117404.20841 | 37.7946979397237 | -122.400350177025 | (37.7946979397237, -122.400350177025) | 3 | 1 | 10 | 28860 | 4 | |||
| 29140 | 108656 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 29654 | 29755 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 532 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3x3 | 6010020.30224 | 2119411.75263 | 37.800065518477 | -122.409446229453 | (37.800065518477, -122.409446229453) | 3 | 1 | 10 | 308 | 23 | |||
| 29799 | 228851 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004146.65332 | 2104546.18314 | 37.7589174920696 | -122.42871101271 | (37.7589174920696, -122.42871101271) | 2 | 4 | 5 | 28862 | 3 | |||
| 30466 | 129799 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011905.71705 | 2120324.12534 | 37.8026761322601 | -122.4029861412 | (37.8026761322601, -122.4029861412) | 3 | 1 | 10 | 28860 | 6 | |||
| 31823 | 97178 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |
| 31986 | 208170 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5996717.7598 | 2107182.54151 | 37.7657330159006 | -122.454593911282 | (37.7657330159006, -122.454593911282) | 15 | 5 | 11 | 29492 | 12 | |||
| 32409 | 39384 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000588.20452 | 2117202.12069 | 37.7934654530274 | -122.441926131987 | (37.7934654530274, -122.441926131987) | 13 | 9 | 1 | 57 | 27 | ||
| 32934 | 129796 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011917.98876 | 2120230.87285 | 37.8024207688713 | -122.402937111974 | (37.8024207688713, -122.402937111974) | 3 | 1 | 10 | 28860 | 6 | |||
| 33465 | 96320 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 3 | 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 | |||
| 33900 | 103111 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 300 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010691 | 2115198.3 | 37.7885339521538 | -122.40682822806 | (37.7885339521538, -122.40682822806) | 5 | 1 | 10 | 28857 | 6 | ||||
| 35332 | 200356 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014331.31299 | 2096752.73935 | 37.7380894902424 | -122.392942157366 | (37.7380894902424, -122.392942157366) | 10 | 3 | 8 | 58 | 1 | |||
| 35348 | 17631 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | ||
| 36379 | 63581 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1360 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 13 | Permit Number 24204 | 6006506.63769 | 2118721.20057 | 37.7979719387185 | -122.421555805959 | (37.7979719387185, -122.421555805959) | 13 | 9 | 10 | 28858 | 32 | |
| 37605 | 228842 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999127.09441 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | 15 | 5 | 5 | 29492 | 9 | |||
| 39344 | 45668 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 46(REVISED) Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 44364 | 6004865.19751473 | 2101080.41704042 | 37.7494419484142 | -122.425979237767 | (37.7494419484142, -122.425979237767) | 2 | 4 | 5 | 28862 | 22 | ||
| 39645 | 140287 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998483.9171 | 2110037.6666 | 37.7736736024147 | -122.448690838206 | (37.7736736024147, -122.448690838206) | 15 | 5 | 11 | 29492 | 16 | |||
| 40742 | 129762 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2222 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006368.54903 | 2118610.8656 | 37.797661199563 | -122.422025790757 | (37.797661199563, -122.422025790757) | 13 | 9 | 10 | 28858 | 32 | |||
| 40856 | 129790 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011945.5166 | 2120015.13463 | 37.8018299412604 | -122.402826669824 | (37.8018299412604, -122.402826669824) | 3 | 1 | 10 | 28860 | 6 | |||
| 40885 | 227937 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 465 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6002968.42227 | 2098587.52799 | 37.7424896769594 | -122.432360309607 | (37.7424896769594, -122.432360309607) | 2 | 7 | 5 | 63 | 22 | |||
| 43501 | 17638 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 8 | 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 | |||
| 44116 | 129771 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012935.02914 | 2119270.4372 | 37.7998403818928 | -122.399350164196 | (37.7998403818928, -122.399350164196) | 3 | 1 | 10 | 28860 | 6 | |||
| 44709 | 96323 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 6 | 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 | |||
| 45676 | 15118 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014060.69419 | 2116194.6265 | 37.7914576032294 | -122.395239337045 | (37.7914576032294, -122.395239337045) | 12 | 2 | 9 | 28855 | 6 |
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) );