sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9887 51349 1 25 6401 23rd Ave 1 1 1 1   10/12/2004 12:00:00 AM     Permit Number 47697          
11322 19745 3 25 100 STAIRWAY15 1 1 1 2     6 3X3            
75642 117921 2 25 701 41st Ave 2 1 1 1     12 Width 4ft   5983188.84619 2110935.7089 37.7752528931729 -122.50166444280799 (37.7752528931729, -122.501664442808)
56961 117877 2 25 734 41st Ave 1 1 1 1     14 Width 3ft   5983242.29307 2110782.48705 37.774835329522794 -122.501468223794 (37.7748353295228, -122.501468223794)
164370 54720 1 25 510 39th Ave 1 1 1 1   07/24/1972 12:00:00 AM 9   Permit Number 10556 5983806.7051 2112297.13716 37.7790272518998 -122.499627803034 (37.7790272518998, -122.499627803034)
87349 807 3 25 600X 39th Ave 5 11 1 2     6 6-HOA   5983808.206040001 2111664.13118 37.7772892893219 -122.49957581574499 (37.7772892893219, -122.499575815745)
170156 117839 3 25 600x 39th Ave 3 11 1 2     15 Width 6ft   5983810.52385 2111649.02031 37.7772479352498 -122.499566680778 (37.7772479352498, -122.499566680778)
71113 117906 2 25 578 39th Ave 1 1 1 1     10 Width 3ft   5983823.18804 2111887.6622200003 37.777903919788606 -122.499540512861 (37.7779039197886, -122.499540512861)
151739 54495 1 25 582 39th Ave 1 1 1 1   07/11/1972 12:00:00 AM 9   Permit Number 10288 5983824.998980001 2111865.7848400003 37.777843957105205 -122.49953263105499 (37.7778439571052, -122.499532631055)
104485 24342 3 25 600X 39th Ave 14 11 1 2     3 6-HOA   5983831.1679936 2111715.0127262003 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383)
143285 814 3 25 600X 39th Ave 12 11 1 2     6 6-HOA   5983831.1679936 2111715.0127262003 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383)
145945 805 3 25 680X 39th Ave 3 11 1 2     6 6-HOA   5983823.96426 2111160.91126 37.7759085177004 -122.499484105844 (37.7759085177004, -122.499484105844)
121730 803 3 25 680X 39th Ave 1 11 1 2     6 6-HOA   5983825.76498 2111129.60729 37.7758226717015 -122.499475562851 (37.7758226717015, -122.499475562851)
62431 75772 2 25 3701 Balboa St 1 1 1 1 1 10/14/1995 12:00:00 AM 13     5984063.002640001 2111035.7891 37.7755789903575 -122.49864797822599 (37.7755789903575, -122.498647978226)
153253 75719 2 25 3701 Balboa St 2 1 1 1 1 10/14/1995 12:00:00 AM 8     5984076.35537 2111035.6681 37.775579441223705 -122.498601779667 (37.7755794412237, -122.498601779667)
39538 75600 2 25 701 38th Ave 4 1 1 1 1 10/14/1995 12:00:00 AM 9     5984118.61972 2110981.94357 37.775434407710705 -122.49845161010599 (37.7754344077107, -122.498451610106)
34723 75661 2 25 701 38th Ave 3 1 1 1 1 10/14/1995 12:00:00 AM 2     5984119.5345 2111005.02849 37.7754978458904 -122.498450151227 (37.7754978458904, -122.498450151227)
159303 75536 2 25 701 38th Ave 5 1 1 1 1 10/14/1995 12:00:00 AM 12     5984118.85326 2110953.37322 37.7753559754601 -122.498448691476 (37.7753559754601, -122.498448691476)
68301 75472 2 25 701 38th Ave 6 1 1 1 1 10/14/1995 12:00:00 AM 8     5984118.82642 2110932.36992 37.77529830487779 -122.498447232603 (37.7752983048778, -122.498447232603)
54299 118236 2 25 680 38th Ave 4 1 1 1     12 Width 5ft   5984154.15255 2111259.59719 37.7761988481286 -122.49834920754101 (37.7761988481286, -122.498349207541)
26497 118237 2 25 680 38th Ave 3 1 1 1     5 Width 5ft   5984156.56832 2111248.83134 37.7761694298689 -122.498340055521 (37.7761694298689, -122.498340055521)
19745 105202 2 25 708 38th Ave 1 1 1 1     14 4x6   5984164.05462 2110996.44068 37.7754768768809 -122.49829551344999 (37.7754768768809, -122.49829551345)
89070 184134 2 25 3240 Lawton St 1 1 1 1     5 Width 0ft   5984156.0453 2104307.1890000002 37.757109619352 -122.497829171247 (37.757109619352, -122.497829171247)
53981 118228 2 25 699 37th Ave 12 1 1 1     5 Width 3ft   5984449.813999999 2111641.4618599997 37.7772646712772 -122.49735464678001 (37.7772646712772, -122.49735464678)
49154 118227 2 25 699 37th Ave 11 1 1 1     2 Width 3ft   5984452.03524 2111621.56677 37.77721017528479 -122.497345493843 (37.7772101752848, -122.497345493843)
186668 118226 2 25 699 37th Ave 10 1 1 1     7 Width 3ft   5984451.57804 2111600.1477900003 37.7771513381474 -122.497345493825 (37.7771513381474, -122.497345493825)
36086 118225 2 25 699 37th Ave 9 1 1 1     8 Width 3ft   5984452.242269999 2111581.69085 37.7771006996432 -122.49734183320601 (37.7771006996432, -122.497341833206)
52120 118224 2 25 699 37th Ave 8 1 1 1     4 Width 3ft   5984451.82255 2111562.02768 37.7770466856492 -122.49734183318701 (37.7770466856492, -122.497341833187)
28186 118223 2 25 699 37th Ave 7 1 1 1     7 Width 3ft   5984452.77979 2111524.2434799997 37.776942997233604 -122.49733573185 (37.7769429972336, -122.49733573185)
181631 118222 2 25 699 37th Ave 6 1 1 1     4 Width 3ft   5984454.40833 2111501.37469 37.776880301576206 -122.497328409687 (37.7768803015762, -122.497328409687)
49033 118221 2 25 699 37th Ave 5 1 1 1     8 Width 3ft   5984455.23409 2111482.2118900004 37.776827734448105 -122.49732413820101 (37.7768277344481, -122.497324138201)
167234 118220 2 25 699 37th Ave 4 1 1 1     6 Width 3ft   5984456.55861 2111461.63296 37.7767713082661 -122.497318036821 (37.7767713082661, -122.497318036821)
50694 118217 2 25 699 37th Ave 1 1 1 1     4 Width 3ft   5984459.3393 2111410.10949 37.776630002637 -122.497304613296 (37.776630002637, -122.497304613296)
162463 35173 1 25 4545 Anza St 1 1 1 1 1 02/10/1998 12:00:00 AM 12   Permit Number 38711 5984612.32858 2111732.91994 37.7775253123971 -122.496799216616 (37.7775253123971, -122.496799216616)
51448 92261 3 25 4545 Anza St 9 1 1 2   07/23/2009 12:00:00 AM 12 3x3 Permit Number 52708 5984639.1399 2111735.34775 37.7775335493935 -122.49670664793301 (37.7775335493935, -122.496706647933)
2683 71631 2 25 678 36th Ave 1 1 1 1 1 07/26/2017 12:00:00 AM 3   Permit Number 780356 5984775.35157 2111233.16415 37.776162677429205 -122.496198392825 (37.7761626774292, -122.496198392825)
82650 21149 3 25 2292X Sunset Blvd 18 1 1 2     3 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
105178 21150 3 25 2292X Sunset Blvd 19 1 1 2     3 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
108652 21148 3 25 2292X Sunset Blvd 17 1 1 2     3 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
134909 187383 2 25 2200 Sunset Blvd 69 9 1 1     5 Width 0ft   5985095.2656 2100101.9401 37.745618175200704 -122.49427107768601 (37.7456181752007, -122.494271077686)
116776 104817 2 25 3170 BALBOA ST   1 1 1     11 3x3   5985841.0 2111127.0 37.7759335444794 -122.49250425909901 (37.7759335444794, -122.492504259099)
151396 84343 1 25 2925 Cabrillo St 1 1 1 1   01/11/2008 12:00:00 AM 5 3x3 Permit Number 50100 5986511.98637 2110444.25082 37.774098116355795 -122.49013294289101 (37.7740981163558, -122.490132942891)
150999 250462 2 25 290 Seacliff Ave 1 9 1 1     11 Width 3ft   5986816.96544 2115727.4811 37.7886221640356 -122.489466544563 (37.7886221640356, -122.489466544563)
69621 67958 1 25 719 28th Ave 1 1 1 1 1 03/22/1993 12:00:00 AM 11   Permit Number 31678 5987220.95005 2111007.3016 37.7756854718616 -122.48772192033998 (37.7756854718616, -122.48772192034)
29127 250321 2 25 247 27th Ave 1 4 1 1     8 Width 3ft   5987414.73446 2114306.1636799998 37.7847545126541 -122.487293940769 (37.7847545126541, -122.487293940769)
137903 250320 2 25 255 27th Ave 1 4 1 1     11 Width 3ft   5987417.56987 2114243.0271099997 37.78458132302389 -122.487279492276 (37.7845813230239, -122.487279492276)
68359 120182 2 25 152 26th Ave 1 1 1 1     13 Width 4ft   5987745.04636 2114955.0234 37.7865553525285 -122.486198834875 (37.7865553525285, -122.486198834875)
176855 50200 1 25 582 24th Ave 1 1 1 1 1 08/21/2003 12:00:00 AM 8 3x4 Permit Number 46908 5988471.49095 2112024.9112400003 37.778552404331705 -122.483470659433 (37.7785524043317, -122.483470659433)
133689 84536 2 25 124 23rd Ave 1 1 1 1 1   6     5988694.18379 2114506.16667 37.7853781914991 -122.482882183887 (37.7853781914991, -122.482882183887)
82375 88393 1 25 124 23rd Ave   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51371 5988714.5 2114502.9 37.785370404226796 -122.48281165726401 (37.7853704042268, -122.482811657264)
112904 114382 2 25 402X SERRANO DR 1 2 1 1     12     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
188682 120320 2 25 640 23rd Ave 2 1 1 1     5 Width 3ft   5988820.50243 2110953.1294299997 37.7756298975626 -122.482184767826 (37.7756298975626, -122.482184767826)
180579 179484 2 25 0 Serrano Dr 2 2 1 1     9     5988536.49014 2090373.27915 37.719106559100396 -122.48165955597099 (37.7191065591004, -122.481659555971)
156566 182027 2 25 2151 Irving St 1 1 1 1     11 Width 0ft   5989030.3614 2106462.597 37.7633123331055 -122.481129936538 (37.7633123331055, -122.481129936538)
103632 95070 2 25 2165 Irving St 1 1 1 1       3x3   5989059.0 2106465.0 37.763320595920504 -122.48103106212099 (37.7633205959205, -122.481031062121)
46825 179482 2 25 0 Serrano Dr 3 2 1 1     10     5988878.80429 2090370.98469 37.719120158641296 -122.48047615337 (37.7191201586413, -122.48047615337)
153866 179481 2 25 0 Serrano Dr 2 2 1 1     15     5988902.49405 2090393.59661 37.7191836220039 -122.480395922129 (37.7191836220039, -122.480395922129)
54855 179483 2 25 0 Serrano Dr 3 2 1 1     8     5988918.9165199995 2090347.02209 37.7190566943955 -122.48033574940399 (37.7190566943955, -122.480335749404)
119916 114214 2 25 230 SERRANO DR 2 2 1 1     13     5988981.0 2090766.0 37.720210710128896 -122.48015180069099 (37.7202107101289, -122.480151800691)
79870 67438 1 25 2910 Anza St 1 1 1 1 1 07/31/1992 12:00:00 AM 8 4x4 Permit Number 30940 5989610.64145 2111971.49615 37.7784719767097 -122.479526038454 (37.7784719767097, -122.479526038454)
129472 93166 1 25 2900@ Anza Anza St 1 1 1 1     12 6x9   5989637.9003800005 2111973.07871 37.7784779053207 -122.47943185638701 (37.7784779053207, -122.479431856387)
157905 183898 2 25 2101 22nd Ave 1 1 1 1     14 Width 0ft   5989422.5761 2101010.3481 37.748364707147495 -122.47937450767701 (37.7483647071475, -122.479374507677)
51874 183899 2 25 2101 22nd Ave 2 1 1 1     9 Width 0ft   5989428.0919 2100803.1123 37.747796012582704 -122.479340275734 (37.7477960125827, -122.479340275734)
48810 183900 2 25 2101 22nd Ave 3 1 1 1     8 Width 0ft   5989432.8197 2100761.3499 37.7476816186189 -122.479320872687 (37.7476816186189, -122.479320872687)
135551 183901 2 25 2101 22nd Ave 4 1 1 1     11 Width 0ft   5989435.1836 2100729.0432 37.7475930502179 -122.47931033546699 (37.7475930502179, -122.479310335467)
167194 183903 2 25 2101 22nd Ave 6 1 1 1     6 Width 0ft   5989437.5475 2100612.4238 37.7472729813132 -122.479293631278 (37.7472729813132, -122.479293631278)
179352 183904 2 25 2101 22nd Ave 7 1 1 1     10 Width 0ft   5989435.9716 2100535.9908 37.7470630248592 -122.479293489941 (37.7470630248592, -122.479293489941)
25682 183905 2 25 2101 22nd Ave 8 1 1 1     17 Width 0ft   5989441.4873 2100495.8044 37.746953003916296 -122.479271477973 (37.7469530039163, -122.479271477973)
96521 62611 1 25 2262 22nd Ave 1 1 1 1 1 03/07/1986 12:00:00 AM     Permit Number 22921 5989510.16412079 2099957.30856958 37.745478424066704 -122.478994620655 (37.7454784240667, -122.478994620655)
171956 179479 2 25 0 Serrano Dr 4 2 1 1     15     5989502.72531 2090743.3416900001 37.7201787974032 -122.478346734135 (37.7201787974032, -122.478346734135)
168 179480 2 25 100 Serrano Dr 1 2 1 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
186144 72398 2 25 791 19th Ave 2 1 1 1 1 03/09/1996 12:00:00 AM 11     5990047.515430001 2110000.36847 37.7730851702984 -122.477870609559 (37.7730851702984, -122.477870609559)
11226 110358 2 25 1830 Irving St 1 1 1 1     12 3x3   5990014.2377 2106553.7919 37.7636198770855 -122.477733734661 (37.7636198770855, -122.477733734661)
89422 101259 2 25 1830 Irving St 1 1 1 1       3x3   5990081.34478 2106545.17551 37.763600113076 -122.47750100502701 (37.763600113076, -122.477501005027)
187686 179478 2 25 0 Serrano Dr 1 2 1 1     9     5989807.06872 2090726.39006 37.720149915678 -122.477293493993 (37.720149915678, -122.477293493993)
72936 121873 2 25 346 18th Ave 1 1 1 1     20 Width 3ft   5990295.07305 2113054.8824 37.7814863875121 -122.47723755062 (37.7814863875121, -122.47723755062)
188963 121868 2 25 382 18th Ave 1 1 1 1     21 Width 6ft   5990304.700669999 2112806.5202900004 37.7808050127417 -122.477186088815 (37.7808050127417, -122.477186088815)
100932 66607 1 25 100 Serrano Dr 1 1 1 1   05/01/1991 12:00:00 AM 12   Permit Number 29802 5989869.39246895 2090726.40504468 37.7201535727537 -122.477078065149 (37.7201535727537, -122.477078065149)
37601 43760 1 25 249 17th Ave 1 1 1 1 1 07/26/2000 12:00:00 AM 8   Permit Number 43395 5990536.37641 2113724.23454 37.783338239757704 -122.47645167744601 (37.7833382397577, -122.476451677446)
52358 43759 1 25 249 17th Ave 2 1 1 1   07/26/2000 12:00:00 AM 9   Permit Number 43395 5990535.981790001 2113705.55195 37.783286919680705 -122.476451677439 (37.7832869196807, -122.476451677439)
136280 96985 1 25 601 15th Ave 1 1 1 1     13 6x7   5991261.14283 2111266.80131 37.7766328115191 -122.473764965551 (37.7766328115191, -122.473764965551)
56526 214173 2 25 2252 17th Ave 1 1 1 1     10 Width 3ft   5991053.76562 2100086.62004 37.7459229980593 -122.47366657496401 (37.7459229980593, -122.473666574964)
174621 214174 2 25 2574 16th Ave 1 1 1 1     10 Width 3ft   5991436.00676 2097903.57199 37.7399510383196 -122.47218574950001 (37.7399510383196, -122.4721857495)
176426 214176 2 25 2570 16th Ave 1 1 1 1     10 Width 3ft   5991436.65565 2097934.35886 37.7400356087611 -122.47218574950001 (37.7400356087611, -122.4721857495)
136010 214175 2 25 2574 16th Ave 2 1 1 1     8 Width 3ft   5991436.71189 2097914.45578 37.7399809632369 -122.472184104624 (37.7399809632369, -122.472184104624)
112946 68795 1 25 2574 16th Ave 1 1 1 1 1 11/22/1993 12:00:00 AM     Permit Number 32734 5991441.9162308 2097904.96501407 37.7399552051973 -122.472165418715 (37.7399552051973, -122.472165418715)
72553 46476 1 25 454 Funston Ave 1 1 1 1   03/26/2002 12:00:00 AM 6   Permit Number 44671 5991902.97979 2112323.35635 37.7795709761183 -122.471621696685 (37.7795709761183, -122.471621696685)
118505 52473 1 25 454@ ANZA Funston Ave 1 1 1 1 1 12/27/2005 12:00:00 AM     Permit Number 48584 5991906.61756296 2112344.10243716 37.779628149659096 -122.471610624408 (37.7796281496591, -122.471610624408)
109971 12646 3 25 944 Lake St 2 1 1 2     80 3X3   5992487.23998 2114843.45413 37.786524258671896 -122.469784032853 (37.7865242586719, -122.469784032853)
103612 12645 3 25 944 Lake St 1 1 1 2     90 3X3   5992509.49668 2114843.34604 37.786525248314206 -122.469707022996 (37.7865252483142, -122.469707022996)
163208 214172 2 25 1370 12th Ave 1 1 1 1     19 Width 4ft   5992428.9422 2106122.35536 37.76257510589 -122.469350698796 (37.76257510589, -122.469350698796)
130729 43657 1 25 553 10th Ave 1 1 1 1 1 07/25/2000 12:00:00 AM 10   Permit Number 43301 5992810.17 2111710.0413599997 37.777939422957104 -122.468438730278 (37.7779394229571, -122.468438730278)
74596 68931 1 25 655 10th Ave 1 1 1 1 1 12/29/1993 12:00:00 AM 12   Permit Number 32915 5992836.31623 2110994.2871 37.7759756654158 -122.468296198193 (37.7759756654158, -122.468296198193)
36655 123174 2 25 735 10th Ave 1 1 1 1     17 Width 4ft   5992855.85161 2110444.11138 37.7744661593712 -122.468188588983 (37.7744661593712, -122.468188588983)
169541 214180 2 25 350 Santa Ana Ave 1 1 1 1     30 Width 3ft   5992555.06379 2094476.42863 37.7306056595249 -122.46806731945499 (37.7306056595249, -122.468067319455)
77105 214181 2 25 355 Santa Ana Ave 1 1 1 1     16 Width 3ft   5992570.4626400005 2094410.6821599999 37.7304260253276 -122.468009303302 (37.7304260253276, -122.468009303302)
151737 214182 2 25 347 Santa Ana Ave 1 1 1 1     12 Width 3ft   5992605.035 2094526.5774700001 37.7307462415431 -122.467898209135 (37.7307462415431, -122.467898209135)
57971 215009 2 25 220 Santa Ana Ave 1 1 1 1     12 Width 5ft   5992622.02484 2095272.1230799998 37.73279430540261 -122.467893679258 (37.7327943054026, -122.467893679258)
121875 56308 1 25 171 09th Ave 1 1 1 1   07/25/1973 12:00:00 AM 14 3x3 Permit Number 12442 5993024.02697 2114355.6170799998 37.785215804041 -122.467891402947 (37.785215804041, -122.467891402947)
182269 215010 2 25 220 Santa Ana Ave 2 1 1 1     13 Width 5ft   5992623.69978 2095247.7676 37.7327275280451 -122.467886117771 (37.7327275280451, -122.467886117771)
54642 214183 2 25 347 Santa Ana Ave 2 1 1 1     17 Width 3ft   5992610.48002 2094547.7964400002 37.730804817991704 -122.467880927762 (37.7308048179917, -122.467880927762)
Powered by Datasette · Query took 8.643ms · Data source: data.sfgov.org