sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
4215 118354 3 109 100X Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 3              
4374 118351 3 109 100X Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 3              
5429 118350 3 109 100X Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 3              
5643 118347 3 109 100X Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 3              
5661 118352 3 109 100X Guerrero St 7 11 1 2   07/15/2016 06:56:00 AM 3              
86391 184203 2 109 1466 41st Ave 1 1 1 1     1 Width 0ft   5983430.71 2105161.519 37.75941282066329 -122.500400782356 (37.7594128206633, -122.500400782356)
129415 43734 1 109 777 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.46176829730601 (37.7181537802459, -122.461768297306)
105304 43729 1 109 763 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638)
59935 203290 2 109 11 Jules Ave 2 1 1 1     5 Width 2ft   5994415.40381 2090011.1413599998 37.7184523203103 -122.46131232093201 (37.7184523203103, -122.461312320932)
55253 203291 2 109 11 Jules Ave 3 1 1 1     4 Width 2ft   5994415.48252 2089998.39973 37.7184173393668 -122.461311125716 (37.7184173393668, -122.461311125716)
90094 54118 1 109 760 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
111021 43728 1 109 760 Lakeview Ave 4 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
112173 43727 1 109 760 Lakeview Ave 3 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
141030 43726 1 109 760 Lakeview Ave 2 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
83271 43725 1 109 759 Lakeview Ave 2 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
86576 43724 1 109 759 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
45394 203292 2 109 10 Jules Ave 2 1 1 1     2 Width 2ft   5994458.02189 2089982.3581700001 37.7183757412389 -122.461162923744 (37.7183757412389, -122.461162923744)
179284 221563 2 109 4286 23rd St 4 1 1 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
179875 221564 2 109 4286 23rd St 3 1 1 1     1 Width 3ft   6001316.917769999 2102341.7359599997 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582)
158034 221565 2 109 4286 23rd St 2 1 1 1     1 Width 3ft   6001328.916669999 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381)
55535 221566 2 109 4286 23rd St 1 1 1 1     1 Width 3ft   6001342.8820400005 2102344.46852 37.7527130350975 -122.43825001643299 (37.7527130350975, -122.438250016433)
184620 221570 2 109 117 Alpine Ter 1 1 1 1     1 Width 3ft   6001705.56397 2108155.3423 37.768688901296294 -122.437411868978 (37.7686889012963, -122.437411868978)
41267 221568 2 109 359 Diamond St 1 1 1 1     4 Width 3ft   6001813.22675 2103761.96483 37.7566318794794 -122.436724942504 (37.7566318794794, -122.436724942504)
80086 37574 1 109 30 Collingwood St 1 1 1 1 1 08/15/2014 12:00:00 AM 3   Permit Number 773155 6001973.00287599 2105680.02476784 37.7619074866084 -122.43630964556101 (37.7619074866084, -122.436309645561)
35135 56924 1 109 140 Tingley St 1 1 1 1   08/15/1974 12:00:00 AM 3   Permit Number 14167 6002240.5096 2093994.70553 37.7298375431559 -122.434548888919 (37.7298375431559, -122.434548888919)
51201 221569 2 109 616 Noe St 1 1 1 1     8 Width 3ft   6003001.08037 2104529.5167 37.7588068286936 -122.432671745707 (37.7588068286936, -122.432671745707)
144269 56594 1 109 533 Laidley St 1 1 1 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224.0 2096098.0 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259)
145556 66265 1 109 4020 26th St 1 1 1 1   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344)
31521 175079 3 109 1104x Alemany Blvd 1 3 1 2     1 Width 10ft   6003837.73065 2094453.4628599999 37.7311877286109 -122.42905980937599 (37.7311877286109, -122.429059809376)
155244 221567 2 109 324 Hill St 1 1 1 1     4 Width 3ft   6004154.58593 2103373.98314 37.7556993571514 -122.428600021096 (37.7556993571514, -122.428600021096)
29150 221508 2 109 1201 San Jose Ave 15 7 1 1     1     6004291.813569999 2095940.5809 37.73529671397821 -122.427595874056 (37.7352967139782, -122.427595874056)
63120 105071 6 109 1808 Vallejo St 1 7 1 1     3   Permit Number 771033 6004794.05676 2118138.55822 37.796275437823894 -122.427440299436 (37.7962754378239, -122.427440299436)
46563 221509 2 109 1201 San Jose Ave 38 7 1 1     2     6004439.440880001 2096038.0117799998 37.735572586401894 -122.42709240931102 (37.7355725864019, -122.427092409311)
75755 115513 3 109 200x Guerrero St 4 11 1 2   02/09/2016 11:41:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
80319 115517 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
86793 115518 3 109 200x Guerrero St 9 11 1 2   02/09/2016 12:33:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
97329 115520 3 109 200x Guerrero St 11 11 1 2   02/09/2016 10:50:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
98416 115516 3 109 200x Guerrero St 7 11 1 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
105439 115510 3 109 200x Guerrero St 1 11 1 2   02/09/2016 12:55:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
105592 115519 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
106984 115515 3 109 200x Guerrero St 6 11 1 2   02/09/2016 11:34:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
118209 115511 3 109 200x Guerrero St 2 11 1 2   02/09/2016 12:48:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
118657 115521 3 109 200x Guerrero St 12 11 1 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
146089 115514 3 109 200x Guerrero St 5 11 1 2   02/09/2016 11:36:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
787 221428 3 109 100x Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.769467407522896 -122.424551705821 (37.7694674075229, -122.424551705821)
745 221429 3 109 100x Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 1 Width 3ft   6005428.96653 2108339.30361 37.76940499098671 -122.424545983407 (37.7694049909867, -122.424545983407)
772 221430 3 109 100x Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 1 Width 3ft   6005430.67341 2108312.23866 37.7693307735195 -122.424538153922 (37.7693307735195, -122.424538153922)
766 221431 3 109 100x Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 1 Width 3ft   6005433.2519 2108280.1340799998 37.769242767658 -122.424526951068 (37.769242767658, -122.424526951068)
754 221432 3 109 100x Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 1 Width 3ft   6005434.00046 2108253.10785 37.769168602384205 -122.42452243915301 (37.7691686023842, -122.424522439153)
733 221433 3 109 100x Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 1 Width 3ft   6005435.4614 2108218.9893400003 37.7690750036386 -122.42451495861201 (37.7690750036386, -122.424514958612)
759 221434 3 109 100x Guerrero St 7 11 1 2   07/15/2016 06:56:00 AM 1 Width 3ft   6005437.11129 2108190.56795 37.7689970584876 -122.42450722982001 (37.7689970584876, -122.42450722982)
727 221435 3 109 100x Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.768908269319795 -122.424501499347 (37.7689082693198, -122.424501499347)
737 221436 3 109 100x Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 1 Width 3ft   6005440.21619 2108132.10005 37.768836694985396 -122.424492330751 (37.7688366949854, -122.424492330751)
773 221437 3 109 100x Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.3361400003 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027)
75610 221438 3 109 100x Guerrero St 11 11 1 2     2 Width 3ft   6005446.19377 2108068.2932700003 37.7686618344154 -122.42446711555901 (37.7686618344154, -122.424467115559)
159995 221439 3 109 100x Guerrero St 12 11 1 2     1 Width 3ft   6005446.76573 2108031.65533 37.768561267704705 -122.424462530821 (37.7685612677047, -122.424462530821)
42902 221440 3 109 100x Guerrero St 13 11 1 2     1 Width 3ft   6005447.60224 2108007.88033 37.7684960344855 -122.424457946087 (37.7684960344855, -122.424457946087)
133864 221441 3 109 100x Guerrero St 14 11 1 2     1 Width 3ft   6005450.56053 2107974.49254 37.768404526663396 -122.424445338474 (37.7684045266634, -122.424445338474)
148926 221442 3 109 100x Guerrero St 15 11 1 2     1 Width 3ft   6005450.9028900005 2107942.8086599996 37.768317549645 -122.42444190036699 (37.768317549645, -122.424441900367)
171233 221443 3 109 100x Guerrero St 16 11 1 2     1 Width 3ft   6005451.42839 2107920.02985 37.7682550341586 -122.42443846228599 (37.7682550341586, -122.424438462286)
4411 221455 3 109 200x Guerrero St 1 11 1 2   02/09/2016 12:55:00 PM 1 Width 3ft   6005458.8795300005 2107745.71785 37.7677768358576 -122.424400289657 (37.7677768358576, -122.424400289657)
4371 221454 3 109 200x Guerrero St 2 11 1 2   02/09/2016 12:48:00 PM 1 Width 3ft   6005462.2492 2107712.58298 37.7676860457059 -122.42438627731501 (37.7676860457059, -122.424386277315)
81008 110625 3 109 400X GUERRERO ST 8 11 1 2   04/29/2015 10:13:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
81226 110627 3 109 400X GUERRERO ST 10 11 1 2   04/29/2015 05:29:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
81262 110626 3 109 400X GUERRERO ST 9 11 1 2   04/29/2015 09:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
85719 110619 3 109 400X GUERRERO ST 2 11 1 2   04/29/2015 10:33:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
86005 110628 3 109 400X GUERRERO ST 11 11 1 2   04/29/2015 05:18:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
90408 110621 3 109 400X GUERRERO ST 4 11 1 2   04/29/2015 10:27:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
91609 110624 3 109 400X GUERRERO ST 7 11 1 2   04/29/2015 10:16:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
95136 110618 3 109 400X GUERRERO ST 1 11 1 2   04/29/2015 10:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
100063 110650 3 109 400X GUERRERO ST 13 11 1 2   04/29/2015 05:03:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
104357 110622 3 109 400X GUERRERO ST 5 11 1 2   04/29/2015 10:24:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
120306 110649 3 109 400X GUERRERO ST 12 11 1 2   04/28/2015 07:46:00 PM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
128230 110620 3 109 400X GUERRERO ST 3 11 1 2   04/29/2015 10:30:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
129058 110623 3 109 400X GUERRERO ST 6 11 1 2   04/29/2015 10:20:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
4392 221453 3 109 200x Guerrero St 3 11 1 2   02/09/2016 12:40:00 PM 1 Width 3ft   6005462.88888 2107675.99901 37.7675856309877 -122.424381462352 (37.7675856309877, -122.424381462352)
4420 221452 3 109 200x Guerrero St 4 11 1 2   02/09/2016 11:41:00 AM 1 Width 3ft   6005465.56003 2107641.57919 37.7674912732207 -122.42436977475501 (37.7674912732207, -122.424369774755)
4377 221451 3 109 200x Guerrero St 5 11 1 2   02/09/2016 11:36:00 AM 1 Width 3ft   6005468.550009999 2107589.96825 37.76734973074429 -122.424355761536 (37.7673497307443, -122.424355761536)
4431 221450 3 109 200x Guerrero St 6 11 1 2   02/09/2016 11:34:00 AM 1 Width 3ft   6005469.47774 2107557.31332 37.7672601204903 -122.424350229795 (37.7672601204903, -122.424350229795)
25703 221449 3 109 200x Guerrero St 7 11 1 2     1 Width 3ft   6005469.95975 2107527.1833200003 37.767177417921 -122.42434641935499 (37.767177417921, -122.424346419355)
4326 221448 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 1 Width 3ft   6005473.21673 2107488.5662700003 37.767071568632105 -122.42433240701 (37.7670715686321, -122.42433240701)
4348 221447 3 109 200x Guerrero St 9 11 1 2   02/09/2016 12:33:00 PM 1 Width 3ft   6005477.00515 2107432.0079200002 37.7669164868187 -122.424315280345 (37.7669164868187, -122.424315280345)
88573 109696 3 109 600x GUERRERO ST 4 11 1 2   02/21/2015 10:57:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
91073 109698 3 109 600x GUERRERO ST 6 11 1 2   02/28/2015 11:01:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
92681 109700 3 109 600x GUERRERO ST 8 11 1 2   02/21/2015 11:08:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
95444 109697 3 109 600x GUERRERO ST 5 11 1 2   02/21/2015 10:59:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
106423 109703 3 109 600x GUERRERO ST 11 11 1 2   02/21/2015 11:05:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
107320 109701 3 109 600x GUERRERO ST 9 11 1 2   02/21/2015 11:07:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
110419 109704 3 109 600x GUERRERO ST 12 11 1 2   02/28/2015 10:40:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118317 109694 3 109 600x GUERRERO ST 2 11 1 2   02/21/2015 10:54:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
123889 109693 3 109 600x GUERRERO ST 1 11 1 2   02/21/2015 10:53:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
126273 109695 3 109 600x GUERRERO ST 3 11 1 2   02/21/2015 12:00:00 AM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
142527 109699 3 109 600x GUERRERO ST 7 11 1 2   02/28/2015 11:10:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
144040 109702 3 109 600x GUERRERO ST 10 11 1 2   02/21/2015 11:06:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
4359 221446 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 1 Width 3ft   6005477.30623 2107402.8649 37.7668364840384 -122.424312165974 (37.7668364840384, -122.424312165974)
4362 221445 3 109 200x Guerrero St 11 11 1 2   02/09/2016 10:50:00 AM 1 Width 3ft   6005479.31495 2107369.2041700003 37.7667441731271 -122.424302823815 (37.7667441731271, -122.424302823815)
Powered by Datasette · Query took 5.392ms · Data source: data.sfgov.org