sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28294 188658 2 5 100 Cargo Way 124 2 1 1     10     6016703.96276 2099238.37904 37.7450460592258 -122.384911766374 (37.7450460592258, -122.384911766374)
26454 188657 2 5 100 Cargo Way 123 2 1 1     12     6016750.167669999 2099204.87087 37.744956608177205 -122.38474966268801 (37.7449566081772, -122.384749662688)
56563 188656 2 5 100 Cargo Way 122 2 1 1     2     6016757.253769999 2099196.6677 37.7449344758533 -122.384724588679 (37.7449344758533, -122.384724588679)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
32317 186821 2 5 1200 Sunset Blvd 105 9 1 1     3 Width 0ft   5984828.6477 2106722.4547 37.763780672010896 -122.49568123753599 (37.7637806720109, -122.495681237536)
153690 186825 2 5 1200 Sunset Blvd 100 9 1 1     4 Width 0ft   5984841.1725 2106636.9913 37.763546746968295 -122.49563161459999 (37.7635467469683, -122.4956316146)
49403 186616 2 5 1501 Sunset Blvd 87 9 1 1     3 Width 0ft   5984717.3898 2104397.9779 37.75739179261161 -122.495894553165 (37.7573917926116, -122.495894553165)
131350 186614 2 5 1501 Sunset Blvd 85 9 1 1     57 Width 0ft   5984775.1737 2104397.9779 37.7573951766754 -122.495694716519 (37.7573951766754, -122.495694716519)
159840 186613 2 5 1501 Sunset Blvd 84 9 1 1     6 Width 0ft   5984762.1933 2104405.0962 37.7574139613926 -122.49574013227699 (37.7574139613926, -122.495740132277)
35253 186612 2 5 1501 Sunset Blvd 83 9 1 1     10 Width 0ft   5984740.0009 2104413.4707 37.7574356557736 -122.49581749901002 (37.7574356557736, -122.49581749901)
167469 186611 2 5 1501 Sunset Blvd 82 9 1 1     7 Width 0ft   5984721.5770000005 2104411.7958 37.7574299779546 -122.49588109168998 (37.7574299779546, -122.49588109169)
67433 186610 2 5 1501 Sunset Blvd 81 9 1 1     6 Width 0ft   5984720.7396 2104420.1703 37.7574529229595 -122.49588460547199 (37.7574529229595, -122.495884605472)
70272 186802 2 5 1200 Sunset Blvd 80 9 1 1     10 Width 0ft   5984846.4625 2106932.8738 37.76435946696029 -122.495635143928 (37.7643594669603, -122.495635143928)
172909 186609 2 5 1501 Sunset Blvd 80 9 1 1     7 Width 0ft   5984732.0451 2104419.3328 37.7574512855375 -122.49584544534599 (37.7574512855375, -122.495845445346)
155155 186608 2 5 1501 Sunset Blvd 79 9 1 1     7 Width 0ft   5984734.9762 2104426.0324 37.757469852437794 -122.49583580278299 (37.7574698524378, -122.495835802783)
181452 220191 2 5 1101 San Jose Ave 79 7 1 1     11     6004894.80738 2096532.47755 37.7369560180099 -122.425553212433 (37.7369560180099, -122.425553212433)
53208 220190 2 5 1101 San Jose Ave 78 7 1 1     8     6004897.78998 2096535.50608 37.73696450219779 -122.425543115723 (37.7369645021978, -122.425543115723)
146508 220189 2 5 1101 San Jose Ave 77 7 1 1     10     6004903.37501 2096531.93768 37.7369550197456 -122.425523551887 (37.7369550197456, -122.425523551887)
163668 186606 2 5 1501 Sunset Blvd 77 9 1 1     10 Width 0ft   5984755.9124 2104439.8503 37.757509018663505 -122.495764417358 (37.7575090186635, -122.495764417358)
176241 184888 2 5 1201 Sunset Blvd 77 9 1 1     1 Width 0ft   5984676.0208 2106738.9985 37.7638171575071 -122.496210339991 (37.7638171575071, -122.496210339991)
51775 184075 2 5 1600 Sunset Blvd 76 9 1 1     1 Width 0ft   5984932.9377 2104018.8187 37.756363348236604 -122.49512115533199 (37.7563633482366, -122.495121155332)
178188 220188 2 5 1101 San Jose Ave 76 7 1 1     6     6004898.43848 2096540.4001099998 37.736977976744 -122.425541221768 (37.736977976744, -122.425541221768)
65971 220202 2 5 1300 San Jose Ave 75 7 1 1     7     6003538.0871 2095667.4408599997 37.7345040713105 -122.430182303581 (37.7345040713105, -122.430182303581)
182151 220187 2 5 1101 San Jose Ave 75 7 1 1     8     6004907.90324 2096539.115 37.736974982905295 -122.42550840641 (37.7369749829053, -122.42550840641)
185060 184887 2 5 1201 Sunset Blvd 75 9 1 1     1 Width 0ft   5984636.53 2106768.6166 37.763896167173705 -122.496349110122 (37.7638961671737, -122.496349110122)
29433 186603 2 5 1501 Sunset Blvd 74 9 1 1     9 Width 0ft   5984731.2077 2104430.2197 37.7574811288953 -122.49584914444799 (37.7574811288953, -122.495849144448)
170910 220201 2 5 1300 San Jose Ave 74 7 1 1     7 Width 5ft   6003510.43036 2095660.01539 37.734482116158105 -122.430277392481 (37.7344821161581, -122.430277392481)
171906 220186 2 5 1101 San Jose Ave 74 7 1 1     12     6004903.97159 2096543.19438 37.736985961816295 -122.42552229012699 (37.7369859618163, -122.425522290127)
30490 184072 2 5 1600 Sunset Blvd 73 9 1 1     3 Width 0ft   5984928.5463 2103997.684 37.756305061112705 -122.495134783659 (37.7563050611127, -122.495134783659)
35284 186795 2 5 1200 Sunset Blvd 73 9 1 1     1 Width 0ft   5984860.9644 2106903.0931 37.764278546741295 -122.49558278994301 (37.7642785467413, -122.495582789943)
41974 184884 2 5 1201 Sunset Blvd 73 9 1 1     6 Width 0ft   5984688.9312 2106783.4256 37.7639398980625 -122.49616896553101 (37.7639398980625, -122.496168965531)
158439 220185 2 5 1101 San Jose Ave 73 7 1 1     6     6004909.032430001 2096549.6336299998 37.7370039284954 -122.42550525066002 (37.7370039284954, -122.42550525066)
160587 220200 2 5 1300 San Jose Ave 73 7 1 1     8 Width 5ft   6003513.54179 2095663.72893 37.7344924889333 -122.430266900093 (37.7344924889333, -122.430266900093)
188967 186602 2 5 1501 Sunset Blvd 73 9 1 1     5 Width 0ft   5984723.2519 2104439.4316 37.7575059562709 -122.495877337913 (37.7575059562709, -122.495877337913)
165475 220184 2 5 1101 San Jose Ave 72 7 1 1     14     6004926.8696 2096549.97699 37.737005879105396 -122.425443603957 (37.7370058791054, -122.425443603957)
177194 184883 2 5 1201 Sunset Blvd 72 9 1 1     6 Width 0ft   5984691.969 2106787.6025 37.763951544593795 -122.49615876703399 (37.7639515445938, -122.496158767034)
30179 184882 2 5 1201 Sunset Blvd 71 9 1 1     5 Width 0ft   5984668.0467 2106784.9445 37.763942845201996 -122.496241309763 (37.763942845202, -122.496241309763)
38042 220199 2 5 1300 San Jose Ave 71 7 1 1     7 Width 5ft   6003519.67627 2095667.91857 37.73450434019979 -122.43024598997499 (37.7345043401998, -122.430245989975)
173065 220183 2 5 1101 San Jose Ave 71 7 1 1     27     6004926.20278 2096562.8505 37.7370411891885 -122.425446825336 (37.7370411891885, -122.425446825336)
28954 186921 2 5 2700 Sunset Blvd 70 9 1 1     5 Width 0ft   5985168.1725 2096748.5598 37.736414961632704 -122.493771912003 (37.7364149616327, -122.493771912003)
42488 220198 2 5 1300 San Jose Ave 70 7 1 1     11 Width 5ft   6003524.19467 2095672.0219999999 37.7345158632135 -122.430230661025 (37.7345158632135, -122.430230661025)
47210 184881 2 5 1201 Sunset Blvd 70 9 1 1     13 Width 0ft   5984647.1621 2106788.3619999997 37.7639510053125 -122.496313794444 (37.7639510053125, -122.496313794444)
74654 220182 2 5 1101 San Jose Ave 70 7 1 1     7     6004985.47233 2096611.09675 37.737177011099604 -122.425245335799 (37.7371770110996, -122.425245335799)
59482 184880 2 5 1201 Sunset Blvd 69 9 1 1     4 Width 0ft   5984640.7069 2106797.4752 37.763975649452 -122.496336793184 (37.763975649452, -122.496336793184)
73216 220197 2 5 1300 San Jose Ave 69 7 1 1     10 Width 5ft   6003530.33086 2095674.11312 37.734521952510796 -122.43020959532 (37.7345219525108, -122.43020959532)
130783 186598 2 5 1501 Sunset Blvd 69 9 1 1     3 Width 0ft   5984775.1737 2104452.8307 37.7575457872194 -122.49569876247699 (37.7575457872194, -122.495698762477)
38739 186794 2 5 1200 Sunset Blvd 68 9 1 1     3 Width 0ft   5984862.0002 2106886.7785 37.7642338120894 -122.495578004049 (37.7642338120894, -122.495578004049)
55241 184879 2 5 1201 Sunset Blvd 68 9 1 1     9 Width 0ft   5984636.1502 2106802.0319 37.7639878939354 -122.49635288946101 (37.7639878939354, -122.496352889461)
76034 220196 2 5 1300 San Jose Ave 68 7 1 1     12 Width 5ft   6003535.06176 2095676.5512700002 37.7345289150748 -122.43019341291401 (37.7345289150748, -122.430193412914)
27189 220159 2 5 1201 San Jose Ave 67 7 1 1     18     6004532.29415 2096115.9287299998 37.73579177907 -122.426776927106 (37.73579177907, -122.426776927106)
38062 220195 2 5 1300 San Jose Ave 67 7 1 1     5 Width 5ft   6003539.74229 2095678.61576 37.734534848798205 -122.43017737800301 (37.7345348487982, -122.430177378003)
42663 184878 2 5 1201 Sunset Blvd 67 9 1 1     4 Width 0ft   5984672.2236 2106800.5130000003 37.763985836593 -122.496228012074 (37.763985836593, -122.496228012074)
24548 184805 2 5 1301 Sunset Blvd 66 9 1 1     17 Width 0ft   5984688.1718 2105711.6678 37.7609971073609 -122.496092516316 (37.7609971073609, -122.496092516316)
47311 220158 2 5 1201 San Jose Ave 66 7 1 1     9     6004531.65878 2096118.78837 37.735799595073104 -122.426779327416 (37.7357995950731, -122.426779327416)
147959 220194 2 5 1300 San Jose Ave 66 7 1 1     13 Width 5ft   6003545.8031 2095679.42322 37.7345374091774 -122.430156481356 (37.7345374091774, -122.430156481356)
179644 184877 2 5 1201 Sunset Blvd 66 9 1 1     11 Width 0ft   5984676.4005 2106805.4493 37.763999634952505 -122.49621392986201 (37.7639996349525, -122.496213929862)
50471 220157 2 5 1201 San Jose Ave 65 7 1 1     3     6004526.08475 2096117.80265 37.7357965733541 -122.426798528853 (37.7357965733541, -122.426798528853)
135166 187379 2 5 2200 Sunset Blvd 65 9 1 1     4 Width 0ft   5985060.734 2100052.5124 37.7454804393236 -122.494386838151 (37.7454804393236, -122.494386838151)
155970 184876 2 5 1201 Sunset Blvd 65 9 1 1     3 Width 0ft   5984660.832 2106807.7277 37.764004978839296 -122.496267944002 (37.7640049788393, -122.496267944002)
164531 186916 2 5 2700 Sunset Blvd 65 9 1 1     1 Width 0ft   5985173.6735 2096745.3508 37.736406472409705 -122.49375265661101 (37.7364064724097, -122.493752656611)
177243 220193 2 5 1300 San Jose Ave 65 7 1 1     9 Width 5ft   6003549.85445 2095682.63787 37.734546465338504 -122.43014270374901 (37.7345464653385, -122.430142703749)
70806 220156 2 5 1201 San Jose Ave 64 7 1 1     4     6004516.6061 2096115.66582 37.7357901701732 -122.426831148142 (37.7357901701732, -122.426831148142)
135813 186790 2 5 1200 Sunset Blvd 64 9 1 1     2 Width 0ft   5984851.9007 2106879.5275 37.764213311472794 -122.49561239995701 (37.7642133114728, -122.495612399957)
138114 220192 2 5 1300 San Jose Ave 64 7 1 1     12 Width 5ft   6003556.22665 2095685.5144599997 37.7345547247094 -122.430120878078 (37.7345547247094, -122.430120878078)
146855 186915 2 5 2700 Sunset Blvd 64 9 1 1     4 Width 0ft   5985160.3793 2096738.0161 37.7363855555031 -122.49379807923401 (37.7363855555031, -122.493798079234)
150808 184875 2 5 1201 Sunset Blvd 64 9 1 1     7 Width 0ft   5984644.1243 2106811.5248 37.764014425890394 -122.496326010311 (37.7640144258904, -122.496326010311)
157545 187378 2 5 2200 Sunset Blvd 64 9 1 1     5 Width 0ft   5985080.0311 2100042.6945 37.745454611339504 -122.494319389248 (37.7454546113395, -122.494319389248)
29694 186789 2 5 1200 Sunset Blvd 63 9 1 1     3 Width 0ft   5984864.8488 2106874.8662 37.7642012710686 -122.495567273023 (37.7642012710686, -122.495567273023)
156817 186913 2 5 2700 Sunset Blvd 62 9 1 1     3 Width 0ft   5985168.1725 2096717.3871 37.7363293697196 -122.493769615567 (37.7363293697196, -122.493769615567)
179664 184874 2 5 1201 Sunset Blvd 62 9 1 1     9 Width 0ft   5984695.3865 2106820.2584 37.7640414086876 -122.496149356564 (37.7640414086876, -122.496149356564)
42429 186912 2 5 2700 Sunset Blvd 61 9 1 1     2 Width 0ft   5985181.9251 2096714.1782 37.736321363521796 -122.493721831405 (37.7363213635218, -122.493721831405)
50308 181501 2 5 1400 Sunset Blvd 61 9 1 1     1 Width 0ft   5984882.2605 2105466.1502 37.7603343510083 -122.495403150426 (37.7603343510083, -122.495403150426)
165781 186788 2 5 1200 Sunset Blvd 61 9 1 1     2 Width 0ft   5984852.1597 2106871.2408 37.7641905736904 -122.495610892905 (37.7641905736904, -122.495610892905)
67384 181500 2 5 1400 Sunset Blvd 60 9 1 1     3 Width 0ft   5984893.9566 2105458.3528 37.760313626354105 -122.49536212461099 (37.7603136263541, -122.495362124611)
159541 184871 2 5 1201 Sunset Blvd 60 9 1 1     12 Width 0ft   5984661.2117 2106828.9919 37.7640633865909 -122.496268199792 (37.7640633865909, -122.496268199792)
172587 184870 2 5 1201 Sunset Blvd 59 9 1 1     17 Width 0ft   5984657.0348 2106822.5367 37.7640454177531 -122.496282169928 (37.7640454177531, -122.496282169928)
42608 184797 2 5 1301 Sunset Blvd 58 9 1 1     3 Width 0ft   5984676.0208 2105815.7109 37.761282068862 -122.496142217022 (37.761282068862, -122.496142217022)
182639 187196 2 5 2301 Sunset Blvd 58 9 1 1     1 Width 0ft   5984952.6117 2099047.6172 37.7427149412723 -122.49468663060101 (37.7427149412723, -122.494686630601)
138203 186787 2 5 1200 Sunset Blvd 57 9 1 1     2 Width 0ft   5984857.5979 2106862.4359999998 37.7641667166364 -122.495591434544 (37.7641667166364, -122.495591434544)
147407 188588 3 5 900x Carolina St 57 3 1 2     13     6012513.0739 2102944.23906 37.754988858573 -122.399663356681 (37.754988858573, -122.399663356681)
184990 221388 2 5 671 Church St 57 7 1 1     17 Width 3ft   6004298.752230001 2105308.1718200003 37.7610183389455 -122.428239289531 (37.7610183389455, -122.428239289531)
73850 184867 2 5 1201 Sunset Blvd 56 9 1 1     11 Width 0ft   5984635.0111 2106821.7773 37.7640420425175 -122.496358286248 (37.7640420425175, -122.496358286248)
63150 188587 3 5 900x Carolina St 55 3 1 2     16     6012500.08207 2102956.31087 37.7550212809088 -122.399709133985 (37.7550212809088, -122.399709133985)
153394 185996 2 5 2001 Sunset Blvd 55 9 1 1     13 Width 0ft   5984845.7236 2100974.1524 37.7479984261704 -122.495198251611 (37.7479984261704, -122.495198251611)
35947 184865 2 5 1201 Sunset Blvd 54 9 1 1     11 Width 0ft   5984635.3908 2106835.0674 37.7640785556344 -122.49635795369 (37.7640785556344, -122.49635795369)
163857 184864 2 5 1201 Sunset Blvd 53 9 1 1     9 Width 0ft   5984647.1621 2106835.0674 37.7640792451971 -122.496317240818 (37.7640792451971, -122.496317240818)
23851 200603 3 5 1400x La Salle Ave 52 11 1 2     17 Width 0ft   6016419.7448 2095144.9307 37.733790555057 -122.38560931762301 (37.733790555057, -122.385609317623)
25539 185720 2 5 2101 Sunset Blvd 52 9 1 1     22 Width 0ft   5984894.4324 2100359.2446 37.7463129086346 -122.494984487249 (37.7463129086346, -122.494984487249)
27415 185199 2 5 2500 Sunset Blvd 52 9 1 1     4 Width 0ft   5985167.8879 2097938.3372 37.739681755184705 -122.49386054871201 (37.7396817551847, -122.493860548712)
56071 184863 2 5 1201 Sunset Blvd 52 9 1 1     3 Width 0ft   5984668.8061 2106833.1689 37.764075300319 -122.496242241592 (37.764075300319, -122.496242241592)
185892 187116 2 5 2600 Sunset Blvd 52 9 1 1     4 Width 0ft   5985139.0056 2097294.5581 37.7379124205271 -122.493912978366 (37.7379124205271, -122.493912978366)
72616 188650 3 5 1700x Quesada Ave 51 3 1 2     8     6014234.97615 2095377.1002900002 37.734306916536 -122.39317901359699 (37.734306916536, -122.393179013597)
137314 200611 3 5 1400x La Salle Ave 51 11 1 2     9 Width 0ft   6016421.2138 2095153.2552 37.7338134937512 -122.385604818769 (37.7338134937512, -122.385604818769)
155834 184862 2 5 1201 Sunset Blvd 51 9 1 1     5 Width 0ft   5984672.6033 2106838.8646 37.764091161536996 -122.496229528652 (37.764091161537, -122.496229528652)
59915 200610 3 5 1400x La Salle Ave 50 11 1 2     4 Width 0ft   6016417.2964 2095161.5798 37.733836134681795 -122.385618942498 (37.7338361346818, -122.385618942498)
69580 188649 3 5 1700x Quesada Ave 50 3 1 2     3 Width 7ft   6014280.17751 2095342.33163 37.734213959905205 -122.393020304839 (37.7342139599052, -122.393020304839)
176885 184861 2 5 1201 Sunset Blvd 50 9 1 1     9 Width 0ft   5984691.2095 2106834.308 37.7640797402699 -122.496164839998 (37.7640797402699, -122.496164839998)
31867 184860 2 5 1201 Sunset Blvd 49 9 1 1     7 Width 0ft   5984687.0326 2106838.4849 37.7640909641996 -122.496179594648 (37.7640909641996, -122.496179594648)
44040 185717 2 5 2101 Sunset Blvd 49 9 1 1     4 Width 0ft   5984895.0862 2100394.2234 37.746408989169105 -122.494984805259 (37.7464089891691, -122.494984805259)
55316 200609 3 5 1400x La Salle Ave 49 11 1 2     1 Width 0ft   6016412.3996 2095168.4353 37.7338546875634 -122.385636349995 (37.7338546875634, -122.385636349995)
Powered by Datasette · Query took 38.193ms · Data source: data.sfgov.org