sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6092 46303 1 46   3 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
7478 46291 1 46   4 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
10371 46304 1 46   1 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
11759 46302 1 46   5 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
13945 46285 1 46   2 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
161630 136974 2 46 1 Avila St 1 1 1 1     14 Width 3ft   6001080.18174 2119739.07113 37.800459273745105 -122.440405888327 (37.8004592737451, -122.440405888327)
30837 123696 2 46 1 Clement St 1 1 1 1     10 Width 3ft   5995493.19231 2113537.8911 37.7831128208781 -122.45928967118799 (37.7831128208781, -122.459289671188)
155708 123695 2 46 1 Clement St 2 1 1 1     12 Width 3ft   5995508.22475 2113538.45627 37.7831152369297 -122.459237706338 (37.7831152369297, -122.459237706338)
159564 242778 2 46 1 McCoppin St 1 4 1 1     4 Width 9ft   6006595.78841 2109152.55753 37.7717038182152 -122.420567728011 (37.7717038182152, -122.420567728011)
35801 215481 2 46 1 Santa Paula Ave 2 2 1 1     3 Width 6ft   5994138.58821 2097841.54459 37.739936758872204 -122.462836916405 (37.7399367588722, -122.462836916405)
180262 215482 2 46 1 Santa Paula Ave 1 2 1 1     1 Width 6ft   5994118.54253 2097814.9092900003 37.7398624703831 -122.462904293614 (37.7398624703831, -122.462904293614)
38520 141758 2 46 10 HOLLIS ST 5 1 1 1     14 Width 0ft   6003941.7467 2113359.8855 37.7831061707931 -122.430048406845 (37.7831061707931, -122.430048406845)
39318 141761 2 46 10 HOLLIS ST 8 1 1 1     10 Width 0ft   6003925.4266 2113468.4989 37.7834034717338 -122.430112618538 (37.7834034717338, -122.430112618538)
46868 141760 2 46 10 HOLLIS ST 7 1 1 1     13 Width 0ft   6003934.4308 2113424.6033 37.783283455356795 -122.430078335144 (37.7832834553568, -122.430078335144)
53705 141759 2 46 10 HOLLIS ST 6 1 1 1     15 Width 0ft   6003937.2446 2113390.8375 37.7831909022721 -122.43006619100001 (37.7831909022721, -122.430066191)
59836 141755 2 46 10 HOLLIS ST 2 1 1 1     14 Width 0ft   6003953.8461 2113272.9385 37.7828681212931 -122.430000343557 (37.7828681212931, -122.430000343557)
155018 141757 2 46 10 HOLLIS ST 4 1 1 1     16 Width 0ft   6003947.6557 2113327.5266 37.7830176559931 -122.430025655042 (37.7830176559931, -122.430025655042)
161755 141754 2 46 10 HOLLIS ST 1 1 1 1     12 Width 0ft   6003957.9028 2113249.5012 37.7828039980646 -122.429984636672 (37.7828039980646, -122.429984636672)
167840 141762 2 46 10 HOLLIS ST 9 1 1 1     11 Width 0ft   6003923.1755 2113496.0743 37.7834790593899 -122.430122374293 (37.7834790593899, -122.430122374293)
170446 141756 2 46 10 HOLLIS ST 3 1 1 1     14 Width 0ft   6003949.9068 2113305.5788 37.7829575203066 -122.43001630101801 (37.7829575203066, -122.430016301018)
164000 242590 2 46 10 Hoffman Ave 1 1 1 1     14 Width 3ft   6000566.185219999 2102752.01252 37.75378784634879 -122.440965200093 (37.7537878463488, -122.440965200093)
11883 17495 3 46 100 Persia Ave 1 1 1 2     20 3X3   6002027.05349 2091378.7208900002 37.722642521627996 -122.43509980193001 (37.722642521628, -122.43509980193)
12993 19985 3 46 100 STAIRWAY46 5 1 1 2     3 40            
56999 198593 2 46 1000 16th St 1 1 1 1     3 Width 4ft   6013352.21579 2107122.2943 37.766507623566106 -122.397054279536 (37.7665076235661, -122.397054279536)
58597 198595 2 46 1000 16th St 3 1 1 1     3 Width 4ft   6013296.53525 2107120.49149 37.7664995737224 -122.397246743447 (37.7664995737224, -122.397246743447)
150160 198597 2 46 1000 16th St 5 1 1 1     3 Width 4ft   6013173.331180001 2107113.60808 37.766473813538106 -122.397672404268 (37.7664738135381, -122.397672404268)
181007 198596 2 46 1000 16th St 4 1 1 1     3 Width 4ft   6013207.26395 2107117.3176700003 37.7664858887413 -122.397555296343 (37.7664858887413, -122.397555296343)
181037 198594 2 46 1000 16th St 2 1 1 1     3 Width 4ft   6013331.88607 2107121.5339099998 37.766504403987796 -122.39712454356001 (37.7665044039878, -122.39712454356)
11239 17609 1 46 1000X Persia Ave 2 1 1 1     40 3X3   6004106.27078 2090068.65464 37.7191632136975 -122.42781910286999 (37.7191632136975, -122.42781910287)
12237 17610 1 46 1000X Persia Ave 3 1 1 1     40 3X3   6004083.7901099995 2090083.69021 37.7192032263241 -122.427897880781 (37.7192032263241, -122.427897880781)
12681 17608 3 46 1000X Persia Ave 1 1 1 2   04/26/1999 12:00:00 AM 40 6x9   6004130.9636 2090056.2016 37.7191304172171 -122.427732862395 (37.7191304172171, -122.427732862395)
14305 85794 3 46 1001 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6010934.7813 2111463.5411 37.778292821216 -122.405721608986 (37.778292821216, -122.405721608986)
84787 17611 1 46 1001X Persia Ave 1 1 1 1     50 3X3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
118411 17613 1 46 1001X Persia Ave 3 1 1 1     12 3x3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
142590 17612 1 46 1001X Persia Ave 2 1 1 1     12 3x3   6004077.225620099 2090145.4202003002 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089)
109476 19301 3 46 100X Balboa St 2 1 1 2     12 3x3   5995247.10654 2111496.409 37.7774933045144 -122.459993084378 (37.7774933045144, -122.459993084378)
120654 102761 1 46 100X Russ St 3 1 1 1 1 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.40821818771099 (37.7785759102049, -122.408218187711)
22362 244426 3 46 100x Octavia St 6 11 1 2     4 Width 0ft   6005680.8792 2109772.4112 37.773354183173396 -122.423776541571 (37.7733541831734, -122.423776541571)
25504 244422 3 46 100x Octavia St 2 11 1 2     5 Width 0ft   6005691.1562 2109690.8797 37.773130897486205 -122.423735193743 (37.7731308974862, -122.423735193743)
34532 244424 3 46 100x Octavia St 4 11 1 2     5 Width 0ft   6005686.3603 2109729.9326 37.7732378565997 -122.42375456071301 (37.7732378565997, -122.423754560713)
62865 244423 3 46 100x Octavia St 3 11 1 2     5 Width 0ft   6005687.7306 2109711.4339 37.7731871409862 -122.423748505092 (37.7731871409862, -122.423748505092)
68449 244328 3 46 100x Octavia St 8 11 1 2     5 Width 0ft   6005669.917 2109835.444 37.7735266371926 -122.423818944241 (37.7735266371926, -122.423818944241)
69750 244330 3 46 100x Octavia St 10 11 1 2     7 Width 0ft   6005665.121 2109878.6077 37.7736448835433 -122.42383860414199 (37.7736448835433, -122.423838604142)
76593 244327 3 46 100x Octavia St 7 11 1 2     7 Width 0ft   6005673.3426 2109802.5573 37.773436531636 -122.42380475570499 (37.773436531636, -122.423804755705)
136512 244331 3 46 100x Octavia St 11 11 1 2     6 Width 0ft   6005661.6953 2109906.0133 37.7737199393103 -122.423852403284 (37.7737199393103, -122.423852403284)
149269 244421 3 46 100x Octavia St 1 11 1 2     7 Width 0ft   6005693.2117 2109673.0661 37.773082101669296 -122.423726816669 (37.7730821016693, -122.423726816669)
152904 244425 3 46 100x Octavia St 5 11 1 2     6 Width 0ft   6005682.2494 2109755.2828 37.7733072300695 -122.423770583723 (37.7733072300695, -122.423770583723)
157190 244329 3 46 100x Octavia St 9 11 1 2     5 Width 0ft   6005667.8615 2109858.0536 37.773588601656996 -122.423827662517 (37.773588601657, -122.423827662517)
121063 16605 1 46 101 Noe St 1 1 1 1   07/21/2014 12:00:00 AM 18 3X3 Permit Number 773154 6002878.7558281 2107677.2386141997 37.7674427729111 -122.433319725194 (37.7674427729111, -122.433319725194)
10917 17498 3 46 101 Persia Ave 3 1 1 2     50 2X2   6002093.54294 2091384.31052 37.72266164479 -122.43487036238501 (37.72266164479, -122.434870362385)
11596 17497 3 46 101 Persia Ave 2 1 1 2     50 2X2   6002079.41309 2091392.13948 37.7226823390961 -122.43491976573401 (37.7226823390961, -122.434919765734)
12309 17496 3 46 101 Persia Ave 1 1 1 2   04/23/2003 12:00:00 AM 3 2X2   6002048.59392 2091411.2062099997 37.7227329421421 -122.43502766371401 (37.7227329421421, -122.435027663714)
120689 112514 2 46 1014 Clement St 1 1 1 1     12 3x3   5992342.97239 2113476.2606 37.7827619817135 -122.47018356398998 (37.7827619817135, -122.47018356399)
10375 17615 1 46 1018 Persia Ave 1 1 1 1     40 3x3   6004156.70512 2090037.9094200002 37.7190816469907 -122.427642581247 (37.7190816469907, -122.427642581247)
102960 103588 6 46 101X Laguna St 1 7 1 1           6005198.60314 2109385.58511 37.772264815602 -122.42541726943199 (37.772264815602, -122.425417269432)
1192 119753 3 46 101x Octavia St 8 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1196 119750 3 46 101x Octavia St 5 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1202 119754 3 46 101x Octavia St 9 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1204 119749 3 46 101x Octavia St 4 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1213 119747 3 46 101x Octavia St 2 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1223 119752 3 46 101x Octavia St 7 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1227 119736 3 46 101x Octavia St 1 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1233 119757 3 46 101x Octavia St 12 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 119748 3 46 101x Octavia St 3 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 119756 3 46 101x Octavia St 11 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
28574 244375 3 46 101x Octavia St 5 11 1 2     6 Width 0ft   6005617.5038 2109823.1115 37.773489816144796 -122.423999372272 (37.7734898161448, -122.423999372272)
45981 244376 3 46 101x Octavia St 6 11 1 2     7 Width 0ft   6005617.5038 2109799.1317 37.7734239734056 -122.423997666684 (37.7734239734056, -122.423997666684)
56950 244345 3 46 101x Octavia St 2 11 1 2     7 Width 0ft   6005607.2268 2109894.3659 37.773684883292105 -122.424039990106 (37.7736848832921, -122.424039990106)
66611 244468 3 46 101x Octavia St 12 11 1 2     7 Width 0ft   6005635.3174 2109670.3256 37.7730713086411 -122.423926885709 (37.7730713086411, -122.423926885709)
68766 244467 3 46 101x Octavia St 11 11 1 2     6 Width 0ft   6005631.8918 2109690.1946 37.7731256707262 -122.423940148458 (37.7731256707262, -122.423940148458)
73396 244466 3 46 101x Octavia St 10 11 1 2     6 Width 0ft   6005631.2066 2109707.3231 37.7731726627699 -122.423943736898 (37.7731726627699, -122.423943736898)
129691 244344 3 46 101x Octavia St 1 11 1 2     7 Width 0ft   6005605.8565 2109917.6606 37.773748767543104 -122.424046387097 (37.7737487675431, -122.424046387097)
155187 244456 3 46 101x Octavia St 8 11 1 2     5 Width 0ft   6005624.3552 2109760.7639 37.773319011501705 -122.42397123777799 (37.7733190115017, -122.423971237778)
161664 244455 3 46 101x Octavia St 7 11 1 2     7 Width 0ft   6005622.2998 2109777.2072 37.7733640447919 -122.423979517231 (37.7733640447919, -122.423979517231)
174364 244465 3 46 101x Octavia St 9 11 1 2     7 Width 0ft   6005629.1512 2109732.6732 37.773242151986 -122.423952649806 (37.773242151986, -122.423952649806)
176821 244373 3 46 101x Octavia St 3 11 1 2     5 Width 0ft   6005612.0227 2109867.6455 37.7736117862994 -122.424021499783 (37.7736117862994, -122.424021499783)
187415 244374 3 46 101x Octavia St 4 11 1 2     7 Width 0ft   6005614.0781 2109847.0914 37.7735554657504 -122.42401292788901 (37.7735554657504, -122.424012927889)
30655 180517 2 46 1023 Persia Ave 3 1 1 1     17 Width 4ft   6004131.62894 2090104.3716099998 37.719262719168896 -122.42773399285299 (37.7192627191689, -122.427733992853)
149925 180515 2 46 1023 Persia Ave 1 1 1 1     14 Width 4ft   6004177.13289 2090077.86698 37.7191925171931 -122.427574815527 (37.7191925171931, -122.427574815527)
173144 180516 2 46 1023 Persia Ave 2 1 1 1     14 Width 4ft   6004155.91588 2090090.6053799998 37.7192262939354 -122.427649061763 (37.7192262939354, -122.427649061763)
54259 180512 2 46 1027 Persia Ave 1 1 1 1     15 Width 3ft   6004254.69534 2090025.2040000001 37.71905230300529 -122.427302962162 (37.7190523030053, -122.427302962162)
65179 180513 2 46 1027 Persia Ave 2 1 1 1     15 Width 3ft   6004235.638830001 2090036.93621 37.719083439333204 -122.427369668478 (37.7190834393332, -122.427369668478)
168800 180514 3 46 1027 Persia Ave 3 1 1 2     14 Width 4ft   6004210.581680001 2090053.8218900003 37.7191283865346 -122.427457483699 (37.7191283865346, -122.427457483699)
91459 119712 3 46 102x Octavia St Frontage East 5 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
101446 119713 3 46 102x Octavia St Frontage East 6 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
103389 119708 3 46 102x Octavia St Frontage East 1 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
108290 119716 3 46 102x Octavia St Frontage East 9 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
110953 119719 3 46 102x Octavia St Frontage East 12 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
122353 119718 3 46 102x Octavia St Frontage East 11 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
124457 119717 3 46 102x Octavia St Frontage East 10 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
128093 119709 3 46 102x Octavia St Frontage East 2 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
128531 119710 3 46 102x Octavia St Frontage East 3 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
141876 119711 3 46 102x Octavia St Frontage East 4 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
145232 119714 3 46 102x Octavia St Frontage East 7 11 1 2           2109802.0 6005691.0 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)
12487 17616 3 46 1030 Persia Ave 1 1 1 2     12 3x3   6004194.38835 2090014.0443400003 37.719018250172 -122.42751062553499 (37.719018250172, -122.427510625535)
19037 7013 1 46 1031 Fell St 1 1 1 1   10/02/1997 12:00:00 AM 8 3X3   6002426.7807 2110189.6116 37.774315477420295 -122.435062751747 (37.7743154774203, -122.435062751747)
8472 46875 1 46 1031 Pacific Ave 1 1 1 1 1 04/26/2002 12:00:00 AM 10 3x4 Permit Number 44938 6009178.55411 2118013.02984 37.7961777714378 -122.412260097639 (37.7961777714378, -122.412260097639)
96794 137038 2 46 1034 Sacramento St 2 1 1 1     1 Width 3ft   6009796.46818 2116817.7113799998 37.792930371678096 -122.41003755358801 (37.7929303716781, -122.410037553588)
158256 137041 2 46 1034 Sacramento St 5 1 1 1     1 Width 3ft   6009697.84819 2116804.05029 37.7928873337267 -122.41037782017901 (37.7928873337267, -122.410377820179)
166414 137039 2 46 1034 Sacramento St 3 1 1 1     1 Width 3ft   6009772.70737 2116813.88249 37.7929185267084 -122.410119497111 (37.7929185267084, -122.410119497111)
172370 137040 2 46 1034 Sacramento St 4 1 1 1     1 Width 3ft   6009716.374480001 2116806.1167599997 37.7928940462749 -122.410313864011 (37.7928940462749, -122.410313864011)
Powered by Datasette · Query took 21.604ms · Data source: data.sfgov.org