sf-trees

Data source: data.sfgov.org

Custom SQL query returning 37 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10069 7948 1 91 1701 Franklin St 2 1 1 1   03/15/2014 12:00:00 AM 6 3X3   6005705.32484 2116013.7592599997 37.790492771869005 -122.42413593393499 (37.790492771869, -122.424135933935)
13712 6809 1 91 1400X Fairfax Ave 1 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016539.9784699995 2097547.42551 37.7403939741954 -122.385360989424 (37.7403939741954, -122.385360989424)
14629 14993 1 91 1445 Fairfax Ave 2 1 1 1   03/15/2006 12:00:00 AM 3 3X3   6016309.01096 2097636.9306 37.740626956171496 -122.38616582959 (37.7406269561715, -122.38616582959)
15010 6841 1 91 1461 Fairfax Ave 1 1 1 1   03/10/2007 12:00:00 AM 6 3X3   6016176.35578 2097734.0043599997 37.7408861578704 -122.38663127193199 (37.7408861578704, -122.386631271932)
15227 6810 1 91 1400X Fairfax Ave 2 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016518.03729 2097563.6173900003 37.74043721991 -122.38543798216999 (37.74043721991, -122.38543798217)
15782 6842 3 91 1461 Fairfax Ave 2 1 1 2   01/27/2016 07:14:00 AM 3 3X3   6016194.23735 2097718.16262 37.740843649614206 -122.38656833917901 (37.7408436496142, -122.386568339179)
16973 10247 3 91 112 Haight St 1 1 1 2   05/29/1997 12:00:00 AM 8 3X3   6005536.2501 2109637.4907 37.7729755585516 -122.424267236647 (37.7729755585516, -122.424267236647)
18351 10343 3 91 940 Haight St 1 1 1 2     25 3X3   6001599.8151 2109085.1313 37.7712358586189 -122.437844249148 (37.7712358586189, -122.437844249148)
18938 10354 3 91 1016 Haight St 1 1 1 2   01/28/2000 12:00:00 AM 20 3X3   6001244.7283 2109040.2146 37.771092330601604 -122.439069286514 (37.7710923306016, -122.439069286514)
18989 10323 1 91 774 Haight St 1 1 1 1   02/24/2009 12:00:00 AM 3 3X3   6002445.3097 2109202.4042 37.771605902741705 -122.43492804083999 (37.7716059027417, -122.43492804084)
19165 10233 3 91 20 Haight St 1 1 1 2     18 3X3   6005984.609 2109698.904 37.77316949126 -122.422720671561 (37.77316949126, -122.422720671561)
19533 25491 3 91 645 Haight St 2 1 1 2   10/29/2005 12:00:00 AM 8 3X3   6003026.26997 2109233.55885 37.7717244144917 -122.43292069334998 (37.7717244144917, -122.43292069335)
21724 10299 3 91 559 Haight St 1 1 1 2     24 3X3   6003469.25661 2109295.83619 37.7719205287291 -122.43139282162599 (37.7719205287291, -122.431392821626)
21845 10257 3 91 155 Haight St 1 1 1 2   02/21/2006 12:00:00 AM 6 3X3   6005354.145880001 2109555.43017 37.7727399559066 -122.424891318606 (37.7727399559066, -122.424891318606)
23042 10300 3 91 548 Haight St 1 1 1 2     3 3X3   6003485.1293 2109346.6257 37.772060883831 -122.43134154303002 (37.772060883831, -122.43134154303)
23175 25492 3 91 645 Haight St 3 1 1 2   11/15/2001 12:00:00 AM 5 3X3   6003043.5783 2109236.3656 37.7717331028377 -122.43286102333299 (37.7717331028377, -122.432861023333)
81436 6830 1 91 1450X Fairfax Ave 12 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
82897 15297 3 91 1625 Mission St 3 1 1 2   03/02/1995 12:00:00 AM 0 3X3   6007067.55267 2109351.08159 37.7722754939412 -122.4189499451 (37.7722754939412, -122.4189499451)
83488 6826 1 91 1450X Fairfax Ave 8 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
85140 10309 3 91 629 Haight St 1 1 1 2   01/22/2011 12:00:00 AM 3 3X3   6003124.536169999 2109214.79731 37.7716784730152 -122.43257944422399 (37.7716784730152, -122.432579444224)
86179 6837 1 91 1475 FAIRFAX AVE 2 1 1 1   03/14/2001 12:00:00 AM 6 3X3   6016157.0 2097767.0 37.740975685587394 -122.386700497992 (37.7409756855874, -122.386700497992)
91795 6840 1 91 1469 FAIRFAX AVE 1 1 1 1   03/10/2007 12:00:00 AM 6 3X3   6016172.0 2097718.0 37.740841972016504 -122.386645216998 (37.7408419720165, -122.386645216998)
104221 6822 1 91 1450X Fairfax Ave 3 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
104856 10264 3 91 212 Haight St 3 1 1 2     60 3X3   6005102.223809999 2109572.2105099997 37.7727717979426 -122.42576394022 (37.7727717979426, -122.42576394022)
105727 15296 3 91 1625 Mission St 2 1 1 2   03/02/1995 12:00:00 AM 3 3X3   6007067.55267 2109351.08159 37.7722754939412 -122.4189499451 (37.7722754939412, -122.4189499451)
107229 6843 1 91 1445 FAIRFAX AVE 1 1 1 1   03/14/2007 12:00:00 AM 6 3X3   6016186.0 2097583.0 37.7404720645711 -122.38658739858299 (37.7404720645711, -122.386587398583)
113110 27335 3 91 398 Haight St 1 1 1 2   10/29/2005 12:00:00 AM 12 3X3   6004279.72317 2109472.24988 37.7724508171595 -122.428601935914 (37.7724508171595, -122.428601935914)
115984 10311 3 91 657 Haight St 1 1 1 2   02/04/1999 12:00:00 AM 8 3X3   6003004.4895 2109163.37188 37.7715304629462 -122.43299101798401 (37.7715304629462, -122.432991017984)
118460 14967 3 91 395 Mendell St 2 1 1 2   12/17/1998 12:00:00 AM 3 3X3   6016770.717680001 2097736.2935200003 37.7409253302671 -122.384576328932 (37.7409253302671, -122.384576328932)
120939 10320 3 91 758 Haight St 1 1 1 2   12/02/1992 12:00:00 AM 25 3X3   6002531.73322 2109228.96362 37.771683734938996 -122.43463099668699 (37.771683734939, -122.434630996687)
121627 10266 3 91 212 Haight St 5 1 1 2     24 3X3   6005102.223809999 2109572.2105099997 37.7727717979426 -122.42576394022 (37.7727717979426, -122.42576394022)
124744 6820 1 91 1450X Fairfax Ave 1 1 1 11   12/19/2000 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
126615 4556 3 91 1340X Laguna St 4 1 1 2   01/29/2000 12:00:00 AM 3 3X3   6004655.03099 2113461.96066 37.7834268147862 -122.427588006915 (37.7834268147862, -122.427588006915)
127073 6827 1 91 1450X Fairfax Ave 9 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
128886 6821 1 91 1450X Fairfax Ave 2 1 1 11   12/19/2000 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
139543 10297 3 91 540 Haight St 1 1 1 2   10/29/2005 12:00:00 AM 8 3X3   6003554.89128 2109371.3672 37.7721327712956 -122.43110199714701 (37.7721327712956, -122.431101997147)
140820 10265 3 91 212 Haight St 4 1 1 2     60 3X3   6005102.223809999 2109572.2105099997 37.7727717979426 -122.42576394022 (37.7727717979426, -122.42576394022)
Powered by Datasette · Query took 6.22ms · Data source: data.sfgov.org