sf-trees

Data source: data.sfgov.org

Custom SQL query returning 29 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2939 203654 2 58 42 Mangels Ave 5 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001070.39767 2095226.13763 37.7331522778487 -122.438682294452 (37.7331522778487, -122.438682294452)
3005 208852 2 58 42 Mangels Ave 3 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001113.97001 2095223.0116299998 37.733146173254205 -122.43853142959101 (37.7331461732542, -122.438531429591)
24848 188408 2 58 2033 22nd St 2 9 1 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
26902 175812 2 58 15 Athens St 2 9 1 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
36636 188403 2 58 700 De Haro St 1 9 1 1     13     6012073.44818 2105095.84941 37.7608721901295 -122.401334912194 (37.7608721901295, -122.401334912194)
39239 175813 2 58 15 Athens St 3 9 1 1     1     6005348.05368 2093155.48995 37.727709159929105 -122.42374609402201 (37.7277091599291, -122.423746094022)
42508 204742 2 58 933 Teresita Blvd 1 9 1 1     3 Width 7ft   5998605.5734 2095661.21413 37.734206366028296 -122.44723512141701 (37.7342063660283, -122.447235121417)
51309 222685 2 58 145 Coso Ave 2 9 1 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
52153 125934 2 58 1715 Taylor St 3 9 1 1     7 Width 4ft   6008711.31794 2118818.3670900003 37.7983627993626 -122.41393383309799 (37.7983627993626, -122.413933833098)
53963 205923 2 58 266 Judson Ave 3 9 1 1     6     5998304.035759999 2093569.7761099997 37.7284465374612 -122.448127087008 (37.7284465374612, -122.448127087008)
54390 247973 2 58 155 Faith St 1 9 1 1     8 Width 6ft   6010331.53551 2099090.76742 37.7442862247418 -122.406936189376 (37.7442862247418, -122.406936189376)
59138 222697 2 58 690 28th St 1 9 1 1     8 Width 6ft   6001460.97341 2099432.54018 37.744724288990895 -122.43763311299101 (37.7447242889909, -122.437633112991)
61378 204745 2 58 370 Monterey Blvd 11 9 1 1     4 Width 8ft   5999685.08818 2094723.93815 37.731694449820296 -122.44343560538799 (37.7316944498203, -122.443435605388)
63986 188409 2 58 2033 22nd St 3 9 1 1     3 Width 3ft   6011983.90541 2103708.46876 37.757057753421 -122.40154709194799 (37.757057753421, -122.401547091948)
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)
72995 217762 2 58 470 West Portal Ave 1 9 1 1     5     5991703.40817 2096440.7638 37.735950009376204 -122.471154649778 (37.7359500093762, -122.471154649778)
75485 175814 2 58 11 Athens St 3 9 1 1     3     6005376.332880001 2093192.89602 37.727813465104 -122.423650990705 (37.727813465104, -122.423650990705)
116006 106924 2 58 196 States St 2 9 1 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
136139 222692 2 58 501 York St 5 9 1 1     5 Width 2ft   6009835.7153900005 2105907.76012 37.7629764094606 -122.409131567579 (37.7629764094606, -122.409131567579)
136522 204722 2 58 422 Bright St 1 9 1 1     6     5993793.315830001 2090006.70292 37.7184043108851 -122.46346228245501 (37.7184043108851, -122.463462282455)
136961 205922 2 58 370 Monterey Blvd 19 9 1 1     4 Width 8ft   5999640.50046 2094726.6696 37.7316994068856 -122.443589949734 (37.7316994068856, -122.443589949734)
144682 106923 2 58 196 States St 1 9 1 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
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)
149164 175811 2 58 15 Athens St 1 9 1 1     1     6005336.45581 2093162.3032099998 37.727727212929004 -122.423786672331 (37.727727212929, -122.423786672331)
166040 175807 2 58 156 San Juan Ave 2 9 1 1     3 Width 10ft   6001266.11551 2092303.88748 37.725139581023605 -122.437796421768 (37.7251395810236, -122.437796421768)
169588 204739 2 58 463 Mangels Ave 2 9 1 1     3 Width 10ft   5998365.55897 2095230.78545 37.7330107938072 -122.44803394331899 (37.7330107938072, -122.448033943319)
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)
185050 204744 2 58 545 Melrose Ave 2 9 1 1     1 Width 6ft   5996927.5801099995 2095415.2897 37.733435093958896 -122.453018700168 (37.7334350939589, -122.453018700168)
Powered by Datasette · Query took 41.705ms · Data source: data.sfgov.org