trees
320 rows where qSpecies_id = 145 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 48566 | 66847 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 45 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | 2 | Permit Number 30151 | 5998689.6182 | 2110496.1606 | 37.7749442695784 | -122.448012307244 | (37.7749442695784, -122.448012307244) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | |||||
| 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 | |||
| 49701 | 31389 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 1 | 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 | |||
| 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 | |||
| 55858 | 200333 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 903 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015264.35575 | 2104459.34943 | 37.7593020107061 | -122.39025440841 | (37.7593020107061, -122.39025440841) | 10 | 3 | 8 | 28856 | 29 | |||
| 56968 | 143040 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1760 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010444.0727 | 2120551.0606 | 37.8032175128046 | -122.408060206321 | (37.8032175128046, -122.408060206321) | 3 | 1 | 10 | 308 | 23 | |||
| 57571 | 124474 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 344 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996301.59979 | 2110522.81259 | 37.7748806555631 | -122.456274850509 | (37.7748806555631, -122.456274850509) | 11 | 6 | 2 | 54 | 16 | |||
| 58485 | 129758 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 311 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006236.20671 | 2111756.75185 | 37.7788340363914 | -122.421996574482 | (37.7788340363914, -122.421996574482) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||
| 59419 | 228844 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007473.72577 | 2097767.91667 | 37.7404936415809 | -122.416724215363 | (37.7404936415809, -122.416724215363) | 2 | 7 | 7 | 28859 | 2 | |||
| 61012 | 61067 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46064 | 6010044.29985327 | 2119322.50303189 | 37.7998218055895 | -122.409356886218 | (37.7998218055895, -122.409356886218) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 66382 | 129748 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.8002382734424 | -122.441353858292 | (37.8002382734424, -122.441353858292) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||||
| 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 | |||
| 73025 | 64662 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2786 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1989 12:00:00 AM | 14 | 6x4 | Permit Number 26052 | 5999613.31909 | 2118454.39818 | 37.7968482744962 | -122.445389381638 | (37.7968482744962, -122.445389381638) | 13 | 9 | 1 | 57 | 17 | |
| 73344 | 208167 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991441.56701 | 2097783.56953 | 37.7396218639513 | -122.472157779682 | (37.7396218639513, -122.472157779682) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 75159 | 86806 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 76029 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5987665 | 2090646 | 37.7198046658936 | -122.484691919383 | (37.7198046658936, -122.484691919383) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 85481 | 62970 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1827 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 10 | Permit Number 23357 | 6008241.17422 | 2118766.33453 | 37.7981935154844 | -122.415556992457 | (37.7981935154844, -122.415556992457) | 5 | 1 | 10 | 28858 | 21 | |
| 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 | |||
| 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 | |||
| 88892 | 200368 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6014118.97804 | 2116248.97229 | 37.7916100652992 | -122.395041482589 | (37.7916100652992, -122.395041482589) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 95161 | 63072 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23550 | 6007407.20126882 | 2097784.26133742 | 37.7405347785586 | -122.416955389518 | (37.7405347785586, -122.416955389518) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 109468 | 129802 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6010252.4995 | 2116845.85776 | 37.79303320378 | -122.408461640988 | (37.79303320378, -122.408461640988) | 3 | 1 | 10 | 28857 | 4 | |||
| 110687 | 227935 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 705 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6008535.61915 | 2104408.30699 | 37.7587863358342 | -122.413522114462 | (37.7587863358342, -122.413522114462) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 123480 | 129760 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2222 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006381.91218 | 2118496.72963 | 37.7973485646419 | -122.421971438426 | (37.7973485646419, -122.421971438426) | 13 | 9 | 10 | 28858 | 32 | |||
| 126645 | 62971 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 6 | Permit Number 23358 | 6008235.84849 | 2118785.82593 | 37.7982467346621 | -122.415576801855 | (37.7982467346621, -122.415576801855) | 5 | 1 | 10 | 28858 | 21 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||||||||||||||
| 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 | |||
| 51868 | 15120 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014101.62567 | 2116233.31764 | 37.7915661163392 | -122.395100425058 | (37.7915661163392, -122.395100425058) | 12 | 2 | 9 | 28855 | 6 | |||
| 127399 | 200369 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 650 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011472.2786 | 2108553.20224 | 37.7703317423487 | -122.403657370911 | (37.7703317423487, -122.403657370911) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 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 | ||||||||||||||
| 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 | |||
| 96572 | 49230 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 500 Howard St | 11 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||||||||||||
| 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 | |||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 133294 | 200351 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014421.21333 | 2096874.8296 | 37.73842971815 | -122.39263986285 | (37.73842971815, -122.39263986285) | 10 | 3 | 8 | 58 | 1 | |||
| 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 |
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) );