sf-trees

Data source: data.sfgov.org

Custom SQL query returning 53 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22588 7129 1 70 399X Fern St 4 1 1 1   02/02/1990 12:00:00 AM 4 3X3   6005508.68317 2114972.6560299997 37.787623057713496 -122.424742207381 (37.7876230577135, -122.424742207381)
24395 92752 1 70 3356 Baker St 1 1 1 1   10/07/2009 12:00:00 AM 4 3x3 Permit Number 52980 5999300.27951 2120375.08626 37.8021040941904 -122.446610827352 (37.8021040941904, -122.446610827352)
27386 220596 2 70 452 Shotwell St 1 4 1 1     4 Width 3ft   6007814.59662 2105186.38117 37.7608822364448 -122.416070852512 (37.7608822364448, -122.416070852512)
28260 92446 1 70 1554 46th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 4 3x3 Permit Number 52837 5981923.4 2104509.6 37.7575342433798 -122.505565385243 (37.7575342433798, -122.505565385243)
30833 220633 2 70 18 Kronquist Ct 2 9 1 1     4 Width 1ft   6002213.10405 2100169.21088 37.7467897493647 -122.435085071929 (37.7467897493647, -122.435085071929)
31567 203453 2 70 2658 16th Ave 1 1 1 1     4 Width 3ft   5991457.8354 2097316.5348 37.738340446961104 -122.47206749851001 (37.7383404469611, -122.47206749851)
31793 221773 2 70 5587 Diamond Heights Blvd 3 9 1 1     4 Width 2ft   6001626.70915 2097120.97663 37.7383866990834 -122.436894581628 (37.7383866990834, -122.436894581628)
33494 175166 2 70 218 Congdon St 2 1 1 1     4 Width 3ft   6004672.7463 2094000.25869 37.7299905627997 -122.426140758388 (37.7299905627997, -122.426140758388)
33859 220622 2 70 58 Fountain St 1 10 1 1     4 Width 3ft   6000334.98133 2101342.05017 37.7499032598351 -122.441663574927 (37.7499032598351, -122.441663574927)
36512 175167 2 70 218 Congdon St 3 1 1 1     4 Width 3ft   6004673.57343 2093985.3797 37.7299497551534 -122.426136840057 (37.7299497551534, -122.426136840057)
36697 220597 2 70 452 Shotwell St 3 4 1 1     4 Width 3ft   6007815.2262 2105168.52935 37.7608332548635 -122.416067410784 (37.7608332548635, -122.416067410784)
37156 189173 2 70 1960 Quesada Ave 1 4 1 1     4 Width 2ft   6013345.84088 2096070.7044 37.73616197508429 -122.396301660307 (37.7361619750843, -122.396301660307)
40963 125473 2 70 655 Powell St 6 9 1 1     4 Width 2ft   6010077.67437 2116003.04391 37.7907092485717 -122.409007053757 (37.7907092485717, -122.409007053757)
41684 203490 2 70 29 Joost Ave 1 1 1 1     4 Width 3ft   6001874.24208 2094906.2061700001 37.7323195164307 -122.43588030914302 (37.7323195164307, -122.435880309143)
43603 249538 2 70 201 Myrtle St 7 4 1 1     4 Width 3ft   6006360.10871 2114050.0114700003 37.785137754239294 -122.421730877876 (37.7851377542393, -122.421730877876)
43939 203498 2 70 234 Flood Ave 1 1 1 1     4 Width 3ft   5999190.87551 2094097.9228400001 37.72994736206179 -122.445099202768 (37.7299473620618, -122.445099202768)
45739 249986 2 70 228 Filbert St 2 7 1 1     4 Width 0ft   6011589.33259 2120106.08083 37.802059763014 -122.404065643309 (37.802059763014, -122.404065643309)
48362 125504 2 70 1001 Lombard St 3 9 1 1     4 Width 7ft   6007489.69173 2120199.0729400003 37.8020851859507 -122.418258985774 (37.8020851859507, -122.418258985774)
48661 125469 2 70 1177 California St 5 10 1 1     4 Width 4ft   6008779.73096 2116281.55689 37.791401184258795 -122.413517591782 (37.7914011842588, -122.413517591782)
50982 220615 2 70 3117 20th St 1 1 1 1     4 Width 3ft   6009011.326230001 2104478.69915 37.75900631630999 -122.411881867955 (37.75900631631, -122.411881867955)
52304 220625 2 70 665 Elizabeth St 4 9 1 1     4 Width 3ft   6002079.843669999 2102040.673 37.751920772823794 -122.43567974235 (37.7519207728238, -122.43567974235)
52909 175174 2 70 399 Vienna St 7 9 1 1     4 Width 3ft   6003793.29108 2091173.5648599998 37.722179343787396 -122.428979687879 (37.7221793437874, -122.428979687879)
55787 189171 2 70 672 Missouri St 2 4 1 1     4 Width 1ft   6013547.271380001 2103937.2716200002 37.7577731065529 -122.396156373043 (37.7577731065529, -122.396156373043)
57215 175165 2 70 218 Congdon St 1 1 1 1     4 Width 3ft   6004671.92277 2094015.32561 37.730031886663 -122.42614467765 (37.730031886663, -122.42614467765)
64600 203500 2 70 77 Staples Ave 2 9 1 1     4 Width 3ft   5999471.94159 2093749.5809 37.729006934723 -122.444102506626 (37.729006934723, -122.444102506626)
70954 125443 2 70 2298 Beach St 8 9 1 1     4 Width 5ft   5999265.80635 2120844.85189 37.8033919746241 -122.446763941418 (37.8033919746241, -122.446763941418)
71361 203465 2 70 480 Hearst Ave 7 9 1 1     4 Width 2ft   5998202.03163 2094421.3515299999 37.7307789309899 -122.448541023359 (37.7307789309899, -122.448541023359)
75445 220658 2 70 172 Precita Ave 1 1 1 1     4 Width 3ft   6007553.6507 2100235.86656 37.7472745765577 -122.416622650424 (37.7472745765577, -122.416622650424)
75833 41617 1 70 2285 Jerrold Ave 11 1 1 1 1 02/16/2002 12:00:00 AM 4   Permit Number 44542 6011837.54866 2099572.35682 37.7456927230357 -122.40176253082501 (37.7456927230357, -122.401762530825)
76457 125449 2 70 3101 Clay St 4 1 1 1     4 Width 4ft   5999876.27718 2115725.0378099997 37.789369177790206 -122.444283251471 (37.7893691777902, -122.444283251471)
131923 125440 2 70 3517 Divisadero St 1 4 1 1     4 Width 2ft   6000220.82214 2120372.11662 37.8021484793247 -122.44342510578801 (37.8021484793247, -122.443425105788)
132173 203487 2 70 828 Foerster St 1 9 1 1     4 Width 3ft   5998282.181969999 2096469.8668799999 37.736408249925 -122.44841139867201 (37.736408249925, -122.448411398672)
137147 220593 2 70 1 14th St 1 1 1 1     4 Width 3ft   6008525.9203 2107974.98193 37.768579058113104 -122.413807947778 (37.7685790581131, -122.413807947778)
137268 203489 2 70 296 Cresta Vista Dr 1 1 1 1     4 Width 3ft   5996836.5401099995 2096166.78672 37.7354933057555 -122.45338768751101 (37.7354933057555, -122.453387687511)
148997 125441 2 70 3517 Divisadero St 2 4 1 1     4 Width 2ft   6000221.62171 2120363.5906700003 37.8021251149445 -122.443421726125 (37.8021251149445, -122.443421726125)
149835 125493 2 70 1207 Chestnut St 4 9 1 1     4 Width 3ft   6006021.473809999 2120333.6545700002 37.8023719590496 -122.42334930055401 (37.8023719590496, -122.423349300554)
151252 125507 2 70 7 Fallon Pl 2 9 1 1     4 Width 4ft   6008925.22265 2118571.08085 37.7976958234636 -122.41317615966801 (37.7976958234636, -122.413176159668)
151503 248095 2 70 8 Brewster St 4 1 1 1     4 Width 2ft   6010444.10359 2099844.52048 37.746362164885 -122.406600056945 (37.746362164885, -122.406600056945)
153001 92753 1 70 3356 Baker St 2 1 1 1   10/07/2009 12:00:00 AM 4 3x3 Permit Number 52980 5999299.39389 2120397.7877700003 37.802166375831106 -122.446615526285 (37.8021663758311, -122.446615526285)
153546 221756 2 70 3649 21st St 1 1 1 1     4 Width 3ft   6004058.63602 2103618.7990900003 37.7563661334022 -122.42894929977699 (37.7563661334022, -122.428949299777)
154495 175170 2 70 364 Moscow St 1 1 1 1     4 Width 3ft   6004288.38035 2091053.9849099999 37.7218790151804 -122.427259769545 (37.7218790151804, -122.427259769545)
156031 220594 2 70 1 14th St 2 1 1 1     4 Width 3ft   6008571.39642 2107977.23283 37.768587792328894 -122.413650808341 (37.7685877923289, -122.413650808341)
156515 220626 2 70 665 Elizabeth St 5 9 1 1     4 Width 3ft   6002107.5344 2102041.80892 37.7519254645963 -122.43558406527599 (37.7519254645963, -122.435584065276)
159436 51699 1 70 270 Sweeny St 1 1 1 1   04/29/2005 12:00:00 AM 4   Permit Number 47975 6009229.913509999 2094736.03223 37.7322673611424 -122.410437947053 (37.7322673611424, -122.410437947053)
163571 203488 2 70 296 Cresta Vista Dr 2 1 1 1     4 Width 3ft   5996843.32855 2096168.5125900002 37.735498433689706 -122.45336434200199 (37.7354984336897, -122.453364342002)
169661 220617 2 70 960 Corbett Ave 1 1 1 1     4 Width 3ft   5999730.468230001 2101939.14181 37.7515082672912 -122.44379689543699 (37.7515082672912, -122.443796895437)
172117 125492 2 70 1207 Chestnut St 3 9 1 1     4 Width 3ft   6006010.16913 2120331.72981 37.8023660361287 -122.42338828343901 (37.8023660361287, -122.423388283439)
172952 248094 2 70 8 Brewster St 3 1 1 1     4 Width 2ft   6010447.33936 2099861.6956599997 37.7464095052133 -122.406590078085 (37.7464095052133, -122.406590078085)
173180 66747 1 70 731 41st Ave 1 1 1 1 1 03/02/1996 12:00:00 AM 4   Permit Number 32132 5983183.98032 2110807.82823 37.7749014841497 -122.501671811672 (37.7749014841497, -122.501671811672)
173963 203499 2 70 379 Staples Ave 1 1 1 1     4 Width 4ft   5997569.0689199995 2093791.20398 37.7290124835419 -122.45068384968799 (37.7290124835419, -122.450683849688)
178320 248096 2 70 8 Brewster St 5 1 1 1     4 Width 2ft   6010442.96014 2099835.6038900004 37.7463376179016 -122.406603382642 (37.7463376179016, -122.406603382642)
179368 37653 1 70 1707 Balboa St 2 1 1 1 1 06/26/1998 12:00:00 AM 4   Permit Number 40063 5990244.837669999 2111259.2640400003 37.7765532018856 -122.477280073273 (37.7765532018856, -122.477280073273)
183705 249985 2 70 228 Filbert St 1 7 1 1     4 Width 0ft   6011591.62105 2120106.88257 37.802062092258 -122.40405778055799 (37.802062092258, -122.404057780558)
Powered by Datasette · Query took 4.568ms · Data source: data.sfgov.org