trees

Custom SQL query returning 61 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
50 264964 6 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
1248 260958 6 59 3790 California St 2 Sidewalk: Property side : Cutout Tree 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
1408 260469 6 185 1 Masonic Ave 4 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
1427 260648 6 155 3891 Sacramento St 6 Sidewalk: Property side : Yard Tree 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
3184 260470 6 185 1 Masonic Ave 5 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
3188 260646 6 36 3905 Sacramento St 2 Sidewalk: Property side : Cutout Tree 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
3724 260475 6 88 520 Laurel St 3 Side Yard : Cutout Tree 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
4071 260649 6 155 3891 Sacramento St 7 Sidewalk: Property side : Yard Tree 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
5115 260959 6 16 400 Cherry St 11 Sidewalk: Property side : Yard Tree 2       Width 9ft   5996243 2114742 37.7864620624436 -122.456782770891 (37.7864620624436, -122.456782770891) 11 6 1 54 31
6867 260482 6 7 3333 California St 4 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
6928 260474 6 88 520 Laurel St 2 Side Yard : Cutout Tree 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
7030 260467 6 36 1 Masonic Ave 2 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
10213 260647 6 36 3905 Sacramento St 3 Sidewalk: Property side : Cutout Tree 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
10395 260478 6 41 3333 California St 8 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11407 260477 6 41 3333 California St 7 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11487 260838 6 53 399 Laurel St 1 Side Yard : Cutout Tree 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
11600 260651 6 11 3751 Sacramento St 2 Front Yard : Cutout Tree 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
12431 262225 6 337 2450 Golden Gate Ave 1 Sidewalk: Property side : Yard Tree 2       Width 7ft   5997659.54255 2111324.05825 37.7771585265736 -122.451635273045 (37.7771585265736, -122.451635273045) 15 6 2 54 16
12511 260840 6 53 399 Laurel St 3 Side Yard : Cutout Tree 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
12545 260484 6 7 3333 California St 6 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
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
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
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
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
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
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
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
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
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
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
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
44979 39247 6 189 3524 Jackson St 1 Front Yard : Cutout Tree 2   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
47695 104013 6 107 3978 Sacramento St 1 Front Yard : Yard Tree 2   07/24/2013 12:00:00 AM     Permit Number 770312 5995753.1 2114886.6 37.7868309532778 -122.458488162336 (37.7868309532778, -122.458488162336) 11 6 1 54 31
48200 108097 6 17 3370 Washington St 2 Front Yard : Cutout Tree 2           5998663.3699 2115944.31994 37.789901994506 -122.448495552231 (37.789901994506, -122.448495552231) 13 6 1 54 31
58472 104728 6 17 3212 Jackson St 1 Front Yard : Cutout Tree 2   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492) 13 6 1 54 31
61403 111037 6 224 3991-3997 Washington St 2 Front Yard : Yard Tree 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
78031 91107 6 17 2650 Turk Blvd 2 Front Yard : Yard Tree 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
94461 98038 6 17 147 Lake St 1 Front Yard : Yard Tree 2   12/09/2011 12:00:00 AM     Permit Number 768423 5994977.2 2114852.5 37.7866927029397 -122.461170103848 (37.7866927029397, -122.461170103848) 11 6 1 54 11
95953 95234 6 17 7 Almaden Ct   Front Yard : Yard Tree 2   01/25/2011 12:00:00 AM     Permit Number 767129 5995849 2112535 37.7803795989447 -122.457986127959 (37.7803795989447, -122.457986127959) 11 6 2 54 16
104764 115564 6 84 3524 Jackson St 2 Front Yard : Cutout Tree 2       5x10   5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
122238 254735 6 89 363 14th Ave 1 Sidewalk: Property side : Cutout Tree 2         Permit Number 781538 5991507 2112990 37.781378479082 -122.473040175374 (37.781378479082, -122.473040175374) 11 6 2 54 26
146644 105349 6 17 151X Spruce St 1 Front Yard : Yard Tree 2   01/16/2014 12:00:00 AM     Permit Number 771071 5997060.93638 2115845.70083 37.7895394616557 -122.45403267224 (37.7895394616557, -122.45403267224) 11 6 1 54 31
147948 111036 6 224 3991-3997 Washington St 1 Front Yard : Yard Tree 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
153312 91106 6 17 2650 Turk Blvd 1 Front Yard : Yard Tree 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
156782 12711 6 17 1449 Lake St 3 Front Yard : Cutout Tree 1   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046) 11 6 2 54 26
163821 87242 6 15 4131 Geary Blvd 1 Sidewalk: Property side : Yard Tree 2         Permit Number 50271 5994116.9 2112250.5 37.7794987690846 -122.46395756624 (37.7794987690846, -122.46395756624) 11 6 2 54 11
55810 116521 6 36 70 BEAUMONT AVE 1 Sidewalk: Property side : Yard Tree 2     10 3x3   5996728 2112568 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336) 11 6 2 54 16
87883 120156 6 53 758 10th Ave 1 Sidewalk: Curb side : Cutout Landscaping 2     10     5992930 2110298 37.7740692588728 -122.467921468059 (37.7740692588728, -122.467921468059) 11 6 2 54 11
137332 112057 6 37 762 FUNSTON AVE 2 Sidewalk: Curb side : Cutout Tree 2 FUF   12     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
90493 108096 6 339 3370 Washington St 1 Front Yard : Cutout Tree 2     17   Permit Number 773610 5998674.83986 2115933.37372 37.7898725948813 -122.448455078738 (37.7898725948813, -122.448455078738) 13 6 1 54 31
144517 112363 6 233 540 10th Ave 3 Front Yard : Yard Tree 2     24 6x6   5992860.82014 2111778.58973 37.778130563709 -122.468268503132 (37.778130563709, -122.468268503132) 11 6 2 54 11
26906 110476 6 14 3700 Washington St 1 Back Yard : Yard Tree 2   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 5997015.1 2115715 37.7891779638687 -122.454181816252 (37.7891779638687, -122.454181816252) 11 6 1 54 31
49235 110583 6 160 46 COOK ST 5 Sidewalk: Curb side : Cutout Tree 2     36     5997534 2113434 37.782944683725 -122.452221842699 (37.782944683725, -122.452221842699) 15 6 1 54 31
117508 121242 6 15 701 16th Ave 1 Back Yard : Cutout Tree 2     36     5990933 2110561 37.7746758635803 -122.474848566269 (37.7746758635803, -122.474848566269) 11 6 2 54 26
153240 107142 6 168 2694 MCALLISTER ST 2 Front Yard : Yard Tree 2     48     5996297.4 2110789.6 37.7756129427938 -122.45630867289 (37.7756129427938, -122.45630867289) 11 6 2 54 16
61291 113491 6 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
179316 112056 6 37 762 FUNSTON AVE 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
127638 98241 6 27 3760 Washington St 1 Front Yard : Yard Tree 2   01/10/2012 12:00:00 AM 9   Permit Number 768462 5996814.46778 2115674.04938 37.7890540175629 -122.45487301497 (37.7890540175629, -122.45487301497) 11 6 1 54 31