sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
140619 95331 3 47 390X Filbert St 2 3 1 2     18     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
103346 95333 3 17 399X Filbert St 5 3 1 2     24     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
53598 95407 3 3 2X Cranleigh Dr 9 3 1 2     80     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
142482 96128 3 17 1420X Innes Ave 1 3 1 2     12     6016441.6 2096581.1 37.7377351967413 -122.385633815961 (37.7377351967413, -122.385633815961)
102603 96129 3 17 1424X Innes Ave 1 3 1 2     12     6016423.9 2096594.4 37.7377707364606 -122.385695940665 (37.7377707364606, -122.385695940665)
94441 96130 3 17 1428X Innes Ave 1 3 1 2     12     6016403.1 2096603.7 37.737795121412795 -122.385768505015 (37.7377951214128, -122.385768505015)
109811 96135 3 17 1444X Innes Ave 1 3 1 2     12     6016335.2 2096661.0 37.7379486980737 -122.386007263552 (37.7379486980737, -122.386007263552)
82638 96136 3 17 1454X Innes Ave 1 3 1 2     12     6016287.8 2096690.3 37.7380265265677 -122.386173192236 (37.7380265265677, -122.386173192236)
129100 96137 3 17 1454X Innes Ave 2 3 1 2     12     6016287.8 2096690.3 37.7380265265677 -122.386173192236 (37.7380265265677, -122.386173192236)
115913 96138 3 17 1454X Innes Ave 3 3 1 2     12     6016287.8 2096690.3 37.7380265265677 -122.386173192236 (37.7380265265677, -122.386173192236)
91583 96139 3 17 1460X Innes Ave 1 3 1 2     12     6016261.2 2096710.2 37.738079695647706 -122.386266549459 (37.7380796956477, -122.386266549459)
144035 96140 3 17 1460X Innes Ave 2 3 1 2     12     6016261.2 2096710.2 37.738079695647706 -122.386266549459 (37.7380796956477, -122.386266549459)
79938 96141 3 17 1468X Innes Ave 1 3 1 2     12     6016228.8 2096740.9 37.738162198215 -122.386380713289 (37.738162198215, -122.386380713289)
145563 96142 3 17 1468X Innes Ave 2 3 1 2     12     6016228.8 2096740.9 37.738162198215 -122.386380713289 (37.738162198215, -122.386380713289)
145598 96143 3 17 1470X Innes Ave 1 3 1 2     12     6016219.9 2096747.5 37.738179827823 -122.38641194538201 (37.738179827823, -122.386411945382)
120340 96144 3 17 1484X Innes Ave 1 3 1 2     12     6016157.8 2096794.1 37.7383043442369 -122.386629906827 (37.7383043442369, -122.386629906827)
84421 96975 3 17 399X Filbert St 4 3 1 1     24     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
93919 96976 2 143 390X Filbert St 1 3 1 3     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
142749 97395 3 24 1203X Sunset Blvd 14 3 1 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
128569 97396 3 24 1203X Sunset Blvd 15 3 1 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
116741 97397 3 149 1203X Sunset Blvd 17 3 1 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
104474 97692 3 37 70x Benton Ave 1 3 1 2   11/05/2011 12:00:00 AM       6004768.61645 2094959.0484200001 37.732628603868704 -122.425877544976 (37.7326286038687, -122.425877544976)
104032 98994 3 5 745X SANCHEZ ST 1 3 1 2     40     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
116375 99101 6 11 55x Santa Monica Way 1 3 1 1   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.739396991894104 -122.464361897304 (37.7393969918941, -122.464361897304)
81264 99456 1 60 400X Miramar Ave 6 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
85151 99471 1 60 600X Miramar Ave 7 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
19556 99478 1 60 650X Miramar Ave 4 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
138714 99482 1 60 700X Miramar Ave 1 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
123683 99488 1 60 800X Miramar Ave 1 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
98576 99490 1 60 800X Miramar Ave 4 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
87236 99491 1 60 800X Miramar Ave 5 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
129469 101030 3 143 1010X Portola Dr 4 3 1 2     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
121860 102111 3 3 18 Saturn St 1 3 1 1     24     6000559.0 2106017.0 37.7627522940794 -122.441224290546 (37.7627522940794, -122.441224290546)
92518 102573 3 47 20X Park St 1 3 1 2     24     6004982.6 2096420.1 37.7366524147431 -122.425241679782 (37.7366524147431, -122.425241679782)
19618 102860 3 177 10X CRANLEIGH DR 1 3 1 2   03/06/2013 12:00:00 AM 6     5991339.0 2095700.0 37.7338949747581 -122.472360557436 (37.7338949747581, -122.472360557436)
109166 103947 3 3 2363X 36th Ave 1 3 1 2     15     5985162.60331 2099213.25819 37.74318203563929 -122.49397275511299 (37.7431820356393, -122.493972755113)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
141372 104398 3 47 3525X Ulloa St 1 3 1 2     48     5985120.1668300005 2098189.34613 37.7403681660846 -122.494044040088 (37.7403681660846, -122.494044040088)
141156 104399 3 47 2440X 37th Ave 1 3 1 2           5984875.46821 2098521.80546 37.7412666886784 -122.49491460561501 (37.7412666886784, -122.494914605615)
110858 104466 3 47 200X VIDAL DR 1 3 1 2     50     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
108451 104499 3 3 44X SATURN ST 1 3 1 2     18     6000456.0 2106003.0 37.7627079858093 -122.44157952536999 (37.7627079858093, -122.44157952537)
95383 104500 3 47 22 SATURN ST 1 3 1 2     45     6000539.0 2106092.0 37.762957086281396 -122.441298844913 (37.7629570862814, -122.441298844913)
100517 104502 5 3 30X SATURN ST 1 3 1 2     14     6000456.0 2106003.0 37.7627079858093 -122.44157952536999 (37.7627079858093, -122.44157952537)
85176 104920 2 75 750 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
101258 104921 2 75 750 Gonzalez Dr 2 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
111624 104922 2 75 750 Gonzalez Dr 3 3 1 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
144760 104926 2 75 810 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
143894 104927 2 75 810 Gonzalez Dr 2 3 1 1     10     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
128606 104928 2 75 810 Gonzalez Dr 3 3 1 1     12     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
140384 104978 2 116 66X San Lorenzo Way 1 3 1 1         Permit Number 770332 5993690.5 2097533.7 37.7390656757525 -122.46436386193301 (37.7390656757525, -122.464363861933)
115289 105020 3 25 101X ORD ST 1 3 1 2     12     6000863.0 2105739.0 37.7620062865301 -122.44015292861602 (37.7620062865301, -122.440152928616)
97142 105761 3 3 2400X CASTRO ST 12 3 1 2     16     6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
125646 105762 3 3 2400X CASTRO ST 13 3 1 2     20     6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
77799 105836 3 24 2100X SLOAT BLVD 1 3 1 2     2     5984309.0 2095832.0 37.733848030924 -122.49667476772 (37.733848030924, -122.49667476772)
144906 105837 3 47 2100X SLOAT BLVD 4 3 1 2     7     5984309.0 2095832.0 37.733848030924 -122.49667476772 (37.733848030924, -122.49667476772)
122322 105909 2 5 1864X 14TH AVE 1 3 1 3     14     5991829.0 2102804.0 37.7534290869332 -122.47118388851999 (37.7534290869332, -122.47118388852)
108704 106057 3 3 140X CANYON DR 1 3 1 2     18     6002713.0 2086188.2 37.708429419739794 -122.432358106226 (37.7084294197398, -122.432358106226)
10408 106060 3 177 12X Canyon Dr 3 3 1 2     24     6003183.55845 2086355.5239400002 37.7089155261884 -122.430743733243 (37.7089155261884, -122.430743733243)
11659 106061 3 3 12X Canyon Dr 1 3 1 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
95665 106062 3 3 140X CANYON DR 2 3 1 2     30     6002713.0 2086188.2 37.708429419739794 -122.432358106226 (37.7084294197398, -122.432358106226)
94540 106114 3 100 1752X DOLORES ST 1 3 1 2           6005197.0 2098194.1 37.741535528464496 -122.424626562024 (37.7415355284645, -122.424626562024)
85292 106578 3 40 1001X SAN JOSE AVE 2 3 1 2     24     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
101240 106579 3 40 1001X SAN JOSE AVE 3 3 1 2     26     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
121315 106581 3 40 1001X SAN JOSE AVE 4 3 1 2     9     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
95732 106583 3 40 1001X SAN JOSE AVE 5 3 1 2     22     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
107987 106584 3 40 1001X SAN JOSE AVE 5 3 1 2     22     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
108041 106585 3 40 1001X SAN JOSE AVE 6 3 1 2     25     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
141868 106586 3 40 1001X SAN JOSE AVE 7 3 1 2     11     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
125322 106587 3 40 1001X SAN JOSE AVE 8 3 1 2     25     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
118789 106592 3 40 1001X SAN JOSE AVE 9 3 1 2     34     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
115315 106597 3 40 1001X SAN JOSE AVE 10 3 1 2     19     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
10203 106598 3 5 1001X SAN JOSE AVE 11 3 1 2     21     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
101111 106599 3 40 1001X SAN JOSE AVE 12 3 1 2     42     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
107740 107644 2 3 1400x KIRKWOOD AVE 1 3 1 1           6015822.8 2096363.1 37.7371023539668 -122.38775811873998 (37.7371023539668, -122.38775811874)
18076 107933 3 17 3098X Market St 1 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
123876 107934 3 17 3098X Market St 3 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
79307 107935 3 17 1099X Market St 3 3 1 2           6009025.86197 2112294.38137 37.7804671773494 -122.41238403194401 (37.7804671773494, -122.412384031944)
142186 107936 3 17 3098X Market St 2 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
113179 108043 3 3 2901X SUNSET BLVD OFF RAMP 1 3 1 2     30     5985539.0 2095817.0 37.7338788340947 -122.492421243764 (37.7338788340947, -122.492421243764)
128096 108044 3 3 2901X SUNSET BLVD OFF RAMP 2 3 1 2     99     5985539.0 2095817.0 37.7338788340947 -122.492421243764 (37.7338788340947, -122.492421243764)
106620 108045 3 3 2901X SUNSET BLVD OFF RAMP 3 3 1 2     40     5985539.0 2095817.0 37.7338788340947 -122.492421243764 (37.7338788340947, -122.492421243764)
144456 108046 3 3 2901X SUNSET BLVD ON RAMP 3 3 1 2     99     5985273.0 2095807.0 37.733835821368295 -122.493340136435 (37.7338358213683, -122.493340136435)
127178 108238 2 17 764x JUNIPERO SERRA BLVD 1 3 1 1           5991289.6 2092496.8 37.7250969308873 -122.47229792145599 (37.7250969308873, -122.472297921456)
84882 108688 3 3 1x MONTEZUMA ST 1 3 1 2     20     6007361.0 2099793.0 37.7460477277002 -122.417257445993 (37.7460477277002, -122.417257445993)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
118269 109197 2 36 2401x CASTRO ST 3 3 1 2     12     6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
125797 109198 2 36 2401x CASTRO ST 2 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
86474 109199 2 36 2401x CASTRO ST 7 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123401 109201 2 36 2401x CASTRO ST 4 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
83073 109202 2 36 2401x CASTRO ST 6 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
128009 109203 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
85810 109204 2 36 2401x CASTRO ST 8 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123260 109205 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
105675 109208 2 36 2401x CASTRO ST 1 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
91226 109209 2 180 2401x CASTRO ST 5 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
86719 109347 3 71 59x BURNSIDE AVE 1 3 1 2     14     6001229.7 2095779.3 37.7346801948558 -122.438171157158 (37.7346801948558, -122.438171157158)
146161 109674 3 47 200X VIDAL DR 3 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
109683 109675 3 47 200X VIDAL DR 4 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
83234 109676 3 47 200X VIDAL DR 5 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
141517 109677 3 47 200X VIDAL DR 6 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
Powered by Datasette · Query took 9.063ms · Data source: data.sfgov.org