sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18948 25002 3 100 400X Dolores St 7 11 1 2     70 20   6004897.79092 2105856.39656 37.7625575106521 -122.42620650513001 (37.7625575106521, -122.42620650513)
19013 25540 3 100 2200X Market St 6 11 1 2   04/01/1993 12:00:00 AM 36 20   6003208.8276 2106774.142 37.7649818088085 -122.43211355317601 (37.7649818088085, -122.432113553176)
19053 25122 3 100 1550 Dolores St 3 11 1 2     90 20   6005275.20405 2099188.4733700003 37.7442702680707 -122.42442687003 (37.7442702680707, -122.42442687003)
19066 25040 3 100 800X Dolores St 4 11 1 2     90 20   6005037.4743800005 2103495.5655400003 37.7560831194465 -122.42555536268499 (37.7560831194465, -122.425555362685)
19082 25127 3 100 1650X Dolores St 3 11 1 2     40 20   6005306.7238300005 2098611.50649 37.7426878281697 -122.424276854096 (37.7426878281697, -122.424276854096)
19160 25028 3 100 700X Dolores St 3 11 1 2   06/23/1997 12:00:00 AM 70 20   6005001.93677 2104182.12883 37.75796625306 -122.425727128704 (37.75796625306, -122.425727128704)
19185 25013 3 100 550X Dolores St 7 11 1 2     90 20   6004948.9055699995 2104970.0682099997 37.7601267519689 -122.425966621772 (37.7601267519689, -122.425966621772)
19235 24988 3 100 370X Dolores St 2 11 1 2     40 20   6004888.10333 2106135.4070099997 37.7633230594236 -122.426259876316 (37.7633230594236, -122.426259876316)
19258 25140 3 100 1750X Dolores St 6 11 1 2     90 20   6005337.960390001 2097982.3892099997 37.74096217846979 -122.424124115947 (37.7409621784698, -122.424124115947)
19284 25135 3 100 1700X Dolores St 1 11 1 2     90 20   6005318.690690001 2098391.09531 37.742083304809206 -122.424219803815 (37.7420833048092, -122.424219803815)
19325 25154 3 100 50X Dolores St 2 11 1 2     90 20   6004786.45589 2107937.0696900003 37.7682642477152 -122.42673975183901 (37.7682642477152, -122.426739751839)
19333 24968 3 100 100 Dolores St 9 11 1 2     90 20   6004810.58196 2107534.1310400004 37.767159239034704 -122.426627605497 (37.7671592390347, -122.426627605497)
19334 24962 3 100 100 Dolores St 3 11 1 2   04/21/2005 12:00:00 AM 30 20   6004805.8872 2107667.07109 37.76752399506629 -122.42665331171999 (37.7675239950663, -122.42665331172)
19402 25141 3 100 1750X Dolores St 7 11 1 2     70 20   6005346.329580001 2097965.45382 37.740916150253604 -122.424093974258 (37.7409161502536, -122.424093974258)
19415 25531 3 100 2300X Market St 6 11 1 2   04/01/1993 12:00:00 AM 36 10   6002640.0878 2106231.2379 37.763458864653295 -122.434041867896 (37.7634588646533, -122.434041867896)
19480 25039 3 100 800X Dolores St 3 11 1 2     90 20   6005035.06937 2103531.66337 37.756182099743 -122.42556624900801 (37.756182099743, -122.425566249008)
19492 25148 3 100 2X Dolores St 1 11 1 2     80 20   6004781.85822 2108123.31219 37.7687753648286 -122.426768919571 (37.7687753648286, -122.426768919571)
19585 24338 3 100 2020X Market St 1 11 1 2   05/07/1993 12:00:00 AM 36 8   6004443.4589 2107950.1478 37.76828075872071 -122.42792707731 (37.7682807587207, -122.42792707731)
19587 25088 3 100 1250X Dolores St 3 11 1 2     90 20   6005178.85274 2100929.77786 37.7490460494561 -122.424883892899 (37.7490460494561, -122.424883892899)
19629 25032 3 100 750X Dolores St 7 11 1 2     70 20   6005021.65336 2103769.84125 37.756835322312604 -122.42562959723 (37.7568353223126, -122.42562959723)
19687 25091 3 100 1350 Dolores St 1 11 1 2     80 20   6005204.68058 2100428.03656 37.7476698420965 -122.42475889070299 (37.7476698420965, -122.424758890703)
19785 25785 1 100 500X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213273997 37.7992817461076 -122.39756784649201 (37.7992817461076, -122.397567846492)
19826 24965 3 100 100 Dolores St 6 11 1 2     90 20   6004804.04595 2107595.6918 37.767327900586 -122.42665459683799 (37.767327900586, -122.426654596838)
19857 5683 3 100 1488 Dolores St 1 1 1 2   05/08/1997 12:00:00 AM 12 6   6005201.38668 2099720.6305299997 37.745727281286705 -122.42471996446301 (37.7457272812867, -122.424719964463)
19946 25514 3 100 2100X Market St 1 11 1 2   04/01/1993 12:00:00 AM 36 10   6004037.0875 2107573.3112 37.7672230586461 -122.429305801661 (37.7672230586461, -122.429305801661)
19960 25156 3 100 50X Dolores St 4 11 1 2     90 20   6004792.45266 2107880.8578 37.768110242434204 -122.426715006093 (37.7681102424342, -122.426715006093)
19964 703 3 100 1375X Dolores St 1 1 1 2     70 3X3   6005257.21277 2100319.77841 37.747375556949 -122.424569537574 (37.747375556949, -122.424569537574)
19989 25018 3 100 750X Dolores St 3 11 1 2     70 20   6005012.95019 2103889.3731400003 37.757163037054 -122.42566820334 (37.757163037054, -122.42566820334)
20060 25500 3 100 1745X Market St 5 11 1 2   04/01/1993 12:00:00 AM 24 20   6005964.12554 2109421.56816 37.7724068380339 -122.422771813485 (37.7724068380339, -122.422771813485)
20149 25149 3 100 2X Dolores St 2 11 1 2     90 20x10   6004775.29887 2108114.09165 37.768749676587205 -122.42679095116002 (37.7687496765872, -122.42679095116)
20169 24997 3 100 400X Dolores St 2 11 1 2   10/04/1999 12:00:00 AM 70 20   6004897.70828 2105945.4375400003 37.7628019913498 -122.426213130441 (37.7628019913498, -122.426213130441)
20197 25001 3 100 400X Dolores St 6 11 1 2     90 20   6004908.3831400005 2105867.13213 37.7625875866685 -122.426170634793 (37.7625875866685, -122.426170634793)
20270 25000 3 100 450X Dolores St 5 11 1 2     90 20   6004920.85287 2105575.60223 37.761787819564205 -122.42610675143801 (37.7617878195642, -122.426106751438)
20326 25115 3 100 1550X Dolores St 2 11 1 2     90 20   6005272.16967 2099229.32207 37.7443822579348 -122.424440267208 (37.7443822579348, -122.424440267208)
20343 25533 3 100 2300X Market St 8 11 1 2   04/01/1993 12:00:00 AM 36 10   6002574.775 2106170.8945 37.7632894694666 -122.43426344933201 (37.7632894694666, -122.434263449332)
20414 25529 3 100 2300X Market St 4 11 1 2   04/01/1993 12:00:00 AM 36 10   6002679.8435 2106267.4439 37.7635605336875 -122.43390695394699 (37.7635605336875, -122.433906953947)
20422 24978 3 100 270 Dolores St 5 11 1 2     90 20   6004857.55515 2106727.96369 37.764948352008 -122.42640772573601 (37.764948352008, -122.426407725736)
20452 24966 3 100 100 Dolores St 7 11 1 2     90 20   6004812.73188 2107584.41194 37.76729741985871 -122.426623750096 (37.7672974198587, -122.426623750096)
20528 5557 3 100 977 Dolores St 1 1 1 2   10/26/2006 12:00:00 AM 32 3x3   6005125.10547 2102657.90315 37.753788045101 -122.42519270209499 (37.753788045101, -122.425192702095)
20599 25518 3 100 2100X Market St 5 11 1 2   04/01/1993 12:00:00 AM 36 10   6003909.9867 2107446.2105 37.7668668744555 -122.429736358347 (37.7668668744555, -122.429736358347)
20628 25499 3 100 1745X Market St 4 11 1 2   04/01/1993 12:00:00 AM 24 20   6005915.63153 2109374.76445 37.772275590069796 -122.42293623203999 (37.7722755900698, -122.42293623204)
20630 24974 3 100 200 Dolores St 1 11 1 2     90 20   6004833.67989 2107139.93189 37.7660781684855 -122.426519640982 (37.7660781684855, -122.426519640982)
20678 25137 3 100 1700X Dolores St 3 11 1 2     90 20   6005325.6404800005 2098301.13362 37.7418366828201 -122.424189377061 (37.7418366828201, -122.424189377061)
20697 24979 3 100 270 Dolores St 6 11 1 2     90 20   6004857.886419999 2106701.08852 37.7648745779366 -122.426404666261 (37.7648745779366, -122.426404666261)
20703 24999 3 100 400X Dolores St 4 11 1 2     90 20   6004906.6428 2105904.72298 37.7626907038434 -122.42617933032899 (37.7626907038434, -122.426179330329)
20710 24340 3 100 2000X Market St 4 11 1 2   05/07/1993 12:00:00 AM 36 8   6004586.5088 2108095.7522 37.7686886449818 -122.42744265544201 (37.7686886449818, -122.427442655442)
20716 25082 3 100 1200X Dolores St 2 11 1 2     90 20   6005158.72228 2101250.83835 37.7499264704292 -122.424976344106 (37.7499264704292, -122.424976344106)
20762 25074 3 100 1100X Dolores St 5 11 1 2     70 20   6005132.37065 2101712.1567700002 37.751191655576 -122.425100289545 (37.751191655576, -122.425100289545)
20790 25095 3 100 1300 Dolores St 5 11 1 2     80 20   6005196.77931 2100544.39428 37.7479888873864 -122.424794489489 (37.7479888873864, -122.424794489489)
20817 25112 3 100 1450 Dolores St 5 11 1 2     90 20   6005235.506709999 2099747.61613 37.7458033045753 -122.42460390154699 (37.7458033045753, -122.424603901547)
20879 25092 3 100 1300 Dolores St 2 11 1 2     80 20   6005189.02223 2100681.47449 37.7483648399821 -122.424831064022 (37.7483648399821, -122.424831064022)
20892 25110 3 100 1450 Dolores St 3 11 1 2     90 20   6005236.31225 2099800.23492 37.7459478292265 -122.42460485845301 (37.7459478292265, -122.424604858453)
20929 25087 3 100 1250X Dolores St 2 11 1 2     90 20   6005179.035519999 2100967.22192 37.7491488725392 -122.42488592444401 (37.7491488725392, -122.424885924444)
20932 5679 1 100 1470 Dolores St 1 1 1 1   12/08/2003 12:00:00 AM 6 3x3   6005190.57812 2099817.1721900003 37.7459917521253 -122.424764205708 (37.7459917521253, -122.424764205708)
20953 25048 3 100 900X Dolores St 3 11 1 2     30 20   6005066.31799 2102985.06573 37.7546830360144 -122.425419283594 (37.7546830360144, -122.425419283594)
21135 25089 3 100 1250X Dolores St 4 11 1 2     90 20   6005180.26353 2100884.10883 37.748920732509 -122.424875765702 (37.748920732509, -122.424875765702)
21187 25519 3 100 2100X Market St 6 11 1 2   04/01/1993 12:00:00 AM 36 10   6003894.4866 2107428.3854 37.7668170533219 -122.42978869913401 (37.7668170533219, -122.429788699134)
21228 5457 3 100 581 Dolores St 1 1 1 2     5 8   6004998.45452 2104996.17843 37.760201244618294 -122.42579711395099 (37.7602012446183, -122.425797113951)
21311 25022 3 100 700X Dolores St 7 11 1 2     70 20   6004995.79572 2104126.38242 37.75781283950229 -122.425744399279 (37.7578128395023, -122.425744399279)
21387 25517 3 100 2190X Market St 4 11 1 2   04/01/1993 12:00:00 AM 36 10   6003660.4353 2107205.9591 37.7661930680529 -122.43058237071199 (37.7661930680529, -122.430582370712)
21388 25107 3 100 1400X Dolores St 7 11 1 2     70 20   6005229.6240300005 2099972.88313 37.7464215039571 -122.424640264758 (37.7464215039571, -122.424640264758)
21419 25138 3 100 1700X Dolores St 4 11 1 2     90 20   6005319.278030001 2098285.9295200002 37.7417945765605 -122.424210295287 (37.7417945765605, -122.424210295287)
21421 25497 3 100 1745X Market St 2 11 1 2   04/01/1993 12:00:00 AM 24 20   6005883.25661 2109339.92737 37.7721781089695 -122.42304574337099 (37.7721781089695, -122.423045743371)
21445 25496 3 100 1745X Market St 1 11 1 2   04/01/1993 12:00:00 AM 24 20   6005866.13841 2109325.7941099997 37.772138336447 -122.42310395199499 (37.772138336447, -122.423103951995)
21453 25004 3 100 400X Dolores St 10 11 1 2     60 20   6004910.30478 2105777.27345 37.762340964691504 -122.42615759100599 (37.7623409646915, -122.426157591006)
21462 25153 3 100 50X Dolores St 1 11 1 2     90 20   6004788.48534 2107965.7019599997 37.768342979778204 -122.426734771418 (37.7683429797782, -122.426734771418)
21503 25093 3 100 1300 Dolores St 3 11 1 2     80 20   6005193.32199 2100633.40551 37.7482330964805 -122.424812776293 (37.7482330964805, -122.424812776293)
21512 25120 3 100 1550 Dolores St 1 11 1 2     90 20   6005269.99247 2099258.02767 37.744460954018 -122.424449836913 (37.744460954018, -122.424449836913)
21602 25126 3 100 1650X Dolores St 2 11 1 2     40 20   6005303.102530001 2098649.37036 37.7427915892743 -122.424292067924 (37.7427915892743, -122.424292067924)
21632 25036 3 100 750X Dolores St 5 11 1 2     90 20   6005017.04415 2103831.36773 37.7570039991458 -122.42564991650801 (37.7570039991458, -122.425649916508)
21636 24991 3 100 340 Dolores St 2 11 1 2     90 20   6004880.84753 2106292.81252 37.763754847342206 -122.42629617923299 (37.7637548473422, -122.426296179233)
21721 25072 3 100 1100X Dolores St 3 11 1 2     80 20   6005130.36391 2101800.2565200003 37.751433443721 -122.425113497011 (37.751433443721, -122.425113497011)
21723 25536 3 100 2200X Market St 2 11 1 2   04/01/1993 12:00:00 AM 36 20   6003342.0906 2106904.3991 37.7653470177984 -122.43166193058599 (37.7653470177984, -122.431661930586)
21747 25537 3 100 2200X Market St 3 11 1 2   04/01/1993 12:00:00 AM 36 20   6003301.0095 2106860.3121 37.7652236369165 -122.43180087233601 (37.7652236369165, -122.431800872336)
21757 25064 3 100 1000X Dolores St 7 11 1 2     40 20   6005102.4225699995 2102227.07793 37.7526038178156 -122.425240490271 (37.7526038178156, -122.425240490271)
21853 25535 3 100 2200X Market St 1 11 1 2   04/01/1993 12:00:00 AM 36 20   6003362.1302 2106920.4307 37.765392172561796 -122.431593762963 (37.7653921725618, -122.431593762963)
21855 25111 3 100 1450 Dolores St 4 11 1 2     90 20   6005242.59316 2099769.2409599996 37.745863081619895 -122.424580935573 (37.7458630816199, -122.424580935573)
21891 25037 3 100 800X Dolores St 1 11 1 2     90 20   6005031.31461 2103614.04185 37.7564080795924 -122.425585096976 (37.7564080795924, -122.425585096976)
21915 25502 3 100 1900X Market St 2 11 1 2   04/01/1993 12:00:00 AM 36 8   6005183.0311 2108665.831 37.7702876647003 -122.425419904307 (37.7702876647003, -122.425419904307)
21959 25083 3 100 1200X Dolores St 3 11 1 2     90 20   6005162.35719 2101213.31575 37.74982364735521 -122.424961105075 (37.7498236473552, -122.424961105075)
21974 25530 3 100 2300X Market St 5 11 1 2   04/01/1993 12:00:00 AM 36 10   6002661.3855 2106250.4058 37.7635127037236 -122.433969576289 (37.7635127037236, -122.433969576289)
21980 27480 3 100 400X Dolores St 9 11 1 2   10/04/1999 12:00:00 AM 70 20   6004900.72353 2105815.65161 37.7624458004571 -122.426193461385 (37.7624458004571, -122.426193461385)
21986 25118 3 100 1500X Dolores St 5 11 1 2     90 20   6005257.61936 2099436.85892 37.74495128509079 -122.42450533857 (37.7449512850908, -122.42450533857)
22009 24961 3 100 100 Dolores St 1 11 1 2   04/21/2005 12:00:00 AM 90 20   6004800.95891 2107734.51921 37.76770891277079 -122.42667516163999 (37.7677089127708, -122.42667516164)
22015 25539 3 100 2200X Market St 5 11 1 2   04/01/1993 12:00:00 AM 36 20   6003230.8711 2106796.1855 37.7650435846647 -122.432038884515 (37.7650435846647, -122.432038884515)
22048 25106 3 100 1450X Dolores St 6 11 1 2     90 20   6005241.17775 2099713.8788799997 37.74571099007721 -122.424581892451 (37.7457109900772, -122.424581892451)
22064 25150 3 100 50X Dolores St 3 11 1 2     12 20   6004790.11345 2107911.6189 37.7681945727608 -122.42672528803699 (37.7681945727608, -122.426725288037)
22145 25515 3 100 2100X Market St 2 11 1 2   04/01/1993 12:00:00 AM 36 10   6004020.8124 2107556.2611 37.767175321793 -122.429360878869 (37.767175321793, -122.429360878869)
22227 25067 3 100 1000X Dolores St 10 11 1 2     40 20   6005110.57075 2102123.34784 37.7523194593995 -122.425204931964 (37.7523194593995, -122.425204931964)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
23525 187316 2 100 2200 Sunset Blvd 1 9 1 1     11 Width 0ft   5985075.4607 2099608.8478 37.744263118481705 -122.494303219592 (37.7442631184817, -122.494303219592)
23714 234376 2 100 1750 Harrison St 2 4 1 1     6 Width 2ft   6008587.75214 2108113.66978 37.7689633348285 -122.41360388622499 (37.7689633348285, -122.413603886225)
23789 234390 2 100 1600 Dolores St 2 1 1 1     5 Width 6ft   6005245.617219999 2098983.50062 37.7437057887861 -122.42451459797199 (37.7437057887861, -122.424514597972)
Powered by Datasette · Query took 9.755ms · Data source: data.sfgov.org