sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9986 1263 6 3 3995X Alemany Blvd 3 5 1 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10627 1283 6 44 3995X Alemany Blvd 1 5 1 1     10 10x10   5992081.50866 2087171.0422099999 37.710519496741206 -122.469172961285 (37.7105194967412, -122.469172961285)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
140157 6099 6 40 500X 08th St 1 5 1 1     18 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
119427 12711 6 17 1449 Lake St 3 8 1 2   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046)
2572 24480 6 182 108X Sussex St 2 1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780363 6002195.08262 2096706.93645 37.737282128351005 -122.434899824187 (37.737282128351, -122.434899824187)
119181 33327 6 61 1629 Green St 2 1 1 1   07/13/2010 12:00:00 AM   3x3 Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued 6005242.65792202 2118493.60609418 37.7972756709044 -122.425913331435 (37.7972756709044, -122.425913331435)
82032 39247 6 96 3524 Jackson St 1 8 1 1   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.790205252620794 -122.452921449726 (37.7902052526208, -122.452921449726)
18402 48402 6 18 706 Wisconsin St 1 9 1 1   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868)
103692 57910 6 17 446 Valley St 1 1 1 1   06/10/1977 12:00:00 AM     Permit Number 16868 6003019.35193275 2099229.53580249 37.7442553690473 -122.432230049776 (37.7442553690473, -122.432230049776)
101276 62912 6 502 500 Cortland Ave 1 13 1 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007523.90359428 2097218.90762974 37.7389890062486 -122.416511839888 (37.7389890062486, -122.416511839888)
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)
81071 78107 6 129 970 GUERRERO ST 1 7 1 1     15     6005649.9 2103318.5 37.755631523761394 -122.42342479955799 (37.7556315237614, -122.423424799558)
119438 78519 6 17 12 Sumner St 1 7 1 1     15 3x3   6009421.0 2110873.0 37.776586565695894 -122.41091663866501 (37.7765865656959, -122.410916638665)
10790 80073 6 35 2788 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3     5985889.2586 2096432.3825 37.735588983385 -122.49125558617901 (37.735588983385, -122.491255586179)
164545 82366 6 31 51 Princeton St 3 1 1 1 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
18877 82435 6 3 51 Peralta Ave 1 7 1 1   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802)
84800 84935 6 11 145 Guerrero St 1 7 1 1   06/06/2007 12:00:00 AM     Permit Number 49347 6005480.0 2108218.0 37.769074802262395 -122.42436083172 (37.7690748022624, -122.42436083172)
142739 84936 6 11 145 Guerrero St 1 7 1 1           6005480.0 2108218.0 37.769074802262395 -122.42436083172 (37.7690748022624, -122.42436083172)
140164 84937 6 17 145 Guerrero St 1 7 1 1         Permit Number 770120 6005480.0 2108218.0 37.769074802262395 -122.42436083172 (37.7690748022624, -122.42436083172)
46601 84938 6 40 145 Guerrero St 1 7 1 1         Permit Number 49347 6005480.0 2108218.0 37.769074802262395 -122.42436083172 (37.7690748022624, -122.42436083172)
9148 85030 6 17 411 Panama St 1 1 1 1   06/26/2007 12:00:00 AM     Permit Number 49384          
115908 85032 6 3 411 Panorama Dr 1 1 1 1           5997300.0 2101977.0 37.7514732863106 -122.452204440653 (37.7514732863106, -122.452204440653)
125647 85060 6 47 7070 California St 1 8 1 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
96134 85085 6 82 1600 Chestnut St 1 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
80993 85086 6 82 1600 Chestnut St 2 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
105009 85087 6 82 1600 Chestnut St 3 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
146084 85088 6 82 1600 Chestnut St 1 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
125168 85089 6 82 1600 Chestnut St 2 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
102660 85090 6 82 1600 Chestnut St 3 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
86608 85093 6 17 100 32nd Ave 2 7 1 1   12/18/2009 12:00:00 AM     Permit Number 53112 5985781.7 2114962.8 37.786462080845396 -122.49299200677 (37.7864620808454, -122.49299200677)
49233 85313 6 43 610 Brannan St 1 12 1 1         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.39955535858401 (37.7766267904106, -122.399555358584)
119856 85365 6 1 66 Clarendon Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.758871479144396 -122.45053809231199 (37.7588714791444, -122.450538092312)
119287 85367 6 18 1990 09th Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.46526605884199 (37.7513105791605, -122.465266058842)
97229 85428 6 17 43 Ora Way 1 8 1 1   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.741605021987205 -122.437232403771 (37.7416050219872, -122.437232403771)
106619 86895 6 17 321 Haight St   7 1 1   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784)
84949 86910 6 163 1 Urbano Dr 1 1 1 1       3x3 Permit Number 49875 5993901.0 2092133.0 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267)
125077 87149 6 116 4 Bellair Pl 2 13 1 1           6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
86911 87150 6 116 4 Bellair Pl 2 13 1 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
126839 87156 6 55 237 Rivoli St 1 7 1 1         Permit Number 50138 5997662.0 2105892.0 37.762243628012705 -122.451234923187 (37.7622436280127, -122.451234923187)
88091 87157 6 55 237 Rivoli St 2 7 1 1         Permit Number 50138 5997662.0 2105892.0 37.762243628012705 -122.451234923187 (37.7622436280127, -122.451234923187)
103866 87188 6 17 2119 Bush St   7 1 1   01/29/2008 12:00:00 AM     Permit Number 50204 6002998.0 2114831.0 37.787091984974104 -122.433418544226 (37.7870919849741, -122.433418544226)
89763 87191 6 17 640 Miramar Ave 1 7 1 1   01/29/2008 12:00:00 AM     Permit Number 50212 5995439.0 2093622.0 37.7284257331327 -122.458035371987 (37.7284257331327, -122.458035371987)
83923 87197 6 129 617 Sanchez St 1 7 1 1         Permit Number 50213 6003760.0 2104634.0 37.7591367256626 -122.43005450480699 (37.7591367256626, -122.430054504807)
91632 87216 6 502 500 Cortland Ave 2 13 1 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709)
87738 87239 6 17 233 Arbor St 1 9 1 1   02/14/2008 12:00:00 AM     Permit Number 50269 6001330.0 2096776.0 37.737422605415205 -122.43789575270901 (37.7374226054152, -122.437895752709)
87608 87240 6 17 233 Arbor St 2 2 1 1   02/14/2008 12:00:00 AM     Permit Number 50269 6001330.0 2096776.0 37.737422605415205 -122.43789575270901 (37.7374226054152, -122.437895752709)
122346 87242 6 3 4131 Geary Blvd 1 9 1 1         Permit Number 50271 5994116.9 2112250.5 37.779498769084604 -122.46395756623998 (37.7794987690846, -122.46395756624)
128937 88145 6 17 1475 Fillmore St 2 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
122706 88146 6 17 1475 Fillmore St 3 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
108992 88147 6 17 1475 Fillmore St 4 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
131725 88148 6 26 1475 Eddy St 5 1 1 1   07/07/2000 12:00:00 AM 6 3x3 Permit Number 51176 6003399.3649 2112760.0054 37.781428317697795 -122.431881978872 (37.7814283176978, -122.431881978872)
88059 88281 6 16 935 Ulloa St 2 7 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51275 5993125.0 2098282.0 37.7410877064311 -122.466373457073 (37.7410877064311, -122.466373457073)
91613 88453 6 1 2801 Oakdale Ave 2 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
111585 88455 6 1 2801 Oakdale Ave 4 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
98070 88456 6 17 2801 Oakdale Ave 5 1 1 1   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
111690 88457 6 17 2801 Oakdale Ave 6 1 1 1   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
112187 88567 6 17 1335 Webster St 39 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
115344 88568 6 17 1335 Webster St 59 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
81053 88569 6 17 1335 Webster St 60 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
109202 88570 6 17 1335 Webster St 61 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
93053 88571 6 17 1335 Webster St 62 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
104222 88572 6 17 1335 Webster St 66 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
81076 88608 6 17 350 Urbano Dr 1 8 1 1   08/01/2008 12:00:00 AM     Permit Number 51562 5991996.0 2092560.0 37.72531132011171 -122.46986059313801 (37.7253113201117, -122.469860593138)
2184 89309 6 17 32 Lyon St 1 7 1 1   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780094 6000399.0 2109002.0 37.7709392449299 -122.441991937871 (37.7709392449299, -122.441991937871)
2169 89310 6 17 32 Lyon St 2 7 1 1   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780094 6000399.0 2109002.0 37.7709392449299 -122.441991937871 (37.7709392449299, -122.441991937871)
117541 91106 6 17 2650 Turk Blvd 1 7 1 1   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208.0 2110277.0 37.774142880877704 -122.46004000497801 (37.7741428808777, -122.460040004978)
95122 91107 6 17 2650 Turk Blvd 2 7 1 1   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208.0 2110277.0 37.774142880877704 -122.46004000497801 (37.7741428808777, -122.460040004978)
110474 91110 6 3 2650 Turk Blvd 1 7 1 1       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915)
146331 91111 6 3 2650 Turk Blvd 2 7 1 1       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915)
83393 92053 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123251 92054 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
119294 92055 6 180 1001 Potrero Ave   9 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123605 92056 6 180 1001 Potrero Ave   9 1 1   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
83580 92310 6 18 2591 26th Ave 1 5 1 1 1 10/18/2008 12:00:00 AM   3x3   5988279.0 2097698.2 37.7392039339278 -122.48308618722099 (37.7392039339278, -122.483086187221)
108780 92311 6 18 2211 33rd Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
10899 92314 6 35 2783 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509)
10597 92315 6 35 2783 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985839.9086 2096474.3035 37.73570120363421 -122.491429290175 (37.7357012036342, -122.491429290175)
13114 92316 6 35 2787 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511002 (37.7355642757438, -122.49142378511)
12690 92317 6 35 2787 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463)
12500 92318 6 35 2787 34th Ave 3 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988222999 (37.7356241060746, -122.49141988223)
10461 92319 6 35 2788 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)
80217 92320 6 2 2733 Wawona St 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5984522.0 2096783.0 37.736471699686206 -122.49600850837099 (37.7364716996862, -122.496008508371)
103510 92813 6 17 365 Fulton St 2 1 1 2       3x3 Permit Number 53020 6006011.0 2111744.0 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798)
125036 92852 6 316 3794 16th St 1 7 1 1   12/14/2009 12:00:00 AM     Permit Number 53072 6001901.0 2106436.0 37.76397911869721 -122.436612788339 (37.7639791186972, -122.436612788339)
140721 92853 6 246 3794 16th St 2 7 1 1   12/14/2009 12:00:00 AM     Permit Number 53072 6001901.0 2106436.0 37.76397911869721 -122.436612788339 (37.7639791186972, -122.436612788339)
119166 92897 6 103 208 States St 1 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
143929 92898 6 103 208 States St 2 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
105251 92899 6 103 208 States St 3 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
128646 92900 6 103 208 States St 4 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
144783 92909 6 17 100 32nd Ave 1 7 1 1   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.786462080845396 -122.49299200677 (37.7864620808454, -122.49299200677)
121713 92964 6 5 380 Valdez Ave 1 7 1 1     17     5995792.2 2095482.9 37.7335556021648 -122.456948893253 (37.7335556021648, -122.456948893253)
139394 93203 6 47 400 Masonic Ave 2 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
103620 93204 6 47 400 Masonic Ave 1 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
75294 93205 6 47 400 Masonic Ave 3 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
118374 93206 6 47 400 Masonic Ave 4 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
86337 93221 6 17 85 Santa Rita Ave 1 7 1 1   02/26/2010 12:00:00 AM     Permit Number 53213 5993788.0 2100441.0 37.7470540096767 -122.46423776520399 (37.7470540096767, -122.464237765204)
79722 93222 6 17 85 Santa Rita Ave 2 7 1 1   02/26/2010 12:00:00 AM     Permit Number 53213 5993788.0 2100441.0 37.7470540096767 -122.46423776520399 (37.7470540096767, -122.464237765204)
93582 93724 6 62 415 Belvedere St   7 1 1           5998488.0 2106798.0 37.7647785355325 -122.44844336243601 (37.7647785355325, -122.448443362436)
Powered by Datasette · Query took 12.379ms · Data source: data.sfgov.org