sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6478 98738 2 5 1150 Scott St 2 1 1 20 2   3 4X4   6001885.6171 2112431.4484 37.780440254610205 -122.43709527307301 (37.7804402546102, -122.437095273073)
102473 95360 3 5 775X Broadway 3 1 1 20 2   12 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
111421 95362 3 5 775X Broadway 2 1 1 20 2     3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
112944 95359 3 5 775X Broadway 5 1 1 20 2   12 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
114297 95361 3 5 775X Broadway 4 1 1 20 2   10 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
114699 98740 2 5 1150 Scott St 4 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
118079 95358 3 5 775X Broadway 1 1 1 20 2   25 3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
126442 95363 3 5 775X Broadway 6 1 1 20 2   20 3x3   6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
126702 98737 2 5 1150 Scott St 1 1 1 20 2   24 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
128761 98739 2 5 1150 Scott St 3 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
79124 11774 1 5 1199X Junipero Serra Blvd 19 1 1 13     18 2x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
91193 11791 1 5 1199X Junipero Serra Blvd 14 1 1 13     30 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
92042 11788 1 5 1199X Junipero Serra Blvd 8 1 1 13     18 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
96683 11823 1 5 1299X Junipero Serra Blvd 15 1 1 13     24 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
102978 11789 1 5 1199X Junipero Serra Blvd 10 1 1 13     24 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
111936 11787 1 5 1199X Junipero Serra Blvd 6 1 1 13     12 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
112455 11817 1 5 1201X Junipero Serra Blvd 3 1 1 13     12 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
118852 11820 1 5 1299X Junipero Serra Blvd 7 1 1 13     12 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
121435 11773 1 5 1199X Junipero Serra Blvd 18 1 1 13     18 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
122991 11815 1 5 1201X Junipero Serra Blvd 1 1 1 13     6 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
16744 6812 1 5 1400X Fairfax Ave 4 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016477.270719999 2097595.73141 37.740523142935096 -122.385581175844 (37.7405231429351, -122.385581175844)
53801 6629 1 5 1415 Evans Ave 12 1 1 11   05/16/2013 12:00:00 AM 17 4x4   6016652.34226 2097729.17939 37.7408992492988 -122.38498513575001 (37.7408992492988, -122.38498513575)
79905 6621 1 5 1415 Evans Ave 4 1 1 11     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093)
81179 6632 1 5 1415 Evans Ave 15 1 1 11     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093)
118616 6824 1 5 1450X Fairfax Ave 4 1 1 11     18 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
128827 6631 1 5 1415 Evans Ave 14 1 1 11   02/15/2001 12:00:00 AM 18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093)
79317 95366 3 5 3101X Van Ness Ave 1 1 1 10 6   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.42518303152201 (37.8041229057048, -122.425183031522)
133148 49664 3 5 3630 Divisadero St 5 1 1 10   04/18/2011 12:00:00 AM 26   Permit Number 46510 6000238.4271 2120737.0669299997 37.80315153908379 -122.44339041353399 (37.8031515390838, -122.443390413534)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
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)
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)
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)
1407 220312 3 5 4235 19th St 7 1 1 4   08/05/1995 12:00:00 AM 15 Width 3ft   6002007.42492 2104678.29116 37.759158924972404 -122.436118906483 (37.7591589249724, -122.436118906483)
1431 220311 3 5 4235 19th St 4 1 1 4   08/05/1995 12:00:00 AM 18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151)
4568 142545 3 5 301 FRANCISCO ST 7 1 1 4     20 Width 0ft   6009562.3577 2121186.5007 37.80491286675579 -122.41115633279499 (37.8049128667558, -122.411156332795)
4570 142547 3 5 301 FRANCISCO ST 9 1 1 4     20 Width 0ft   6009612.5597 2121193.6724 37.804935373675605 -122.41098310943799 (37.8049353736756, -122.410983109438)
77569 98569 3 5 301X Francisco St 7 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
79583 73289 3 5 1600X GREEN ST 6 1 1 4 2 11/20/1999 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
80033 96215 3 5 200X Collingwood St 3 1 1 4 2   26 4x4   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
81902 96211 3 5 201X Diamond St 3 1 1 4 2   14 4x4   6001762.6 2104666.8 37.759113460692 -122.43696480408701 (37.759113460692, -122.436964804087)
85600 93121 3 5 151X Palm Ave 11 1 1 4 2   9 3x3   5995892.67419 2113127.59534 37.7820092173573 -122.457877934554 (37.7820092173573, -122.457877934554)
86000 102186 2 5 3999X Folsom St 1 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
90252 96214 3 5 200X Collingwood St 2 1 1 4 2   20 3x3   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
96597 42644 3 5 1600X GREEN ST 3 1 1 4 2 06/26/2000 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
98830 96212 3 5 201X Diamond St 4 1 1 4 2   14 4x4   6001762.6 2104666.8 37.759113460692 -122.43696480408701 (37.759113460692, -122.436964804087)
99139 74759 3 5 250 Foerster St 13 5 1 4 2 05/15/1999 12:00:00 AM 30 5x7   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
100783 73287 3 5 1600X GREEN ST 8 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
105706 96216 3 5 200X Collingwood St 4 1 1 4 2   6 4x4   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
108653 73528 3 5 4235 19th St 7 1 1 4 2 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342)
111189 98571 3 5 301X Francisco St 9 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
118717 102187 2 5 3999X Folsom St 2 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
124535 73286 3 5 1600X GREEN ST 9 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
127279 71177 3 5 4235 19th St 4 1 1 4 2 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342)
128247 116052 2 5 650x KANSAS ST 8 1 1 4 2     4x4   6011530.0 2105347.0 37.761531458187 -122.403232137637 (37.761531458187, -122.403232137637)
129870 116056 2 5 650x Kansas St 12 1 1 4 2   23 4x4   6011515.191980001 2105171.68257 37.7610492486475 -122.40327101944901 (37.7610492486475, -122.403271019449)
139596 73288 3 5 1600X GREEN ST 7 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
140357 73285 3 5 1600X GREEN ST 10 1 1 4 2 11/20/1999 12:00:00 AM 13 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
142663 42642 3 5 1600X GREEN ST 1 1 1 4 2 06/26/2000 12:00:00 AM 5 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
144074 92957 1 5 300 Seneca Ave 2 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
145041 92956 1 5 300 Seneca Ave 1 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
31 22614 1 5 1001 Turk St 5 1 1 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
85 22613 1 5 1001 Turk St 4 1 1 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
1909 125218 1 5 2101 Washington St 21 1 1 3     13 Width 4ft   6005090.35688 2116771.11072 37.7925375271472 -122.42631763077499 (37.7925375271472, -122.426317630775)
8575 22617 1 5 1001 Turk St 8 1 1 3   03/25/1997 12:00:00 AM 6 3x5   6005634.7978 2112724.8918 37.781458374599794 -122.424145957729 (37.7814583745998, -122.424145957729)
10993 764 1 5 1200X 37th Ave 1 1 1 3     12 3   5984614.2914 2106873.7688 37.76418358274471 -122.496433785178 (37.7641835827447, -122.496433785178)
79616 24935 1 5 2099X Post St 12 1 1 3     3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
82591 24927 1 5 2099X Post St 3 1 1 3     36 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
83248 24932 1 5 2099X Post St 8 1 1 3   02/22/1996 12:00:00 AM 18 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
88695 104451 5 5 2490X Folsom St 6 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
88826 22610 1 5 1001 Turk St 1 1 1 3     30 3X5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
91930 113799 2 5 695x SHOTWELL ST 3 1 1 3       4x4   6008062.0 2103972.0 37.757561731467 -122.415129229314 (37.757561731467, -122.415129229314)
92561 104449 5 5 2490X Folsom St 4 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
93328 24934 1 5 2099X Post St 10 1 1 3   09/28/1999 12:00:00 AM 24 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
95715 20475 1 5 1203X Sunset Blvd 9 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
97092 5467 1 5 600X Dolores St 7 1 1 3     48     6004918.892342701 2104703.9652182 37.7593943997498 -122.426051479658 (37.7593943997498, -122.426051479658)
98214 113797 2 5 695x SHOTWELL ST 1 1 1 3       4x4   6008062.0 2103972.0 37.757561731467 -122.415129229314 (37.757561731467, -122.415129229314)
101610 20510 1 5 1211X Sunset Blvd 6 1 1 3     18 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
107042 24929 1 5 2099X Post St 5 1 1 3     24 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
113430 24924 1 5 2199X Post St 4 1 1 3     12 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
117968 5435 1 5 500X Dolores St 3 1 1 3     90 6   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
120636 22615 1 5 1001 Turk St 6 1 1 3     24 3x5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
121073 113798 2 5 695x SHOTWELL ST 2 1 1 3       4x4   6008062.0 2103972.0 37.757561731467 -122.415129229314 (37.757561731467, -122.415129229314)
122322 105909 2 5 1864X 14TH AVE 1 3 1 3     14     5991829.0 2102804.0 37.7534290869332 -122.47118388851999 (37.7534290869332, -122.47118388852)
123025 20477 1 5 1203X Sunset Blvd 11 1 1 3     6 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
126289 22618 1 5 1001 Turk St 9 1 1 3     24 3x5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
141366 24933 1 5 2099X Post St 9 1 1 3     6 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
142153 113800 2 5 695x SHOTWELL ST 4 1 1 3       4x4   6008062.0 2103972.0 37.757561731467 -122.415129229314 (37.757561731467, -122.415129229314)
5 188702 3 5 1501 Evans Ave 2 4 1 2     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263)
7 188697 3 5 1301 Evans Ave 13 4 1 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
29 188686 3 5 1300 Evans Ave 20 4 1 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
105 6251 3 5 1315 Ellis St 1 1 1 2   12/06/2003 12:00:00 AM 24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144)
341 14553 3 5 875 Masonic Ave 1 1 1 2     60 3X3   5999239.2853 2109883.9856 37.7732947980524 -122.446066856713 (37.7732947980524, -122.446066856713)
613 20019 3 5 100 STAIRWAY48 3 1 1 2     6 10ST            
854 203901 3 5 3794 19th Ave 3 2 1 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
Powered by Datasette · Query took 16.049ms · Data source: data.sfgov.org