sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
54 121137 4 26 1388x Minna St 1 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
60 121139 4 26 1388x Minna St 3 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 4 26 1388x Minna St 2 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
2571 253124 4 17 399x Lexington St 1 1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780530          
4880 253705 4 49 98X Shotwell St 2 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4889 253706 4 49 98X Shotwell St 3 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
9959 57959 4 12 336 Hanover St 1 1 1 1   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288)
109947 120109 4 88 555 Ellington Ave 1 1 1 1   08/03/2016 12:00:00 AM 3 3x3   5997970.0 2087042.0 37.7105036758619 -122.44881186315901 (37.7105036758619, -122.448811863159)
126380 117510 4 134 23x BRIGHT ST 1 1 1 1   06/17/2016 12:00:00 AM 3 3x3   5993679.0 2087403.0 37.711248577137496 -122.463668552658 (37.7112485771375, -122.463668552658)
17607 1217 4 44 3501 Alemany Blvd 2 1 1 1   06/17/2016 12:00:00 AM 3 3x3   5993695.72185 2087421.0982400002 37.711299234146296 -122.463612070865 (37.7112992341463, -122.463612070865)
9782 159354 4 58 417x Ellington Ave 1 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998501.29354 2087549.7908 37.7119283225022 -122.44701212372802 (37.7119283225022, -122.447012123728)
9769 159355 4 50 417 Ellington Ave 2 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.882680001 2087558.1907400002 37.7119518775514 -122.44698304145001 (37.7119518775514, -122.44698304145)
9792 159358 4 13 49 Naglee Ave 2 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998584.62871 2087583.8857099998 37.712026700246 -122.446726546692 (37.712026700246, -122.446726546692)
9771 159357 4 37 49 Naglee Ave 1 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998577.1355099995 2087591.01668 37.7120458522191 -122.446752958004 (37.7120458522191, -122.446752958004)
3901 253246 4 49 1192 Naples St 1 1 1 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001173.0 2087586.0 37.7121800264355 -122.437780563503 (37.7121800264355, -122.437780563503)
3890 161753 4 49 175x Newton St 1 1 1 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001022.0 2087749.0 37.7126190008501 -122.43831413288 (37.7126190008501, -122.43831413288)
9718 105047 4 37 278 Capitol Ave   1 1 1       3x3   5995102.4 2087946.7 37.7128233663074 -122.458788296392 (37.7128233663074, -122.458788296392)
125501 122796 4 21 306 Arleta Ave 1 1 1 1   11/28/2016 12:00:00 AM 3 3x3   6009497.08014 2088289.5150400002 37.7145815488228 -122.40905958389999 (37.7145815488228, -122.4090595839)
82889 114908 4 88 281 LOBOS ST 1 1 1 1       3x3   5994225.0 2088676.0 37.714775380268996 -122.461873702271 (37.714775380269, -122.461873702271)
78883 98406 4 37 237 Minerva St 1 1 1 1   04/15/2016 12:00:00 AM 3 3x3 Permit Number 778181 5994692.2 2088928.8 37.7154963945459 -122.46027718208401 (37.7154963945459, -122.460277182084)
91141 67994 4 37 241 Minerva St 1 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 776577 5994615.10957021 2088996.30431809 37.7156773106674 -122.460548527933 (37.7156773106674, -122.460548527933)
81046 113699 4 37 239 Minerva St 2 1 1 1   04/15/2016 12:00:00 AM 3 3x3 Permit Number 778180 5994635.15348587 2088996.04011087 37.715677738331706 -122.460479228374 (37.7156777383317, -122.460479228374)
948 251406 4 12 445 Amazon Ave 1 1 1 1   04/25/2017 12:00:00 AM 3 3x3   6001636.0 2088904.0 37.7158252789105 -122.43627456666799 (37.7158252789105, -122.436274566668)
976 160371 4 12 868 Edinburgh St 3 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001686.38396 2088939.3945099998 37.7159253269669 -122.43610294800199 (37.7159253269669, -122.436102948002)
994 160370 4 12 868 Edinburgh St 2 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349)
991 160369 4 12 868 Edinburgh St 1 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001700.06015 2088961.7176 37.715987398188894 -122.436057273237 (37.7159873981889, -122.436057273237)
122654 116267 4 183 717 PARIS ST 1 7 1 1       3x3   6001138.0 2089523.0 37.717496606347495 -122.438040195581 (37.7174966063475, -122.438040195581)
125393 121465 4 17 218 Faxon Ave 1 1 1 1   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778899 5994755.067290001 2090055.4837 37.7185936165551 -122.46014146415101 (37.7185936165551, -122.460141464151)
84622 121145 4 21 962 Capitol Ave 1 1 1 1   09/09/2016 12:00:00 AM 3 3x3   5995080.0 2090346.0 37.7194099895512 -122.45903933602399 (37.7194099895512, -122.459039336024)
98279 120680 4 48 522 Moscow St 1 1 1 1   08/23/2016 12:00:00 AM 3 3x3   6003717.0 2090174.0 37.719430440149104 -122.42917217063999 (37.7194304401491, -122.42917217064)
143274 122379 4 88 466 Vernon St 1 8 1 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
12678 108261 4 50 379 Lisbon St 1 1 1 1   12/16/2015 12:00:00 AM 3 4x4 Permit Number 774479 6002548.02456 2091247.69967 37.7223123355393 -122.43328956378201 (37.7223123355393, -122.433289563782)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
171742 115979 4 88 2x Olmstead St 4 1 1 1     1 3x3   6011610.19593 2091240.25279 37.722801825729604 -122.401963063449 (37.7228018257296, -122.401963063449)
172623 115978 4 88 2x Olmstead St 3 1 1 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
182061 115977 4 88 2x Olmstead St 2 1 1 1     1 3x3   6011639.0005 2091249.90123 37.722829925953896 -122.40186416949 (37.7228299259539, -122.40186416949)
12646 115976 4 88 2x Olmstead St 1 1 1 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
12462 115357 4 142 270 Ocean Ave 1 1 1 1   01/27/2016 12:00:00 AM 3 3x6   5999894.51999 2091641.8812799999 37.723243775973394 -122.442490363056 (37.7232437759734, -122.442490363056)
78467 115494 4 75 1199X OCEAN AVE 2 1 1 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
84834 115491 4 75 280 BRIGHTON AVE 2 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
88750 115493 4 75 280 BRIGHTON AVE 4 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
116577 106315 4 75 1199X OCEAN AVE 1 1 1 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
126990 115495 4 75 1199X OCEAN AVE 3 1 1 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
129261 115492 4 75 280 BRIGHTON AVE 3 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
143786 115490 4 75 280 BRIGHTON AVE 1 1 1 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
9719 173651 4 88 80 Entrada Ct 3 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9723 173650 4 12 80 Entrada Ct 2 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
11604 116262 4 12 35 La Grande Ave 1 1 1 1   03/22/2016 12:00:00 AM 3 3x4   6005278.18089 2092026.4994299999 37.724605255111896 -122.42390739821998 (37.7246052551119, -122.42390739822)
90462 121463 4 17 415 Oxford St 2 1 1 1   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.7240000002 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563)
145095 121462 4 17 415 Oxford St 1 1 1 1   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.7240000002 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
84353 115886 4 482 134 Lunado Way 1 1 1 1   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397)
126350 115887 4 482 134 Lunado Way 2 1 1 1   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397)
126630 115885 4 482 134 Lunado Way 1 9 1 1   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397)
91500 122697 4 44 98 Woolsey St 1 1 1 1   11/16/2016 12:00:00 AM 3 3x3   6011441.9927199995 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524)
101006 122699 4 44 98 Woolsey St 3 1 1 1   11/16/2016 12:00:00 AM 3 3x3   6011441.9927199995 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524)
141801 122698 4 44 98 Woolsey St 2 1 1 1   11/16/2016 12:00:00 AM 3 3x3   6011441.9927199995 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524)
128007 122701 4 6 2895 San Bruno Ave 5 1 1 1   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.7679400002 37.7253343641976 -122.40256910729201 (37.7253343641976, -122.402569107292)
145746 122700 4 6 2895 San Bruno Ave 1 1 1 1   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.7679400002 37.7253343641976 -122.40256910729201 (37.7253343641976, -122.402569107292)
128992 121466 4 17 79 Harrington St 1 1 1 1   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778952 6001819.85633 2092538.60283 37.7258155279415 -122.43589898702801 (37.7258155279415, -122.435898987028)
2575 253126 4 26 182 London St   1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
9964 173762 4 37 1405 Van Dyke Ave 2 1 1 1   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.7192900002 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894)
9965 173761 4 37 1405 Van Dyke Ave 1 1 1 1   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.7192900002 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894)
3048 253287 4 17 1237 Shafter Ave 1 1 1 1   08/16/2017 12:00:00 AM 3 3x3 Permit Number 780510 6016839.12241 2092718.7941400001 37.727152059320204 -122.383990506478 (37.7271520593202, -122.383990506478)
10513 117008 4 18 1315 Silliman St 1 1 1 1   05/13/2016 12:00:00 AM 3 3x3   6006952.61647 2093135.11232 37.7277436552341 -122.418197638517 (37.7277436552341, -122.418197638517)
10564 116803 4 12 931 Silver Ave 1 1 1 1   04/27/2016 12:00:00 AM 3 3x3   6007342.71844 2093540.3953900002 37.728878425184796 -122.416877747635 (37.7288784251848, -122.416877747635)
141647 122627 4 12 34 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731.0 2094410.0 37.729968312905505 -122.49511098534401 (37.7299683129055, -122.495110985344)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
2687 253164 4 17 146 Cambridge St 1 8 1 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
96115 121093 4 17 150 Ridgewood Ave 1 1 1 1   09/06/2016 12:00:00 AM 3 3x3 Permit Number 778915 5996816.77701 2094570.7008900002 37.7311097051787 -122.453340820219 (37.7311097051787, -122.453340820219)
101885 122625 4 141 189 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222.0 2094938.0 37.731388248087605 -122.496909587532 (37.7313882480876, -122.496909587532)
1180 251470 4 37 194 Sweeny St 1 1 1 1   05/04/2017 12:00:00 AM 3 3x3 Permit Number 777454 6009558.57553 2094850.0846799999 37.7325989441491 -122.409309728531 (37.7325989441491, -122.409309728531)
2759 253203 4 120 349 Mangels Ave 1 5 1 1       3x3   5999103.0 2095207.0 37.732987611392005 -122.44548271607799 (37.732987611392, -122.445482716078)
138648 122626 4 141 330 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613.0 2095517.0 37.73300093168071 -122.495600537949 (37.7330009316807, -122.495600537949)
5103 253796 4 49 100 Scotia Ave 1 1 1 1   11/07/2017 12:00:00 AM 3   Permit Number 779938 6011980.63004 2095004.60122 37.733158617067296 -122.40094689916799 (37.7331586170673, -122.400946899168)
9629 173614 4 51 2955 20th Ave 2 9 1 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
9631 173613 4 51 2955 20th Ave 1 9 1 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
5242 243740 4 13 550 Laidley St 1 1 1 1   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.0557699995 2096015.8076799999 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248)
4385 224618 4 94 165 Sussex St 1 1 1 2     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198)
4329 239457 4 18 165 Sussex St 2 1 1 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437)
4369 222216 4 28 2 Van Buren St 1 1 1 2     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887)
4404 239458 4 18 165 Sussex St 3 1 1 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)
128502 66394 4 41 504 Andover St 1 1 1 1   10/26/2016 12:00:00 AM 3 3x4 Permit Number 772815 6007447.25872729 2096493.62336554 37.7369932248849 -122.41672547553001 (37.7369932248849, -122.41672547553)
4790 158406 4 41 50 Conrad St 1 1 1 1   10/25/2017 12:00:00 AM 3 3X3 Permit Number 770857 6001789.37716 2096842.5543 37.7376314601307 -122.436312235543 (37.7376314601307, -122.436312235543)
77786 124717 4 51 610 Cortland Ave 1 1 1 1   12/02/2016 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.738938646129704 -122.41581766964899 (37.7389386461297, -122.415817669649)
86220 124718 4 51 610 Cortland Ave 2 1 1 1   12/02/2016 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.738938646129704 -122.41581766964899 (37.7389386461297, -122.415817669649)
3174 253344 4 88 2586 30th Ave 1 1 1 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
22901 183545 4 7 2580 26th Ave 1 1 1 1   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.73937736557679 -122.482876432223 (37.7393773655768, -122.482876432223)
81719 112974 4 12 4099x ULLOA ST 3 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
90957 112973 4 12 4099x ULLOA ST 2 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
105015 112975 4 12 4099x ULLOA ST 4 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
127737 112972 4 12 4099x ULLOA ST 1 5 1 1   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
9790 104876 4 227 2478 43rd Ave   5 1 1   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.740479796641296 -122.50114367627701 (37.7404797966413, -122.501143676277)
2257 229627 4 21 3662 Folsom St 1 1 1 1     1 Width 3ft   6008456.11159 2097816.22885 37.7406815009641 -122.41333091228701 (37.7406815009641, -122.413330912287)
2025 243143 4 12 98x Eugenia Ave 1 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2032 243144 4 12 98x Eugenia Ave 2 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
22979 112863 4 12 2451 19TH AVE 1 1 1 1   08/25/2015 12:00:00 AM 3 3x3   5990427.0 2098705.0 37.7420931085193 -122.475732948104 (37.7420931085193, -122.475732948104)
2715 253166 4 82 2405 32nd Ave 1 1 1 1   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.48968039586501 (37.742306656921, -122.489680395865)
3083 252820 4 49 2339 41st Ave 1 1 1 1   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.6863599997 37.743137766616 -122.49941055724301 (37.743137766616, -122.499410557243)
110233 43569 4 44 601 29TH ST 3 1 1 1   07/20/2000 12:00:00 AM   3x3 Permit Number 43230 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
145677 108030 4 12 601 29th St 1 1 1 1   11/17/2014 12:00:00 AM 3 3x3   6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
Powered by Datasette · Query took 4.447ms · Data source: data.sfgov.org