sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
104 251210 3 39 1170 Ingalls St 2 1 1 2   11/02/1992 12:00:00 AM                
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
1567 251594 2 39 3698 19th St 2 1 1 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1574 251596 2 39 3698 19th St 4 1 1 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1583 251593 2 39 3698 19th St 1 1 1 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1592 251595 2 39 3698 19th St 3 1 1 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1985 252841 1 39 1763 Golden Gate Ave   1 1 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
4668 253644 3 39 1200x La Salle Ave 12 1 1 2 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4669 253646 3 39 1200x La Salle Ave 22 1 1 2 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 3 39 1200x La Salle Ave 17 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4764 253679 2 39 94 Teresita Blvd 1 9 1 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
9972 173766 2 39 1100x Bacon St 2 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9974 173765 2 39 1100x Bacon St 1 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9975 173768 2 39 1100x Bacon St 4 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9976 173769 2 39 1100x Bacon St 5 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9978 173767 2 39 1100x Bacon St 3 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
13240 187608 2 39 101 Northridge Rd 3 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13250 187606 2 39 101 Northridge Rd 1 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13251 187611 2 39 100 Northridge Rd 3 1 1 2       3x3   6018548.0 2094208.0 37.7313354560629 -122.37818620453699 (37.7313354560629, -122.378186204537)
13256 187607 2 39 101 Northridge Rd 2 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13296 187658 7 39 600X Clarendon Ave 1 7 1 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
19560 103375 2 39 22 VANDEWATER ST   1 1 1       2.5x2.5 Permit Number 770057 6009069.0 2121391.0 37.8054466905223 -122.41287812458401 (37.8054466905223, -122.412878124584)
30141 42966 1 39 160 Belgrave Ave 1 1 1 1   07/13/2000 12:00:00 AM     Permit Number 42854 5997814.60948514 2104925.35351079 37.75959819679839 -122.45063741216002 (37.7595981967984, -122.45063741216)
77352 36702 1 39 3698x 19th St 4 1 1 1 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005001.97582164 2104885.80884876 37.759898394802605 -122.42577707942199 (37.7598983948026, -122.425777079422)
78184 42222 1 39 661 Howard St 8 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
78814 42223 1 39 661 Howard St 2 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
79414 55370 1 39 177 San Aleso Ave 1 1 1 1   07/11/2011 12:00:00 AM   2x3 Permit Number 767959 5993373.59500695 2094436.22943113 37.7305425193622 -122.465234638195 (37.7305425193622, -122.465234638195)
79810 68817 1 39 125 Congo St 1 1 1 1 1 06/19/2007 12:00:00 AM     Permit Number 49379 6000058.92001633 2094143.32486819 37.730121532663105 -122.442101535638 (37.7301215326631, -122.442101535638)
80578 36705 1 39 3690x 19TH ST 3 1 1 1 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
81348 113709 2 39 2801x CLEMENT ST 5 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
81989 39617 1 39 143 Parnassus Ave 2 1 1 1   12/29/1998 12:00:00 AM     Permit Number 41017 5997752.15145133 2106762.51515119 37.7646390036764 -122.45098590004999 (37.7646390036764, -122.45098590005)
82285 50882 1 39 2055 15th Ave 1 1 1 1 1 04/26/2004 12:00:00 AM     Permit Number 47392 5991593.93786831 2101441.81632133 37.7496752859252 -122.471897503797 (37.7496752859252, -122.471897503797)
82947 46916 1 39 161 Newman St 1 1 1 1 1 01/04/2013 12:00:00 AM     Permit Number 769519 6007338.4828929 2096787.18196624 37.7377931534639 -122.41712235805201 (37.7377931534639, -122.417122358052)
84481 113708 2 39 2801x CLEMENT ST 4 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
84579 49746 1 39 40@ LELAND Britton St 1 1 1 1 1 06/04/2003 12:00:00 AM     Permit Number 46545 6008551.24165341 2087877.47374564 37.7133971377495 -122.412299691068 (37.7133971377495, -122.412299691068)
84687 41668 1 39 500 Corbett Ave 5 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42131 5999528.76445246 2104225.15584588 37.7577735947767 -122.44465870166599 (37.7577735947767, -122.444658701666)
85345 36703 1 39 3690x 19TH ST 1 1 1 1 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
86261 42484 1 39 50 Phelan Ave 2 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42614 5997088.18001 2092254.3140099999 37.7247650096883 -122.452235460018 (37.7247650096883, -122.452235460018)
87641 87256 1 39 2 Garrison Ave 3 1 1 1       3x3 Permit Number 50279 6008242.3 2086782.6 37.710373499787394 -122.413290127101 (37.7103734997874, -122.413290127101)
87916 98953 6 39 302 Ivy St 19 7 1 1           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433)
87952 111303 1 39 3690x 19TH ST 4 1 1 1 1         6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
89160 73475 1 39 340 Ritch St 1 1 1 1   03/04/2008 12:00:00 AM   3x3 Permit Number 50288 6014252.15043428 2111690.62627274 37.7791012985319 -122.394261419296 (37.7791012985319, -122.394261419296)
89550 52895 1 39 1642 12th Ave 2 1 1 1   07/10/2006 12:00:00 AM   3x3 Permit Number 48894 5992495.5632863 2104272.70590883 37.757500303864 -122.468985668503 (37.757500303864, -122.468985668503)
90863 43515 1 39 165 Newman St 1 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43192 6007354.1406378 2096784.95342482 37.7377879152119 -122.41706806363999 (37.7377879152119, -122.41706806364)
90990 84960 1 39 2616 24th Ave 1 1 1 1   06/12/2007 12:00:00 AM     Permit Number 49352 5988993.8 2097500.0 37.7387012975774 -122.48060025376301 (37.7387012975774, -122.480600253763)
91233 44205 1 39 341 Moultrie St 1 1 1 1 1 11/25/1986 12:00:00 AM     Permit Number 43653 6007751.99799899 2097517.30165944 37.739821155436 -122.415744314793 (37.739821155436, -122.415744314793)
92147 42218 1 39 661 Howard St 7 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
92358 42224 1 39 661 Howard St 1 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
92407 37521 1 39 1112 Larkin St 1 1 1 1 1 06/22/1998 12:00:00 AM   3x3 Permit Number 39974 6007343.449516599 2115114.77721986 37.7881167428842 -122.41840434148199 (37.7881167428842, -122.418404341482)
93393 103615 6 39 200X Buchanan St 5 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
93935 38688 1 39 1763 Golden Gate Ave 1 1 1 1 1 10/07/1998 12:00:00 AM     Permit Number 40601 6001154.46973963 2111747.51694807 37.7785207657155 -122.439575605477 (37.7785207657155, -122.439575605477)
93982 69756 1 39 2 Garrison Ave 1 1 1 1   02/19/2008 12:00:00 AM   3x3 Permit Number 50279 6008252.26832326 2086801.73422247 37.710426598074605 -122.41325702656601 (37.7104265980746, -122.413257026566)
94001 43523 1 39 1442 Grove St 1 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43199 6000900.07851404 2110723.16086375 37.7756936614931 -122.44038215551001 (37.7756936614931, -122.44038215551)
94433 38683 1 39 1785 Fulton St 2 1 1 1   10/05/1998 12:00:00 AM     Permit Number 40599 5999225.65056076 2110784.42467282 37.7757663950795 -122.446178803683 (37.7757663950795, -122.446178803683)
94979 38022 1 39 180 Madrone Ave 2 1 1 1   07/10/1998 12:00:00 AM     Permit Number 40233 5992584.62016279 2098022.80205393 37.740344819144795 -122.468223027257 (37.7403448191448, -122.468223027257)
95191 39732 1 39 3698 17th St 1 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41104 6004245.08369654 2106017.71232833 37.7629635309961 -122.428475481414 (37.7629635309961, -122.428475481414)
95272 101396 3 39 305X Hickory St 5 7 1 2           6005503.9 2110451.5 37.775208804322 -122.42443704976002 (37.775208804322, -122.42443704976)
95502 106502 1 39 420X Shrader St 4 1 1 1           5997462.73555 2109001.92463 37.770771276139705 -122.452148498658 (37.7707712761397, -122.452148498658)
95530 42477 1 39 50 Phelan Ave 8 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42614 5997094.69001 2092414.90401 37.7252063248445 -122.45222453793501 (37.7252063248445, -122.452224537935)
96781 42220 1 39 661 Howard St 4 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
97152 39662 1 39 340 Grafton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41053 5995802.87923545 2090583.42381532 37.7201034282275 -122.45655778592199 (37.7201034282275, -122.456557785922)
97389 38684 1 39 1785 Fulton St 3 1 1 1   10/05/1998 12:00:00 AM     Permit Number 40599 5999225.65056076 2110784.42467282 37.7757663950795 -122.446178803683 (37.7757663950795, -122.446178803683)
97455 98954 6 39 302 Ivy St 20 7 1 1           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433)
98015 38023 1 39 180 Madrone Ave 1 1 1 1 1 07/10/1998 12:00:00 AM     Permit Number 40233 5992584.62016279 2098022.80205393 37.740344819144795 -122.468223027257 (37.7403448191448, -122.468223027257)
98079 104865 6 39 80 Stoneman St 1 7 1 1         Permit Number 770375 6007947.7 2099422.0 37.7450620347132 -122.415202450973 (37.7450620347132, -122.415202450973)
98884 114475 2 39 1254 MONTGOMERY ST 2 1 1 1       3x3   6011527.0 2119680.0 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897)
99031 32507 1 39 100x OGDEN AVE 3 1 1 1 1 10/15/1996 12:00:00 AM     Permit Number 37009 6007659.0 2096105.0 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682)
99641 48625 1 39 1548 12th Ave 1 1 1 1 1 08/30/2002 12:00:00 AM     Permit Number 45922 5992473.51988967 2104913.75628044 37.7592591867123 -122.46910855694901 (37.7592591867123, -122.469108556949)
100567 103612 6 39 200X Buchanan St 2 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
100770 35831 1 39 800 Edinburg St 2 1 1 1 1 04/23/1998 12:00:00 AM     Permit Number 39062 6001828.61140297 2089175.38471651 37.7165813830219 -122.435628217621 (37.7165813830219, -122.435628217621)
101395 46613 1 39 394 Fair Oaks St 4 1 1 1 1 04/12/2002 12:00:00 AM     Permit Number 44735. Tree 4 on 25th St. 6005464.68638444 2101420.18882448 37.750408745884 -122.423930345056 (37.750408745884, -122.423930345056)
101434 43022 1 39 71 Waller St 1 1 1 1 1 07/05/2000 12:00:00 AM     Permit Number 42883 6005491.3790617995 2109225.31619528 37.7718412930396 -122.424393129042 (37.7718412930396, -122.424393129042)
102286 113325 1 39 1234 10th Ave 3 1 1 1 1     3x3   5993019.12807809 2107069.22790191 37.76520905664 -122.467378332531 (37.76520905664, -122.467378332531)
102771 38682 1 39 1785 Fulton St 1 1 1 1 1 01/19/2000 12:00:00 AM     Permit Number 41971 5999225.65056076 2110784.42467282 37.7757663950795 -122.446178803683 (37.7757663950795, -122.446178803683)
103843 43507 1 39 161 Newman St 2 1 1 1   01/04/2013 12:00:00 AM     Permit Number 769519 6007338.4828929 2096787.18196624 37.7377931534639 -122.41712235805201 (37.7377931534639, -122.417122358052)
105824 97405 1 39 2@Melrose Stanford Heights Ave 2 2 1 1           5997807.0 2095590.8 37.7339673631019 -122.449990957178 (37.7339673631019, -122.449990957178)
105957 42221 1 39 661 Howard St 3 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
108241 87255 1 39 2 Garrison Ave 2 1 1 1   02/19/2008 12:00:00 AM   3x3 Permit Number 50279 6008242.3 2086782.6 37.710373499787394 -122.413290127101 (37.7103734997874, -122.413290127101)
108488 105973 1 39 1336 Greenwich St 1 1 1 1         Permit Number 771235 6006462.9 2119771.0 37.8008519560253 -122.421781757787 (37.8008519560253, -122.421781757787)
108551 43516 1 39 165 Newman St 2 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43192 6007354.1406378 2096784.95342482 37.7377879152119 -122.41706806363999 (37.7377879152119, -122.41706806364)
109004 42219 1 39 661 Howard St 5 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
109085 39733 1 39 3698 17th St 3 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41104 6004245.08369654 2106017.71232833 37.7629635309961 -122.428475481414 (37.7629635309961, -122.428475481414)
110154 92101 1 39 1076 Guerrero St 1 1 1 1   06/25/2009 12:00:00 AM   3x3 Permit Number 52984 6005698.0 2102695.0 37.7539222521842 -122.42321413605801 (37.7539222521842, -122.423214136058)
110365 46585 1 39 496 Fair Oaks St 1 1 1 1 1 04/05/2002 12:00:00 AM     Permit Number 44714 6005497.60346294 2100827.74105942 37.748783878914296 -122.423774394842 (37.7487838789143, -122.423774394842)
110912 35830 1 39 800 Edinburg St 1 1 1 1 1 04/23/1998 12:00:00 AM     Permit Number 39062 6001828.61140297 2089175.38471651 37.7165813830219 -122.435628217621 (37.7165813830219, -122.435628217621)
111119 42127 1 39 57 Staples Ave 1 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42423 5999631.06894657 2093753.11151717 37.729025705554704 -122.44355264659401 (37.7290257055547, -122.443552646594)
111553 113706 2 39 2801x CLEMENT ST 2 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
111572 39734 1 39 3698 17th St 2 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41104 6004245.08369654 2106017.71232833 37.7629635309961 -122.428475481414 (37.7629635309961, -122.428475481414)
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)
112553 39757 1 39 513 Liberty St 1 1 1 1 1 01/06/1999 12:00:00 AM     Permit Number 41124 6002972.50040311 2103846.50934997 37.7569298331089 -122.43272179816601 (37.7569298331089, -122.432721798166)
112971 52587 1 39 690@ CABRILLO 22nd Ave 1 1 1 1   01/27/2006 12:00:00 AM     Permit Number 48680 5989145.55322023 2110639.08863484 37.774786529724494 -122.48103735116399 (37.7747865297245, -122.481037351164)
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)
114318 103614 6 39 200X Buchanan St 4 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
115512 41136 1 39 1890 Page St 1 1 1 1 1 11/18/1999 12:00:00 AM     Permit Number 41875 5997533.67783563 2108867.16274176 37.7704053182028 -122.451893385496 (37.7704053182028, -122.451893385496)
115629 113707 2 39 2801x CLEMENT ST 3 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
115777 36704 1 39 3690x 19TH ST 2 1 1 1 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
116217 101395 3 39 305X Hickory St 4 7 1 2           6005503.9 2110451.5 37.775208804322 -122.42443704976002 (37.775208804322, -122.42443704976)
117157 42476 1 39 50 Phelan Ave 7 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42614 5997093.60501 2092371.5010099998 37.725087088302104 -122.452225158319 (37.7250870883021, -122.452225158319)
118408 43517 1 39 165 Newman St 3 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43192 6007354.1406378 2096784.95342482 37.7377879152119 -122.41706806363999 (37.7377879152119, -122.41706806364)
118530 104452 6 39 1045 Mission St 1 5 1 1       2x6 Permit Number 770594 6009749.9 2112056.4 37.7798543407434 -122.40986242910299 (37.7798543407434, -122.409862429103)
119378 42217 1 39 661 Howard St 6 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
Powered by Datasette · Query took 6.166ms · Data source: data.sfgov.org