sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25734 237874 2 72 160 Coso Ave 1 2 1 1     5     6007471.906690001 2099585.1841700003 37.74548335098721 -122.41685922338301 (37.7454833509872, -122.416859223383)
29426 117740 2 72 475 39th Ave 2 2 1 1     3 Width 4ft   5983746.49746 2112674.00016 37.7800584750229 -122.499863945897 (37.7800584750229, -122.499863945897)
33471 182339 2 72 3081 Kirkham St 1 2 1 1     1 Width 0ft   5985312.4034 2104975.8588 37.759013323653 -122.493879375972 (37.759013323653, -122.493879375972)
36470 237886 2 72 286 Upper Ter 1 2 1 1     9 Width 4ft   5999373.81016 2106048.64713 37.7627716059584 -122.445325703321 (37.7627716059584, -122.445325703321)
46324 135861 2 72 5 Dicha Aly 2 2 1 1     1 Width 2ft   5998316.32407 2113776.61007 37.783930185978704 -122.44954003254999 (37.7839301859787, -122.44954003255)
46702 214354 2 72 8 Edgehill Way 1 2 1 1     7 Width 3ft   5994911.61844 2099129.8957599998 37.7435187450863 -122.460257437746 (37.7435187450863, -122.460257437746)
55084 214318 2 72 16 Belmont Ave 1 2 1 1     9     5996661.1210199995 2106238.0269400002 37.763136371875895 -122.454721566453 (37.7631363718759, -122.454721566453)
57881 214317 2 72 20 Belmont Ave 10 2 1 1     21     5996726.67758 2106195.56131 37.763023532129004 -122.454491761784 (37.763023532129, -122.454491761784)
62511 202088 2 72 1 Gould St 16 2 1 1     7     6012849.75876 2091137.38485 37.722588475066 -122.397670917693 (37.722588475066, -122.397670917693)
65313 183563 2 72 2593 30th Ave 2 2 1 1     5 Width 0ft   5987056.9644 2097643.917 37.738983699378096 -122.487307395263 (37.7389836993781, -122.487307395263)
71198 214353 2 72 50 Garcia Ave 5 2 1 1     4 Width 3ft   5995149.72336 2099349.67966 37.74413591023829 -122.45945004977399 (37.7441359102383, -122.459450049774)
75667 123051 2 72 544 Funston Ave 2 2 1 1     1 Width 4ft   5991925.368290001 2111718.74321 37.777912168825004 -122.47150017707199 (37.777912168825, -122.471500177072)
128545 183562 2 72 2591 30th Ave 1 2 1 1     5 Width 0ft   5987056.0774 2097655.4477 37.7390153079093 -122.487311308785 (37.7390153079093, -122.487311308785)
130582 214327 2 72 100 Vista Verde Ct 9 2 1 1     10 Width 10ft   5999204.10164 2096073.9362400002 37.7353737849692 -122.44519548960501 (37.7353737849692, -122.445195489605)
131846 214348 2 72 101 Montalvo Ave 1 2 1 1     16 Width 3ft   5993734.17627 2099649.69883 37.7448781944898 -122.464366439256 (37.7448781944898, -122.464366439256)
147966 183564 2 72 2595 30th Ave 3 2 1 1     6 Width 0ft   5987057.6296 2097628.3948 37.738941118307295 -122.487303955513 (37.7389411183073, -122.487303955513)
154466 214328 2 72 100 Vista Verde Ct 10 2 1 1     7 Width 10ft   5999189.95231 2096066.10598 37.735351477276296 -122.44524384613001 (37.7353514772763, -122.44524384613)
164027 237931 2 72 18 Temple St 2 2 1 1     6 Width 3ft   5999994.62286 2105880.85812 37.7623463174434 -122.443166486857 (37.7623463174434, -122.443166486857)
171405 183467 2 72 2534 26th Ave 1 2 1 1     2 Width 0ft   5988330.845 2098043.4689 37.740154968776395 -122.482932230746 (37.7401549687764, -122.482932230746)
175815 237928 2 72 310 Liberty St 19 2 1 1     9 Width 3ft   6004144.43295 2103938.76991 37.75724955362679 -122.428675392374 (37.7572495536268, -122.428675392374)
186227 214352 2 72 50 Garcia Ave 4 2 1 1     3 Width 3ft   5995162.00455 2099364.3275 37.744176835692 -122.459408645009 (37.744176835692, -122.459408645009)
Powered by Datasette · Query took 19.404ms · Data source: data.sfgov.org