sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
69 19206 3 30 630 Sansome St 4 1 1 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
2850 27607 3 30 1377 Fulton St 1 1 1 2     3 3X3   6001133.4058 2111053.0447 37.7766127217509 -122.439598674592 (37.7766127217509, -122.439598674592)
3230 1713 3 30 555 Battery St 1 1 1 2     6 5x6   6012507.60717 2118114.90232 37.796643729085005 -122.40074798855 (37.796643729085, -122.40074798855)
3315 20250 3 30 1880 Steiner St 3 1 1 2     3 3X3   6002537.9918 2114673.3066 37.78663289034311 -122.43499878671301 (37.7866328903431, -122.434998786713)
3485 1714 3 30 555 Battery St 2 1 1 2     6 5x9   6012511.35044 2118080.94057 37.796550687018204 -122.400732648813 (37.7965506870182, -122.400732648813)
6797 27608 3 30 1377 Fulton St 2 1 1 2     3 3X3   6001149.4313 2111053.53 37.776614966343296 -122.439543272646 (37.7766149663433, -122.439543272646)
7797 6925 3 30 460 Fell St 1 1 1 2     6 3X3   6005200.4571 2110629.3361 37.7756799587692 -122.42549938705099 (37.7756799587692, -122.425499387051)
7798 1716 9 30 555 Battery St 4 1 1 2     18 5x15   6012528.51285 2117974.4106400004 37.796259138493205 -122.400665775228 (37.7962591384932, -122.400665775228)
7931 1715 3 30 555 Battery St 3 1 1 2     6 5x6   6012518.40757 2118034.67495 37.796424046287996 -122.400704977573 (37.796424046288, -122.400704977573)
7985 1718 3 30 555 Battery St 6 1 1 2     20 9x6   6012538.2564900005 2117884.3369 37.7960123609319 -122.400625729299 (37.7960123609319, -122.400625729299)
16227 7404 3 30 1060 Folsom St 1 1 1 2   05/28/1992 12:00:00 AM 24 3X3   6010543.2443 2111181.3457 37.777496075538004 -122.407056190657 (37.777496075538, -122.407056190657)
17244 25180 3 30 3226 Market St 2 1 1 2   04/18/1996 12:00:00 AM 6 3X3   5999422.34121 2104738.79635 37.7591778511874 -122.445063681349 (37.7591778511874, -122.445063681349)
17457 25179 3 30 3226 Market St 1 1 1 2   04/18/1996 12:00:00 AM 6 3X3   5999420.685330001 2104753.2461200003 37.7592174321694 -122.445070446966 (37.7592174321694, -122.445070446966)
18345 16909 3 30 457 Oak St 2 1 1 2   12/15/2009 12:00:00 AM 18 3X3   6004854.34153 2110178.37501 37.7744221674765 -122.42666456674101 (37.7744221674765, -122.426664566741)
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)
20331 25181 3 30 3226 Market St 3 1 1 2   04/18/1996 12:00:00 AM 6 3X3   5999423.66493 2104708.37976 37.7590944103092 -122.44505691664101 (37.7590944103092, -122.445056916641)
22166 25182 3 30 3226 Market St 4 1 1 2   04/18/1996 12:00:00 AM 3 3X3   5999429.9273 2104670.84771 37.7589917140099 -122.4450325603 (37.7589917140099, -122.4450325603)
23013 15425 3 30 2101 Mission St 2 1 1 2     6 2X2   6006866.3108 2106096.3931 37.7633275539022 -122.41941512219401 (37.7633275539022, -122.419415122194)
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)
60646 191259 3 30 900x Carolina St 27 3 1 2     17     6012470.08805 2103421.28043 37.7562963136528 -122.39984551077299 (37.7562963136528, -122.399845510773)
61696 4545 3 30 66 Cleary Ct 8 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
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)
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)
77532 4538 3 30 66 Cleary Ct 1 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
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)
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)
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)
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)
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)
87087 4518 3 30 20X Cleary Ct 8 1 1 2     6 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.42642640211099 (37.7846101140023, -122.426426402111)
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)
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)
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)
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)
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)
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)
96001 7147 3 30 685X Oak St 4 1 1 2     18 3X3   6003730.753719999 2110025.58578 37.7739390589029 -122.430540363958 (37.7739390589029, -122.430540363958)
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)
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)
99626 4541 3 30 66 Cleary Ct 4 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
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)
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)
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)
103688 92051 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
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)
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)
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)
107985 92049 3 30 2323 Cesar Chavez St   7 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
108240 89065 3 30 664 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990373.51835 2110921.31055 37.775632739883704 -122.476810236402 (37.7756327398837, -122.476810236402)
108532 89077 3 30 546 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990343.546375 2111649.81696 37.777631279192796 -122.47696715934299 (37.7776312791928, -122.476967159343)
108932 89105 3 30 635 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990321.35395 2111045.8273 37.775971602591795 -122.476999784527 (37.7759716025918, -122.476999784527)
109044 89081 3 30 482 18th Ave 1 1 1 2   03/20/2008 12:00:00 AM 3 3x3   5990329.59035 2112107.51338 37.778887177480705 -122.477048890931 (37.7788871774807, -122.477048890931)
109677 89070 3 30 610 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 2 3x3   5990363.96165 2111197.3405 37.776390087833796 -122.476863467892 (37.7763900878338, -122.476863467892)
110683 89091 3 30 467 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990279.30017 2112189.56022 37.7791095377355 -122.4772288603 (37.7791095377355, -122.4772288603)
110944 89687 3 30 2405 Anza St 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5991137.52605 2111970.73345 37.778558455774295 -122.474243965231 (37.7785584557743, -122.474243965231)
111180 89059 3 30 746 18th Ave 2 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990397.15719 2110267.75159 37.7738396174891 -122.476680705622 (37.7738396174891, -122.476680705622)
113266 89058 3 30 746 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990395.0930699995 2110255.0249900003 37.7738045540059 -122.47668691568899 (37.7738045540059, -122.476686915689)
113805 89087 3 30 401 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990264.81657 2112592.30835 37.780214532141706 -122.477308406147 (37.7802145321417, -122.477308406147)
114490 89100 3 30 601X 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990315.52162 2111207.6584 37.7764156078929 -122.47703178789499 (37.7764156078929, -122.477031787895)
115246 89686 3 30 2435 Anza St 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5991074.90155 2111969.0301099997 37.7785501507324 -122.474460480761 (37.7785501507324, -122.474460480761)
115691 89075 3 30 554 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990347.66295 2111591.2456400003 37.777470697316 -122.476948638049 (37.777470697316, -122.476948638049)
116013 89430 3 30 2626 Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990477.756159999 2112004.06486 37.778611730986206 -122.476528772678 (37.7786117309862, -122.476528772678)
116257 89423 3 30 2400 Anza St 2 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5991174.61875 2112030.16247 37.778723780309996 -122.474119986052 (37.77872378031, -122.474119986052)
116465 89109 3 30 667 18th Ave 1 1 1 2   03/21/2008 12:00:00 AM 3 3x3   5990327.355930001 2110845.92809 37.775423082523396 -122.47696441245 (37.7754230825234, -122.47696441245)
116787 89682 3 30 2439X Anza St 1 1 1 2   04/08/2008 12:00:00 AM 3 3x3   5990978.9280199995 2111966.0770799997 37.7785364815441 -122.474792270832 (37.7785364815441, -122.474792270832)
118373 89099 3 30 583 18th Ave 1 1 1 2   03/07/2008 12:00:00 AM 3 3x3   5990307.45252 2111413.41703 37.776980096273 -122.477074739943 (37.776980096273, -122.477074739943)
118487 89064 3 30 706 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990387.44621 2110524.3809 37.7745436879542 -122.476733050457 (37.7745436879542, -122.476733050457)
118494 89078 3 30 526 18th Ave 1 1 1 2   03/03/2008 12:00:00 AM 3 3x3   5990340.85231 2111766.5874799998 37.7779517425204 -122.47698501352501 (37.7779517425204, -122.476985013525)
Powered by Datasette · Query took 6.104ms · Data source: data.sfgov.org