sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1828 35192 1 12   12 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1869 35202 1 12   1 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
2080 34119 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37980          
3062 34116 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37979          
3077 35211 1 12   8 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3212 34102 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37975          
3420 35199 1 12   4 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3663 36860 1 12   5 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
5605 34138 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37987          
5673 46713 1 12   5 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
5690 34100 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37975          
5885 46715 1 12   4 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6242 35188 1 12   16 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
6282 46717 1 12   2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7169 34120 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37980          
7206 46718 1 12   1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7464 35185 1 12   19 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
7694 36863 1 12   8 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
7712 35193 1 12   11 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
8041 46716 1 12   3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
8802 50777 1 12   3 1 1 1         Permit Number 47304          
8884 34133 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9418 34114 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37978          
9498 36866 1 12   12 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9542 34136 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9591 36856 1 12   2 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9614 36864 1 12   9 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
10854 34134 1 12   5 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
10907 34118 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37979          
11057 46152 1 12   2 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44491          
11107 34137 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37987          
11262 34121 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37980          
11449 35191 1 12   13 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
11627 88529 1 12     1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51479          
11728 35200 1 12   3 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
12079 46714 1 12   6 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
12275 35186 1 12   18 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
12401 36861 1 12   6 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
12589 34135 1 12   4 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
13016 35189 1 12   15 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
13086 34123 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37981          
13445 36857 1 12   1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13457 36874 1 12   11 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14227 35184 1 12   6 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14687 35195 1 12   9 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14730 34101 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37975          
14763 50776 1 12   1 1 1 1         Permit Number 47304          
14818 35190 1 12   14 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14890 36859 1 12   4 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14897 36862 1 12   7 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15003 34117 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37979          
15057 34122 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37981          
15117 36858 1 12   3 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15124 35187 1 12   17 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
15551 34115 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37978          
15779 50775 1 12   2 1 1 1         Permit Number 47304          
15869 46153 1 12   1 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44491          
15972 34132 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
16027 35201 1 12   2 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16469 35182 1 12   7 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16677 36865 1 12   10 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16819 34124 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37982          
16829 35194 1 12   10 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16890 34103 1 12   4 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37975          
17122 35196 1 12   5 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
53867 204800 2 12 0 16th Ave 1 2 1 1     6 Width 3ft   5991281.57381 2102416.71556 37.752334025717296 -122.473048745206 (37.7523340257173, -122.473048745206)
90909 46106 1 12 1 Alder St 3 1 1 1   12/18/2001 12:00:00 AM     Permit Number 44470 6010785.67875033 2089962.42163565 37.7192471121728 -122.404723343661 (37.7192471121728, -122.404723343661)
102611 46104 1 12 1 Alder St 1 1 1 1   12/18/2001 12:00:00 AM     Permit Number 44470 6010785.67875033 2089962.42163565 37.7192471121728 -122.404723343661 (37.7192471121728, -122.404723343661)
109583 46105 1 12 1 Alder St 2 1 1 1   12/18/2001 12:00:00 AM     Permit Number 44470 6010785.67875033 2089962.42163565 37.7192471121728 -122.404723343661 (37.7192471121728, -122.404723343661)
2702 175365 2 12 1 Brotherhood Way 18 2 1 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)
2703 175367 2 12 1 Brotherhood Way 23 2 1 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
2705 175366 2 12 1 Brotherhood Way 22 2 1 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2708 175370 2 12 1 Brotherhood Way 26 2 1 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
2709 175364 2 12 1 Brotherhood Way 15 2 1 1     3 Width 5ft   5993263.021319999 2087797.41727 37.7123075747038 -122.465134896479 (37.7123075747038, -122.465134896479)
2716 175362 2 12 1 Brotherhood Way 10 2 1 1     6 Width 5ft   5993185.52762 2087808.44828 37.7123333942447 -122.46540353654 (37.7123333942447, -122.46540353654)
2720 175369 2 12 1 Brotherhood Way 25 2 1 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
2721 175371 2 12 1 Brotherhood Way 27 2 1 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2722 175368 2 12 1 Brotherhood Way 24 2 1 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
3733 175357 2 12 1 Brotherhood Way 2 7 1 1     3 Width 5ft   5992890.63105 2087809.5806900002 37.7123194916216 -122.466422861444 (37.7123194916216, -122.466422861444)
3737 175356 2 12 1 Brotherhood Way 1 1 1 1     3 Width 5ft   5992860.08995 2087808.05232 37.71231353272879 -122.46652830874201 (37.7123135327288, -122.466528308742)
3738 175361 2 12 1 Brotherhood Way 6 7 1 1     3 Width 5ft   5993097.02114 2087813.9243700001 37.7123433254574 -122.465709836634 (37.7123433254574, -122.465709836634)
3740 175359 2 12 1 Brotherhood Way 4 7 1 1     7 Width 5ft   5993023.53483 2087808.23472 37.7123234639353 -122.465963412176 (37.7123234639353, -122.465963412176)
3743 175363 2 12 1 Brotherhood Way 8 17 1 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
3747 175360 2 12 1 Brotherhood Way 5 7 1 1     5 Width 5ft   5993054.1062900005 2087811.2090200002 37.7123333942521 -122.46585796488002 (37.7123333942521, -122.46585796488)
3748 175358 2 12 1 Brotherhood Way 3 7 1 1     3 Width 5ft   5992915.27224 2087806.8926400002 37.7123135327144 -122.466337499576 (37.7123135327144, -122.466337499576)
47487 221032 2 12 1 Castro St 6 1 1 1     2 Width 3ft   6002228.72337 2107859.0178400003 37.7679049955364 -122.43558110199699 (37.7679049955364, -122.435581101997)
71258 221030 2 12 1 Castro St 2 1 1 1     2 Width 3ft   6002233.32446 2107776.82877 37.7676795858795 -122.43555930691299 (37.7676795858795, -122.435559306913)
169512 221031 2 12 1 Castro St 3 1 1 1     2 Width 3ft   6002232.66397 2107795.66667 37.76773127261 -122.435562939274 (37.76773127261, -122.435562939274)
23559 188032 2 12 1 Coral Rd 6 1 1 1     1 Width 3ft   6012685.55222 2102502.84879 37.7537865099459 -122.39903589429599 (37.7537865099459, -122.399035894296)
41794 188029 2 12 1 Coral Rd 7 1 1 1     1 Width 3ft   6012701.65178 2102497.5852200002 37.753772954465205 -122.39897984856 (37.7537729544652, -122.39897984856)
47119 188031 2 12 1 Coral Rd 9 1 1 1     1 Width 3ft   6012734.91684 2102494.2067299997 37.7537655314595 -122.398864572545 (37.7537655314595, -122.398864572545)
65289 188025 2 12 1 Coral Rd 1 1 1 1     1 Width 3ft   6012582.73869 2102525.50011 37.753842975695704 -122.399393039364 (37.7538429756957, -122.399393039364)
68625 188030 2 12 1 Coral Rd 8 1 1 1     2 Width 3ft   6012718.84264 2102495.6973 37.7537687285693 -122.398920265762 (37.7537687285693, -122.398920265762)
155301 188026 2 12 1 Coral Rd 2 1 1 1     1 Width 3ft   6012601.825180001 2102523.3374799998 37.7538381013656 -122.399326881633 (37.7538381013656, -122.399326881633)
155536 188028 2 12 1 Coral Rd 4 1 1 1     1 Width 3ft   6012635.81277 2102515.49505 37.753818461957 -122.39920879346 (37.753818461957, -122.39920879346)
164156 188027 2 12 1 Coral Rd 3 1 1 1     1 Width 3ft   6012619.435430001 2102520.28152 37.7538306918346 -122.399265766417 (37.7538306918346, -122.399265766417)
179276 188033 2 12 1 Coral Rd 5 1 1 1     1 Width 3ft   6012652.037140001 2102509.0655400003 37.7538017120961 -122.39915223420799 (37.7538017120961, -122.399152234208)
133650 222061 2 12 1 Dorland St 2 1 1 1     7 Width 3ft   6005472.8501 2105742.2338099997 37.7622765336656 -122.424209462512 (37.7622765336656, -122.424209462512)
185671 222060 2 12 1 Dorland St 1 1 1 1     14 Width 3ft   6005458.51914 2105741.51022 37.7622737376675 -122.424258976498 (37.7622737376675, -122.424258976498)
117710 46167 1 12 1 Hill Point Ave 2 1 1 1   12/28/2001 12:00:00 AM     Permit Number 44496 5996328.40935041 2106768.45994323 37.7645737153289 -122.45591064533001 (37.7645737153289, -122.45591064533)
126993 46166 1 12 1 Hill Point Ave 3 1 1 1   12/28/2001 12:00:00 AM     Permit Number 44496 5996328.40935041 2106768.45994323 37.7645737153289 -122.45591064533001 (37.7645737153289, -122.45591064533)
Powered by Datasette · Query took 17.889ms · Data source: data.sfgov.org