sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
1685 251478 1 15 2x Virginia Ave 2 1 1 1 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
1968 251132 1 26 354 05th St 2 1 1 1 4 02/11/2006 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
4588 200921 1 79 4040 03rd St 1 1 1 1 4 01/18/2008 12:00:00 AM 5 Width 0ft   6015547.5959 2097647.2059 37.7406129979736 -122.388799250904 (37.7406129979736, -122.388799250904)
5209 169218 1 29 824 Ellis St 1 1 1 1 4   0 3x3   6006905.3054599995 2113639.6299099997 37.7840416758297 -122.419815533287 (37.7840416758297, -122.419815533287)
5210 83637 1 17 840 Ellis St 1 1 1 1 4 11/19/2005 12:00:00 AM   3x3   6006834.966315799 2113631.30048912 37.784014842491395 -122.420058290383 (37.7840148424914, -122.420058290383)
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5217 169168 1 29 701 Polk St 2 1 1 1 4   0 3x3   6007051.56678 2113380.55802 37.7833385660552 -122.41929113679599 (37.7833385660552, -122.419291136796)
5218 169214 1 29 724 Ellis St 1 1 1 1 4   0 Width 4ft   6007369.544319999 2113705.88387 37.7842497348906 -122.41821413029301 (37.7842497348906, -122.418214130293)
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5223 74484 1 17 749 Polk St 4 1 1 1 4 06/29/2016 12:00:00 AM 3 3x3 Permit Number 778449 6007035.08305 2113498.23336 37.783660745502296 -122.41935651480301 (37.7836607455023, -122.419356514803)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5227 169217 1 29 800 Ellis St 1 1 1 1 4   0 3x3   6006932.37231 2113646.73425 37.7840627073778 -122.41972239586501 (37.7840627073778, -122.419722395865)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5234 169170 1 29 750 Eddy St 1 1 1 1 4   0 3x3   6006877.9642199995 2113290.02776 37.7830802133315 -122.419885308057 (37.7830802133315, -122.419885308057)
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
5238 169219 1 29 840 Polk St 1 1 1 1 4   0 3x3   6006827.36035 2113629.7400599997 37.7840101293977 -122.42008449353001 (37.7840101293977, -122.42008449353)
5239 253830 1 54 651X Polk St 3 1 1 1 4     3x3            
7506 14836 1 21 1300 McAllister St 1 1 1 1 4 10/22/2008 12:00:00 AM 9 3X3   6002892.8097 2111692.1261 37.7784674596438 -122.43355807318501 (37.7784674596438, -122.433558073185)
22149 16024 1 11 130 Monterey Blvd 1 1 1 1 4 12/29/2015 12:00:00 AM 3 3X3 Permit Number 776129 6001188.36813 2094689.80455 37.731686341545206 -122.43823603107799 (37.7316863415452, -122.438236031078)
26614 98657 1 55 2110 Greenwich St 11 1 1 4 4   11 5x5   6002607.56666 2119218.5959900003 37.7991170337862 -122.43508328318701 (37.7991170337862, -122.435083283187)
31571 98656 1 55 2110 Greenwich St 10 1 1 4 4   8 5x5   6002629.88193 2119221.45898 37.799126161900396 -122.435006269744 (37.7991261619004, -122.435006269744)
33915 98646 1 55 2110 Greenwich St 3 1 1 4 4   8 5x5   6002771.23879 2119243.65965 37.799195144410795 -122.43451871576099 (37.7991951444108, -122.434518715761)
44207 98648 1 55 2110 Greenwich St 5 1 1 4 4   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245)
52422 34688 1 55 3101X Webster St 2 1 1 4 4 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533)
53064 98650 1 55 2110 Greenwich St 7 1 1 4 4   11 5x5   6002693.158 2119231.9709099997 37.799158617543604 -122.43478806542801 (37.7991586175436, -122.434788065428)
61243 34693 1 55 3101X Webster St 1 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.43438045581301 (37.799535058456, -122.434380455813)
62828 5490 1 150 714 Dolores St 1 1 1 1 4 12/28/2015 12:00:00 AM 1 4X4 Permit Number 774286 6004953.58017 2104162.27117 37.757908995925206 -122.425892952911 (37.7579089959252, -122.425892952911)
69128 98649 1 55 2110 Greenwich St 6 1 1 4 4   16 5x5   6002707.76445 2119233.0203 37.799162328147794 -122.434737597267 (37.7991623281478, -122.434737597267)
69366 93014 1 79 2395 Lombard St 4 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001021.4146 2119265.9756 37.7991569323377 -122.440575294128 (37.7991569323377, -122.440575294128)
71504 98651 1 32 2110 Greenwich St 8 1 1 4 4   23 5x5   6002674.17203 2119228.66956 37.799148474973705 -122.434853527066 (37.7991484749737, -122.434853527066)
73429 34690 1 55 3101X Webster St 4 1 1 4 4 07/28/1997 12:00:00 AM 8 3x3 Permit Number 38352 6002819.05677 2119313.26082 37.7993889653989 -122.434358228162 (37.7993889653989, -122.434358228162)
74427 67860 1 55 2110 Greenwich St 1 1 1 4 4 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.43439798360501 (37.7992088356751, -122.434397983605)
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)
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)
85658 96467 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
89325 96464 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
89333 104727 1 90 1079 Church St 1 1 1 1 4     3x3 Permit Number 770313 6004450.0 2102615.0 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639)
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)
94772 98675 1 17 199X Park St 1 1 1 4 4         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)
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)
96184 102636 1 26 2176 Mission St 2 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
101889 95411 1 20 2815 Diamond St 1 1 1 1 4   1 3x3 Planted by Glen Park Library; will become DPW maintained. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
103701 96466 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
105652 98659 1 43 2110 Greenwich St 13 1 1 4 4   20 7x7   6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
109180 102635 1 26 2176 Mission St 1 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
109229 93013 1 11 2395 Lombard St 1 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6000915.0 2119261.0 37.7991372104515 -122.440943166878 (37.7991372104515, -122.440943166878)
110539 14250 1 15 2001 Market St 6 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
113603 104154 1 54 525X Church St 2 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
115707 96469 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
119702 111096 1 52 67 SAINT CHARLES AVE 31 1 1 10 4   15     5992079.0 2088073.0 37.712995910736204 -122.46924723728901 (37.7129959107362, -122.469247237289)
120383 95412 1 20 2815 Diamond St 3 1 1 1 4   1 3x3 Planted by Glen Park Public Library; will become DPW maintained after it is established. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
120725 96465 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
124890 96470 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
127181 103126 1 17 1020 Guerrero St 2 1 1 1 4 03/22/2013 12:00:00 AM   3x3 Permit Number 769235 6005624.5 2103007.3 37.7547756072831 -122.423490517587 (37.7547756072831, -122.423490517587)
131687 98655 1 55 2110 Greenwich St 9 1 1 4 4   6 5x5   6002650.75991 2119226.56813 37.799141375727295 -122.434934390513 (37.7991413757273, -122.434934390513)
133902 34692 1 55 3101X Webster St 6 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002825.2019 2119271.55666 37.7992748054477 -122.434333980647 (37.7992748054477, -122.434333980647)
140589 14248 1 15 2001 Market St 4 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
141475 104153 1 54 525X Church St 1 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
144888 96468 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
153048 98645 1 55 2110 Greenwich St 2 1 1 4 4   9 5x5   6002788.88101 2119245.38589 37.799200885676605 -122.434457791187 (37.7992008856766, -122.434457791187)
161870 98647 1 55 2110 Greenwich St 4 1 1 4 4   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619)
166994 34691 1 55 3101X Webster St 5 1 1 4 4 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.43435014504699 (37.7993346796145, -122.434350145047)
171968 93015 1 79 2395 Lombard St 5 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001036.8533 2119267.6007 37.7991622735558 -122.440521987709 (37.7991622735558, -122.440521987709)
176592 34689 1 55 3101X Webster St 3 1 1 4 4 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.79943447017929 -122.434367321195 (37.7994344701793, -122.434367321195)
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
4475 253631 2 49 39 Mason St 1 1 1 1 4         6009957.290080001 2113442.89538 37.783672949399204 -122.409242840109 (37.7836729493992, -122.409242840109)
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
58682 116625 2 41 5732X GEARY BLVD 6 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
63146 75990 2 273 350 Broadway 1 1 1 4 4 10/07/1995 12:00:00 AM 3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.40285383475599 (37.7984395708796, -122.402853834756)
77610 109992 2 55 501X Shotwell St 9 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
77875 106884 2 53 180X SAN MARCOS AVE 6 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
83876 109990 2 26 501X Shotwell St 7 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
84743 116631 2 41 5732X GEARY BLVD 12 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
85949 109996 2 55 501X Shotwell St 13 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
87276 112509 2 11 699x WILLOW ST 1 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
89691 109988 2 26 501X Shotwell St 5 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
90177 109991 2 297 501X Shotwell St 8 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
92640 109986 2 26 501X Shotwell St 3 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93134 98908 2 26 501X Shotwell St 2 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93703 97898 2 49 375X Precita Ave 4 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
94993 112510 2 11 699x WILLOW ST 2 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
95046 109987 2 26 501X Shotwell St 4 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
96632 116628 2 41 5732X GEARY BLVD 9 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
96961 97902 2 62 375X Precita Ave 8 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
97325 97901 2 62 375X Precita Ave 7 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
98455 97903 2 2 375X Precita Ave 9 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
Powered by Datasette · Query took 3.795ms · Data source: data.sfgov.org