sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
34305 20466 1 2 1202X Sunset Blvd 5 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
54999 75092 2 2 288 Eddy St 5 1 1 3   09/16/1989 12:00:00 AM 16     6009056.34359 2113588.95965 37.7840234906369 -122.41237011169201 (37.7840234906369, -122.412370111692)
80523 20465 1 2 1202X Sunset Blvd 4 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
100327 20463 1 2 1202X Sunset Blvd 2 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
105704 20464 1 2 1202X Sunset Blvd 3 1 1 3   06/05/1997 12:00:00 AM 3 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
106691 25411 1 2 895X Mansell St 1 1 1 3     12 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
108952 13376 1 2 1000X Mansell St 2 1 1 3     6 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
109944 13381 1 2 1000X Mansell St 7 1 1 3     18 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
110546 25416 1 2 895X Mansell St 6 1 1 3     18 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
112414 110047 2 2 290 Eddy St 7 1 1 3           6009037.88726419 2113590.00375699 37.7840253217877 -122.412434037929 (37.7840253217877, -122.412434037929)
112463 20462 1 2 1202X Sunset Blvd 1 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
112727 25417 1 2 895X Mansell St 7 1 1 3     12 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
113947 13383 1 2 1000X Mansell St 9 1 1 3     18 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
66190 20482 1 3 1204 Sunset Blvd 3 1 1 3     42 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
78201 20481 1 3 1204 Sunset Blvd 2 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
80410 20503 1 3 1204 Sunset Blvd 24 1 1 3     12 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
82693 20498 1 3 1204 Sunset Blvd 19 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
87086 20486 1 3 1204 Sunset Blvd 7 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
90425 20506 1 3 1211X Sunset Blvd 2 1 1 3     24 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
99272 20491 1 3 1204 Sunset Blvd 12 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
99897 20497 1 3 1204 Sunset Blvd 18 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
102283 20490 1 3 1204 Sunset Blvd 11 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
104110 20487 1 3 1204 Sunset Blvd 8 1 1 3     12 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
104532 20502 1 3 1204 Sunset Blvd 23 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
105140 20485 1 3 1204 Sunset Blvd 6 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
105238 20492 1 3 1204 Sunset Blvd 13 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
107034 20493 1 3 1204 Sunset Blvd 14 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
113460 20494 1 3 1204 Sunset Blvd 15 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
115936 20480 1 3 1204 Sunset Blvd 1 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
119828 20484 1 3 1204 Sunset Blvd 5 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
121001 20500 1 3 1204 Sunset Blvd 21 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
123341 117622 2 3 890x VERMONT ST 1 7 1 3           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
139137 20489 1 3 1204 Sunset Blvd 10 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
144600 20499 1 3 1204 Sunset Blvd 20 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
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)
87911 29065 1 6 1001X McAllister St 1 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004375.703483 2111849.9138356997 37.7789847305516 -122.42843943238 (37.7789847305516, -122.42843943238)
113978 29066 1 6 1001X McAllister St 2 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004375.703483 2111849.9138356997 37.7789847305516 -122.42843943238 (37.7789847305516, -122.42843943238)
123177 6288 1 6 1700X Ellis St 2 1 1 3   01/28/2013 12:00:00 AM   4x3 Permit Number 768629 6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
6201 87987 1 11 300x Jones St 5 1 1 3   04/23/2015 03:33:00 PM 3 3x3 Permit Number 51027 6008990.567000001 2113714.34992 37.7843640908799 -122.41260654257201 (37.7843640908799, -122.412606542572)
6217 83680 1 11 300X Jones St 4 1 1 3   04/23/2015 03:26:00 PM 3     6008994.04445 2113694.03545 37.784308507385504 -122.412593075226 (37.7843085073855, -122.412593075226)
18569 9792 1 11 997X Gough St 3 1 1 3     36 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
19639 9777 1 11 897X Gough St 5 1 1 3     30 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
50158 20507 1 11 1211X Sunset Blvd 3 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
78103 22400 1 11 5755X 03rd St 3 1 1 3     5 4X4   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
78217 22401 1 11 5755X 03rd St 4 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
83331 9776 1 11 897X Gough St 4 1 1 3     30 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
85752 20509 1 11 1211X Sunset Blvd 5 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
88734 26148 1 11 1500 Oakdale Ave 18 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
93843 26146 1 11 1500 Oakdale Ave 16 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
95897 20508 1 11 1211X Sunset Blvd 4 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
96327 9794 1 11 997X Gough St 5 1 1 3     26 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
98448 26147 1 11 1500 Oakdale Ave 17 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
99178 9800 1 11 997X Gough St 11 1 1 3   03/30/2006 12:00:00 AM 3 3X3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
105542 9791 1 11 997X Gough St 2 1 1 3     24 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
105626 22399 1 11 5755X 03rd St 2 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
106297 9775 1 11 897X Gough St 3 1 1 3     40 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
106561 9778 1 11 897X Gough St 6 1 1 3     30 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
108052 101312 2 11 4244X 19th St 5 1 1 3     12 4x4   6001912.0 2104709.0 37.7592378221466 -122.43645112889901 (37.7592378221466, -122.436451128899)
108709 6291 1 11 1700X Ellis St 10 1 1 3   01/04/2008 12:00:00 AM 3 4x4   6002728.2699376 2113059.4201816004 37.7822123689276 -122.43422505132601 (37.7822123689276, -122.434225051326)
109267 26145 1 11 1500 Oakdale Ave 15 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
109810 9782 1 11 897X Gough St 10 1 1 3   02/25/1997 12:00:00 AM 12 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
110369 9799 1 11 997X Gough St 10 1 1 3   03/30/2006 12:00:00 AM 30 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
111357 96617 6 11 3555@ Valencia 19th St 251 26 1 3         Permit Number 771218 6006277.0 2104934.0 37.7601026853586 -122.42137080656 (37.7601026853586, -122.42137080656)
112097 26150 1 11 1500 Oakdale Ave 20 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
114182 9793 1 11 997X Gough St 4 1 1 3     40 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
114266 9773 1 11 897X Gough St 1 1 1 3   02/25/1997 12:00:00 AM 18 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
117126 9781 1 11 897X Gough St 9 1 1 3     18 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
117973 9795 1 11 997X Gough St 6 1 1 3     26 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
123639 9780 1 11 897X Gough St 8 1 1 3     24 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
124786 22398 1 11 5755X 03rd St 1 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
126377 9774 1 11 897X Gough St 2 1 1 3   05/26/1992 12:00:00 AM 34 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
128126 9796 1 11 997X Gough St 7 1 1 3   03/08/2006 12:00:00 AM   3X3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
129343 9783 1 11 897X Gough St 11 1 1 3     6 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
139364 96618 6 11 3555@ 19th St 19th St 268 26 1 3         Permit Number 771218 6006277.0 2104934.0 37.7601026853586 -122.42137080656 (37.7601026853586, -122.42137080656)
Powered by Datasette · Query took 5.87ms · Data source: data.sfgov.org