sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1485 115988 1 30 499 Jackson St 3 1 1 1   06/09/2016 12:00:00 AM 3 3x3 Permit Number 777967 6011781.45666 2118040.71778 37.7963995082912 -122.40325542520901 (37.7963995082912, -122.403255425209)
3030 224462 4 30 2810 26th St 2 1 1 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.40714655877301 (37.7497653433983, -122.407146558773)
3035 240686 4 30 2810 26th St 1 1 1 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.749767577309605 -122.40709853768499 (37.7497675773096, -122.407098537685)
5667 102263 2 30 2037 Pierce St 1 1 1 1     5 3x3   6001878.76288 2115606.3786400002 37.78915741351871 -122.437346392945 (37.7891574135187, -122.437346392945)
5887 94203 1 30 1000 Green St 2 1 1 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008148.35783 2118956.03523 37.7987091687558 -122.415891605907 (37.7987091687558, -122.415891605907)
6585 44092 1 30 2200 Sacramento St 2 1 1 1   11/01/2000 12:00:00 AM 8 3x3 Permit Number 43607 6004180.10381 2116042.60341 37.790485736467296 -122.429415161181 (37.7904857364673, -122.429415161181)
7288 111098 1 30 754 Post St 1 1 1 1   05/20/2015 12:00:00 AM 3 3x3   6008536.0762 2114905.536 37.78760928190211 -122.414263235869 (37.7876092819021, -122.414263235869)
10378 98180 1 30 622 Cambridge St 1 1 1 1   12/29/2011 12:00:00 AM 3 3x3 Permit Number 768099 6007169.16242 2091641.99398 37.7236560602499 -122.417343266399 (37.7236560602499, -122.417343266399)
14017 104025 2 30 716 Wisconsin St 1 1 1 1     16 3x3   6012687.87968 2104149.7182 37.7583085835989 -122.399143437016 (37.7583085835989, -122.399143437016)
16738 28934 1 30 260 08th St 1 1 1 1   02/11/2006 12:00:00 AM 3 3x3   6009412.25627 2110486.9627400003 37.775526107775704 -122.41091961406299 (37.7755261077757, -122.410919614063)
19126 89429 3 30 2608 Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990547.63767 2112005.7823900003 37.778620499636 -122.476287153711 (37.778620499636, -122.476287153711)
24787 56080 1 30 723 47th Ave 1 1 1 1   02/22/2011 12:00:00 AM 2 3x3 Permit Number 51743 5981333.03596 2110794.79787 37.774756814986794 -122.50807353876199 (37.7747568149868, -122.508073538762)
28685 99380 1 30 1590 Yosemite Ave 3 1 1 1   05/09/2012 12:00:00 AM 1 3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
29524 108754 2 30 200x Hester Ave 2 1 1 1     4 3x3   6012760.63999 2087707.7823400002 37.7131665099896 -122.397738543111 (37.7131665099896, -122.397738543111)
31094 87873 1 30 2341 Francisco St 1 1 1 1   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50845 6000097.31037 2119864.70248 37.8007482115146 -122.443816038389 (37.8007482115146, -122.443816038389)
33248 94086 1 30 1727 29th Ave 1 1 1 1   06/02/2010 12:00:00 AM 2 3x3 Permit Number 53469 5987161.9603 2103493.9012 37.7550523122054 -122.48737396285101 (37.7550523122054, -122.487373962851)
41714 115987 2 30 499 Jackson St 2 1 1 1     3 3x3   6011766.1004 2118039.4815599998 37.7963952562896 -122.40330847443 (37.7963952562896, -122.40330847443)
47584 97338 1 30 1917 Irving St 1 1 1 1     6 3x3   5989797.6411 2106487.0994 37.763424185107496 -122.478477988866 (37.7634241851075, -122.478477988866)
49968 89660 3 30 2849X Anza St 3 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989791.50971 2111922.56539 37.7783481307856 -122.47889677398099 (37.7783481307856, -122.478896773981)
59444 80749 1 30 375 Munich St 1 1 1 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52325 6004167.50654 2090267.3011900003 37.719712117607 -122.42762157938101 (37.719712117607, -122.427621579381)
62074 94211 1 30 465 Missouri St 6 1 1 1   06/22/2010 12:00:00 AM 3 3x3 Permit Number 53589 6013546.79092 2104912.40006 37.760450569952205 -122.39622637625799 (37.7604505699522, -122.396226376258)
62932 108753 2 30 200x Hester Ave 1 1 1 1     4 3x3   6012766.4768 2087726.3545799998 37.713217830719294 -122.397719670851 (37.7132178307193, -122.397719670851)
66258 101283 2 30 2001 Irving St 2 1 1 1     6 3x3   5989499.782000001 2106476.1919 37.7633769390525 -122.479507377657 (37.7633769390525, -122.479507377657)
67146 105243 1 30 616 Cambridge St 1 1 1 1   01/07/2014 12:00:00 AM 2 3x3 Permit Number 770335 6007163.0512 2091665.3874599999 37.723719949895 -122.417366048922 (37.723719949895, -122.417366048922)
67555 89658 3 30 2849X Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989742.13076 2111923.12979 37.7783468130036 -122.479067633531 (37.7783468130036, -122.479067633531)
68229 101282 2 30 2001 Irving St 1 1 1 1     7 3x3   5989468.7375 2106475.7724 37.7633739839128 -122.479614718585 (37.7633739839128, -122.479614718585)
70158 98192 2 30 1020 Green St 1 1 1 1     15 3x3   6008091.62981 2118948.72517 37.7986859077751 -122.41608738562799 (37.7986859077751, -122.416087385628)
70774 31727 1 30 2460 20th Ave 2 1 1 1 1 07/27/2011 12:00:00 AM 1 3x3 Permit Number 767614 5990175.918 2098661.7302 37.7419597410001 -122.476597940821 (37.7419597410001, -122.476597940821)
70856 122542 2 30 2233 Post St 2 1 1 1     3 3x3   6001449.1657 2113870.4558 37.784366584009206 -122.43870830313499 (37.7843665840092, -122.438708303135)
72581 89663 3 30 2827 Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989854.97314 2111927.2213 37.7783645996222 -122.47867757338301 (37.7783645996222, -122.478677573383)
76395 89691 3 30 2351 Anza St 2 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5991367.10083 2111979.26618 37.7785951812776 -122.47345040879401 (37.7785951812776, -122.473450408794)
78569 89433 3 30 2750X Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990101.1887300005 2111991.79472 37.7785561929756 -122.477830552774 (37.7785561929756, -122.477830552774)
78926 112621 2 30 226x HESTER AVE 1 1 1 1       3x3   6012667.0 2087636.0 37.712964194877294 -122.398057164184 (37.7129641948773, -122.398057164184)
79152 89072 3 30 578 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990352.95655 2111441.21881 37.7770590720957 -122.47691936106001 (37.7770590720957, -122.47691936106)
79857 89670 3 30 2643 Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990382.48871 2111946.2204400003 37.778447380347096 -122.476854108344 (37.7784473803471, -122.476854108344)
80995 81638 1 30 611 San Bruno Ave 1 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52388 6011631.16657043 2091602.57917757 37.7237978701092 -122.40191602971301 (37.7237978701092, -122.401916029713)
81167 89071 3 30 606 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990364.94891 2111219.79426 37.776451796946795 -122.476861693703 (37.7764517969468, -122.476861693703)
81513 102256 1 30 1933 Divisadero St 1 1 1 1   01/07/2013 12:00:00 AM 1 3x3 Permit Number 58594 6000840.6 2115080.7 37.787654962994104 -122.440900572101 (37.7876549629941, -122.440900572101)
81655 89431 3 30 2650 Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990408.549930001 2112000.5588 37.7785980902022 -122.476767924851 (37.7785980902022, -122.476767924851)
82382 89086 3 30 406 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990312.19916 2112568.90758 37.780153029212705 -122.47714277925199 (37.7801530292127, -122.477142779252)
82821 102559 2 30 1755X 04th St 6 1 1 1       3x3   6015173.7 2107354.9 37.767247536270204 -122.390770296702 (37.7672475362702, -122.390770296702)
83557 89117 3 30 727 18th Ave 1 1 1 2   04/21/2008 12:00:00 AM 3 3x3   5990344.4993 2110412.80162 37.774234830642705 -122.476873456227 (37.7742348306427, -122.476873456227)
83665 89055 3 30 788 18th Ave 2 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990404.298780001 2110035.18225 37.773201459979404 -122.476639007633 (37.7732014599794, -122.476639007633)
83785 89426 3 30 2550X Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990714.583219999 2112013.9673599997 37.7786526533285 -122.475710228678 (37.7786526533285, -122.475710228678)
83916 89107 3 30 659 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990326.6354 2110892.4923 37.775550893244294 -122.47697030809401 (37.7755508932443, -122.476970308094)
84911 89061 3 30 740 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990394.60611 2110329.10213 37.7740079212926 -122.476694013266 (37.7740079212926, -122.476694013266)
85475 89435 3 30 2750X Anza St 3 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990064.10708 2111990.80436 37.7785513215492 -122.477958758538 (37.7785513215492, -122.477958758538)
85766 89095 3 30 547 18th Ave 1 1 1 2   03/20/2008 12:00:00 AM 3 3x3   5990300.3364699995 2111641.2158 37.7776051560139 -122.477116006748 (37.7776051560139, -122.477116006748)
86108 89056 3 30 774 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990401.329059999 2110113.1437 37.7734153485371 -122.476654976983 (37.7734153485371, -122.476654976983)
87060 102564 2 30 1655X 04th St 4 1 1 1       3x3   6015154.2 2107704.9 37.768207477714896 -122.39086220831899 (37.7682074777149, -122.390862208319)
87859 89093 3 30 501X 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990291.48047 2111913.4147099997 37.7783520252361 -122.477166538778 (37.7783520252361, -122.477166538778)
88071 99759 2 30 4295x 25th St 3 1 1 1       3x3   6001974.5 2101167.2 37.7495164396885 -122.43598153971399 (37.7495164396885, -122.435981539714)
88920 89419 3 30 2300X Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5991532.05809 2112041.47431 37.778775538782796 -122.472884301267 (37.7787755387828, -122.472884301267)
88935 89118 3 30 767 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990353.59701 2110151.97769 37.7735192073496 -122.47682292511001 (37.7735192073496, -122.47682292511)
89037 89685 3 30 2439X Anza St 4 1 1 2   04/08/2008 12:00:00 AM 3 3x3   5991052.102419999 2111967.85185 37.7785455945924 -122.47453926483699 (37.7785455945924, -122.474539264837)
89224 89437 3 30 2840 Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989793.92088 2111979.6154 37.7785049142916 -122.47889260671002 (37.7785049142916, -122.47889260671)
89255 89080 3 30 498X 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990331.33174 2112032.1373799997 37.7786803168555 -122.477037357467 (37.7786803168555, -122.477037357467)
89315 99393 1 30 1590 Yosemite Ave 16 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
89862 99399 1 30 1590 Yosemite Ave 22 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
90993 108995 1 30 55 06th Ave 1 1 1 1 1 01/20/2015 12:00:00 AM 3 3x3 Permit Number 772985 5993924.20809 2115202.12337 37.787592019403704 -122.46483857455401 (37.7875920194037, -122.464838574554)
91083 89110 3 30 675 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990329.58522 2110790.11902 37.7752699754793 -122.476952622071 (37.7752699754793, -122.476952622071)
91285 89428 3 30 2600X Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990570.85 2112008.13119 37.778628294884896 -122.47620702578001 (37.7786282948849, -122.47620702578)
91731 83341 1 30 422-24 Noe St 1 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50786 6002931.20131858 2105783.16408091 37.762245079378 -122.433002986091 (37.762245079378, -122.433002986091)
92061 89659 3 30 2849X Anza St 2 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989777.3063199995 2111923.10549 37.7783487889755 -122.47894594776001 (37.7783487889755, -122.47894594776)
92272 89085 3 30 410 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990312.707669999 2112537.21644 37.78006604363139 -122.477138703582 (37.7800660436314, -122.477138703582)
92389 102561 2 30 1655X 04th St 1 1 1 1       3x3   6015154.2 2107704.9 37.768207477714896 -122.39086220831899 (37.7682074777149, -122.390862208319)
92557 89674 3 30 2605 Anza St 2 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990556.82661 2111951.2036599996 37.77847117438171 -122.476251378309 (37.7784711743817, -122.476251378309)
92694 89112 3 30 691 18th Ave 2 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990332.54501 2110711.2620900003 37.7750536277141 -122.476936620369 (37.7750536277141, -122.476936620369)
92892 89436 3 30 2832 Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989812.97644 2111980.65198 37.7785088669528 -122.47882676286501 (37.7785088669528, -122.478826762865)
93936 32892 1 30 1235 07th Ave 1 1 1 1 1 09/01/2016 12:00:00 AM 3 3x3 Permit Number 778801 5993897.25914467 2107077.09548698 37.7652813146396 -122.464341682773 (37.7652813146396, -122.464341682773)
94707 94202 1 30 1000 Green St 1 1 1 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008232.0 2118962.0 37.798730248485896 -122.415602598872 (37.7987302484859, -122.415602598872)
95620 89692 3 30 2337 Anza St 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5991391.91305 2111981.89017 37.7786038228381 -122.47336476609101 (37.7786038228381, -122.473364766091)
95844 89420 3 30 2300 Anza St 2 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5991511.6539 2112041.01499 37.7787730963608 -122.47295485316499 (37.7787730963608, -122.472954853165)
95924 89438 3 30 2936 Anza St 1 1 1 2   04/18/2008 12:00:00 AM 3 3x3   5989471.29839 2111967.48674 37.778452873034894 -122.480007779772 (37.7784528730349, -122.480007779772)
96649 89665 3 30 2801X Anza St 2 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989906.30924 2111928.05503 37.7783698693417 -122.478500045616 (37.7783698693417, -122.478500045616)
97443 89666 3 30 2801X Anza St 3 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989919.5240400005 2111926.33605 37.7783659166954 -122.478454205464 (37.7783659166954, -122.478454205464)
97837 4519 3 30 20X Cleary Ct 9 1 1 2   01/29/2015 11:31:00 AM 12 3x3   6004999.51904 2113885.82273 37.7846101140023 -122.42642640211099 (37.7846101140023, -122.426426402111)
98308 107371 2 30 448 BROADWAY   1 1 1     1 3x3   6011394.4 2118786.8 37.798426445485 -122.404647279275 (37.798426445485, -122.404647279275)
98803 104725 1 30 2747 Green St 2 1 1 1   11/06/2013 12:00:00 AM   3x3 Permit Number 770749 5999893.3 2117731.9 37.794880464642894 -122.44436863671899 (37.7948804646429, -122.444368636719)
99099 89084 3 30 430 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990316.3630800005 2112431.39135 37.7797756893394 -122.477118322615 (37.7797756893394, -122.477118322615)
99532 89079 3 30 522 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 2 3x3   5990340.26635 2111799.54514 37.7780422011609 -122.476989449392 (37.7780422011609, -122.476989449392)
100350 89662 3 30 2835 Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989829.3800099995 2111924.6433900003 37.778356035382295 -122.478765919993 (37.7783560353823, -122.478765919993)
100520 89671 3 30 2643 Anza St 2 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990400.47198 2111947.3155099996 37.7784514302677 -122.476791978132 (37.7784514302677, -122.476791978132)
100752 89096 3 30 551 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990302.22714 2111615.47744 37.7775345952701 -122.47710758505501 (37.7775345952701, -122.477107585055)
101307 89661 3 30 2849X Anza St 4 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989805.26204 2111923.47415 37.778351424551 -122.478849266567 (37.778351424551, -122.478849266567)
101687 102565 2 30 1655X 04th St 5 1 1 1       3x3   6015154.2 2107704.9 37.768207477714896 -122.39086220831899 (37.7682074777149, -122.390862208319)
101833 89054 3 30 788 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990404.14743 2110052.29751 37.773248445022 -122.476640781805 (37.773248445022, -122.476640781805)
102309 99758 2 30 4295x 25th St 2 1 1 1       3x3   6001974.5 2101167.2 37.7495164396885 -122.43598153971399 (37.7495164396885, -122.435981539714)
102376 89667 3 30 2731 Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990147.66431 2111935.32582 37.778403842194 -122.477665649037 (37.778403842194, -122.477665649037)
103093 89057 3 30 768 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990399.549819999 2110162.4742900003 37.773550693633 -122.47666473627899 (37.773550693633, -122.476664736279)
103146 89063 3 30 710 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990388.49369 2110501.1170799998 37.774479872644 -122.476727727029 (37.774479872644, -122.476727727029)
103217 89101 3 30 617 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990317.59695 2111167.61171 37.7763057711064 -122.477021681856 (37.7763057711064, -122.477021681856)
103411 89656 3 30 2921 Anza St 1 1 1 2   03/21/2008 12:00:00 AM 3 3x3   5989570.9478400005 2111917.39409 37.7783211217462 -122.479659392459 (37.7783211217462, -122.479659392459)
105058 89068 3 30 622 18th Ave 1 1 1 2   03/20/2008 12:00:00 AM 3 3x3   5990367.60069 2111102.5118400003 37.7761299255256 -122.476843949277 (37.7761299255256, -122.476843949277)
105851 55533 1 30 20 Caselli Ave 1 1 1 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50807 6000967.89961965 2104951.08442142 37.759848834973795 -122.439733631625 (37.7598488349738, -122.439733631625)
106037 89088 3 30 401 18th Ave 2 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990265.0064900005 2112569.67776 37.780152405839 -122.477306094769 (37.780152405839, -122.477306094769)
106267 89111 3 30 691 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990331.56334 2110745.46757 37.775147489618504 -122.47694251603501 (37.7751474896185, -122.476942516035)
106668 102554 2 30 1755X 04th St 1 1 1 1       3x3   6015173.7 2107354.9 37.767247536270204 -122.390770296702 (37.7672475362702, -122.390770296702)
106957 89684 3 30 2439X Anza St 3 1 1 2   04/08/2008 12:00:00 AM 3 3x3   5991029.88573 2111967.95192 37.778544582090504 -122.47461612736299 (37.7785445820905, -122.474616127363)
107023 89094 3 30 543 18th Ave 1 1 1 2   03/20/2008 12:00:00 AM 3 3x3   5990300.0620099995 2111662.7982900003 37.777664399650604 -122.477118533728 (37.7776643996506, -122.477118533728)
107613 89669 3 30 2701 Anza St 2 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990256.0353 2111940.3234 37.7784238525584 -122.477291122539 (37.7784238525584, -122.477291122539)
Powered by Datasette · Query took 5.64ms · Data source: data.sfgov.org