sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
26902 175812 2 58 15 Athens St 2 9 1 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
36204 222700 2 58 551 Eureka St 1 1 1 1     2 Width 3ft   6001566.9280900005 2102610.03358 37.7534549532875 -122.437494242369 (37.7534549532875, -122.437494242369)
44360 222680 2 58 76 Tiffany Ave 1 1 1 1     2 Width 6ft   6006248.111740001 2099605.96855 37.7454715078156 -122.421092396098 (37.7454715078156, -122.421092396098)
68446 188417 2 58 274 Topeka Ave 1 9 1 1     2 Width 3ft   6013295.80448 2094667.84679 37.7323072334974 -122.396376359792 (37.7323072334974, -122.396376359792)
75225 204717 3 58 1485x Northwood Dr 5 3 1 2     2     5995876.20042 2094034.0159599998 37.7295821401899 -122.456553740875 (37.7295821401899, -122.456553740875)
81516 50910 1 58 2450 17th Ave 2 1 1 1 1 04/26/2004 12:00:00 AM 2 3x9 Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.47339717645399 (37.742199437798, -122.473397176454)
84993 117424 2 58 600x POWHATTAN AVE 1 1 1 1     2 3x3   6008524.0 2098073.0 37.7413903494898 -122.41311433102699 (37.7413903494898, -122.413114331027)
91704 188404 3 58 1300x De Haro St 10 3 1 2     2     6012258.41015 2102196.39231 37.7529212353325 -122.40049153337401 (37.7529212353325, -122.400491533374)
128258 204719 2 58 110 Dorantes Ave 1 2 1 1     2 Width 4ft   5993903.71897 2099982.29966 37.7458012037543 -122.46380433331001 (37.7458012037543, -122.46380433331)
129739 204728 2 58 400 Junipero Serra Blvd 13 4 1 1     2 Width 0ft   5991366.51565 2094145.3724 37.729627950748295 -122.47215214722401 (37.7296279507483, -122.472152147224)
133308 222682 2 58 2 Trainor St 12 1 1 1     2 Width 3ft   6008292.2753800005 2108046.95875 37.768763565716704 -122.41462120290501 (37.7687635657167, -122.414621202905)
135290 222704 2 58 69 Mirabel Ave 1 1 1 1     2 Width 3ft   6007772.24851 2100018.26139 37.746689373329296 -122.415851346858 (37.7466893733293, -122.415851346858)
146575 222710 2 58 201 Randall St 1 9 1 1     2 Width 3ft   6004263.21249 2097476.0489 37.7395111430209 -122.427804130079 (37.7395111430209, -122.427804130079)
156342 222693 2 58 440 29th St 1 1 1 1     2 Width 2ft   6003701.6023699995 2098966.92625 37.74357296341329 -122.42985224701 (37.7435729634133, -122.42985224701)
167905 94813 1 58 2948 Fillmore St 1 1 1 1   11/09/2010 12:00:00 AM 2 3x3 Permit Number 53896 6002515.07841 2118365.04564 37.7967681547718 -122.43534223486799 (37.7967681547718, -122.435342234868)
175877 222699 2 58 2102 Castro St 1 10 1 1     2 Width 5ft   6002635.97774 2099387.5471900003 37.744667486907204 -122.43356696417 (37.7446674869072, -122.43356696417)
175957 204740 2 58 317 Mangels Ave 1 9 1 1     2 Width 6ft   5999296.31857 2095221.44608 37.7330383112512 -122.44481540373 (37.7330383112512, -122.44481540373)
176434 124049 2 58 651 11th Ave 2 9 1 1     2 Width 3ft   5992517.64773 2111006.08275 37.775989642541795 -122.469399404795 (37.7759896425418, -122.469399404795)
Powered by Datasette · Query took 4.245ms · Data source: data.sfgov.org