sf-trees

Data source: data.sfgov.org

Custom SQL query returning 32 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10086 88538 2 109 1306 York St   5 1 1   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367021999 (37.7511299031436, -122.40816367022)
29150 221508 2 109 1201 San Jose Ave 15 7 1 1     1     6004291.813569999 2095940.5809 37.73529671397821 -122.427595874056 (37.7352967139782, -122.427595874056)
30241 201711 2 109 724 Jamestown Ave 1 1 1 1     9 Width 4ft   6015357.64919 2088292.5533900002 37.714916457608204 -122.388803118478 (37.7149164576082, -122.388803118478)
33280 201714 2 109 726 Jamestown Ave 1 1 1 1     9 Width 4ft   6015317.96334 2088364.51894 37.715111861390795 -122.388945312084 (37.7151118613908, -122.388945312084)
39265 201713 2 109 724 Jamestown Ave 3 1 1 1     9 Width 4ft   6015343.41284 2088314.94317 37.7149771465452 -122.38885388790001 (37.7149771465452, -122.3888538879)
41267 221568 2 109 359 Diamond St 1 1 1 1     4 Width 3ft   6001813.22675 2103761.96483 37.7566318794794 -122.436724942504 (37.7566318794794, -122.436724942504)
44105 221562 2 109 100 San Jose Ave 5 1 1 1     1 Width 3ft   6006161.28805 2102498.9287799997 37.753410020459995 -122.421598049829 (37.75341002046, -122.421598049829)
45394 203292 2 109 10 Jules Ave 2 1 1 1     2 Width 2ft   5994458.02189 2089982.3581700001 37.7183757412389 -122.461162923744 (37.7183757412389, -122.461162923744)
46563 221509 2 109 1201 San Jose Ave 38 7 1 1     2     6004439.440880001 2096038.0117799998 37.735572586401894 -122.42709240931102 (37.7355725864019, -122.427092409311)
47711 187781 2 109 101 Pennsylvania Ave 4 7 1 1     3     6014331.70125 2106323.79299 37.7643695906061 -122.393610496623 (37.7643695906061, -122.393610496623)
51201 221569 2 109 616 Noe St 1 1 1 1     8 Width 3ft   6003001.08037 2104529.5167 37.7588068286936 -122.432671745707 (37.7588068286936, -122.432671745707)
54543 187786 2 109 1650 Galvez Ave 1 17 1 1     6     6015560.61147 2097934.79581 37.7414033822515 -122.388774319486 (37.7414033822515, -122.388774319486)
55253 203291 2 109 11 Jules Ave 3 1 1 1     4 Width 2ft   5994415.48252 2089998.39973 37.7184173393668 -122.461311125716 (37.7184173393668, -122.461311125716)
55535 221566 2 109 4286 23rd St 1 1 1 1     1 Width 3ft   6001342.8820400005 2102344.46852 37.7527130350975 -122.43825001643299 (37.7527130350975, -122.438250016433)
59268 187787 2 109 1650 Galvez Ave 2 17 1 1     7     6015518.873319999 2097965.1979799997 37.7414845469671 -122.388920758811 (37.7414845469671, -122.388920758811)
59935 203290 2 109 11 Jules Ave 2 1 1 1     5 Width 2ft   5994415.40381 2090011.1413599998 37.7184523203103 -122.46131232093201 (37.7184523203103, -122.461312320932)
67739 187784 2 109 101 Pennsylvania Ave 35 7 1 1     4     6014258.31464 2106694.98019 37.765384711161104 -122.393890307196 (37.7653847111611, -122.393890307196)
71884 221560 2 109 100 San Jose Ave 3 1 1 1     1 Width 3ft   6006161.42459 2102519.64651 37.7534669142699 -122.42159904898001 (37.7534669142699, -122.42159904898)
76798 187783 2 109 101 Pennsylvania Ave 26 7 1 1     4     6014314.48936 2106550.7653 37.764991850418895 -122.393685915597 (37.7649918504189, -122.393685915597)
86391 184203 2 109 1466 41st Ave 1 1 1 1     1 Width 0ft   5983430.71 2105161.519 37.75941282066329 -122.500400782356 (37.7594128206633, -122.500400782356)
116885 96193 2 109 1640 Jerrold Ave 1 1 1 1     4 4x50   6015077.4 2097255.4 37.7395111076977 -122.39039765239299 (37.7395111076977, -122.390397652393)
136012 187785 2 109 1740 20th St 2 9 1 1     1 Width 3ft   6012766.00153 2104746.33455 37.7599511143744 -122.39891512883499 (37.7599511143744, -122.398915128835)
148793 221561 2 109 100 San Jose Ave 4 1 1 1     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977)
155244 221567 2 109 324 Hill St 1 1 1 1     4 Width 3ft   6004154.58593 2103373.98314 37.7556993571514 -122.428600021096 (37.7556993571514, -122.428600021096)
155379 221559 2 109 1306 York St 4 4 1 1     7 Width 3ft   6010039.89073 2101557.1439900002 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954)
158034 221565 2 109 4286 23rd St 2 1 1 1     1 Width 3ft   6001328.916669999 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381)
161335 201715 2 109 726 Jamestown Ave 2 1 1 1     8 Width 4ft   6015296.606380001 2088393.85947 37.715191240972 -122.38902117888901 (37.715191240972, -122.389021178889)
179218 201712 2 109 724 Jamestown Ave 2 1 1 1     6 Width 4ft   6015351.33364 2088303.0821 37.7149450173645 -122.388825682463 (37.7149450173645, -122.388825682463)
179284 221563 2 109 4286 23rd St 4 1 1 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
179875 221564 2 109 4286 23rd St 3 1 1 1     1 Width 3ft   6001316.917769999 2102341.7359599997 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582)
181350 187782 2 109 101 Pennsylvania Ave 14 7 1 1     1     6014325.58247 2106437.08289 37.764680319857995 -122.39363958970199 (37.764680319858, -122.393639589702)
184620 221570 2 109 117 Alpine Ter 1 1 1 1     1 Width 3ft   6001705.56397 2108155.3423 37.768688901296294 -122.437411868978 (37.7686889012963, -122.437411868978)
Powered by Datasette · Query took 63.824ms · Data source: data.sfgov.org