sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4955 253734 3 15 350 Girard St 12 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4956 253729 3 15 350 Girard St 7 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4965 253732 3 15 350 Girard St 10 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4968 253724 3 15 350 Girard St 2 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4982 253733 3 15 350 Girard St 11 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4986 253726 3 15 350 Girard St 4 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4993 253727 3 15 350 Girard St 5 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5004 253731 3 15 350 Girard St 1 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5021 253725 3 15 350 Girard St 3 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5028 253730 3 15 350 Girard St 8 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5029 251680 3 15 350 Girard St 9 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5037 253728 3 15 350 Girard St 6 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
9734 173682 3 103 450x Raymond Ave 1 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
9739 173683 3 103 450x Raymond Ave 2 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
10038 96503 3 150 2360X Harrison St 4 1 1 4 4     3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
10264 92961 3 17 2051 34th Ave 1 1 1 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369005 -122.49227087024799 (37.748848003369, -122.492270870248)
10265 92962 3 17 2051 34th Ave 2 1 1 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369005 -122.49227087024799 (37.748848003369, -122.492270870248)
10282 173941 2 36 3750 18th St 4 1 1 4       3x3   6004590.0 2105440.0 37.7613967828987 -122.42724138037701 (37.7613967828987, -122.427241380377)
17867 98680 1 55 199X Park St 6 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
19132 96505 3 150 2360X Harrison St 7 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
19735 96580 3 131 401x Otsego Ave 5 1 1 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
42976 113471 2 59 450 CHURCH ST 28 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
44829 94949 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
50161 96500 3 150 2360X Harrison St 1 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
63419 106952 2 17 399X SOMERSET ST 1 1 1 4       3x3   6009953.0 2092875.0 37.7271978698015 -122.40780687976499 (37.7271978698015, -122.407806879765)
77523 96504 3 150 2360X Harrison St 5 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
77569 98569 3 5 301X Francisco St 7 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
78003 107872 3 15 830X Harrison St 5 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
78764 111862 3 82 201x LOBOS ST 4 1 1 4       3x3   5994528.0 2088713.0 37.714894412350205 -122.460829096166 (37.7148944123502, -122.460829096166)
79453 107874 3 15 830X Harrison St 7 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
79535 96590 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
79769 113436 3 55 198x HIGHLAND AVE 3 1 1 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
80122 98749 2 26 540X Eureka St 6 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
80335 98579 3 26 301X Francisco St 17 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
80997 113469 2 59 450 CHURCH ST 26 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
81160 96570 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81163 104152 1 54 525X Church St 2 5 2 4 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81171 96512 3 150 2360X Harrison St 14 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
81219 117257 3 15 1570 31ST AVE 5 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
81703 96593 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
81722 104155 1 54 525X Church St 3 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81972 98746 2 26 540X Eureka St 3 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
82707 96509 3 150 2360X Harrison St 11 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
82834 107870 3 15 830X Harrison St 3 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
82915 95268 3 43 2245 Jones St 7 1 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
84977 98681 1 55 199X Park St 7 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
85224 112022 3 25 2101x 22nd Ave 2 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
85657 96591 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
85887 117255 3 53 1570 31ST AVE 3 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
86907 96483 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
86964 113437 3 55 198x HIGHLAND AVE 4 1 1 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
87131 113474 2 59 450 CHURCH ST 31 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
88001 96511 3 150 2360X Harrison St 13 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
88558 112026 3 25 2101x 22nd Ave 6 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
88644 111861 3 82 201x LOBOS ST 3 1 1 4       3x3   5994528.0 2088713.0 37.714894412350205 -122.460829096166 (37.7148944123502, -122.460829096166)
88992 98678 1 55 199X Park St 4 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89462 113039 3 17 242X 07TH AVE 4 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
89475 112027 3 25 2101x 22nd Ave 7 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
89526 107869 3 15 830X Harrison St 2 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
89609 79386 1 11 2355 Folsom St 16 1 1 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008491.21757684 2104497.38565881 37.7590284322587 -122.4136819767 (37.7590284322587, -122.4136819767)
89957 113573 2 43 901 LOMBARD ST 4 1 1 4 2     3x3   6007813.0 2120272.0 37.802303618634795 -122.417145352251 (37.8023036186348, -122.417145352251)
90481 113037 3 17 242X 07TH AVE 2 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
90667 94951 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
90673 98752 2 26 540X Eureka St 9 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
91198 107871 3 15 830X Harrison St 4 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
91915 113040 3 17 242X 07TH AVE 5 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
92018 110190 3 55 625 Holly Park Cir 6 1 1 4           6006167.62160945 2096413.49051844 37.736701142359294 -122.421144072665 (37.7367011423593, -122.421144072665)
92105 98750 2 26 540X Eureka St 7 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
92153 107873 3 15 830X Harrison St 6 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
92501 97725 3 94 1000X Bay St 4 5 1 4 2     7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
92566 113466 2 59 450 CHURCH ST 2 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
92729 98679 1 55 199X Park St 5 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
93011 113435 3 55 198x HIGHLAND AVE 2 1 1 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
93270 98756 2 26 540X Eureka St 13 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
93623 94948 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
94043 98566 3 26 301X Francisco St 4 1 1 4 2 05/04/2013 12:00:00 AM   3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
94173 117256 3 53 1570 31ST AVE 4 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
94595 98794 3 21 950@Washington Clay St 6 1 1 4 2     3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
94912 98754 2 26 540X Eureka St 11 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
95375 98676 1 55 199X Park St 2 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
95495 104151 1 54 525X Church St 1 5 2 4 4     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95556 104158 1 54 525X Church St 6 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95832 98577 3 94 301X Francisco St 15 1 1 4 2     6x7   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
96050 113472 2 59 450 CHURCH ST 29 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
96077 104157 1 54 525X Church St 5 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
96688 96513 3 150 2360X Harrison St 15 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
97136 96502 3 150 2360X Harrison St 3 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
97255 110187 3 55 625 Holly Park Cir 3 1 1 4           6006167.62160945 2096413.49051844 37.736701142359294 -122.421144072665 (37.7367011423593, -122.421144072665)
97416 96594 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
97683 98677 1 55 199X Park St 3 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
97749 96481 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
Powered by Datasette · Query took 12.043ms · Data source: data.sfgov.org