trees
320 rows where qSpecies_id = 145 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | |||
| 52940 | 17658 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 63614 | 17661 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 6 | 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 | |||
| 119788 | 17656 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | ||
| 130244 | 17662 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 113405 | 38388 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1998 12:00:00 AM | 5 | Permit Number 40446 | 6014255.10813 | 2096652.83017 | 37.7378109270327 | -122.393198648518 | (37.7378109270327, -122.393198648518) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
| 67507 | 115305 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1199x KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x5 | 6011077 | 2118941 | 37.7988320967672 | -122.405756453764 | (37.7988320967672, -122.405756453764) | 3 | 1 | 10 | 308 | 23 | ||||
| 93232 | 115306 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1199x KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6011157 | 2118940 | 37.7988338244478 | -122.405479555764 | (37.7988338244478, -122.405479555764) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 47457 | 129798 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011911.92184 | 2120288.00736 | 37.8025773075571 | -122.402962127524 | (37.8025773075571, -122.402962127524) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 69464 | 96318 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6011857 | 2120322 | 37.802667576079 | -122.403154578184 | (37.802667576079, -122.403154578184) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 59314 | 14844 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1327 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/1987 12:00:00 AM | 6 | 3x3 | 6002796.5861 | 2111629.8173 | 37.7782909152526 | -122.43388649175 | (37.7782909152526, -122.43388649175) | 15 | 5 | 11 | 29492 | 41 | ||
| 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 |
| 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 | |
| 69975 | 129767 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1375 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6006477.16604 | 2118669.59087 | 37.7978285696796 | -122.421654118939 | (37.7978285696796, -122.421654118939) | 13 | 9 | 10 | 28858 | 32 | |||
| 85887 | 129766 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1375 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6006461.42741 | 2118668.07402 | 37.7978235173022 | -122.421708471292 | (37.7978235173022, -122.421708471292) | 13 | 9 | 10 | 28858 | 32 | |||
| 66376 | 129763 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1379 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006382.65003 | 2118656.35061 | 37.7977868852004 | -122.421980230217 | (37.7977868852004, -122.421980230217) | 13 | 9 | 10 | 28858 | 32 | |||
| 78811 | 129764 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.421903498241 | (37.7977976222176, -122.421903498241) | 13 | 9 | 10 | 28858 | 32 | |||
| 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 | |||
| 69887 | 142486 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1501 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010093.7913 | 2119417.8989 | 37.8000865119614 | -122.409192361945 | (37.8000865119614, -122.409192361945) | 3 | 1 | 10 | 308 | 23 | |||
| 129427 | 142487 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010095.4595 | 2119399.2703 | 37.8000354558626 | -122.409185274056 | (37.8000354558626, -122.409185274056) | 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 | |||||
| 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 | |||||
| 132689 | 208172 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 154 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994418.09474 | 2099364.41721 | 37.7441342815725 | -122.461980910185 | (37.7441342815725, -122.461980910185) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 49467 | 85037 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | 1 | 8 | 4 | 59 | 40 | |||||
| 60012 | 85038 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | 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 |
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) );