sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
127400 119700 3 100 6x Octavia St Frontage West 2 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
138316 119699 3 100 6x Octavia St Frontage West 1 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
69507 132112 3 100 1500x The Embarcadero 13 3 1 2     20 Width 10ft   6011208.1934400005 2121737.88602 37.8065189965151 -122.40549956557501 (37.8065189965151, -122.405499565575)
30823 132092 3 100 1500x The Embarcadero 12 3 1 2     20 Width 10ft   6011191.46105 2121714.3637599996 37.806453474602 -122.405555813649 (37.806453474602, -122.405555813649)
149311 132111 3 100 1500x The Embarcadero 11 3 1 2     22 Width 10ft   6011290.22315 2121683.26622 37.806373610322105 -122.40521183646999 (37.8063736103221, -122.40521183647)
41127 132091 3 100 1500x The Embarcadero 10 3 1 2     21 Width 10ft   6011272.98764 2121658.8993 37.806305741188204 -122.405269766312 (37.8063057411882, -122.405269766312)
168748 132110 3 100 1500x The Embarcadero 9 3 1 2     23 Width 10ft   6011374.63029 2121626.67271 37.8062229369941 -122.404915741893 (37.8062229369941, -122.404915741893)
62222 132090 3 100 1500x The Embarcadero 8 3 1 2     21 Width 10ft   6011358.77785 2121601.92287 37.8061540939119 -122.40496885853999 (37.8061540939119, -122.40496885854)
107397 25804 1 100 1300X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
109799 25803 1 100 1300X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
112807 25802 1 100 1300X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
116990 25800 1 100 1300X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
140551 25801 1 100 1300X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
50014 132109 3 100 1500x The Embarcadero 7 3 1 2     21 Width 10ft   6011459.50109 2121569.1071 37.8060696196846 -122.40461797546301 (37.8060696196846, -122.404617975463)
155474 132089 3 100 1500x The Embarcadero 6 3 1 2     23 Width 10ft   6011437.6783 2121540.455 37.805989728403894 -122.404691478852 (37.8059897284039, -122.404691478852)
181994 132108 3 100 1500x The Embarcadero 5 3 1 2     21 Width 10ft   6011532.668269999 2121506.48507 37.8059017639302 -122.404360356561 (37.8059017639302, -122.404360356561)
69372 25749 1 100 1301X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
89841 25748 1 100 1301X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
101776 25752 1 100 1301X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
112942 25754 1 100 1301X The Embarcadero 7 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
117219 25750 1 100 1301X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
141888 25751 1 100 1301X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
146321 25753 1 100 1301X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
70595 132088 3 100 1500x The Embarcadero 4 3 1 2     22 Width 10ft   6011509.10408 2121480.92062 37.8058302534199 -122.404440103948 (37.8058302534199, -122.404440103948)
182470 132107 3 100 1500x The Embarcadero 3 3 1 2     22 Width 10ft   6011604.73213 2121437.1460700002 37.805715402812204 -122.40410608402901 (37.8057154028122, -122.404106084029)
70221 132087 3 100 1500x The Embarcadero 2 3 1 2     20 Width 10ft   6011581.4658 2121414.5973099996 37.8056521894584 -122.40418501304501 (37.8056521894584, -122.404185013045)
166867 132106 3 100 1500x The Embarcadero 1 3 1 2     20 Width 10ft   6011673.52168 2121373.1691 37.8055435810345 -122.40386352159099 (37.8055435810345, -122.403863521591)
168474 132105 3 100 1400x The Embarcadero 4 3 1 2     20 Width 10ft   6012001.46692 2121074.30881 37.8047412994387 -122.402707584299 (37.8047412994387, -122.402707584299)
136050 132086 3 100 1400x The Embarcadero 3 3 1 2     20 Width 10ft   6011972.21269 2121045.33445 37.8046601095467 -122.402806783124 (37.8046601095467, -122.402806783124)
177459 132104 3 100 1400x The Embarcadero 2 3 1 2     19 Width 10ft   6012041.8343 2121038.82925 37.8046461349625 -122.402565391602 (37.8046461349625, -122.402565391602)
25048 132103 3 100 1400x The Embarcadero 1 3 1 2     18 Width 10ft   6012095.78368 2120981.89347 37.8044928149639 -122.402374687645 (37.8044928149639, -122.402374687645)
54583 132068 2 100 3601 Broderick St 4 9 1 1     3 Width 4ft   5999659.130480001 2120925.06177 37.803634670174496 -122.445408603735 (37.8036346701745, -122.445408603735)
153490 132085 3 100 1300x The Embarcadero 2 3 1 2     23 Width 10ft   6012153.585109999 2120867.04559 37.8041806971541 -122.402166580042 (37.8041806971541, -122.402166580042)
103830 27697 1 100 1100X The Embarcadero 2 11 1 9     36 10   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
4067 25799 1 100 1300X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525)
81176 27963 1 100 1101X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
105106 25746 1 100 1101X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
111083 25747 1 100 1101X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
127945 25787 1 100 800X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012271.38601 2120709.8440099997 37.803755634424206 -122.401747862284 (37.8037556344242, -122.401747862284)
176923 132084 3 100 1200x The Embarcadero 5 3 1 2     25 Width 10ft   6012274.61558 2120706.35336 37.8037462301721 -122.401736440606 (37.8037462301721, -122.401736440606)
123015 25788 1 100 800X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012327.37501 2120629.11501 37.8035370964877 -122.401548430804 (37.8035370964877, -122.401548430804)
70617 132083 3 100 1200x The Embarcadero 3 3 1 2     23 Width 10ft   6012328.94165 2120621.527 37.8035163490725 -122.401542475719 (37.8035163490725, -122.401542475719)
47529 132102 3 100 1200x The Embarcadero 2 3 1 2     17 Width 10ft   6012409.883230001 2120572.1173400003 37.8033851982182 -122.401258897879 (37.8033851982182, -122.401258897879)
120825 25789 1 100 800X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6012378.15701 2120553.5940099997 37.8033325675946 -122.40136738582899 (37.8033325675946, -122.401367385829)
65398 132082 3 100 1200x The Embarcadero 1 3 1 2     21 Width 10ft   6012375.04896 2120549.1986599998 37.803320325622295 -122.40137783233999 (37.8033203256223, -122.40137783234)
76348 27944 1 100 999 The Embarcadero 1 11 1 9     24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
83420 27948 1 100 999 The Embarcadero 5 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
91110 27949 1 100 999 The Embarcadero 6 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
98325 27947 1 100 999 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
106831 27951 1 100 999 The Embarcadero 8 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
114665 27950 1 100 999 The Embarcadero 7 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
116513 27946 1 100 999 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
144240 27945 1 100 999 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
56654 132101 3 100 1100x The Embarcadero 17 3 1 2     18 Width 10ft   6012520.61539 2120407.16114 37.802938445615 -122.40086410632 (37.802938445615, -122.40086410632)
107210 25790 1 100 800X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6012501.85401 2120373.90601 37.8028460885889 -122.400926692934 (37.8028460885889, -122.400926692934)
135157 132081 3 100 1100x The Embarcadero 16 3 1 2     20 Width 10ft   6012501.69351 2120366.8481099997 37.802826700352995 -122.400926752172 (37.802826700353, -122.400926752172)
48115 132100 3 100 1100x The Embarcadero 15 3 1 2     24 Width 10ft   6012551.63717 2120363.68822 37.802820809805496 -122.400753698321 (37.8028208098055, -122.400753698321)
34765 143058 2 100 426 GREENWICH ST 1 1 1 1     30 Width 0ft   6010776.1378 2120354.2833 37.8026957973236 -122.406897202115 (37.8026957973236, -122.406897202115)
91779 26017 1 100 899X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
92465 26024 1 100 899X The Embarcadero 8 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
119621 26019 1 100 899X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
124284 26018 1 100 899X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
126593 26022 1 100 899X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
128560 26023 1 100 899X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
140237 26020 1 100 899X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
144442 26021 1 100 899X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
129992 132099 3 100 1100x The Embarcadero 14 3 1 2     22 Width 10ft   6012592.45443 2120302.68635 37.8026555899447 -122.40060816104099 (37.8026555899447, -122.400608161041)
118985 25791 1 100 800X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6012561.75001 2120285.36501 37.802606317276 -122.40071319691499 (37.802606317276, -122.400713196915)
37174 132080 3 100 1100x The Embarcadero 13 3 1 2     26 Width 10ft   6012562.54875 2120282.53748 37.802598598112 -122.40071023410101 (37.802598598112, -122.400710234101)
61544 132098 3 100 1100x The Embarcadero 12 3 1 2     23 Width 10ft   6012646.4501 2120224.08688 37.802442786052396 -122.40041578348699 (37.8024427860524, -122.400415783487)
127804 25792 1 100 800X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6012611.22901 2120208.54201 37.802398139421705 -122.400536574048 (37.8023981394217, -122.400536574048)
176286 132079 3 100 1100x The Embarcadero 11 3 1 2     21 Width 10ft   6012611.87531 2120208.19637 37.8023972264213 -122.40053431322399 (37.8023972264213, -122.400534313224)
59618 132097 3 100 1100x The Embarcadero 10 3 1 2     22 Width 10ft   6012695.81427 2120154.0888900002 37.8022533411719 -122.400240038841 (37.8022533411719, -122.400240038841)
108921 25793 1 100 800X The Embarcadero 7 11 1 9   08/30/1996 12:00:00 AM 36 10   6012660.709009999 2120133.02101 37.802193536328 -122.40036004021499 (37.802193536328, -122.400360040215)
75574 132078 3 100 1100x The Embarcadero 9 3 1 2     21 Width 10ft   6012663.130340001 2120132.51785 37.8021922897941 -122.40035162582899 (37.8021922897941, -122.400351625829)
81328 25745 1 100 801X The Embarcadero 10 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
86291 25738 1 100 801X The Embarcadero 3 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
98209 25737 1 100 801X The Embarcadero 2 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
101160 25742 1 100 801X The Embarcadero 7 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
104498 25741 1 100 801X The Embarcadero 6 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
113256 25744 1 100 801X The Embarcadero 9 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
113720 25743 1 100 801X The Embarcadero 8 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
114962 27698 1 100 801X The Embarcadero 11 11 1 9     24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
118856 25739 1 100 801X The Embarcadero 4 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
128307 25736 1 100 801X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
142246 25740 1 100 801X The Embarcadero 5 11 1 9   08/15/1996 12:00:00 AM 24 10   6012632.1664062 2120088.9827256002 37.802071026160604 -122.400455716884 (37.8020710261606, -122.400455716884)
78230 27930 1 100 799 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
95434 27933 1 100 799 The Embarcadero 5 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
115229 27932 1 100 799 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
119199 27935 1 100 799 The Embarcadero 7 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
123638 27929 1 100 799 The Embarcadero 1 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
128206 27931 1 100 799 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
143792 27934 1 100 799 The Embarcadero 6 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
150555 132096 3 100 1100x The Embarcadero 8 3 1 2     21 Width 10ft   6012742.85934 2120080.46122 37.8020538004962 -122.400072065282 (37.8020538004962, -122.400072065282)
25390 132077 3 100 1100x The Embarcadero 7 3 1 2     23 Width 10ft   6012714.4120000005 2120058.1365799997 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451)
120030 25794 1 100 800X The Embarcadero 8 11 1 9   08/30/1996 12:00:00 AM 36 10   6012712.79201 2120057.50001 37.8019890781012 -122.40017449968501 (37.8019890781012, -122.400174499685)
76777 132095 3 100 1100x The Embarcadero 6 3 1 2     23 Width 10ft   6012798.77066 2120004.26494 37.801847701082394 -122.39987323058901 (37.8018477010824, -122.399873230589)
78155 25795 1 100 800X The Embarcadero 9 11 1 9   08/30/1996 12:00:00 AM 36 10   6012764.87501 2119980.6770099998 37.80178104459689 -122.39998886869199 (37.8017810445969, -122.399988868692)
164266 132076 3 100 1100x The Embarcadero 5 3 1 2     25 Width 10ft   6012766.891340001 2119978.53875 37.8017752858665 -122.399981740966 (37.8017752858665, -122.399981740966)
49479 132094 3 100 1100x The Embarcadero 4 3 1 2     24 Width 10ft   6012848.0944 2119927.2949200002 37.8016391096046 -122.39969713882601 (37.8016391096046, -122.399697138826)
32862 132075 3 100 1100x The Embarcadero 3 3 1 2     23 Width 10ft   6012816.85763 2119903.53523 37.8015721299035 -122.399803563704 (37.8015721299035, -122.399803563704)
Powered by Datasette · Query took 9.68ms · Data source: data.sfgov.org