sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
146436 191979 2 39 1322 Hudson Ave 50 1 1 1     21 Width 3ft   6017285.56486 2095260.85875 37.7341567396346 -122.38262395315901 (37.7341567396346, -122.382623953159)
108988 10842 3 39 1139X Hudson Ave 49 1 1 2     12 3X4   6018020.73301 2094608.3360099997 37.732405626582796 -122.380036890979 (37.7324056265828, -122.380036890979)
132879 191978 2 39 1322 Hudson Ave 48 1 1 1     24 Width 3ft   6017314.11415 2095218.1238900002 37.734040975317605 -122.382522275793 (37.7340409753176, -122.382522275793)
126559 98132 3 39 1120X Hudson Ave 47 5 1 2     22 3x4   6017903.8 2094987.0 37.733438911814 -122.38046746904399 (37.733438911814, -122.380467469044)
88419 10839 3 39 1139X Hudson Ave 46 1 1 2     12 3X4   6017986.87901 2094607.0340099998 37.732400183828396 -122.380153842969 (37.7324001838284, -122.380153842969)
78294 24522 3 39 1120X Hudson Ave 45 5 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
141300 10755 3 39 1120X Hudson Ave 44 1 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
25469 224313 2 39 1300 San Jose Ave 43 9 1 1     23     6003370.69781 2095579.24653 37.734252427487895 -122.43075473197099 (37.7342524274879, -122.430754731971)
37794 191977 2 39 1322 Hudson Ave 43 1 1 1     26 Width 3ft   6017367.63238 2095116.6683200002 37.7337653546743 -122.382330188681 (37.7337653546743, -122.382330188681)
144510 10758 3 39 1120X Hudson Ave 43 5 1 2     12 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
28637 191976 2 39 1322 Hudson Ave 42 1 1 1     14 Width 3ft   6017379.91787 2095113.3460400002 37.7337569109368 -122.38228748260599 (37.7337569109368, -122.382287482606)
51663 224312 2 39 1300 San Jose Ave 42 9 1 1     14     6003373.67876 2095579.3072 37.7342527629625 -122.43074443020599 (37.7342527629625, -122.430744430206)
69503 224311 2 39 1300 San Jose Ave 41 9 1 1     16     6003371.63665 2095581.9974099998 37.7342600339703 -122.430751682345 (37.7342600339703, -122.430751682345)
102867 10766 3 39 1120X Hudson Ave 40 1 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
23872 191975 2 39 1322 Hudson Ave 39 1 1 1     23 Width 3ft   6017399.67227 2095082.1979 37.7336724754063 -122.38221701890801 (37.7336724754063, -122.382217018908)
114504 10774 3 39 1120X Hudson Ave 39 5 1 2     6 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
60853 191974 2 39 1322 Hudson Ave 38 1 1 1     14 Width 3ft   6017406.23051 2095071.90841 37.7336445847257 -122.382193629354 (37.7336445847257, -122.382193629354)
47273 10756 3 39 1120X Hudson Ave 37 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
57544 191973 2 39 1322 Hudson Ave 37 1 1 1     24 Width 3ft   6017413.418380001 2095064.5219 37.7336246998239 -122.382168264862 (37.7336246998239, -122.382168264862)
72113 142421 2 39 10 MAYFAIR DR 36 9 1 1     3 Width 0ft   5997633.2625 2114522.3029 37.78593856211079 -122.451956978624 (37.7859385621108, -122.451956978624)
185250 191972 2 39 1322 Hudson Ave 36 1 1 1     12 Width 3ft   6017424.03825 2095052.5170099998 37.733592323307 -122.382130713678 (37.733592323307, -122.382130713678)
56901 191971 2 39 1322 Hudson Ave 35 1 1 1     20 Width 3ft   6017425.53819 2095032.4759799999 37.733537377444 -122.38212413422701 (37.733537377444, -122.382124134227)
139201 10772 3 39 1120X Hudson Ave 35 1 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
40673 191970 2 39 1322 Hudson Ave 34 1 1 1     10 Width 3ft   6017432.113390001 2095036.9566 37.7335500434817 -122.382101713228 (37.7335500434817, -122.382101713228)
79233 10737 3 39 1120X Hudson Ave 34 1 1 2     16 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
33413 191913 2 39 1195 La Salle Ave 33 1 1 1     19 Width 3ft   6017141.57749 2094559.46795 37.7322229040473 -122.383072967557 (37.7322229040473, -122.383072967557)
177796 191969 2 39 1322 Hudson Ave 33 1 1 1     8 Width 3ft   6017439.33628 2095027.5859 37.7335247123006 -122.382076089739 (37.7335247123006, -122.382076089739)
66687 191968 2 39 1322 Hudson Ave 32 1 1 1     19 Width 3ft   6017451.63963 2095009.8105400002 37.7334765841572 -122.38203231705299 (37.7334765841572, -122.382032317053)
50446 191912 2 39 1195 La Salle Ave 31 1 1 1     21 Width 3ft   6017156.08475 2094552.98118 37.7322058942787 -122.383022360886 (37.7322058942787, -122.383022360886)
42493 191967 2 39 1322 Hudson Ave 30 1 1 1     18 Width 3ft   6017483.19802 2094966.73925 37.733360061719395 -122.381920214743 (37.7333600617194, -122.381920214743)
25389 191966 2 39 1322 Hudson Ave 29 1 1 1     17 Width 3ft   6017499.193519999 2094948.2745700001 37.7333102446675 -122.381863629414 (37.7333102446675, -122.381863629414)
180296 191911 2 39 1195 La Salle Ave 29 1 1 1     29 Width 6ft   6017174.995619999 2094538.0244099998 37.7321658708595 -122.38295594056002 (37.7321658708595, -122.38295594056)
49761 191965 2 39 1322 Hudson Ave 28 1 1 1     25 Width 3ft   6017513.97895 2094931.0641 37.733263804581 -122.38181131495001 (37.733263804581, -122.38181131495)
107681 26534 3 39 1200X La Salle Ave 28 1 1 2     12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
133897 191873 2 39 1196 La Salle Ave 28 1 1 1     20 Width 3ft   6017415.1746 2094317.3101 37.731573100711294 -122.38211023161199 (37.7315731007113, -122.382110231612)
137880 191910 2 39 1195 La Salle Ave 28 1 1 1     5 Width 3ft   6017194.90189 2094527.0562099998 37.7321368542252 -122.38288635642901 (37.7321368542252, -122.382886356429)
129603 191872 2 39 1196 La Salle Ave 27 1 1 1     25 Width 3ft   6017405.77912 2094325.5778400002 37.7315952833905 -122.38214328888701 (37.7315952833905, -122.382143288887)
134376 191909 2 39 1195 La Salle Ave 27 1 1 1     21 Width 3ft   6017213.21329 2094518.67057 37.732114840633 -122.38282246588001 (37.732114840633, -122.38282246588)
18452 10752 3 39 1120X Hudson Ave 26 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
65097 191908 2 39 1195 La Salle Ave 26 1 1 1     22 Width 3ft   6017233.07561 2094505.5167200002 37.7320798201283 -122.382752881756 (37.7320798201283, -122.382752881756)
68686 191893 2 39 1189 La Salle Ave 26 1 1 1     18 Width 3ft   6017518.154180001 2094274.42497 37.7314610334903 -122.38175122585501 (37.7314610334903, -122.381751225855)
86885 11999 3 39 1200X La Salle Ave 26 1 1 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
126260 10819 3 39 1139X Hudson Ave 26 1 1 2     12 3X4   6017712.13901 2094678.6490099998 37.7325816628845 -122.38110867061701 (37.7325816628845, -122.381108670617)
33999 191871 2 39 1196 La Salle Ave 25 1 1 1     22 Width 3ft   6017366.50596 2094360.99224 37.73169035522479 -122.382281528172 (37.7316903552248, -122.382281528172)
98284 11286 3 39 1176X Ingalls St 25 1 1 2     45 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
107134 12043 3 39 1250X La Salle Ave 25 1 1 2   03/29/1993 12:00:00 AM 12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
115375 10748 3 39 1120X Hudson Ave 25 1 1 2     25 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
50215 209138 3 39 900x Bosworth St 24 3 1 2     24     6000918.34106 2095790.55513 37.7346933857729 -122.439248434772 (37.7346933857729, -122.439248434772)
120117 10762 3 39 1120X Hudson Ave 24 1 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
139037 11285 3 39 1176X Ingalls St 24 1 1 2     45 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
50311 209137 3 39 900x Bosworth St 23 3 1 2     24     6000977.0463 2095762.1119400002 37.734618627848796 -122.43904343343 (37.7346186278488, -122.43904343343)
122783 10768 3 39 1120X Hudson Ave 23 5 1 2     14 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
168012 191964 2 39 1322 Hudson Ave 23 1 1 1     20 Width 3ft   6017587.14065 2094853.02283 37.7330535583775 -122.381552946926 (37.7330535583775, -122.381552946926)
177060 191870 2 39 1196 La Salle Ave 23 1 1 1     26 Width 3ft   6017330.87617 2094390.2738400002 37.7317687886877 -122.382406745273 (37.7317687886877, -122.382406745273)
4669 253646 3 39 1200x La Salle Ave 22 1 1 2 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
55869 191869 2 39 1196 La Salle Ave 22 1 1 1     23 Width 3ft   6017313.47535 2094403.8962400001 37.731805231916596 -122.382467851533 (37.7318052319166, -122.382467851533)
58168 209136 3 39 900x Bosworth St 22 3 1 2     27     6000997.1554 2095746.93377 37.7345780962937 -122.438972822257 (37.7345780962937, -122.438972822257)
70861 191963 2 39 1322 Hudson Ave 22 1 1 1     24 Width 3ft   6017606.4886 2094832.3379799998 37.7329978300889 -122.381484617321 (37.7329978300889, -122.381484617321)
116742 11283 3 39 1176X Ingalls St 22 1 1 2     80 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
128523 11995 3 39 1200X La Salle Ave 22 1 1 2   11/09/1992 12:00:00 AM 18 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
130839 201686 2 39 401 08th St 22 7 1 1     22     6010289.03016 2109854.63752 37.773839014688605 -122.40784202968399 (37.7738390146886, -122.407842029684)
143187 10764 3 39 1120X Hudson Ave 22 1 1 2     14 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
169419 191892 2 39 1189 La Salle Ave 22 1 1 1     14 Width 3ft   6017557.69492 2094217.1276599998 37.7313058896339 -122.38161054129499 (37.7313058896339, -122.381610541295)
37941 201685 2 39 401 08th St 21 7 1 1     30     6010307.98401 2109858.68813 37.773851197808206 -122.407776750616 (37.7738511978082, -122.407776750616)
95381 10763 3 39 1120X Hudson Ave 21 5 1 2     22 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
111525 99343 3 39 450 30th Ave 21 1 1 4 2   24 3x3   5986574.07493 2113086.2305799997 37.781355867791 -122.490112542148 (37.781355867791, -122.490112542148)
132259 191962 2 39 1322 Hudson Ave 21 1 1 1     19 Width 3ft   6017619.80486 2094818.84734 37.732961522640004 -122.381437641251 (37.73296152264, -122.381437641251)
152593 191868 2 39 1196 La Salle Ave 21 1 1 1     16 Width 3ft   6017292.29785 2094417.0178599998 37.7318400914414 -122.382541979921 (37.7318400914414, -122.382541979921)
187536 209135 3 39 900x Bosworth St 21 3 1 2     21     6001010.142969999 2095737.8079 37.7345537777227 -122.438927266197 (37.7345537777227, -122.438927266197)
26906 191961 2 39 1322 Hudson Ave 20 1 1 1     14 Width 3ft   6017640.3936 2094798.44512 37.7329066388304 -122.381365041689 (37.7329066388304, -122.381365041689)
29768 191907 2 39 1195 La Salle Ave 20 1 1 1     21 Width 3ft   6017354.46575 2094427.64232 37.7318726981701 -122.382327789305 (37.7318726981701, -122.382327789305)
69448 191927 2 39 1197 La Salle Ave 20 1 1 1     25 Width 4ft   6016640.54337 2094861.3889799998 37.733024220672895 -122.38482619767099 (37.7330242206729, -122.384826197671)
97455 98954 6 39 302 Ivy St 20 7 1 1           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433)
127830 10751 3 39 1120X Hudson Ave 20 1 1 2     14 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
129536 191891 2 39 1189 La Salle Ave 20 1 1 1     15 Width 3ft   6017565.20536 2094205.8473099999 37.7312753306895 -122.381583791867 (37.7312753306895, -122.381583791867)
164621 191938 2 39 1333 Hudson Ave 20 1 1 1     24 Width 3ft   6018097.58806 2094596.5000900002 37.7323773671099 -122.379770360219 (37.7323773671099, -122.379770360219)
176176 209134 3 39 900x Bosworth St 20 3 1 2     16     6001014.7051099995 2095735.41705 37.7345474725699 -122.438911322111 (37.7345474725699, -122.438911322111)
41196 209133 3 39 900x Bosworth St 19 3 1 2     25     6001054.84945 2095714.1457200001 37.734491350384005 -122.43877100628 (37.734491350384, -122.43877100628)
42099 191937 2 39 1333 Hudson Ave 19 1 1 1     13 Width 3ft   6018063.70689 2094592.47846 37.732364455550204 -122.379887217221 (37.7323644555502, -122.379887217221)
87916 98953 6 39 302 Ivy St 19 7 1 1           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433)
105361 11992 3 39 1200X La Salle Ave 19 1 1 2   08/26/2016 12:00:00 AM 18 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
131616 191960 2 39 1322 Hudson Ave 19 1 1 1     16 Width 3ft   6017644.49917 2094802.97512 37.732919303973205 -122.381351162419 (37.7329193039732, -122.381351162419)
182546 191906 2 39 1195 La Salle Ave 19 1 1 1     21 Width 3ft   6017367.74393 2094414.6206900002 37.7318376767563 -122.38228097780501 (37.7318376767563, -122.382280977805)
33183 209132 3 39 900x Bosworth St 18 3 1 2     22 Width 10ft   6001073.50305 2095703.1639599998 37.7344622582302 -122.438705728106 (37.7344622582302, -122.438705728106)
82251 12036 3 39 1250X La Salle Ave 18 1 1 2     12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
87797 11991 3 39 1200X La Salle Ave 18 1 1 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
144777 24280 3 39 300X Winding Way 18 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
163162 191959 2 39 1322 Hudson Ave 18 1 1 1     15 Width 3ft   6017649.25254 2094793.65412 37.732893972760294 -122.38133408071 (37.7328939727603, -122.38133408071)
164537 191926 2 39 1197 La Salle Ave 18 1 1 1     18 Width 4ft   6016704.51234 2094812.9590200002 37.7328947794661 -122.384601665737 (37.7328947794661, -122.384601665737)
4684 253645 3 39 1200x La Salle Ave 17 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
20904 12016 3 39 1230X La Salle Ave 17 1 1 2   11/09/1992 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
24581 191958 2 39 1322 Hudson Ave 17 1 1 1     20 Width 3ft   6017653.96329 2094797.5572 37.732904949909994 -122.381318065575 (37.73290494991, -122.381318065575)
55923 191867 2 39 1196 La Salle Ave 17 1 1 1     15 Width 3ft   6017210.738969999 2094467.7098 37.7319747757199 -122.382827475124 (37.7319747757199, -122.382827475124)
59293 209131 3 39 900x Bosworth St 17 3 1 2     28 Width 10ft   6001087.056530001 2095697.8346 37.734448396084396 -122.43865848761699 (37.7344483960844, -122.438658487617)
72160 10810 3 39 1139X Hudson Ave 17 1 1 2     12 3x4   6017615.78501 2094776.3050099998 37.7328444878546 -122.38144858171499 (37.7328444878546, -122.381448581715)
79089 11278 3 39 1176X Ingalls St 17 1 1 2     45 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
143311 10754 3 39 1120X Hudson Ave 17 5 1 2     8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
148144 191905 2 39 1195 La Salle Ave 17 1 1 1     20 Width 3ft   6017404.86032 2094385.99704 37.7317611318669 -122.38215066694299 (37.7317611318669, -122.382150666943)
152325 191925 2 39 1197 La Salle Ave 17 1 1 1     20 Width 4ft   6016730.8677 2094795.07915 37.7328471423683 -122.38450930266599 (37.7328471423683, -122.384509302666)
183084 191936 2 39 1333 Hudson Ave 17 1 1 1     14 Width 3ft   6018015.40205 2094588.0044900002 37.7323495061149 -122.38005390925501 (37.7323495061149, -122.380053909255)
48769 191924 2 39 1197 La Salle Ave 16 1 1 1     17 Width 4ft   6016750.43932 2094781.42247 37.7328107261178 -122.384440687085 (37.7328107261178, -122.384440687085)
Powered by Datasette · Query took 12.007ms · Data source: data.sfgov.org