sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
887 251303 2 103 1 Cashmere St 2 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
2603 253136 2 103 3059 Pine St 1 1 1 1       4x5   5999298.0 2114593.0 37.786227889505604 -122.446202552789 (37.7862278895056, -122.446202552789)
3693 252877 2 103 1400 Baker St 2 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
5068 253206 2 103 2253 09th Ave 3 5 1 1       3x3   5993186.0 2100608.0 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971)
78981 113860 2 103 456 HILL ST 2 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
90489 113805 2 103 990X OSHAUGHNESSY BLVD 2 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
92750 113861 2 103 456 HILL ST 3 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
92823 116020 2 103 2023 09TH AVE 2 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
97315 113859 2 103 456 HILL ST 1 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
109652 113804 2 103 990X OSHAUGHNESSY BLVD 1 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
114512 108201 2 103 90 Reuel Ct 2 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
119476 108200 2 103 90 Reuel Ct 1 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
128787 116019 2 103 2023 09TH AVE 1 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
139866 115801 2 103 9M CAIRE TER 1 7 1 1           6012720.0 2101959.0 37.7522951385919 -122.398878598484 (37.7522951385919, -122.398878598484)
141326 113862 2 103 456 HILL ST 4 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
141792 119265 2 103 1317 Bosworth St 1 5 1 1           6000208.0 2096491.0 37.7365761953737 -122.44175457190599 (37.7365761953737, -122.441754571906)
34595 209040 2 103 419 Baden St 5 7 1 1     1     6000753.71672 2095344.13435 37.7334582487793 -122.43978559983 (37.7334582487793, -122.43978559983)
36668 209041 2 103 419 Baden St 6 7 1 1     1     6000751.4342 2095340.2355900002 37.7334474137664 -122.43979321169901 (37.7334474137664, -122.439793211699)
157173 209039 2 103 419 Baden St 4 7 1 1     1     6000750.66308 2095345.5130200002 37.7334618604699 -122.439796255913 (37.7334618604699, -122.439796255913)
176149 209037 2 103 419 Baden St 2 7 1 1     1     6000749.92806 2095352.54396 37.7334811239592 -122.43979930099701 (37.7334811239592, -122.439799300997)
76683 185931 2 103 2000 Sunset Blvd 74 9 1 1     2 Width 0ft   5985001.315 2101504.3546 37.749463324703996 -122.494699314147 (37.749463324704, -122.494699314147)
3850 207785 2 103 290 Santa Clara Ave 1 2 1 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
84894 105492 2 103 1575 07TH AVE 6 1 1 1     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571)
26956 208920 2 103 135 Saint Francis Blvd 2 2 1 1     4 Width 10ft   5992288.77396 2096040.55395 37.734884974665 -122.46910170710301 (37.734884974665, -122.469101707103)
42046 209030 2 103 36 Martha Ave 7 7 1 1     5     6000755.13076 2095576.9220900002 37.7340975102859 -122.439797395328 (37.7340975102859, -122.439797395328)
66266 191737 2 103 200 Helena St 2 2 1 1     5     6010885.73151 2096220.33708 37.736435634280895 -122.40481783988199 (37.7364356342809, -122.404817839882)
130011 209032 2 103 38 Martha Ave 1 7 1 1     5     6000749.17916 2095580.7996200002 37.7341078183059 -122.43981824973301 (37.7341078183059, -122.439818249733)
178073 224242 2 103 1100 San Jose Ave 40 7 1 1     5     6004773.2240699995 2096631.25513 37.7372203683314 -122.425980609816 (37.7372203683314, -122.425980609816)
35228 209038 2 103 419 Baden St 3 7 1 1     6     6000746.779019999 2095349.3205099998 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065)
48572 224238 2 103 1100 San Jose Ave 30 7 1 1     6     6004809.6017 2096680.0059200001 37.737356282853 -122.425858304718 (37.737356282853, -122.425858304718)
135102 224232 2 103 1100 San Jose Ave 22 7 1 1     6     6004847.66693 2096700.7431599998 37.7374153737207 -122.425728171024 (37.7374153737207, -122.425728171024)
150050 209031 2 103 36 Martha Ave 8 7 1 1     6     6000753.40861 2095578.70975 37.734102320756996 -122.43980347745001 (37.734102320757, -122.43980347745)
45082 209042 2 103 419 Baden St 7 7 1 1     7     6000746.1619 2095340.78312 37.7334486170489 -122.439811478728 (37.7334486170489, -122.439811478728)
45967 209014 2 103 412 Baden St 2 17 1 1     7     6000787.79858 2095464.06576 37.733789492485 -122.43967636459601 (37.733789492485, -122.439676364596)
148899 247820 2 103 1201 Jarboe Ave 2 7 1 1     7     6009707.559769999 2096850.2861400002 37.7380994142676 -122.40893572671699 (37.7380994142676, -122.408935726717)
154936 224219 2 103 1201 San Jose Ave 4 7 1 1     7     6004118.53569 2095824.9734900002 37.734969479450896 -122.428186723249 (37.7349694794509, -122.428186723249)
71482 176344 2 103 450 Raymond Ave 2 9 1 1     8     6008453.924319999 2088393.6006200002 37.714808853708604 -122.41267251952299 (37.7148088537086, -122.412672519523)
146980 247819 2 103 1201 Jarboe Ave 1 7 1 1     8     6009694.17454 2096850.5592099999 37.738099414264 -122.408982025597 (37.738099414264, -122.408982025597)
172652 247821 2 103 1201 Jarboe Ave 3 7 1 1     8     6009717.95526 2096849.3331900002 37.7380973799798 -122.40889971695 (37.7380973799798, -122.40889971695)
56581 209009 2 103 408 Baden St 1 7 1 1     9     6000785.2821 2095342.6683900002 37.7334560202787 -122.439676364582 (37.7334560202787, -122.439676364582)
133399 224230 2 103 1100 San Jose Ave 20 7 1 1     9     6004850.154069999 2096702.7007099998 37.7374208892559 -122.425719711103 (37.7374208892559, -122.425719711103)
72359 209033 2 103 38 Martha Ave 2 7 1 1     10     6000746.954419999 2095582.5977 37.7341126287783 -122.439826070211 (37.7341126287783, -122.439826070211)
160722 209027 2 103 36 Martha Ave 4 7 1 1     10     6000763.850930001 2095573.2374 37.7340878893448 -122.439766982962 (37.7340878893448, -122.439766982962)
165768 208980 2 103 302 Santa Clara Ave 1 2 1 1     10 Width 3ft   5993091.73044 2095958.45065 37.7347059025462 -122.46631966423901 (37.7347059025462, -122.466319664239)
65353 207764 2 103 1520 Monterey Blvd 2 2 1 1     11 Width 4ft   5993438.38203 2095281.4007599999 37.7328668869905 -122.46507202306299 (37.7328668869905, -122.465072023063)
170494 209008 2 103 406 Baden St 1 7 1 1     11     6000788.7045 2095325.02184 37.7334077617457 -122.439663267741 (37.7334077617457, -122.439663267741)
181095 247932 2 103 1099 Esmeralda Ave 5 17 1 1     11     6010369.906140001 2098762.7933799997 37.743387826290395 -122.406780401602 (37.7433878262904, -122.406780401602)
41213 224227 2 103 1100 San Jose Ave 17 7 1 1     12     6004843.36157 2096707.31423 37.7374331731056 -122.425743524245 (37.7374331731056, -122.425743524245)
54495 118438 2 103 5201 Anza St 6 2 1 1     12 Width 3ft   5982520.38622 2111663.82262 37.7772127952946 -122.50403070229099 (37.7772127952946, -122.504030702291)
63043 209019 2 103 33 Martha Ave 2 23 1 1     12     6000764.3171 2095528.5679900001 37.7339652640682 -122.43976216978201 (37.7339652640682, -122.439762169782)
153234 209020 2 103 33 Martha Ave 4 23 1 1     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547)
189014 209015 2 103 412 Baden St 3 17 1 1     12     6000779.78636 2095479.1538 37.73383046469421 -122.439705146498 (37.7338304646942, -122.439705146498)
28820 209004 2 103 156 Kensington Way 4 2 1 1     13 Width 3ft   5994803.6888 2098556.09355 37.7419370183784 -122.460589057359 (37.7419370183784, -122.460589057359)
71759 208946 2 103 300 Saint Francis Blvd 2 2 1 1     13 Width 10ft   5992719.83793 2096001.79663 37.7348034547201 -122.467608563598 (37.7348034547201, -122.467608563598)
124116 224234 2 103 1100 San Jose Ave 24 7 1 1     13     6004836.880530001 2096694.1378 37.7373966273622 -122.425764994654 (37.7373966273622, -122.425764994654)
181724 224226 2 103 1100 San Jose Ave 16 7 1 1     13     6004846.937969999 2096712.6297900002 37.7374479705325 -122.42573153718 (37.7374479705325, -122.42573153718)
182141 209011 2 103 408 Baden St 3 7 1 1     13     6000782.1941599995 2095354.33843 37.7334878877384 -122.439687876799 (37.7334878877384, -122.439687876799)
186323 224264 2 103 11 Germania St 3 1 1 1     13 Width 3ft   6004254.57068 2108904.38845 37.770890184456796 -122.42864845406 (37.7708901844568, -122.42864845406)
36905 224255 2 103 388 Corbett Ave 2 1 1 1     14 Width 3ft   5999122.55283 2104753.1321799997 37.7592000986313 -122.446101520571 (37.7592000986313, -122.446101520571)
61025 224257 2 103 355 Buena Vista Ave East 13 9 1 1     14 Width 3ft   6001064.07525 2107884.43165 37.767908557750204 -122.439611299541 (37.7679085577502, -122.439611299541)
61204 224222 2 103 1100 San Jose Ave 3 7 1 1     14     6004869.898159999 2096730.73115 37.7374989702074 -122.42565344095199 (37.7374989702074, -122.425653440952)
63720 224229 2 103 1100 San Jose Ave 19 7 1 1     14     6004833.29966 2096702.67223 37.7374198586269 -122.425777982686 (37.7374198586269, -122.425777982686)
69421 224263 2 103 11 Germania St 2 1 1 1     14 Width 3ft   6004229.44428 2108900.2308400003 37.770877346636205 -122.42873507047399 (37.7708773466362, -122.428735070474)
130326 209005 2 103 172 Kensington Way 1 2 1 1     14 Width 3ft   5994782.01847 2098589.82391 37.7420283868014 -122.460666429624 (37.7420283868014, -122.460666429624)
164592 191726 2 103 700 Missouri St 1 7 1 1     14     6013632.69543 2103711.63212 37.757158302141 -122.395845128465 (37.757158302141, -122.395845128465)
175511 208978 2 103 700 Junipero Serra Blvd 109 4 1 1     14 Width 0ft   5991241.872330001 2091923.37185 37.723519677182495 -122.47242112456001 (37.7235196771825, -122.47242112456)
68974 224228 2 103 1100 San Jose Ave 18 7 1 1     15     6004840.27089 2096702.3446900002 37.7374193532181 -122.425753856564 (37.7374193532181, -122.425753856564)
90816 119631 2 103 265 Fowler Ave 1 9 1 1     15 3x5   5997384.0 2099137.0 37.7436801569324 -122.451709113802 (37.7436801569324, -122.451709113802)
136867 224241 2 103 1100 San Jose Ave 41 7 1 1     15     6004764.42793 2096634.9587599998 37.7372300405369 -122.42601128568998 (37.7372300405369, -122.42601128569)
137042 207787 2 103 292 Santa Clara Ave 1 2 1 1     15 Width 10ft   5993086.25016 2096104.5741400002 37.7351068050182 -122.466349227661 (37.7351068050182, -122.466349227661)
152307 208936 2 103 3 Saint Francis Blvd 2 2 1 1     15 Width 10ft   5991855.38456 2095971.03212 37.7346690339426 -122.470595009771 (37.7346690339426, -122.470595009771)
177154 224221 2 103 1000 San Jose Ave 63 7 1 1     15     6005093.2410699995 2097044.1609999998 37.7383721957242 -122.424903531393 (37.7383721957242, -122.424903531393)
33664 207789 2 103 275 Santa Clara Ave 1 2 1 1     16 Width 10ft   5993131.90761 2096210.54353 37.735400404893 -122.46619907325199 (37.735400404893, -122.466199073252)
76953 208935 2 103 3 Saint Francis Blvd 1 2 1 1     16 Width 10ft   5991812.79149 2095969.62922 37.7346627188958 -122.47074216493401 (37.7346627188958, -122.470742164934)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
146709 224254 2 103 190 Storrie St 4 7 1 1     16 Width 3ft   6000752.12131 2105271.59361 37.760716590308704 -122.440502889194 (37.7607165903087, -122.440502889194)
149384 207754 2 103 1364 08th Ave 1 1 1 1     16 Width 4ft   5993663.7534300005 2106217.17575 37.7629067380829 -122.46508685559999 (37.7629067380829, -122.4650868556)
162672 207760 2 103 333 Santa Clara Ave 1 2 1 1     16 Width 10ft   5993144.47081 2095802.99513 37.734282103340796 -122.46612603120501 (37.7342821033408, -122.466126031205)
174806 185917 2 103 2000 Sunset Blvd 60 9 1 1     16 Width 0ft   5985004.5736 2101420.7172 37.749233870008794 -122.494681880668 (37.7492338700088, -122.494681880668)
182600 209016 2 103 412 Baden St 4 17 1 1     16     6000787.61929 2095495.57167 37.7338759901863 -122.43967924239901 (37.7338759901863, -122.439679242399)
701 176335 2 103 287 Hester Ave 5 17 1 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
30634 207776 2 103 110 Santa Clara Ave 2 2 1 1     17 Width 10ft   5993235.98614 2096867.2882599998 37.7372096663776 -122.46588694193001 (37.7372096663776, -122.46588694193)
32381 207778 2 103 124 Santa Clara Ave 1 2 1 1     17 Width 10ft   5993200.08857 2096786.31561 37.7369852648432 -122.46600517310699 (37.7369852648432, -122.466005173107)
47668 208973 2 103 136 Yerba Buena Ave 1 2 1 1     17 Width 6ft   5994259.725980001 2096572.0955299998 37.7364581434207 -122.46232602774799 (37.7364581434207, -122.462326027748)
62115 247923 2 103 1098 Esmeralda Ave 8 17 1 1     17     6010288.87158 2098729.72842 37.7432925026595 -122.40705826963699 (37.7432925026595, -122.407058269637)
171861 224261 2 103 355 Buena Vista Ave East 18 9 1 1     17 Width 3ft   6001117.5941 2107921.40745 37.768013130033204 -122.439428835199 (37.7680131300332, -122.439428835199)
179858 224235 2 103 1100 San Jose Ave 25 7 1 1     17     6004831.6413199995 2096688.95275 37.7373820943173 -122.425782740103 (37.7373820943173, -122.425782740103)
31541 247930 2 103 1099 Esmeralda Ave 3 17 1 1     18     6010384.98383 2098777.78466 37.7434298327179 -122.406729322818 (37.7434298327179, -122.406729322818)
37470 176346 2 103 40 Teddy Ave 1 9 1 1     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861)
43077 191722 2 103 1100 25th St 1 2 1 1     18     6014479.640380001 2101959.5389 37.752394509601494 -122.392793471535 (37.7523945096015, -122.392793471535)
63465 224224 2 103 1100 San Jose Ave 14 7 1 1     18     6004854.036780001 2096713.3958700001 37.737450475157296 -122.42570704776199 (37.7374504751573, -122.425707047762)
69718 208957 2 103 625 Saint Francis Blvd 1 2 1 1     18 Width 8ft   5993588.443419999 2096129.23717 37.73520348755321 -122.46461476908001 (37.7352034875532, -122.46461476908)
72350 209029 2 103 36 Martha Ave 6 7 1 1     18     6000758.12976 2095576.10922 37.7340954490409 -122.43978696861299 (37.7340954490409, -122.439786968613)
119339 121341 2 103 401X Cargo Way 2 17 1 1     18 3x3   6017217.0 2098844.0 37.7439915378474 -122.383110313195 (37.7439915378474, -122.383110313195)
132331 208961 2 103 1575 07th Ave 6 1 1 1     18 Width 2ft   5993977.82871 2104681.32491 37.75870779624321 -122.463889098911 (37.7587077962432, -122.463889098911)
159705 191732 2 103 100 Hampshire St 4 7 1 1     18     6009982.19315 2107558.06249 37.7675159677065 -122.408741381426 (37.7675159677065, -122.408741381426)
165006 208952 2 103 440 Saint Francis Blvd 3 2 1 1     18 Width 10ft   5993062.868430001 2096011.9995 37.734851268974296 -122.466423339872 (37.7348512689743, -122.466423339872)
166974 209007 2 103 172 Kensington Way 3 2 1 1     18 Width 3ft   5994745.50567 2098641.39451 37.7421678860404 -122.460796414937 (37.7421678860404, -122.460796414937)
Powered by Datasette · Query took 162.008ms · Data source: data.sfgov.org