sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
692 176334 2 103 287 Hester Ave 7 17 1 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
701 176335 2 103 287 Hester Ave 5 17 1 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
24579 247929 2 103 1099 Esmeralda Ave 2 17 1 1     37     6010384.7561099995 2098766.60945 37.743399135274295 -122.40672932282301 (37.7433991352743, -122.406729322823)
25962 209036 2 103 427 Baden St 2 7 1 1     41     6000750.14831 2095370.65935 37.7335308771479 -122.439799837889 (37.7335308771479, -122.439799837889)
25982 247919 2 103 1098 Esmeralda Ave 4 17 1 1     22     6010242.48982 2098715.3752200003 37.743250496220895 -122.40721763491001 (37.7432504962209, -122.40721763491)
26944 224225 2 103 1100 San Jose Ave 15 7 1 1     32     6004862.254919999 2096710.90423 37.737444098063 -122.42567845649201 (37.737444098063, -122.425678456492)
27200 209021 2 103 34 Martha Ave 1 7 1 1     25     6000790.06178 2095561.6998400001 37.7340577017886 -122.43967553722 (37.7340577017886, -122.43967553722)
28853 209017 2 103 33 Martha Ave 1 23 1 1     25     6000774.79116 2095519.5815700002 37.7339411856303 -122.43972531378401 (37.7339411856303, -122.439725313784)
30032 247924 2 103 1098 Esmeralda Ave 9 17 1 1     23     6010297.695230001 2098727.78354 37.7432876562154 -122.40702762254499 (37.7432876562154, -122.407027622545)
30144 209022 2 103 34 Martha Ave 2 7 1 1     33     6000785.93499 2095562.5681900003 37.7340598511869 -122.43968986701401 (37.7340598511869, -122.439689867014)
31541 247930 2 103 1099 Esmeralda Ave 3 17 1 1     18     6010384.98383 2098777.78466 37.7434298327179 -122.406729322818 (37.7434298327179, -122.406729322818)
32543 176345 2 103 450 Raymond Ave 3 9 1 1     34     6008420.88631 2088405.51015 37.7148397004654 -122.412787554496 (37.7148397004654, -122.412787554496)
34595 209040 2 103 419 Baden St 5 7 1 1     1     6000753.71672 2095344.13435 37.7334582487793 -122.43978559983 (37.7334582487793, -122.43978559983)
35228 209038 2 103 419 Baden St 3 7 1 1     6     6000746.779019999 2095349.3205099998 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065)
35692 209045 2 103 300 Melrose Ave 3 17 1 1     88     5998032.3562900005 2095523.6559099997 37.733795893852296 -122.44920699922599 (37.7337958938523, -122.449206999226)
36668 209041 2 103 419 Baden St 6 7 1 1     1     6000751.4342 2095340.2355900002 37.7334474137664 -122.43979321169901 (37.7334474137664, -122.439793211699)
37470 176346 2 103 40 Teddy Ave 1 9 1 1     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861)
39683 191728 2 103 1790 23rd St 5 9 1 1     21     6013472.8835 2102915.30193 37.754962860065 -122.39634201017999 (37.754962860065, -122.39634201018)
41213 224227 2 103 1100 San Jose Ave 17 7 1 1     12     6004843.36157 2096707.31423 37.7374331731056 -122.425743524245 (37.7374331731056, -122.425743524245)
41325 224244 2 103 1100 San Jose Ave 38 7 1 1     23     6004777.47133 2096641.4622900002 37.73724863492671 -122.425966651467 (37.7372486349267, -122.425966651467)
42046 209030 2 103 36 Martha Ave 7 7 1 1     5     6000755.13076 2095576.9220900002 37.7340975102859 -122.439797395328 (37.7340975102859, -122.439797395328)
42995 52091 1 103 300 Dorantes Ave 2 1 1 1   10/24/2005 12:00:00 AM     Permit Number 48287 5993176.51233561 2099718.04340733 37.745033690620396 -122.46629968747601 (37.7450336906204, -122.466299687476)
43077 191722 2 103 1100 25th St 1 2 1 1     18     6014479.640380001 2101959.5389 37.752394509601494 -122.392793471535 (37.7523945096015, -122.392793471535)
43267 121204 2 103 44 MacOndray Ln 1 20 1 1     52     6008473.20212 2119153.5676 37.799269800719294 -122.41478152415002 (37.7992698007193, -122.41478152415)
43329 111546 3 103 900x BOSWORTH ST 24 7 1 2     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
43564 207757 2 103 95 Kirkham St 8 9 1 1     24     5994806.26925 2105291.62903 37.760431240817795 -122.46106822873399 (37.7604312408178, -122.461068228734)
45082 209042 2 103 419 Baden St 7 7 1 1     7     6000746.1619 2095340.78312 37.7334486170489 -122.439811478728 (37.7334486170489, -122.439811478728)
45967 209014 2 103 412 Baden St 2 17 1 1     7     6000787.79858 2095464.06576 37.733789492485 -122.43967636459601 (37.733789492485, -122.439676364596)
46194 247925 2 103 1098 Esmeralda Ave 10 17 1 1     25     6010304.27631 2098731.76841 37.743298966077795 -122.407005147582 (37.7432989660778, -122.407005147582)
48059 43994 1 103 141 Hampshire St 2 1 1 1   09/08/2000 12:00:00 AM 18   Permit Number 43551 6010001.85414 2107517.13485 37.7674046909874 -122.408670488759 (37.7674046909874, -122.408670488759)
48153 209013 2 103 412 Baden St 1 17 1 1     20     6000780.48794 2095392.50815 37.7335925958074 -122.439696511209 (37.7335925958074, -122.439696511209)
48548 65198 1 103 371 Madrid St 1 1 1 1 1 07/29/1989 12:00:00 AM 34   Permit Number 27183 6003158.74485 2091706.4873099998 37.7236066919673 -122.431211180179 (37.7236066919673, -122.431211180179)
48572 224238 2 103 1100 San Jose Ave 30 7 1 1     6     6004809.6017 2096680.0059200001 37.737356282853 -122.425858304718 (37.737356282853, -122.425858304718)
50757 191735 2 103 100 Hampshire St 8 7 1 1     27     6010009.096969999 2107534.42743 37.7674525780981 -122.408646656734 (37.7674525780981, -122.408646656734)
50832 224239 2 103 1100 San Jose Ave 36 7 1 1     37     6004801.05123 2096666.83115 37.7373196246961 -122.425886930149 (37.7373196246961, -122.425886930149)
51062 224245 2 103 160 Coso Ave 2 2 1 1     32     6007485.6356 2099587.10163 37.7454893881214 -122.41681188667201 (37.7454893881214, -122.416811886672)
54108 176348 2 103 0 Fuente Ave 2 2 1 1     26     5989603.79735 2090546.09261 37.7196430676648 -122.47798295295799 (37.7196430676648, -122.477982952958)
55507 191724 3 103 950x Kansas St 5 3 1 2     43     6011608.5229400005 2103823.60133 37.7573529289142 -122.402853412073 (37.7573529289142, -122.402853412073)
56581 209009 2 103 408 Baden St 1 7 1 1     9     6000785.2821 2095342.6683900002 37.7334560202787 -122.439676364582 (37.7334560202787, -122.439676364582)
56692 247937 2 103 1149 Esmeralda Ave 2 7 1 1     24     6010236.06133 2098747.86868 37.7433393564296 -122.40724215312599 (37.7433393564296, -122.407242153126)
57024 209025 2 103 36 Martha Ave 2 7 1 1     46     6000769.58789 2095570.4874200001 37.7340806650885 -122.43974695145599 (37.7340806650885, -122.439746951456)
59219 247999 2 103 346 Peralta Ave 3 17 1 1     35     6009771.618319999 2099231.70155 37.744641851750295 -122.40888221345101 (37.7446418517503, -122.408882213451)
59867 247926 2 103 1098 Esmeralda Ave 11 17 1 1     27     6010312.05046 2098736.31721 37.743311891127604 -122.406978587005 (37.7433118911276, -122.406978587005)
61204 224222 2 103 1100 San Jose Ave 3 7 1 1     14     6004869.898159999 2096730.73115 37.7374989702074 -122.42565344095199 (37.7374989702074, -122.425653440952)
61471 224223 2 103 1100 San Jose Ave 13 7 1 1     21     6004855.412690001 2096718.43509 37.7374643894683 -122.425702649156 (37.7374643894683, -122.425702649156)
61748 224243 2 103 1100 San Jose Ave 39 7 1 1     20     6004771.77471 2096643.7523700001 37.737254601020005 -122.425986510284 (37.73725460102, -122.425986510284)
62115 247923 2 103 1098 Esmeralda Ave 8 17 1 1     17     6010288.87158 2098729.72842 37.7432925026595 -122.40705826963699 (37.7432925026595, -122.407058269637)
63043 209019 2 103 33 Martha Ave 2 23 1 1     12     6000764.3171 2095528.5679900001 37.7339652640682 -122.43976216978201 (37.7339652640682, -122.439762169782)
63465 224224 2 103 1100 San Jose Ave 14 7 1 1     18     6004854.036780001 2096713.3958700001 37.737450475157296 -122.42570704776199 (37.7374504751573, -122.425707047762)
63720 224229 2 103 1100 San Jose Ave 19 7 1 1     14     6004833.29966 2096702.67223 37.7374198586269 -122.425777982686 (37.7374198586269, -122.425777982686)
63741 246757 2 103 70 Waltham St 1 7 1 1     27     6009117.20748 2098899.99025 37.7436943673943 -122.41112161978998 (37.7436943673943, -122.41112161979)
63892 224237 2 103 1100 San Jose Ave 29 7 1 1     19     6004814.56562 2096681.78705 37.7373614539559 -122.425841268876 (37.7373614539559, -122.425841268876)
66266 191737 2 103 200 Helena St 2 2 1 1     5     6010885.73151 2096220.33708 37.736435634280895 -122.40481783988199 (37.7364356342809, -122.404817839882)
68974 224228 2 103 1100 San Jose Ave 18 7 1 1     15     6004840.27089 2096702.3446900002 37.7374193532181 -122.425753856564 (37.7374193532181, -122.425753856564)
70101 247851 2 103 152 Chapman St 3 17 1 1     79     6009070.86749 2098234.59559 37.7418647407582 -122.411234858803 (37.7418647407582, -122.411234858803)
70209 191734 2 103 100 Hampshire St 7 7 1 1     22     6009976.801940001 2107534.39117 37.767450669731105 -122.40875835881201 (37.7674506697311, -122.408758358812)
70884 247927 2 103 1098 Esmeralda Ave 12 17 1 1     34     6010318.55961 2098736.7728 37.7433135063186 -122.40695611204501 (37.7433135063186, -122.406956112045)
71482 176344 2 103 450 Raymond Ave 2 9 1 1     8     6008453.924319999 2088393.6006200002 37.714808853708604 -122.41267251952299 (37.7148088537086, -122.412672519523)
71541 224269 2 103 2300 22nd St 7 7 1 1     23     6011241.96431 2103719.95233 37.7570478572995 -122.404113828986 (37.7570478572995, -122.404113828986)
72350 209029 2 103 36 Martha Ave 6 7 1 1     18     6000758.12976 2095576.10922 37.7340954490409 -122.43978696861299 (37.7340954490409, -122.439786968613)
72359 209033 2 103 38 Martha Ave 2 7 1 1     10     6000746.954419999 2095582.5977 37.7341126287783 -122.439826070211 (37.7341126287783, -122.439826070211)
73320 224268 2 103 2300 22nd St 6 7 1 1     28     6011248.24436 2103720.25065 37.757049027311204 -122.40409213106001 (37.7570490273112, -122.40409213106)
73493 224246 2 103 483 Valley St 10 2 1 1     55     6002830.24391 2099168.61142 37.744077360782796 -122.432879592517 (37.7440773607828, -122.432879592517)
74012 247935 2 103 1099 Esmeralda Ave 8 17 1 1     31     6010295.56922 2098768.42696 37.743399135252204 -122.407037837932 (37.7433991352522, -122.407037837932)
75518 191738 2 103 920 Vermont St 1 2 1 1     39     6011311.04969 2104026.1978700003 37.757892599481 -122.40389645386699 (37.757892599481, -122.403896453867)
76551 224247 2 103 527 Powhattan Ave 1 2 1 1     46     6008745.222630001 2098103.60695 37.74148680607821 -122.412351580256 (37.7414868060782, -122.412351580256)
77296 209024 2 103 36 Martha Ave 1 7 1 1     32     6000772.29534 2095570.30388 37.7340803152378 -122.43973757782601 (37.7340803152378, -122.439737577826)
79476 116530 3 103 745X SANCHEZ ST 7 3 1 2     45     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
88008 111551 3 103 900x BOSWORTH ST 29 7 1 2     27     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
92343 113367 3 103 6X Christopher Dr 1 7 1 2     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361)
92772 114075 2 103 24 HIGUERA AVE 1 2 1 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
92885 111536 3 103 900x BOSWORTH ST 14 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
100681 111529 3 103 900x BOSWORTH ST 7 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
102874 111513 3 103 800x BOSWORTH ST 8 7 1 2     16     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
103214 106173 6 103 267 Green St 1 7 1 1         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098)
105251 92899 6 103 208 States St 3 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
106180 106794 3 103 199X ARLINGTON ST 51 11 1 2     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
108603 114396 1 103 35 HIGUERA AVE 3 1 1 1           5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
109383 106792 3 103 199X ARLINGTON ST 1 11 1 2     15     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
111260 111511 3 103 800x BOSWORTH ST 6 7 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
113760 106810 3 103 3500X MISSION ST 10 11 1 2     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
113956 114069 2 103 2 HIGUERA AVE 2 2 1 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
114512 108201 2 103 90 Reuel Ct 2 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
117576 111525 3 103 900x BOSWORTH ST 3 7 1 2     26     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
119166 92897 6 103 208 States St 1 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
119476 108200 2 103 90 Reuel Ct 1 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
120548 111538 3 103 900x BOSWORTH ST 16 7 1 2     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
122260 66251 1 103 35 HIGUERA AVE 2 1 1 1   10/24/1990 12:00:00 AM     Permit Number 29352 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
124116 224234 2 103 1100 San Jose Ave 24 7 1 1     13     6004836.880530001 2096694.1378 37.7373966273622 -122.425764994654 (37.7373966273622, -122.425764994654)
127427 106795 3 103 199X ARLINGTON ST 55 11 1 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
128646 92900 6 103 208 States St 4 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
Powered by Datasette · Query took 10.322ms · Data source: data.sfgov.org