trees
11,761 rows where qSpecies_id = 17 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
| 162 | 105806 | Undocumented 4 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x3 | 5994834 | 2112130 | 37.7792092085373 | -122.461468091676 | (37.7792092085373, -122.461468091676) | 11 | 6 | 2 | 54 | 11 | |||||
| 227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
| 361 | 107141 | Undocumented 4 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | 15 | 4 | 5 | 28862 | 3 | ||||||
| 1105 | 106501 | Undocumented 4 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993358 | 2106830.8 | 37.764573953722 | -122.46618893715 | (37.764573953722, -122.46618893715) | 11 | 8 | 11 | 56 | 12 | |||||
| 1361 | 105851 | Undocumented 4 | Tree(s) :: 17 | 2590 16TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991465.4 | 2097806.4 | 37.7396859298071 | -122.472077039908 | (37.7396859298071, -122.472077039908) | 1 | 8 | 4 | 29491 | 40 | |||||
| 2010 | 260603 | DPW Maintained 1 | Tree(s) :: 17 | 1162 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013406.09782 | 2090446.93369 | 37.7207235989971 | -122.395699409803 | (37.7207235989971, -122.395699409803) | 10 | 3 | 8 | 58 | 1 | |||
| 2090 | 260628 | DPW Maintained 1 | Tree(s) :: 17 | 1251 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016934.60308 | 2092996.85523 | 37.7279208386687 | -122.383679778477 | (37.7279208386687, -122.383679778477) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||||
| 2598 | 95032 | - 12 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout | Landscaping | Private 2 | 6004772 | 2093802 | 37.7294517978782 | -122.425783519869 | (37.7294517978782, -122.425783519869) | 9 | 7 | 6 | 28861 | 5 | ||||||
| 3740 | 102276 | DPW Maintained 1 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||||||
| 4399 | 260599 | DPW Maintained 1 | Tree(s) :: 17 | 1114 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014272.04969 | 2090150.96276 | 37.7199590543715 | -122.392685364492 | (37.7199590543715, -122.392685364492) | 10 | 3 | 8 | 58 | 1 | |||
| 4623 | 106966 | Undocumented 4 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 4853 | 107519 | Undocumented 4 | Tree(s) :: 17 | 100x CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004015.5 | 2108290.9 | 37.7691921614924 | -122.429431648714 | (37.7691921614924, -122.429431648714) | 7 | 9 | 5 | 28862 | 3 | ||||||
| 5607 | 260608 | DPW Maintained 1 | Tree(s) :: 17 | 1010 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014125.00477 | 2089910.99969 | 37.7192919954616 | -122.393176869863 | (37.7192919954616, -122.393176869863) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||||
| 7665 | 107118 | Undocumented 4 | Tree(s) :: 17 | 49 Elsie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 6x3 | Permit Number 773429 | 6007534.56738 | 2099145.89717 | 37.7442806914439 | -122.41661143894 | (37.7442806914439, -122.41661143894) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 8600 | 260856 | DPW Maintained 1 | Tree(s) :: 17 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||||
| 8860 | 260613 | DPW Maintained 1 | Tree(s) :: 17 | 1271 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016832.40592 | 2093073.03805 | 37.7281243722496 | -122.384038382899 | (37.7281243722496, -122.384038382899) | 10 | 3 | 8 | 58 | 1 | |||
| 10379 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard | Tree | Private 2 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177 | 2107098 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | 15 | 5 | 5 | 29492 | 3 | |||
| 11448 | 96234 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/15/2011 12:00:00 AM | Permit Number 767856 | |||||||||||||||
| 11689 | 260606 | DPW Maintained 1 | Tree(s) :: 17 | 1038 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013981.83254 | 2090017.73229 | 37.7195771072229 | -122.393679232644 | (37.7195771072229, -122.393679232644) | 10 | 3 | 8 | 58 | 1 | |||
| 11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
| 12037 | 260602 | DPW Maintained 1 | Tree(s) :: 17 | 1152 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013444.93607 | 2090417.98033 | 37.7206462592683 | -122.395563129546 | (37.7206462592683, -122.395563129546) | 10 | 3 | 8 | 58 | 1 | |||
| 12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
| 12345 | 107864 | Permitted Site 7 | Tree(s) :: 17 | 362 BRANNAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014441.4 | 2112297.4 | 37.7807778793576 | -122.393649202889 | (37.7807778793576, -122.393649202889) | 6 | 2 | 9 | 28856 | 6 | |||||
| 13376 | 29902 | DPW Maintained 1 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6001149.68281092 | 2114264.52722613 | 37.7854315611698 | -122.439772670022 | (37.7854315611698, -122.439772670022) | 15 | 6 | 1 | 29490 | 27 | ||||||
| 14217 | 107031 | Undocumented 4 | Tree(s) :: 17 | 4022 19TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6002868.3 | 2104782.6 | 37.7594942034983 | -122.433149044029 | (37.7594942034983, -122.433149044029) | 2 | 4 | 5 | 28862 | 3 | |||||
| 14367 | 86754 | Permitted Site 7 | Tree(s) :: 17 | 1376 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | Permit Number 49715 | 5994310.3 | 2106169.4 | 37.7628128189867 | -122.462847225894 | (37.7628128189867, -122.462847225894) | 1 | 5 | 11 | 56 | 12 | ||||
| 14442 | 260627 | DPW Maintained 1 | Tree(s) :: 17 | 1557 Hudson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015914.7542 | 2097249.1447 | 37.7395403460526 | -122.387501983912 | (37.7395403460526, -122.387501983912) | 10 | 3 | 8 | 58 | 1 | |||
| 15100 | 86751 | Permitted Site 7 | Tree(s) :: 17 | 81 Parker Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | 11 | 6 | 1 | 54 | 31 | ||||
| 15172 | 260605 | DPW Maintained 1 | Tree(s) :: 17 | 1042 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013961.37936 | 2090032.97981 | 37.719617837314 | -122.393750999085 | (37.719617837314, -122.393750999085) | 10 | 3 | 8 | 58 | 1 | |||
| 15191 | 96232 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
| 15343 | 92823 | Permitted Site 7 | Tree(s) :: 17 | 50 Kirkham St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2009 12:00:00 AM | 3x3 | Permit Number 53037 | 5994776.3 | 2105346.5 | 37.7605801777143 | -122.461175855238 | (37.7605801777143, -122.461175855238) | 15 | 5 | 11 | 56 | 12 | |||
| 15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
| 16275 | 260607 | DPW Maintained 1 | Tree(s) :: 17 | 1026 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014043.19207 | 2089971.98975 | 37.71945491674 | -122.393463933828 | (37.71945491674, -122.393463933828) | 10 | 3 | 8 | 58 | 1 | |||
| 16631 | 104298 | Permitted Site 7 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6003557 | 2104154 | 37.7578072610358 | -122.430722322319 | (37.7578072610358, -122.430722322319) | 2 | 4 | 5 | 28862 | 3 | |||||
| 17248 | 260604 | DPW Maintained 1 | Tree(s) :: 17 | 1058 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013879.56666 | 2090093.96987 | 37.7197807571849 | -122.394038065566 | (37.7197807571849, -122.394038065566) | 10 | 3 | 8 | 58 | 1 | |||
| 17341 | 260857 | DPW Maintained 1 | Tree(s) :: 17 | 726 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985712.15541 | 2110932.69313 | 37.7753924991275 | -122.492935643751 | (37.7753924991275, -122.492935643751) | 11 | 6 | 2 | 55 | 26 | |||
| 17829 | 106868 | Undocumented 4 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout | Tree | Private 2 | 5981193.7 | 2101737.6 | 37.7498801477899 | -122.507883225183 | (37.7498801477899, -122.507883225183) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 18448 | 260600 | DPW Maintained 1 | Tree(s) :: 17 | 1122 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014231.13861 | 2090181.46138 | 37.7200405252834 | -122.392828913667 | (37.7200405252834, -122.392828913667) | 10 | 3 | 8 | 58 | 1 | |||
| 18556 | 105475 | Undocumented 4 | Tree(s) :: 17 | 671 Waller St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2014 12:00:00 AM | 3x3 | 6002476.36422 | 2108834.33955 | 37.7705970512656 | -122.434794296397 | (37.7705970512656, -122.434794296397) | 15 | 5 | 11 | 29492 | 9 | ||||
| 19014 | 260601 | DPW Maintained 1 | Tree(s) :: 17 | 1142 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014128.86091 | 2090257.70792 | 37.7202442017659 | -122.393187787982 | (37.7202442017659, -122.393187787982) | 10 | 3 | 8 | 58 | 1 | |||
| 23742 | 112565 | Permitted Site 7 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.474140224193 | (37.7515380150924, -122.474140224193) | 1 | 8 | 4 | 29491 | 12 | ||||
| 24076 | 91328 | DPW Maintained 1 | Tree(s) :: 17 | 5089 Mission St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/05/2007 12:00:00 AM | 3x3 | 6000514.1536 | 2089460.50315 | 37.7172895061936 | -122.440192061387 | (37.7172895061936, -122.440192061387) | 9 | 7 | 6 | 28861 | 5 | ||||
| 26011 | 100148 | Property Tree 8 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard | Tree | Private 2 | 6004141 | 2102142 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 26293 | 107520 | Undocumented 4 | Tree(s) :: 17 | 2 CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004041.5 | 2108639.2 | 37.7701499806884 | -122.429366557007 | (37.7701499806884, -122.429366557007) | 7 | 9 | 5 | 29492 | 10 | ||||||
| 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 | ||||||
| 27619 | 107651 | Undocumented 4 | Tree(s) :: 17 | 2908 23RD ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009361.7 | 2102802.2 | 37.7544226781239 | -122.410551718922 | (37.7544226781239, -122.410551718922) | 2 | 4 | 7 | 28859 | 19 | ||||||
| 28498 | 106346 | Permitted Site 7 | Tree(s) :: 17 | 4020 19th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | Permit Number 772952 | 6002864.7 | 2104850 | 37.7596790634802 | -122.433166310425 | (37.7596790634802, -122.433166310425) | 2 | 4 | 5 | 28862 | 3 | ||||
| 28606 | 104299 | Permitted Site 7 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6003557 | 2104154 | 37.7578072610358 | -122.430722322319 | (37.7578072610358, -122.430722322319) | 2 | 4 | 5 | 28862 | 3 | |||||
| 29040 | 89138 | DPW Maintained 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373 | (37.7541940143569, -122.41572017373) | 2 | 4 | 7 | 28859 | 19 | ||||
| 32821 | 88995 | Permitted Site 7 | Tree(s) :: 17 | 5 Rico Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51744 | 6001709 | 2121299 | 37.8047782094669 | -122.438341747927 | (37.8047782094669, -122.438341747927) | 13 | 9 | 1 | 57 | 17 | |||
| 33052 | 91050 | Permitted Site 7 | Tree(s) :: 17 | 567 Texas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2008 12:00:00 AM | 4x4 | Permit Number 51962 | 6013849 | 2104463 | 37.7592334263593 | -122.395149687391 | (37.7592334263593, -122.395149687391) | 10 | 3 | 8 | 28856 | 29 | |||
| 33827 | 99268 | Property Tree 8 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout | Tree | Private 2 | 6004280 | 2096681 | 37.7373290690714 | -122.427689454915 | (37.7373290690714, -122.427689454915) | 2 | 7 | 5 | 63 | 7 | ||||||
| 34166 | 255908 | Undocumented 4 | Tree(s) :: 17 | 237 Valley St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004146 | 2099216 | 37.7442820186212 | -122.428333377796 | (37.7442820186212, -122.428333377796) | 2 | 7 | 5 | 63 | 22 | |||||
| 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 | ||||||
| 34983 | 93555 | Permitted Site 7 | Tree(s) :: 17 | 290 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2010 12:00:00 AM | 3x3 | Permit Number 53175 | 6011548 | 2119416 | 37.8001626595724 | -122.404160079164 | (37.8001626595724, -122.404160079164) | 3 | 1 | 10 | 308 | 23 | |||
| 35153 | 92026 | Permitted Site 7 | Tree(s) :: 17 | 450 Somerset St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52171 | 6010071 | 2092425 | 37.7259688694367 | -122.407367242494 | (37.7259688694367, -122.407367242494) | 10 | 3 | 7 | 309 | 28 | |||
| 36007 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard | Tree | Private 2 | 6004592.7 | 2107127.1 | 37.7660293092823 | -122.427352228532 | (37.7660293092823, -122.427352228532) | 8 | 4 | 5 | 28862 | 3 | ||||||
| 37265 | 106849 | Undocumented 4 | Tree(s) :: 17 | 111 Conrad St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2014 12:00:00 AM | 2X3 | Permit Number 772929 | 6001823.82453 | 2096683.04547 | 37.7371954430884 | -122.436181723191 | (37.7371954430884, -122.436181723191) | 2 | 7 | 5 | 63 | 7 | |||
| 39566 | 89234 | Permitted Site 7 | Tree(s) :: 17 | 239 08th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2008 12:00:00 AM | 3x3 | Permit Number 51868 | 6009415.9 | 2110603.1 | 37.7758451977468 | -122.41091521392 | (37.7758451977468, -122.41091521392) | 8 | 2 | 9 | 28853 | 34 | |||
| 43873 | 107865 | Permitted Site 7 | Tree(s) :: 17 | 570 BEALE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015852.9 | 2114012.6 | 37.7855657638563 | -122.388885877785 | (37.7855657638563, -122.388885877785) | 6 | 2 | 9 | 28856 | 6 | |||||
| 44140 | 107650 | Undocumented 4 | Tree(s) :: 17 | 888 DUNCAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000841.2 | 2099697.3 | 37.7454159980932 | -122.439795143209 | (37.7454159980932, -122.439795143209) | 2 | 4 | 5 | 63 | 22 | ||||||
| 44982 | 106930 | Undocumented 4 | Tree(s) :: 17 | 560 Jersey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2014 12:00:00 AM | 3X3 | Permit Number 772858 | 6001503.65227 | 2101489.51912 | 37.7503746913106 | -122.437632822405 | (37.7503746913106, -122.437632822405) | 2 | 4 | 5 | 28862 | 22 | |||
| 45129 | 98465 | Property Tree 8 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard | Landscaping | Private 2 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | 2 | 5 | 5 | 63 | 38 | ||||||
| 46883 | 106970 | Undocumented 4 | Tree(s) :: 17 | 30 Piedmont St | Front Yard : Yard | Tree | Private 2 | 07/11/2014 12:00:00 AM | Permit Number 772781 | 5999571.08265 | 2107127.27884 | 37.7657445183673 | -122.444720943629 | (37.7657445183673, -122.444720943629) | 15 | 5 | 5 | 29492 | 9 | ||||
| 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 | ||||
| 49479 | 112562 | Permitted Site 7 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.474140224193 | (37.7515380150924, -122.474140224193) | 1 | 8 | 4 | 29491 | 12 | ||||
| 49649 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||
| 50373 | 95369 | - 12 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout | Landscaping | Private 2 | 02/18/2011 12:00:00 AM | 6002651 | 2105744 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | 15 | 4 | 5 | 28862 | 3 | |||||
| 51552 | 94522 | Permitted Site 7 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : | Tree | Private 2 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519 | 2114878 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | 6 | 2 | 9 | 28855 | 6 | ||||
| 52216 | 100074 | Undocumented 4 | Tree(s) :: 17 | 701 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003070 | 2104166 | 37.7578126071811 | -122.432407426584 | (37.7578126071811, -122.432407426584) | 2 | 4 | 5 | 28862 | 3 | ||||||
| 53547 | 106559 | Permitted Site 7 | Tree(s) :: 17 | 2630 Bay Shore Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2014 12:00:00 AM | 3x3 | Permit Number 772167 | 6010472.4 | 2086044.7 | 37.7084723291496 | -122.405530459051 | (37.7084723291496, -122.405530459051) | 9 | 7 | 8 | 309 | 39 | |||
| 54211 | 98502 | Property Tree 8 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999066 | 2100737 | 37.7481695560511 | -122.446008243376 | (37.7481695560511, -122.446008243376) | 2 | 5 | 5 | 63 | 38 | ||||||
| 57526 | 86741 | Permitted Site 7 | Tree(s) :: 17 | 1275 02nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2007 12:00:00 AM | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | 15 | 5 | 11 | 56 | 12 | ||||
| 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 | ||||
| 58309 | 100046 | Property Tree 8 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard | Tree | Private 2 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262 | 2099459 | 37.7448424535299 | -122.434865213189 | (37.7448424535299, -122.434865213189) | 2 | 7 | 5 | 63 | 22 | |||
| 59133 | 106328 | Permitted Site 7 | Tree(s) :: 17 | 4309 19th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2014 12:00:00 AM | 3X3 | Permit Number 772711 | 6001662.1 | 2104635.3 | 37.7590212565974 | -122.437310124809 | (37.7590212565974, -122.437310124809) | 2 | 4 | 5 | 28862 | 3 | |||
| 59137 | 107620 | Undocumented 4 | Tree(s) :: 17 | 138 CORTLAND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006430.5 | 2097564.1 | 37.7398752757691 | -122.420316827642 | (37.7398752757691, -122.420316827642) | 2 | 7 | 7 | 28859 | 2 | ||||||
| 62390 | 107810 | Permitted Site 7 | Tree(s) :: 17 | 2 BARTLETT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006662 | 2103492 | 37.7561649865508 | -122.419936943866 | (37.7561649865508, -122.419936943866) | 2 | 4 | 7 | 28859 | 19 | |||||
| 62714 | 105221 | DPW Maintained 1 | Tree(s) :: 17 | 1587 41ST AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2014 12:00:00 AM | 3x3 | Permit Number 771982 | 5983395.5 | 2104359.9 | 37.7572097335405 | -122.500463283464 | (37.7572097335405, -122.500463283464) | 1 | 8 | 3 | 56 | 35 | |||
| 62971 | 94521 | Permitted Site 7 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : | Tree | Private 2 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519 | 2114878 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | 6 | 2 | 9 | 28855 | 6 | ||||
| 63564 | 92637 | Permitted Site 7 | Tree(s) :: 17 | 254 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52928 | 6006132.5 | 2101681.8 | 37.7511647494644 | -122.421639572935 | (37.7511647494644, -122.421639572935) | 2 | 4 | 5 | 28859 | 19 | |||
| 63810 | 86778 | Permitted Site 7 | Tree(s) :: 17 | 1201SAWYER Sunnydale Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49246 | 6008311.7 | 2086994.1 | 37.7109581313437 | -122.413065210327 | (37.7109581313437, -122.413065210327) | 9 | 7 | 8 | 309 | 39 | |||||
| 65619 | 100841 | Undocumented 4 | Tree(s) :: 17 | 139 Stillman St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014008 | 2112974 | 37.782611576233 | -122.39519596309 | (37.782611576233, -122.39519596309) | 6 | 2 | 9 | 28856 | 6 | |||||
| 66043 | 89356 | Permitted Site 7 | Tree(s) :: 17 | 3 Peralta Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2008 12:00:00 AM | 3x3 | Permit Number 51937 | 6010899 | 2100465.1 | 37.7480915808773 | -122.405070759341 | (37.7480915808773, -122.405070759341) | 2 | 7 | 7 | 28859 | 2 | |||
| 66336 | 106490 | Permitted Site 7 | Tree(s) :: 17 | 74 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2014 12:00:00 AM | 3x3 | Permit Number 772723 | 6013483 | 2114541 | 37.7868849859064 | -122.397122161673 | (37.7868849859064, -122.397122161673) | 6 | 2 | 9 | 28855 | 6 | |||
| 67179 | 107161 | Undocumented 4 | Tree(s) :: 17 | 3772 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2014 12:00:00 AM | 3 | 5x5 | Permit Number 773829 | 6005193.3 | 2104336.4 | 37.7584006572295 | -122.42507628966 | (37.7584006572295, -122.42507628966) | 2 | 4 | 5 | 28859 | 19 | ||
| 68093 | 106516 | DPW Maintained 1 | Tree(s) :: 17 | 366 Hill St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/07/2014 12:00:00 AM | 3X3 | Permit Number 772751 | 6003996.2 | 2103381.7 | 37.7557115810688 | -122.42914832014 | (37.7557115810688, -122.42914832014) | 2 | 4 | 5 | 28862 | 22 | |||
| 69682 | 173883 | DPW Maintained 1 | Tree(s) :: 17 | 127 Holloway Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779596 | 5996444 | 2091166 | 37.721739833175 | -122.454383721237 | (37.721739833175, -122.454383721237) | 9 | 8 | 6 | 28861 | 24 | ||
| 70823 | 89326 | Permitted Site 7 | Tree(s) :: 17 | 22 Banbury Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2008 12:00:00 AM | 3x3 | Permit Number 51917 | 5990779 | 2090643 | 37.7199772923765 | -122.47392780719 | (37.7199772923765, -122.47392780719) | 9 | 8 | 4 | 64 | 40 | |||
| 70885 | 106063 | Undocumented 4 | Tree(s) :: 17 | 274 MONTICELLO ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991733.9 | 2090351.1 | 37.7192310708749 | -122.470605827889 | (37.7192310708749, -122.470605827889) | 9 | 8 | 6 | 64 | 24 | |||||
| 71071 | 107774 | Permitted Site 7 | Tree(s) :: 17 | 4532 17TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999156.7 | 2105780.6 | 37.7620232196749 | -122.44605732695 | (37.7620232196749, -122.44605732695) | 15 | 5 | 5 | 29492 | 3 | |||||
| 72486 | 93983 | Permitted Site 7 | Tree(s) :: 17 | 560 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3x3 | Permit Number 53407 | 6002980 | 2104981 | 37.7600452979057 | -122.432776903654 | (37.7600452979057, -122.432776903654) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 73384 | 107402 | Undocumented 4 | Tree(s) :: 17 | 88 LUNDYS LN | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006885 | 2099070 | 37.7440357411005 | -122.418852127392 | (37.7440357411005, -122.418852127392) | 2 | 7 | 7 | 28859 | 2 | ||||||
| 75068 | 107777 | Permitted Site 7 | Tree(s) :: 17 | 348 DUNCAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003988 | 2099873 | 37.7460770471098 | -122.428926539119 | (37.7460770471098, -122.428926539119) | 2 | 7 | 5 | 63 | 22 | |||||
| 75402 | 86839 | Permitted Site 7 | Tree(s) :: 17 | 2238 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001026.6 | 2113503.7 | 37.7833355182269 | -122.440143921372 | (37.7833355182269, -122.440143921372) | 15 | 5 | 11 | 29490 | 13 |
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) );