sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2062 8436 1 168 1730 Geary Blvd 3 1 1 1   05/28/1997 12:00:00 AM 11 3X3   6003412.8094 2113950.8814 37.784698926436796 -122.431920527552 (37.7846989264368, -122.431920527552)
6315 18251 1 168 1825 Post St 2 1 1 1     12 3X3   6003359.8742 2114137.1113 37.7852072657709 -122.432116969328 (37.7852072657709, -122.432116969328)
8545 8434 1 168 1730 Geary Blvd 1 1 1 1   05/28/1997 12:00:00 AM 12 3X3   6003465.1068 2113959.1725 37.784724656301705 -122.4317401882 (37.7847246563017, -122.4317401882)
10303 93436 3 168 2404 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985728.5988 2098924.1036 37.7424211954642 -122.491994435754 (37.7424211954642, -122.491994435754)
10492 93427 3 168 2150 Taraval St 3 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986487.6789 2098952.531 37.7425435906318 -122.48937188989099 (37.7425435906318, -122.489371889891)
10611 93426 3 168 2150 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986519.4905 2098952.531 37.7425454476092 -122.489261896232 (37.7425454476092, -122.489261896232)
10719 93437 3 168 2408 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985715.4003 2098924.442 37.7424213531218 -122.492040096469 (37.7424213531218, -122.492040096469)
10782 93456 3 168 2039 Taraval St 1 1 1 2   02/19/2015 01:33:00 PM 3 3x3   5986815.2712 2098896.6914 37.7424093879903 -122.488235084702 (37.7424093879903, -122.488235084702)
10804 93408 3 168 1440 Taraval St 1 1 1 2   02/19/2015 03:17:00 PM 3 3x3   5988695.7955 2099025.5303 37.7428726808967 -122.48174230877899 (37.7428726808967, -122.481742308779)
10945 93434 3 168 2300 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986059.5753 2098939.671 37.742483280315 -122.490851179477 (37.742483280315, -122.490851179477)
10956 93428 3 168 2222 Taraval St 1 1 1 2   02/19/2015 01:36:00 PM 3 3x3   5986281.7492 2098944.9165 37.7425106597816 -122.490083364444 (37.7425106597816, -122.490083364444)
11010 93431 3 168 2240 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986207.6348 2098941.1939 37.742496110202296 -122.49033935278798 (37.7424961102023, -122.490339352788)
11014 93432 3 168 2244 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986188.6832 2098942.886 37.7424996493843 -122.49040500535 (37.7424996493843, -122.49040500535)
11156 93446 3 168 2343 Taraval St 2 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985872.427999999 2098863.1876 37.7422623426363 -122.491492641715 (37.7422623426363, -122.491492641715)
11158 93435 3 168 2302 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986039.9468 2098937.3019999997 37.742475628974205 -122.490918873767 (37.7424756289742, -122.490918873767)
11200 93423 3 168 2048 Taraval St 2 1 1 2   01/20/2015 12:49:00 PM 3 3x3   5986826.7775 2098962.0068 37.7425893979873 -122.488200098519 (37.7425893979873, -122.488200098519)
11253 93439 3 168 2545 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985279.5976 2098843.1362 37.7421726252091 -122.49354096012199 (37.7421726252091, -122.493540960122)
11256 93430 3 168 2226 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986248.2454 2098943.2244 37.742504057158996 -122.490199084637 (37.742504057159, -122.490199084637)
11517 93438 3 168 2414 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985694.7566 2098925.7957 37.7424238632874 -122.492111574827 (37.7424238632874, -122.492111574827)
11519 93424 3 168 2100 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986662.1353 2098956.0844 37.7425635298153 -122.488768940253 (37.7425635298153, -122.488768940253)
11729 93414 3 168 1722 Taraval St 1 1 1 2   02/19/2015 03:10:00 PM 3 3x3   5987827.66 2098999.0640000002 37.7427494893985 -122.484742100445 (37.7427494893985, -122.484742100445)
11867 93415 3 168 1716 Taraval St 1 1 1 2   03/23/2015 06:26:00 PM 3 3x3   5987861.1638 2098998.3872 37.7427495822889 -122.48462620565901 (37.7427495822889, -122.484626205659)
11939 93441 3 168 2453 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985552.0272 2098851.9351 37.7422127174882 -122.492599644801 (37.7422127174882, -122.492599644801)
12074 93453 3 168 2139 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986521.8595 2098886.5388 37.7423643889255 -122.489248854134 (37.7423643889255, -122.489248854134)
12101 93425 3 168 2122 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986588.0209 2098955.4076 37.7425573460454 -122.489025152899 (37.7425573460454, -122.489025152899)
12150 93452 3 168 2149 Taraval St 1 1 1 2   01/03/2015 01:35:00 PM 3 3x3   5986481.2489 2098884.5082 37.742356442825105 -122.489389122116 (37.7423564428251, -122.489389122116)
12217 93451 3 168 2239 Taraval St 2 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986220.3256 2098876.0477 37.742317977353395 -122.490290681149 (37.7423179773534, -122.490290681149)
12231 93450 3 168 2239 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986205.0967 2098876.0477 37.7423170879313 -122.49034333731599 (37.7423170879313, -122.490343337316)
12449 93447 3 168 2337 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985896.456 2098863.5261 37.742264676187 -122.491409586353 (37.742264676187, -122.491409586353)
12625 93444 3 168 2401 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985736.1286 2098858.7036 37.74224206476121 -122.491963586408 (37.7422420647612, -122.491963586408)
12639 93455 3 168 2109 Taraval St 2 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986657.5666 2098892.2919 37.7423881059963 -122.488780049158 (37.7423881059963, -122.488780049158)
12731 38212 1 168 108 Wayland St 1 1 1 1 1 07/17/1998 12:00:00 AM 8 3x3 Permit Number 40335 6011170.868009999 2092548.53605 37.726369572089894 -122.403573737557 (37.7263695720899, -122.403573737557)
12949 93454 3 168 2109 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986642.3376 2098891.6151 37.742385358930996 -122.488832656 (37.742385358931, -122.488832656)
12982 93443 3 168 2409 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985719.2076 2098858.0267 37.742239217096795 -122.492022043353 (37.7422392170968, -122.492022043353)
13132 93433 3 168 2306 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986025.3947 2098937.9789 37.7424766373979 -122.490969239699 (37.7424766373979, -122.490969239699)
13160 91380 3 168 1421 Taraval St 1 1 1 2   02/19/2015 01:27:00 PM 3 3x3 Permit Number 52077 5988771.9062 2098963.627 37.742707136361105 -122.48147460973699 (37.7427071363611, -122.481474609737)
17530 16968 1 168 767 Oak St 1 1 1 1     12 3X3   6003330.7652 2109962.2092 37.7737423751934 -122.431919463762 (37.7737423751934, -122.431919463762)
17619 17030 1 168 1159 Oak St 1 1 1 1     12 3X3   6001449.2469 2109707.3473 37.772935745446404 -122.438409655481 (37.7729357454464, -122.438409655481)
17827 17125 1 168 1967 Oak St 1 1 1 1     3 3x3   5997619.3207 2109172.1957 37.7712477652106 -122.451619154414 (37.7712477652106, -122.451619154414)
18537 17028 1 168 1140 Oak St 1 1 1 1     12 3X3   6001519.83997 2109777.5071900003 37.7731324020756 -122.438170492981 (37.7731324020756, -122.438170492981)
18858 17137 1 168 2045 Oak St 1 1 1 1     6 3X3   5997217.7067 2109114.9444 37.7710675601361 -122.453004213188 (37.7710675601361, -122.453004213188)
19296 17136 1 168 2041 Oak St 1 1 1 1     6 3X3   5997241.2054 2109118.3624 37.7710782917307 -122.45292317759301 (37.7710782917307, -122.452923177593)
19523 16915 1 168 484 Oak St 1 1 1 1     6 3X3   6004711.24143 2110219.61063 37.7745272991249 -122.42716251506 (37.7745272991249, -122.42716251506)
19579 17029 1 168 1153 Oak St 1 1 1 1     12 3X3   6001512.0667 2109715.9891 37.772963046680395 -122.438192973878 (37.7729630466804, -122.438192973878)
20032 17103 1 168 1745 Oak St 1 1 1 1     12 3X3   5998656.2538 2109314.8969 37.7716989147196 -122.44804265122801 (37.7716989147196, -122.448042651228)
21215 17119 1 168 1931 Oak St 1 1 1 1     18 3X3   5997738.0959 2109188.8584 37.7713003179936 -122.451209509969 (37.7713003179936, -122.451209509969)
21894 17095 1 168 1661 Oak St 1 1 1 1     6 3X3   5999030.0966 2109360.6125 37.7718458009941 -122.446752800648 (37.7718458009941, -122.446752800648)
22104 16924 1 168 508 Oak St 1 1 1 1   04/13/2005 12:00:00 AM 12 3X4   6004451.24438 2110184.3203 37.774415694158 -122.42805938013399 (37.774415694158, -122.428059380134)
22112 17000 1 168 940 Oak St 1 1 1 1     12 3X3   6002487.5182 2109913.8953 37.77356187754221 -122.43483292856399 (37.7735618775422, -122.434832928564)
22581 16398 1 168 299X Myrtle St 4 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006124.74935 2114015.2727900003 37.7850290954547 -122.422542679726 (37.7850290954547, -122.422542679726)
22586 16396 1 168 299X Myrtle St 2 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006093.31996 2114011.54372 37.7850170832184 -122.422651150523 (37.7850170832184, -122.422651150523)
22735 16395 1 168 299X Myrtle St 1 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006070.4864 2114008.23449 37.7850067086413 -122.42272991225201 (37.7850067086413, -122.422729912252)
22771 16397 1 168 299X Myrtle St 3 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006110.1202 2114012.78935 37.785021451230705 -122.422593115487 (37.7850214512307, -122.422593115487)
23297 17101 3 168 1711 Oak St 1 1 1 2     8 3X3   5998684.4523 2109317.8876 37.771708738288105 -122.447945326623 (37.7717087382881, -122.447945326623)
24985 30698 1 168 240 Lily St 2 1 1 1 1 01/31/1995 12:00:00 AM 6   Permit Number 34612 6005345.2585 2110114.4836 37.7742744792738 -122.42496184383499 (37.7742744792738, -122.424961843835)
25018 181957 2 168 2535 Taraval St 1 1 1 1     1 Width 0ft   5985299.9029 2098842.7977 37.7421728835811 -122.493470726805 (37.7421728835811, -122.493470726805)
26169 234856 2 168 656 Banks St 1 1 1 1     11 Width 2ft   6008485.30896 2095795.27692 37.735134047297294 -122.413087094406 (37.7351340472973, -122.413087094406)
27987 139151 2 168 1881 POST ST 2 1 1 1     6 Width 0ft   6003144.9445 2114104.5849 37.7851057685851 -122.43285823467801 (37.7851057685851, -122.432858234678)
28292 181330 2 168 2343 Taraval St 1 1 1 1     1 Width 0ft   5985852.7996 2098862.8492 37.7422602664155 -122.49156048482901 (37.7422602664155, -122.491560484829)
29058 181956 2 168 2453 Taraval St 2 1 1 1     1 Width 0ft   5985572.3325 2098853.6272 37.7422185507809 -122.492529560952 (37.7422185507809, -122.492529560952)
29077 91140 1 168 342 21st Ave 1 1 1 1   01/26/2009 12:00:00 AM 1 3x3 Permit Number 52025 5989366.26045 2113048.7976 37.7814157473958 -122.48045031235 (37.7814157473958, -122.48045031235)
30095 139152 2 168 1881 POST ST 3 1 1 1     8 Width 0ft   6003164.7154 2114107.1359 37.7851138943196 -122.432790015912 (37.7851138943196, -122.432790015912)
34940 244280 2 168 575 Oak St 5 1 1 1     4 Width 0ft   6004261.3266 2110092.3934 37.77415253865129 -122.42870978718099 (37.7741525386513, -122.428709787181)
39854 55830 1 168 170 11th Ave 1 1 1 1   03/09/1973 12:00:00 AM 7   Permit Number 11879 5992452.285209999 2114337.35562 37.7851326311765 -122.469868105299 (37.7851326311765, -122.469868105299)
42841 178684 2 168 161 Delta St 2 1 1 1     1 Width 3ft   6009805.30528 2088917.07553 37.716321963062 -122.40803845872401 (37.716321963062, -122.408038458724)
43887 72500 2 168 2311 Taraval St 3 1 1 1 1 08/10/1996 12:00:00 AM 1     5986050.4379 2098869.9561 37.7422913280707 -122.49087764471001 (37.7422913280707, -122.49087764471)
49392 49889 1 168 1430@ OCTAVIA Francisco St 1 1 1 1 1 07/01/2003 12:00:00 AM 6   Permit Number 46660 6004450.34869 2120515.08924 37.8027813349583 -122.42879910759599 (37.8027813349583, -122.428799107596)
49412 139153 2 168 1881 POST ST 4 1 1 1     10 Width 0ft   6003212.5485 2114113.5137 37.785134118902 -122.432624984211 (37.785134118902, -122.432624984211)
52703 234862 2 168 147 Andover St 1 1 1 1     7 Width 3ft   6007596.66098 2097957.46338 37.741021008521 -122.41631257406 (37.741021008521, -122.41631257406)
53631 244281 2 168 565 Oak St 6 1 1 1     7 Width 0ft   6004280.5399 2110094.8567 37.7741603896423 -122.42864350060499 (37.7741603896423, -122.428643500605)
53954 47883 1 168 1422 45th Ave 1 1 1 1 1 02/11/2006 12:00:00 AM 5   Permit Number 45630 5982178.8025 2105387.2339 37.7599590039895 -122.504747143589 (37.7599590039895, -122.504747143589)
55292 234854 2 168 130 Andover St 1 1 1 1     5 Width 3ft   6007573.33331 2098019.6233599996 37.7411903742509 -122.41639763464799 (37.7411903742509, -122.416397634648)
56065 139135 2 168 1825 POST ST 6 1 1 1     8 Width 0ft   6003465.1068 2114153.0556 37.785257010462 -122.43175403601299 (37.785257010462, -122.431754036013)
58090 178683 2 168 161 Delta St 1 1 1 1     1 Width 3ft   6009800.07713 2088901.3026400001 37.7162783612237 -122.408055418121 (37.7162783612237, -122.408055418121)
59264 52753 1 168 59@ ROLPH Newton St 1 1 1 1 1 10/06/2006 12:00:00 AM 7   Permit Number 48796 6000913.35841 2088160.63266 37.713743072553 -122.438719109114 (37.713743072553, -122.438719109114)
60571 30701 1 168 241 Lily St 1 1 1 1 1 01/31/1995 12:00:00 AM 4   Permit Number 34613 6005368.9614 2110093.8196 37.7742190797874 -122.42487838067 (37.7742190797874, -122.42487838067)
60903 135662 2 168 1430 Francisco St 2 1 1 1     4 Width 3ft   6004430.55292 2120513.3454 37.802775426403606 -122.42886748667101 (37.8027754264036, -122.428867486671)
61982 234857 2 168 125 Winfield St 1 1 1 1     8 Width 2ft   6007057.29918 2098677.05689 37.74296650740129 -122.418228500567 (37.7429665074013, -122.418228500567)
62609 181327 2 168 2150 Taraval St 2 1 1 1     1 Width 0ft   5986507.3073 2098951.8542 37.7425428781244 -122.48930397183099 (37.7425428781244, -122.489303971831)
63225 178682 2 168 583 Naples St 1 1 1 1     1 Width 2ft   6002865.41308 2090226.6105799999 37.71952665220171 -122.432119544876 (37.7195266522017, -122.432119544876)
63869 121932 2 168 344 16th Ave 1 1 1 1     5 Width 3ft   5990915.4532 2113093.93697 37.7816295951245 -122.475094208069 (37.7816295951245, -122.475094208069)
63888 30697 1 168 240 Lily St 1 1 1 1 1 01/31/1995 12:00:00 AM 3   Permit Number 34612 6005370.1769 2110115.0914 37.774277555648496 -122.42487568971599 (37.7742775556485, -122.424875689716)
65840 97111 1 168 1345 Noriega St 2 1 1 1     1   Permit Number 18860 5989755.1906 2103082.2788 37.754072995002204 -122.47837582871401 (37.7540729950022, -122.478375828714)
66471 181329 2 168 2319 Taraval St 1 1 1 1     1 Width 0ft   5985969.5551 2098866.9103 37.742278239613796 -122.491157084664 (37.7422782396138, -122.491157084664)
68838 106982 3 168 1737-1795 Post St 1 1 1 2     10     6003656.2329 2114175.7467 37.7853301466286 -122.431094418652 (37.7853301466286, -122.431094418652)
70845 93449 3 168 2301x Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986031.0 2098812.3 37.7421318842811 -122.490940612353 (37.7421318842811, -122.490940612353)
71138 30700 1 168 240 Lily St 4 1 1 1 1 01/31/1995 12:00:00 AM 5   Permit Number 34612 6005310.6159 2110107.7982 37.7742541659126 -122.425081203232 (37.7742541659126, -122.425081203232)
71601 30699 1 168 240 Lily St 3 1 1 1 1 01/31/1995 12:00:00 AM 3   Permit Number 34612 6005328.8488 2110110.837 37.7742635396666 -122.425018348522 (37.7742635396666, -122.425018348522)
72613 212834 2 168 2622 16th Ave 2 1 1 1     3 Width 3ft   5991449.17538 2097558.9485400002 37.7390055522499 -122.472115105035 (37.7390055522499, -122.472115105035)
72690 39956 1 168 370 Teddy Ave 1 1 1 1 1 01/25/1999 12:00:00 AM 7   Permit Number 41218 6009202.76969 2088674.77745 37.7156229083553 -122.41010402697901 (37.7156229083553, -122.410104026979)
76677 244964 2 168 250 Lily St 2 1 1 1     4 Width 0ft   6005290.5596 2110104.7594 37.774244689119 -122.42515036540199 (37.774244689119, -122.425150365402)
83387 23889 3 168 1750X Geary Blvd 6 1 1 2     18 3X3   6003201.67908 2113890.07748 37.7845200030062 -122.43264662292299 (37.7845200030062, -122.432646622923)
85518 8412 3 168 1590X Geary Blvd 1 1 1 2     18 3X3   6004120.4992681 2114020.0804586997 37.784929023116796 -122.429477092496 (37.7849290231168, -122.429477092496)
87801 18262 1 168 1895X Post St 1 1 1 1     12 3x3   6003118.209290001 2114097.1727299998 37.785083900253 -122.43295020031799 (37.785083900253, -122.432950200318)
89147 93429 3 168 2222 Taraval St 2 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986343.0 2098927.0 37.742465042516706 -122.489870262796 (37.7424650425167, -122.489870262796)
90439 8411 3 168 1570 Geary Blvd 4 1 1 2     18 3X3   6004211.027185 2114032.026709 37.7849669496355 -122.42916474711001 (37.7849669496355, -122.42916474711)
91862 18263 1 168 1895X Post St 2 1 1 1     12 3X3   6003138.05675 2114098.29377 37.7850881040741 -122.43288161451599 (37.7850881040741, -122.432881614516)
91939 122722 2 168 1385 Natoma St 1 1 1 1     6 3x3   6007219.0 2107431.0 37.76701193031621 -122.41828991357599 (37.7670119303162, -122.418289913576)
92742 18267 1 168 1895X Post St 6 1 1 1     12 3X3   6003219.29534 2114110.16008 37.785125293322295 -122.432601402633 (37.7851252933223, -122.432601402633)
93139 18222 3 168 1643X Post St 5 1 1 2   01/02/1991 12:00:00 AM 6 3X3   6004309.242075901 2114268.2781924 37.7856211964399 -122.428841803498 (37.7856211964399, -122.428841803498)
93885 18250 3 168 1825 Post St 1 1 1 2     12 3X3   6003354.45468 2114131.31985 37.7851910566456 -122.432135305453 (37.7851910566456, -122.432135305453)
Powered by Datasette · Query took 4.271ms · Data source: data.sfgov.org