sf-trees

Data source: data.sfgov.org

Custom SQL query returning 45 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22606 7130 1 70 399X Fern St 5 1 1 1   02/02/1990 12:00:00 AM 5 3X3   6005539.58789 2114975.93468 37.7876338054953 -122.42463551632 (37.7876338054953, -122.42463551632)
23721 220632 2 70 18 Kronquist Ct 1 9 1 1     5 Width 1ft   6002213.33941 2100174.25358 37.746803608795396 -122.43508461868299 (37.7468036087954, -122.435084618683)
27524 189155 2 70 2 Shipley St 3 4 1 1     5 Width 3ft   6012260.87565 2112478.52323 37.7811537953404 -122.40120547186899 (37.7811537953404, -122.401205471869)
30036 92979 1 70 147 Mason St 2 1 1 1   01/04/2010 12:00:00 AM 5   Permit Number 53131 6009891.19153 2113906.4761 37.78494212831 -122.40950424575001 (37.78494212831, -122.40950424575)
35258 120266 2 70 100 24th Ave 2 17 1 1     5     5988365.77159 2115120.59325 37.78704611790379 -122.48406345051399 (37.7870461179038, -122.484063450514)
36849 220592 2 70 1383 Natoma St 1 1 1 1     5 Width 2ft   6007189.08287 2107465.79435 37.76710578333971 -122.418395859874 (37.7671057833397, -122.418395859874)
43148 32487 1 70 257 States St 1 1 1 1 1 10/10/1996 12:00:00 AM 5   Permit Number 36994 6000562.081590001 2106647.6707099997 37.7644841354656 -122.441258885382 (37.7644841354656, -122.441258885382)
47594 220635 2 70 628 Chenery St 2 1 1 1     5 Width 2ft   6002826.10631 2095715.4099400002 37.7345954316319 -122.432647280541 (37.7345954316319, -122.432647280541)
49324 175168 2 70 218 Congdon St 5 1 1 1     5 Width 3ft   6004674.59943 2093952.62434 37.7298598742113 -122.426130962075 (37.7298598742113, -122.426130962075)
49765 94178 1 70 1379 Kansas St 1 1 1 1   06/22/2010 12:00:00 AM 5 3x3 Permit Number 53590 6011748.15969 2101956.8719099998 37.752235095787704 -122.402239247057 (37.7522350957877, -122.402239247057)
54839 125453 2 70 2401 Broadway 12 9 1 1     5 Width 4ft   6002078.25785 2117342.70193 37.793936248105 -122.43678051073299 (37.793936248105, -122.436780510733)
63274 203472 2 70 126 Howth St 1 4 1 1     5 Width 3ft   5997592.47815 2091138.0222 37.721728810427706 -122.450411736413 (37.7217288104277, -122.450411736413)
64478 125452 2 70 2401 Broadway 9 9 1 1     5 Width 4ft   6002068.61749 2117342.59163 37.7939353973611 -122.436813859368 (37.7939353973611, -122.436813859368)
65850 92445 1 70 2646 45th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 5 3x3 Permit Number 52836 5982487.2 2097095.3 37.737209800771296 -122.503066669454 (37.7372098007713, -122.503066669454)
67177 249537 2 70 201 Myrtle St 6 4 1 1     5 Width 3ft   6006345.87488 2114047.3209700002 37.7851295641198 -122.421779931396 (37.7851295641198, -122.421779931396)
69728 125437 2 70 1921 Jefferson St 3 1 1 1     5 Width 4ft   6000052.89269 2121248.37983 37.8045448847905 -122.44406922002199 (37.8045448847905, -122.444069220022)
71919 125496 2 70 1207 Chestnut St 8 9 1 1     5 Width 3ft   6006063.84143 2120339.6871599997 37.802390914060204 -122.42320311664899 (37.8023909140602, -122.423203116649)
126893 203457 2 70 89 Manor Dr 2 1 1 1     5 Width 2ft   5993628.67358 2093513.96157 37.7280249047113 -122.464285869009 (37.7280249047113, -122.464285869009)
130236 189156 2 70 2 Shipley St 4 4 1 1     5 Width 3ft   6012246.95244 2112466.10025 37.7811189079475 -122.401252766302 (37.7811189079475, -122.401252766302)
131618 125455 2 70 2401 Broadway 17 9 1 1     5 Width 4ft   6002099.50591 2117347.8348 37.7939515491883 -122.436707358076 (37.7939515491883, -122.436707358076)
131931 125538 2 70 11 Miller Pl 10 1 1 1     5 Width 2ft   6010079.834919999 2116873.2549900003 37.793098758955395 -122.409061006782 (37.7930987589554, -122.409061006782)
132705 125527 2 70 29 Miller Pl 2 1 1 1     5 Width 3ft   6010066.41664 2116970.44466 37.7933648665474 -122.409114296086 (37.7933648665474, -122.409114296086)
137746 118929 2 70 875 La Playa 5 9 1 1     5 Width 4ft   5980750.23602 2109645.2788 37.7715662158284 -122.510004109936 (37.7715662158284, -122.510004109936)
146408 220630 2 70 901 Elizabeth St 1 9 1 1     5 Width 4ft   6000579.189809999 2101957.47614 37.7516069822848 -122.44086323496 (37.7516069822848, -122.44086323496)
147992 189169 2 70 2098 20th St 5 9 1 1     5 Width 7ft   6011892.76134 2104699.04319 37.75977256567371 -122.40193193701401 (37.7597725656737, -122.401931937014)
148879 249535 2 70 201 Myrtle St 4 4 1 1     5 Width 3ft   6006279.61488 2114039.5342599996 37.7851044469537 -122.422008617322 (37.7851044469537, -122.422008617322)
150229 125458 2 70 2371 Broadway 2 9 1 1     5 Width 4ft   6002284.26434 2117368.32549 37.794018309436396 -122.436069543591 (37.7940183094364, -122.436069543591)
150526 125502 2 70 1001 Lombard St 1 9 1 1     5 Width 7ft   6007468.42884 2120195.8771599997 37.8020752142594 -122.41833233898701 (37.8020752142594, -122.418332338987)
151194 220621 2 70 714 Duncan St 2 9 1 1     5 Width 4ft   6001868.87894 2099747.43156 37.745612090735506 -122.43624518748999 (37.7456120907355, -122.43624518749)
152269 220631 2 70 901 Elizabeth St 3 1 1 1     5 Width 4ft   6000591.194080001 2101959.06133 37.751612018500204 -122.440821836477 (37.7516120185002, -122.440821836477)
154406 221753 2 70 466 Alvarado St 1 1 1 1     5 Width 3ft   6003367.55908 2102748.60922 37.7539376572014 -122.431277170628 (37.7539376572014, -122.431277170628)
154701 220611 2 70 1 Bradford St 1 1 1 1     5 Width 4ft   6009641.7814 2098664.7156700003 37.743077758937105 -122.40929116218399 (37.7430777589371, -122.409291162184)
157035 125454 2 70 2401 Broadway 16 9 1 1     5 Width 4ft   6002093.86703 2117345.7842200003 37.7939455983674 -122.43672672227 (37.7939455983674, -122.43672672227)
159347 220623 2 70 58 Fountain St 2 10 1 1     5 Width 3ft   6000335.70641 2101336.8621 37.7498890559574 -122.44166069529699 (37.7498890559574, -122.441660695297)
161535 95678 1 70 307 Holyoke St 1 1 1 1 1 03/08/2011 12:00:00 AM 5 3x3 Permit Number 767430 6009637.5069 2092959.36639 37.7274118548521 -122.40890349142799 (37.7274118548521, -122.408903491428)
162716 125448 2 70 3057 Franklin St 2 4 1 1     5 Width 2ft   6005070.86935 2120497.70862 37.8027687129688 -122.426650549882 (37.8027687129688, -122.426650549882)
168173 125468 2 70 1177 California St 4 10 1 1     5 Width 4ft   6008726.14199 2116272.16952 37.7913723996763 -122.413702344902 (37.7913723996763, -122.413702344902)
170476 37652 1 70 1707 Balboa St 3 1 1 1 1 06/26/1998 12:00:00 AM 5   Permit Number 40063 5990267.40387 2111259.21957 37.7765543890648 -122.477202007865 (37.7765543890648, -122.477202007865)
173529 125459 2 70 2371 Broadway 3 9 1 1     5 Width 4ft   6002302.24315 2117372.6414900003 37.7940311814406 -122.436007644151 (37.7940311814406, -122.436007644151)
177222 125447 2 70 3057 Franklin St 1 4 1 1     5 Width 2ft   6005068.7625400005 2120514.19483 37.8028138607435 -122.426659015206 (37.8028138607435, -122.426659015206)
178837 92978 1 70 147 Mason St 1 1 1 1   01/04/2010 12:00:00 AM 5   Permit Number 53131 6009889.177999999 2113928.0150200003 37.7850011562254 -122.409512732628 (37.7850011562254, -122.409512732628)
180383 220627 2 70 665 Elizabeth St 11 9 1 1     5 Width 3ft   6002180.12335 2102046.5010900004 37.7519424707911 -122.43533337833401 (37.7519424707911, -122.435333378334)
183859 220608 2 70 385 Nevada St 2 10 1 1     5 Width 2ft   6008946.36134 2096525.7454799998 37.7371656274845 -122.41154465636801 (37.7371656274845, -122.411544656368)
184444 66783 1 70 1207 Chestnut St 1 1 1 1 1 09/20/1991 12:00:00 AM 5   Permit Number 30054 6005979.755609999 2120327.60903 37.80235300495529 -122.42349323614799 (37.8023530049553, -122.423493236148)
188993 221754 2 70 3879 23rd St 1 1 1 1     5 Width 3ft   6003935.10667 2102444.58543 37.753135026677604 -122.42929277965099 (37.7531350266776, -122.429292779651)
Powered by Datasette · Query took 7.234ms · Data source: data.sfgov.org