sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
112275 100071 2 39 96X Douglass St 1 1 1 1       3x3 Address is 4200-4204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284)
114221 100072 2 39 96X Douglass St 2 1 1 1       3x3 Address is 1200-1204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284)
142899 100073 1 482 930@ Lorraine Ct Anza St 2 1 1 1   07/02/2012 12:00:00 AM   3x3 Permit Number 769060 5996162.0 2112255.0 37.7796287713947 -122.45688306406099 (37.7796287713947, -122.456883064061)
81746 100074 2 17 701 Noe St   1 1 1           6003070.0 2104166.0 37.7578126071811 -122.43240742658399 (37.7578126071811, -122.432407426584)
144263 100075 2 17 707-709 Noe St   1 1 1       3x3   6003067.0 2104139.0 37.757738301523105 -122.43241587342699 (37.7577383015231, -122.432415873427)
108919 100076 1 519 262 17th Ave 1 1 1 1   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776532 5990584.51145 2113652.92092 37.783145223942 -122.47627994024201 (37.783145223942, -122.476279940242)
108144 100077 2 46 260 Page St 1 1 1 1       3x3   6005310.0 2109942.0 37.7737988894613 -122.42507153447501 (37.7737988894613, -122.425071534475)
122707 100078 1 519 266 17th Ave 1 1 1 1   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776410 5990586.53381 2113609.7978 37.7830269371305 -122.47626979286501 (37.7830269371305, -122.476269792865)
40075 100079 2 1 1451 44th Ave 1 1 1 1     14 3x6   5982451.9345 2105243.3429 37.759579983868605 -122.503791871245 (37.7595799838686, -122.503791871245)
101662 100080 1 11 701X POLK ST 1 1 1 1   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774752 6007001.0 2113322.0 37.7831749319814 -122.419461922492 (37.7831749319814, -122.419461922492)
95559 100087 1 9 2028 Filbert St 1 1 1 1           6003216.8 2118972.8 37.798476716718895 -122.432957560795 (37.7984767167189, -122.432957560795)
162761 100088 2 52 2034 Filbert St 1 1 1 1     11 3x3   6003201.40964 2118956.6592900003 37.7984315255609 -122.43300966237301 (37.7984315255609, -122.433009662373)
65147 100089 2 52 2034 Filbert St 2 1 1 1     8 3x3   6003188.20593 2118955.0281 37.7984262977915 -122.43305523462601 (37.7984262977915, -122.433055234626)
100352 100090 2 60 11X Shotwell St 1 1 1 1     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993)
102318 100091 2 191 11X Shotwell St 2 1 1 1     5 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993)
107864 100092 2 17 11X Shotwell St 4 1 1 1     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993)
93276 100093 2 191 11X Shotwell St 5 1 1 1     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993)
17835 100094 2 60 11X Shotwell St 6 1 1 1     12 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993)
107282 100095 1 17 4372 26th St 1 1 1 3 3 07/03/2012 12:00:00 AM   3x3 Permit Number 769070 6001507.0 2100613.7 37.747970090970504 -122.43755853273001 (37.7479700909705, -122.43755853273)
90647 100096 1 15 495 Jefferson St 1 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
87167 100097 1 15 495 Jefferson St 2 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
91649 100098 1 15 495 Jefferson St 3 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
126698 100099 1 15 495 Jefferson St 4 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
140481 100100 1 15 495 Jefferson St 5 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
110150 100101 1 15 495 Jefferson St 6 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
93311 100102 2 201 495@ Beach Jefferson St 2 1 1 1           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066)
77838 100103 2 108 461 Jefferson St 1 1 1 1           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169)
141339 100104 2 108 461 Jefferson St 2 1 1 1           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169)
113022 100105 2 108 461 Jefferson St 3 1 1 1           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169)
109346 100106 2 43 461 Jefferson St 4 1 1 1           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169)
82122 100107 2 43 461 Jefferson St 5 1 1 1           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169)
102979 100108 2 43 461 Jefferson St 6 1 1 1           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169)
88125 100109 2 11 333 Jefferson St 1 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
89982 100110 2 11 333 Jefferson St 2 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
93784 100111 2 11 333 Jefferson St 3 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
100595 100112 2 11 333 Jefferson St 4 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
86389 100113 2 11 333 Jefferson St 5 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
81210 100114 2 11 333 Jefferson St 6 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
112445 100115 2 11 333 Jefferson St 7 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
113502 100116 2 11 333 Jefferson St 8 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
95264 100117 2 11 333 Jefferson St 9 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
139689 100118 2 11 333 Jefferson St 10 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
90019 100119 2 11 333 Jefferson St 11 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
118771 100120 2 11 333 Jefferson St 12 1 1 1           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
106068 100123 2 5 690 Miramar Ave 1 9 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
126830 100124 6 431 40@ San Ramon Eastwood Dr 1 7 1 1           5995635.0 2092781.0 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484)
37666 100125 2 15 1800 Washington St 1 1 1 1     11     6005967.88782 2116944.18436 37.793062307639204 -122.423293649581 (37.7930623076392, -122.423293649581)
35544 100126 2 15 1800 Washington St 2 1 1 1     14     6005948.98718 2116940.10629 37.7930500435754 -122.423358756926 (37.7930500435754, -122.423358756926)
47709 100127 2 15 1800 Washington St 3 1 1 1     13     6005919.013280001 2116937.33835 37.793040751777895 -122.423462271584 (37.7930407517779, -122.423462271584)
33270 100128 2 15 1800 Washington St 4 1 1 1     12     6005897.30712 2116933.8296 37.7930298924771 -122.42353712664499 (37.7930298924771, -122.423537126645)
15069 100129 2 37 155 05th St 1 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011082.10119 2112775.22352 37.7819026320456 -122.40530436681401 (37.7819026320456, -122.405304366814)
16480 100130 2 37 155 05th St 2 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011065.09249 2112790.5825400003 37.7819438533601 -122.40536429132601 (37.7819438533601, -122.405364291326)
16324 100131 2 37 155 05th St 3 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011051.59118 2112804.91213 37.781982444176705 -122.405412009362 (37.7819824441767, -122.405412009362)
14515 100132 2 37 155 05th St 4 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011001.43438 2112862.15185 37.782136806515496 -122.405589562524 (37.7821368065155, -122.405589562524)
14550 100133 2 37 155 05th St 5 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010986.38868 2112879.38733 37.7821832897709 -122.405642828459 (37.7821832897709, -122.405642828459)
15641 100134 2 37 155 05th St 6 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010970.105930001 2112898.8843900003 37.782235913593 -122.40570053346902 (37.782235913593, -122.405700533469)
99637 100135 2 17 155 05th St 1 7 1 1   11/27/2012 12:00:00 AM 9   Permit Number 769351 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
15639 100136 2 37 155 05th St 7 1 1 1   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010957.25903 2112913.8393900003 37.782276258096296 -122.405746031954 (37.7822762580963, -122.405746031954)
102364 100137 2 17 155 05th St 8 1 1 1       3x3 Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
80812 100138 2 17 155 05th St 9 1 1 1       3x3 Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
98786 100139 7 17 155 05th St 2 7 1 1         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
122054 100145 2 85 222X Cumberland St 4 1 1 1           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895)
88634 100146 2 85 222X Cumberland St 5 1 1 1           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895)
98916 100147 2 20 3955 18th St 1 1 1 1     8 3x3   6003272.0 2105332.0 37.761025616168396 -122.431792078279 (37.7610256161684, -122.431792078279)
125346 100148 7 17 209 Vicksburg St   13 1 1           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815)
115292 100149 2 17 3975 18th St 1 1 1 1     1 3x3   6003144.0 2105325.0 37.760999139175794 -122.43223427442499 (37.7609991391758, -122.432234274425)
19681 100150 2 9 4007 18th St 1 1 1 1     3 3x3   6002942.0 2105314.0 37.7609574805046 -122.432932117926 (37.7609574805046, -122.432932117926)
122138 100151 2 89 4047 18th St 1 1 1 1     2 5x5 Permit Number 776452 6002690.0 2105300.0 37.760904743288705 -122.433802674054 (37.7609047432887, -122.433802674054)
87700 100152 2 20 500X Noe St 2 1 1 1     8 3x3   6002933.4 2105264.1 37.760819979332105 -122.432958296422 (37.7608199793321, -122.432958296422)
5207 100153 2 26 590 08th Ave 3 1 1 1     10   Permit Number 780398 5993481.43699 2111479.23814 37.7773444498569 -122.46609982361299 (37.7773444498569, -122.466099823613)
122487 100154 1 21 421 Arguello Blvd 1 1 1 1   07/09/2012 12:00:00 AM 2 3x3 Permit Number 768665 5995548.20979 2113421.38615 37.7827960924124 -122.459090895565 (37.7827960924124, -122.459090895565)
110393 100155 1 21 421 Arguello Blvd 2 1 1 1   07/09/2012 12:00:00 AM 1 3x3 Permit Number 768665 5995547.63901 2113410.0857599997 37.782765031751296 -122.459092051698 (37.7827650317513, -122.459092051698)
66788 100156 1 21 421 Arguello Blvd 3 1 1 1   07/09/2012 12:00:00 AM 2 3x3 Permit Number 768665 5995549.3318 2113386.41255 37.782700128760794 -122.45908448070101 (37.7827001287608, -122.459084480701)
110999 100157 1 15 14 Broderick St 2 1 1 1           6001430.1 2108737.2 37.7702708737839 -122.438406367889 (37.7702708737839, -122.438406367889)
124830 100158 1 15 14 Broderick St 3 1 1 1   07/09/2012 12:00:00 AM     Permit Number 769008 6001430.1 2108737.2 37.7702708737839 -122.438406367889 (37.7702708737839, -122.438406367889)
182844 100160 1 32 1699 Vallejo St 2 1 1 1     11   Permit Number 28164 6005505.58523 2118187.22554 37.7964492830571 -122.424981725648 (37.7964492830571, -122.424981725648)
174840 100161 1 37 1699 Vallejo St 3 1 1 1     2   Permit Number 28164 6005519.03005 2118189.86695 37.7964572951359 -122.42493539165599 (37.7964572951359, -122.424935391656)
73623 100162 1 37 1699 Vallejo St 4 1 1 1     3   Permit Number 28164 6005532.34096 2118193.0872400003 37.7964668890905 -122.424889562218 (37.7964668890905, -122.424889562218)
122540 100163 2 32 1814 Union St 1 1 1 1     18     6004278.90656 2118759.95598 37.797952487273605 -122.429267157958 (37.7979524872736, -122.429267157958)
183764 100164 1 32 839 Leavenworth St 3 1 1 1     14 3x3   6008231.9319 2115379.46118 37.7888934760005 -122.41534908182 (37.7888934760005, -122.41534908182)
40732 100165 1 32 839 Leavenworth St 4 1 1 1     14 3x3   6008234.89338 2115366.55149 37.7888581955857 -122.415337921201 (37.7888581955857, -122.415337921201)
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
122879 100167 1 60 710 El Camino Del Mar 1 1 1 1           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671)
141182 100168 1 2 710 El Camino Del Mar 2 1 1 1           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671)
122667 100169 3 3 180X Manchester St   13 1 2         Adjacent to rear of property - DPW parcel 6008242.0 2099158.0 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282)
44206 100170 1 17 2149 Grove St 1 1 1 1   07/11/2012 12:00:00 AM 4 3x3 Permit Number 769012 5997531.0 2110183.0 37.774018114579896 -122.451997596236 (37.7740181145799, -122.451997596236)
110792 100171 6 76 109 Edgewood Ave 1 7 1 1           5996563.8 2106359.1 37.763463224843996 -122.455066914463 (37.763463224844, -122.455066914463)
113059 100174 2 17 50 O'Farrell St 1 1 1 1   07/12/2012 12:00:00 AM 18 3x3 Permit Number 769094 6010932.2 2114627.3 37.7869796149513 -122.405953468587 (37.7869796149513, -122.405953468587)
113831 100175 1 11 1140 Page St 1 1 1 1   07/12/2012 12:00:00 AM   3x3 Permit Number 768230 6001099.0 2109378.2 37.772012061027006 -122.43959759817301 (37.772012061027, -122.439597598173)
65540 100177 1 3 252 States St 3 7 1 1         Permit Number 768965 6000636.0 2106677.4 37.764569975148895 -122.44100535545 (37.7645699751489, -122.44100535545)
99782 100178 1 41 1270 Sanchez St 3 1 1 1   07/06/2012 12:00:00 AM   3x3   6003851.0 2100874.0 37.748817804949496 -122.42947164058 (37.7488178049495, -122.42947164058)
95039 100179 1 41 1270 Sanchez St 4 1 1 1   07/06/2012 12:00:00 AM   3x3   6003851.0 2100874.0 37.748817804949496 -122.42947164058 (37.7488178049495, -122.42947164058)
97490 100180 2 62 100x BELVEDERE ST 3 1 1 1       3x3   5997991.0 2108152.0 37.768467847026294 -122.450259955793 (37.7684678470263, -122.450259955793)
13839 100181 2 32 230 Ritch St 2 1 1 1     15     6013794.16577 2112184.81721 37.7804327665865 -122.39588042503999 (37.7804327665865, -122.39588042504)
15722 100182 2 32 230 Ritch St 3 1 1 1     20     6013808.29227 2112170.33848 37.7803937971776 -122.39583053966001 (37.7803937971776, -122.39583053966)
127433 100183 1 17 956 Noe St 1 1 1 1       3x3   6003075.2 2102641.9 37.7536280862965 -122.432280596021 (37.7536280862965, -122.432280596021)
182317 100184 2 2 480 Oxford St 1 1 1 1     11 3x3   6006818.05082 2091764.69226 37.7239732025834 -122.418565697766 (37.7239732025834, -122.418565697766)
115349 100186 3 191 2445 HARRISON ST 3 1 1 2     8 3x3   6008897.0 2104213.0 37.758270352242796 -122.41225848424999 (37.7582703522428, -122.41225848425)
99942 100187 1 28 217 Montcalm St 1 1 1 1   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
122591 100188 1 28 217 Montcalm St 2 1 1 1   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
Powered by Datasette · Query took 104.35ms · Data source: data.sfgov.org