sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92 98091 3 35 2X Frank Norris St 4 1 1 4 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
343 244298 3 35 350 Octavia St 1 1 1 2     6 Width 0ft   6005605.7628 2110511.5277 37.7753793775331 -122.42408895277501 (37.7753793775331, -122.424088952775)
605 23903 3 35 1600X Webster St 6 11 1 2     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251)
1472 244877 2 35 1349 Page St 1 1 1 1     15 Width 0ft   6000105.0 2109153.0 37.7713370947812 -122.443019734512 (37.7713370947812, -122.443019734512)
2489 119760 3 35 101X Octavia St Frontage West 2 1 1 2       4x4            
2492 119762 3 35 101X Octavia St Frontage West 4 1 1 2       4x4            
2501 119761 3 35 101X Octavia St Frontage West 3 1 1 2       4x4            
2508 119759 3 35 101X Octavia St Frontage West 1 1 1 2       4x4            
2550 138186 3 35 1865 Buchanan St 6 1 1 2     2 Width 0ft   6003941.622 2114719.9923 37.786840675810396 -122.43014589889499 (37.7868406758104, -122.430145898895)
2613 98090 3 35 2X Frank Norris St 3 1 1 4 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
3194 253362 1 35 1737 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3199 253365 1 35 1745 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3209 253364 1 35 1741 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3215 253360 1 35 1723 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3221 253361 1 35 1737 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3234 253359 1 35 1723 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3238 253363 1 35 1741 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3398 245004 2 35 1201 Page St 2 1 1 1     6 Width 0ft   6000727.3724 2109263.3505 37.7716755548589 -122.44087484303499 (37.7716755548589, -122.440874843035)
3528 13088 1 35 722 Lombard St 1 1 1 1     45 3X3   6008925.6016 2120449.3844 37.802853199751794 -122.413307745784 (37.8028531997518, -122.413307745784)
3617 196400 2 35 380x Clara St 2 1 1 1     1 Width 2ft   6011308.09655 2111275.91215 37.7777985048225 -122.404416956276 (37.7777985048225, -122.404416956276)
4145 113403 2 35 2052 Polk St 1 1 1 1     4 3x3   6006463.2485 2117908.2188 37.7957372487994 -122.42164817262501 (37.7957372487994, -122.421648172625)
4166 143128 2 35 2052 POLK ST 2 1 1 1     4 Width 0ft   6006467.2287 2117887.8753 37.795681615093 -122.421632954779 (37.795681615093, -122.421632954779)
4309 1910 3 35 47 Beideman St 2 1 1 2     6 3X3   6001514.9606 2113070.1349 37.782172849750296 -122.43842331734601 (37.7821728497503, -122.438423317346)
4516 28647 3 35 1600X Webster St 9 11 1 2     8 6   6003547.8453 2114380.4001 37.785885930849204 -122.431484021877 (37.7858859308492, -122.431484021877)
4753 98088 3 35 2X Frank Norris St 1 1 1 4 2   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.41900880992901 (37.7893685797349, -122.419008809929)
5333 26937 1 35 1529 Golden Gate Ave 2 1 1 1     3 3X3   6002019.9705 2111862.8998 37.7788867994939 -122.436589775324 (37.7788867994939, -122.436589775324)
5350 28646 3 35 1600X Webster St 8 11 1 2     8 6   6003557.7645 2114374.9896 37.7858716371659 -122.431449317827 (37.7858716371659, -122.431449317827)
5957 28643 3 35 1300 Webster St 5 11 1 2     10 20   6003700.2631 2113325.6745 37.7829985565916 -122.43088139933201 (37.7829985565916, -122.430881399332)
5979 98098 2 35 81 Frank Norris St 4 1 1 1     3 3x3   6006897.32558 2115510.94052 37.789179385771604 -122.41997598040399 (37.7891793857716, -122.419975980404)
5993 23902 3 35 1600X Webster St 5 11 1 2     8 20   6003560.0188 2114334.411 37.7857603463241 -122.431438620741 (37.7857603463241, -122.431438620741)
6273 106722 2 35 2905 Bush St 1 1 1 1     5 3x3   5999550.4676 2114295.9601 37.7854267102234 -122.44530771900499 (37.7854267102234, -122.445307719005)
6354 98096 2 35 81 Frank Norris St 2 1 1 1     3 3x3   6006843.26628 2115504.44745 37.789158511592 -122.420162558272 (37.789158511592, -122.420162558272)
6475 23884 3 35 1750X Geary Blvd 1 1 1 2     3 3X3   6003258.4682 2113929.8349 37.7846323872704 -122.432452992684 (37.7846323872704, -122.432452992684)
6496 23490 3 35 2500X Van Ness Ave 6 11 1 2     30 9   6005777.87956 2119177.1307599996 37.799182688783496 -122.424109961515 (37.7991826887835, -122.424109961515)
6792 23871 3 35 1499X Webster St 4 1 1 2     12 3X3   6003600.3539 2113692.9201 37.784001259600295 -122.43125326646499 (37.7840012596003, -122.431253266465)
6947 26936 1 35 1529 Golden Gate Ave 1 1 1 1     3 3X3   6002004.7416 2111860.8692 37.7788803585551 -122.436642312661 (37.7788803585551, -122.436642312661)
7067 28641 3 35 1300 Webster St 3 11 1 2     8 20   6003709.2011 2113267.9212 37.7828404869024 -122.43084635463 (37.7828404869024, -122.43084635463)
7387 98089 3 35 2X Frank Norris St 2 1 1 4 2   3 3x3   6007160.90241 2115572.1732 37.789362361841505 -122.41906838009899 (37.7893623618415, -122.419068380099)
7425 8168 1 35 1160 Fulton St 1 1 1 1     35 3X3   6002214.9627 2111253.4218 37.7772244047313 -122.435871600468 (37.7772244047313, -122.435871600468)
7927 13089 1 35 722 Lombard St 2 1 1 1     60 3X3   6008909.0684 2120447.731 37.8028477316821 -122.41336484235 (37.8028477316821, -122.41336484235)
8518 18226 3 35 1675 Post St 3 1 1 2     12 3X3   6004172.0667 2114245.454 37.785550761919 -122.42931476245899 (37.785550761919, -122.429314762459)
8560 98097 2 35 81 Frank Norris St 3 1 1 1     3 3x3   6006875.6654 2115508.14993 37.789170503156704 -122.420050723983 (37.7891705031567, -122.420050723983)
8638 98095 2 35 81 Frank Norris St 1 1 1 1     3 3x3   6006820.270769999 2115499.9051599996 37.789144743881295 -122.420241797518 (37.7891447438813, -122.420241797518)
8790 105143 2 35 432 Octavia St 1 1 1 3 2   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933)
9626 173611 2 35 3779 25th St 1 1 1 1     7 3x3   6005304.0 2101328.0 37.7501465436699 -122.424479453971 (37.7501465436699, -122.424479453971)
10144 173880 2 35 1922 Grove St 1 1 1 1       3x3   5998581.0 2110425.0 37.7747426714218 -122.448382913575 (37.7747426714218, -122.448382913575)
10200 122374 2 35 95x Tompkins Ave 2 1 1 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
10400 94994 1 35 82 Leland Ave 1 1 1 1     3 3x3   6010574.5301 2087274.9346 37.7118560160688 -122.405264057289 (37.7118560160688, -122.405264057289)
10403 95015 1 35 83 Leland Ave 1 1 1 1     3     6010521.9467 2087254.8816 37.711798014587295 -122.40544438972 (37.7117980145873, -122.40544438972)
10438 95023 1 35 45 Leland Ave 2 1 1 1     3 3x3   6010750.3281 2087136.1233 37.711484695229295 -122.404646681546 (37.7114846952293, -122.404646681546)
10565 94985 1 35 6 Leland Ave 4 1 1 1     3 3x3   6010907.8555 2087101.5876 37.7113986701374 -122.40409979381799 (37.7113986701374, -122.404099793818)
10735 95001 1 35 166 Leland Ave 1 1 1 1     3 3x3   6010153.2106 2087493.0431 37.712431333442 -122.40673562308099 (37.712431333442, -122.406735623081)
10780 26783 1 35 6 Leland Ave 2 1 1 1     3 4X4   6010951.9721 2087077.0783 37.711333837408205 -122.40394559103301 (37.7113338374082, -122.403945591033)
10788 94995 1 35 88 Leland Ave 1 1 1 1     3 3x3   6010547.3472 2087288.7489 37.711892427555796 -122.40535898167299 (37.7118924275558, -122.405358981673)
11078 94996 1 35 116 Leland Ave 1 1 1 1     3 3x3   6010370.4352 2087379.2102 37.7121309230244 -122.405976810763 (37.7121309230244, -122.405976810763)
11134 95007 1 35 185 Leland Ave 1 1 1 1     3 3x3   6010037.7782 2087495.7404 37.712432280377705 -122.40713478458 (37.7124322803777, -122.40713478458)
11165 95019 1 35 65 Leland Ave 2 1 1 1     3 3x3   6010608.3974 2087210.3194 37.7116804891797 -122.40514245485001 (37.7116804891797, -122.40514245485)
11181 95011 1 35 141 Leland Ave 5 1 1 1     4 3x3   6010324.7589 2087356.7063 37.7120665771229 -122.406133097694 (37.7120665771229, -122.406133097694)
11288 95020 3 35 57 Leland Ave 1 1 1 2     3 3x3   6010631.1241 2087198.2876 37.711648722790706 -122.40506305817699 (37.7116487227907, -122.405063058177)
11451 94993 1 35 66 Leland Ave 2 1 1 1     3 3x3   6010619.538 2087251.7622 37.711794905553106 -122.405106866024 (37.7117949055531, -122.405106866024)
11522 94986 1 35 6 Leland Ave 5 1 1 1     3 3x3   6010873.097 2087120.3037 37.711448118617 -122.404221245197 (37.711448118617, -122.404221245197)
11559 27104 1 35 637 Silver Ave 1 1 1 1     3 2X3   6005511.99058 2093568.16222 37.7288515201802 -122.423208682549 (37.7288515201802, -122.423208682549)
11612 95017 1 35 73 Leland Ave 1 1 1 1     3 3x3   6010561.1615 2087236.1655 37.7117488165229 -122.40530753468501 (37.7117488165229, -122.405307534685)
11741 94992 3 35 66 Leland Ave 1 1 1 2     3 3x3   6010640.4822 2087242.4042 37.7117703812114 -122.40503381823 (37.7117703812114, -122.40503381823)
11754 95026 1 35 33 Leland Ave 1 1 1 1     3 3x3   6010809.5958 2087105.821 37.7114048035242 -122.404439704211 (37.7114048035242, -122.404439704211)
11772 95029 1 35 13 Leland Ave 1 1 1 1     3 3x3   6010870.6461 2087075.073 37.71132378726 -122.40422653482 (37.71132378726, -122.40422653482)
11844 95027 1 35 29 Leland Ave 1 1 1 1     3 3x3   6010839.0069 2087091.1154 37.711366068478 -122.404337016935 (37.711366068478, -122.404337016935)
11845 95018 1 35 65 Leland Ave 1 1 1 1     3 3x3   6010587.8988 2087221.4599 37.7117099327517 -122.40521408790899 (37.7117099327517, -122.405214087909)
11853 94988 1 35 38 Leland Ave 1 1 1 1     3 3x3   6010771.4951 2087173.3327 37.711588047755605 -122.40457614013901 (37.7115880477556, -122.404576140139)
11856 95002 1 35 170 Leland Ave 1 1 1 1     3 3x3   6010131.1046 2087504.7217 37.712462163614795 -122.406812851088 (37.7124621636148, -122.406812851088)
12055 95028 1 35 21 Leland Ave 1 1 1 1     3 3x3   6010854.6037 2087083.0942 37.711344915432 -122.404282545919 (37.711344915432, -122.404282545919)
12204 95003 3 35 176 Leland Ave 1 1 1 2     3 3x3   6010111.9182 2087516.8174 37.7124943023778 -122.406880017452 (37.7124943023778, -122.406880017452)
12239 95010 1 35 141 Leland Ave 4 1 1 1     3 3x3   6010304.2603 2087368.7381 37.7120984674199 -122.406204794273 (37.7120984674199, -122.406204794273)
12283 95024 1 35 41 Leland Ave 1 1 1 1     3 3x3   6010769.0442 2087127.6565 37.7114624931322 -122.404581397838 (37.7114624931322, -122.404581397838)
12450 26799 1 35 141 Leland Ave 3 1 1 1     3 3x3   6010285.5441 2087377.2049 37.7121206686095 -122.40627007937 (37.7121206686095, -122.40627007937)
12621 95008 1 35 167 Leland Ave 1 1 1 1     3 3x3   6010080.5579 2087480.5892 37.712393072261705 -122.40698585693501 (37.7123930722617, -122.406985856935)
12738 95005 1 35 201X Leland Ave 1 1 1 1     3     6009777.312000001 2087590.4351 37.71267771272821 -122.40804171326799 (37.7126777127282, -122.408041713268)
12802 26786 1 35 34 Leland Ave 1 1 1 1     3 3X3   6010794.6675 2087161.3009 37.7115563058928 -122.404495203342 (37.7115563058928, -122.404495203342)
12814 95025 1 35 37 Leland Ave 1 1 1 1     3 3x3   6010791.7709 2087116.9615 37.7114343969477 -122.40450209567699 (37.7114343969477, -122.404502095677)
12883 26798 1 35 141 Leland Ave 2 1 1 1     3 3x3   6010259.698 2087389.6823 37.71215348320929 -122.406360290051 (37.7121534832093, -122.406360290051)
12999 94997 1 35 134 Leland Ave 1 1 1 1     3 3x3   6010302.5304 2087413.7951 37.7122220880479 -122.40621394582399 (37.7122220880479, -122.406213945824)
13116 26784 1 35 6 Leland Ave 3 1 1 1     3 4X4   6010928.7998 2087090.8926 37.7113704740421 -122.40402665236999 (37.7113704740421, -122.40402665237)
13302 187656 1 35 1548 Sanchez St 2 1 1 1       3x3   6003789.0 2099328.0 37.744569337434 -122.42957579341999 (37.744569337434, -122.42957579342)
18799 11188 3 35 100 Idora Ave 1 11 1 2     24 8   5995291.088769999 2099424.10153 37.7443483813689 -122.45896663000299 (37.7443483813689, -122.458966630003)
18983 11186 3 35 100 Idora Ave 2 11 1 2     18 8   5995298.39303 2099423.25523 37.7443464775133 -122.458941312315 (37.7443464775133, -122.458941312315)
19557 119842 3 35 350 Octavia St Frontage East 2 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
19795 9378 3 35 320 Gold Mine Dr 1 1 1 2     6 2X2   6001091.814301901 2097867.0769738997 37.740404899832896 -122.438797433034 (37.7404048998329, -122.438797433034)
23661 142764 2 35 400 FILBERT ST 7 1 1 1     2 Width 0ft   6010752.149 2120007.2027 37.801741456909596 -122.40695573845899 (37.8017414569096, -122.406955738459)
23801 183452 2 35 2519 23rd Ave 1 1 1 1     8 Width 0ft   5989212.0936 2098169.1351 37.7405512532287 -122.479894458871 (37.7405512532287, -122.479894458871)
23893 238011 2 35 170 Upper Ter 4 1 1 1     10 Width 4ft   5999678.6983900005 2106620.27376 37.7643585496334 -122.444312287003 (37.7643585496334, -122.444312287003)
23946 113286 2 35 1626 Pierce St 2 1 1 1     3 3x3   6002122.0899 2114184.377 37.7852667906839 -122.43640269829099 (37.7852667906839, -122.436402698291)
24060 182205 2 35 1651 26th Ave 1 1 1 1     2 Width 0ft   5988079.8655 2104054.0379 37.756643783163206 -122.484240699303 (37.7566437831632, -122.484240699303)
24062 237974 2 35 250 Fair Oaks St 1 1 1 1     15 Width 5ft   6005423.51837 2102260.48733 37.752713687090896 -122.424132459851 (37.7527136870909, -122.424132459851)
24086 178876 2 35 852 Paris St 2 1 1 1     1 Width 2ft   6000760.9108 2088982.59449 37.7159913219087 -122.439304903221 (37.7159913219087, -122.439304903221)
24195 244515 2 35 426 Fillmore St 1 1 1 1     4 Width 0ft   6003699.3803 2109847.5959 37.7734485650794 -122.430636186348 (37.7734485650794, -122.430636186348)
24204 238028 2 35 251 Alma St 10 1 1 1     5 Width 3ft   5997698.52987 2106146.63858 37.7629448927014 -122.45112694477699 (37.7629448927014, -122.451126944777)
24350 214468 2 35 623 Gennessee St 5 9 1 1     2 Width 10ft   5997445.526980001 2095470.2100900002 37.7336155617911 -122.451231980178 (37.7336155617911, -122.451231980178)
24369 237998 2 35 338 Hoffman Ave 1 9 1 1     3 Width 3ft   6000611.91644 2101788.98208 37.7511462020375 -122.440737977395 (37.7511462020375, -122.440737977395)
24617 181947 2 35 1651 Taraval St 1 1 1 1     1 Width 0ft   5988027.6673 2098939.5018 37.7425975937033 -122.484046173892 (37.7425975937033, -122.484046173892)
24630 184291 2 35 1543 41st Ave 1 2 1 1     3 Width 0ft   5983404.3155 2104639.3384 37.7579775103532 -122.50045345703501 (37.7579775103532, -122.500453457035)
24750 182725 2 35 1734 29th Ave 1 1 1 1     1 Width 0ft   5987217.2069 2103447.5916 37.7549283802803 -122.487179505586 (37.7549283802803, -122.487179505586)
Powered by Datasette · Query took 21.014ms · Data source: data.sfgov.org