sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17563 687 1 229 1299X Potrero Ave 1 1 1 3     20 3X3   6010636.022580001 2101844.6913400004 37.75186493122229 -122.40607730804199 (37.7518649312223, -122.406077308042)
144769 689 1 82 1299X Potrero Ave 3 1 1 3     6 3X3   6010664.761195901 2101498.8811325002 37.7509170198962 -122.40595356703501 (37.7509170198962, -122.405953567035)
92348 690 1 82 1299X Potrero Ave 4 1 1 3     20 3X3   6010664.761195901 2101498.8811325002 37.7509170198962 -122.40595356703501 (37.7509170198962, -122.405953567035)
83618 693 1 43 1299X Potrero Ave 7 1 1 3     24 3x3   6010664.761195901 2101498.8811325002 37.7509170198962 -122.40595356703501 (37.7509170198962, -122.405953567035)
91816 694 1 43 1299X Potrero Ave 8 1 1 3     24 3x3   6010664.761195901 2101498.8811325002 37.7509170198962 -122.40595356703501 (37.7509170198962, -122.405953567035)
10993 764 1 5 1200X 37th Ave 1 1 1 3     12 3   5984614.2914 2106873.7688 37.76418358274471 -122.496433785178 (37.7641835827447, -122.496433785178)
104399 765 1 176 1200X 37th Ave 2 1 1 3     24 3   5984609.996333099 2107018.7644647 37.764581448379396 -122.496459340328 (37.7645814483794, -122.496459340328)
81054 2804 1 15 1070X California St 1 1 1 3     50 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
115677 2805 1 15 1070X California St 2 1 1 3     65 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
109159 2806 1 15 1070X California St 3 1 1 3     45 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
126954 2807 1 15 1070X California St 4 1 1 3     45 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
88529 2808 1 15 1070X California St 5 1 1 3     50 3x3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
139043 2809 1 15 1070X California St 6 1 1 3     35 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
7851 4658 1 59 600X Columbus Ave 1 1 1 3     34 5X5   6009795.4348 2119557.2423 37.8004523952872 -122.410234638074 (37.8004523952872, -122.410234638074)
4255 4659 1 59 600X Columbus Ave 2 1 1 3     90 5X5   6009780.1976 2119571.0943 37.800489575353104 -122.410288343699 (37.8004895753531, -122.410288343699)
7939 4660 1 59 600X Columbus Ave 3 1 1 3     125 5X5   6009761.7282 2119587.7167 37.8005341810425 -122.410353429867 (37.8005341810425, -122.410353429867)
6968 4661 1 59 600X Columbus Ave 4 1 1 3     90 5X5   6009739.5649 2119605.2627 37.8005811155969 -122.41043136381901 (37.8005811155969, -122.410431363819)
8289 4662 1 59 600X Columbus Ave 5 1 1 3     80 5X5   6009727.0981 2119617.2678 37.8006133797513 -122.41047535239099 (37.8006133797513, -122.410475352391)
7037 4663 1 59 600X Columbus Ave 6 1 1 3     60 5X5   6009710.0139 2119634.3519 37.8006593307081 -122.41053567802 (37.8006593307081, -122.41053567802)
5145 4664 1 59 600X Columbus Ave 7 1 1 3     90 5X5   6009692.467999999 2119649.5892 37.8007001848924 -122.410597470914 (37.8007001848924, -122.410597470914)
3904 4665 1 59 600X Columbus Ave 8 1 1 3     100 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881)
21461 5433 1 229 500X Dolores St 1 1 1 3   09/27/2008 12:00:00 AM 3 6   6004888.034519999 2105376.13123 37.76123826456529 -122.42620605546301 (37.7612382645653, -122.426206055463)
20166 5434 1 229 500X Dolores St 2 1 1 3   04/14/2009 12:00:00 AM 3 6   6004889.66204 2105352.28361 37.7611728766429 -122.426198728713 (37.7611728766429, -122.426198728713)
117968 5435 1 5 500X Dolores St 3 1 1 3     90 6   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
18744 5437 1 21 500X Dolores St 5 1 1 3     25 6   6004897.82208 2105221.96635 37.760815517531206 -122.426161228775 (37.7608155175312, -122.426161228775)
20609 5438 1 21 500X Dolores St 6 1 1 3   02/19/1992 12:00:00 AM 20 6   6004899.41142 2105199.1804 37.7607530425379 -122.426154109737 (37.7607530425379, -122.426154109737)
19361 5439 1 312 500X Dolores St 7 1 1 3   03/01/1990 12:00:00 AM 45 6   6004897.2550099995 2105174.4218599997 37.7606849395651 -122.426159805147 (37.7606849395651, -122.426159805147)
18991 5440 1 21 500X Dolores St 8 1 1 3     100 6   6004903.17124 2105121.8240799997 37.7605408528978 -122.426135598976 (37.7605408528978, -122.426135598976)
20901 5441 1 21 500X Dolores St 9 1 1 3     90 6   6004905.78091 2105098.60706 37.76047725195271 -122.426124920443 (37.7604772519527, -122.426124920443)
17712 5442 1 21 500X Dolores St 10 1 1 3     20 6   6004907.01705 2105068.65381 37.7603950772802 -122.426118512771 (37.7603950772802, -122.426118512771)
20994 5443 1 21 500X Dolores St 11 1 1 3   02/19/1992 12:00:00 AM 80 6   6004908.86181 2105038.27798 37.7603117767003 -122.426109970095 (37.7603117767003, -122.426109970095)
19884 5444 1 21 500X Dolores St 12 1 1 3     20 6   6004913.15076 2105006.62195 37.760225099135795 -122.426092882994 (37.7602250991358, -122.426092882994)
19227 5445 1 312 500X Dolores St 13 1 1 3   03/20/1990 12:00:00 AM 8 6   6004913.51654 2104964.38719 37.76010915314279 -122.426088611215 (37.7601091531428, -122.426088611215)
21952 5447 1 21 500X Dolores St 15 1 1 3     100 6   6004926.667780001 2104747.1594700003 37.7595134404185 -122.42602766326401 (37.7595134404185, -122.426027663264)
100994 5461 1 21 600X Dolores St 1 1 1 3   03/11/2006 12:00:00 AM 3 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
141306 5462 1 21 600X Dolores St 2 1 1 3   06/02/1992 12:00:00 AM 25 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
105022 5464 1 21 600X Dolores St 4 1 1 3     90 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
115430 5466 1 21 600X Dolores St 6 1 1 3   03/20/1990 12:00:00 AM 25 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
97092 5467 1 5 600X Dolores St 7 1 1 3     48     6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
111960 5468 1 21 600X Dolores St 8 1 1 3   03/01/1990 12:00:00 AM 25 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
91762 5469 1 21 600X Dolores St 9 1 1 3   06/02/1992 12:00:00 AM 25 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
115857 5470 1 21 600X Dolores St 10 1 1 3   03/10/2006 12:00:00 AM 3 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
85991 5471 1 21 600X Dolores St 11 1 1 3   06/02/1992 12:00:00 AM 25 6   6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
88029 5481 1 43 700X Dolores St 1 1 1 3     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
99318 5483 1 55 700X Dolores St 3 1 1 3   04/28/2008 12:00:00 AM 6 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
95365 5484 1 25 700X Dolores St 4 1 1 3     35 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
101187 5485 1 100 700X Dolores St 5 1 1 3     100 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
88492 5486 1 25 700X Dolores St 6 1 1 3   04/28/2008 12:00:00 AM 12 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
116727 5487 1 21 700X Dolores St 7 1 1 3     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
142678 5488 1 21 700X Dolores St 8 1 1 3     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
123177 6288 1 6 1700X Ellis St 2 1 1 3   01/28/2013 12:00:00 AM   4x3 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
119159 6290 1 12 1700X Ellis St 9 1 1 3   05/06/2015 12:00:00 AM   4x4 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
108709 6291 1 11 1700X Ellis St 10 1 1 3   01/04/2008 12:00:00 AM 3 4x4   6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
43333 6292 1 12 1700X Ellis St 11 1 1 3   01/28/2013 12:00:00 AM 24 3X4 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
15454 7377 1 44 1000X Folsom St 1 1 1 3     45 3X3   6010910.3764 2111530.9317 37.7784764953194 -122.405810783213 (37.7784764953194, -122.405810783213)
15693 7378 1 44 1000X Folsom St 2 1 1 3     45 3X3   6010884.8623 2111505.4176 37.7784050126686 -122.40589724881 (37.7784050126686, -122.40589724881)
16764 7379 1 44 1000X Folsom St 3 1 1 3     45 3X3   6010870.4412 2111489.3325 37.7783600402028 -122.40594600363998 (37.7783600402028, -122.40594600364)
14183 7380 1 44 1000X Folsom St 4 1 1 3     45 3X3   6010853.2469 2111475.4662 37.7783210049209 -122.40600450833401 (37.7783210049209, -122.406004508334)
15604 7382 1 44 1000X Folsom St 6 1 1 3     60 3X3   6010814.6984 2111439.6909 37.7782206182135 -122.406135341461 (37.7782206182135, -122.406135341461)
128189 8478 1 15 1900X Geary Blvd 1 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
124222 8479 1 15 1900X Geary Blvd 2 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
139564 8480 1 15 1900X Geary Blvd 3 1 1 3     12 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
89154 8481 1 15 1900X Geary Blvd 4 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
88707 8482 1 15 1900X Geary Blvd 5 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
139473 8483 1 15 1900X Geary Blvd 6 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
122255 8484 1 15 1900X Geary Blvd 7 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
105973 8485 1 15 1900X Geary Blvd 8 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
145655 8486 1 18 1900X Geary Blvd 9 1 1 3   03/15/2006 12:00:00 AM 3 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
7635 8487 1 15 1900X Geary Blvd 10 1 1 3     18 3X3   6002304.7836 2113777.2973 37.7841594324943 -122.43574149958401 (37.7841594324943, -122.435741499584)
116461 8488 1 15 1900X Geary Blvd 11 1 1 3     24 3X3   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
6893 8489 1 15 1900X Geary Blvd 12 1 1 3     18 3X3   6002220.6585 2113766.2282 37.7841242607304 -122.436031749589 (37.7841242607304, -122.436031749589)
90660 8490 1 15 1950X Geary Blvd 1 1 1 3     18 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
79428 8492 1 15 1950X Geary Blvd 3 1 1 3     30 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
114003 8493 1 15 1950X Geary Blvd 4 1 1 3     30 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
85228 8494 1 15 1950X Geary Blvd 5 1 1 3     30 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
115535 8495 1 15 1950X Geary Blvd 6 1 1 3     24 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
121289 8496 1 15 1950X Geary Blvd 7 1 1 3     24 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
110591 8497 1 15 1950X Geary Blvd 8 1 1 3     18 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
82553 8498 1 15 1950X Geary Blvd 9 1 1 3     18 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
98915 8499 1 15 1950X Geary Blvd 10 1 1 3     18 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
82040 8500 1 15 1950X Geary Blvd 11 1 1 3     24 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
77594 8501 1 15 1950X Geary Blvd 12 1 1 3     18 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
87002 8502 1 15 1950X Geary Blvd 13 1 1 3     30 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
145985 8503 1 15 1950X Geary Blvd 14 1 1 3     24 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
103189 8504 1 15 1950X Geary Blvd 15 1 1 3     24 3X3   6002386.446026901 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616)
94964 8519 1 15 1901 Geary Blvd 1 1 1 3     24 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
84016 8521 1 127 1901 Geary Blvd 3 1 1 3   01/30/2005 12:00:00 AM 3 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
80827 8522 1 15 1901 Geary Blvd 4 1 1 3     24 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
141074 8523 1 15 1901 Geary Blvd 5 1 1 3     24 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
129090 8524 1 15 1901 Geary Blvd 6 1 1 3     18 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
8794 8525 1 15 1901 Geary Blvd 7 1 1 3     18 3X3   6002439.1587 2113663.3402 37.7838541670365 -122.43526845642201 (37.7838541670365, -122.435268456422)
5555 8527 1 15 1901 Geary Blvd 9 1 1 3     24 3X3   6002529.8149 2113677.2092 37.7838973955703 -122.434955812258 (37.7838973955703, -122.434955812258)
87286 8528 1 15 1901 Geary Blvd 11 1 1 3     30 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
7740 9445 1 22 800X Golden Gate Ave 1 7 1 3   03/01/1994 12:00:00 AM 12 3X3   6005680.1419 2112439.5166 37.780677364386705 -122.423968789396 (37.7806773643867, -122.423968789396)
7171 9447 1 22 800X Golden Gate Ave 3 7 1 3     12 3X3   6005622.1957 2112431.3933 37.780651788182794 -122.424168675479 (37.7806517881828, -122.424168675479)
7570 9448 1 22 800X Golden Gate Ave 4 7 1 3   05/18/1992 12:00:00 AM 12 3X3   6005590.2441 2112426.5193 37.78063660125729 -122.424278864743 (37.7806366012573, -122.424278864743)
8920 9449 1 22 800X Golden Gate Ave 5 7 1 3     12 3X3   6005556.1262 2112420.5622 37.780618317973 -122.424396471178 (37.780618317973, -122.424396471178)
7676 9450 1 150 800X Golden Gate Ave 6 7 1 3     12 3X3   6005543.6705 2112420.5622 37.780617614602896 -122.424439561439 (37.7806176146029, -122.424439561439)
6304 9451 1 22 800X Golden Gate Ave 7 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005532.2979 2112418.9375 37.7806125113537 -122.424478789137 (37.7806125113537, -122.424478789137)
6101 9452 1 150 800X Golden Gate Ave 8 1 1 3   02/17/1998 12:00:00 AM 3 3X3   6005518.2175 2112416.7713 37.780605768348295 -122.424527345883 (37.7806057683483, -122.424527345883)
3483 9453 1 150 800X Golden Gate Ave 9 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005504.6787 2112415.6882 37.7806020298362 -122.42457410603201 (37.7806020298362, -122.424574106032)
Powered by Datasette · Query took 8.425ms · Data source: data.sfgov.org