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          
19496 34866 1 41 579 Miramar Ave 1 11 1 1 1 12/29/2015 12:00:00 AM     Permit Number 775311 5995338.59696042 2093168.95782094 37.7271760192259 -122.458349689476 (37.7271760192259, -122.458349689476)
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)
72222 87818 1 180 85 Mendosa Ave 1 11 1 1   06/04/2008 12:00:00 AM     Permit Number 50680 5993356.0 2100787.0 37.747979128324 -122.46575670711701 (37.747979128324, -122.465756707117)
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)
78674 99497 1 180 1400X Plymouth Ave 4 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
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)
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)
83274 99496 1 60 1400X Plymouth Ave 3 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
84036 27864 1 15 900X The Embarcadero 5 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
84835 86968 1 17 3250 Van Ness Ave 1 11 1 1   10/27/2007 12:00:00 AM     Permit Number 49934 6005499.7 2121504.7 37.8055578865418 -122.42523827370701 (37.8055578865418, -122.425238273707)
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)
87404 99494 1 60 1400X Plymouth Ave 1 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
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)
89385 27863 1 15 900X The Embarcadero 4 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
89834 27792 1 127 199X The Embarcadero 9 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
90241 27861 1 15 900X The Embarcadero 2 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
91142 28372 1 100 199X The Embarcadero 1 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
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)
94947 27865 1 15 900X The Embarcadero 6 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
110146 27862 1 15 900X The Embarcadero 3 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
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)
112303 27790 1 127 199X The Embarcadero 7 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
113231 27793 1 127 199X The Embarcadero 10 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
113986 115182 1 51 315 Lakeshore Dr 1 11 1 1   01/15/2016 12:00:00 AM     Permit Number 775158 5983956.6 2095109.9 37.7318446842931 -122.497839799214 (37.7318446842931, -122.497839799214)
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)
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)
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)
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)
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)
120310 27785 1 100 199X The Embarcadero 2 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
122780 99495 1 60 1400X Plymouth Ave 2 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
125860 27766 1 100 399X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
127099 27943 1 100 699 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
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)
128446 27860 1 15 900X The Embarcadero 1 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
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)
140517 86969 1 17 3250 Van Ness Ave 2 11 1 1   10/27/2007 12:00:00 AM     Permit Number 49934 6005499.7 2121504.7 37.8055578865418 -122.42523827370701 (37.8055578865418, -122.425238273707)
140643 27786 1 100 199X The Embarcadero 3 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
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)
140893 27783 1 100 399X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
141929 27794 1 127 199X The Embarcadero 11 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
144544 27779 1 100 399X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
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)
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)
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)
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)
6093 26031 1 100 450X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 10   6014122.12078 2117941.0950599997 37.7962564126589 -122.39514918719999 (37.7962564126589, -122.3951491872)
6748 26030 1 100 450X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 10   6014150.34723 2117905.1373099997 37.796159250800294 -122.395048997307 (37.7961592508003, -122.395048997307)
7108 25783 1 100 500X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6013938.98446 2118296.9177 37.7972232315271 -122.39580782638599 (37.7972232315271, -122.395807826386)
7340 25782 1 100 500X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 36 10   6013997.3565 2118221.08563 37.7970182616509 -122.395600527244 (37.7970182616509, -122.395600527244)
8987 25784 1 100 500X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6013869.26975 2118339.24702 37.797335579338004 -122.396052026484 (37.797335579338, -122.396052026484)
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)
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)
78155 25795 1 100 800X The Embarcadero 9 11 1 9   08/30/1996 12:00:00 AM 36 10   6012764.87501 2119980.6770099998 37.80178104459689 -122.39998886869199 (37.8017810445969, -122.399988868692)
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)
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)
80104 25796 1 100 800X The Embarcadero 10 11 1 9   08/30/1996 12:00:00 AM 36 10   6012816.959009999 2119901.25001 37.80156586089179 -122.399803052325 (37.8015658608918, -122.399803052325)
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)
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)
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)
86502 25797 1 100 800X The Embarcadero 11 11 1 9   08/30/1996 12:00:00 AM 36 10   6012870.34401 2119824.4270099998 37.801357899362394 -122.399612917904 (37.8013578993624, -122.399612917904)
87172 26029 1 100 499X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 10   6013385.9217822 2119009.0450001 37.7991477810775 -122.397771551765 (37.7991477810775, -122.397771551765)
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)
91779 26017 1 100 899X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
92465 26024 1 100 899X The Embarcadero 8 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
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)
96132 25786 1 100 500X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213273997 37.7992817461076 -122.39756784649201 (37.7992817461076, -122.397567846492)
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)
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)
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)
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)
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)
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)
107210 25790 1 100 800X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6012501.85401 2120373.90601 37.8028460885889 -122.400926692934 (37.8028460885889, -122.400926692934)
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)
108921 25793 1 100 800X The Embarcadero 7 11 1 9   08/30/1996 12:00:00 AM 36 10   6012660.709009999 2120133.02101 37.802193536328 -122.40036004021499 (37.802193536328, -122.400360040215)
Powered by Datasette · Query took 80.386ms · Data source: data.sfgov.org