sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
145407 27787 1 100 199X The Embarcadero 4 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
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)
144953 26025 1 100 599X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
144869 26027 1 100 599X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
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)
144442 26021 1 100 899X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
144240 27945 1 100 999 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
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)
143978 27298 1 71 7800X Geary Blvd 5 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413)
143792 27934 1 100 799 The Embarcadero 6 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
142949 25680 1 100 350X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
142246 25740 1 100 801X The Embarcadero 5 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
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)
141929 27794 1 127 199X The Embarcadero 11 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
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)
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)
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)
140643 27786 1 100 199X The Embarcadero 3 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
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)
140237 26020 1 100 899X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
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)
140032 25632 1 100 650X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
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)
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)
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)
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)
138363 25645 1 100 550X The Embarcadero 3 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
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)
128765 99475 1 60 650X Miramar Ave 1 11 1 1   04/18/2014 12:00:00 AM 44 15x280 Permit Number 772553 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
128560 26023 1 100 899X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
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)
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)
128307 25736 1 100 801X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
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)
128206 27931 1 100 799 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
127947 26028 1 100 599X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
127945 25787 1 100 800X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012271.38601 2120709.8440099997 37.803755634424206 -122.401747862284 (37.8037556344242, -122.401747862284)
127804 25792 1 100 800X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6012611.22901 2120208.54201 37.802398139421705 -122.400536574048 (37.8023981394217, -122.400536574048)
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)
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)
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)
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)
126813 25644 1 100 550X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
126593 26022 1 100 899X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
126250 26096 1 100 499X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 10   6013385.9217822 2119009.0450001 37.7991477810775 -122.397771551765 (37.7991477810775, -122.397771551765)
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)
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)
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)
125804 25634 1 100 650X The Embarcadero 3 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
125734 25647 1 100 550X The Embarcadero 5 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
125546 27294 1 71 7800X Geary Blvd 1 11 1 11   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.77924621575129 -122.503283404585 (37.7792462157513, -122.503283404585)
125282 27867 1 100 800 The Embarcadero 2 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6014979.71901 2116870.00001 37.7933630896865 -122.392106753362 (37.7933630896865, -122.392106753362)
124284 26018 1 100 899X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
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)
123638 27929 1 100 799 The Embarcadero 1 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
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)
123015 25788 1 100 800X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012327.37501 2120629.11501 37.8035370964877 -122.401548430804 (37.8035370964877, -122.401548430804)
122780 99495 1 60 1400X Plymouth Ave 2 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
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)
120825 25789 1 100 800X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6012378.15701 2120553.5940099997 37.8033325675946 -122.40136738582899 (37.8033325675946, -122.401367385829)
120310 27785 1 100 199X The Embarcadero 2 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
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)
120030 25794 1 100 800X The Embarcadero 8 11 1 9   08/30/1996 12:00:00 AM 36 10   6012712.79201 2120057.50001 37.8019890781012 -122.40017449968501 (37.8019890781012, -122.400174499685)
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)
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)
119621 26019 1 100 899X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
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)
118985 25791 1 100 800X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6012561.75001 2120285.36501 37.802606317276 -122.40071319691499 (37.802606317276, -122.400713196915)
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)
118808 25681 1 100 350X The Embarcadero 5 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
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)
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)
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)
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)
117942 25633 1 100 650X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
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)
117750 25678 1 100 350X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
114920 25677 1 100 350X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
114765 27804 1 100 550X The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
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)
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)
114362 25635 1 100 650X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
114112 27296 1 71 7800X Geary Blvd 3 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.7930900003 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232)
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)
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)
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)
113255 25643 1 100 550X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
Powered by Datasette · Query took 34.938ms · Data source: data.sfgov.org