trees
320 rows where qSpecies_id = 145 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49455 | 129816 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 433 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012609.05006 | 2117170.52576 | 37.7940563534572 | -122.400330606896 | (37.7940563534572, -122.400330606896) | 3 | 1 | 10 | 28860 | 6 | |||
| 50047 | 129847 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012509.67235 | 2118803.01279 | 37.798533230779 | -122.400789209861 | (37.798533230779, -122.400789209861) | 3 | 1 | 10 | 28860 | 6 | |||
| 55878 | 129828 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012548.89522 | 2117204.86317 | 37.7941472812331 | -122.400541163364 | (37.7941472812331, -122.400541163364) | 3 | 1 | 10 | 28860 | 4 | |||
| 55981 | 129840 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012708.88892 | 2118533.80702 | 37.7978051657442 | -122.400080938001 | (37.7978051657442, -122.400080938001) | 3 | 1 | 10 | 28860 | 6 | |||
| 57735 | 97618 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012618 | 2117355 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | 3 | 1 | 10 | 28860 | 4 | |||||
| 61782 | 108657 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 62839 | 129795 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011922.61764 | 2120202.56088 | 37.8023432895615 | -122.402919101237 | (37.8023432895615, -122.402919101237) | 3 | 1 | 10 | 28860 | 6 | |||
| 62966 | 108652 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 63039 | 129800 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011900.25036 | 2120353.89385 | 37.8027575640746 | -122.403007153861 | (37.8027575640746, -122.403007153861) | 3 | 1 | 10 | 28860 | 6 | |||
| 65779 | 96326 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 9 | 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 | |||
| 66349 | 129826 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012620.11049 | 2117309.34489 | 37.7944381345611 | -122.400302091187 | (37.7944381345611, -122.400302091187) | 3 | 1 | 10 | 28860 | 4 | |||
| 67026 | 97617 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012618 | 2117355 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | 3 | 1 | 10 | 28860 | 4 | |||||
| 67296 | 129812 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 435 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2018 12:00:00 AM | 3 | Width 3ft | 6012517.23545 | 2117156.65433 | 37.794013145532 | -122.400647322033 | (37.794013145532, -122.400647322033) | 4 | 1 | 10 | 28860 | 6 | ||
| 67848 | 129786 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011965.83445 | 2119897.8199 | 37.8015089579449 | -122.402748105054 | (37.8015089579449, -122.402748105054) | 3 | 1 | 10 | 28860 | 6 | |||
| 72090 | 108651 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 72850 | 129775 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012820.86947 | 2119255.17116 | 37.7997921017684 | -122.399744129295 | (37.7997921017684, -122.399744129295) | 3 | 1 | 10 | 28860 | 6 | |||
| 73571 | 129849 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012584.80341 | 2118810.70115 | 37.7985585314168 | -122.400529771657 | (37.7985585314168, -122.400529771657) | 3 | 1 | 10 | 28860 | 6 | |||
| 73734 | 129810 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 435 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2018 12:00:00 AM | 3 | Width 3ft | 6012477.08259 | 2117150.1123 | 37.7939929431787 | -122.400785796051 | (37.7939929431787, -122.400785796051) | 4 | 1 | 10 | 28860 | 6 | ||
| 75864 | 129793 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011934.29934 | 2120106.56325 | 37.8020803556973 | -122.402871921008 | (37.8020803556973, -122.402871921008) | 3 | 1 | 10 | 28860 | 6 | |||
| 77431 | 108649 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 77678 | 129832 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012451.48028 | 2117191.95794 | 37.7941064133197 | -122.400877324536 | (37.7941064133197, -122.400877324536) | 3 | 1 | 10 | 28860 | 4 | |||
| 81217 | 253611 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012712.81893 | 2119514.81479 | 37.8004989968021 | -122.400136271497 | (37.8004989968021, -122.400136271497) | 3 | 1 | 10 | 28860 | 6 | ||||
| 81266 | 129784 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1600 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6011334.32807 | 2120989.68408 | 37.8044716700829 | -122.405010336152 | (37.8044716700829, -122.405010336152) | 3 | 1 | 10 | 28860 | 6 | |||
| 87581 | 129811 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 435 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012498.50919 | 2117154.1734 | 37.7940052890658 | -122.400711942828 | (37.7940052890658, -122.400711942828) | 4 | 1 | 10 | 28860 | 6 | |||
| 88454 | 129787 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011959.46477 | 2119924.96913 | 37.8015831474946 | -122.402772057584 | (37.8015831474946, -122.402772057584) | 3 | 1 | 10 | 28860 | 6 | |||
| 88776 | 129827 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012617.00039 | 2117213.20404 | 37.7941739812068 | -122.400306096749 | (37.7941739812068, -122.400306096749) | 3 | 1 | 10 | 28860 | 4 | |||
| 89600 | 129814 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 433 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012557.97886 | 2117161.95783 | 37.7940299799473 | -122.400506717522 | (37.7940299799473, -122.400506717522) | 4 | 1 | 10 | 28860 | 6 | |||
| 90481 | 129774 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012849.95348 | 2119259.82939 | 37.7998065134132 | -122.399643814425 | (37.7998065134132, -122.399643814425) | 3 | 1 | 10 | 28860 | 6 | |||
| 90645 | 97619 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012618 | 2117355 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | 3 | 1 | 10 | 28860 | 4 | |||||
| 93331 | 96324 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 7 | 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 | |||
| 108714 | 129843 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012472.98586 | 2118729.74451 | 37.7983300073669 | -122.400911006864 | (37.7983300073669, -122.400911006864) | 3 | 1 | 10 | 28860 | 6 | |||
| 108765 | 129801 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011895.86595 | 2120414.05559 | 37.8029225087266 | -122.403026560337 | (37.8029225087266, -122.403026560337) | 3 | 1 | 10 | 28860 | 6 | |||
| 111169 | 129785 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011966.59622 | 2119867.20019 | 37.8014249261853 | -122.402743314356 | (37.8014249261853, -122.402743314356) | 3 | 1 | 10 | 28860 | 6 | |||
| 111817 | 129819 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012648.9601 | 2117092.83821 | 37.7938452673045 | -122.400187054399 | (37.7938452673045, -122.400187054399) | 4 | 1 | 10 | 28860 | 6 | |||
| 114242 | 129797 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011917.15823 | 2120261.12287 | 37.8025037816892 | -122.402942114884 | (37.8025037816892, -122.402942114884) | 3 | 1 | 10 | 28860 | 6 | |||
| 114612 | 129813 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 435 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2018 12:00:00 AM | 3 | Width 3ft | 6012536.38879 | 2117159.9438 | 37.7940232458398 | -122.400581280298 | (37.7940232458398, -122.400581280298) | 4 | 1 | 10 | 28860 | 6 | ||
| 114811 | 129835 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012779.55401 | 2118654.25305 | 37.7981398214472 | -122.399844877638 | (37.7981398214472, -122.399844877638) | 3 | 1 | 10 | 28860 | 6 | |||
| 115183 | 129780 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012726.99956 | 2119408.50299 | 37.8002078808339 | -122.400079730213 | (37.8002078808339, -122.400079730213) | 3 | 1 | 10 | 28860 | 6 | |||
| 115807 | 129822 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 504 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012331.01864 | 2117278.3358 | 37.7943368663928 | -122.401300210056 | (37.7943368663928, -122.401300210056) | 3 | 1 | 10 | 28860 | 4 | |||
| 116930 | 129788 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011956.16596 | 2119957.68161 | 37.8016727838339 | -122.402785774963 | (37.8016727838339, -122.402785774963) | 3 | 1 | 10 | 28860 | 6 | |||
| 119941 | 129842 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6012477.73931 | 2118700.34341 | 37.7982495441479 | -122.400892491621 | (37.7982495441479, -122.400892491621) | 3 | 1 | 10 | 28860 | 6 | |||
| 123142 | 129844 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012469.34241 | 2118758.90101 | 37.7984098608851 | -122.400925663989 | (37.7984098608851, -122.400925663989) | 3 | 1 | 10 | 28860 | 6 | |||
| 124727 | 129838 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6012789.03405 | 2118594.11911 | 37.7979752365279 | -122.39980784898 | (37.7979752365279, -122.39980784898) | 3 | 1 | 10 | 28860 | 6 | |||
| 125463 | 129830 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012498.4118 | 2117199.54922 | 37.7941298748476 | -122.400715469043 | (37.7941298748476, -122.400715469043) | 3 | 1 | 10 | 28860 | 4 | |||
| 126383 | 108650 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 129470 | 129778 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012744.14452 | 2119292.42038 | 37.7998901017986 | -122.400012245068 | (37.7998901017986, -122.400012245068) | 3 | 1 | 10 | 28860 | 6 | |||
| 131028 | 96322 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 5 | 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 | |||
| 132115 | 129825 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012609.83657 | 2117389.63944 | 37.7946580314036 | -122.400343282842 | (37.7946580314036, -122.400343282842) | 3 | 1 | 10 | 28860 | 4 | |||
| 132394 | 129794 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011926.85553 | 2120176.70877 | 37.802272542593 | -122.402902616671 | (37.802272542593, -122.402902616671) | 3 | 1 | 10 | 28860 | 6 | |||
| 135729 | 65057 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1989 12:00:00 AM | 14 | Permit Number 27011 | 6012481.29964 | 2118678.07069 | 37.7981885871952 | -122.400878606079 | (37.7981885871952, -122.400878606079) | 3 | 1 | 10 | 28860 | 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |||||
| 49670 | 228845 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001290.00365 | 2104097.67072 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | 2 | 4 | 5 | 28862 | 3 | |||
| 53191 | 228841 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000998.7373 | 2101290.13943 | 37.7497985212072 | -122.439364559745 | (37.7497985212072, -122.439364559745) | 2 | 4 | 5 | 28862 | 22 | |||
| 65172 | 228847 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004213.13115 | 2104548.41319 | 37.758927377407 | -122.428481260227 | (37.758927377407, -122.428481260227) | 2 | 4 | 5 | 28862 | 3 | |||
| 76067 | 100146 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
| 78987 | 228846 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | 2 | 4 | 5 | 28862 | 3 | |||
| 102617 | 50617 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
| 112046 | 227938 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 25 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004713.51107 | 2103480.2352 | 37.7560227155946 | -122.426674645426 | (37.7560227155946, -122.426674645426) | 2 | 4 | 5 | 28862 | 22 | |||
| 120354 | 228840 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 104 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004701.59069 | 2103023.11733 | 37.754766903184 | -122.426683319388 | (37.754766903184, -122.426683319388) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 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 | |
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );