155 rows where qSpecies_id = 68

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)
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
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
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
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
2397 19696 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 -3 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
3409 234920 DPW Maintained 1 Prunus spp :: Cherry 68 501 York St 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6009827.75137 2105874.2614 37.7628839834388 -122.409156748587 (37.7628839834388, -122.409156748587) 8 4 8 28859 19
3996 19960 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY41 18 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
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
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                    
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
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                      
18058 136026 DPW Maintained 1 Prunus spp :: Cherry 68 957 Sacramento St 1 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6010195.26054 2116841.12509 37.7930170033817 -122.408659357866 (37.7930170033817, -122.408659357866) 3 1 10 28857 4
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
20109 136027 DPW Maintained 1 Prunus spp :: Cherry 68 957 Sacramento St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6010215.88282 2116843.14587 37.7930237069305 -122.408588145932 (37.7930237069305, -122.408588145932) 3 1 10 28857 4
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
23889 212859 DPW Maintained 1 Prunus spp :: Cherry 68 1850 17th Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5990965.56748 2102825.03354 37.7534368589362 -122.474171325764 (37.7534368589362, -122.474171325764) 1 8 4 56 12
24447 136025 DPW Maintained 1 Prunus spp :: Cherry 68 80 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     11     6008316.37067 2119137.06676 37.7992156804143 -122.415323048225 (37.7992156804143, -122.415323048225) 5 1 10 308 32
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
25405 185047 DPW Maintained 1 Prunus spp :: Cherry 68 2767 34th Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985832.2143 2096586.5348 37.7360089113847 -122.491464150215 (37.7360089113847, -122.491464150215) 1 8 3 29491 35
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
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
38671 234924 DPW Maintained 1 Prunus spp :: Cherry 68 323 Mullen Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6010626.29866 2099830.99271 37.7463352122137 -122.4059690917 (37.7463352122137, -122.4059690917) 2 7 7 28859 2
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
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
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
41546 213705 DPW Maintained 1 Prunus spp :: Cherry 68 175 Staples Ave 2 Sidewalk: Property side : Yard Tree Private 2     2     5998918.04752 2093764.63915 37.7290166671659 -122.4460184358 (37.7290166671659, -122.4460184358) 9 7 4 28861 40
42662 213703 DPW Maintained 1 Prunus spp :: Cherry 68 27 Melrose Ave 2 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   5999907.55727 2095471.26814 37.7337591277724 -122.442720129024 (37.7337591277724, -122.442720129024) 9 7 4 63 40
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
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
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
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
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
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
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
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
59358 103517 Permitted Site 7 Prunus spp :: Cherry 68 55X MacOndray Ln 1 Unaccepted Street : Yard Tree Private 2         Permit Number 770452 6008432 2119159 37.7992824016355 -122.414924482909 (37.7992824016355, -122.414924482909) 5 1 10 308 32
62171 238535 DPW Maintained 1 Prunus spp :: Cherry 68 118 Saint Marys Ave 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6003941.15849 2095961.17353 37.7353334161892 -122.428809685439 (37.7353334161892, -122.428809685439) 2 7 5 63 7
62546 19034 Permitted Site 7 Prunus spp :: Cherry 68 3192 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2     12 2X2   5999529.89099 2115397.322 37.7884495878023 -122.445458129536 (37.7884495878023, -122.445458129536) 13 6 1 29490 27
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
65616 86757 Permitted Site 7 Prunus spp :: Cherry 68 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
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
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
73071 196064 DPW Maintained 1 Prunus spp :: Cherry 68 1800 Illinois St 10 Sidewalk: Curb side : Yard Tree Private 2     2 Width 5ft   6016257.27394 2100629.71457 37.7488416623195 -122.386553348372 (37.7488416623195, -122.386553348372) 10 3 8 58 1
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
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
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
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
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
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
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
88402 96987 Permitted Site 7 Prunus spp :: Cherry 68 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
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
92263 196371 DPW Maintained 1 Prunus spp :: Cherry 68 1797 Bancroft Ave 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 1ft   6013429.50102 2092789.94242 37.7271583305791 -122.395782600389 (37.7271583305791, -122.395782600389) 10 3 8 58 1
93588 136021 DPW Maintained 1 Prunus spp :: Cherry 68 1010 Lombard St 1 Sidewalk: Curb side : Yard Tree Private 2     12     6007482.49892 2120248.47345 37.8022204224067 -122.418287380977 (37.8022204224067, -122.418287380977) 5 1 1 28858 32
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
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
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
117684 117739 DPW Maintained 1 Prunus spp :: Cherry 68 475 39th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5983746.16527 2112679.78018 37.7800743257794 -122.49986552243 (37.7800743257794, -122.49986552243) 11 6 2 55 26
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
122322 136024 DPW Maintained 1 Prunus spp :: Cherry 68 66 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     9     6008379.74874 2119143.46885 37.7992368207748 -122.415104191024 (37.7992368207748, -122.415104191024) 5 1 10 308 32
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

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