sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
13240 187608 2 39 101 Northridge Rd 3 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13250 187606 2 39 101 Northridge Rd 1 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13256 187607 2 39 101 Northridge Rd 2 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13251 187611 2 39 100 Northridge Rd 3 1 1 2       3x3   6018548.0 2094208.0 37.7313354560629 -122.37818620453699 (37.7313354560629, -122.378186204537)
127234 11208 1 39 1001X Ingalls St 6 1 1 1     30 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
127821 11203 3 39 1001X Ingalls St 1 1 1 2     60 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
85139 6395 3 39 5X Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 3 3X4   6018168.8629005 2094369.8502073998 37.7317589621466 -122.379508204595 (37.7317589621466, -122.379508204595)
14069 11218 3 39 1050X Ingalls St 4 1 1 2     70 3X4   6018145.287959999 2094715.08165 37.73270559986911 -122.379613683941 (37.7327055998691, -122.379613683941)
16356 11215 3 39 1050X Ingalls St 1 1 1 2     80 3X4   6018142.31163 2094695.6186 37.732651993985705 -122.37962262229799 (37.7326519939857, -122.379622622298)
13889 11219 3 39 1050X Ingalls St 5 1 1 2   10/28/1992 12:00:00 AM 30 3X4   6018141.66576 2094727.81231 37.7327403559813 -122.379627091035 (37.7327403559813, -122.379627091035)
14426 4895 3 39 10 Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
63342 199335 2 39 75 Beatrice Ln 3 1 1 1     20 Width 3ft   6018140.2133599995 2094331.77652 37.731652839107205 -122.379604608887 (37.7316528391072, -122.379604608887)
81260 10730 3 39 1100 Hudson Ave 1 1 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
84760 10732 3 39 1100 Hudson Ave 3 1 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
88044 10731 3 39 1100 Hudson Ave 2 5 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
103686 10735 3 39 1100 Hudson Ave 6 5 1 2     12 3x4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
16458 11221 3 39 1050X Ingalls St 7 1 1 2     60 3X4   6018130.45859 2094749.06198 37.7327980852604 -122.379667313208 (37.7327980852604, -122.379667313208)
146404 201402 2 39 1051 Ingalls St 14 1 1 1     11 Width 3ft   6018102.67767 2094695.98571 37.732650815871104 -122.379759673583 (37.7326508158711, -122.379759673583)
14846 11225 3 39 1050X Ingalls St 11 1 1 2   10/29/1992 12:00:00 AM 35 3X4   6018100.6161400005 2094835.81488 37.733034645636394 -122.37977651247101 (37.7330346456364, -122.379776512471)
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)
14285 11226 3 39 1050X Ingalls St 12 1 1 2   10/29/1992 12:00:00 AM 35 3X4   6018091.97554 2094860.3210200001 37.7331014580651 -122.379808087687 (37.7331014580651, -122.379808087687)
136786 201397 2 39 1051 Ingalls St 9 4 1 1     9 Width 3ft   6018087.14225 2094737.7033099998 37.7327645072762 -122.3798162814 (37.7327645072762, -122.3798162814)
138594 11229 3 39 1050X Ingalls St 15 1 1 2     45 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
171668 191989 2 39 1000 Oakdale Ave 6 9 1 1     14     6018085.22941 2093254.8331099998 37.72869272957939 -122.379719907353 (37.7286927295794, -122.379719907353)
50831 191939 2 39 1320 Hudson Ave 1 1 1 1     22 Width 3ft   6018082.22777 2094639.81643 37.732495458002205 -122.379826473412 (37.7324954580022, -122.379826473412)
133614 191940 2 39 1320 Hudson Ave 2 1 1 1     16 Width 3ft   6018081.7385 2094632.8643599998 37.7324763419914 -122.379827682097 (37.7324763419914, -122.379827682097)
43516 201395 2 39 1051 Ingalls St 7 1 1 1     15 Width 3ft   6018074.69503 2094783.0062 37.732888213509604 -122.37986246160101 (37.7328882135096, -122.379862461601)
53137 191990 2 39 1000 Oakdale Ave 8 9 1 1     22     6018074.25782 2093264.02641 37.7287173674097 -122.379758475681 (37.7287173674097, -122.379758475681)
136324 191941 2 39 1320 Hudson Ave 4 1 1 1     15 Width 3ft   6018070.15847 2094630.66021 37.7324696510439 -122.379867564341 (37.7324696510439, -122.379867564341)
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)
169935 191942 2 39 1320 Hudson Ave 5 1 1 1     24 Width 3ft   6018059.7664 2094635.39442 37.7324820769923 -122.379903821399 (37.7324820769923, -122.379903821399)
154696 191991 2 39 1000 Oakdale Ave 9 9 1 1     20     6018056.783869999 2093269.9322799998 37.728732619904 -122.37981929503 (37.728732619904, -122.37981929503)
170575 191992 2 39 1000 Oakdale Ave 10 9 1 1     22     6018050.15302 2093281.6022599998 37.7287642976303 -122.37984302904499 (37.7287642976303, -122.379843029045)
171174 201391 2 39 1051 Ingalls St 1 4 1 1     21 Width 4ft   6018035.79915 2094923.7562 37.7332725396855 -122.380006712838 (37.7332725396855, -122.380006712838)
52638 191988 2 39 9 Navy Rd 10 1 1 1     23 Width 3ft   6018026.281719999 2093609.8087099998 37.729664171855504 -122.37994835046001 (37.7296641718555, -122.37994835046)
81116 11239 3 39 1100X Ingalls St 8 1 1 2     40 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
81312 11243 3 39 1100X Ingalls St 12 1 1 2     12 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
86825 11235 3 39 1100X Ingalls St 4 1 1 2   01/06/2016 12:00:00 AM 18 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
99278 11244 3 39 1100X Ingalls St 13 1 1 2     18 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
103589 11241 3 39 1100X Ingalls St 10 1 1 2     80 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
126235 11232 3 39 1100X Ingalls St 1 1 1 2     60 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
138686 11245 3 39 1100X Ingalls St 14 1 1 2   04/02/1998 12:00:00 AM 12 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
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)
135133 191987 2 39 9 Navy Rd 9 1 1 1     25 Width 3ft   6018017.38611 2093615.5419400001 37.729679423453604 -122.379979502076 (37.7296794234536, -122.379979502076)
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)
146541 192010 2 39 1201 Ingalls St 5 1 1 1     20 Width 3ft   6018007.26195 2093940.33851 37.7305706929704 -122.380037063171 (37.7305706929704, -122.380037063171)
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)
71341 199337 2 39 15 Beatrice Ln 12 1 1 1     18 Width 3ft   6017980.98552 2094034.02956 37.73082650063571 -122.380134413865 (37.7308265006357, -122.380134413865)
180858 191935 2 39 1333 Hudson Ave 14 1 1 1     23 Width 3ft   6017966.52071 2094591.95633 37.7323576602579 -122.38022317967399 (37.7323576602579, -122.380223179674)
34411 199336 2 39 15 Beatrice Ln 11 1 1 1     21 Width 3ft   6017966.39006 2094043.2312 37.7308509612846 -122.38018551245399 (37.7308509612846, -122.380185512454)
163711 192009 2 39 1201 Ingalls St 4 1 1 1     30 Width 3ft   6017965.16033 2093921.6756900002 37.7305171257561 -122.38018131983 (37.7305171257561, -122.38018131983)
184439 191980 2 39 8 Navy Rd 11 1 1 1     12 Width 3ft   6017947.42371 2093728.36474 37.729985353037705 -122.380229209634 (37.7299853530377, -122.380229209634)
172612 191986 2 39 9 Navy Rd 5 1 1 1     22 Width 3ft   6017936.56291 2093671.85779 37.7298295967392 -122.38026283166599 (37.7298295967392, -122.380262831666)
166719 191985 2 39 9 Navy Rd 4 1 1 1     21 Width 3ft   6017925.145330001 2093680.2056099998 37.7298518882562 -122.380302883883 (37.7298518882562, -122.380302883883)
168613 191943 2 39 1322 Hudson Ave 1 1 1 1     9 Width 3ft   6017914.028030001 2094650.6730900002 37.732515988608704 -122.38040874036999 (37.7325159886087, -122.38040874037)
90337 83074 3 39 1120X Hudson Ave 13 1 1 2     16     6017910.254851099 2094654.90941097 37.7325274125135 -122.380422079616 (37.7325274125135, -122.380422079616)
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)
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)
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)
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)
82997 10741 3 39 1120X Hudson Ave 2 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
91396 10743 3 39 1120X Hudson Ave 4 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
94761 10740 3 39 1120X Hudson Ave 1 1 1 2     8 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
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)
99336 10761 3 39 1120X Hudson Ave 14 1 1 2   01/11/1999 12:00:00 AM 8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
99737 10739 3 39 1120X Hudson Ave 11 1 1 2     16 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
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)
105402 10757 3 39 1120X Hudson Ave 10 1 1 2     15 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
105607 10746 3 39 1120X Hudson Ave 12 1 1 2     15 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
106941 10744 3 39 1120X Hudson Ave 5 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
108965 10753 3 39 1120X Hudson Ave 16 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
113353 10745 3 39 1120X Hudson Ave 15 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
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)
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)
117900 10742 3 39 1120X Hudson Ave 3 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
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)
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)
123207 10738 3 39 1120X Hudson Ave 9 5 1 2     8 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
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)
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)
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)
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)
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)
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)
145604 10747 3 39 1120X Hudson Ave 7 5 1 2     12 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
156979 191984 2 39 9 Navy Rd 3 1 1 1     18 Width 3ft   6017905.88765 2093693.41097 37.729887085019705 -122.380370378013 (37.7298870850197, -122.380370378013)
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)
68175 192008 2 39 1201 Ingalls St 3 1 1 1     22 Width 3ft   6017902.514280001 2093906.2127 37.730471210880395 -122.380396824379 (37.7304712108804, -122.380396824379)
155107 191981 2 39 8 Navy Rd 12 1 1 1     27 Width 4ft   6017899.944209999 2093758.26883 37.730064844096 -122.380395431304 (37.730064844096, -122.380395431304)
71831 191944 2 39 1322 Hudson Ave 2 1 1 1     21 Width 3ft   6017890.25827 2094658.564 37.732536343878294 -122.38049146723499 (37.7325363438783, -122.380491467235)
111913 191983 2 39 9 Navy Rd 2 1 1 1     22 Width 3ft   6017888.98442 2093706.35548 37.729921695419 -122.38042971438699 (37.729921695419, -122.380429714387)
156583 191982 2 39 9 Navy Rd 1 1 1 1     18 Width 3ft   6017886.531140001 2093723.0686400002 37.729967451122704 -122.380439356906 (37.7299674511227, -122.380439356906)
47235 191945 2 39 1322 Hudson Ave 3 1 1 1     21 Width 3ft   6017875.529519999 2094666.5378599998 37.732557425767496 -122.38054294262899 (37.7325574257675, -122.380542942629)
77827 11247 3 39 1145X Ingalls St 2 1 1 2   01/09/2003 12:00:00 AM 8 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
78989 11248 3 39 1145X Ingalls St 3 1 1 2     50 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
99438 11256 3 39 1145X Ingalls St 11 1 1 2   01/09/2003 12:00:00 AM 3 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
120747 11257 3 39 1145X Ingalls St 12 1 1 2     70 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
123755 11255 3 39 1145X Ingalls St 10 1 1 2   11/02/1992 12:00:00 AM 80 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
124384 11246 3 39 1145X Ingalls St 1 1 1 2   01/09/2003 12:00:00 AM 16 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
141024 11249 3 39 1145X Ingalls St 4 1 1 2   01/09/2003 12:00:00 AM 8 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
143708 11250 3 39 1145X Ingalls St 5 1 1 2     40 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
Powered by Datasette · Query took 6.852ms · Data source: data.sfgov.org