sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
187 251248 3 60 829 Chenery St 1 1 1 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
197 251245 3 60 701 Chenery St 1 1 1 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
492 173939 2 60 570 Pennsylvania Ave 1 1 1 1   02/15/2017 12:00:00 AM 3 5xt Permit Number 779890 6014341.0 2104455.0 37.7592388085315 -122.39344754111201 (37.7592388085315, -122.393447541112)
526 18856 3 60 2201 Sacramento St 1 1 1 2     12 3X3   6004191.661859999 2115995.22985 37.790356315029996 -122.429371791378 (37.79035631503, -122.429371791378)
570 22578 1 60 799X Turk St 6 1 1 1     18 4X4   6006396.3025 2112828.5224900004 37.7817858856438 -122.421518877095 (37.7817858856438, -122.421518877095)
598 22577 1 60 799X Turk St 5 1 1 1     18 4X4   6006373.00538 2112825.1930299997 37.7817754301315 -122.421599237822 (37.7817754301315, -122.421599237822)
662 206411 2 60 241 Ortega St 1 1 1 1     14 Width 3ft Permit Number 779935 5993240.35303 2102520.36003 37.752731819221 -122.466282559112 (37.752731819221, -122.466282559112)
718 99173 1 60 2100 Webster St 9 1 1 1     14 3x3 Permit Number 25928 6003311.25259 2116120.54401 37.790650512059 -122.432426898975 (37.790650512059, -122.432426898975)
800 216493 3 60 800x Bosworth St 6 1 1 2     0 Width 3ft   6001711.3067 2095523.18805 37.734004349526 -122.43648775710301 (37.734004349526, -122.436487757103)
804 216488 3 60 800x Bosworth St 1 1 1 2   01/29/1998 12:00:00 AM 0 Width 3ft   6001838.4009 2095488.4107 37.7339160801534 -122.43604586623002 (37.7339160801534, -122.43604586623)
813 251390 3 60 800x Bosworth St 7 1 1 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
817 212190 3 60 720 Bosworth St 4 1 1 2     17 Width 4ft   6002054.13349 2095467.56195 37.733871087977 -122.435298523304 (37.733871087977, -122.435298523304)
819 212192 3 60 720 Bosworth St 6 1 1 2     24 Width 4ft   6002033.39335 2095471.77421 37.733881476032295 -122.43537052934201 (37.7338814760323, -122.435370529342)
829 212194 3 60 720 Bosworth St 8 1 1 2     26 Width 4ft   6002001.778390001 2095479.66425 37.733901344755296 -122.43548039589899 (37.7339013447553, -122.435480395899)
832 212195 3 60 720 Bosworth St 10 1 1 2     17 Width 4ft   6001959.954469999 2095488.58892 37.7339234743781 -122.43562563193899 (37.7339234743781, -122.435625631939)
836 212188 3 60 720 Bosworth St 2 1 1 2     36 Width 4ft   6002077.238580001 2095462.75447 37.7338591998391 -122.435218298393 (37.7338591998391, -122.435218298393)
897 22581 1 60 799X Turk St 10 1 1 1     18 4X4   6006522.42636 2112846.04587 37.7818411112169 -122.42108379139799 (37.7818411112169, -122.421083791398)
898 139815 3 60 1652 Eddy St 2 1 1 2     26 Width 0ft   6002517.0 2112708.0 37.7812354643217 -122.434930809638 (37.7812354643217, -122.434930809638)
900 140947 2 60 2060 Ofarrell St 5 1 1 1     19 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
902 140944 2 60 2060 Ofarrell St 2 1 1 1     18 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
904 140946 2 60 2060 Ofarrell St 4 1 1 1     13 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
907 140952 2 60 2060 Ofarrell St 10 1 1 1     18 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
915 140945 2 60 2060 Ofarrell St 3 1 1 1     23 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
922 140943 2 60 2060 Ofarrell St 1 1 1 1     22 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
925 139814 2 60 1652 Eddy St 1 1 1 1     21 Width 0ft   6002517.0 2112708.0 37.7812354643217 -122.434930809638 (37.7812354643217, -122.434930809638)
929 140950 2 60 2060 Ofarrell St 8 1 1 1     23 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
1077 98926 2 60 3541 Sacramento St 2 1 1 1     15 4x4   5997927.34517 2115124.9687799998 37.7876101632223 -122.450983011859 (37.7876101632223, -122.450983011859)
1274 212204 3 60 920 Bosworth St 4 1 1 2     25 Width 3ft   6001555.51112 2095599.51711 37.7342050772889 -122.437031852331 (37.7342050772889, -122.437031852331)
1303 212206 3 60 920 Bosworth St 7 1 1 2     22 Width 3ft   6001486.61652 2095618.44955 37.734253145164 -122.43727139756399 (37.734253145164, -122.437271397564)
1453 251535 3 60 2799 Diamond St 1 1 1 2       3x3   6002520.0 2095715.0 37.734576941489294 -122.433705562416 (37.7345769414893, -122.433705562416)
1471 251536 3 60 2799 Diamond St 2 1 1 2       3x3   6002520.0 2095715.0 37.734576941489294 -122.433705562416 (37.7345769414893, -122.433705562416)
1543 141557 2 60 524 Baker St 1 1 1 1     18 Width 0ft   6000673.0 2110815.0 37.7759328964671 -122.44117426506 (37.7759328964671, -122.44117426506)
1614 251637 3 60 1640 Eddy St 1 1 1 2       3x3   6002593.76659 2112688.5347700003 37.7811863760687 -122.43466384314199 (37.7811863760687, -122.434663843142)
1636 139812 1 60 1624 EDDY ST 1 1 1 1   06/17/1997 12:00:00 AM 32 Width 0ft   6002737.4248 2112708.2774 37.7812487388446 -122.434168269296 (37.7812487388446, -122.434168269296)
1832 24314 1 60 600X Golden Gate Ave 1 1 1 1     12 3X3   6006601.99404 2112547.97273 37.781027160014204 -122.420787355977 (37.7810271600142, -122.420787355977)
2258 7812 3 60 700X Franklin St 5 1 1 2     18 4X4   6006212.78826 2112695.72596 37.7814109097272 -122.422144314234 (37.7814109097272, -122.422144314234)
2401 140740 1 60 2057X O'Farrell St 1 1 1 1     24 Width 0ft   6001431.032000001 2113174.7073 37.7824552046492 -122.438721167537 (37.7824552046492, -122.438721167537)
2542 4384 3 60 5 Chilton Ave 1 1 1 2     24 3X14   6001725.16099 2095738.6738900002 37.7345968111862 -122.43645527631 (37.7345968111862, -122.43645527631)
2628 248767 2 60 1 Cuesta Ct 1 1 1 1     19 Width 3ft   5999684.377780001 2101641.28638 37.750687799606105 -122.443934882898 (37.7506877996061, -122.443934882898)
2632 248768 2 60 1 Cuesta Ct 6 1 1 1     12 Width 3ft   5999691.3486 2101670.41928 37.7507681891085 -122.44391287020399 (37.7507681891085, -122.443912870204)
2693 98923 2 60 3527 Sacramento St 1 1 1 1     12 4x4   5997962.31773 2115134.58282 37.7876385629149 -122.450862707746 (37.7876385629149, -122.450862707746)
2773 114412 1 60 1345 Taylor St 2 1 1 1     12     6008898.23064 2117525.75314 37.794824095717395 -122.413195602999 (37.7948240957174, -122.413195602999)
2793 7815 3 60 700X Franklin St 8 1 1 2     18 4X4   6006205.55902 2112775.31728 37.781629040289005 -122.422174980189 (37.781629040289, -122.422174980189)
2800 248806 1 60 1039 Stanyan St 1 1 1 1   04/10/1979 12:00:00 AM 18 Width 4ft Permit Number 17875 5997248.91757 2106862.4287 37.7648845181415 -122.45273365463001 (37.7648845181415, -122.45273365463)
2857 41128 3 60 2049 Grove St 2 1 1 4 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2873 41127 3 60 2049 Grove St 1 1 1 4 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2880 41129 3 60 2049 Grove St 3 1 1 4 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2898 114413 1 60 1345 Taylor St 3 1 1 1     22     6008903.22514 2117506.21986 37.7947707425189 -122.413176939363 (37.7947707425189, -122.413176939363)
2937 142168 1 60 1477 GROVE ST 5 1 1 1     13 Width 0ft   6000782.6842 2110659.1833 37.775511310355505 -122.440783660256 (37.7755113103555, -122.440783660256)
3011 142167 1 60 1477 GROVE ST 3 1 1 1     14 Width 0ft   6000740.7568 2110654.3455 37.775495639126795 -122.440928349683 (37.7754956391268, -122.440928349683)
3045 141431 1 60 501 HAYES ST 1 1 1 1   10/26/2005 12:00:00 AM 17 Width 0ft Permit Number 48304 6005404.7905 2110954.8993 37.776585419130896 -122.42481571306601 (37.7765854191309, -122.424815713066)
3053 126134 2 60 2829 Divisadero St 1 1 1 1     18 Width 5ft Permit Number 779774 6000559.90395 2118036.87537 37.7957558571972 -122.44208400078101 (37.7957558571972, -122.442084000781)
3357 32073 1 60 3254 Clay St 1 1 1 1     30   Permit Number 35447 5999189.55674 2115674.61094 37.7891915158244 -122.44665558658701 (37.7891915158244, -122.446655586587)
3447 7810 1 60 700X Franklin St 3 1 1 1     18 3X3   6006241.41357 2112578.9156299997 37.781091791593205 -122.422036983727 (37.7810917915932, -122.422036983727)
3490 141187 1 60 1802 Ellis St 1 1 1 8     25 Width 0ft   6002206.3563 2112987.8984 37.7819863518957 -122.436025516484 (37.7819863518957, -122.436025516484)
3494 106527 2 60 2100 Baker St 3 1 1 1     15     5999890.2062099995 2116153.78918 37.7905472114236 -122.444265881958 (37.7905472114236, -122.444265881958)
3559 24319 1 60 600X Golden Gate Ave 6 1 1 1     14 3X3   6006449.33086 2112523.89037 37.7809524299494 -122.42131378399901 (37.7809524299494, -122.421313783999)
3685 22584 3 60 799X Turk St 12 1 1 2     12 4X4   6006566.74341 2112845.87169 37.7818431310978 -122.420930462379 (37.7818431310978, -122.420930462379)
3774 99172 1 60 2100 Webster St 8 1 1 1     14 3x3 Permit Number 25928 6003312.12208 2116110.60344 37.7906232670935 -122.432423180296 (37.7906232670935, -122.432423180296)
3989 22582 1 60 799X Turk St 9 1 1 1     18 4X4   6006498.64773 2112839.17836 37.7818209142342 -122.421165566743 (37.7818209142342, -122.421165566743)
4186 9424 1 60 701X Golden Gate Ave 4 1 1 1   02/01/1994 12:00:00 AM 12 3X3   6006118.832780001 2112436.92682 37.7806950106942 -122.422450960554 (37.7806950106942, -122.422450960554)
4307 22579 1 60 799X Turk St 7 1 1 1     18 4X4   6006429.75961 2112830.68466 37.7817937088462 -122.42140328454799 (37.7817937088462, -122.421403284548)
4330 70503 2 60 193 Naples St 1 1 1 1 1 06/25/1994 12:00:00 AM 7     6004252.47977 2092436.6780400001 37.725673555265395 -122.42748232385901 (37.7256735552654, -122.427482323859)
4657 24332 3 60 600X Golden Gate Ave 8 1 1 2   01/22/1999 12:00:00 AM 9     6006393.27479 2112527.98365 37.7809605085733 -122.421508000714 (37.7809605085733, -122.421508000714)
5253 222095 2 60 116 Clipper St 1 1 1 1     39 12x9   6004345.11847 2101047.98994 37.7493235046981 -122.427775375138 (37.7493235046981, -122.427775375138)
5515 48743 1 60   1 1 1 1         Permit Number 46023          
5739 99171 1 60 2100 Webster St 7 1 1 1     14 3x3 Permit Number 25928 6003316.34975 2116092.5427599996 37.7905739167998 -122.432407262311 (37.7905739167998, -122.432407262311)
5771 99170 1 60 2100 Webster St 6 1 1 1     14 3x3 Permit Number 25928 6003318.49866 2116076.63924 37.790530371641296 -122.43239869085899 (37.7905303716413, -122.432398690859)
5793 99169 1 60 2100 Webster St 5 1 1 1     14 3x3 Permit Number 25928 6003320.5239 2116054.74736 37.790470376959796 -122.432390119424 (37.7904703769598, -122.432390119424)
5879 24320 1 60 600X Golden Gate Ave 7 1 1 1     12 3X3   6006433.20726 2112530.1062 37.7809685880643 -122.421370005128 (37.7809685880643, -122.421370005128)
5977 98925 2 60 3541 Sacramento St 1 1 1 1     8 4x4   5997905.152000001 2115121.83421 37.7876002859601 -122.45105956936399 (37.7876002859601, -122.451059569364)
6053 7809 1 60 700X Franklin St 2 1 1 1     18 4X4   6006235.14399 2112561.39045 37.7810433181208 -122.422057428004 (37.7810433181208, -122.422057428004)
6135 48746 1 60   4 1 1 1         Permit Number 46023          
6180 113748 1 60 840X Broadway 5 1 1 1     3     6009543.77791 2118449.1609099996 37.7973957673671 -122.411027164876 (37.7973957673671, -122.411027164876)
6223 24318 1 60 600X Golden Gate Ave 5 1 1 1     12 3X3   6006459.0655 2112530.3105599997 37.7809706070487 -122.421280563062 (37.7809706070487, -122.421280563062)
6350 22583 3 60 799X Turk St 11 1 1 2     18 4X4   6006548.992330001 2112844.76483 37.7818390913318 -122.42099179435499 (37.7818390913318, -122.420991794355)
6363 99168 1 60 2100 Webster St 4 1 1 1     14 3x3 Permit Number 25928 6003328.674 2116003.83043 37.790331034186295 -122.432358282529 (37.7903310341863, -122.432358282529)
6377 7813 1 60 700X Franklin St 6 1 1 1     18 4X4   6006213.15076 2112713.3724700003 37.7814593831787 -122.422144314209 (37.7814593831787, -122.422144314209)
6446 107232 2 60 2265 Larkin St 1 1 1 1     15 3x3   6006749.11596 2119031.04722 37.7988363688534 -122.420738768293 (37.7988363688534, -122.420738768293)
6477 113747 1 60 840X Broadway 4 1 1 1   06/29/2016 12:00:00 AM 3     6009570.41641 2118454.8311400004 37.7974128301892 -122.410935389082 (37.7974128301892, -122.410935389082)
6777 26162 1 60 220 Richardson Ave 5 1 1 1     12 3X3   5999090.095480001 2119848.96049 37.800647486559704 -122.447300272802 (37.8006474865597, -122.447300272802)
6785 24317 1 60 600X Golden Gate Ave 4 1 1 1     12 3X3   6006479.1525 2112537.25416 37.7809908049215 -122.421211565287 (37.7809908049215, -122.421211565287)
6948 20002 3 60 100 STAIRWAY46 22 1 1 2     6 2            
6959 48747 1 60   5 1 1 1         Permit Number 46023          
7016 22573 1 60 799X Turk St 1 1 1 1     18 4X4   6006249.787140001 2112806.77447 37.781717908586295 -122.422024207046 (37.7817179085863, -122.422024207046)
7180 48749 1 60   7 1 1 1         Permit Number 46023          
7212 6169 3 60 1075 Ellis St 4 1 1 2   12/11/2009 12:00:00 AM 3 3x3   6005763.6544 2113429.69831 37.7834008746955 -122.423750304634 (37.7834008746955, -122.423750304634)
7248 65393 1 60 1345 Taylor St 1 1 1 1   10/04/1989 12:00:00 AM 22   Permit Number 28235 6008898.78625 2117545.17326 37.7948774497893 -122.41319505442 (37.7948774497893, -122.41319505442)
7319 98048 2 60 2251 Jackson St 2 1 1 1     24 3x3   6003429.10066 2116873.98532 37.7927259513035 -122.432072977999 (37.7927259513035, -122.432072977999)
7445 99167 1 60 2100 Webster St 3 1 1 1     14 3x3 Permit Number 25928 6003331.11107 2115984.74946 37.7902787808939 -122.432348487091 (37.7902787808939, -122.432348487091)
7696 19998 3 60 100 STAIRWAY46 18 1 1 2     12 40            
7734 24324 1 60 600X Golden Gate Ave 11 1 1 1     12 3X3   6006305.76929 2112511.39113 37.7809100152295 -122.421809546989 (37.7809100152295, -122.421809546989)
7803 98047 2 60 2251 Jackson St 1 1 1 1     24 3x3   6003407.78151 2116869.84399 37.7927133715759 -122.43214644721901 (37.7927133715759, -122.432146447219)
7840 19005 1 60 3067 Sacramento St 1 1 1 1     12 3x3   6000119.97054 2115432.29592 37.788579285248495 -122.443419066834 (37.7885792852485, -122.443419066834)
7871 9429 3 60 727 Golden Gate Ave 3 1 1 2     18 3X3   6005901.79421 2112405.20993 37.7805956778943 -122.423199547232 (37.7805956778943, -122.423199547232)
7920 98924 2 60 3527 Sacramento St 2 1 1 1     12 4x4   5997977.38318 2115131.5705 37.7876311543002 -122.45081036719999 (37.7876311543002, -122.4508103672)
7982 99166 1 60 2100 Webster St 2 1 1 1     16 3x3 Permit Number 25928 6003335.0360900005 2115969.1620099996 37.7902362042855 -122.43233379308701 (37.7902362042855, -122.432333793087)
8055 113745 1 60 840X Broadway 2 1 1 1     3     6009609.4912 2118458.30583 37.797424561837 -122.410800425125 (37.797424561837, -122.410800425125)
8095 50823 1 60   2 1 1 1   03/19/2004 12:00:00 AM     Permit Number 47344          
8251 22580 1 60 799X Turk St 8 1 1 1     18 4X4   6006453.23929 2112834.51188 37.7818055412449 -122.42132232756 (37.7818055412449, -122.42132232756)
8293 24315 1 60 600X Golden Gate Ave 2 1 1 1     12 3X3   6006566.6125300005 2112551.64159 37.781035239531704 -122.420910018978 (37.7810352395317, -122.420910018978)
Powered by Datasette · Query took 27.351ms · Data source: data.sfgov.org