sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
589 26916 1 15 1901 Geary Blvd 10 1 1 3     18 3X3   6002555.1851 2113680.9302 37.783909052953 -122.43486830704398 (37.783909052953, -122.434868307044)
1080 9610 1 22 1388X Golden Gate Ave 1 1 1 3   05/01/2017 01:42:00 PM 3 3X3   6002958.1886 2112049.4711 37.7794523489738 -122.433357444963 (37.7794523489738, -122.433357444963)
1593 9458 1 150 800X Golden Gate Ave 14 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005390.9525 2112398.9001 37.780549510570204 -122.424966344778 (37.7805495105702, -122.424966344778)
2279 9454 1 150 800X Golden Gate Ave 10 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005489.5152 2112411.3558 37.7805892777689 -122.424626255587 (37.7805892777689, -122.424626255587)
2525 9534 1 17 1100X Golden Gate Ave 2 1 1 3   01/02/2014 12:00:00 AM 6 3X3 Permit Number 771276 6004154.8546 2112220.8365 37.779990692526 -122.42922989330201 (37.779990692526, -122.429229893302)
2696 9611 1 22 1390X Golden Gate Ave 2 1 1 3   05/14/1992 12:00:00 AM 3 3X3   6002925.8908 2112046.6002 37.7794426338279 -122.43346897140499 (37.7794426338279, -122.433468971405)
3190 9537 1 25 1100X Golden Gate Ave 5 1 1 3   05/14/1992 12:00:00 AM 3 3X3   6004100.4915 2112210.9093 37.779960357201205 -122.429417251502 (37.7799603572012, -122.429417251502)
3252 9455 1 150 800X Golden Gate Ave 11 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005466.2284 2112408.648 37.7805805276453 -122.424706623116 (37.7805805276453, -122.424706623116)
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)
3688 9457 1 150 800X Golden Gate Ave 13 1 1 3     6 3X3   6005414.2393 2112401.6078 37.7805582605963 -122.424885977306 (37.7805582605963, -122.424885977306)
5025 9541 1 17 1100X Golden Gate Ave 9 1 1 3   01/02/2014 12:00:00 AM 3 3X3 Permit Number 771276 6003998.856000001 2112198.1457 37.7799195567604 -122.429767943463 (37.7799195567604, -122.429767943463)
5378 9456 1 22 800X Golden Gate Ave 12 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005442.4 2112406.4818 37.780573233977705 -122.424788902821 (37.7805732339777, -122.424788902821)
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)
5863 9461 1 22 800X Golden Gate Ave 17 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005331.3816 2112388.6106 37.780517893039395 -122.425171696602 (37.7805178930394, -122.425171696602)
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)
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)
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)
7109 18519 1 59 1700X Powell St 1 1 1 3     30 3X3   6009627.5943 2119520.0726 37.800340927010296 -122.410812809398 (37.8003409270103, -122.410812809398)
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)
7440 9542 1 50 1100X Golden Gate Ave 10 1 1 3   03/31/2000 12:00:00 AM 3 3X3   6003977.1107 2112193.8912 37.7799066435706 -122.429842866574 (37.7799066435706, -122.429842866574)
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)
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)
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)
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)
7827 9544 1 50 1100X Golden Gate Ave 12 1 1 3     6 3X3   6003937.8747 2112189.6367 37.7798927397998 -122.429978297745 (37.7798927397998, -122.429978297745)
7831 9536 1 25 1100X Golden Gate Ave 4 1 1 3   10/14/1994 12:00:00 AM 3 3X3   6004118.455 2112215.6365 37.779974353933 -122.42935544491999 (37.779974353933, -122.42935544492)
8608 9533 1 25 1100X Golden Gate Ave 1 1 1 3     6 3X3   6004176.1272 2112221.7819 37.7799944925987 -122.429156369266 (37.7799944925987, -122.429156369266)
8706 9539 1 26 1100X Golden Gate Ave 7 1 1 3   03/31/2000 12:00:00 AM 3 3X3   6004035.7284 2112200.9821 37.779929432705 -122.429640587781 (37.779929432705, -122.429640587781)
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)
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)
13832 27154 1 20 1700X Silver Ave 3 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011126.61874 2095085.7194599998 37.7333336755986 -122.403905168305 (37.7333336755986, -122.403905168305)
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)
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)
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)
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)
15856 27155 1 20 1700X Silver Ave 4 1 1 3   01/29/2000 12:00:00 AM 6 3X3   6011143.89147 2095098.83858 37.733370662922795 -122.403846374205 (37.7333706629228, -122.403846374205)
15973 22420 1 79 5815 03rd St 3 1 1 3   01/18/2008 12:00:00 AM 3 3X3   6013860.9167 2092056.0916 37.725167314492104 -122.39423983281799 (37.7251673144921, -122.394239832818)
16026 27153 1 20 1700X Silver Ave 2 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011109.96837 2095074.7045 37.7333025005961 -122.403961958687 (37.7333025005961, -122.403961958687)
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)
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)
18045 24537 1 15 500X Cortland Ave 1 1 1 3     18 3X3   6007586.10322 2097213.8581 37.738978639151505 -122.416296424042 (37.7389786391515, -122.416296424042)
18163 24539 9 292 500X Cortland Ave 3 1 1 3     50 3X3   6007622.1254900005 2097206.54003 37.738960570878795 -122.41617135711999 (37.7389605708788, -122.41617135712)
19639 9777 1 11 897X Gough St 5 1 1 3     30 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
19899 24538 1 15 500X Cortland Ave 2 1 1 3     12 3X3   6007606.23219 2097211.71423 37.7389738844263 -122.416226675338 (37.7389738844263, -122.416226675338)
19927 10223 1 25 1377X Guerrero St 1 1 1 3     12 3X3   6005871.04446 2100967.56548 37.7491888788632 -122.42249296966999 (37.7491888788632, -122.42249296967)
21449 24540 9 292 500X Cortland Ave 4 1 1 3     50 3X3   6007652.968230001 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819)
21616 25457 1 37 100 Randolph St 2 1 1 3   12/10/1997 12:00:00 AM 6 3X3   5993681.7949 2088543.8714 37.7143812997511 -122.463741645146 (37.7143812997511, -122.463741645146)
21634 24542 1 55 500X Cortland Ave 6 1 1 3   07/29/1999 12:00:00 AM 18 3X3   6007686.223540001 2097194.49045 37.7389310892969 -122.41594888193701 (37.7389310892969, -122.415948881937)
21638 18577 1 37 100 Randolph St 1 1 1 3   10/12/1998 12:00:00 AM 6 3X3   5993712.2633 2088544.8235 37.7143856696584 -122.46363640417201 (37.7143856696584, -122.463636404172)
48375 17720 1 37 1300X Pierce St 1 1 1 3   01/28/2013 12:00:00 AM 35 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
50090 13071 1 80 645X Lombard St 1 1 1 3   09/27/2006 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
51128 25415 1 12 895X Mansell St 5 1 1 3   07/19/1996 12:00:00 AM 9 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
52923 9470 1 150 800X Golden Gate Ave 26 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
76131 9462 1 22 800X Golden Gate Ave 18 1 1 3     6 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
77366 17721 1 37 1300X Pierce St 2 1 1 3   01/28/2013 12:00:00 AM 3 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
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)
77876 9463 1 22 800X Golden Gate Ave 19 1 1 3     6 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
78217 22401 1 11 5755X 03rd St 4 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
78511 9477 1 22 800X Golden Gate Ave 33 1 1 3   05/18/1992 12:00:00 AM 3 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
78527 17723 1 60 1300X Pierce St 4 1 1 3     90 3X3   6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
78609 26824 1 37 2000X San Jose Ave 17 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
78664 13380 1 12 1000X Mansell St 6 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
78668 17728 1 60 1300X Pierce St 9 1 1 3   05/20/1992 12:00:00 AM 70 3X3   6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
78767 12056 1 39 1330X La Salle Ave 1 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
79113 24925 1 316 2099X Post St 1 1 1 3   02/09/1996 12:00:00 AM 6 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
79265 26306 1 37 2000X San Jose Ave 9 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
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)
79530 9479 1 22 800X Golden Gate Ave 35 1 1 3   04/28/1998 12:00:00 AM 3 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
79616 24935 1 5 2099X Post St 12 1 1 3     3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
79960 26313 1 37 2000X San Jose Ave 16 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
80056 26299 1 37 2000X San Jose Ave 2 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
80328 26645 1 316 2199X Post St 8 1 1 3   06/22/1998 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
80819 12055 1 39 1300X La Salle Ave 7 1 1 3     18 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
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)
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)
81488 13074 1 16 645X Lombard St 4 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
81506 26304 1 37 2000X San Jose Ave 7 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
81892 26644 1 316 2199X Post St 7 1 1 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
81947 26643 1 316 2199X Post St 6 1 1 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
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)
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)
82591 24927 1 5 2099X Post St 3 1 1 3     36 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
83248 24932 1 5 2099X Post St 8 1 1 3   02/22/1996 12:00:00 AM 18 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
83331 9776 1 11 897X Gough St 4 1 1 3     30 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
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)
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)
85891 26298 1 37 2000X San Jose Ave 1 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
86895 13384 1 108 1000X Mansell St 10 1 1 3     12 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
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)
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)
87999 9918 1 108 1905X Gough St 2 1 1 3     20 3X3 Permit Number 768908 6005198.982724099 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562)
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)
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)
89209 9466 1 22 800X Golden Gate Ave 22 1 1 3     6 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
89492 17722 1 26 1300X Pierce St 3 1 1 3   04/25/2008 12:00:00 AM 3 3X3   6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
89936 9476 1 22 800X Golden Gate Ave 32 1 1 3   02/17/1998 12:00:00 AM 3 3X3   6005716.3316921 2112434.9405022 37.780666842627795 -122.423843265886 (37.7806668426278, -122.423843265886)
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)
91375 13073 1 16 645X Lombard St 3 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
91603 24685 1 37 6599X Geary Blvd 1 1 1 3   12/02/1998 12:00:00 AM 3 3X3   5986563.555448 2112507.5928897997 37.7797664796237 -122.490106359303 (37.7797664796237, -122.490106359303)
92206 26303 1 37 2000X San Jose Ave 6 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
92208 13378 1 12 1000X Mansell St 4 1 1 3   01/13/2000 12:00:00 AM 3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
Powered by Datasette · Query took 4.438ms · Data source: data.sfgov.org