sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12092 77648 3 55 1300X Silliman St 9 1 1 4 4 01/01/2011 12:00:00 AM 3 3x3   6006817.147419999 2093142.9824700002 37.727757638780204 -122.418666516263 (37.7277576387802, -122.418666516263)
26614 98657 1 55 2110 Greenwich St 11 1 1 4 4   11 5x5   6002607.56666 2119218.5959900003 37.7991170337862 -122.43508328318701 (37.7991170337862, -122.435083283187)
31571 98656 1 55 2110 Greenwich St 10 1 1 4 4   8 5x5   6002629.88193 2119221.45898 37.799126161900396 -122.435006269744 (37.7991261619004, -122.435006269744)
33915 98646 1 55 2110 Greenwich St 3 1 1 4 4   8 5x5   6002771.23879 2119243.65965 37.799195144410795 -122.43451871576099 (37.7991951444108, -122.434518715761)
44207 98648 1 55 2110 Greenwich St 5 1 1 4 4   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245)
52422 34688 1 55 3101X Webster St 2 1 1 4 4 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533)
53064 98650 1 55 2110 Greenwich St 7 1 1 4 4   11 5x5   6002693.158 2119231.9709099997 37.799158617543604 -122.43478806542801 (37.7991586175436, -122.434788065428)
61243 34693 1 55 3101X Webster St 1 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.43438045581301 (37.799535058456, -122.434380455813)
69128 98649 1 55 2110 Greenwich St 6 1 1 4 4   16 5x5   6002707.76445 2119233.0203 37.799162328147794 -122.434737597267 (37.7991623281478, -122.434737597267)
73429 34690 1 55 3101X Webster St 4 1 1 4 4 07/28/1997 12:00:00 AM 8 3x3 Permit Number 38352 6002819.05677 2119313.26082 37.7993889653989 -122.434358228162 (37.7993889653989, -122.434358228162)
74427 67860 1 55 2110 Greenwich St 1 1 1 4 4 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.43439798360501 (37.7992088356751, -122.434397983605)
77610 109992 2 55 501X Shotwell St 9 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
85949 109996 2 55 501X Shotwell St 13 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
106116 109995 2 55 501X Shotwell St 12 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
122481 102195 2 55 3999X Folsom St 9 1 1 4 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
124316 109993 2 55 501X Shotwell St 10 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
131687 98655 1 55 2110 Greenwich St 9 1 1 4 4   6 5x5   6002650.75991 2119226.56813 37.799141375727295 -122.434934390513 (37.7991413757273, -122.434934390513)
133902 34692 1 55 3101X Webster St 6 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002825.2019 2119271.55666 37.7992748054477 -122.434333980647 (37.7992748054477, -122.434333980647)
142889 109994 2 55 501X Shotwell St 11 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
153048 98645 1 55 2110 Greenwich St 2 1 1 4 4   9 5x5   6002788.88101 2119245.38589 37.799200885676605 -122.434457791187 (37.7992008856766, -122.434457791187)
161870 98647 1 55 2110 Greenwich St 4 1 1 4 4   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619)
166994 34691 1 55 3101X Webster St 5 1 1 4 4 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.43435014504699 (37.7993346796145, -122.434350145047)
176592 34689 1 55 3101X Webster St 3 1 1 4 4 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.79943447017929 -122.434367321195 (37.7994344701793, -122.434367321195)
Powered by Datasette · Query took 2.45ms · Data source: data.sfgov.org