trees
2,694 rows where qSpecies_id = 84 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
112245 | 42078 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | 2 | 7 | 7 | 28859 | 2 | ||
166777 | 42077 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | 2 | 7 | 7 | 28859 | 2 | ||
106164 | 46168 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.456659588364 | (37.7648158648531, -122.456659588364) | 15 | 5 | 11 | 29492 | 12 | ||
153005 | 42079 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42389 | 6009265.41363365 | 2099503.07167939 | 37.7453586067376 | -122.410651736773 | (37.7453586067376, -122.410651736773) | 2 | 7 | 7 | 28859 | 2 | ||
78261 | 250308 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10 Redfield Aly | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.414769923808 | (37.8002391853351, -122.414769923808) | 5 | 1 | 10 | 308 | 32 | |||
56370 | 88522 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 10 Valdez Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417 | 2093827.6 | 37.7290464055545 | -122.454669245202 | (37.7290464055545, -122.454669245202) | 9 | 7 | 4 | 28861 | 40 | |||
47035 | 47713 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | 2 | 7 | 5 | 63 | 7 | ||
58343 | 47712 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | 2 | 7 | 5 | 63 | 7 | ||
74282 | 47714 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | 2 | 7 | 5 | 63 | 7 | ||
107135 | 42815 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42760 | 6001684.72316119 | 2105247.9392865 | 37.760704701255 | -122.437275750105 | (37.760704701255, -122.437275750105) | 2 | 4 | 5 | 28862 | 3 | ||
62448 | 11188 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995291.08877 | 2099424.10153 | 37.7443483813689 | -122.458966630003 | (37.7443483813689, -122.458966630003) | 1 | 8 | 4 | 59 | 40 | |||
83697 | 11186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | 1 | 8 | 4 | 59 | 40 | |||
151183 | 121666 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993653 | 2099666 | 37.7449182738718 | -122.464648312953 | (37.7449182738718, -122.464648312953) | 1 | 8 | 4 | 29491 | 40 | ||||
129951 | 34419 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38167 | 6003358.09011166 | 2096226.49076231 | 37.7360288984966 | -122.430844496116 | (37.7360288984966, -122.430844496116) | 2 | 7 | 5 | 63 | 7 | ||
131572 | 237981 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003493.73736 | 2095146.10486 | 37.7330700888164 | -122.43029845283 | (37.7330700888164, -122.43029845283) | 9 | 7 | 5 | 28861 | 25 | |||
43412 | 49133 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | 9 | 7 | 4 | 28861 | 40 | |||
94762 | 49134 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100 Valdez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | 9 | 7 | 4 | 28861 | 40 | |||
122444 | 41855 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1001 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | 1 | 8 | 4 | 56 | 12 | ||
162890 | 41858 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1001 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | 1 | 8 | 4 | 56 | 12 | ||
163485 | 41857 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1001 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | 1 | 8 | 4 | 56 | 12 | ||
185723 | 41856 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1001 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | 1 | 8 | 4 | 56 | 12 | ||
9552 | 139978 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | 15 | 5 | 11 | 29490 | 41 | |||
78281 | 115487 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1004 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003744 | 2102383 | 37.7529551066007 | -122.4299492716 | (37.7529551066007, -122.4299492716) | 2 | 4 | 5 | 28862 | 22 | ||||
38683 | 65210 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1008 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27196 | 6003122.02248491 | 2102364.94475265 | 37.7528702875206 | -122.432098897252 | (37.7528702875206, -122.432098897252) | 2 | 4 | 5 | 28862 | 22 | ||
184986 | 53023 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 100@ DEWEY Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2006 12:00:00 AM | Permit Number 49002 | 5994618.97974152 | 2099903.5858652 | 37.7456262668668 | -122.461325376527 | (37.7456262668668, -122.461325376527) | 1 | 8 | 4 | 29491 | 40 | |||
132799 | 214408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Idora Ave | 20 | Median : Yard | Tree | DPW 1 | 3 | Width 9ft | 5995751.65358 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | 1 | 8 | 4 | 59 | 40 | |||
42803 | 115684 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
100482 | 115686 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
149513 | 115687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
181373 | 115685 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
72693 | 16604 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778401 | 6002878.7558281 | 2107677.2386142 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | 15 | 5 | 5 | 28862 | 3 | |
85666 | 36557 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39427 | 6008880.2941613 | 2098058.52124465 | 37.7413705893714 | -122.411881362374 | (37.7413705893714, -122.411881362374) | 10 | 7 | 7 | 28859 | 2 | ||
22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
165564 | 40228 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
96137 | 121759 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015338 | 2103772 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | 10 | 3 | 8 | 28856 | 29 | ||||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
85007 | 34536 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38245 | 6009539.66453921 | 2097997.54688011 | 37.7412401371814 | -122.409597177582 | (37.7412401371814, -122.409597177582) | 10 | 7 | 7 | 28859 | 2 | ||
38556 | 196406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | 10 | 3 | 8 | 28856 | 29 | |||
71336 | 37016 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1024 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39629 | 6008593.31384349 | 2102571.16222478 | 37.7537451924393 | -122.413192669543 | (37.7537451924393, -122.413192669543) | 2 | 4 | 7 | 28859 | 19 | ||
80400 | 88253 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1025 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131 | 2106547 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | 15 | 5 | 11 | 29492 | 9 | |||
178074 | 39191 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40844 | 6008645.24325538 | 2102573.87076335 | 37.7537555446899 | -122.413013276733 | (37.7537555446899, -122.413013276733) | 2 | 4 | 7 | 28859 | 19 | ||
48523 | 178872 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003905.75349 | 2089465.86318 | 37.7174967348674 | -122.428469272232 | (37.7174967348674, -122.428469272232) | 9 | 7 | 6 | 28861 | 5 | |||
189468 | 178873 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003894.97731 | 2089471.28937 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | 9 | 7 | 6 | 28861 | 5 | |||
29518 | 88278 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
42192 | 88277 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Aptos Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062 | 2093861.6 | 37.7289467548913 | -122.466270114229 | (37.7289467548913, -122.466270114229) | 9 | 8 | 4 | 59 | 40 | |||
18391 | 214451 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | 1 | 8 | 4 | 29491 | 40 | |||
74508 | 84214 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Tucker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.5804163 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | 9 | 7 | 8 | 309 | 39 | ||
133866 | 84224 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.5804163 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | 9 | 7 | 8 | 309 | 39 | ||
152362 | 116779 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650 | 2118281 | 37.7968838784408 | -122.414107975451 | (37.7968838784408, -122.414107975451) | 5 | 1 | 10 | 308 | 21 | ||
90801 | 199985 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.7257158363369 | -122.379428312297 | (37.7257158363369, -122.379428312297) | 10 | 3 | 8 | 58 | 1 | |||
36812 | 95528 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) | 1 | 8 | 3 | 29491 | 35 |
41559 | 135907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | 5 | 1 | 1 | 308 | 32 | |||
53150 | 48870 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46813 | 5992505.4658098 | 2098397.03654372 | 37.7413678003574 | -122.468523930768 | (37.7413678003574, -122.468523930768) | 1 | 8 | 4 | 59 | 40 | ||
177326 | 62195 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 105 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1985 12:00:00 AM | Permit Number 22314 | 6000493.57908868 | 2092148.88322612 | 37.7246700159736 | -122.440455881068 | (37.7246700159736, -122.440455881068) | 9 | 7 | 6 | 28861 | 25 | ||
68939 | 43903 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1050 York St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.7552328939148 | -122.408509176777 | (37.7552328939148, -122.408509176777) | 2 | 4 | 7 | 28859 | 19 | |
109017 | 43904 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1050 York St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.7552328939148 | -122.408509176777 | (37.7552328939148, -122.408509176777) | 2 | 4 | 7 | 28859 | 19 |
193697 | 43905 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1050 York St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.7552328939148 | -122.408509176777 | (37.7552328939148, -122.408509176777) | 2 | 4 | 7 | 28859 | 19 |
110828 | 62849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23217 | 6008647.40750977 | 2098052.96381421 | 37.7413422616597 | -122.412686213201 | (37.7413422616597, -122.412686213201) | 10 | 7 | 7 | 28859 | 2 | ||
141066 | 36347 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39309 | 5995651.79090977 | 2093374.88380892 | 37.7277594354695 | -122.457281878498 | (37.7277594354695, -122.457281878498) | 9 | 7 | 4 | 28861 | 40 | ||
90421 | 26790 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | 9 | 7 | 8 | 309 | 39 | ||
36790 | 32384 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | 2 | 7 | 7 | 28859 | 2 | |||
69390 | 32381 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Park St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | 2 | 7 | 7 | 28859 | 2 | |||
143664 | 32382 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | 2 | 7 | 7 | 28859 | 2 | |||
150020 | 32383 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | 2 | 7 | 7 | 28859 | 2 | |||
164966 | 63019 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1986 12:00:00 AM | Permit Number 23434 | 6007356.32584056 | 2097719.32736654 | 37.740353622343 | -122.417126697503 | (37.740353622343, -122.417126697503) | 2 | 7 | 7 | 28859 | 2 | ||
21001 | 37006 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.7548622220933 | -122.411084752447 | (37.7548622220933, -122.411084752447) | 2 | 4 | 7 | 28859 | 19 | ||
35498 | 36349 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | 9 | 7 | 4 | 28861 | 40 | ||
57926 | 36348 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | 9 | 7 | 4 | 28861 | 40 | ||
53697 | 95012 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 107 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | 3 | 3x3 | 6010407.8674 | 2087313.2581 | 37.7119519253908 | -122.405842790713 | (37.7119519253908, -122.405842790713) | 9 | 7 | 8 | 309 | 39 | ||
145864 | 16607 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 107 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6002880.6418591 | 2107642.9841193 | 37.7673488254303 | -122.433310753696 | (37.7673488254303, -122.433310753696) | 15 | 5 | 5 | 28862 | 3 | |||
66725 | 51430 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1070 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47751 | 6007408.58996673 | 2101077.89386609 | 37.7495784341832 | -122.417183917873 | (37.7495784341832, -122.417183917873) | 2 | 4 | 7 | 28859 | 19 | |||
155292 | 51429 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1070 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47751 | 6007408.58996673 | 2101077.89386609 | 37.7495784341832 | -122.417183917873 | (37.7495784341832, -122.417183917873) | 2 | 4 | 7 | 28859 | 19 | |||
110926 | 37007 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1071 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39621 | 6009212.75104301 | 2102931.76923387 | 37.7547700944461 | -122.411075976411 | (37.7547700944461, -122.411075976411) | 2 | 4 | 7 | 28859 | 19 | ||
68043 | 245135 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 108 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000350.1465 | 2109371.4561 | 37.7719508943795 | -122.442187448391 | (37.7719508943795, -122.442187448391) | 15 | 5 | 11 | 29492 | 9 | |||
22144 | 39140 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1084 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40818 | 6007412.89120014 | 2100999.62033196 | 37.749363754725 | -122.417163498301 | (37.749363754725, -122.417163498301) | 2 | 4 | 7 | 28859 | 19 | ||
27605 | 178906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009976.78188 | 2089389.92306 | 37.7176299046612 | -122.407479066904 | (37.7176299046612, -122.407479066904) | 9 | 7 | 8 | 309 | 39 | |||
25815 | 27759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.8179102 | 2101113.2850563 | 37.750139234821 | -122.388473299437 | (37.750139234821, -122.388473299437) | 10 | 3 | 8 | 58 | 1 | ||
14432 | 178904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011792.88406 | 2090769.73397 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | 10 | 3 | 8 | 309 | 28 | |||
58755 | 178902 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.7214973572857 | -122.401224985361 | (37.7214973572857, -122.401224985361) | 10 | 3 | 8 | 309 | 28 | |||
147402 | 178903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011814.45609 | 2090752.08936 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | 10 | 7 | 8 | 309 | 28 | |||
99333 | 67117 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 110 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30537 | 5998254.46044174 | 2105394.41401324 | 37.7609112863716 | -122.449149986975 | (37.7609112863716, -122.449149986975) | 15 | 5 | 11 | 29492 | 12 | ||
28270 | 26791 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.7120981579726 | -122.405883520018 | (37.7120981579726, -122.405883520018) | 9 | 7 | 8 | 309 | 39 | ||
77038 | 45127 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 110 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2001 12:00:00 AM | Permit Number 43984 | 6000366.86976442 | 2109279.71080278 | 37.7716999379516 | -122.442123014739 | (37.7716999379516, -122.442123014739) | 15 | 5 | 11 | 29492 | 9 | ||
39995 | 65245 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1106 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28039 | 6009173.38165211 | 2102703.44295541 | 37.7541409539447 | -122.411195999264 | (37.7541409539447, -122.411195999264) | 2 | 4 | 7 | 28859 | 19 | ||
21420 | 47310 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | 10 | 4 | 7 | 28859 | 19 | ||
101593 | 40468 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 111 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41553 | 5997316.73360061 | 2089179.17157647 | 37.7163344773044 | -122.451223710036 | (37.7163344773044, -122.451223710036) | 9 | 8 | 6 | 28861 | 24 | ||
172288 | 45132 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1114 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43991 | 6001218.6094792 | 2109380.86443699 | 37.7720261837752 | -122.439184051701 | (37.7720261837752, -122.439184051701) | 15 | 5 | 11 | 29492 | 9 | ||
81137 | 245099 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1116 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001200.4602 | 2109374.4683 | 37.7720075888162 | -122.439246372799 | (37.7720075888162, -122.439246372799) | 15 | 5 | 11 | 29492 | 9 | |||
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 |
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) );