sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7193 110906 1 47 2891 Vallejo St 2 1 1 1   05/08/2015 12:00:00 AM 3 3x10 Permit Number 775210 5999784.0596900005 2117390.4095799997 37.7939365889551 -122.44472206489799 (37.7939365889551, -122.444722064898)
19685 92559 1 47 222 Stanyan St 1 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
24419 20488 1 47 1204 Sunset Blvd 9 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
42268 53726 1 47 100 Topeka Ave 1 1 1 1   01/07/1972 12:00:00 AM 8   Permit Number 9405 6012451.87174 2095251.14558 37.733861851932296 -122.399334980939 (37.7338618519323, -122.399334980939)
43485 20515 1 47 1211X Sunset Blvd 11 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
72965 99863 1 47 681 47th Ave 1 1 1 1     28     5981324.99313 2111098.19167 37.7755893711796 -122.508123883044 (37.7755893711796, -122.508123883044)
77359 12466 1 47 307 Lake Merced Blvd 11 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
78443 12480 1 47 307 Lake Merced Blvd 25 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
78476 12483 1 47 307 Lake Merced Blvd 28 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
78630 85239 1 47 200 Yerba Buena Ave 2 1 1 1   07/20/2007 12:00:00 AM     Permit Number 49542 5994792.0 2096029.0 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237)
79934 12458 1 47 307 Lake Merced Blvd 3 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
80495 92565 1 47 222 Stanyan St 7 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
81048 20479 1 47 1203X Sunset Blvd 16 1 1 3     24 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
81281 12469 1 47 307 Lake Merced Blvd 14 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
82157 20474 1 47 1203X Sunset Blvd 8 1 1 3     48 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
83377 87064 1 47 101 Arbor St 1 1 1 1   05/30/2007 12:00:00 AM     Permit Number 50006 6001805.0 2096722.0 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043)
83819 92562 1 47 222 Stanyan St 4 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
84240 12484 1 47 307 Lake Merced Blvd 29 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
85296 12456 1 47 307 Lake Merced Blvd 1 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
91597 12475 1 47 307 Lake Merced Blvd 20 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
91646 20468 1 47 1203X Sunset Blvd 2 1 1 3     48 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
92266 20513 1 47 1211X Sunset Blvd 9 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
92632 91152 1 47 166 Kensington Way 3 1 1 1       3x3 Permit Number 52026 5994670.3 2098755.2 37.742476040106396 -122.46106469780199 (37.7424760401064, -122.461064697802)
92932 86903 1 47 233 Drake St 1 1 1 1   10/30/2007 12:00:00 AM   3x3 Permit Number 49863 6001780.0 2086418.0 37.7090074518569 -122.435599089406 (37.7090074518569, -122.435599089406)
93559 12463 1 47 307 Lake Merced Blvd 8 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
93789 20514 1 47 1211X Sunset Blvd 10 1 1 3     48 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
93970 20470 1 47 1203X Sunset Blvd 4 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
96684 12468 1 47 307 Lake Merced Blvd 13 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
96901 12482 1 47 307 Lake Merced Blvd 27 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
98709 12472 1 47 307 Lake Merced Blvd 17 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
100881 12467 1 47 307 Lake Merced Blvd 12 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
101420 20496 1 47 1204 Sunset Blvd 17 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
101961 12461 1 47 307 Lake Merced Blvd 6 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
104160 12471 1 47 307 Lake Merced Blvd 16 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
104492 92563 1 47 222 Stanyan St 5 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
107010 12487 1 47 307 Lake Merced Blvd 32 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
108304 41202 1 47 79 Midcrest Way 1 1 1 1         Permit Number 53043 5998096.00481154 2100748.3020607 37.748145150880795 -122.44936325399401 (37.7481451508808, -122.449363253994)
108403 12459 1 47 307 Lake Merced Blvd 4 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
111079 12465 1 47 307 Lake Merced Blvd 10 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
111984 12478 1 47 307 Lake Merced Blvd 23 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
113400 12491 1 47 307 Lake Merced Blvd 36 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
113404 12479 1 47 307 Lake Merced Blvd 24 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
115085 12473 1 47 307 Lake Merced Blvd 18 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
116167 12481 1 47 307 Lake Merced Blvd 26 1 1 13     36 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
116784 12474 1 47 307 Lake Merced Blvd 19 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
117794 12485 1 47 307 Lake Merced Blvd 30 1 1 13     36 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
118813 12477 1 47 307 Lake Merced Blvd 22 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
118999 92564 1 47 222 Stanyan St 6 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
121516 12486 1 47 307 Lake Merced Blvd 31 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
124901 12497 1 47 307 Lake Merced Blvd 42 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
125657 87116 1 47 470 West Portal Ave 7 1 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
125794 85238 1 47 200 Yerba Buena Ave 1 1 1 1   07/20/2007 12:00:00 AM     Permit Number 49542 5994792.0 2096029.0 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237)
125992 93107 1 47 15 Mesa Ave 1 1 1 1   02/02/2010 12:00:00 AM   3x3 Permit Number 53163 5993680.1 2100698.2 37.747753995799705 -122.46462954455299 (37.7477539957997, -122.464629544553)
126878 92561 1 47 222 Stanyan St 3 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
126959 12498 1 47 307 Lake Merced Blvd 43 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
127369 12460 1 47 307 Lake Merced Blvd 5 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
127792 99864 1 47 681 47th Ave 2 1 1 1         Permit Number 768887 5981306.2 2111092.9 37.775573734396204 -122.508188499048 (37.7755737343962, -122.508188499048)
138304 12489 1 47 307 Lake Merced Blvd 34 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
138346 12464 1 47 307 Lake Merced Blvd 9 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
140349 12462 1 47 307 Lake Merced Blvd 7 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
141644 20495 1 47 1204 Sunset Blvd 16 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
142440 95072 1 47 19 Miguel St 1 1 1 1       3x3 Permit Number 54021 6003434.0 2097382.0 37.7392059633181 -122.430664475135 (37.7392059633181, -122.430664475135)
144723 12470 1 47 307 Lake Merced Blvd 15 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
144772 40713 1 47 2 Crown Ter 1 1 1 1         Permit Number 41692 5998528.84920016 2104703.4154957 37.7590296670037 -122.448151244492 (37.7590296670037, -122.448151244492)
145203 92560 1 47 222 Stanyan St 2 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
145293 12457 1 47 307 Lake Merced Blvd 2 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
145316 12476 1 47 307 Lake Merced Blvd 21 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
961 251408 2 47 75 Christmas Tree Point Rd 1 1 1 1       3x3   5998776.0 2103023.0 37.75442978774979 -122.447175546291 (37.7544297877498, -122.447175546291)
3112 253318 2 47 2 Euclid Ave 16 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3113 253332 2 47 2 Euclid Ave 27 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3115 253329 2 47 2 Euclid Ave 24 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3116 253328 2 47 2 Euclid Ave 23 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3119 253313 2 47 2 Euclid Ave 11 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3120 253308 2 47 2 Euclid Ave 6 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3121 253303 2 47 2 Euclid Ave 1 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3122 253323 2 47 2 Euclid Ave 21 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3123 253306 2 47 2 Euclid Ave 4 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3125 253309 2 47 2 Euclid Ave 7 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3127 253316 2 47 2 Euclid Ave 14 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3128 253330 2 47 2 Euclid Ave 25 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3129 253317 2 47 2 Euclid Ave 15 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3130 253319 2 47 2 Euclid Ave 17 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3131 253310 2 47 2 Euclid Ave 8 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3133 253333 2 47 2 Euclid Ave 28 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3135 253335 2 47 2 Euclid Ave 30 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3136 253320 2 47 2 Euclid Ave 18 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3139 253322 2 47 2 Euclid Ave 20 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3140 253334 2 47 2 Euclid Ave 29 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3141 253311 2 47 2 Euclid Ave 9 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3143 253336 2 47 2 Euclid Ave 31 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3145 253304 2 47 2 Euclid Ave 2 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3146 253314 2 47 2 Euclid Ave 12 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3148 253327 2 47 2 Euclid Ave 22 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3150 253331 2 47 2 Euclid Ave 26 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3151 253312 2 47 2 Euclid Ave 10 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3152 253307 2 47 2 Euclid Ave 5 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3153 253315 2 47 2 Euclid Ave 13 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3155 253305 2 47 2 Euclid Ave 3 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3156 253321 2 47 2 Euclid Ave 19 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
9172 173599 2 47 100X Warren Dr 1 1 1 1     20 3x3   5995367.0 2102770.0 37.7535397418859 -122.458946354326 (37.7535397418859, -122.458946354326)
22920 251148 2 47 625 Brotherhood Way 1 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
Powered by Datasette · Query took 103.508ms · Data source: data.sfgov.org