trees
11,761 rows where qSpecies_id = 17 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
8305 | 86762 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
27177 | 101951 | Property Tree 8 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard | Tree | Private 2 | 6003106 | 2094969 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | 9 | 7 | 5 | 28861 | 25 | ||||||
49179 | 86765 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
58275 | 86763 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
73349 | 86764 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
86075 | 100243 | Private 9 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard | Tree | Private 2 | 6008043 | 2100485 | 37.7479861507453 | -122.414948142067 | (37.7479861507453, -122.414948142067) | 2 | 7 | 7 | 28859 | 2 | ||||||
127770 | 86766 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
139334 | 105664 | Undocumented 4 | Tree(s) :: 17 | 317X DORADO TER | 1 | unknown : Yard | Tree | Private 2 | 10 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
149978 | 200176 | DPW Maintained 1 | Tree(s) :: 17 | 1047 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | |||
161613 | 86767 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
172705 | 185485 | DPW Maintained 1 | Tree(s) :: 17 | 2400 Sunset Blvd | 38 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985115.7608 | 2098504.4307 | 37.7412330456993 | -122.494082490759 | (37.7412330456993, -122.494082490759) | 1 | 8 | 3 | 29491 | 35 | |||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
2335 | 262272 | Undocumented 4 | Tree(s) :: 17 | 99X Glendale St | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
4489 | 97354 | Permitted Site 7 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
6241 | 261939 | DPW Maintained 1 | Tree(s) :: 17 | 1 Verna St | 4 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
7552 | 97352 | Permitted Site 7 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
10185 | 97351 | Permitted Site 7 | Tree(s) :: 17 | 1 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
12859 | 97357 | Permitted Site 7 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
13861 | 97353 | Permitted Site 7 | Tree(s) :: 17 | 3 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
17452 | 97358 | Permitted Site 7 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
19547 | 97356 | Permitted Site 7 | Tree(s) :: 17 | 6 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
27649 | 64475 | Permitted Site 7 | Tree(s) :: 17 | 201 Quintara St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 03/27/2012 12:00:00 AM | Permit Number 768647 | 5992886.81207962 | 2101152.3784099 | 37.7489552885612 | -122.467405690566 | (37.7489552885612, -122.467405690566) | 1 | 8 | 4 | 29491 | 40 | |||
38815 | 96537 | Permitted Site 7 | Tree(s) :: 17 | 950X Kansas St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 767960 | 6011564.8 | 2103917.5 | 37.7576083124183 | -122.403011228478 | (37.7576083124183, -122.403011228478) | 10 | 3 | 8 | 28856 | 29 | |||
60665 | 122555 | Permitted Site 7 | Tree(s) :: 17 | 1910X Castro St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6002640 | 2099906 | 37.7460912652213 | -122.433590100931 | (37.7460912652213, -122.433590100931) | 2 | 7 | 5 | 63 | 22 | |||||
68373 | 115524 | Permitted Site 7 | Tree(s) :: 17 | 25 FRANCONIA ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777451 | 6010006 | 2099954 | 37.7466382512014 | -122.408122694659 | (37.7466382512014, -122.408122694659) | 2 | 7 | 7 | 28859 | 2 | |
72174 | 105759 | Permitted Site 7 | Tree(s) :: 17 | 1910X CASTRO ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 04/10/2014 12:00:00 AM | 15 | Permit Number 771977 | 6002617 | 2100030 | 37.7464304351188 | -122.433678492599 | (37.7464304351188, -122.433678492599) | 2 | 7 | 5 | 63 | 22 | ||
83802 | 115379 | Undocumented 4 | Tree(s) :: 17 | 4004 20TH ST | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6003604 | 2104237 | 37.758037821948 | -122.430565699194 | (37.758037821948, -122.430565699194) | 2 | 4 | 5 | 28862 | 3 | |||||
114511 | 96539 | Permitted Site 7 | Tree(s) :: 17 | 952X Kansas St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 767960 | 6011608.51303 | 2103942.83298 | 37.7576803120977 | -122.402861831849 | (37.7576803120977, -122.402861831849) | 10 | 3 | 8 | 28856 | 29 | |||
131094 | 105760 | Permitted Site 7 | Tree(s) :: 17 | 1910X CASTRO ST | 5 | Unaccepted Street : Yard | Tree | Private 2 | 04/10/2014 12:00:00 AM | 15 | Permit Number 771977 | 6002617 | 2100030 | 37.7464304351188 | -122.433678492599 | (37.7464304351188, -122.433678492599) | 2 | 7 | 5 | 63 | 22 | ||
144693 | 105756 | Permitted Site 7 | Tree(s) :: 17 | 1910X CASTRO ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | Permit Number 771977 | 6002640 | 2099906 | 37.7460912652213 | -122.433590100931 | (37.7460912652213, -122.433590100931) | 2 | 7 | 5 | 63 | 22 | ||
148055 | 96538 | Permitted Site 7 | Tree(s) :: 17 | 950X Kansas St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 05/25/2011 12:00:00 AM | Permit Number 767960 | 6011564.8 | 2103917.5 | 37.7576083124183 | -122.403011228478 | (37.7576083124183, -122.403011228478) | 10 | 3 | 8 | 28856 | 29 | |||
164808 | 114584 | Permitted Site 7 | Tree(s) :: 17 | 3300x HARRISON ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | Permit Number 777406 | 6009042 | 2099449 | 37.745197609352 | -122.411420448228 | (37.745197609352, -122.411420448228) | 2 | 7 | 7 | 28859 | 2 | ||
177278 | 115526 | Permitted Site 7 | Tree(s) :: 17 | 25 FRANCONIA ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777451 | 6010006 | 2099954 | 37.7466382512014 | -122.408122694659 | (37.7466382512014, -122.408122694659) | 2 | 7 | 7 | 28859 | 2 | |
186942 | 99610 | DPW Maintained 1 | Tree(s) :: 17 | 111 Corwin St | Unaccepted Street : Yard | Landscaping | Private 2 | 6000616 | 2104331 | 37.7581261988062 | -122.44090619354 | (37.7581261988062, -122.44090619354) | 2 | 4 | 5 | 28862 | 38 | ||||||
194363 | 265042 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x010 | Permit Number 787936 | |||||||||||
6380 | 110632 | Undocumented 4 | Tree(s) :: 17 | 1051X Mandalay Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991736.20076 | 2101819.33429 | 37.7507200830769 | -122.47143306251 | (37.7507200830769, -122.47143306251) | 1 | 8 | 4 | 29491 | 12 | |||||
34416 | 110631 | Undocumented 4 | Tree(s) :: 17 | 1001X Mandalay Ln | Unaccepted Street : Cutout | Tree | Private 2 | 5991736.20076 | 2101819.33429 | 37.7507200830769 | -122.47143306251 | (37.7507200830769, -122.47143306251) | 1 | 8 | 4 | 29491 | 12 | ||||||
94661 | 110323 | Undocumented 4 | Tree(s) :: 17 | 1501x SHOTWELL ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 05/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775301 | 6008079 | 2099374 | 37.7449376155386 | -122.414745041111 | (37.7449376155386, -122.414745041111) | 2 | 7 | 7 | 28859 | 2 | |
106132 | 110322 | Undocumented 4 | Tree(s) :: 17 | 1501x SHOTWELL ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 05/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775301 | 6008079 | 2099374 | 37.7449376155386 | -122.414745041111 | (37.7449376155386, -122.414745041111) | 2 | 7 | 7 | 28859 | 2 | |
3790 | 262255 | Undocumented 4 | Tree(s) :: 17 | 4210 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
4096 | 261159 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
6646 | 261235 | DPW Maintained 1 | Tree(s) :: 17 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/07/2020 12:00:00 AM | 3 | 3x10 | Permit Number 784981 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | |
6747 | 261157 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 | ||||||
9381 | 261160 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
10202 | 261492 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
15525 | 261460 | Undocumented 4 | Tree(s) :: 17 | 701X Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
15590 | 260947 | Private 9 | Tree(s) :: 17 | 143 Gambier St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005856 | 2093079 | 37.72752779603 | -122.421984681693 | (37.72752779603, -122.421984681693) | 9 | 7 | 7 | 309 | 5 | ||||
15788 | 93091 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
15964 | 71808 | DPW Maintained 1 | Tree(s) :: 17 | 2487 21st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 4x6 | Permit Number 783161 | 5989823.9383 | 2098417.3202 | 37.7412682330564 | -122.477797097779 | (37.7412682330564, -122.477797097779) | 1 | 8 | 3 | 29491 | 35 | |
20624 | 97964 | Permitted Site 7 | Tree(s) :: 17 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/10/2012 12:00:00 AM | 12 | 4x4 | Permit Number 768496 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.449589586059 | (37.7598420097441, -122.449589586059) | 15 | 5 | 11 | 29492 | 12 | |
25047 | 93079 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
25386 | 93084 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
25544 | 94565 | Permitted Site 7 | Tree(s) :: 17 | 66 Saint Elmo Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/17/2010 12:00:00 AM | 55 | Permit Number 53747 | 5995072.9 | 2094997.2 | 37.7321806567094 | -122.459400540638 | (37.7321806567094, -122.459400540638) | 9 | 8 | 4 | 59 | 40 | ||
27555 | 173771 | - 12 | Tree(s) :: 17 | 231 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779366 | 5990884.97189 | 2090977.23451 | 37.7209011553391 | -122.473585870316 | (37.7209011553391, -122.473585870316) | 9 | 8 | 4 | 64 | 40 | |
29509 | 93088 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
29994 | 93085 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
33969 | 103647 | Undocumented 4 | Tree(s) :: 17 | 500X Oak Park Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 3x10 | 5994983.3 | 2103652.8 | 37.7559416221353 | -122.460337221652 | (37.7559416221353, -122.460337221652) | 1 | 5 | 4 | 63 | 12 | |||
34066 | 100190 | Undocumented 4 | Tree(s) :: 17 | 404 Noriega St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/07/2016 12:00:00 AM | Permit Number 776979 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||
35226 | 185189 | DPW Maintained 1 | Tree(s) :: 17 | 2500 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985143.9825 | 2097859.9805 | 37.7394652100499 | -122.493937429023 | (37.7394652100499, -122.493937429023) | 1 | 8 | 3 | 29491 | 35 | |||
37092 | 254109 | Significant Tree 6 | Tree(s) :: 17 | 38X Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 6x6 | Permit Number 781050 | 5997469 | 2101545 | 37.7502968010125 | -122.451588863361 | (37.7502968010125, -122.451588863361) | 1 | 5 | 4 | 63 | 38 | |
37232 | 256765 | Significant Tree 6 | Tree(s) :: 17 | 355 Serrano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782555 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
38504 | 93093 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
42522 | 93094 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
44663 | 250594 | DPW Maintained 1 | Tree(s) :: 17 | 2201 Golden Gate Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | Width 7ft | Permit Number 782666 | 5998426.00628 | 2111357.02356 | 37.7772929050689 | -122.448986219244 | (37.7772929050689, -122.448986219244) | 15 | 6 | 2 | 29492 | 16 | |
44745 | 93086 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
45376 | 187257 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984951.1083 | 2098437.5001 | 37.7410396364594 | -122.494646859045 | (37.7410396364594, -122.494646859045) | 1 | 8 | 3 | 29491 | 35 | |||
47222 | 113141 | Undocumented 4 | Tree(s) :: 17 | 140 BROADMOOR DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/09/2015 12:00:00 AM | 3x10 | Permit Number 776484 | 5990979 | 2092893 | 37.7261668163813 | -122.473400506865 | (37.7261668163813, -122.473400506865) | 9 | 8 | 4 | 64 | 40 | ||
51551 | 186812 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.7642834011007 | -122.495707883417 | (37.7642834011007, -122.495707883417) | 1 | 8 | 3 | 56 | 35 | |||
68627 | 93087 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
69427 | 95096 | Permitted Site 7 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/22/2010 12:00:00 AM | 10 | Permit Number 54030 | 5999362 | 2116697.3 | 37.7920093994348 | -122.446132548429 | (37.7920093994348, -122.446132548429) | 13 | 6 | 1 | 29490 | 27 | ||
71176 | 87239 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330 | 2096776 | 37.7374226054152 | -122.437895752709 | (37.7374226054152, -122.437895752709) | 2 | 7 | 5 | 63 | 7 | |||
73887 | 187219 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984931.5011 | 2098800.6417 | 37.7420355776419 | -122.494741419283 | (37.7420355776419, -122.494741419283) | 1 | 8 | 3 | 29491 | 35 | |||
74831 | 181347 | DPW Maintained 1 | Tree(s) :: 17 | 2500 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6 | Width 0ft | 5985144.6465 | 2098114.9716 | 37.7401653859663 | -122.493953920474 | (37.7401653859663, -122.493953920474) | 1 | 8 | 3 | 29491 | 35 | |||
80420 | 105436 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 15 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
81334 | 106255 | Significant Tree 6 | Tree(s) :: 17 | 1900X 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770844 | 6012067 | 2105610 | 37.7622835736204 | -122.401393347502 | (37.7622835736204, -122.401393347502) | 8 | 3 | 8 | 28856 | 29 | ||||
81938 | 103627 | Undocumented 4 | Tree(s) :: 17 | 20 Mountain Spring Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 2x20 | 5997484.2 | 2104350.9 | 37.75800197393 | -122.451738687438 | (37.75800197393, -122.451738687438) | 15 | 5 | 4 | 28862 | 38 | |||
82221 | 182927 | DPW Maintained 1 | Tree(s) :: 17 | 2639 44th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5982723.7516 | 2097156.0189 | 37.7373904194317 | -122.502253307981 | (37.7373904194317, -122.502253307981) | 1 | 8 | 3 | 29491 | 35 | |||
84977 | 112660 | Permitted Site 7 | Tree(s) :: 17 | 2101X 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2015 12:00:00 AM | Permit Number 775001 | 5993200.98623 | 2101015.16354 | 37.7485966642746 | -122.466309313334 | (37.7485966642746, -122.466309313334) | 1 | 8 | 4 | 29491 | 40 | |||
85917 | 93196 | Permitted Site 7 | Tree(s) :: 17 | 1223 24th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/19/2010 12:00:00 AM | Permit Number 53200 | 5988582.3 | 2106975.8 | 37.7646953907786 | -122.482717226164 | (37.7646953907786, -122.482717226164) | 1 | 8 | 3 | 56 | 35 | |||
88182 | 99608 | Permitted Site 7 | Tree(s) :: 17 | 1 Entrada Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768939 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||
89708 | 115345 | Undocumented 4 | Tree(s) :: 17 | 698 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/27/2016 12:00:00 AM | 3 | Permit Number 776977 | 6000026.4 | 2101151.8 | 37.7493632922521 | -122.442717001669 | (37.7493632922521, -122.442717001669) | 2 | 4 | 5 | 28862 | 22 | ||
91717 | 107522 | Permitted Site 7 | Tree(s) :: 17 | 100X Lawton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/19/2014 12:00:00 AM | 3 | Permit Number 773356 | 5993852.82258 | 2104613.64437 | 37.7585147583588 | -122.464316510192 | (37.7585147583588, -122.464316510192) | 1 | 8 | 4 | 56 | 12 | ||
92188 | 109666 | Undocumented 4 | Tree(s) :: 17 | 2X NIDO AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999244 | 2112088 | 37.7793467258368 | -122.446209119816 | (37.7793467258368, -122.446209119816) | 15 | 5 | 1 | 54 | 16 | |||||
92522 | 93090 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
94958 | 93080 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
105812 | 106145 | Permitted Site 7 | Tree(s) :: 17 | 89 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 771523 | 5998082.7 | 2104872.2 | 37.7594675922154 | -122.449706395213 | (37.7594675922154, -122.449706395213) | 15 | 5 | 11 | 28862 | 12 | |||||
107476 | 93089 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
108887 | 93082 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
109195 | 187259 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984964.1798 | 2098429.7389 | 37.7410190913708 | -122.4946010912 | (37.7410190913708, -122.4946010912) | 1 | 8 | 3 | 29491 | 35 | |||
110269 | 93092 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
121762 | 186803 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Sunset Blvd | 81 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984854.4903 | 2106938.312 | 37.7643748688283 | -122.495607779566 | (37.7643748688283, -122.495607779566) | 1 | 8 | 3 | 56 | 35 | |||
123776 | 93078 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
124269 | 256872 | Significant Tree 6 | Tree(s) :: 17 | 2401X Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782666 | 5997871 | 2111315 | 37.7771457625148 | -122.450903124986 | (37.7771457625148, -122.450903124986) | 15 | 6 | 2 | 29492 | 16 | |
124713 | 107523 | Permitted Site 7 | Tree(s) :: 17 | 100X Lawton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/19/2014 12:00:00 AM | 3 | Permit Number 773356 | 5993852.82258 | 2104613.64437 | 37.7585147583588 | -122.464316510192 | (37.7585147583588, -122.464316510192) | 1 | 8 | 4 | 56 | 12 | ||
125092 | 93076 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
126190 | 186815 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Sunset Blvd | 112 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984815.7546 | 2106849.1761 | 37.7641278583257 | -122.495735178133 | (37.7641278583257, -122.495735178133) | 1 | 8 | 3 | 56 | 35 | |||
129769 | 93077 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
131409 | 94503 | Permitted Site 7 | Tree(s) :: 17 | 60 Fernwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/24/2010 12:00:00 AM | Permit Number 53693 | 5994613 | 2095460 | 37.733424938715 | -122.461024038199 | (37.733424938715, -122.461024038199) | 9 | 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) );