sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
81526 103927 3 100 100 The Embarcadero 13 11 1 2   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186)
127400 119700 3 100 6x Octavia St Frontage West 2 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
138316 119699 3 100 6x Octavia St Frontage West 1 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
140592 26537 3 100 794X Dolores St 4 11 1 2   06/23/1997 12:00:00 AM   20   6004985.41588 2103704.6857762 37.7566543729812 -122.425750282521 (37.7566543729812, -122.425750282521)
78381 23674 3 100 319 Virginia Ave 3 11 1 2     3 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
18142 13388 3 100 218 Marietta Dr 1 11 1 2     6 5   5997667.5215300005 2098758.8322 37.7426580336411 -122.45070150968999 (37.7426580336411, -122.45070150969)
14049 18560 3 100 1700X Quesada Ave 15 11 1 2     12 19   6014546.06488 2095149.2171099999 37.7336984729967 -122.392087539714 (37.7336984729967, -122.392087539714)
16768 18555 9 100 1700X Quesada Ave 10 11 1 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
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)
78875 27848 1 100 100 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
78913 25684 1 100 100 The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
85028 18558 3 100 1700X Quesada Ave 13 11 1 2     12 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
86395 18554 3 100 1700X Quesada Ave 9 11 1 2     12 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
109189 27850 1 100 100 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015895.51701 2112292.73501 37.7808457639334 -122.38861833648701 (37.7808457639334, -122.388618336487)
117445 27852 1 100 100 The Embarcadero 7 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015817.39201 2112182.05801 37.780537539741395 -122.388880882265 (37.7805375397414, -122.388880882265)
120266 27849 1 100 100 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015921.55801 2112354.58401 37.7810170305764 -122.388532565578 (37.7810170305764, -122.388532565578)
126124 25683 1 100 100 The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015960.62101 2112553.15201 37.781564418481004 -122.388411289639 (37.781564418481, -122.388411289639)
139779 27853 1 100 100 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015772.90401 2112134.31501 37.780403982219205 -122.389031454309 (37.7804039822192, -122.389031454309)
139983 27851 1 100 100 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015857.5390099995 2112236.31101 37.7806887314792 -122.388745782008 (37.7806887314792, -122.388745782008)
101242 27788 1 100 199X The Embarcadero 5 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
140643 27786 1 100 199X The Embarcadero 3 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
145407 27787 1 100 199X The Embarcadero 4 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
724 25734 1 100 500X The Embarcadero 4 11 1 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
1312 25735 1 100 500X The Embarcadero 5 11 1 9   08/15/1996 12:00:00 AM 16 10   6013816.07307 2118422.78251 37.7975619881486 -122.396241959692 (37.7975619881486, -122.396241959692)
78576 25731 1 100 501X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
112637 25732 1 100 501X The Embarcadero 2 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
124202 25733 1 100 501X The Embarcadero 3 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
30035 194392 3 100 860x Jamestown Ave 5 11 1 2     17 Width 5ft   6014755.052209999 2089115.5775900001 37.7171429037943 -122.39094345187799 (37.7171429037943, -122.390943451878)
77513 27958 1 100 307X The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
79708 27959 1 100 307X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
91142 28372 1 100 199X The Embarcadero 1 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
93856 27960 1 100 307X The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
101121 27717 1 100 307X The Embarcadero 1 11 1 9   09/11/2000 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
118074 27961 1 100 307X The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
120310 27785 1 100 199X The Embarcadero 2 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
140710 27962 1 100 307X The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
151174 194393 3 100 860x Jamestown Ave 9 11 1 2     18 Width 5ft   6014647.11529 2089218.63866 37.7174198994758 -122.391323741894 (37.7174198994758, -122.391323741894)
32439 194391 3 100 828x Jamestown Ave 4 11 1 2     19 Width 5ft   6014866.8225 2088973.5540099998 37.7167591360948 -122.39054719349899 (37.7167591360948, -122.390547193499)
41784 194394 3 100 920x Jamestown Ave 4 11 1 2     19 Width 5ft   6014490.42947 2089308.0420799998 37.717656686497506 -122.39187158462799 (37.7176566864975, -122.391871584628)
111571 27784 1 100 399X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 20     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
121202 27482 3 100 990X Dolores St 2 11 1 2   10/20/1999 12:00:00 AM 20 20   6005038.29077 2102581.9809991 37.7535746757806 -122.425487524624 (37.7535746757806, -122.425487524624)
172221 245963 3 100 1950x Market St 1 11 1 2     20 Width 0ft   6005062.3371 2108554.2304 37.7699744164919 -122.425829439833 (37.7699744164919, -122.425829439833)
183995 194395 3 100 920x Jamestown Ave 9 11 1 2     20 Width 5ft   6014427.53162 2089348.9061599998 37.7177653992236 -122.392091851971 (37.7177653992236, -122.392091851971)
58367 132070 3 100 1000x The Embarcadero 1 11 1 2     23 Width 5ft   6013297.802519999 2119184.84583 37.7996255806051 -122.39808881644501 (37.7996255806051, -122.398088816445)
18337 25498 3 100 1745X Market St 3 11 1 2   04/01/1993 12:00:00 AM 24 20   6005901.64349 2109360.28288 37.7722350378549 -122.422983588528 (37.7722350378549, -122.422983588528)
18585 25121 3 100 1500 Dolores St 2 11 1 2     24 20   6005252.19486 2099522.95164 37.745187369700105 -122.424530218294 (37.7451873697001, -122.424530218294)
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)
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)
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)
44570 27941 1 100 699 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
76348 27944 1 100 999 The Embarcadero 1 11 1 9     24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
77877 28025 1 100 100 The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014170.25601 2117873.24701 37.796072794607895 -122.39497787369301 (37.7960727946079, -122.394977873693)
78230 27930 1 100 799 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
78636 28030 1 100 100 The Embarcadero 10 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014322.16601 2117689.8700099997 37.795577730351205 -122.39443938464899 (37.7955777303512, -122.394439384649)
81297 28024 1 100 100 The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014145.300009999 2117911.2250099997 37.7961756855245 -122.39506688844999 (37.7961756855245, -122.39506688845)
81328 25745 1 100 801X The Embarcadero 10 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
82580 28021 1 100 100 The Embarcadero 1 11 1 9   02/05/2001 12:00:00 AM 24 4x4   6014080.19501 2118017.56101 37.796464038519396 -122.39529961933201 (37.7964640385194, -122.395299619332)
83420 27948 1 100 999 The Embarcadero 5 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
86291 25738 1 100 801X The Embarcadero 3 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
87718 96830 3 100 650X Dolores St 5 11 1 2     24 20x225   6004936.0 2104486.3 37.7587977092663 -122.425976818319 (37.7587977092663, -122.425976818319)
89908 27997 1 100 300 The Embarcadero 1 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
91110 27949 1 100 999 The Embarcadero 6 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
92133 27942 1 100 699 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
92364 27782 1 100 399X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
92652 27780 1 100 399X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
92971 28023 1 100 100 The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 24 4x4   6014119.25801 2117944.86201 37.7962665966149 -122.395159357042 (37.7962665966149, -122.395159357042)
94674 27870 1 100 800 The Embarcadero 5 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6015155.50001 2116672.0830099997 37.79282941355329 -122.391484690649 (37.7928294135533, -122.391484690649)
94898 28032 1 100 100 The Embarcadero 12 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014349.29301 2117643.21201 37.7954511263865 -122.394342251353 (37.7954511263865, -122.394342251353)
95346 96821 3 100 610X Dolores St 1 11 1 2     24 20x225   6004926.4 2104659.4 37.7592724584905 -122.426022342006 (37.7592724584905, -122.426022342006)
95434 27933 1 100 799 The Embarcadero 5 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
98209 25737 1 100 801X The Embarcadero 2 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
98325 27947 1 100 999 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
101160 25742 1 100 801X The Embarcadero 7 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
102648 28027 1 100 100 The Embarcadero 7 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014263.57201 2117754.9750099997 37.795753235969 -122.394646693031 (37.795753235969, -122.394646693031)
104366 28002 1 100 300 The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
104388 28031 1 100 100 The Embarcadero 11 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014334.10201 2117669.25401 37.7955217871698 -122.394396639485 (37.7955217871698, -122.394396639485)
104498 25741 1 100 801X The Embarcadero 6 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
106008 28003 1 100 300 The Embarcadero 7 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
106831 27951 1 100 999 The Embarcadero 8 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
107611 28000 1 100 300 The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
109422 27866 1 100 800 The Embarcadero 1 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6014921.77607 2116935.19701 37.793538888238395 -122.39231180375 (37.7935388882384, -122.39231180375)
110274 96826 3 100 650X Dolores St 1 11 1 2     24 20x225   6004936.0 2104486.3 37.7587977092663 -122.425976818319 (37.7587977092663, -122.425976818319)
111881 27998 1 100 300 The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
112720 27781 1 100 399X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
113256 25744 1 100 801X The Embarcadero 9 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
113720 25743 1 100 801X The Embarcadero 8 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
113929 25012 3 100 500X Dolores St 6 11 1 2     24 20   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
114665 27950 1 100 999 The Embarcadero 7 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
114962 27698 1 100 801X The Embarcadero 11 11 1 9     24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
115229 27932 1 100 799 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
115397 28022 1 100 100 The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014106.23701 2117977.41401 37.796355252616294 -122.39520669408002 (37.7963552526163, -122.39520669408)
115406 27868 1 100 800 The Embarcadero 3 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6015038.31301 2116806.19801 37.793191157262704 -122.39189954881 (37.7931911572627, -122.39189954881)
116513 27946 1 100 999 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
117908 28001 1 100 300 The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
118260 96823 3 100 610X Dolores St 3 11 1 2     24 20x225   6004926.4 2104659.4 37.7592724584905 -122.426022342006 (37.7592724584905, -122.426022342006)
118790 27869 1 100 800 The Embarcadero 4 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6015100.81301 2116738.49001 37.7930087163181 -122.39167855690701 (37.7930087163181, -122.391678556907)
118856 25739 1 100 801X The Embarcadero 4 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
119199 27935 1 100 799 The Embarcadero 7 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
119973 27999 1 100 300 The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709)
120022 27940 1 100 699 The Embarcadero 1 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
Powered by Datasette · Query took 30.816ms · Data source: data.sfgov.org