sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3821 46195 1 21   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
5109 36635 1 21   10 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5809 46193 1 21   4 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
6461 34901 1 21   7 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
6892 36621 1 21   5 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
7024 34903 1 21   4 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
8059 34906 1 21   1 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
8112 36618 1 21   8 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
9577 36622 1 21   4 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
9973 34904 1 21   3 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
10516 46191 1 21   5 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
10947 34905 1 21   6 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
11359 36625 1 21   1 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
11887 46194 1 21   3 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
11991 46192 1 21   6 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
12314 36623 1 21   3 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
12930 36616 1 21   11 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13700 36624 1 21   2 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13764 36627 1 21   9 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13775 46199 1 21   7 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
14367 46202 1 21   1 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
15451 34902 1 21   5 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
15974 36620 1 21   6 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
16053 36610 1 21   7 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
16211 34900 1 21   2 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
78220 34235 1 21   1 1 1 1   06/30/1997 12:00:00 AM     Permit Number 38048 6016895.91787464 2103845.69851644 37.757707418448895 -122.38456887610201 (37.7577074184489, -122.384568876102)
2357 39974 1 21 0 Steiner St 4 1 1 1         Permit Number 41235          
12032 39973 1 21 0 Steiner St 3 1 1 1         Permit Number 41235          
15515 39976 1 21 0 Steiner St 5 1 1 1         Permit Number 41235          
68923 123900 2 21 1 11th Ave 1 2 1 1     9 Width 10ft   5992382.46379 2114901.63457 37.7866779493995 -122.470150767402 (37.7866779493995, -122.470150767402)
131610 193291 2 21 1 Ardath Ct 14 1 1 1     2 Width 3ft   6017457.59567 2095286.9396900001 37.7342378548914 -122.382030995952 (37.7342378548914, -122.382030995952)
158336 193288 2 21 1 Ardath Ct 1 1 1 1     2 Width 3ft   6017236.66649 2095426.16645 37.734607940290104 -122.382804511829 (37.7346079402901, -122.382804511829)
171547 193289 2 21 1 Ardath Ct 6 1 1 1     2 Width 3ft   6017396.94192 2095313.3929599999 37.7343071404432 -122.38224253716601 (37.7343071404432, -122.382242537166)
178805 193290 2 21 1 Ardath Ct 13 1 1 1     2 Width 3ft   6017463.55131 2095291.12818 37.734249684563 -122.38201069645099 (37.734249684563, -122.382010696451)
23962 245061 2 21 1 Baker St 4 1 1 1     6 Width 0ft   6000833.6361 2109001.0122 37.7709612910265 -122.44048845278 (37.7709612910265, -122.44048845278)
45889 201340 2 21 1 Bitting Ave 2 9 1 1     4     6012714.10336 2092626.0861900002 37.7266685912663 -122.39824424808901 (37.7266685912663, -122.398244248089)
168141 201342 2 21 1 Bitting Ave 4 9 1 1     3     6012732.15495 2092620.2542299998 37.7266535833942 -122.398181434938 (37.7266535833942, -122.398181434938)
175355 229657 2 21 1 Bradford St 2 1 1 1     9 Width 4ft   6009643.76186 2098683.06501 37.743128253176295 -122.40928560886499 (37.7431282531763, -122.409285608865)
184615 230854 2 21 1 Castro St 7 1 1 1     3 Width 3ft   6002226.53145 2107879.97904 37.7679624253424 -122.435590183343 (37.7679624253424, -122.435590183343)
56781 230558 2 21 1 College Ave 1 1 1 1     10 Width 3ft   6004244.19102 2095797.65599 37.7349015806344 -122.42775034252399 (37.7349015806344, -122.427750342524)
109757 60992 1 21 1 College Ave 1 1 1 1 1 03/22/1993 12:00:00 AM     Permit Number 31624 6004216.5458966 2095763.6003461003 37.7348065076562 -122.42784349558998 (37.7348065076562, -122.42784349559)
34346 202086 2 21 1 Gould St 14 2 1 1     12     6012832.48602 2091118.85258 37.722536627341796 -122.39772932687299 (37.7225366273418, -122.397729326873)
38534 192961 2 21 1 Missouri St 2 1 1 1     7 Width 3ft   6013428.8993 2106971.39143 37.7660975461955 -122.39677846284901 (37.7660975461955, -122.396778462849)
41355 192962 2 21 1 Missouri St 3 1 1 1     8 Width 3ft   6013428.91312 2106990.27483 37.766149396595104 -122.39677973902 (37.7661493965951, -122.39677973902)
157347 192963 2 21 1 Missouri St 4 1 1 1     9 Width 3ft   6013426.6142 2107013.53276 37.7662131297585 -122.396789321282 (37.7662131297585, -122.396789321282)
159740 192960 2 21 1 Missouri St 1 1 1 1     8 Width 3ft   6013429.15967 2106956.37648 37.7660563329628 -122.396776509533 (37.7660563329628, -122.396776509533)
182635 192964 2 21 1 Missouri St 5 1 1 1     9 Width 3ft   6013426.74121 2107037.58883 37.7662791894618 -122.396790568631 (37.7662791894618, -122.396790568631)
111483 113691 2 21 1 WALTER U LUM PL 2 1 1 1       3x3   6010972.0 2117336.0 37.794419283176495 -122.406006661324 (37.7944192831765, -122.406006661324)
127146 113690 2 21 1 WALTER U LUM PL 1 1 1 1       3x3   6010972.0 2117336.0 37.794419283176495 -122.406006661324 (37.7944192831765, -122.406006661324)
27985 143502 2 21 1 Walter U Lum Pl 2 1 1 1     12 Width 0ft   6011053.9105 2117332.9615 37.7944155210534 -122.405723025535 (37.7944155210534, -122.405723025535)
79650 107185 6 21 10 Florence St 1 8 1 1         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272)
62581 177303 2 21 10 Ruth St 3 2 1 1     4 Width 2ft   6001666.9736 2091588.58341 37.7231983035377 -122.436359529079 (37.7231983035377, -122.436359529079)
67374 177304 2 21 10 Ruth St 5 2 1 1     3 Width 2ft   6001647.41554 2091598.6912099998 37.723224945954 -122.43642786046101 (37.723224945954, -122.436427860461)
36665 193207 2 21 10 South Park 2 1 1 1     8 Width 3ft   6014550.69631 2112820.9410200003 37.7822214767738 -122.393307738057 (37.7822214767738, -122.393307738057)
52583 193206 2 21 10 South Park 1 1 1 1     9 Width 3ft   6014561.27051 2112829.17177 37.7822446640061 -122.39327173191201 (37.7822446640061, -122.393271731912)
36657 230266 2 21 10 Wilder St 1 1 1 1     9 Width 3ft   6002981.00853 2095469.58645 37.73392923992321 -122.43209418311199 (37.7339292399232, -122.432094183112)
93538 65368 1 21 10 Wilder St 1 1 1 1 1 09/30/1989 12:00:00 AM     Permit Number 28206 6003053.48376145 2095454.29402477 37.733891359152395 -122.43184252277 (37.7338913591524, -122.43184252277)
25924 46092 1 21 100 19th Ave 2 1 1 1   12/10/2001 12:00:00 AM 2   Permit Number 44465 5989927.3729 2114632.55981 37.785796907481206 -122.478625013843 (37.7857969074812, -122.478625013843)
89407 46091 1 21 100 19th Ave 4 1 1 1   12/10/2001 12:00:00 AM     Permit Number 44465 5989930.31260509 2114699.05014668 37.785979641938205 -122.478619707642 (37.7859796419382, -122.478619707642)
123888 46090 1 21 100 19th Ave 5 1 1 1   12/10/2001 12:00:00 AM     Permit Number 44465 5989930.31260509 2114699.05014668 37.785979641938205 -122.478619707642 (37.7859796419382, -122.478619707642)
56457 140847 2 21 100 COMMONWEALTH AVE 3 2 1 1     5 Width 0ft   5996563.0036 2113772.191 37.7838175945574 -122.455605521023 (37.7838175945574, -122.455605521023)
76435 140846 2 21 100 COMMONWEALTH AVE 2 2 1 1     8 Width 0ft   5996563.342 2113760.0078 37.783784162147704 -122.455603469395 (37.7837841621477, -122.455603469395)
125984 33498 1 21 100 Coleridge St 1 1 1 1   11/25/1996 12:00:00 AM     Permit Number 37606 6006683.58482984 2099106.89574168 37.74412570540729 -122.419551194294 (37.7441257054073, -122.419551194294)
118336 52505 1 21 100 Delano Ave 3 1 1 1 1 12/28/2005 12:00:00 AM     Permit Number 48612 6000459.21212403 2092796.53249414 37.726446355434106 -122.44062111517599 (37.7264463554341, -122.440621115176)
120191 52504 1 21 100 Delano Ave 2 1 1 1 1 12/28/2005 12:00:00 AM     Permit Number 48612 6000459.21212403 2092796.53249414 37.726446355434106 -122.44062111517599 (37.7264463554341, -122.440621115176)
138847 52503 1 21 100 Delano Ave 1 1 1 1 1 12/28/2005 12:00:00 AM     Permit Number 48612 6000459.21212403 2092796.53249414 37.726446355434106 -122.44062111517599 (37.7264463554341, -122.440621115176)
37119 230739 2 21 100 Diamond St 2 1 1 1     11 Width 3ft   6001694.43925 2105191.75415 37.760550982871706 -122.43723812355199 (37.7605509828717, -122.437238123552)
75557 230738 2 21 100 Diamond St 1 1 1 1     12 Width 3ft   6001693.29132 2105215.82364 37.7606170065784 -122.437243817162 (37.7606170065784, -122.437243817162)
150398 208602 2 21 100 Edgewood Ave 1 10 1 1     16 Width 4ft   5996618.83287 2106426.3084 37.7636509189712 -122.454881430853 (37.7636509189712, -122.454881430853)
37957 230116 2 21 100 Ellert St 2 1 1 1     13 Width 3ft   6007159.83351 2097032.6620599998 37.738457135785296 -122.41775743207701 (37.7384571357853, -122.417757432077)
95557 12527 3 21 100 Lake St 1 1 1 2     45 3x3   5995151.97418 2114942.29811 37.7869493206202 -122.460571940769 (37.7869493206202, -122.460571940769)
26135 130570 2 21 100 Maple St 9 1 1 1     6 Width 3ft   5996597.05315 2115854.8899 37.789538083068706 -122.45563831375401 (37.7895380830687, -122.455638313754)
35620 130566 2 21 100 Maple St 5 1 1 1     7 Width 3ft   5996609.34051 2115762.66793 37.789285571419796 -122.45558913254 (37.7892855714198, -122.45558913254)
50725 130567 2 21 100 Maple St 6 1 1 1     5 Width 3ft   5996608.23291 2115784.90382 37.7893465616436 -122.455594572544 (37.7893465616436, -122.455594572544)
52182 130568 2 21 100 Maple St 7 1 1 1     2 Width 3ft   5996607.55895 2115808.58588 37.7894115475449 -122.45559861679199 (37.7894115475449, -122.455598616792)
75925 130565 2 21 100 Maple St 3 1 1 1     12 Width 3ft   5996612.8231 2115714.26414 37.789152867453396 -122.455573583256 (37.7891528674534, -122.455573583256)
135380 130571 2 21 100 Maple St 10 1 1 1     5 Width 3ft   5996592.08363 2115880.31383 37.78960760516829 -122.45565734611401 (37.7896076051683, -122.455657346114)
167700 130569 2 21 100 Maple St 8 1 1 1     4 Width 3ft   5996602.67631 2115833.52881 37.7894797539414 -122.45561731370701 (37.7894797539414, -122.455617313707)
111402 91383 1 21 100 SAN JOSE AVE 1 1 1 1     3 3x3   6006168.0 2102576.0 37.7536220187283 -122.421580311855 (37.7536220187283, -122.421580311855)
15835 19850 3 21 100 STAIRWAY27 1 1 1 2     3 10ST            
13312 20032 3 21 100 STAIRWAY51 3 1 1 2     3 3X3ST            
41133 230130 2 21 100 San Jose Ave 2 1 1 1     2 Width 3ft   6006162.21511 2102529.99038 37.7534953607276 -122.42159704978998 (37.7534953607276, -122.42159704979)
67045 193107 2 21 100 Thornton Ave 1 4 1 1     4 Width 3ft   6014292.7910400005 2094097.73703 37.7307972573678 -122.392889649557 (37.7307972573678, -122.392889649557)
155233 193108 2 21 100 Thornton Ave 2 4 1 1     4 Width 3ft   6014279.85245 2094099.9138200001 37.7308025157065 -122.392934532911 (37.7308025157065, -122.392934532911)
165073 130905 2 21 1000 Jones St 2 1 1 1     3 Width 3ft   6008670.58834 2116008.76921 37.7906460469339 -122.41387591943199 (37.7906460469339, -122.413875919432)
430 103824 1 21 1000 Polk St 4 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006951.91038 2114418.6460599997 37.786183288961205 -122.419709589538 (37.7861832889612, -122.419709589538)
5593 103823 1 21 1000 Polk St 5 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006948.133219999 2114434.09135 37.7862254851663 -122.419723753855 (37.7862254851663, -122.419723753855)
6648 103825 1 21 1000 Polk St 3 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006956.54225 2114398.79268 37.786129037366294 -122.41969215528 (37.7861290373663, -122.41969215528)
73635 130882 2 21 1000 Polk St 6 1 1 1     5 Width 4ft   6006947.79281 2114448.21135 37.7862642360477 -122.419725933829 (37.7862642360477, -122.419725933829)
75772 230011 2 21 1000 Stanyan St 1 1 1 1     12 Width 3ft   5997298.06475 2106860.60293 37.7648823210859 -122.452563536173 (37.7648823210859, -122.452563536173)
23342 4711 3 21 1000 Taylor St 1 1 1 2     4 3X3   6008439.857000001 2120847.9647 37.8039203178058 -122.41501690508801 (37.8039203178058, -122.415016905088)
49882 229404 2 21 1000 York St 3 1 1 1     5 Width 3ft   6009947.44128 2103311.08092 37.7558527725071 -122.408561960379 (37.7558527725071, -122.408561960379)
154171 229402 2 21 1000 York St 1 1 1 1     5 Width 3ft   6009946.62507 2103338.81408 37.7559288758449 -122.40856673937799 (37.7559288758449, -122.408566739378)
166081 229403 2 21 1000 York St 2 1 1 1     6 Width 3ft   6009946.56186 2103326.03812 37.7558937923786 -122.408566056777 (37.7558937923786, -122.408566056777)
70207 229597 2 21 1001 Clayton St 1 1 1 1     8 Width 4ft   5998810.79476 2106435.70161 37.7638022056215 -122.44730082587601 (37.7638022056215, -122.447300825876)
80893 46114 1 21 1001 Clayton St 1 1 1 1   12/24/2001 12:00:00 AM     Permit Number 44473 5998803.64501261 2106479.79215495 37.7639228586403 -122.44732872816401 (37.7639228586403, -122.447328728164)
111463 68477 1 21 1001 Hampshire St 1 1 1 1 1 10/18/1993 12:00:00 AM     Permit Number 32346 6010253.77501878 2103382.5290377 37.756066104478 -122.407507590908 (37.756066104478, -122.407507590908)
177091 229344 2 21 1001 Hampshire St 2 1 1 1     12 Width 6ft   6010247.17323 2103327.9648599997 37.755915913899 -122.40752657540001 (37.755915913899, -122.4075265754)
182836 208733 2 21 1001 Ortega St 2 1 1 1     3 Width 3ft   5990828.95595 2102433.7995 37.752354718202604 -122.474615201448 (37.7523547182026, -122.474615201448)
150161 142882 2 21 1001 POLK ST 2 10 1 1     2 Width 0ft   6006903.448 2114407.3806 37.7861496266915 -122.41987645727801 (37.7861496266915, -122.419876457278)
159164 113231 2 21 1001 Polk St 2 10 1 1     3 3x3   6006895.89971 2114421.0496799997 37.7861867333855 -122.419903542741 (37.7861867333855, -122.419903542741)
Powered by Datasette · Query took 44.939ms · Data source: data.sfgov.org