sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8590 102757 2 70 2807 Steiner St 2 1 1 1     8 3x3   6002051.958459999 2117801.7316900003 37.795195129895895 -122.436904386043 (37.7951951298959, -122.436904386043)
24159 33290 1 70 166 Sproule Ln 2 1 1 1 1 11/14/1996 12:00:00 AM 8   Permit Number 37451 6009219.4283 2116994.47406 37.7933833601996 -122.41204664625499 (37.7933833601996, -122.412046646255)
24227 203475 2 70 2357 16th Ave 1 2 1 1     8 Width 3ft   5991280.398630001 2099387.14513 37.7440155431828 -122.472831922275 (37.7440155431828, -122.472831922275)
31906 220602 2 70 345 Valley St 1 1 1 1     8 Width 2ft   6003653.16044 2099206.97915 37.744229349819896 -122.43003686791401 (37.7442293498199, -122.430036867914)
32542 221762 2 70 4407 20th St 1 1 1 1     8 Width 3ft   6001705.956180001 2104074.38405 37.7574836102927 -122.43711828977399 (37.7574836102927, -122.437118289774)
34506 125457 2 70 2807 Steiner St 4 9 1 1     8 Width 4ft   6002053.50035 2117793.13608 37.795171616221104 -122.43689843522101 (37.7951716162211, -122.436898435221)
41654 125506 2 70 7 Fallon Pl 1 9 1 1     8 Width 4ft   6008920.97468 2118571.47788 37.7976966751291 -122.413190886946 (37.7976966751291, -122.413190886946)
48805 220628 2 70 907 Elizabeth St 1 9 1 1     8 Width 4ft   6000553.10276 2101957.71166 37.751606143208 -122.44095346395201 (37.751606143208, -122.440953463952)
55076 125501 2 70 1115 Filbert St 2 9 1 1     8 Width 4ft   6007553.747280001 2119514.62481 37.8002094690578 -122.417988773678 (37.8002094690578, -122.417988773678)
63824 220654 2 70 580 Ogden Ave 2 1 1 1     8 Width 3ft   6008103.73158 2096079.3451 37.735892608341 -122.414426443037 (37.735892608341, -122.414426443037)
67240 125498 2 70 1154 Chestnut St 6 9 1 1     8 Width 2ft   6006270.07079 2120429.11585 37.8026480985929 -122.422495818752 (37.8026480985929, -122.422495818752)
72887 189192 2 70 30 15th St 1 1 1 1     8 Width 4ft   6012099.2034599995 2107516.8442700002 37.767521137926394 -122.401415981588 (37.7675211379264, -122.401415981588)
73487 125479 2 70 1133 Clay St 1 1 1 1     8 Width 3ft   6009244.74147 2117035.03683 37.793496155866706 -122.411961928316 (37.7934961558667, -122.411961928316)
73496 220620 2 70 747 Duncan St 1 9 1 1     8 Width 4ft   6001698.74806 2099680.01267 37.745417306567 -122.43682864783001 (37.745417306567, -122.43682864783)
75383 125524 2 70 220 Lombard St 8 9 1 1     8 Width 9ft   6011207.6846199995 2120726.9389400003 37.8037431562814 -122.40543008395201 (37.8037431562814, -122.405430083952)
76753 125472 2 70 655 Powell St 5 9 1 1     8 Width 2ft   6010077.8197800005 2116010.1713 37.790728826812206 -122.40900705375401 (37.7907288268122, -122.409007053754)
136912 250078 2 70 399 Austin St 4 4 1 1     8 Width 3ft   6005435.52045 2115308.45101 37.78854093456471 -122.425019237271 (37.7885409345647, -122.425019237271)
149175 249549 2 70 380 Fern St 1 4 1 1     8 Width 2ft   6005525.061919999 2114997.09858 37.7876910959164 -122.424687279516 (37.7876910959164, -122.424687279516)
149887 175169 2 70 728 Burrows St 1 1 1 1     8 Width 3ft   6009133.75655 2092888.51191 37.7271890729929 -122.41063996266001 (37.7271890729929, -122.41063996266)
152079 220653 2 70 580 Ogden Ave 3 1 1 1     8 Width 3ft   6008119.35429 2096079.0254799998 37.7358926083592 -122.41437240636002 (37.7358926083592, -122.41437240636)
155798 203493 2 70 227 Stillings Ave 1 9 1 1     8 Width 6ft   5999314.08769 2095746.28692 37.7344804146435 -122.444791684116 (37.7344804146435, -122.444791684116)
157854 203451 2 70 1515 16th Ave 4 17 1 1     8 Width 8ft   5991183.11857 2105012.94014 37.7594568739424 -122.473578579008 (37.7594568739424, -122.473578579008)
160138 125525 2 70 220 Lombard St 9 9 1 1     8 Width 9ft   6011203.66326 2120729.63027 37.8037503211682 -122.405444189817 (37.8037503211682, -122.405444189817)
170184 220663 2 70 1190 Sanchez St 1 1 1 1     8 Width 3ft   6003819.29636 2101374.54384 37.7501903863949 -122.42961696546999 (37.7501903863949, -122.42961696547)
184201 220660 2 70 2 Milton St 1 1 1 1     8 Width 3ft   6003703.338380001 2095523.5259999998 37.734118272040604 -122.429600714704 (37.7341182720406, -122.429600714704)
189070 203497 2 70 585 Mangels Ave 1 1 1 1     8 Width 3ft   5997548.43133 2095250.42463 37.733017974899504 -122.45086036952299 (37.7330179748995, -122.450860369523)
Powered by Datasette · Query took 3.839ms · Data source: data.sfgov.org