sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
2773 114412 1 60 1345 Taylor St 2 1 1 1     12     6008898.23064 2117525.75314 37.794824095717395 -122.413195602999 (37.7948240957174, -122.413195602999)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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          
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)
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)
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)
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)
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)
8305 24325 1 60 600X Golden Gate Ave 12 1 1 1     33 3X3   6006278.38926 2112509.01094 37.7809019357225 -122.42190409898998 (37.7809019357225, -122.42190409899)
8309 22576 1 60 799X Turk St 4 1 1 1     18 4X4   6006347.61377 2112822.4191900003 37.7817663820541 -122.421686883966 (37.7817663820541, -122.421686883966)
8440 19006 1 60 3067 Sacramento St 2 1 1 1     12 3x3   6000132.745080001 2115433.98205 37.7885846434091 -122.443374990159 (37.7885846434091, -122.443374990159)
8642 22574 1 60 799X Turk St 2 1 1 1     18 4X4   6006283.90302 2112813.42944 37.7817381055674 -122.421906654863 (37.7817381055674, -122.421906654863)
8650 7811 1 60 700X Franklin St 4 1 1 1     18 4X4   6006219.73405 2112674.25147 37.7813523377843 -122.422118759068 (37.7813523377843, -122.422118759068)
8773 48750 1 60   8 1 1 1         Permit Number 46023          
8925 22575 1 60 799X Turk St 3 1 1 1     18 4X4   6006314.95978 2112814.99848 37.7817441651975 -122.42179932438499 (37.7817441651975, -122.421799324385)
8939 48748 1 60   6 1 1 1         Permit Number 46023          
9025 48744 1 60   2 1 1 1         Permit Number 46023          
9050 1999 1 60 217 Bocana St 1 1 1 1     38 3X3   6007148.9837828 2097704.1672577998 37.7403003295941 -122.417842531543 (37.7403003295941, -122.417842531543)
9075 17962 1 60 2507 Pine St 3 1 1 1     30 3x3   6001946.9790368 2114981.8697349 37.7874465501899 -122.437065644028 (37.7874465501899, -122.437065644028)
9093 12590 1 60 521 Lake St 1 1 1 1   02/24/2008 12:00:00 AM 11 4x4   5993790.57771 2114837.48993 37.786583130222 -122.465274409298 (37.786583130222, -122.465274409298)
9127 12154 1 60 1400X La Salle Ave 34 1 1 1     12 3X3   6016226.76201 2095667.61701 37.735215066832104 -122.386312951947 (37.7352150668321, -122.386312951947)
9140 12661 1 60 1045 Lake St 2 1 1 1     100 4X4   5992178.70595 2114775.57253 37.786320036254004 -122.47084652786002 (37.786320036254, -122.47084652786)
9163 17982 1 60 2578 Pine St 1 1 1 1     30 3x3   6001610.4943389995 2114985.9919613 37.7874387369759 -122.43823010545499 (37.7874387369759, -122.438230105455)
9177 10667 1 60 1021 Hayes St 1 1 1 1     24 3X3   6002954.21433 2110590.33753 37.7754457061984 -122.43326690297701 (37.7754457061984, -122.433266902977)
9233 25445 1 60 1400X La Salle Ave 40 1 1 1     24 3X3   6016123.98501 2095766.22901 37.735480146065505 -122.386675167071 (37.7354801460655, -122.386675167071)
9275 9356 1 60 241 Gold Mine Dr 1 1 1 1     100 3X3   6000999.4900667 2098404.1035626 37.74187419547079 -122.43915513344 (37.7418741954708, -122.43915513344)
9286 4816 1 60 50X Cortland Ave 1 1 1 1     30 11x5   6005990.1672425 2097819.1039723 37.7405506369184 -122.421857425384 (37.7405506369184, -122.421857425384)
9297 5763 1 60 401 Duboce Ave 1 1 1 1     18 3x3   6004052.45174 2108353.78487 37.7693669201086 -122.429308319494 (37.7693669201086, -122.429308319494)
9301 28308 1 60 244X CORTLAND AVE 1 1 1 1     15 3X3   6006809.0 2097383.0 37.739399336612 -122.418995288624 (37.739399336612, -122.418995288624)
9314 12158 1 60 1400X La Salle Ave 38 1 1 1     18 3X3   6016158.70701 2095735.6730099998 37.735398167686206 -122.38655298897699 (37.7353981676862, -122.386552988977)
9353 12157 1 60 1400X La Salle Ave 37 1 1 1     12 3X3   6016176.76201 2095719.00601 37.73535340295211 -122.386489403775 (37.7353534029521, -122.386489403775)
9420 12628 1 60 840 Lake St 1 1 1 1     35 3X3   5992820.04588 2114852.30881 37.786567801977796 -122.46863326133999 (37.7865678019778, -122.46863326134)
9423 17963 1 60 2507 Pine St 4 1 1 1     30 3x3   6001946.9790368 2114981.8697349 37.7874465501899 -122.437065644028 (37.7874465501899, -122.437065644028)
9450 19167 1 60 95 Sanchez St 1 1 1 1     12 3X3   6003517.6175946 2107764.5447227 37.767718716857 -122.43111622226601 (37.767718716857, -122.431116222266)
9455 17964 1 60 2507 Pine St 5 1 1 1     30 3x3   6001946.9790368 2114981.8697349 37.7874465501899 -122.437065644028 (37.7874465501899, -122.437065644028)
9472 12156 1 60 1400X La Salle Ave 36 1 1 1     18 3X3   6016192.73501 2095700.95101 37.7353047117642 -122.386432920212 (37.7353047117642, -122.386432920212)
9805 57857 1 60 491 12th Ave 1 1 1 1   02/07/1984 12:00:00 AM 15   Permit Number 779316 5992173.1495199995 2112167.2990599996 37.7791581122705 -122.47067570242599 (37.7791581122705, -122.470675702426)
9958 19162 1 60 85 Sanchez St 2 1 1 1     12 3x3   6003517.76355 2107824.4837 37.7678833029889 -122.431119996093 (37.7678833029889, -122.431119996093)
10143 58653 1 60 1041 Stanyan St 1 1 1 1   04/10/1979 12:00:00 AM   3x3 Permit Number 17875 5997239.92048014 2106921.18918515 37.7650453439116 -122.45276901450501 (37.7650453439116, -122.452769014505)
10338 30354 1 60   1 1 1 1   02/17/1956 12:00:00 AM     Permit Number 43          
13443 14968 1 60 400X Mendell St 1 1 1 11     12 3X3   6016667.040519999 2097697.80462 37.7408139135396 -122.384932128834 (37.7408139135396, -122.384932128834)
13566 48742 1 60   10 1 1 1         Permit Number 46023          
13725 14972 1 60 400X Mendell St 5 1 1 11     12 3X3   6016621.68773 2097636.5481 37.740643206920204 -122.385084676324 (37.7406432069202, -122.385084676324)
13861 12127 1 60 1400X La Salle Ave 7 1 1 1     6 3X3   6016490.26403 2095091.74303 37.733648414028295 -122.385361804207 (37.7336484140283, -122.385361804207)
13922 14989 1 60 500 Mendell St 5 1 1 1     6 3x3   6016436.5067300005 2097390.6567700002 37.7399577940171 -122.38570783365101 (37.7399577940171, -122.385707833651)
14417 48751 1 60   9 1 1 1         Permit Number 46023          
14499 35359 1 60 917 Rhode Island St 1 1 1 1 1 02/23/1998 12:00:00 AM 28 6x6 Permit Number 38821 6011905.65469 2104108.25722 37.758151117709104 -122.40184581615 (37.7581511177091, -122.40184581615)
14766 12139 1 60 1400X La Salle Ave 19 1 1 1   05/17/1996 12:00:00 AM 6 3X3   6016385.33586 2095408.8215700001 37.7345132425897 -122.385746667286 (37.7345132425897, -122.385746667286)
14800 12153 1 60 1400X La Salle Ave 33 1 1 1     12 3X3   6016182.90625 2095712.9210700002 37.7353370350581 -122.386467736523 (37.7353370350581, -122.386467736523)
15356 54446 1 60 661 Mississippi St 1 1 1 1   06/23/1972 12:00:00 AM 30   Permit Number 10224 6014152.690909999 2104085.93791 37.7582149794585 -122.394072973006 (37.7582149794585, -122.394072973006)
15452 12142 1 60 1400X La Salle Ave 22 1 1 1   05/17/1996 12:00:00 AM 3 3X3   6016364.0707 2095472.0382700001 37.734685646232 -122.385824593536 (37.734685646232, -122.385824593536)
15637 48745 1 60   3 1 1 1         Permit Number 46023          
15813 14969 1 60 400X Mendell St 2 1 1 11     12 3x3   6016654.44168 2097681.89431 37.7407695301847 -122.38497458311501 (37.7407695301847, -122.384974583115)
15841 12149 1 60 1400X La Salle Ave 29 1 1 1     12 3X3   6016248.95724 2095649.3696400002 37.735166191751 -122.38623494249399 (37.735166191751, -122.386234942494)
16035 54185 1 60 1526 Kirkwood Ave 1 1 1 1   06/19/1972 12:00:00 AM 30 4x4 Permit Number 9920 6015598.37895 2096494.31778 37.7374502170542 -122.388543207207 (37.7374502170542, -122.388543207207)
16135 12122 1 60 1400X La Salle Ave 2 1 1 1   05/17/1996 12:00:00 AM 3 3X3   6016530.391559999 2095003.08247 37.7334071897754 -122.38521689463998 (37.7334071897754, -122.38521689464)
16140 12129 1 60 1400X La Salle Ave 9 1 1 1     18 3X3   6016454.923280001 2095170.51744 37.7338627575466 -122.385489476485 (37.7338627575466, -122.385489476485)
16161 14904 1 60 175 Mendell St 4 1 1 1     12 3x3   6017055.387680001 2098389.95887 37.7427359014434 -122.383637533158 (37.7427359014434, -122.383637533158)
16226 14876 1 60 50 Mendell St 2 1 1 1     12 3x3   6017126.2926199995 2098751.68022 37.7437330337612 -122.383417536507 (37.7437330337612, -122.383417536507)
16398 14883 1 60 50 Mendell St 9 1 1 1   02/21/2008 12:00:00 AM 3 3x3   6017019.70543 2098544.01606 37.7431569388511 -122.383771637374 (37.7431569388511, -122.383771637374)
16652 14973 1 60 400X Mendell St 6 1 1 11     12 3X3   6016605.91834 2097618.21478 37.740591995028 -122.385137924278 (37.740591995028, -122.385137924278)
16680 14970 1 60 400X Mendell St 3 1 1 11     18 3x3   6016646.28629 2097669.62437 37.740735388316395 -122.385001926999 (37.7407353883164, -122.385001926999)
Powered by Datasette · Query took 14.975ms · Data source: data.sfgov.org