sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9655 114155 6 128 1200X JUNIPERO SERRA BLVD 16 7 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10002 114158 6 259 1200X JUNIPERO SERRA BLVD 6 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10004 114140 6 3 1200X JUNIPERO SERRA BLVD 5 17 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10011 173616 6 26 1200X JUNIPERO SERRA BLVD 15 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
89097 114144 6 140 1200x JUNIPERO SERRA BLVD 1 7 1 1     10     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
89972 114147 6 3 1200x JUNIPERO SERRA BLVD 4 7 1 1     7     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
118401 114145 6 140 1200x JUNIPERO SERRA BLVD 2 7 1 1     6     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
140509 114146 6 140 1200x JUNIPERO SERRA BLVD 3 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
83993 114406 6 203 500X ARBALLO DR 3 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
93266 114407 6 177 500X ARBALLO DR 4 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
107939 114408 6 203 500X ARBALLO DR 5 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
109893 114409 6 103 500X ARBALLO DR 6 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
112205 114404 6 203 500X ARBALLO DR 1 1 1 1     24 3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
138618 114405 6 203 500X ARBALLO DR 2 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
89824 110738 6 333 1299x PERSIA AVE 5 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
104170 110739 6 333 1299x PERSIA AVE 6 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
125443 110737 6 333 1299x PERSIA AVE 4 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
50102 94943 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
88058 94937 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
96189 94940 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111560 94941 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111884 94939 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
112975 94938 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
139320 94936 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144144 94944 6 540 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144883 94942 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
11662 102569 6 41 0 Diaz Ave 1 7 1 1   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.8197400002 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439)
19054 94934 6 311 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81078 94935 6 469 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
141804 96996 6 235 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
52917 116537 6 17 598x MOUNT VERNON AVE 6 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
96225 116534 6 17 598x MOUNT VERNON AVE 3 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
101782 116536 6 17 598x MOUNT VERNON AVE 5 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
111156 116535 6 17 598x MOUNT VERNON AVE 4 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
108075 116951 6 24 299 Tara St 1 7 1 1           5997754.0 2090179.6 37.7191064490611 -122.44978436622101 (37.7191064490611, -122.449784366221)
108061 104751 6 5 13X JUAN BAUTISTA CIR 2 7 1 1           5989494.0 2090180.0 37.7186314952818 -122.47833572411999 (37.7186314952818, -122.47833572412)
91565 114074 6 146 18x HIGUERA AVE 2 2 1 1     5     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
119334 114073 6 146 18x HIGUERA AVE 1 2 1 1     6     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
108375 111357 6 3 600x MANSELL ST 1 8 1 2     48 3x3   6010142.0 2090267.0 37.720047423695505 -122.40696976451099 (37.7200474236955, -122.406969764511)
89406 114379 6 5 443X ARBALLO DR 1 7 1 1     36     5988110.0 2090275.0 37.718811899837206 -122.483126550771 (37.7188118998372, -122.483126550771)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
84582 114072 6 21 454 ARBALLO DR 1 2 1 1     4     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
86962 114103 6 62 5 ACEVEDO AVE 2 7 1 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
103750 114102 6 62 7 ACEVEDO AVE 1 7 1 1     18     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
113595 114068 6 62 8 HIGUERA AVE 1 7 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
88441 114094 6 55 239x VIDAL DR 1 7 1 1     24     5987668.0 2090475.0 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602)
83253 98082 6 105 525 Grafton Ave 1 5 1 1           5995193.7 2090526.9 37.7199132334677 -122.45865940878001 (37.7199132334677, -122.45865940878)
94574 114097 6 306 221x VIDAL DR 1 7 1 1     14     5987664.0 2090556.0 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519)
96627 104900 6 146 317 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
99835 104913 6 28 608 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
102326 104898 6 1 310 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
118620 104908 6 1 500 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
119511 104899 6 193 314 Gonzalez Dr 2 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
140531 104916 6 3 700 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
142126 104912 6 39 606 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
143237 104888 6 47 146 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
127835 114387 6 16 417x ARBALLO DR 1 2 1 1     7     5988152.0 2090574.0 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928)
80921 104904 6 26 417 Gonzalez Dr 1 7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
124358 104909 6 3 533 Gonzalez Dr 1 7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
104018 104932 6 26 717 Gonzalez Dr 1 7 1 1           5990427.0 2090598.0 37.7198333383806 -122.47514125414499 (37.7198333383806, -122.475141254145)
104403 114100 6 146 21x ACEVEDO AVE 1 7 1 1     10     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
118949 114101 6 146 21x ACEVEDO AVE 2 7 1 1     7     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
142616 104933 6 26 755 Gonzalez Dr 1 7 1 1           5990427.0 2090598.0 37.7198333383806 -122.47514125414499 (37.7198333383806, -122.475141254145)
72156 104935 6 62 835 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
99811 104936 6 62 837 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
109347 104937 6 62 839 Gonzalez Dr 2 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
114209 104934 6 62 805 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
82402 114388 6 16 361x ARBALLO DR 1 7 1 1     7     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
99779 114394 6 253 134x TAPIA DR 1 7 1 1     28     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
110346 114383 6 82 418X SERRANO DR 1 2 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
138436 114384 6 82 418X SERRANO DR 2 7 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5144 253807 6 25 2 Garfield St 1 17 1 1       10x2   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
124990 107541 6 3 2 GARFIELD ST 4 13 1 1     36     5993976.6 2090624.3 37.7201106425596 -122.46287353180901 (37.7201106425596, -122.462873531809)
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
125203 114389 6 15 345x ARBALLO DR 1 7 1 1     8     5988176.0 2090635.0 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
98711 105649 6 47 3 Gonzalez Dr 1 7 1 1           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469)
115524 117309 6 17 3711 19th Ave 1 13 1 1   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777997 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
93217 114390 6 82 23x PINTO AVE 1 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
144388 114393 6 253 118x TAPIA DR 1 7 1 1     36     5988638.0 2090878.0 37.72049829773871 -122.48134562114099 (37.7204982977387, -122.481345621141)
81688 93931 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
99064 93932 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
84041 114392 6 15 104x TAPIA DR 1 8 1 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
53190 94850 6 17 1107 Bowdoin St 1 7 1 1   11/17/2010 12:00:00 AM     Permit Number 53929 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
98300 94851 6 5 1107 Bowdoin St 2 7 1 1   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
44089 109772 6 211 2200x SAN JOSE AVE 11 1 1 1     30 3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
121702 95777 6 518 30 Onondaga Ave   7 1 1   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.721861535681704 -122.437972107548 (37.7218615356817, -122.437972107548)
111731 122636 6 19 3698X 19th Ave 1 5 1 1       3x3   5990586.0 2091171.0 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984)
89464 100191 6 3 1201 Holloway Ave 1 7 1 1           5992431.5 2091178.1 37.721542125529396 -122.46825464021099 (37.7215421255294, -122.468254640211)
88445 122634 6 17 3680X 19th Ave 1 5 1 1   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592.0 2091224.0 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991)
139196 72854 6 39 24 Lunado Way 4 1 1 1   09/26/1998 12:00:00 AM       5991516.52955398 2091408.89207172 37.722122935753106 -122.47143422303499 (37.7221229357531, -122.471434223035)
Powered by Datasette · Query took 11.841ms · Data source: data.sfgov.org