sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
108522 113066   47 2X Cranleigh Dr 7 4 1 2   09/09/2015 01:08:00 PM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
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)
82039 116084 1 47 127 Edgehill Way 1 9 1 1       10x10 Permit Number 773426 5994851.1 2098962.7 37.7430561859317 -122.46045458158301 (37.7430561859317, -122.460454581583)
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)
98538 98820 1 47 302X Pacheco St 28 11 1 1   05/09/2010 12:00:00 AM     Permit Number 768820 5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
104759 87819 1 47 390 Lansdale Ave 1 8 1 1         Permit Number 50681 5995630.7 2096410.1 37.736092191921294 -122.457574304331 (37.7360921919213, -122.457574304331)
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)
110058 91138 1 47 166 Kensington Way 1 2 1 1       3x3 Permit Number 52026 5994670.3 2098755.2 37.742476040106396 -122.46106469780199 (37.7424760401064, -122.461064697802)
110349 91139 1 47 166 Kensington Way 2 2 1 1       3x3 Permit Number 52026 5994670.3 2098755.2 37.742476040106396 -122.46106469780199 (37.7424760401064, -122.461064697802)
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)
115560 109453 1 47 951 GILMAN AVE 1 7 1 3   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955)
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)
119522 99047 1 47 240@Casitas Lansdale Ave 1 5 1 1     42   Permit Number 768724 5994955.6 2096712.9 37.736884803366706 -122.459930310697 (37.7368848033667, -122.459930310697)
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)
121692 98378 1 47 199X Cragmont Ave 3 14 1 1         Permit Number 768647 5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
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)
134629 45072 1 47 580 De Haro St 1 9 1 1     17   Permit Number 770844 6012040.04022 2105787.48822 37.7627694124935 -122.401499066356 (37.7627694124935, -122.401499066356)
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)
549 251321 2 47 100X Monument Way 1 14 1 1                    
782 251385 2 47 138x Gladeview Way 2 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
784 251384 2 47 138x Gladeview Way 1 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
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)
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
1029 251428 2 47 5030 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1398 251517 2 47 145 Bonview St 1 13 1 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1605 251634 2 47 14R Amethyst Way 3 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1618 251611 2 47 56R Amber Dr 4 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 2 47 64R Amber Dr 4 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1624 251624 2 47 76R Amber Dr 2 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1625 251623 2 47 76R Amber Dr 1 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 2 47 18R Amethyst Way 1 13 1 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1633 251599 2 47 740 Moraga St 1 7 1 1       3x3   5992006.0 2103899.0 37.756445907456396 -122.470651540396 (37.7564459074564, -122.470651540396)
1638 251620 2 47 72R Amber Dr 3 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1639 251615 2 47 64R Amber Dr 2 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1640 251622 2 47 72R Amber Dr 5 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1641 251627 2 47 2R Amethyst Way 2 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1643 251614 2 47 64R Amber Dr 1 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1736 251677 2 47 772x Panorama Dr 1 9 1 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
3044 253288 2 47 650 Peru Ave 4 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
Powered by Datasette · Query took 16.666ms · Data source: data.sfgov.org