sf-trees

Data source: data.sfgov.org

Custom SQL query returning 87 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
83201 21481 3 5 2792X Sunset Blvd 4 11 1 2     10 60   5985060.3629888 2096294.4798015 37.735161871163605 -122.49411119238 (37.7351618711636, -122.49411119238)
81565 443 3 5 700x 23rd Ave 3 11 1 2     3     5988815.988030001 2110428.99683 37.774190512498706 -122.482161976658 (37.7741905124987, -122.482161976658)
83214 448 3 5 700x 23rd Ave 8 11 1 2     3     5988818.05287 2110350.21953 37.773974331987795 -122.482149061597 (37.7739743319878, -122.482149061597)
18211 11709 3 5 700X Junipero Serra Blvd 26 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991284.83406 2092750.4086799999 37.7257930014245 -122.472332875878 (37.7257930014245, -122.472332875878)
21068 29972 3 5 500X Junipero Serra Blvd 16 11 1 2   04/01/2007 12:00:00 AM 3 3x3   5991341.172 2093706.68724 37.7284219643784 -122.47220779725299 (37.7284219643784, -122.472207797253)
21937 29584 3 5 500X Junipero Serra Blvd 17 11 1 2   02/12/2016 12:00:00 AM 3 3X3   5991345.88941 2093701.3780900002 37.728407659786 -122.47219110225299 (37.728407659786, -122.472191102253)
88947 4806 3 5 260 Corona St 1 11 1 2     24 35   5992988.2755218 2092740.8940691003 37.7258653179999 -122.46644356219299 (37.7258653179999, -122.466443562193)
91586 4807 3 5 260 Corona St 2 11 1 2     24 35   5992988.2755218 2092740.8940691003 37.7258653179999 -122.46644356219299 (37.7258653179999, -122.466443562193)
108562 4809 3 5 260 Corona St 4 11 1 2     24 35   5992988.2755218 2092740.8940691003 37.7258653179999 -122.46644356219299 (37.7258653179999, -122.466443562193)
111013 4808 3 5 260 Corona St 3 11 1 2     24 35   5992988.2755218 2092740.8940691003 37.7258653179999 -122.46644356219299 (37.7258653179999, -122.466443562193)
73683 203961 3 5 200x Dorantes Ave 1 11 1 2     38 Width 3ft   5993559.03115 2099734.05216 37.745099710091296 -122.4649781788 (37.7450997100913, -122.4649781788)
44175 99145 2 5 302X Pacheco St 29 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
120664 99135 2 5 302X Pacheco St 18 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
20854 11187 3 5 100 Idora Ave 3 11 1 2     12 8   5995309.2253 2099420.08132 37.7443383854121 -122.458903627104 (37.7443383854121, -122.458903627104)
8054 14425 3 5 90X Masonic Ave 1 11 1 2     40 12   5998875.1013 2112962.0092 37.781725454134396 -122.447548220181 (37.7817254541344, -122.447548220181)
6171 8616 3 5 2600 Geary Blvd 4 11 1 2     12 20   5999337.0471 2113224.2861 37.78247198716561 -122.44596898090299 (37.7824719871656, -122.445968980903)
10951 24278 3 5 350X Winding Way 16 11 1 2     6 8   6000808.42529 2086790.5767400002 37.709975233345 -122.438983668972 (37.709975233345, -122.438983668972)
12225 24277 3 5 350X Winding Way 15 11 1 2     6 8   6000814.16949 2086790.4577099998 37.709975233345496 -122.43896380743999 (37.7099752333455, -122.43896380744)
62523 220272 3 5 500x 27th St 13 11 1 2     10 Width 4ft   6002834.52979 2100065.9287400004 37.7465414276535 -122.432928866369 (37.7465414276535, -122.432928866369)
42146 220273 3 5 500x 27th St 16 11 1 2     23 Width 4ft   6002878.6956 2100066.19718 37.746544669703106 -122.432776165093 (37.7465446697031, -122.432776165093)
63458 220274 3 5 500x 27th St 23 11 1 2     10 Width 4ft   6002921.47786 2100071.21628 37.7465608772933 -122.43262858725299 (37.7465608772933, -122.432628587253)
54812 175058 3 5 1132x Alemany Blvd 2 11 1 2     1 Width 3ft   6003548.97454 2094354.07012 37.7308984688672 -122.430051002559 (37.7308984688672, -122.430051002559)
6495 26421 3 5 2235X Octavia St 6 11 1 2     6 20   6004624.1328 2116974.76242 37.793070338586205 -122.427945300259 (37.7930703385862, -122.427945300259)
16543 15277 3 5 1563X Mission St 2 11 1 2   10/28/2016 12:00:00 AM 3 4X4 Permit Number 777705 6007250.560819999 2109703.40074 37.7732531819334 -122.418341887077 (37.7732531819334, -122.418341887077)
36772 175020 3 5 500x Mansell St 11 11 1 2     12 Width 0ft   6010396.843230001 2090323.76583 37.7202175482911 -122.40609285101401 (37.7202175482911, -122.406092851014)
9889 3743 3 5 906 Carolina St 2 11 1 2     18 18   6012418.0 2103694.0 37.757042237838796 -122.400044801952 (37.7570422378388, -122.400044801952)
9888 173719 3 5 922 Carolina St 1 11 1 2     12 3x3   6012422.0 2103621.0 37.7568420188621 -122.40002584196199 (37.7568420188621, -122.400025841962)
9882 173729 3 5 994 Carolina St 2 11 1 2     6 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
9906 173728 3 5 994 Carolina St 1 11 1 2     8 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
15525 3745 3 5 900 Carolina St 4 11 1 2     6 18   6012461.71984 2103674.63492 37.7569915030708 -122.39989224135799 (37.7569915030708, -122.399892241358)
9903 3758 3 5 1056 Carolina St 3 11 1 2     15 18   6012452.0863519 2103047.5184298 37.7552690413169 -122.399881522302 (37.7552690413169, -122.399881522302)
9898 3765 3 5 1074 Carolina St 3 11 1 2     15 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.39986024500799 (37.7550481677782, -122.399860245008)
9908 3768 3 5 1098 Carolina St 1 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
13675 18550 9 5 1700X Quesada Ave 5 11 1 2     30 19   6014656.2717 2095062.2920900001 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637)
49094 200518 3 5 1400x La Salle Ave 1 11 1 2     18 Width 0ft   6016087.5147 2095748.7503 37.7354301338826 -122.386800041299 (37.7354301338826, -122.386800041299)
173916 200530 3 5 1400x La Salle Ave 6 11 1 2     10 Width 0ft   6016148.3458 2095686.6607 37.735263016153105 -122.386585395355 (37.7352630161531, -122.386585395355)
153209 200532 3 5 1400x La Salle Ave 8 11 1 2     13 Width 0ft   6016155.8972 2095677.4311 37.7352380915724 -122.386558643793 (37.7352380915724, -122.386558643793)
180983 200531 3 5 1400x La Salle Ave 7 11 1 2     8 Width 0ft   6016156.3167 2095682.0459 37.7352507861079 -122.386557515095 (37.7352507861079, -122.386557515095)
73902 200534 3 5 1400x La Salle Ave 10 11 1 2     10 Width 0ft   6016166.8048 2095673.2359 37.7352271762292 -122.386520639457 (37.7352271762292, -122.386520639457)
187646 200535 3 5 1400x La Salle Ave 11 11 1 2     9 Width 0ft   6016168.4829 2095664.0064 37.735201926775396 -122.386514194261 (37.7352019267754, -122.386514194261)
49943 200538 3 5 1400x La Salle Ave 14 11 1 2     7 Width 0ft   6016175.1953 2095654.7768 37.7351769557335 -122.38649034349899 (37.7351769557335, -122.386490343499)
58892 200537 3 5 1400x La Salle Ave 13 11 1 2     10 Width 0ft   6016177.7125 2095662.3283 37.735197829979 -122.38648216691001 (37.735197829979, -122.38648216691)
42702 200540 3 5 1400x La Salle Ave 16 11 1 2     3 Width 0ft   6016179.8101 2095650.1621 37.7351645401576 -122.38647406665501 (37.7351645401576, -122.386474066655)
121090 200539 3 5 1400x La Salle Ave 15 11 1 2     7 Width 0ft   6016182.3272 2095656.8744 37.735183110122 -122.38646583191401 (37.735183110122, -122.386465831914)
133613 200541 3 5 1400x La Salle Ave 17 11 1 2     13 Width 0ft   6016186.7948 2095652.8098 37.7351721968582 -122.386450102344 (37.7351721968582, -122.386450102344)
137749 200543 3 5 1400x La Salle Ave 19 11 1 2     5 Width 0ft   6016187.8616 2095644.6304 37.7351497969246 -122.38644584387501 (37.7351497969246, -122.386445843875)
55546 200544 3 5 1400x La Salle Ave 20 11 1 2     11 Width 0ft   6016191.0622 2095640.0073 37.73513727999379 -122.38643445590401 (37.7351372799938, -122.386434455904)
169431 200546 3 5 1400x La Salle Ave 22 11 1 2     7 Width 0ft   6016197.8191 2095632.8949 37.735118124804394 -122.386410598906 (37.7351181248044, -122.386410598906)
42056 200548 3 5 1400x La Salle Ave 24 11 1 2     13 Width 0ft   6016205.9984 2095634.3174 37.7351224834655 -122.38638241900699 (37.7351224834655, -122.386382419007)
169201 200549 3 5 1400x La Salle Ave 25 11 1 2     11 Width 0ft   6016205.8206 2095623.8265 37.7350936677212 -122.386382302519 (37.7350936677212, -122.386382302519)
188905 200550 3 5 1400x La Salle Ave 26 11 1 2     5 Width 0ft   6016212.9331 2095623.1152 37.7350921083386 -122.386357662249 (37.7350921083386, -122.386357662249)
134402 200552 3 5 1400x La Salle Ave 28 11 1 2     11 Width 0ft   6016213.9999 2095615.2915 37.7350706850821 -122.386353428604 (37.7350706850821, -122.386353428604)
38412 200551 3 5 1400x La Salle Ave 27 11 1 2     15 Width 0ft   6016216.4893 2095621.6927 37.735088399287 -122.38634526793001 (37.735088399287, -122.38634526793)
69094 200554 3 5 1400x La Salle Ave 30 11 1 2     14 Width 0ft   6016223.9574 2095601.7778 37.7350341303539 -122.386318059776 (37.7350341303539, -122.386318059776)
38644 200553 3 5 1400x La Salle Ave 29 11 1 2     6 Width 0ft   6016224.312999999 2095613.1578 37.7350653972301 -122.38631762348301 (37.7350653972301, -122.386317623483)
172385 200555 3 5 1400x La Salle Ave 31 11 1 2     6 Width 0ft   6016252.4072 2095574.3949 37.7349605171331 -122.386217789361 (37.7349605171331, -122.386217789361)
51216 200556 3 5 1400x La Salle Ave 32 11 1 2     4 Width 0ft   6016262.7203 2095558.3918 37.734917146653 -122.38618101771601 (37.734917146653, -122.386181017716)
169172 200560 3 5 1400x La Salle Ave 37 11 1 2     13 Width 0ft   6016311.7963 2095496.5134 37.7347499571366 -122.38600703115401 (37.7347499571366, -122.386007031154)
34139 200562 3 5 1400x La Salle Ave 38 11 1 2     13 Width 0ft   6016315.2256 2095489.7997 37.73473171245129 -122.385994706933 (37.7347317124513, -122.385994706933)
46940 200568 3 5 1400x La Salle Ave 40 11 1 2     13 Width 0ft   6016324.0126 2095472.2809 37.7346840956345 -122.385963106208 (37.7346840956345, -122.385963106208)
62628 200574 3 5 1400x La Salle Ave 44 11 1 2     1 Width 0ft   6016364.4111 2095326.6015 37.734286324847005 -122.385813282871 (37.734286324847, -122.385813282871)
177749 200602 3 5 1400x La Salle Ave 45 11 1 2     13 Width 0ft   6016396.2402 2095212.996 37.7339761481789 -122.385695323117 (37.7339761481789, -122.385695323117)
159406 200605 3 5 1400x La Salle Ave 46 11 1 2     9 Width 0ft   6016398.6886 2095199.7747 37.7339399806144 -122.385685937001 (37.7339399806144, -122.385685937001)
130157 200606 3 5 1400x La Salle Ave 47 11 1 2     10 Width 0ft   6016400.6473 2095190.9605 37.7339158869669 -122.385678551006 (37.7339158869669, -122.385678551006)
131211 200607 3 5 1400x La Salle Ave 48 11 1 2     5 Width 0ft   6016406.5235 2095183.1256 37.73389469904829 -122.385657689133 (37.7338946990483, -122.385657689133)
55316 200609 3 5 1400x La Salle Ave 49 11 1 2     1 Width 0ft   6016412.3996 2095168.4353 37.7338546875634 -122.385636349995 (37.7338546875634, -122.385636349995)
59915 200610 3 5 1400x La Salle Ave 50 11 1 2     4 Width 0ft   6016417.2964 2095161.5798 37.733836134681795 -122.385618942498 (37.7338361346818, -122.385618942498)
23851 200603 3 5 1400x La Salle Ave 52 11 1 2     17 Width 0ft   6016419.7448 2095144.9307 37.733790555057 -122.38560931762301 (37.733790555057, -122.385609317623)
137314 200611 3 5 1400x La Salle Ave 51 11 1 2     9 Width 0ft   6016421.2138 2095153.2552 37.7338134937512 -122.385604818769 (37.7338134937512, -122.385604818769)
15352 97230 3 5 1301X Newcomb Ave 10 11 1 2     10 15x200   6016626.81073 2094919.21722 37.7331822459561 -122.38487770274999 (37.7331822459561, -122.38487770275)
15842 97227 3 5 1301X Newcomb Ave 7 11 1 2     8 15x200   6016638.64484 2094938.128 37.733234825728296 -122.384838105605 (37.7332348257283, -122.384838105605)
16240 97228 3 5 1301X Newcomb Ave 8 11 1 2     6 15x200   6016642.6726 2094934.5266099998 37.733225159799204 -122.384823929606 (37.7332251597992, -122.384823929606)
13955 97226 3 5 1301X Newcomb Ave 6 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016643.51258 2094941.1276900002 37.7332433315076 -122.38482148523899 (37.7332433315076, -122.384821485239)
23028 97224 3 5 1301X Newcomb Ave 4 11 1 2   09/30/2011 12:00:00 AM 6 15x200   6016653.042219999 2094950.9325 37.733270780626995 -122.38478922115499 (37.733270780627, -122.384789221155)
16107 97223 3 5 1301X Newcomb Ave 3 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016661.55982 2094959.63165 37.733295137843 -122.384760378985 (37.733295137843, -122.384760378985)
16402 97222 3 5 1301X Newcomb Ave 2 11 1 2     24 15x200   6016676.72369 2094975.37763 37.733339211818105 -122.38470904929702 (37.7333392118181, -122.384709049297)
77349 3742 3 5 450X Cargo Way 1 11 1 2     12 8   6016957.733924 2099023.86587 37.74447108289971 -122.38401932754 (37.7444710828997, -122.38401932754)
13612 3695 3 5 400X Cargo Way 2 11 1 2     12 8   6017120.58643 2098873.01635 37.7440658827378 -122.383445712243 (37.7440658827378, -122.383445712243)
82822 3694 3 5 400X Cargo Way 1 11 1 2     12 8   6017199.673908999 2098835.752969 37.7439679357533 -122.383169649574 (37.7439679357533, -122.383169649574)
99473 3689 1 5 200X Cargo Way 3 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127580 3691 1 5 200X Cargo Way 5 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127726 3690 1 5 200X Cargo Way 4 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
128521 3688 1 5 200X Cargo Way 2 11 1 9     18 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
140153 3687 1 5 200X Cargo Way 1 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
86341 3693 3 5 300X Cargo Way 2 11 1 2     12 8   6017817.275253 2098336.256691 37.742630528905295 -122.380999383309 (37.7426305289053, -122.380999383309)
104843 3692 3 5 300X Cargo Way 1 11 1 2     18 8   6017817.275253 2098336.256691 37.742630528905295 -122.380999383309 (37.7426305289053, -122.380999383309)
118559 3686 1 5 100X Cargo Way 1 11 1 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
Powered by Datasette · Query took 38.671ms · Data source: data.sfgov.org