sf-trees

Data source: data.sfgov.org

Custom SQL query returning 100 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1043 81845 3 12 1421 Pine St 2 1 1 10 6 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.789704100621705 -122.419274608151 (37.7897041006217, -122.419274608151)
1171 172952 3 5 3000X Van Ness Ave 1 1 1 2 6   0 Width 3ft   6005556.34576 2120733.12845 37.8034425497953 -122.42498731221201 (37.8034425497953, -122.424987312212)
2825 81846 3 12 1421 Pine St 1 1 1 10 6 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328)
2924 140269 2 62 2040 Hayes St 1 1 1 10 6 08/11/2017 12:00:00 AM 3 Width 0ft   5998144.7463 2109987.1343 37.7735154534297 -122.449860434482 (37.7735154534297, -122.449860434482)
3824 229287 3 21 420 Dolores St 2 1 1 2 6   2 6x6   6004863.64618 2105856.17124 37.7625549619753 -122.42632458341299 (37.7625549619753, -122.426324583413)
8242 81844 3 12 1421 Pine St 3 1 1 2 6 09/11/2012 12:00:00 AM 3 3x3 Permit Number 50020 6007169.781140001 2115706.72596 37.789732310539705 -122.419047208268 (37.7897323105397, -122.419047208268)
12506 98216 3 39 1501X 42nd Ave 9 1 1 10 6   30 3x12   5983098.741 2104521.6922 37.7576365448231 -122.50150154301201 (37.7576365448231, -122.501501543012)
12923 111444 1 180 241 Oneida Ave 34 1 1 2 6   14 6x12   5999970.3074 2091024.03837 37.721551640364396 -122.442184051271 (37.7215516403644, -122.442184051271)
13261 144 3 22 1025X 14th St 14 1 1 2 6   18 3x3   6002159.27678 2107619.02908 37.7672421007673 -122.435804136578 (37.7672421007673, -122.435804136578)
23389 43452 1 180 241 Oneida Ave 12 1 1 2 6 07/18/2000 12:00:00 AM 10   Permit Number 43162 5999577.25447 2091228.40825 37.7220903846374 -122.44355739787599 (37.7220903846374, -122.443557397876)
24577 43433 1 180 241 Oneida Ave 27 1 1 2 6 07/18/2000 12:00:00 AM 16   Permit Number 43162 5999846.51913 2091089.02473 37.7217230223792 -122.442616616172 (37.7217230223792, -122.442616616172)
26060 43443 1 180 241 Oneida Ave 5 1 1 2 6 03/06/2004 12:00:00 AM 6   Permit Number 43162 5999469.30626 2091283.8759 37.722236528981206 -122.44393453036999 (37.7222365289812, -122.44393453037)
28704 43445 1 180 241 Oneida Ave 28 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999858.82768 2091082.35027 37.7217053974709 -122.44257358990299 (37.7217053974709, -122.442573589903)
33677 43434 1 180 241 Oneida Ave 26 1 1 2 6 07/18/2000 12:00:00 AM 7   Permit Number 43162 5999832.90051 2091096.8327900001 37.7217436851966 -122.44266425237 (37.7217436851966, -122.44266425237)
39173 43441 1 180 241 Oneida Ave 3 1 1 2 6 01/05/2016 12:00:00 AM 7   Permit Number 774294 5999448.10749 2091294.70392 37.7222650509726 -122.444008586831 (37.7222650509726, -122.444008586831)
39824 43966 1 11 627 Turk St 1 1 1 2 6 08/20/2005 12:00:00 AM 9   Permit Number 43534 6006884.39072 2112892.55093 37.781989200774206 -122.41983486151199 (37.7819892007742, -122.419834861512)
45283 43435 1 180 241 Oneida Ave 25 1 1 2 6 07/18/2000 12:00:00 AM 14   Permit Number 43162 5999819.49506 2091104.19362 37.7217631321556 -122.44271111962699 (37.7217631321556, -122.442711119627)
45429 111443 1 180 241 Oneida Ave 33 1 1 2 6   17     5999927.23458 2091047.72982 37.7216142367899 -122.442334641847 (37.7216142367899, -122.442334641847)
52424 43437 1 180 241 Oneida Ave 1 1 1 2 6 03/06/2004 12:00:00 AM 19   Permit Number 43162 5999381.26407 2091328.9112200001 37.7223551630339 -122.44424210479099 (37.7223551630339, -122.444242104791)
54575 111440 1 180 241 Oneida Ave 30 1 1 2 6   12     5999883.47669 2091070.55057 37.72167440322979 -122.442487538293 (37.7216744032298, -122.442487538293)
63781 43439 1 180 241 Oneida Ave 2 1 1 2 6 01/05/2016 12:00:00 AM 12   Permit Number 774294 5999436.71838 2091300.71882 37.72228091680579 -122.44404838812099 (37.7222809168058, -122.444048388121)
65476 43457 1 180 241 Oneida Ave 7 1 1 2 6 07/18/2000 12:00:00 AM 3   Permit Number 43162 5999502.576 2091265.96486 37.722189247127105 -122.443818239036 (37.7221892471271, -122.443818239036)
66622 43448 1 180 241 Oneida Ave 21 1 1 2 6 07/18/2000 12:00:00 AM 9   Permit Number 43162 5999710.3638 2091158.16281 37.721905097333 -122.443092230725 (37.721905097333, -122.443092230725)
68075 43459 1 180 241 Oneida Ave 17 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999660.0285 2091185.4802700002 37.7219772346577 -122.443268187573 (37.7219772346577, -122.443268187573)
70864 43453 1 180 241 Oneida Ave 15 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999638.45654 2091195.87208 37.7220045380552 -122.443343502225 (37.7220045380552, -122.443343502225)
71753 43458 1 180 241 Oneida Ave 9 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999537.11613 2091248.65338 37.72214368387 -122.443697599487 (37.72214368387, -122.443697599487)
74074 43442 1 180 241 Oneida Ave 4 1 1 2 6 01/05/2016 12:00:00 AM 14   Permit Number 774294 5999458.08811 2091290.64416 37.72225447314511 -122.443973794765 (37.7222544731451, -122.443973794765)
75670 43444 1 180 241 Oneida Ave 6 1 1 2 6 07/18/2000 12:00:00 AM 2   Permit Number 43162 5999490.75065 2091271.846 37.722204720867204 -122.443859538611 (37.7222047208672, -122.443859538611)
78503 98221 3 2 1501X 42nd Ave 16 1 1 10 6   6 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
78909 111135 2 62 2030x HAYES ST 8 1 1 10 6   2 5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
79317 95366 3 5 3101X Van Ness Ave 1 1 1 10 6   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.42518303152201 (37.8041229057048, -122.425183031522)
81348 113709 2 39 2801x CLEMENT ST 5 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
81617 81843 3 12 1299X Larkin St 1 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
82264 107888 1 44 941 Washington St 6 1 1 2 6 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
84481 113708 2 39 2801x CLEMENT ST 4 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
84535 111128 2 62 2030x HAYES ST 1 1 1 10 6   7 5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
84926 98219 3 2 1501X 42nd Ave 13 1 1 10 6   4 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
86525 105658 3 43 901X Lombard St 5 1 1 2 6         6007813.035080001 2120272.8882299997 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832)
86889 111133 2 62 2030x HAYES ST 6 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
88711 113813 2 2 4101x 25TH ST 6 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
88938 82383 3 12 1421 Pine St 4 1 1 10 6 09/11/2012 12:00:00 AM 3 3x3   6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
88957 105655 3 21 901X Lombard St 2 1 1 2 6         6007813.035080001 2120272.8882299997 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832)
89194 99308 3 50 1902X 41st Ave 20 1 1 10 6   6 3X3   5983703.9 2101544.3 37.7494969779561 -122.49918869137501 (37.7494969779561, -122.499188691375)
92792 98222 3 503 1501X 42nd Ave 17 1 1 10 6   30 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
93570 111448 1 180 241 Oneida Ave 38 1 1 2 6     6x7   5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
93890 98217 3 42 1501X 42nd Ave 11 1 1 10 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
94059 113817 2 49 4101x 25TH ST 10 1 1 10 6 02/16/2016 06:00:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
95213 113810 2 51 4101x 25TH ST 3 1 1 10 6     3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
96370 113818 2 49 4101x 25TH ST 11 1 1 10 6 02/16/2016 05:57:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
96735 113809 2 49 4101x 25TH ST 2 1 1 10 6 06/15/2016 07:36:00 AM 3 5x5   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
96833 107891 1 17 941 Washington St 9 1 1 2 6         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
96890 111446 1 180 241 Oneida Ave 36 1 1 2 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
97025 81841 3 12 1299X Larkin St 3 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
98563 113820 2 184 4101x 25TH ST 13 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
100401 81842 3 12 1299X Larkin St 2 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
101061 113808 2 18 4101x 25TH ST 1 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
101787 107890 1 17 941 Washington St 8 1 1 2 6         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
105585 113819 2 18 4101x 25TH ST 12 1 1 10 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
106701 113812 2 51 4101x 25TH ST 5 1 1 10 6   1 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
106760 99309 3 41 1902X 41st Ave 23 1 1 10 6   6 3X3   5983703.9 2101544.3 37.7494969779561 -122.49918869137501 (37.7494969779561, -122.499188691375)
109505 111134 2 62 2030x HAYES ST 7 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
110169 113705 2 39 2801x CLEMENT ST 1 1 1 10 6   10 4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
111252 81840 3 12 1299X Larkin St 4 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
111553 113706 2 39 2801x CLEMENT ST 2 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
111981 43455 1 180 241 Oneida Ave 11 1 1 2 6 07/18/2000 12:00:00 AM     Permit Number 43162 5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
113461 111447 1 180 241 Oneida Ave 37 1 1 2 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
115629 113707 2 39 2801x CLEMENT ST 3 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
118334 111131 2 62 2030x HAYES ST 4 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
119065 98218 3 8 1501X 42nd Ave 12 1 1 10 6   3 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
120505 98220 3 8 1501X 42nd Ave 14 1 1 10 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
122616 113811 2 2 4101x 25TH ST 4 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
123447 43449 1 180 241 Oneida Ave 24 1 1 2 6 07/18/2000 12:00:00 AM 7   Permit Number 43162 5999756.32409 2091134.05765 37.7218415305512 -122.442931628018 (37.7218415305512, -122.442931628018)
124026 113821 2 50 4101x 25TH ST 14 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
124753 113814 2 49 4101x 25TH ST 7 1 1 10 6 02/16/2016 06:05:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
126528 111776 2 62 2030x HAYES ST 9 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
133363 43450 1 180 241 Oneida Ave 22 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999728.91774 2091148.65353 37.72188004492379 -122.443027412104 (37.7218800449238, -122.443027412104)
134509 43456 1 180 241 Oneida Ave 8 1 1 2 6 07/18/2000 12:00:00 AM 9   Permit Number 43162 5999514.70275 2091259.45123 37.722172053891704 -122.44377585219699 (37.7221720538917, -122.443775852197)
135134 43451 1 180 241 Oneida Ave 23 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999743.131580001 2091140.9715900002 37.7218597624867 -122.442977727254 (37.7218597624867, -122.442977727254)
137253 43440 1 180 241 Oneida Ave 14 1 1 2 6 07/18/2000 12:00:00 AM 2   Permit Number 43162 5999628.40371 2091200.8294 37.722017576445204 -122.44337860813499 (37.7220175764452, -122.443378608135)
138615 105657 3 43 901X Lombard St 4 1 1 2 6         6007813.035080001 2120272.8882299997 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832)
140031 105654 3 21 901X Lombard St 1 1 1 2 6 05/09/2014 12:00:00 AM 3 3x3   6007813.035080001 2120272.8882299997 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832)
140201 111132 2 62 2030x HAYES ST 5 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
140997 113815 2 15 4101x 25TH ST 8 1 1 10 6   8 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
141271 113816 2 2 4101x 25TH ST 9 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
141680 107889 1 17 941 Washington St 7 1 1 2 6 11/03/2014 12:00:00 AM 3   Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
141753 81839 3 12 1299X Larkin St 5 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
142174 111129 2 62 2030x HAYES ST 2 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
143896 113822 2 130 4101x 25TH ST 15 1 1 10 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
144223 105656 3 21 901X Lombard St 3 1 1 2 6 05/09/2014 12:00:00 AM 3     6007813.035080001 2120272.8882299997 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832)
145968 98223 3 503 1501X 42nd Ave 18 1 1 10 6   30 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
147696 43438 1 180 241 Oneida Ave 10 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999550.19859 2091242.74615 37.7221282101348 -122.443651952598 (37.7221282101348, -122.443651952598)
153063 43436 1 180 241 Oneida Ave 16 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999647.9704599995 2091192.0487400002 37.721994582572606 -122.44331034060801 (37.7219945825726, -122.443310340608)
155143 43447 1 180 241 Oneida Ave 20 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999697.54909 2091165.42889 37.7219243176433 -122.443137049362 (37.7219243176433, -122.443137049362)
162227 111441 1 180 241 Oneida Ave 31 1 1 2 6   5     5999897.1183 2091063.84845 37.721656778309494 -122.442439902078 (37.7216567783095, -122.442439902078)
162642 43446 1 180 241 Oneida Ave 18 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999670.6407 2091179.60867 37.721961717728 -122.44323108247299 (37.721961717728, -122.443231082473)
180178 111442 1 180 241 Oneida Ave 32 1 1 2 6   8     5999909.42688 2091057.1743400001 37.721639154299204 -122.44239687581002 (37.7216391542992, -122.44239687581)
181064 43454 1 180 241 Oneida Ave 13 1 1 2 6 07/18/2000 12:00:00 AM 11   Permit Number 43162 5999613.63458 2091208.86715 37.722038804018204 -122.443430238238 (37.7220388040182, -122.443430238238)
182202 111445 1 180 241 Oneida Ave 35 1 1 2 6   7     5999980.8477300005 2091017.84349 37.721535231343296 -122.442147171851 (37.7215352313433, -122.442147171851)
183638 111439 1 180 241 Oneida Ave 29 1 1 2 6   6     5999870.68262 2091075.2427400001 37.721686557579204 -122.44253210058201 (37.7216865575792, -122.442532100582)
187095 43432 1 180 241 Oneida Ave 19 1 1 2 6 07/18/2000 12:00:00 AM 3   Permit Number 43162 5999683.18724 2091173.0602 37.7219444525549 -122.443187242296 (37.7219444525549, -122.443187242296)
Powered by Datasette · Query took 2.741ms · Data source: data.sfgov.org