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)
875 19954 1 150 100 STAIRWAY39 11 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
1404 19975 1 150 100 STAIRWAY45 2 Sidewalk: Curb side : Cutout Tree 1     3 30ST                      
1595 19920 1 150 100 STAIRWAY36 -2 Sidewalk: Curb side : Cutout Tree 1     6 3X3                      
1837 19878 1 150 100 STAIRWAY33 10 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
2169 19944 1 150 100 STAIRWAY39 1 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
6286 19771 1 150 100 STAIRWAY17 1 Sidewalk: Curb side : Cutout Tree 1     12 50ST                      
7321 20302 1 150 50X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     12 60                      
9985 19773 1 150 100 STAIRWAY17 3 Sidewalk: Curb side : Cutout Tree 1     12 20ST                      
11575 19874 1 150 100 STAIRWAY33 6 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
12424 19961 1 150 100 STAIRWAY41 19 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
14073 19821 1 150 100 STAIRWAY25 5 Sidewalk: Curb side : Cutout Tree 1     24 10ST                      
17397 19895 1 150 100 STAIRWAY33 27 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
17450 19946 1 150 100 STAIRWAY39 3 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
17793 19777 1 150 100 STAIRWAY18 3 Sidewalk: Curb side : Cutout Tree 1     6 50ST                      
1491 181698 1 150 1801 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5990006.9617 2107176.8497 37.7653302032624 -122.477804448514 (37.7653302032624, -122.477804448514) 1 8 3 56 35
7165 181321 1 150 1801 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   5990078.1902 2107177.6156 37.7653364397928 -122.477558144457 (37.7653364397928, -122.477558144457) 1 8 3 56 35
9811 181699 1 150 1801 Lincoln Way 4 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   5990039.1294 2107177.6156 37.7653341730561 -122.477693245166 (37.7653341730561, -122.477693245166) 1 8 3 56 35
16086 181700 1 150 1801 Lincoln Way 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5990060.5745 2107178.3815 37.7653375205099 -122.477619128372 (37.7653375205099, -122.477619128372) 1 8 3 56 35
19388 114226 6 150 99x FONT BLVD 2 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
21577 114229 6 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
22410 182140 1 150 1414 24th Ave 1 Sidewalk: Curb side : Cutout Tree 2     24 Width 0ft   5988688.758 2105677.7715 37.7611375509737 -122.482253913011 (37.7611375509737, -122.482253913011) 1 8 3 56 35
26055 21441 1 150 2692X Sunset Blvd 36 Sidewalk: Curb side : Cutout Tree 1     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
27121 114234 6 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30455 114232 6 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
38129 114239 6 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
44804 114228 6 150 99x FONT BLVD 4 Sidewalk: Curb side : Yard Tree 2     7     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
62078 114235 6 150 99x FONT BLVD 11 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
64792 114144 6 150 1200x JUNIPERO SERRA BLVD 1 Front Yard : Yard Tree 2     10     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
109646 114230 6 150 99x FONT BLVD 6 Sidewalk: Curb side : Yard Tree 2     30     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
119903 30340 7 150 175 Granville Way 1 Sidewalk: Curb side : Cutout Tree 2   02/15/1956 12:00:00 AM     Permit Number 26 5994414.04695782 2098601.44324242 37.7420391129783 -122.461939590962 (37.7420391129783, -122.461939590962) 1 8 4 59 40
128045 114227 6 150 99x FONT BLVD 3 Sidewalk: Curb side : Yard Tree 2     16     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
136142 185643 1 150 2100 Sunset Blvd 23 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5985040.1399 2100443.7841 37.7465535598153 -122.494486886414 (37.7465535598153, -122.494486886414) 1 8 3 29491 35
138971 21436 1 150 2692X Sunset Blvd 33 Sidewalk: Curb side : Cutout Tree 1     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
139515 21403 1 150 2692X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
141272 114231 6 150 99x FONT BLVD 7 Sidewalk: Curb side : Yard Tree 2     10     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
149260 185019 1 150 2701 Sunset Blvd 45 Sidewalk: Property side : Yard Tree 2     7 Width 0ft   5985029.339 2096373.556 37.7353771778975 -122.494224278603 (37.7353771778975, -122.494224278603) 1 8 3 29491 35
154745 114237 6 150 99x FONT BLVD 13 Sidewalk: Curb side : Yard Tree 2     14     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
157275 173625 1 150 1200X Junipero Serra Blvd 47 Sidewalk: Property side : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
165218 114145 6 150 1200x JUNIPERO SERRA BLVD 2 Front Yard : Yard Tree 2     6     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
170130 186367 1 150 1801 Sunset Blvd 34 Sidewalk: Property side : Yard Tree 2     5 Width 0ft   5984825.2316 2102541.2113 37.7522999403759 -122.495384664955 (37.7522999403759, -122.495384664955) 1 8 3 56 35
173199 186270 1 150 1800 Sunset Blvd 8 Sidewalk: Property side : Yard Tree 2     10 Width 0ft   5984992.9477 2102426.3669 37.7519944279313 -122.49479621795 (37.7519944279313, -122.49479621795) 1 8 3 56 35
173544 114236 6 150 99x FONT BLVD 12 Sidewalk: Curb side : Yard Tree 2     22     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
175670 21440 1 150 2692X Sunset Blvd 35 Sidewalk: Curb side : Cutout Tree 1     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
179418 114233 6 150 99x FONT BLVD 9 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
180735 114146 6 150 1200x JUNIPERO SERRA BLVD 3 Front Yard : Yard Tree 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
184558 186118 1 150 1700 Sunset Blvd 3 Sidewalk: Property side : Yard Tree 2     5 Width 0ft   5984966.576 2103035.9667 37.7536666774921 -122.49493235749 (37.7536666774921, -122.49493235749) 1 8 3 56 35
185977 114238 6 150 99x FONT BLVD 14 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
189813 185642 1 150 2100 Sunset Blvd 22 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5985069.1522 2100447.6812 37.7465659581193 -122.494386853704 (37.7465659581193, -122.494386853704) 1 8 3 29491 35
7936 188547 1 150 1790 23rd St 2 Sidewalk: Property side : Yard Tree 2     15     6013501.25195 2102912.88665 37.754957806785 -122.396243734071 (37.754957806785, -122.396243734071) 10 3 8 28856 29
14871 188551 1 150 1790 23rd St 6 Sidewalk: Property side : Yard Tree 2     15     6013445.60553 2102908.48406 37.7549426217134 -122.396435867938 (37.7549426217134, -122.396435867938) 10 3 8 28856 29
22213 188548 1 150 1790 23rd St 3 Sidewalk: Property side : Yard Tree 2     16     6013494.18064 2102912.22652 37.7549556007366 -122.396268142573 (37.7549556007366, -122.396268142573) 10 3 8 28856 29
24584 188556 1 150 1790 23rd St 11 Sidewalk: Curb side : Yard Tree 2     20     6013320.20258 2102893.09045 37.7548933748448 -122.396868470618 (37.7548933748448, -122.396868470618) 10 3 8 28856 29
27746 54159 1 150 262 Bridgeview Dr 1 Sidewalk: Curb side : Cutout Tree 2   06/20/1972 12:00:00 AM 13   Permit Number 9894 6012942.04708 2095291.83842 37.7340008934128 -122.397643138528 (37.7340008934128, -122.397643138528) 10 3 8 58 1
43781 188558 1 150 1790 23rd St 13 Sidewalk: Curb side : Yard Tree 2     12     6013273.06711 2102892.5718 37.7548893269913 -122.397031443052 (37.7548893269913, -122.397031443052) 10 3 8 28856 29
47455 188552 1 150 1790 23rd St 7 Sidewalk: Property side : Yard Tree 2     15     6013433.23441 2102906.76929 37.7549372248775 -122.396478530878 (37.7549372248775, -122.396478530878) 10 3 8 28856 29
49488 188559 1 150 1790 23rd St 15 Sidewalk: Curb side : Yard Tree 2     20     6013256.52558 2102904.20918 37.7549203598944 -122.397089464634 (37.7549203598944, -122.397089464634) 10 3 8 28856 29
51132 85506 7 150 1 Nebraska St 7 Sidewalk: Property side : Yard Tree 2         Permit Number 49678 6009335 2098038 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317) 10 7 7 28859 2
60011 85505 7 150 1 Nebraska St 6 Sidewalk: Property side : Yard Tree 2           6009335 2098038 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317) 10 7 7 28859 2
61467 188560 1 150 1790 23rd St 16 Sidewalk: Curb side : Yard Tree 2     4     6013253.43645 2102897.8837 37.7549028195293 -122.397099704282 (37.7549028195293, -122.397099704282) 10 3 8 28856 29
63539 188544 1 150 1501 22nd St 15 Front Yard : Yard Tree 2     12     6013369.71631 2103799.38115 37.757384608426 -122.396760769601 (37.757384608426, -122.396760769601) 10 3 8 28856 29
63575 44253 7 150 1375 Evans Ave 2 Sidewalk: Curb side : Cutout Tree 2   02/08/2001 12:00:00 AM     Permit Number 43687 6016852.68384064 2097573.05225711 37.7404816352752 -122.384281551427 (37.7404816352752, -122.384281551427) 10 3 8 58 1
64708 188554 1 150 1790 23rd St 9 Sidewalk: Property side : Yard Tree 2     15     6013414.60293 2102900.51315 37.7549190100055 -122.396542525734 (37.7549190100055, -122.396542525734) 10 3 8 28856 29
74203 1916 1 150 11 Bell Ct 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6016651.8152009 2095266.4928857 37.734137178639 -122.384815438972 (37.734137178639, -122.384815438972) 10 3 8 58 1
88192 1711 1 150 5 Bass Ct 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6016572.54474 2095129.81679 37.7337575087508 -122.385079984921 (37.7337575087508, -122.385079984921) 10 3 8 58 1
88490 188557 1 150 1790 23rd St 12 Sidewalk: Curb side : Yard Tree 2     13     6013310.23031 2102900.17201 37.7549122641975 -122.39690345423 (37.7549122641975, -122.39690345423) 10 3 8 28856 29
94332 29878 1 150 1500X La Salle Ave 12 Median : Cutout Tree 1     14 12x31   6015992.6911276 2095862.2429535 37.735736511316 -122.38713579848 (37.735736511316, -122.38713579848) 10 3 8 58 1
101683 44252 7 150 1375 Evans Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/08/2001 12:00:00 AM     Permit Number 43687 6016852.68384064 2097573.05225711 37.7404816352752 -122.384281551427 (37.7404816352752, -122.384281551427) 10 3 8 58 1
115625 188542 1 150 900x Carolina St 54 Median : Yard Tree 1     16     6012509.86374 2102962.70315 37.75503937799 -122.399675754754 (37.75503937799, -122.399675754754) 10 3 8 28856 29
119931 188543 1 150 1501 22nd St 13 Front Yard : Yard Tree 2     9     6013381.40306 2103831.17556 37.7574725594206 -122.396722580779 (37.7574725594206, -122.396722580779) 10 3 8 28856 29
122765 188562 1 150 36 03rd St 11 : Tree 2     12 Width 3ft   6015968.54272 2098749.82191 37.7436638776954 -122.387420665355 (37.7436638776954, -122.387420665355) 10 3 8 58 1
128049 200915 1 150 3801 03rd St 8 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   6015749.7726 2098032.6644 37.7416825916515 -122.388127088521 (37.7416825916515, -122.388127088521) 10 3 8 58 1
132091 1912 1 150 8 Bell Ct 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6016615.0158523 2095214.1533182 37.7339914292631 -122.384939021898 (37.7339914292631, -122.384939021898) 10 3 8 58 1
134873 6425 1 150 1100X Evans Ave 6 Sidewalk: Curb side : Cutout Tree 1   07/04/2003 12:00:00 AM 12 3x3   6018217.31109 2096647.32337 37.7380151271058 -122.379498860299 (37.7380151271058, -122.379498860299) 10 3 8 58 1
144258 6728 1 150 1200X Fairfax Ave 25 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
144780 188549 1 150 1790 23rd St 4 Sidewalk: Property side : Yard Tree 2     16     6013485.70626 2102911.99671 37.7549544981753 -122.396297433481 (37.7549544981753, -122.396297433481) 10 3 8 28856 29
145654 188546 1 150 651 Missouri St 9 Sidewalk: Property side : Yard Tree 2     10     6013632.14132 2103889.75102 37.757647347167 -122.395859525694 (37.757647347167, -122.395859525694) 10 3 8 28856 29
146942 188553 1 150 1790 23rd St 8 Sidewalk: Property side : Yard Tree 2     15     6013421.85474 2102905.28008 37.7549325025407 -122.396517780884 (37.7549325025407, -122.396517780884) 10 3 8 28856 29
158251 188550 1 150 1790 23rd St 17 Sidewalk: Curb side : Yard Tree 2     16     6013235.33415 2102896.38806 37.7548977050817 -122.397162202681 (37.7548977050817, -122.397162202681) 10 3 8 28856 29
165268 188545 1 150 651 Missouri St 1 Sidewalk: Property side : Yard Tree 2     14     6013660.85413 2103803.37059 37.75741176256 -122.395754171925 (37.75741176256, -122.395754171925) 10 3 8 28856 29
170310 188563 1 150 1 Waterville St 1 Side Yard : Yard Tree 2     6     6011470.31075 2096143.82241 37.7362581989524 -122.402791312072 (37.7362581989524, -122.402791312072) 10 3 8 58 1
171557 6704 1 150 1200X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
173340 22130 1 150 3795X 03rd St 15 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6015845.49183 2098416.12541 37.7427407998196 -122.387822870352 (37.7427407998196, -122.387822870352) 10 3 8 58 1
175920 188561 1 150 2230 Jerrold Ave 1 Sidewalk: Property side : Yard Tree 2     9 Width 8ft   6012197.23492 2099395.45129 37.7452270442016 -122.400506356909 (37.7452270442016, -122.400506356909) 10 3 8 58 1
180412 6835 1 150 1485 FAIRFAX AVE 4 Sidewalk: Curb side : Cutout Tree 1   01/03/2017 08:13:00 AM 3 3X3   6016296 2097688 37.7407664622153 -122.386214376382 (37.7407664622153, -122.386214376382) 10 3 8 58 1
185709 26889 1 150 1601 Galvez Ave 4 Sidewalk: Curb side : Cutout Tree 1     20 3x3   6015842.1307553 2097647.0535434 37.7406288998504 -122.387780842816 (37.7406288998504, -122.387780842816) 10 3 8 58 1
187481 22125 1 150 3795X 03rd St 10 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6015845.49183 2098416.12541 37.7427407998196 -122.387822870352 (37.7427407998196, -122.387822870352) 10 3 8 58 1
190012 6427 1 150 1100X Evans Ave 9 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6018163.14059 2096688.19053 37.7381243524454 -122.379688994958 (37.7381243524454, -122.379688994958) 10 3 8 58 1
191870 188555 1 150 1790 23rd St 10 Sidewalk: Property side : Yard Tree 2     15     6013407.82956 2102894.99959 37.7549034940071 -122.396565563648 (37.7549034940071, -122.396565563648) 10 3 8 28856 29
1772 72077 1 150 140 20th Ave 3 Sidewalk: Curb side : Cutout Tree 2 FUF   12     5989623.30395 2114484.58501 37.7853729513779 -122.479666163956 (37.7853729513779, -122.479666163956) 11 6 2 55 26
11264 74002 1 150 140 20th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF   7     5989624.30976 2114465.16508 37.7853196881434 -122.47966126275 (37.7853196881434, -122.47966126275) 11 6 2 55 26
15240 74217 1 150 140 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   10     5989626.45991 2114449.60046 37.7852770769798 -122.479652684717 (37.7852770769798, -122.479652684717) 11 6 2 55 26
17173 124764 1 150 138 Locust St 3 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5997570.27212 2115851.1781 37.7895836921739 -122.45227082935 (37.7895836921739, -122.45227082935) 11 6 1 54 31
20937 124765 1 150 138 Locust St 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5997565.1935 2115884.13609 37.7896738950858 -122.452290779906 (37.7896738950858, -122.452290779906) 11 6 1 54 31
28787 65914 7 150 431 Hugo St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28924 5994447.75768828 2106990.5338514 37.7650753550186 -122.462431373492 (37.7650753550186, -122.462431373492) 11 5 11 56 12
32255 120027 1 150 5250 Fulton St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 2ft   5987077.12189 2109838.60933 37.7724681813772 -122.488133553564 (37.7724681813772, -122.488133553564) 11 6 2 55 26
40967 63210 7 150 3601 Clement St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/18/1986 12:00:00 AM     Permit Number 23753 5984371.56597884 2113133.02236934 37.7813554779566 -122.497735487323 (37.7813554779566, -122.497735487323) 11 6 2 55 26
53426 12824 1 150 2201 Lake St 2 Sidewalk: Curb side : Cutout Tree 2     18 5   5988584.5219 2114647.39179 37.7857595743157 -122.48327193233 (37.7857595743157, -122.48327193233) 11 6 2 55 26
70416 12836 1 150 2255 Lake St 1 Sidewalk: Curb side : Cutout Tree 1   12/27/2017 03:44:00 PM 60 3x3   5988409.73159 2114642.30176 37.7857354248176 -122.483876276617 (37.7857354248176, -122.483876276617) 11 6 2 55 26
71879 120392 1 150 735 24th Ave 5 Sidewalk: Property side : Yard Tree 2     11     5988458.4501 2110868.62788 37.7753768145809 -122.483430984429 (37.7753768145809, -122.483430984429) 11 6 2 55 26
73044 56310 7 150 178 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/21/1984 12:00:00 AM     Permit Number 21650 5993077.11990526 2114307.36148956 37.7850863731263 -122.467704208587 (37.7850863731263, -122.467704208587) 11 6 2 54 11
77670 106400 1 150 100 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2     18 4x4   5989617.86074 2114578.87225 37.7856315213945 -122.479691897092 (37.7856315213945, -122.479691897092) 11 6 2 55 26