sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1996 252848 7 164 99 Reposa Way 1 13 1 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
17180 2349 1 164 2406 Bryant St 1 1 1 1   03/15/2016 12:00:00 AM 12 3x3   6009666.3501699995 2103307.94884 37.7558284260662 -122.409533847831 (37.7558284260662, -122.409533847831)
20534 16379 3 164 1050 Moraga St 1 11 1 2     24 12   5990995.6052 2103835.85647 37.7562140526474 -122.47414119938401 (37.7562140526474, -122.474141199384)
25680 247142 2 164 500 27th St 12 7 1 1     17     6003177.22177 2100100.19766 37.7466549535644 -122.43174632176 (37.7466549535644, -122.43174632176)
41339 234481 2 164 1201 San Jose Ave 71 7 1 1     13     6004557.918269999 2096148.5785299998 37.73588287679821 -122.42669065877199 (37.7358828767982, -122.426690658772)
42739 211043 3 164 401x Ortega St 1 11 1 2     3 Width 2ft   5992723.26269 2102584.7826900003 37.752878858386396 -122.46807542056601 (37.7528788583864, -122.468075420566)
45535 211042 3 164 1050x Moraga St 2 3 1 2     12 Width 10ft   5990982.70719 2103833.6403200002 37.756207220509204 -122.47418564296001 (37.7562072205092, -122.47418564296)
48027 194435 2 164 800 Vermont St 41 2 1 1     60     6011302.64565 2104147.13964 37.7582242092014 -122.40393402935301 (37.7582242092014, -122.403934029353)
59519 234482 2 164 25 Bradford St 1 1 1 1     16 Width 4ft   6009639.158969999 2098562.4259900004 37.7427967468751 -122.40929301297301 (37.7427967468751, -122.409293012973)
68987 194433 3 164 900x Carolina St 25 3 1 2     8     6012468.7970199995 2103466.34183 37.756419970421206 -122.39985313972001 (37.7564199704212, -122.39985313972)
76078 234480 2 164 2827 Cesar Chavez St 9 7 1 1     18     6010697.222490001 2100672.7702 37.7486505159232 -122.40578312810699 (37.7486505159232, -122.405783128107)
94229 116554 2 164 424x LOS PALMOS DR 1 16 1 1     16 3x3   5997290.0 2095790.0 37.734484721942295 -122.451792740897 (37.7344847219423, -122.451792740897)
95382 99489 2 164 800X Miramar Ave 6 11 1 1     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
98668 108560 6 164 3790 21st St 1 1 1 1           6003155.9 2103640.4 37.7563743055091 -122.432072816055 (37.7563743055091, -122.432072816055)
100244 114271 2 164 49x ESMERALDA AVE 1 20 1 1     27 3x3   6006783.0 2099038.0 37.7439421324692 -122.41920255172501 (37.7439421324692, -122.419202551725)
114812 100474 6 164 930 Monterey Blvd 2 7 1 1           5995794.4 2094643.4 37.7312506649165 -122.45688058924699 (37.7312506649165, -122.456880589247)
116190 117545 2 164 3340x HARRISON ST 1 14 1 1     20 3x3   6008964.0 2099209.0 37.7445342470575 -122.411673205451 (37.7445342470575, -122.411673205451)
124928 104968 5 164 495 COLLINGWOOD ST 1 7 1 1     15   Permit Number 770776 6002186.6 2103026.0 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855)
132241 194436 2 164 653 Kansas St 1 9 1 1     13 Width 3ft   6011568.57052 2105306.76486 37.7614231354979 -122.403095907076 (37.7614231354979, -122.403095907076)
139448 99461 2 164 550X Miramar Ave 8 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
143721 100473 6 164 930 Monterey Blvd 1 7 1 1           5995794.4 2094643.4 37.7312506649165 -122.45688058924699 (37.7312506649165, -122.456880589247)
146760 186517 2 164 1400 Lower Great Hwy 3 19 1 1     9 Width 0ft   5980906.8218 2104997.2844 37.7588134060814 -122.509117272676 (37.7588134060814, -122.509117272676)
150385 194434 2 164 2225 25th St 2 9 1 1     1     6012067.76833 2101856.84412 37.7519782763933 -122.40112695564699 (37.7519782763933, -122.401126955647)
152731 234483 2 164 671 Church St 6 7 1 1     21 Width 3ft   6004312.0765 2104900.49102 37.759899698321796 -122.428164152046 (37.7598996983218, -122.428164152046)
182679 234479 2 164 73 Elgin Park 1 10 1 1     4 Width 3ft   6005835.003269999 2108667.27292 37.770328438229704 -122.42316483429701 (37.7703284382297, -122.423164834297)
185147 246639 2 164 3320 Harrison St 10 7 1 1     13     6009035.16234 2099239.17175 37.744621083714 -122.41142927065201 (37.744621083714, -122.411429270652)
Powered by Datasette · Query took 1.406ms · Data source: data.sfgov.org