trees

11,761 rows where qSpecies_id = 17 sorted by SiteOrder

✎ 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)
75644 92824 Permitted Site 7 Tree(s) :: 17 75 Buena Vista Ter   Sidewalk: Curb side : Cutout Tree Private 2   11/18/2009 12:00:00 AM   3x3 Permit Number 53038 6001499.7 2107781.6 37.7676509917015 -122.43809715918 (37.7676509917015, -122.43809715918) 15 5 5 29492 3
81422 86780 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
81747 107245 Significant Tree 6 Tree(s) :: 17 140 CEDRO AVE   Front Yard : Yard Tree Private 2           5991993.7 2093259.3 37.7272312918526 -122.469919436342 (37.7272312918526, -122.469919436342) 9 8 4 59 40
81928 107454 Undocumented 4 Tree(s) :: 17 2101 CHESTNUT ST   Sidewalk: Curb side : Cutout Tree Private 2           6001686.4 2119715.1 37.8004279539124 -122.438306415372 (37.8004279539124, -122.438306415372) 13 9 1 57 17
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
83874 104304 Permitted Site 7 Tree(s) :: 17 414 LIBERTY ST   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2014 12:00:00 AM   2x4 Permit Number 770200 6003582 2103943 37.7572293215726 -122.430620805889 (37.7572293215726, -122.430620805889) 2 4 5 28862 3
85579 104826 Permitted Site 7 Tree(s) :: 17 52 Alpine Ter   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770816 6001492.3 2108495.8 37.7696115871053 -122.438173923211 (37.7696115871053, -122.438173923211) 15 5 5 29492 9
85997 111996 Significant Tree 6 Tree(s) :: 17 501 Point Lobos Ave   Front Yard : Yard Tree Private 2   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.7796878572283 -122.508495636007 (37.7796878572283, -122.508495636007) 11 6 2 55 26
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
86844 112564 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
87462 107036 Significant Tree 6 Tree(s) :: 17 350 08th St   Sidewalk: Property side : Cutout Tree Private 2   07/23/2014 12:00:00 AM   7x7 Permit Number 772214 6009826 2110084 37.7744428576765 -122.409459923405 (37.7744428576765, -122.409459923405) 8 2 9 28853 34
88857 100242 DPW Maintained 1 Tree(s) :: 17 76 Linda St   Sidewalk: Curb side : Pot Landscaping Private 2           6005815 2105046 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568) 2 4 5 28859 19
90033 107359 Undocumented 4 Tree(s) :: 17 3636 Clay St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 771771 5997400.59946 2115444.59193 37.7884575935217 -122.452828517416 (37.7884575935217, -122.452828517416) 11 6 1 54 31
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
91537 85195 DPW Maintained 1 Tree(s) :: 17 333 Eucalyptus Dr   Sidewalk: Property side : Cutout Landscaping Private 2           5990168 2094689 37.7310511825826 -122.476335191755 (37.7310511825826, -122.476335191755) 1 8 4 64 14
91615 95952 Undocumented 4 Tree(s) :: 17 46 Bosworth St   Sidewalk: Curb side : Cutout Tree Private 2     6 1x1   6004452 2095346 37.7336731880288 -122.426999715945 (37.7336731880288, -122.426999715945) 2 7 5 28861 25
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
92648 28968 DPW Maintained 1 Tree(s) :: 17 2455 Hyde St   Sidewalk: Curb side : Cutout Tree DPW 1           6006975.5076786 2120876.6023829 37.8039165535698 -122.420086422377 (37.8039165535698, -122.420086422377) 5 1 1 28858 32
92815 86775 Permitted Site 7 Tree(s) :: 17 21 Commonwealth Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/05/2007 12:00:00 AM   3x3 Permit Number 49747 5996467 2114425.1 37.7856047990731 -122.455984873003 (37.7856047990731, -122.455984873003) 11 6 1 54 31
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
94473 96289 DPW Maintained 1 Tree(s) :: 17 228 30th St   Sidewalk: Curb side : Cutout Landscaping Private 2         Permit Number 767877 6005120 2098458 37.7422557889482 -122.424911572967 (37.7422557889482, -122.424911572967) 2 7 5 63 22
95953 95234 Significant Tree 6 Tree(s) :: 17 7 Almaden Ct   Front Yard : Yard Tree Private 2   01/25/2011 12:00:00 AM     Permit Number 767129 5995849 2112535 37.7803795989447 -122.457986127959 (37.7803795989447, -122.457986127959) 11 6 2 54 16
95999 107525 Permitted Site 7 Tree(s) :: 17 3606 TARAVAL ST   Sidewalk: Curb side : Cutout Tree Private 2           5981997.1 2098820.7 37.7419184550143 -122.504888957614 (37.7419184550143, -122.504888957614) 1 8 3 29491 35
98463 107295 Undocumented 4 Tree(s) :: 17 218 Howth St   Sidewalk: Curb side : Cutout Tree Private 2   08/18/2014 12:00:00 AM     Permit Number 773357 5997350.11104 2090721.936 37.7205724606378 -122.451219539387 (37.7205724606378, -122.451219539387) 9 8 6 28861 24
99018 106237 Undocumented 4 Tree(s) :: 17 607 BRUSSELS ST   Sidewalk: Property side : Cutout Tree Private 2           6010922.6 2091903.6 37.724584840414 -122.404386617586 (37.724584840414, -122.404386617586) 10 3 7 309 28
99131 94962 DPW Maintained 1 Tree(s) :: 17 3098@Lyon Pacific Ave   Sidewalk: Property side : Cutout Landscaping Private 2   10/25/2010 12:00:00 AM       5999362 2116697.3 37.7920093994348 -122.446132548429 (37.7920093994348, -122.446132548429) 13 6 1 29490 27
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
100489 105773 Permitted Site 7 Tree(s) :: 17 105 Hoffman Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 771196 6000637.4 2102505.5 37.7531150384646 -122.440701242772 (37.7531150384646, -122.440701242772) 2 4 5 28862 22
101175 106092 Permitted Site 7 Tree(s) :: 17 2397 Diamond St   Sidewalk: Curb side : Cutout Tree Private 2   04/07/2014 12:00:00 AM   3x3 Permit Number 769667 6001819.7 2097112.6 37.7383746657841 -122.436226715207 (37.7383746657841, -122.436226715207) 2 7 5 63 7
102734 88530 Permitted Site 7 Tree(s) :: 17 1930x Pine St   Sidewalk: Curb side : Cutout Tree Private 2   09/18/2014 12:00:00 AM 3 3x3 Permit Number 772191 6004696 2115413 37.7887861985618 -122.427585317117 (37.7887861985618, -122.427585317117) 13 9 11 28858 27
102859 87188 Significant Tree 6 Tree(s) :: 17 2119 Bush St   Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50204 6002998 2114831 37.7870919849741 -122.433418544226 (37.7870919849741, -122.433418544226) 13 9 11 29490 27
103417 106912 Permitted Site 7 Tree(s) :: 17 2447 TARAVAL ST   Sidewalk: Curb side : Cutout Tree Private 2           5985552.6 2098834.9 37.7421659771756 -122.49259640996 (37.7421659771756, -122.49259640996) 1 8 3 29491 35
104379 94588 Permitted Site 7 Tree(s) :: 17 4080 24th St   Sidewalk: Curb side : Cutout Tree Private 2   10/04/2010 12:00:00 AM   3x3 Permit Number 53765 6002663.9 2101828.7 37.7513719025488 -122.433644846842 (37.7513719025488, -122.433644846842) 2 4 5 28862 22
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
104431 111726 DPW Maintained 1 Tree(s) :: 17 1833 Laguna St   Sidewalk: Curb side : Cutout Tree Private 2   06/19/2015 12:00:00 AM 3 3x3   6004353.4 2115169.4 37.7880979499935 -122.428753291942 (37.7880979499935, -122.428753291942) 13 9 11 29490 27
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
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
106574 106496 Permitted Site 7 Tree(s) :: 17 352 Corbett Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/05/2014 12:00:00 AM   4X3 Permit Number 772747 5999237.2 2105011.2 37.759915235248 -122.445723576033 (37.759915235248, -122.445723576033) 15 5 5 28862 3
107867 105219 Undocumented 4 Tree(s) :: 17 1799X 26TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988124 2103397 37.7548423040305 -122.484039888389 (37.7548423040305, -122.484039888389) 1 8 3 56 35
107954 105206 DPW Maintained 1 Tree(s) :: 17 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree Private 2   01/22/2015 12:00:00 AM 3 3x3 Permit Number 774528 5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
108068 107643 DPW Maintained 1 Tree(s) :: 17 455 ATHENS ST   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF     4x4   6003769 2090659.8 37.7207672837341 -122.429027043999 (37.7207672837341, -122.429027043999) 9 7 6 28861 5
111458 93908 Permitted Site 7 Tree(s) :: 17 1238 Sutter St   Sidewalk: Property side : Pot Tree Private 2   04/26/2010 12:00:00 AM     Permit Number 53382 6006657 2114990 37.7877354690453 -122.420770480664 (37.7877354690453, -122.420770480664) 13 9 10 28858 21
111710 107283 Undocumented 4 Tree(s) :: 17 4214 26TH ST   Sidewalk: Curb side : Cutout Tree Private 2           6002441.8 2100664.9 37.7481637783896 -122.434329697409 (37.7481637783896, -122.434329697409) 2 4 5 28862 22
112445 89237 Permitted Site 7 Tree(s) :: 17 1391 Clayton St   Sidewalk: Curb side : Cutout Tree Private 2   08/20/2014 12:00:00 AM   3x3 Permit Number 773358 5999019 2104613 37.7588094164011 -122.446449573242 (37.7588094164011, -122.446449573242) 15 5 5 28862 12
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
115447 85273 DPW Maintained 1 Tree(s) :: 17 36 Santa Cruz Ave   Sidewalk: Property side : Cutout Landscaping Private 2           5993017.1 2086630.8 37.709090137513 -122.465900153218 (37.709090137513, -122.465900153218) 9 8 6 28861 25
116212 89327 Permitted Site 7 Tree(s) :: 17 30 Crestline Dr   Sidewalk: Curb side : Cutout Tree Private 2   11/07/2008 12:00:00 AM   3x3 Permit Number 51919 5999054 2101396 37.7499783244546 -122.446097133024 (37.7499783244546, -122.446097133024) 2 5 5 63 38
116221 104863 Permitted Site 7 Tree(s) :: 17 3946 25th St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770427 6004212.1 2101360.5 37.7501740590096 -122.428257625423 (37.7501740590096, -122.428257625423) 2 4 5 28862 22
116710 86798 Permitted Site 7 Tree(s) :: 17 266 Lexington St   Sidewalk: Curb side : Cutout Tree Private 2   10/03/2007 12:00:00 AM   3x3 Permit Number 49714 6006494 2104554 37.7590715260193 -122.42059333056 (37.7590715260193, -122.42059333056) 2 4 7 28859 19
116761 110023 Permitted Site 7 Tree(s) :: 17 452 Molimo Dr   Sidewalk: Curb side : Cutout Tree Private 2   03/18/2015 12:00:00 AM 3 3x3 Permit Number 774741 5997471.2 2097283.4 37.7385956151498 -122.45127394441 (37.7385956151498, -122.45127394441) 9 7 4 59 40
118343 86881 Permitted Site 7 Tree(s) :: 17 801 Howard St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 771223 6011833 2113224.2 37.7831773700909 -122.402738173851 (37.7831773700909, -122.402738173851) 6 2 9 28853 34
119847 89137 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
119969 107867 Permitted Site 7 Tree(s) :: 17 483 03RD ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013753.3 2112637.3 37.7816729073921 -122.396053518829 (37.7816729073921, -122.396053518829) 6 2 9 28856 6
120050 96291 DPW Maintained 1 Tree(s) :: 17 1294 Union St   Sidewalk: Property side : Pot Landscaping Private 2   03/21/2011 12:00:00 AM       6006773 2119090 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797) 5 9 1 28858 32
121235 86895 Significant Tree 6 Tree(s) :: 17 321 Haight St   Front Yard : Yard Tree Private 2   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784) 7 9 11 28852 10
123690 98250 DPW Maintained 1 Tree(s) :: 17 650 Eddy St   Sidewalk: Curb side : Cutout Landscaping Private 2         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554) 7 9 9 28858 36
126618 89140 DPW Maintained 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Property 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
127413 99743 Undocumented 4 Tree(s) :: 17 447 Clipper St   Sidewalk: Curb side : Cutout Tree Private 2           6002285 2100894 37.7487839315189 -122.43488828753 (37.7487839315189, -122.43488828753) 2 4 5 28862 22
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
127951 106236 Undocumented 4 Tree(s) :: 17 921 DWIGHT ST   Sidewalk: Curb side : Cutout Tree Private 2           6008890 2090823.6 37.721505591324 -122.411336818418 (37.721505591324, -122.411336818418) 9 3 7 309 28
129058 105708 Permitted Site 7 Tree(s) :: 17 269 Randall St   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 771165 6003863.5 2097760.5 37.7402695610174 -122.429206439034 (37.7402695610174, -122.429206439034) 2 7 5 63 7
130088 100868 Undocumented 4 Tree(s) :: 17 655 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014591.2 2111956.1 37.7798490696224 -122.393107079978 (37.7798490696224, -122.393107079978) 6 2 9 28856 6
131144 93519 Permitted Site 7 Tree(s) :: 17 1300 Shrader St   Sidewalk: Curb side : Cutout Tree Private 2   03/08/2010 12:00:00 AM   3x3 Permit Number 53238 5997787 2106170 37.7630141020872 -122.450822643136 (37.7630141020872, -122.450822643136) 15 5 11 29492 9
131215 104942 Undocumented 4 Tree(s) :: 17 840X Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2   09/11/2014 12:00:00 AM 3   Permit Number 770723 5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
131480 104811 Permitted Site 7 Tree(s) :: 17 1900 08th Ave   Sidewalk: Curb side : Yard Tree Private 2   11/18/2013 12:00:00 AM     Permit Number 770426 5993817.2 2102486.9 37.7526732127641 -122.464285305355 (37.7526732127641, -122.464285305355) 1 8 4 29491 40
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
138569 107093 Permitted Site 7 Tree(s) :: 17 152 Elsie St   Sidewalk: Curb side : Cutout Tree Private 2   07/25/2014 12:00:00 AM     Permit Number 773381 6007025.06774 2098325.61272 37.7419997059315 -122.418315035519 (37.7419997059315, -122.418315035519) 2 7 7 28859 2
139592 252871 DPW Maintained 1 Tree(s) :: 17 2557 Sutter St   Front Yard : Yard Tree Private 2   01/30/2018 12:00:00 AM 3 3x3 Permit Number 779185 5999847 2113975 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096) 15 6 11 29490 31
140484 92775 Permitted Site 7 Tree(s) :: 17 2701 Pacific Ave   Sidewalk: Curb side : Cutout Landscaping Private 2   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141) 13 6 1 29490 27
140977 86820 Permitted Site 7 Tree(s) :: 17 345 Santiago St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49707 5991856 2099765 37.7450863408288 -122.47086916045 (37.7450863408288, -122.47086916045) 1 8 4 29491 40
142194 89329 Permitted Site 7 Tree(s) :: 17 1216 Treat Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/16/2016 12:00:00 AM 3 3x3 Permit Number 778419 6008665.9 2101450.3 37.750671631411 -122.412862409199 (37.750671631411, -122.412862409199) 2 4 7 28859 19
142477 89139 DPW Maintained 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Property 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
142647 92825 Permitted Site 7 Tree(s) :: 17 393 San Benito Way   Sidewalk: Curb side : Cutout Tree Private 2   11/18/2009 12:00:00 AM   3x3 Permit Number 53039 5992626.8 2093932.1 37.7291152105949 -122.467779744785 (37.7291152105949, -122.467779744785) 9 8 4 59 40
143544 29903 DPW Maintained 1 Tree(s) :: 17 750 San Jose Ave   Sidewalk: Curb side : Cutout Tree DPW 1           6005639.13550214 2098758.44315121 37.7431100472957 -122.423137910761 (37.7431100472957, -122.423137910761) 2 7 5 28859 22
144070 97894 Significant Tree 6 Tree(s) :: 17 2927 Folsom St   Front Yard : Yard Tree Private 2   02/29/2012 12:00:00 AM 30   Permit Number 768566 6008395 2101384 37.7504743768844 -122.413794517972 (37.7504743768844, -122.413794517972) 2 4 7 28859 19
145860 86752 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
146972 104810 Permitted Site 7 Tree(s) :: 17 685 Marina Blvd   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 770974 5999736.8 2121509.8 37.8052446370698 -122.445181890463 (37.8052446370698, -122.445181890463) 13 9 1 57 17
147509 105514 Undocumented 4 Tree(s) :: 17 4004 20TH ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003604.3 2104237.3 37.7580386626716 -122.430564683072 (37.7580386626716, -122.430564683072) 2 4 5 28862 3
148822 107196 Undocumented 4 Tree(s) :: 17 3359 21st St   Sidewalk: Curb side : Cutout Tree Private 2       12x8   6005949 2103729 37.7567755383179 -122.422419582476 (37.7567755383179, -122.422419582476) 2 4 5 28859 19
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
149412 107468 Undocumented 4 Tree(s) :: 17 479 SANCHEZ ST   Sidewalk: Curb side : Cutout Tree Private 2           6003670.2 2105503.2 37.7615182547925 -122.430427093318 (37.7615182547925, -122.430427093318) 8 4 5 28862 3
149471 107820 Permitted Site 7 Tree(s) :: 17 45 CHENERY ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005046.6 2098072.8 37.7411939710316 -122.425137965322 (37.7411939710316, -122.425137965322) 2 7 5 63 7
152155 107078 DPW Maintained 1 Tree(s) :: 17 92 Homestead St   Sidewalk: Property side : Cutout Landscaping Private 2   07/25/2014 12:00:00 AM   3x3.5 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227) 2 4 5 28862 22
152856 107939 Permitted Site 7 Tree(s) :: 17 364 Richland Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3   Permit Number 770440 6007084.72543 2095976.12398 37.7355518884678 -122.417942244485 (37.7355518884678, -122.417942244485) 2 7 7 28859 2
153085 93131 Permitted Site 7 Tree(s) :: 17 700 Brotherhood Way   Sidewalk: Property side : Tree Private 2   02/10/2010 12:00:00 AM     Permit Number 53178 5991178.9 2088065.4 37.7129229890255 -122.472357697274 (37.7129229890255, -122.472357697274) 1 8 4 64 14
153431 93554 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
153742 96292 DPW Maintained 1 Tree(s) :: 17 1294 Union St   Sidewalk: Property side : Pot Landscaping Private 2   03/21/2011 12:00:00 AM       6006773 2119090 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797) 5 9 1 28858 32
153838 94436 Permitted Site 7 Tree(s) :: 17 127 Grand View Ave   Sidewalk: Property side : Cutout Tree Private 2   08/02/2010 12:00:00 AM   3x3 Permit Number 53661 6000876.8 2103580.3 37.7560798093856 -122.439950411199 (37.7560798093856, -122.439950411199) 2 4 5 28862 38
154702 93130 Permitted Site 7 Tree(s) :: 17 700 Brotherhood Way   Sidewalk: Property side : Tree Private 2   02/10/2010 12:00:00 AM     Permit Number 53178 5991178.9 2088065.4 37.7129229890255 -122.472357697274 (37.7129229890255, -122.472357697274) 1 8 4 64 14
155047 89354 Permitted Site 7 Tree(s) :: 17 1636 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2   11/17/2008 12:00:00 AM   3x3 Permit Number 51934 6005074.4 2119304.5 37.7994926681844 -122.426553317623 (37.7994926681844, -122.426553317623) 13 9 1 57 17
155494 86772 Permitted Site 7 Tree(s) :: 17 376 Eureka St   Sidewalk: Curb side : Cutout Tree Private 2   10/05/2007 12:00:00 AM   3x3 Permit Number 49744 6001477 2103473 37.7558193380332 -122.437867037362 (37.7558193380332, -122.437867037362) 2 4 5 28862 3
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
157068 89233 Permitted Site 7 Tree(s) :: 17 125 Bemis St   Sidewalk: Curb side : Cutout Tree Private 2   10/09/2008 12:00:00 AM   3x3 Permit Number 51867 6003580 2096707 37.7373608379824 -122.430111532552 (37.7373608379824, -122.430111532552) 2 7 5 63 7
157301 104291 Permitted Site 7 Tree(s) :: 17 530 DAY ST   Sidewalk: Curb side : Cutout Tree Private 2       2x4   6002507 2098619 37.7425499168777 -122.433958018119 (37.7425499168777, -122.433958018119) 2 7 5 63 7
157484 105210 Undocumented 4 Tree(s) :: 17 2467 38TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       4x3   5984528 2098448 37.7410436924745 -122.496110565766 (37.7410436924745, -122.496110565766) 1 8 3 29491 35
158298 107212 Undocumented 4 Tree(s) :: 17 556 NATOMA ST   Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009971.5 2111821.4 37.7792215026621 -122.4090792269 (37.7792215026621, -122.4090792269) 14 2 9 28853 34
158515 112566 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
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
161923 88997 Permitted Site 7 Tree(s) :: 17 71 Bemis St   Sidewalk: Curb side : Cutout Tree Private 2   09/24/2008 12:00:00 AM   3x3 Permit Number 51746 6003720 2096818 37.7376735468888 -122.429635401887 (37.7376735468888, -122.429635401887) 2 7 5 63 7
162713 96182 DPW Maintained 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout Landscaping Private 2   04/04/2011 12:00:00 AM     Permit Number 767813 6007366 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618) 8 4 7 28853 19

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