trees

11,761 rows where qSpecies_id = 17 sorted by qSiteInfo

✎ View and edit SQL

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)
54212 246488 DPW Maintained 1 Tree(s) :: 17 399 Duncan St 2 : Tree Private 2     3 Width 3ft Permit Number 780909 6004022.94651 2099813.62498 37.7459159950372 -122.428801466541 (37.7459159950372, -122.428801466541) 2 7 5 63 22
65525 250499 DPW Maintained 1 Tree(s) :: 17 540 El Camino Del Mar 2 : Tree Private 2   05/10/2017 12:00:00 AM 3 Width 3ft Permit Number 779924 5986884.24135 2115388.89729 37.7876964378791 -122.489208879795 (37.7876964378791, -122.489208879795) 11 6 1 55 33
183886 105148 Permitted Site 7 Tree(s) :: 17 185 Stratford Dr   : Tree Private 2   12/26/2013 12:00:00 AM     Permit Number 770387 5990916.9 2091282.3 37.7217406386467 -122.473497746062 (37.7217406386467, -122.473497746062) 9 8 4 64 40
130825 255872 Property Tree 8 Tree(s) :: 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
99 255073 Private 9 Tree(s) :: 17 173R Glenview Dr   Back Yard : Yard Tree Private 2                              
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
1773 116537 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 6 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
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
4313 105327 Significant Tree 6 Tree(s) :: 17 2051 03rd St 1 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
5622 251139 Significant Tree 6 Tree(s) :: 17 621X Gough St 1 Back Yard : Yard Tree Private 2   03/10/2017 12:00:00 AM 3   Permit Number 779685                    
6104 92481 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 12 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
7964 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
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
23121 209183 DPW Maintained 1 Tree(s) :: 17 140 Kensington Way 3 Back Yard : Yard Tree Private 2   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994862.40668 2098482.07156 37.741737150351 -122.460380669142 (37.741737150351, -122.460380669142) 1 8 4 59 40
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
32266 108871 Property Tree 8 Tree(s) :: 17 99x OAKWOOD ST 1 Back Yard : Yard Tree Private 2           6005305 2104962 37.7601247169433 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
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
51717 115446 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 2 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
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
58512 253898 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 2 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
59930 251497 DPW Maintained 1 Tree(s) :: 17 329x Warren Dr 1 Back Yard : Yard Tree Private 2       3x3   5994610 2103362 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764) 1 5 4 63 12
61377 92475 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 5 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
62383 92476 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 6 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
63865 92484 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 15 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
67875 242822 DPW Maintained 1 Tree(s) :: 17 18 Ohlone Way 1 Back Yard : Yard Tree Private 2     46 Width 5ft   6002178.85689 2096424.55585 37.7365058551638 -122.434935735002 (37.7365058551638, -122.434935735002) 2 7 5 63 7
74399 92474 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 4 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
74590 115445 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 1 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
79585 108000 Significant Tree 6 Tree(s) :: 17 1000 Rhode Island St 1 Back Yard : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774025 6011852.20179 2103661.18899 37.7569205837919 -122.401999252275 (37.7569205837919, -122.401999252275) 10 3 8 28856 29
83572 119911 Undocumented 4 Tree(s) :: 17 67 Rebecca Ln 1 Back Yard : Yard Tree Private 2       3x3   6017125 2096711 37.7381296664541 -122.383279988851 (37.7381296664541, -122.383279988851) 10 3 8 58 1
84393 116534 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 3 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
90504 98893 Property Tree 8 Tree(s) :: 17 216 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
92154 97177 Property Tree 8 Tree(s) :: 17 257 Roosevelt Way   Back Yard : Yard Tree Private 2         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.7658190148973 -122.440304070451 (37.7658190148973, -122.440304070451) 15 5 5 28862 3
94535 87564 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 3 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
98835 121143 Undocumented 4 Tree(s) :: 17 90X Warren Dr 1 Back Yard : Yard Tree Private 2       3x3   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
99462 209188 DPW Maintained 1 Tree(s) :: 17 156 Kensington Way 2 Back Yard : Yard Tree Private 2   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994823.81863 2098534.27999 37.7418782818471 -122.460517875106 (37.7418782818471, -122.460517875106) 1 8 4 59 40
99841 98436 Property Tree 8 Tree(s) :: 17 238 Glenview Dr   Back Yard : Yard Tree Private 2           5999035 2100736 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035) 2 5 5 63 38
104393 112422 Undocumented 4 Tree(s) :: 17 279 Topaz Way   Back Yard : Yard Tree Private 2   07/29/2015 12:00:00 AM 3 3x3 Permit Number 775772 6001205.6 2097796.6 37.7402178594385 -122.438398959733 (37.7402178594385, -122.438398959733) 2 7 5 63 7
105492 116536 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 5 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
105747 98892 Property Tree 8 Tree(s) :: 17 220 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
111867 115459 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 1 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
113384 98890 Property Tree 8 Tree(s) :: 17 256 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
113829 101236 Significant Tree 6 Tree(s) :: 17 895X Church St 1 Back Yard : Yard Tree Private 2   10/05/2012 12:00:00 AM 13   Permit Number 769299 6004383.5 2103691.7 37.7565846850157 -122.427831000859 (37.7565846850157, -122.427831000859) 2 4 5 28862 3
117826 251307 DPW Maintained 1 Tree(s) :: 17 200 Cashmere St 1 Back Yard : Yard Tree Private 2       3x3   6016315 2096328 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871) 10 3 8 58 1
118076 242821 DPW Maintained 1 Tree(s) :: 17 18 Ohlone Way 2 Back Yard : Yard Tree Private 2     37 Width 5ft   6002176.86514 2096431.69756 37.7365253515621 -122.434943131915 (37.7365253515621, -122.434943131915) 2 7 5 63 7
130338 92480 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 10 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
137488 98501 Property Tree 8 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
139299 87562 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 1 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
142152 117309 Significant Tree 6 Tree(s) :: 17 3711 19th Ave 1 Back Yard : Yard Tree Private 2   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777997 5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
142995 108574 Property Tree 8 Tree(s) :: 17 1891 15th St 1 Back Yard : Yard Tree Private 2       7x8   6004884.86016 2107160.44126 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904) 8 4 5 28853 19
143694 116535 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 4 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
147070 88028 Permitted Site 7 Tree(s) :: 17 495 Pacheco St 1 Back Yard : Yard Tree Private 2   06/23/2008 12:00:00 AM     Permit Number 51051 5993544.7 2101797.8 37.750765410178 -122.465177603148 (37.750765410178, -122.465177603148) 1 8 4 29491 40
149268 106458 Property Tree 8 Tree(s) :: 17 71 HANCOCK ST   Back Yard : Yard Tree Private 2           6003861.6 2105050 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 4 5 28862 3
151096 242820 DPW Maintained 1 Tree(s) :: 17 37 Poppy Ln 2 Back Yard : Yard Tree Private 2     17 Width 2ft   6002456.61791 2096763.39514 37.7374519967974 -122.4339996118 (37.7374519967974, -122.4339996118) 2 7 5 63 7
155860 96938 Property Tree 8 Tree(s) :: 17 1306 Cole St   Back Yard : Yard Tree Private 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9
170834 107493 Significant Tree 6 Tree(s) :: 17 180 BARTLETT ST 1 Back Yard : Yard Tree Private 2   11/10/2014 12:00:00 AM 3   Permit Number 774017 6006657.2 2102756.7 37.7541457516772 -122.419901368465 (37.7541457516772, -122.419901368465) 2 4 7 28859 19
177119 114191 Significant Tree 6 Tree(s) :: 17 201 Delano Ave 7 Back Yard : Yard Tree Private 2     20   Permit Number 776814 6000172.52130735 2092388.14283689 37.7253086814057 -122.44158289611 (37.7253086814057, -122.44158289611) 9 7 6 28861 25
178454 96779 Significant Tree 6 Tree(s) :: 17 555 Melrose Ave 1 Back Yard : Yard Tree Private 2   07/18/2011 12:00:00 AM     Permit Number 767966 5996882.6 2095364.1 37.7332919614683 -122.45317051412 (37.7332919614683, -122.45317051412) 9 7 4 59 40
179476 115460 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 2 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
181279 87563 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 2 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
183899 253897 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 1 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
188105 108171 Undocumented 4 Tree(s) :: 17 59x MACONDRAY LN 1 Back Yard : Yard Tree Private 2     30   Permit Number 774825 6008454 2119149 37.7992561803015 -122.414847646907 (37.7992561803015, -122.414847646907) 5 1 10 308 32
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
192331 92485 Permitted Site 7 Tree(s) :: 17 155 Greenwich St 11 Back Yard : Yard Tree Private 2   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015 2120477 37.8031019907049 -122.402618721555 (37.8031019907049, -122.402618721555) 3 1 10 28860 6
25036 95137 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 127 Front Yard : Tree Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590 2110608 37.7751884337973 -122.451824172116 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
33415 95138 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 128 Front Yard : Tree Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590 2110608 37.7751884337973 -122.451824172116 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
37942 98308 Significant Tree 6 Tree(s) :: 17 1490 Fairfax Ave 1 Front Yard : Tree Private 2   01/25/2012 12:00:00 AM   3x3 Permit Number 768575 6016246.6 2097899.9 37.7413455620636 -122.386399955147 (37.7413455620636, -122.386399955147) 10 3 8 58 1
119552 101202 Significant Tree 6 Tree(s) :: 17 7070 California St 1 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
126350 101810 Significant Tree 6 Tree(s) :: 17 38 Nebraska St 1 Front Yard : Tree Private 2   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261909 (37.740765720819, -122.41052261909) 10 7 7 28859 2
146707 103477 Significant Tree 6 Tree(s) :: 17 875 El Camino Del Mar 1 Front Yard : Tree Private 2   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739) 11 6 1 55 15
162612 101203 Significant Tree 6 Tree(s) :: 17 7070 California St 2 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
1701 54592 DPW Maintained 1 Tree(s) :: 17 329 Mississippi St 1 Front Yard : Cutout Tree Private 2   03/26/2020 12:00:00 AM 3 3x4 Permit Number 785178 6014074.3359 2105511.64681 37.7621253108683 -122.394443787777 (37.7621253108683, -122.394443787777) 10 3 8 28856 29
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
3640 173712 DPW Maintained 1 Tree(s) :: 17 699x 29th St 1 Front Yard : Cutout Tree Private 2   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089 2098776 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427) 2 7 5 63 7
20835 63301 Permitted Site 7 Tree(s) :: 17 3261 Harrison St 1 Front Yard : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM 18   Permit Number 53402 6009046.03746796 2099701.90725396 37.7458922633049 -122.411424351246 (37.7458922633049, -122.411424351246) 2 7 7 28859 2
21303 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727 2102215 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741) 1 8 4 29491 12
23525 36443 Permitted Site 7 Tree(s) :: 17 1260 Plymouth Ave 1 Front Yard : Cutout Tree Private 2   11/20/2009 12:00:00 AM   3x3 Permit Number 53041 5995883.45550893 2092448.59347632 37.725229366758 -122.456414062747 (37.725229366758, -122.456414062747) 9 7 4 28861 40
29146 31647 Permitted Site 7 Tree(s) :: 17 4500 Ulloa St 4 Front Yard : Cutout Tree Private 2   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106) 1 8 3 29491 35
32335 173635 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 1 Front Yard : Cutout Tree Private 2   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
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
38995 88447 Permitted Site 7 Tree(s) :: 17 93 Prentiss St 1 Front Yard : Cutout Tree Private 2   07/14/2008 12:00:00 AM   3x3 Permit Number 51413 6008891.7 2098141.7 37.7415996198956 -122.411847801096 (37.7415996198956, -122.411847801096) 10 7 7 28859 2
41739 253164 Planning Code 138.1 required 2 Tree(s) :: 17 146 Cambridge St 1 Front Yard : Cutout Tree Private 2   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.41191 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225) 9 7 7 309 5
43517 88608 Significant Tree 6 Tree(s) :: 17 350 Urbano Dr 1 Front Yard : Cutout Tree Private 2   08/01/2008 12:00:00 AM     Permit Number 51562 5991996 2092560 37.7253113201117 -122.469860593138 (37.7253113201117, -122.469860593138) 9 8 4 59 40
48200 108097 Significant Tree 6 Tree(s) :: 17 3370 Washington St 2 Front Yard : Cutout Tree Private 2           5998663.3699 2115944.31994 37.789901994506 -122.448495552231 (37.789901994506, -122.448495552231) 13 6 1 54 31
48260 94583 Permitted Site 7 Tree(s) :: 17 90 Joost Ave 1 Front Yard : Cutout Tree Private 2       3x3   6001518 2094975.2 37.732488714298 -122.437116855647 (37.732488714298, -122.437116855647) 9 7 5 63 40
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
51498 88569 Significant Tree 6 Tree(s) :: 17 1335 Webster St 60 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
58472 104728 Significant Tree 6 Tree(s) :: 17 3212 Jackson St 1 Front Yard : Cutout Tree Private 2   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492) 13 6 1 54 31
67887 108239 Permitted Site 7 Tree(s) :: 17 15 ASHBURY TER 1 Front Yard : Cutout Tree Private 2   01/14/2015 12:00:00 AM 3 5x50 Permit Number 774721 5999554.7 2106911.6 37.7651513833487 -122.444762103204 (37.7651513833487, -122.444762103204) 15 5 5 29492 9
73226 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.7901043022718 -122.429743441495 (37.7901043022718, -122.429743441495) 13 9 1 29490 27
77876 88571 Significant Tree 6 Tree(s) :: 17 1335 Webster St 62 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
80380 114184 Significant Tree 6 Tree(s) :: 17 2454 HYDE ST 1 Front Yard : Cutout Tree Private 2   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060 2120781 37.8036588138585 -122.41978724304 (37.8036588138585, -122.41978724304) 5 1 1 28858 32
92659 85428 Significant Tree 6 Tree(s) :: 17 43 Ora Way 1 Front Yard : Cutout Tree Private 2   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.7416050219872 -122.437232403771 (37.7416050219872, -122.437232403771) 2 7 5 63 7
94087 96183 DPW Maintained 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout Landscaping Private 2           6007366 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618) 8 4 7 28853 19
94624 110787 Section 143 10 Tree(s) :: 17 850x SANCHEZ ST 1 Front Yard : Cutout Tree Private 2   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
105490 31648 Permitted Site 7 Tree(s) :: 17 4500 Ulloa St 3 Front Yard : Cutout Tree Private 2   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106) 1 8 3 29491 35
114698 173713 DPW Maintained 1 Tree(s) :: 17 699x 29th St 2 Front Yard : Cutout Tree Private 2   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089 2098776 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427) 2 7 5 63 7
121105 88572 Significant Tree 6 Tree(s) :: 17 1335 Webster St 66 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
122699 109973 DPW Maintained 1 Tree(s) :: 17 1458 43rd Ave 1 Front Yard : Cutout Tree Private 2   03/16/2015 12:00:00 AM 3 3x3   5982831.2 2105195.6 37.7594711884194 -122.502476670215 (37.7594711884194, -122.502476670215) 1 8 3 56 35
128997 109708 Significant Tree 6 Tree(s) :: 17 621 Laguna Honda Blvd 3 Front Yard : Cutout Tree Private 2 FUF 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.7457002690083 -122.457505029341 (37.7457002690083, -122.457505029341) 1 5 4 59 40
130286 253951 Significant Tree 6 Tree(s) :: 17 431 Yerba Buena Ave 2 Front Yard : Cutout Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780852 5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);