155 rows where qSpecies_id = 68 sorted by qAddress

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)
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                    
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
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
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
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
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
151000 51061 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 8 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
172948 51060 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 2 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
173341 51063 Permitted Site 7 Prunus spp :: Cherry 68 10 South Van Ness Ave 6 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
6955 19957 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY40 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
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                      
3996 19960 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY41 18 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
2397 19696 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 -3 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
14491 19697 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
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
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
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
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
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
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
151735 102286 Undocumented 4 Prunus spp :: Cherry 68 122 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2014 12:00:00 AM 26 4x4 Permit Number 772865 6000574.8 2102350.7 37.7526864299915 -122.440906621345 (37.7526864299915, -122.440906621345) 2 4 5 28862 22
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
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
189473 121317 DPW Maintained 1 Prunus spp :: Cherry 68 1270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6007670 2102262 37.7528444245459 -122.416363810551 (37.7528444245459, -122.416363810551) 2 4 7 28859 19
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
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
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
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
186812 234918 DPW Maintained 1 Prunus spp :: Cherry 68 1319 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011166.83162 2102201.8831 37.7528753762183 -122.404266824377 (37.7528753762183, -122.404266824377) 10 4 8 28859 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
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
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
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
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
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
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
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
174316 50441 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 5 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
174947 50443 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 2 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
193278 50442 Permitted Site 7 Prunus spp :: Cherry 68 1539 Funston Ave 3 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
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
174186 105781 DPW Maintained 1 Prunus spp :: Cherry 68 1631 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2014 12:00:00 AM     Permit Number 772613 6001347.6 2111440.1 37.7776876665107 -122.43888545994 (37.7776876665107, -122.43888545994) 15 5 11 29492 41
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
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
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
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
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
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
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
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
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
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
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
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
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
153560 20857 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 7 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
191467 20855 DPW Maintained 1 Prunus spp :: Cherry 68 1892X Sunset Blvd 5 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
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
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
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
188790 93987 Permitted Site 7 Prunus spp :: Cherry 68 200 Belgrave Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 53411 5997460.5 2104904 37.759519290122 -122.451860552802 (37.759519290122, -122.451860552802) 15 5 11 29492 12
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
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
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
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
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
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
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
193280 196534 DPW Maintained 1 Prunus spp :: Cherry 68 2221 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011830.1521 2101342.38489 37.7505524246675 -122.401912510764 (37.7505524246675, -122.401912510764) 10 3 8 28856 1
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
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
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
163327 181930 DPW Maintained 1 Prunus spp :: Cherry 68 2431 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5986090.3717 2098682.4704 37.7417788753673 -122.49072577603 (37.7417788753673, -122.49072577603) 1 8 3 29491 35
173631 96998 Significant Tree 6 Prunus spp :: Cherry 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
159933 183196 Undocumented 4 Prunus spp :: Cherry 68 2479 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983931.1246 2098292.1691 37.740580843976 -122.498162805629 (37.740580843976, -122.498162805629) 1 8 3 29491 35
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
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
190581 234912 DPW Maintained 1 Prunus spp :: Cherry 68 266 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006193.38743 2096072.09961 37.7357652112859 -122.421030756557 (37.7357652112859, -122.421030756557) 2 7 7 28859 2
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
178755 141006 DPW Maintained 1 Prunus spp :: Cherry 68 269 COLLINS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998171.184 2112777.5693 37.7811787774786 -122.449970134459 (37.7811787774786, -122.449970134459) 15 6 2 54 16
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
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
185049 185048 DPW Maintained 1 Prunus spp :: Cherry 68 2767 34th Ave 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985831.6836 2096605.638 37.7360613326903 -122.491467390698 (37.7360613326903, -122.491467390698) 1 8 3 29491 35
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
191512 40428 Permitted Site 7 Prunus spp :: Cherry 68 29 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1999 12:00:00 AM     Permit Number 41523 6007969.10251409 2094049.49213596 37.7303115087504 -122.414748301777 (37.7303115087504, -122.414748301777) 9 3 7 309 28
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
175309 88559 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
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
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
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
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
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
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
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
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
189823 19024 DPW Maintained 1 Prunus spp :: Cherry 68 3170 Sacramento St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372) 13 6 1 29490 27
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
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
189054 19028 DPW Maintained 1 Prunus spp :: Cherry 68 3176 SACRAMENTO ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     7 2x2   5999568 2115477 37.7886705381772 -122.44533201 (37.7886705381772, -122.44533201) 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)
);