trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
14497 251425 6 170 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree 2           5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
14597 106873 6 36 38 08th St 4 Front Yard : Cutout Tree 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
14733 255398 6 172 637 MASONIC AVE 3 Sidewalk: Property side : Cutout Tree 2       Width 0ft   5999139.3301 2110590.1819 37.7752281241925 -122.446463429304 (37.7752281241925, -122.446463429304) 15 5 11 29492 16
14736 92056 6 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree 2   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
14780 262330 6 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
14819 259822 6 27 850x Bryant St 16 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14822 96765 6 7 184 Edgewood Ave 1 Front Yard : Yard Tree 2   07/12/2011 12:00:00 AM     Permit Number 767998 5996632 2105999 37.7624783944866 -122.454805014883 (37.7624783944866, -122.454805014883) 15 5 11 29492 12
14823 260479 6 7 3333 California St 1 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
14900 260476 6 88 520 Laurel St 4 Side Yard : Cutout Tree 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
14911 264785 6 15 1738 14th Ave 1 Sidewalk: Curb side : Cutout Tree 2       10x10   5991929 2103547 37.7554749546691 -122.470892190435 (37.7554749546691, -122.470892190435) 1 8 4 56 12
14961 259823 6 27 850x Bryant St 17 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
15016 261205 6 36 2301 Leavenworth St 2 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
15055 259264 6 41 3580X 19th Ave 2 Sidewalk: Property side : Yard Tree 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
15065 261762 6 85 2943 Harrison St 1 Front Yard : Yard Tree 2       Width 3ft   6009034.67775 2101326.83516 37.7503533174728 -122.411578417814 (37.7503533174728, -122.411578417814) 2 4 7 28859 19
15093 119607 6 15 299x Avalon Ave 3 Front Yard : Yard Tree 2                              
15148 260466 6 36 1 Masonic Ave 1 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
15160 260680 6 17 1450x Laguna St 1 Sidewalk: Property side : Cutout Tree 2       3x3   6004617 2113883 37.7845807327875 -122.42774958855 (37.7845807327875, -122.42774958855) 13 9 11 28858 41
15224 264691 6 46 1560 Plymouth Ave 1 Front Yard : Yard Tree 2       10x10   5995798 2094356 37.730461740667 -122.45684736471 (37.730461740667, -122.45684736471) 9 7 4 28861 40
15254 260460 6 70 1798X Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree 2       5x10   5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
15289 119601 6 185 4357x Mission St 3 Front Yard : Yard Tree 2         Permit Number 774415                    
15393 260480 6 7 3333 California St 2 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
15591 262378 6 289 2172 Green St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002662 2118213 37.796359019498 -122.434822974351 (37.796359019498, -122.434822974351) 13 9 1 57 17
15657 259657 6 17 132 Sagamore St 1 Front Yard : Yard Tree 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
15671 104278 6 105 2 Allston Way 1 Back Yard : Yard Tree 2           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974) 1 8 4 59 40
15795 251263 6 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
15911 105081 6 45 344 Fulton St 1 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
15941 85313 6 53 610 Brannan St 1 unknown : Cutout Tree 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
15969 261831 6 124 1507 Cole St 1 Front Yard : Cutout Tree 2       3x3   5998279 2105297 37.7606452154312 -122.449058098094 (37.7606452154312, -122.449058098094) 15 5 11 29492 12
15980 262426 6 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
16010 260965 6 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
16021 260481 6 7 3333 California St 3 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
16043 260472 6 185 1 Masonic Ave 7 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16142 94943 6 364 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
16147 260471 6 16 1 Masonic Ave 6 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16256 260911 6 40 2035 15th Ave 1 Front Yard : Yard Tree 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
16260 260650 6 11 3751 Sacramento St 1 Front Yard : Cutout Tree 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
16292 262198 6 118 801 Sanchez St 2 Back Yard : Yard Tree 2       3x3   6003778 2103544 37.7561448640021 -122.429914501498 (37.7561448640021, -122.429914501498) 2 4 5 28862 22
16309 259807 6 27 850x Bryant St 1 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16372 96327 6 64 296 Randall St 1 Sidewalk: Property side : Yard Tree 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
16429 262110 6 87 25 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002200 2092574 37.7259343081174 -122.434587389509 (37.7259343081174, -122.434587389509) 9 7 6 28861 25
16536 259816 6 27 850x Bryant St 10 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16652 258405 6 62 15 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree 2       6x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
16717 262293 6 31 2418 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002408 2117119 37.7933407549318 -122.435623560602 (37.7933407549318, -122.435623560602) 13 9 1 29490 27
16781 260951 6 15 190 Jackson St 1 Sidewalk: Curb side : Yard Tree 2       3x3   6013038 2118237 37.7970085486816 -122.398921272101 (37.7970085486816, -122.398921272101) 3 1 10 28860 6
17108 105086 6 45 344 Fulton St 6 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17188 260389 6 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
17242 253971 6 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
17264 260645 6 127 3905 Sacramento St 1 Sidewalk: Property side : Cutout Tree 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
17333 259266 6 15 3580X 19th Ave 4 Sidewalk: Property side : Yard Tree 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
17369 260483 6 7 3333 California St 5 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
17429 103965 6 17 141 Marview Way 1 Front Yard : Yard Tree 2   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
17502 260902 6 184 1901 Geary Blvd 1 Sidewalk: Property side : Cutout Tree 1       Width 0ft   6002672 2113572 37.7836165897996 -122.434456380093 (37.7836165897996, -122.434456380093) 13 9 11 29490 41
17557 261982 6 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
17604 261710 6 93 3555 16th St 1 Front Yard : Yard Tree 12       8x8   6003221.95473 2106496.25325 37.7642195378276 -122.432048304209 (37.7642195378276, -122.432048304209) 15 4 5 28862 3
17656 261984 6 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 10 3 8 58 1
17671 260957 6 59 3790 California St 1 Sidewalk: Property side : Cutout Tree 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
17902 113640 6 175 545X Minna St 1 Sidewalk: Property side : Cutout Tree 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
17941 258800 6 113 566 29th Ave 2 Front Yard : Cutout Tree 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
17949 100194 6 163 361 Dellbrook Ave 2 Front Yard : Yard Tree 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
18002 261423 6 27 2400x 23rd St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6011254 2102764 37.7544236960072 -122.404004933004 (37.7544236960072, -122.404004933004) 10 4 8 28859 19
18011 262289 6 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
18171 260058 6 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
18276 119614 6 129 2X Sutter St 2 Sidewalk: Property side : Cutout Tree 2       3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
18320 261763 6 15 315 Montcalm St 1 Front Yard : Yard Tree 2       3x3   6009577 2099558 37.7455268923792 -122.409578193595 (37.7455268923792, -122.409578193595) 2 7 7 28859 2
18482 260468 6 185 1 Masonic Ave 3 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
18519 260473 6 172 520 Laurel St 1 Side Yard : Cutout Tree 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
18601 262329 6 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
18661 259820 6 27 850x Bryant St 14 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18680 262301 6 97 2117 Broderick St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000330 2116040 37.7902598573453 -122.44273605224 (37.7902598573453, -122.44273605224) 13 6 1 29490 27
18707 259811 6 27 850x Bryant St 5 Sidewalk: Property side : Yard Tree 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18711 262449 6 41 155 Baker St 1 Side Yard : Yard Tree 2       10x10   6000750.251 2109577.8851 37.7725404908768 -122.440818271359 (37.7725404908768, -122.440818271359) 15 5 11 29492 9
18868 260249 6 260 10 Crestline Dr 1 Median : Yard Tree 2       3x3   5999247 2101231 37.7495362941779 -122.445417868856 (37.7495362941779, -122.445417868856) 2 5 5 63 38
18899 261161 6 172 2452 Green St 1 Front Yard : Cutout Tree 2       3x3   6001304 2118013 37.7957326780501 -122.439507585878 (37.7957326780501, -122.439507585878) 13 9 1 57 17
18957 259263 6 15 3580X 19th Ave 1 Sidewalk: Property side : Yard Tree 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
18983 262256 6 16 4210 Ocean Ave 9 Sidewalk: Property side : Yard Tree 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
18988 103657 6 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
19027 260904 6 16 4228 Geary Blvd 1 Sidewalk: Property side : Cutout Tree 2       Width 4ft   5993841 2112866 37.7811728620679 -122.464956727678 (37.7811728620679, -122.464956727678) 11 6 2 54 11
19052 260948 6 15 370 Drumm St 1 Side Yard : Yard Tree 2           6013616 2118213 37.7969748404412 -122.396919555024 (37.7969748404412, -122.396919555024) 3 1 10 28860 6
19246 253252 6 15 99X Lopez Ave 3 Front Yard : Yard Tree 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
19453 261628 6 11 3930 21st St 1 Front Yard : Cutout Tree 2       3x3   6002255 2103579 37.7561545985327 -122.435184046951 (37.7561545985327, -122.435184046951) 2 4 5 28862 3
19573 254456 6 113 1055X Duncan St 1 Side Yard : Yard Tree 2                              
19616 262407 6 15 300 Font Blvd 1 Sidewalk: Property side : Yard Tree 2       6x5   5990018 2089729 37.7174235665943 -122.476491559856 (37.7174235665943, -122.476491559856) 1 8 4 64 14
19844 254259 6 15 45X Everglade Dr 6 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
19958 104685 6 36 33 08th St 7 Front Yard : Yard Tree 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
20021 88145 6 17 1475 Fillmore St 2 Sidewalk: Curb side : Cutout Tree 2   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975 (37.7830370509294, -122.43279450975) 15 9 11 29490 41
20037 100423 6 47 155 Winston Dr 1 Front Yard : Yard Tree 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
20150 256573 6 172 145 Castenada Ave 1 Front Yard : Cutout Tree 2       3x3   5994569 2100949 37.74849383418 -122.461573977381 (37.74849383418, -122.461573977381) 1 8 4 29491 40
20207 105239 6 17 20X Cleary Ct 6 Front Yard : Yard Tree 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
20228 251632 6 41 14R Amethyst Way 1 Back Yard : Yard Tree 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
20298 113730 6 36 1580 Valencia St 7 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
20385 251602 6 95 44R Amber Dr 1 Back Yard : Yard Tree 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
20461 104283 6 17 150X Middle Point Rd 5 Front Yard : Yard Tree 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
20972 254094 6 15 320 Magellan Ave 1 Front Yard : Yard Tree 2       10x10 Permit Number 781012 5994209 2099943 37.7457108840866 -122.462745872627 (37.7457108840866, -122.462745872627) 1 8 4 29491 40
21096 253953 6 41 11X Ravenwood Dr 2 Sidewalk: Curb side : Yard Tree 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
21449 255662 6 230 1626 Shrader St 1 Sidewalk: Property side : Yard Tree 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
21762 100124 6 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
22296 113639 6 175 1X Russ St 3 Sidewalk: Property side : Cutout Tree 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
22312 116999 6 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
22628 101981 6 93 25X Tiffany Ave 4 Front Yard : Yard Tree 2           6006415.7 2099833.4 37.7461054290546 -122.420529042399 (37.7461054290546, -122.420529042399) 2 7 7 28859 2
22679 108026 6 155 862 Kansas St   Front Yard : Yard Tree 2         Permit Number 774734 6011570 2104296 37.7586478799274 -122.403019866682 (37.7586478799274, -122.403019866682) 10 3 8 28856 29
22688 120924 6 63 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24