sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
162153 201632 2 15 451 Galvez Ave 6 2 1 1     2 Width 3ft   6021871.21572 2093119.8757200001 37.728530265257504 -122.366622037185 (37.7285302652575, -122.366622037185)
25954 201635 2 15 451 Galvez Ave 5 2 1 1     2 Width 3ft   6021853.58241 2093133.73067 37.7285673424948 -122.36668395282301 (37.7285673424948, -122.366683952823)
61764 201633 2 15 451 Galvez Ave 4 2 1 1     2 Width 3ft   6021837.4277 2093144.7538400001 37.7285967251547 -122.36674056154699 (37.7285967251547, -122.366740561547)
186137 201634 2 15 451 Galvez Ave 3 2 1 1     2 Width 3ft   6021819.77945 2093157.84467 37.728631703379996 -122.366802476247 (37.72863170338, -122.366802476247)
152013 201631 2 15 451 Galvez Ave 2 2 1 1     2 Width 3ft   6021802.56362 2093169.8437599998 37.728663707547 -122.366862820783 (37.728663707547, -122.366862820783)
147489 201630 2 15 451 Galvez Ave 1 2 1 1     12 Width 3ft   6021771.18031 2093196.4626099998 37.72873507866179 -122.36697315229799 (37.7287350786618, -122.366973152298)
50863 201629 2 15 401 Galvez Ave 13 4 1 1     6 Width 3ft   6021522.6239599995 2093379.49172 37.7292240220626 -122.36784506930599 (37.7292240220626, -122.367845069306)
33230 201628 2 15 401 Galvez Ave 12 4 1 1     13 Width 3ft   6021496.8135400005 2093398.7623299998 37.729275520830996 -122.36793562924 (37.729275520831, -122.36793562924)
87727 65566 1 17 340 Yerba Buena Rd 1 1 1 1   01/17/1990 12:00:00 AM     Permit Number 28465 6022030.55852908 2122617.11164597 37.8095323316173 -122.368107024455 (37.8095323316173, -122.368107024455)
143067 65565 1 17 282 Yerba Buena Rd 1 1 1 1   01/17/1990 12:00:00 AM     Permit Number 28464 6022001.13211196 2122805.77301993 37.8100487398864 -122.368221901586 (37.8100487398864, -122.368221901586)
60882 201626 2 15 401 Galvez Ave 9 2 1 1     8 Width 3ft   6021390.17472 2093479.1465200002 37.729490394945294 -122.36830984254298 (37.7294903949453, -122.368309842543)
61834 201616 2 44 0 Innes Ct 1 2 1 1     1 Width 3ft   6021349.55513 2092801.0747099998 37.7276263098888 -122.36840346285801 (37.7276263098888, -122.368403462858)
2371 253059 1 174 421 Hudson Ave 2 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770411 6021349.4 2093117.8080000002 37.728495991679296 -122.368425863032 (37.7284959916793, -122.368425863032)
2385 253058 1 174 421 Hudson Ave 1 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770411 6021349.4 2093117.8080000002 37.728495991679296 -122.368425863032 (37.7284959916793, -122.368425863032)
2395 253061 1 174 421 Hudson Ave 4 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770411 6021349.4 2093117.8080000002 37.728495991679296 -122.368425863032 (37.7284959916793, -122.368425863032)
2462 253060 1 174 421 Hudson Ave 3 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770411 6021349.4 2093117.8080000002 37.728495991679296 -122.368425863032 (37.7284959916793, -122.368425863032)
147636 201625 2 15 401 Galvez Ave 7 4 1 1     11 Width 3ft   6021338.5629 2093518.11855 37.729594575111 -122.368490962388 (37.729594575111, -122.368490962388)
2365 253069 1 44 420 Innes Ave 4 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.0075199995 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757)
2380 253068 1 44 420 Innes Ave 3 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.0075199995 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757)
2382 253067 1 44 420 Innes Ave 2 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.0075199995 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757)
2384 253066 1 44 420 Innes Ave 1 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.0075199995 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757)
2373 253062 1 174 451 Hudson Ave 1 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770412 6021215.947000001 2093217.369 37.728762049698204 -122.36889409743 (37.7287620496982, -122.36889409743)
2421 253064 1 174 451 Hudson Ave 3 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770412 6021215.947000001 2093217.369 37.728762049698204 -122.36889409743 (37.7287620496982, -122.36889409743)
2431 253063 1 174 451 Hudson Ave 2 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770412 6021215.947000001 2093217.369 37.728762049698204 -122.36889409743 (37.7287620496982, -122.36889409743)
67615 201618 2 15 401 Galvez Ave 3 2 1 1     9 Width 3ft   6021223.045080001 2093587.4702 37.7297786672424 -122.36889511322701 (37.7297786672424, -122.368895113227)
162543 201617 2 15 401 Galvez Ave 1 2 1 1     10 Width 3ft   6021188.31873 2093585.6418599999 37.729771742469794 -122.369015041404 (37.7297717424698, -122.369015041404)
90246 65563 1 17 255 Yerba Buena Rd 1 1 1 1   01/16/1990 12:00:00 AM     Permit Number 28462 6021766.42970205 2122905.90070123 37.8103107984086 -122.36904110347099 (37.8103107984086, -122.369041103471)
31009 201796 2 174 50 Jerrold Ave 1 4 1 1     2 Width 5ft   6021152.60745 2092710.04539 37.727365560462395 -122.369078036218 (37.7273655604624, -122.369078036218)
2405 201816 1 48 101 Friedell St 7 1 1 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021143.08428 2093327.21502 37.729059670062206 -122.36915357747299 (37.7290596700622, -122.369153577473)
2369 201815 1 48 101 Friedell St 6 1 1 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021129.2467 2093308.19399 37.7290066829092 -122.369200102111 (37.7290066829092, -122.369200102111)
164353 201797 2 174 50 Jerrold Ave 2 4 1 1     2 Width 5ft   6021117.279709999 2092731.0926599998 37.7274214146518 -122.369201619254 (37.7274214146518, -122.369201619254)
2391 201814 1 48 101 Friedell St 5 1 1 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021112.10587 2093285.4865 37.728943392223 -122.36925779181699 (37.728943392223, -122.369257791817)
2410 201817 2 48 100 Friedell St 1 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021101.98762 2093338.62944 37.7290887577236 -122.36929644199101 (37.7290887577236, -122.369296441991)
70745 201798 2 174 50 Jerrold Ave 3 4 1 1     2 Width 5ft   6021088.33309 2092752.01283 37.7274772697451 -122.36930313385099 (37.7274772697451, -122.369303133851)
2381 201818 2 48 100 Friedell St 2 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021088.08179 2093322.4173400002 37.7290434795636 -122.369343396492 (37.7290434795636, -122.369343396492)
2466 201813 1 48 101 Friedell St 4 1 1 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021086.18405 2093254.37787 37.728856551886395 -122.369345258092 (37.7288565518864, -122.369345258092)
2417 201819 2 48 100 Friedell St 3 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
33142 201605 2 44 570 Innes Ave 1 2 1 1     1 Width 3ft   6021066.69823 2093118.6837900002 37.7284828925695 -122.369403250859 (37.7284828925695, -122.369403250859)
178920 201812 2 48 101 Friedell St 3 4 1 1     1 Width 6ft   6021065.67541 2093224.76894 37.728774126326705 -122.369414113788 (37.7287741263267, -122.369414113788)
133056 201799 2 174 50 Jerrold Ave 4 4 1 1     2 Width 5ft   6021051.90692 2092781.9816400001 37.727557560315795 -122.36943113075 (37.7275575603158, -122.36943113075)
2408 201820 2 48 100 Friedell St 4 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
64913 201811 2 48 101 Friedell St 2 4 1 1     1 Width 6ft   6021050.71889 2093203.62599 37.7287152512926 -122.369464359799 (37.7287152512926, -122.369464359799)
2367 253057 1 11 451 Donahue St 7 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6021055.26176 2093480.52839 37.729475822337605 -122.36946777993099 (37.7294758223376, -122.369467779931)
2386 201590 1 11 451 Donahue St 6 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6021055.26176 2093480.52839 37.729475822337605 -122.36946777993099 (37.7294758223376, -122.369467779931)
71242 201604 2 44 570 Innes Ave 2 2 1 1     1 Width 3ft   6021044.33252 2093135.00772 37.7285264880895 -122.369481698744 (37.7285264880895, -122.369481698744)
59854 201603 2 44 565 Innes Ave 1 4 1 1     2 Width 3ft   6021043.02716 2093075.23068 37.7283622799705 -122.369482082752 (37.7283622799705, -122.369482082752)
2383 201821 2 48 100 Friedell St 5 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
65062 201810 2 48 101 Friedell St 1 4 1 1     1 Width 6ft   6021035.70856 2093179.8039900002 37.7286490171175 -122.369514606714 (37.7286490171175, -122.369514606714)
2455 201589 1 11 451 Donahue St 5 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6021039.89306 2093459.94557 37.729418462686894 -122.369519490027 (37.7294184626869, -122.369519490027)
2387 201822 2 48 100 Friedell St 6 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
182476 201800 2 174 50 Jerrold Ave 5 4 1 1     2 Width 5ft   6021019.258830001 2092809.3324400003 37.7276308694498 -122.36954588606001 (37.7276308694498, -122.36954588606)
2438 201823 2 48 100 Friedell St 7 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021023.85438 2093233.10906 37.728794732485206 -122.369559269737 (37.7287947324852, -122.369559269737)
2374 201588 1 11 451 Donahue St 4 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6021025.00287 2093440.1386 37.7293632596022 -122.369569599359 (37.7293632596022, -122.369569599359)
2389 201587 1 11 451 Donahue St 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6021008.9496 2093419.1731599998 37.729304811746104 -122.36962364951799 (37.7293048117461, -122.369623649518)
2409 201824 2 48 100 Friedell St 8 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021004.603680001 2093212.5880900002 37.728737329640495 -122.369624404053 (37.7287373296405, -122.369624404053)
2403 201586 1 11 451 Donahue St 2 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020998.06283 2093403.93478 37.729262372745794 -122.36966023392799 (37.7292623727458, -122.369660233928)
51493 201801 2 174 50 Jerrold Ave 6 4 1 1     2 Width 5ft   6020978.953509999 2092836.83628 37.7277041785835 -122.369687123669 (37.7277041785835, -122.369687123669)
2402 201606 2 44 598 Innes Ave 1 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.4635700001 37.7287012794353 -122.36979738594101 (37.7287012794353, -122.369797385941)
163371 201802 2 174 50 Jerrold Ave 7 4 1 1     2 Width 5ft   6020947.47999 2092859.07822 37.7277635239432 -122.369797465976 (37.7277635239432, -122.369797465976)
157074 201809 2 48 237 Friedell St 1 4 1 1     1 Width 6ft   6020945.51773 2093059.3003900002 37.72831318869729 -122.369818081152 (37.7283131886973, -122.369818081152)
2465 201607 2 44 598 Innes Ave 2 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.8340900003 37.7287396409072 -122.36986751418699 (37.7287396409072, -122.369867514187)
181683 201803 2 174 50 Jerrold Ave 8 4 1 1     2 Width 5ft   6020924.86388 2092877.32885 37.7278123958223 -122.36987691208401 (37.7278123958223, -122.369876912084)
50519 201808 2 48 247 Friedell St 1 4 1 1     1 Width 6ft   6020927.8472 2093035.08257 37.7282457215548 -122.369877496672 (37.7282457215548, -122.369877496672)
2460 201825 1 48 232 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020928.29141 2093111.1924700001 37.7284547293849 -122.36988121894899 (37.7284547293849, -122.369881218949)
93209 65564 1 17 228 Yerba Buena Rd 1 1 1 1   01/17/1990 12:00:00 AM     Permit Number 28463 6021524.08705829 2122941.38889516 37.8103949467147 -122.36988228287599 (37.8103949467147, -122.369882282876)
2433 201610 1 44 599 Innes Ave 2 1 1 1   07/12/2017 12:00:00 AM 3 Width 3ft Permit Number 770566 6020924.70462 2093166.9470099998 37.7286076240414 -122.36989747059201 (37.7286076240414, -122.369897470592)
2422 201585 1 11 451 Donahue St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020918.10936 2093291.5638700002 37.728949436562 -122.36992888032302 (37.728949436562, -122.369928880323)
176019 201608 2 44 598 Innes Ave 3 2 1 1     1 Width 3ft   6020912.48689 2093230.64881 37.7287818667771 -122.369944109446 (37.7287818667771, -122.369944109446)
52097 201804 2 174 50 Jerrold Ave 9 4 1 1     2 Width 5ft   6020904.74927 2092892.98725 37.7278542871344 -122.369947531359 (37.7278542871344, -122.369947531359)
2435 201826 1 48 250 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020898.42083 2093071.04954 37.7283428654122 -122.369981710984 (37.7283428654122, -122.369981710984)
179043 201807 2 48 273 Friedell St 1 4 1 1     2 Width 6ft   6020893.117219999 2092989.08595 37.728117517799795 -122.36999438334298 (37.7281175177998, -122.369994383343)
51993 201805 2 174 50 Jerrold Ave 10 4 1 1     2 Width 5ft   6020879.60636 2092912.55986 37.727906650163 -122.37003580431801 (37.727906650163, -122.370035804318)
2446 201827 1 48 258 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020879.65439 2093047.83852 37.7282781025329 -122.370044984594 (37.7282781025329, -122.370044984594)
2392 253051 1 11 101 Donahue St 4 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
2397 253052 1 11 101 Donahue St 5 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
2413 253048 1 11 101 Donahue St 1 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
2414 253049 1 11 101 Donahue St 2 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
2448 253050 1 11 101 Donahue St 3 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
2464 253053 1 11 101 Donahue St 6 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
55370 201806 2 174 50 Jerrold Ave 11 4 1 1     2 Width 5ft   6020862.09511 2092930.7088400002 37.727955522906605 -122.37009759584998 (37.7279555229066, -122.37009759585)
2444 201828 1 48 268 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020862.97624 2093021.3694799999 37.728204508308 -122.3701008136 (37.728204508308, -122.3701008136)
2406 201829 1 48 284 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020846.41585 2093000.7945400001 37.7281471046068 -122.37015664263399 (37.7281471046068, -122.370156642634)
2423 201830 1 48 292 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020827.60649 2092975.44043 37.7280764547545 -122.370219916224 (37.7280764547545, -122.370219916224)
2412 201597 1 11 451 Donahue St 8 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020830.52372 2093183.4296400002 37.728647714022 -122.37022420239201 (37.728647714022, -122.370224202392)
2415 201596 1 11 501 Donahue St 8 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020816.91369 2093164.12057 37.7285939480275 -122.370269919443 (37.7285939480275, -122.370269919443)
2376 201595 1 11 501 Donahue St 7 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020802.701169999 2093144.94147 37.7285405058214 -122.370317728275 (37.7285405058214, -122.370317728275)
132813 201611 2 67 98 Jerrold Ave 1 17 1 1     2 Width 9ft   6020793.34161 2092957.5019 37.7280253184122 -122.37033713297501 (37.7280253184122, -122.370337132975)
2377 201594 1 11 501 Donahue St 6 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020788.86166 2093125.8535099998 37.7284873343211 -122.370364253806 (37.7284873343211, -122.370364253806)
184420 201549 2 60 601 Innes Ave 18 9 1 1     23 Width 6ft   6020789.549380001 2093251.9329799998 37.728833562500206 -122.370370588629 (37.7288335625002, -122.370370588629)
177224 201612 2 67 98 Jerrold Ave 2 17 1 1     2 Width 3ft   6020781.6072 2092974.15888 37.7280704113081 -122.370378850726 (37.7280704113081, -122.370378850726)
2411 201831 1 48 350 Friedell St 1 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020768.36275 2092897.8842900002 37.7278602487283 -122.37041936696698 (37.7278602487283, -122.370419366967)
2447 201593 1 11 501 Donahue St 5 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020771.25022 2093102.78815 37.72842303458621 -122.370423544329 (37.7284230345862, -122.370423544329)
184178 201613 2 67 98 Jerrold Ave 3 17 1 1     2 Width 4ft   6020763.58395 2092982.86481 37.728093326933205 -122.370441760089 (37.7280933269332, -122.370441760089)
2393 201592 1 11 501 Donahue St 4 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020757.80811 2093085.24603 37.7283741294404 -122.370468802689 (37.7283741294404, -122.370468802689)
2390 201832 1 48 350 Friedell St 2 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020752.62591 2092874.74971 37.727795861786205 -122.370472171548 (37.7277958617862, -122.370472171548)
185405 201614 2 67 98 Jerrold Ave 4 17 1 1     3 Width 4ft   6020747.34365 2092993.8196 37.728122515333396 -122.370498661104 (37.7281225153334, -122.370498661104)
2437 201591 1 11 501 Donahue St 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020744.06411 2093067.1780599998 37.7283237638216 -122.37051506831001 (37.7283237638216, -122.37051506831)
2454 201833 1 48 350 Friedell St 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020733.63229 2092847.8779900002 37.727721034575296 -122.370535976659 (37.7277210345753, -122.370535976659)
69445 201615 2 67 98 Jerrold Ave 5 17 1 1     2 Width 4ft   6020732.10647 2093000.2197599998 37.728139252612 -122.370551779534 (37.728139252612, -122.370551779534)
2362 201584 1 11 501 Donahue St 2 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020732.46705 2093049.56763 37.7282747723482 -122.370553943333 (37.7282747723482, -122.370553943333)
2461 201834 1 48 350 Friedell St 4 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020718.56969 2092826.63123 37.7276618681873 -122.37058658062 (37.7276618681873, -122.37058658062)
Powered by Datasette · Query took 95.913ms · Data source: data.sfgov.org