sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14379 48480 1 17   1 11 1 1         Permit Number 45832          
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
123608 28026 1 100 100 The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014253.80701 2117776.67601 37.795812278914 -122.39468200241699 (37.795812278914, -122.394682002417)
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)
142211 28029 1 100 100 The Embarcadero 9 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014304.80501 2117713.7420099997 37.7956423121436 -122.394501129585 (37.7956423121436, -122.394501129585)
144979 28028 1 100 100 The Embarcadero 8 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014289.61401 2117737.61301 37.7957070117951 -122.394555365911 (37.7957070117951, -122.394555365911)
118559 3686 1 5 100X Cargo Way 1 11 1 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
127755 83007 1 457 1058 De Haro St 1 11 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
104698 27952 1 15 107X The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
106951 27956 1 15 107X The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
108807 27718 1 15 107X The Embarcadero 1 11 1 9   09/11/2000 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
114418 27957 1 15 107X The Embarcadero 7 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
128222 27953 1 15 107X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
140645 27955 1 15 107X The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
145142 27954 1 15 107X The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
5785 25798 1 100 1100X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012871.9305 2119823.23547 37.801354716114 -122.39960734420201 (37.801354716114, -122.399607344202)
103830 27697 1 100 1100X The Embarcadero 2 11 1 9     36 10   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
81176 27963 1 100 1101X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
105106 25746 1 100 1101X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
111083 25747 1 100 1101X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
4067 25799 1 100 1300X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525)
107397 25804 1 100 1300X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
109799 25803 1 100 1300X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
112807 25802 1 100 1300X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
116990 25800 1 100 1300X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
140551 25801 1 100 1300X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
69372 25749 1 100 1301X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
89841 25748 1 100 1301X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
101776 25752 1 100 1301X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
112942 25754 1 100 1301X The Embarcadero 7 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
117219 25750 1 100 1301X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
141888 25751 1 100 1301X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
146321 25753 1 100 1301X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
78674 99497 1 180 1400X Plymouth Ave 4 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
83274 99496 1 60 1400X Plymouth Ave 3 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
87404 99494 1 60 1400X Plymouth Ave 1 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
122780 99495 1 60 1400X Plymouth Ave 2 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
86095 103414 1 180 1490X Plymouth Ave 1 11 1 1   04/18/2013 12:00:00 AM     Permit Number 770026 5995919.3 2094026.5 37.7295639775589 -122.456404198854 (37.7295639775589, -122.456404198854)
89834 27792 1 127 199X The Embarcadero 9 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
91142 28372 1 100 199X The Embarcadero 1 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
101242 27788 1 100 199X The Embarcadero 5 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
101933 27789 1 127 199X The Embarcadero 6 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
104599 27791 1 127 199X The Embarcadero 8 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
112303 27790 1 127 199X The Embarcadero 7 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
113231 27793 1 127 199X The Embarcadero 10 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
120310 27785 1 100 199X The Embarcadero 2 11 1 9     18     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)
141929 27794 1 127 199X The Embarcadero 11 11 1 9     12     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)
99473 3689 1 5 200X Cargo Way 3 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127580 3691 1 5 200X Cargo Way 5 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127726 3690 1 5 200X Cargo Way 4 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
128521 3688 1 5 200X Cargo Way 2 11 1 9     18 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
140153 3687 1 5 200X Cargo Way 1 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
125989 87027 1 302 23 Magellan Ave 1 11 1 1       3x3 Permit Number 49971 5994623.4 2101166.9 37.74909526366879 -122.461401658799 (37.7490952636688, -122.461401658799)
117426 106344 1 7 2428 14th Ave 1 11 1 1   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922)
144189 106345 1 7 2428 14th Ave 2 11 1 1   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922)
91320 107140 1 80 250X Roosevelt Way   11 1 1   08/01/2014 12:00:00 AM   5x5 Permit Number 773751 6000794.71275 2107196.95489 37.766005582708395 -122.440493678393 (37.7660055827084, -122.440493678393)
90111 27847 1 100 280 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
99547 27845 1 100 280 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
100729 27843 1 100 280 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105556 27842 1 100 280 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105677 27827 1 100 280 The Embarcadero 1 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
110061 27844 1 100 280 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
115875 27841 1 100 280 The Embarcadero 2 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
118319 27846 1 100 280 The Embarcadero 7 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
82090 27775 1 100 299X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
87650 27777 1 100 299X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
96124 27767 1 100 299X The Embarcadero 1 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
100132 27778 1 100 299X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
121752 27776 1 100 299X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
139415 27774 1 100 299X The Embarcadero 2 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
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)
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)
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)
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)
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)
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)
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)
112766 92207 1 143 300X Miramar Ave 1 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
99750 92208 1 60 300x Miramar Ave 2 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
100266 92210 1 143 300x Miramar Ave 4 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
112226 92209 1 60 300x Miramar Ave 3 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
128923 92212 1 17 300x Miramar Ave 6 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
139081 92211 1 60 300x Miramar Ave 5 11 1 1   12/29/2010 12:00:00 AM   2x2 Permit Number 54064 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
98538 98820 1 47 302X Pacheco St 28 11 1 1   05/09/2010 12:00:00 AM     Permit Number 768820 5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
Powered by Datasette · Query took 78.965ms · Data source: data.sfgov.org