155 rows where qSpecies_id = 68 sorted by qSiteInfo

View and edit SQL

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)
55073 213701 DPW Maintained 1 Prunus spp :: Cherry 68 700 Junipero Serra Blvd 130 : Tree Private 2     8 Width 0ft   5991210.94255 2091714.66662 37.7229448341183 -122.472512833822 (37.7229448341183, -122.472512833822) 9 8 4 64 40
129139 196536 DPW Maintained 1 Prunus spp :: Cherry 68 1422 Rhode Island St 1 : Tree Private 2     10 Width 3ft   6011983.19537 2101729.68858 37.7516244165498 -122.401410487604 (37.7516244165498, -122.401410487604) 10 3 8 28856 29
40074 238536 DPW Maintained 1 Prunus spp :: Cherry 68 1 Penny Ln 4 Back Yard : Yard Tree Private 2     3 Width 2ft   6002355.47862 2096490.80035 37.736697774076 -122.434329814067 (37.736697774076, -122.434329814067) 2 7 5 63 7
83211 93959 Permitted Site 7 Prunus spp :: Cherry 68 419 Elizabeth St   Front Yard : Cutout Tree Private 2       3x3 Permit Number 53399 6003681 2102149 37.7523090296265 -122.430150445418 (37.7523090296265, -122.430150445418) 2 4 5 28862 22
1082 261856 DPW Maintained 1 Prunus spp :: Cherry 68 937x Meade Ave 4 Front Yard : Yard Tree DPW 1       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
1810 253859 Planning Code 138.1 required 2 Prunus spp :: Cherry 68 130 Graystone Ter 1 Front Yard : Yard Tree Private 2       6x6 Permit Number 780749 5998952.88335 2104176.47413 37.7576070480405 -122.446646826709 (37.7576070480405, -122.446646826709) 2 5 5 28862 3
4637 247987 DPW Maintained 1 Prunus spp :: Cherry 68 124 Mullen Ave 1 Front Yard : Yard Tree Private 2     11     6009857.2555 2099808.73815 37.7462310644209 -122.408626794296 (37.7462310644209, -122.408626794296) 2 7 7 28859 2
57739 247592 DPW Maintained 1 Prunus spp :: Cherry 68 800 Tompkins Ave 13 Front Yard : Yard Tree Private 2     20     6008994.80779 2096446.35961 37.7369503684581 -122.411371547678 (37.7369503684581, -122.411371547678) 10 7 7 28859 2
58981 196335 DPW Maintained 1 Prunus spp :: Cherry 68 1900 19th St 10 Front Yard : Yard Tree Private 2     1     6012008.47004 2105145.92381 37.761006057794 -122.401563163706 (37.761006057794, -122.401563163706) 10 3 8 28856 29
65912 196067 DPW Maintained 1 Prunus spp :: Cherry 68 2338 Lane St 2 Front Yard : Yard Tree Private 2     2 Width 5ft   6013920.54146 2092873.26714 37.7274144278184 -122.394090896496 (37.7274144278184, -122.394090896496) 10 3 8 58 1
107251 238534 DPW Maintained 1 Prunus spp :: Cherry 68 671 Church St 39 Front Yard : Yard Tree Private 2     12 Width 3ft   6004315.93981 2105094.00544 37.7604312615151 -122.428164581928 (37.7604312615151, -122.428164581928) 2 4 5 28862 3
130764 249657 DPW Maintained 1 Prunus spp :: Cherry 68 2401 Lyon St 9 Front Yard : Yard Tree Private 2     5 Width 10ft   5999220.85646 2117228.07126 37.7934586955217 -122.446659110123 (37.7934586955217, -122.446659110123) 11   1 57 30
166835 196065 DPW Maintained 1 Prunus spp :: Cherry 68 602 Arthur Ave 28 Front Yard : Yard Tree Private 2     3     6015745.27894 2099859.59173 37.7466987082831 -122.388270101098 (37.7466987082831, -122.388270101098)   3 8 58 1
168750 116071 DPW Maintained 1 Prunus spp :: Cherry 68 4150X CLEMENT ST 1 Front Yard : Yard Tree DPW 1     8 3x3   5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
190691 196373 DPW Maintained 1 Prunus spp :: Cherry 68 1900 19th St 2 Front Yard : Yard Tree Private 2     1     6012066.64129 2105141.25616 37.760996487211 -122.401361645431 (37.760996487211, -122.401361645431) 10 3 8 28856 29
191979 196066 DPW Maintained 1 Prunus spp :: Cherry 68 602 Arthur Ave 29 Front Yard : Yard Tree Private 2     3     6015729.65904 2099863.28866 37.7467079937826 -122.38832437159 (37.7467079937826, -122.38832437159)   3 8 58 1
160 107490 DPW Maintained 1 Prunus spp :: Cherry 68 1306x Montgomery St 19 Median : Cutout Tree DPW 1     12     6011447.18476 2119974.76336 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963) 3 1 10 308 23
479 122586 Undocumented 4 Prunus spp :: Cherry 68 2500X Lyon St 6 Median : Cutout Tree Private 2     12 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
28549 16688 DPW Maintained 1 Prunus spp :: Cherry 68 600X Noriega St 1 Median : Cutout Tree DPW 1     3 2   5992180.8132004 2103552.59538 37.7555048781502 -122.470021758383 (37.7555048781502, -122.470021758383) 1 8 4 56 12
43975 122579 Undocumented 4 Prunus spp :: Cherry 68 2500X Lyon St 1 Median : Cutout Tree Private 2     30 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
82413 29657 DPW Maintained 1 Prunus spp :: Cherry 68 299X Cashmere St 1 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 3x3   6016930.34883 2095863.99444 37.7357931999838 -122.383894041377 (37.7357931999838, -122.383894041377) 10 3 8 58 1
164522 199890 DPW Maintained 1 Prunus spp :: Cherry 68 1200x Quesada Ave 1 Median : Cutout Tree DPW 1     3 Width 0ft   6017354.2822 2093058.6837 37.7281137963921 -122.382233221943 (37.7281137963921, -122.382233221943) 10 3 8 58 1
167001 11193 DPW Maintained 1 Prunus spp :: Cherry 68 162 Idora Ave 1 Median : Cutout Tree DPW 1     18 8   5995521.0890831 2099407.054304 37.7443147925186 -122.458170108957 (37.7443147925186, -122.458170108957) 1 8 4 59 40
12108 213702 DPW Maintained 1 Prunus spp :: Cherry 68 714 Detroit St 6 Side Yard : Yard Tree Private 2     2     5999450.30082 2095402.17977 37.7335433498509 -122.444296031758 (37.7335433498509, -122.444296031758) 9 7 4 63 40
55945 234919 DPW Maintained 1 Prunus spp :: Cherry 68 200 Saint Marys Ave 5 Side Yard : Yard Tree Private 2     2 Width 4ft   6003932.02563 2095971.19882 37.7353604264491 -122.428841975603 (37.7353604264491, -122.428841975603) 2 7 5 63 7
76705 196372 DPW Maintained 1 Prunus spp :: Cherry 68 1700 Armstrong Ave 7 Side Yard : Yard Tree Private 2     1     6013890.96771 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931) 10 3 8 58 1
85690 196063 DPW Maintained 1 Prunus spp :: Cherry 68 1751 22nd St 9 Side Yard : Yard Tree Private 2     3 Width 5ft   6012868.1198 2103766.18767 37.757265535503 -122.398493171445 (37.757265535503, -122.398493171445) 10 3 8 28856 29
85722 237945 DPW Maintained 1 Prunus spp :: Cherry 68 99 Aztec St 2 Side Yard : Yard Tree Private 2     14     6007968.29609 2099608.22097 37.7455745134701 -122.415144412305 (37.7455745134701, -122.415144412305) 2 7 7 28859 2
149775 196062 DPW Maintained 1 Prunus spp :: Cherry 68 1751 22nd St 8 Side Yard : Yard Tree Private 2     5 Width 5ft   6012859.76673 2103766.08005 37.7572647746544 -122.398522052264 (37.7572647746544, -122.398522052264) 10 3 8 28856 29
191781 196068 DPW Maintained 1 Prunus spp :: Cherry 68 1700 Armstrong Ave 9 Side Yard : Yard Tree Private 2     3     6013885.20395 2092887.61216 37.7274518522042 -122.394214063144 (37.7274518522042, -122.394214063144) 10 3 8 58 1
208 107457 Undocumented 4 Prunus spp :: Cherry 68 2682 16TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           5991487.4 2097177.7 37.7379609526954 -122.471955163509 (37.7379609526954, -122.471955163509) 1 8 4 29491 40
2397 19696 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 -3 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
3996 19960 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY41 18 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
5476 196535 DPW Maintained 1 Prunus spp :: Cherry 68 2050 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011971.89654 2104695.59738 37.7597675204772 -122.401658003519 (37.7597675204772, -122.401658003519) 10 3 8 28856 29
6901 80867 DPW Maintained 1 Prunus spp :: Cherry 68 123 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM 1 3x3 Permit Number 50655 6003213.7924 2092811.2834 37.7266433347113 -122.431099707385 (37.7266433347113, -122.431099707385) 9 7 6 28861 5
6955 19957 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
7074 19023 DPW Maintained 1 Prunus spp :: Cherry 68 3170 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     7 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372) 13 6 1 29490 27
7636 21084 DPW Maintained 1 Prunus spp :: Cherry 68 2192X Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905) 1 8 3 29491 35
8120 1497 DPW Maintained 1 Prunus spp :: Cherry 68 325 Arguello Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     2 3x3   5995534.5488977 2114067.6155393 37.7845696798314 -122.45918496627 (37.7845696798314, -122.45918496627) 11 6 2 54 11
9951 40088 Permitted Site 7 Prunus spp :: Cherry 68   1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1999 12:00:00 AM     Permit Number 41311                    
12237 88560 Permitted Site 7 Prunus spp :: Cherry 68 2901 Pierce St   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501 2118350 37.7966692015857 -122.438850093229 (37.7966692015857, -122.438850093229) 13 9 1 57 17
13644 212860 DPW Maintained 1 Prunus spp :: Cherry 68 129 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5994548.15716 2099444.62817 37.7443620078908 -122.461537000359 (37.7443620078908, -122.461537000359) 1 8 4 59 40
14491 19697 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
15177 72435 DPW Maintained 1 Prunus spp :: Cherry 68 339 Presidio Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5999048.26208 2115432.14991 37.7885177095774 -122.447126990534 (37.7885177095774, -122.447126990534) 13 6 1 54 31
15283 19958 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
17361 19956 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
18248 51214 Permitted Site 7 Prunus spp :: Cherry 68 111 Mission St 11 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2004 12:00:00 AM     Permit Number 47578 6014394.74626942 2116530.73461445 37.7923990500381 -122.394107054187 (37.7923990500381, -122.394107054187) 12 2 9 28855 6
21568 6944 DPW Maintained 1 Prunus spp :: Cherry 68 561 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/09/2006 12:00:00 AM 3 3X3   6004740.44786 2110511.39404 37.7753301167361 -122.427082271256 (37.7753301167361, -122.427082271256) 7 9 11 28852 10
22746 212861 DPW Maintained 1 Prunus spp :: Cherry 68 175 Garcia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5994619.09353 2099469.67136 37.7444348530002 -122.461293534079 (37.7444348530002, -122.461293534079) 1 8 4 59 40
24517 42766 Permitted Site 7 Prunus spp :: Cherry 68 415 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
25310 213700 DPW Maintained 1 Prunus spp :: Cherry 68 1316 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993037.4807 2106453.44522 37.7635193391717 -122.467270077655 (37.7635193391717, -122.467270077655) 1 8 11 56 12
25692 53523 Permitted Site 7 Prunus spp :: Cherry 68 221 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 4 3x3 Permit Number 775251 5994812.01878897 2088373.36040249 37.7139781801866 -122.459822827247 (37.7139781801866, -122.459822827247) 9 8 6 28861 24
26135 41411 Permitted Site 7 Prunus spp :: Cherry 68 531 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM     Permit Number 42023 6007932.96070428 2088253.06472002 37.7143937182098 -122.414463253601 (37.7143937182098, -122.414463253601) 9 7 8 309 39
39858 84640 DPW Maintained 1 Prunus spp :: Cherry 68 1363 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2009 12:00:00 AM 3 3x3 Permit Number 52752 5988634.2057 2106032.7782 37.7621091296561 -122.482468596885 (37.7621091296561, -122.482468596885) 1 8 3 56 35
41171 40117 Permitted Site 7 Prunus spp :: Cherry 68 51 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/2001 12:00:00 AM     Permit Number 41332 6004835.9770779 2101026.68937802 37.7492927732201 -122.42607645855 (37.7492927732201, -122.42607645855) 2 4 5 28862 22
43718 45454 Permitted Site 7 Prunus spp :: Cherry 68 219 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2001 12:00:00 AM     Permit Number 44239 5994709.07342911 2090056.25354598 37.7185930847656 -122.460300500781 (37.7185930847656, -122.460300500781) 9 8 6 28861 24
45518 238533 DPW Maintained 1 Prunus spp :: Cherry 68 2929 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009029.88036 2101415.6654 37.7505969563892 -122.411601283067 (37.7505969563892, -122.411601283067) 2 4 7 28859 19
50445 104765 Undocumented 4 Prunus spp :: Cherry 68 47 VICKSBURG ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004132.1 2102787.4 37.7540874654016 -122.428635972714 (37.7540874654016, -122.428635972714) 2 4 5 28862 22
53658 237949 DPW Maintained 1 Prunus spp :: Cherry 68 3145 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008037.75868 2102668.77987 37.7539820234627 -122.415120820376 (37.7539820234627, -122.415120820376) 2 4 7 28859 19
58423 234923 DPW Maintained 1 Prunus spp :: Cherry 68 24 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009961.80336 2099942.52208 37.7466042605945 -122.40827471332 (37.7466042605945, -122.40827471332) 2 7 7 28859 2
58869 105378 Undocumented 4 Prunus spp :: Cherry 68 298X SAN FERNANDO WAY 2 Sidewalk: Curb side : Cutout Tree Private 2     7 2x2   5991951 2094979 37.7319506911602 -122.470192222389 (37.7319506911602, -122.470192222389) 9 8 4 59 40
64777 234916 DPW Maintained 1 Prunus spp :: Cherry 68 1 Albion St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6005792.88209 2107221.84485 37.766357260514 -122.423207770616 (37.766357260514, -122.423207770616) 8 4 5 28853 19
70091 237950 DPW Maintained 1 Prunus spp :: Cherry 68 3145 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008062.3853 2102670.45818 37.7539880156382 -122.415035774193 (37.7539880156382, -122.415035774193) 2 4 7 28859 19
70311 50019 Permitted Site 7 Prunus spp :: Cherry 68 1363 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46753 6009308.17778689 2101227.80950502 37.7500967527825 -122.410625639874 (37.7500967527825, -122.410625639874) 2 4 7 28859 19
75245 234921 DPW Maintained 1 Prunus spp :: Cherry 68 1062 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006317.5902 2103335.47216 37.7557157877704 -122.421116917936 (37.7557157877704, -122.421116917936) 2 4 5 28859 19
75737 50440 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
79051 237948 DPW Maintained 1 Prunus spp :: Cherry 68 3387 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6007155.62665 2101453.96351 37.7505968017181 -122.418085332981 (37.7505968017181, -122.418085332981) 2 4 7 28859 19
80855 237971 DPW Maintained 1 Prunus spp :: Cherry 68 3178 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008600.41483 2100617.45628 37.7483811527764 -122.413029982045 (37.7483811527764, -122.413029982045) 2 4 7 28859 19
84619 51065 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
85355 58408 Permitted Site 7 Prunus spp :: Cherry 68 755 Buena Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1979 12:00:00 AM 5   Permit Number 17543 5999798.5 2108081.7 37.7683780948237 -122.444002941237 (37.7683780948237, -122.444002941237) 15 5 11 29492 9
85686 17372 Permitted Site 7 Prunus spp :: Cherry 68 1050X Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2012 12:00:00 AM 6 3X3 Permit Number 769300 5999379.15193 2109268.47217 37.7716127406754 -122.445538771694 (37.7716127406754, -122.445538771694) 15 5 11 29492 9
88482 56560 Permitted Site 7 Prunus spp :: Cherry 68 298X SAN FERNANDO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   5992129 2095185 37.7325266047982 -122.469591834842 (37.7325266047982, -122.469591834842) 9 8 4 59 40
89476 49741 Permitted Site 7 Prunus spp :: Cherry 68 646@ 18th Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2003 12:00:00 AM     Permit Number 46540 6010086.91434322 2105281.03537103 37.7612696346383 -122.408218548113 (37.7612696346383, -122.408218548113) 2 4 8 28859 19
91325 84725 Permitted Site 7 Prunus spp :: Cherry 68 20 Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49296 5996092 2115960 37.7897976912986 -122.457393340224 (37.7897976912986, -122.457393340224) 11 6 1 54 31
91846 19030 DPW Maintained 1 Prunus spp :: Cherry 68 3176 SACRAMENTO ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     7 2x2   5999568 2115477 37.7886705381772 -122.44533201 (37.7886705381772, -122.44533201) 13 6 1 29490 27
97628 234922 DPW Maintained 1 Prunus spp :: Cherry 68 818 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010155.119 2104325.0374 37.758648498551 -122.407915239024 (37.758648498551, -122.407915239024) 2 4 7 28859 19
99909 96676 Property Tree 8 Prunus spp :: Cherry 68 1701 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
100372 40636 Permitted Site 7 Prunus spp :: Cherry 68 142 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM     Permit Number 41636 6010372.94752615 2111469.26002805 37.7782770896065 -122.407665612051 (37.7782770896065, -122.407665612051) 14 2 9 28853 34
100657 237946 DPW Maintained 1 Prunus spp :: Cherry 68 923 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008002.82503 2102600.12508 37.7537915497511 -122.415236769973 (37.7537915497511, -122.415236769973) 2 4 7 28859 19
106492 20856 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984852.8466778 2102317.5089788 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334) 1 8 3 56 35
110871 52194 Permitted Site 7 Prunus spp :: Cherry 68 415 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.427511197042 (37.7737647507648, -122.427511197042) 7 9 11 28852 10
112015 120699 DPW Maintained 1 Prunus spp :: Cherry 68 82 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5988985.45615 2114833.30825 37.7862933730561 -122.481898453185 (37.7862933730561, -122.481898453185) 11 6 1 55 33
112884 19029 DPW Maintained 1 Prunus spp :: Cherry 68 3176 SACRAMENTO ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     8 2x2   5999568 2115477 37.7886705381772 -122.44533201 (37.7886705381772, -122.44533201) 13 6 1 29490 27
115596 39201 Permitted Site 7 Prunus spp :: Cherry 68 36 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/1998 12:00:00 AM   3x3 Permit Number 40852 5996541.64157093 2114326.11365116 37.7853372927938 -122.455719478601 (37.7853372927938, -122.455719478601) 11 6 1 54 31
115685 234917 DPW Maintained 1 Prunus spp :: Cherry 68 1341 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011175.62775 2102086.99041 37.7525603976539 -122.404228319896 (37.7525603976539, -122.404228319896) 10 4 8 28859 19
118419 43986 Permitted Site 7 Prunus spp :: Cherry 68 2200 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2000 12:00:00 AM     Permit Number 43550 6005547.87197183 2117529.65351428 37.7946461451301 -122.424788600108 (37.7946461451301, -122.424788600108) 13 9 1 28858 27
121576 142162 DPW Maintained 1 Prunus spp :: Cherry 68 490X Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000657 2110488 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609) 15 5 11 29492 16
121716 51062 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
121838 53181 Permitted Site 7 Prunus spp :: Cherry 68 2784 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2006 12:00:00 AM   3x3 Permit Number 49099 6010077.71172244 2102830.43618978 37.7545403242811 -122.408077545352 (37.7545403242811, -122.408077545352) 2 4 7 28859 19
125827 56999 Permitted Site 7 Prunus spp :: Cherry 68 4206 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 14257 6001838.61131344 2101787.92307498 37.7512130767933 -122.436495868054 (37.7512130767933, -122.436495868054) 2 4 5 28862 22
127650 43350 DPW Maintained 1 Prunus spp :: Cherry 68 651 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2000 12:00:00 AM 8   Permit Number 43102 6007249.15746 2091540.31674 37.7233813767346 -122.417059535679 (37.7233813767346, -122.417059535679) 9 3 7 309 28
128650 179166 DPW Maintained 1 Prunus spp :: Cherry 68 137 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007974.04708 2093261.84981 37.7281490902886 -122.414675489606 (37.7281490902886, -122.414675489606) 9 3 7 309 28
129805 142312 DPW Maintained 1 Prunus spp :: Cherry 68 1691 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5999733.1826 2110513.1611 37.7750505456338 -122.444403629404 (37.7750505456338, -122.444403629404) 15 5 11 29492 16
133197 51064 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
133845 49367 Permitted Site 7 Prunus spp :: Cherry 68 1328@ 4th & 5t Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2005 12:00:00 AM     Permit Number 47977 5994585.78557071 2112147.74022661 37.7792436288989 -122.462328048371 (37.7792436288989, -122.462328048371) 11 6 2 54 11
139351 96677 Permitted Site 7 Prunus spp :: Cherry 68 1701 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767971 5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
139368 50308 Permitted Site 7 Prunus spp :: Cherry 68 701 (REVISED) Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2003 12:00:00 AM     Permit Number 47019 5994734.51143453 2090549.74162157 37.7199495485694 -122.460248307265 (37.7199495485694, -122.460248307265) 9 8 6 28861 24
140897 19022 Permitted Site 7 Prunus spp :: Cherry 68 3170 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372) 13 6 1 29490 27
142169 82056 Permitted Site 7 Prunus spp :: Cherry 68 447 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2011 12:00:00 AM   3x3 Permit Number 767285 5993745.17939928 2090171.13367763 37.7188530246919 -122.463640596127 (37.7188530246919, -122.463640596127) 9 8 6 64 24
145574 19031 Permitted Site 7 Prunus spp :: Cherry 68 3190 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 2X2   5999568.09479 2115476.97835 37.7886704841429 -122.445331680485 (37.7886704841429, -122.445331680485) 13 6 1 29490 27

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