sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2489 119760 3 35 101X Octavia St Frontage West 2 1 1 2       4x4            
2492 119762 3 35 101X Octavia St Frontage West 4 1 1 2       4x4            
2501 119761 3 35 101X Octavia St Frontage West 3 1 1 2       4x4            
2508 119759 3 35 101X Octavia St Frontage West 1 1 1 2       4x4            
3013 39333 1 35 0 21st St 3 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
3019 20034 3 16 100 STAIRWAY51 5 1 1 2     3 ST            
3403 19880 3 198 100 STAIRWAY33 12 1 1 2     6 25ST            
3610 115725 2 198 250X Octavia St 2 17 1 5                    
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
4106 20001 3 198 100 STAIRWAY46 21 1 1 2     6 2            
4351 36746 1 16 5555 Woodward St 1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39516          
5302 35167 1 16 240 Walter St 1 1 1 1   02/02/1998 12:00:00 AM     Permit Number 38700          
5325 40088 1 84   1 1 1 1   03/09/1999 12:00:00 AM     Permit Number 41311          
5373 31852 1 35 1117 Houston St 2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35299          
5518 39334 1 35 0 21st St 4 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
5746 31847 1 16   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
6573 19697 3 84 100 STAIRWAY9 1 1 1 2     3 15ST            
6740 39332 1 35 0 21st St 2 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
7293 31848 1 16   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7527 20039 3 16 100 STAIRWAY51 10 1 1 2     3 ST            
9510 46857 1 16   1 1 1 1   04/25/2002 12:00:00 AM     Permit Number 44926          
9515 19958 3 84 100 STAIRWAY40 3 1 1 2     3 15ST            
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
10575 20040 3 16 100 STAIRWAY51 11 1 1 2     6 ST            
10800 19957 3 84 100 STAIRWAY40 2 1 1 2     3 15ST            
10952 43297 1 16 1501 Missouri St 1 1 1 1   07/12/2000 12:00:00 AM     Permit Number 43066          
11785 31851 1 35 1117 Houston St 1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35299          
11795 31846 1 16   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11812 20044 3 16 100 STAIRWAY51 15 1 1 2     3 ST            
11986 31849 1 35   1 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
12896 19960 3 84 100 STAIRWAY41 18 1 1 2     6 25ST            
12976 20042 3 16 100 STAIRWAY51 13 1 1 2     3 ST            
13223 33083 1 16   2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14197 39331 1 35 0 21st St 5 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
14604 19885 3 198 100 STAIRWAY33 17 1 1 2     6 25ST            
14695 20043 3 16 100 STAIRWAY51 14 1 1 2     3 ST            
14881 33084 1 16   1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
15743 115724 2 198 250x Octavia St 1 17 1 5                    
15875 31850 1 35   2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
15956 31845 1 35   3 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35298          
16368 19956 3 84 100 STAIRWAY40 1 1 1 2     12 15ST            
44810 53918 1 35 3 21st St 1 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
67142 118470 2 18 510 48th Ave 1 1 1 1     1 Width 3ft   5981008.92024 2112222.55161 37.7786579010228 -122.50930075514499 (37.7786579010228, -122.509300755145)
67642 118478 2 18 578 48th Ave 1 2 1 1     8 Width 3ft   5981024.51617 2111800.84509 37.7775009394111 -122.509215478972 (37.7775009394111, -122.509215478972)
99492 110751 2 18 510 48th Ave 1 1 1 1   05/05/2015 12:00:00 AM 3   Permit Number 775489 5981042.2 2112214.0 37.778636382962 -122.509184994454 (37.778636382962, -122.509184994454)
85021 33758 1 35 842 48th Ave 1 1 1 1   12/11/1996 12:00:00 AM     Permit Number 37811 5981102.7142707 2109980.14676383 37.77250644827279 -122.508809756644 (37.7725064482728, -122.508809756644)
83651 68577 1 16 139 Sutro Heights Ave 1 1 1 1 1 10/18/1993 12:00:00 AM     Permit Number 32471 5981217.74443457 2111271.39856875 37.7760586259822 -122.508507736704 (37.7760586259822, -122.508507736704)
50040 87823 1 18 451 47th Ave   1 1 1   06/05/2008 12:00:00 AM 4 2x3 Permit Number 50716 5981265.5826900005 2112596.97795 37.7797010943021 -122.508440678428 (37.7797010943021, -122.508440678428)
37553 87825 1 18 451 47th Ave 3 1 1 1   06/05/2008 12:00:00 AM 3 2x3 Permit Number 50716 5981267.84329 2112567.4887599996 37.7796202589611 -122.508430668506 (37.7796202589611, -122.508430668506)
46301 87824 1 18 451 47th Ave 2 1 1 1   06/05/2008 12:00:00 AM 3 2x3 Permit Number 50716 5981268.94768 2112581.1831099996 37.7796579246713 -122.50842786485799 (37.7796579246713, -122.508427864858)
150585 56095 1 18 783 47th Ave 1 1 1 1   01/12/2009 12:00:00 AM 2 3x3 Permit Number 52001 5981348.38409 2110404.98623 37.7736874110676 -122.507991510924 (37.7736874110676, -122.507991510924)
135919 85241 1 35 4331 Kirkham St 1 1 1 1   07/20/2007 12:00:00 AM 1   Permit Number 49544 5981367.2124 2104841.304 37.7584122600662 -122.507513483633 (37.7584122600662, -122.507513483633)
162332 85242 1 35 4331 Kirkham St 2 1 1 1   07/20/2007 12:00:00 AM 1   Permit Number 49544 5981385.546 2104841.9152 37.7584150182243 -122.507450124372 (37.7584150182243, -122.507450124372)
32419 89550 3 35 5539 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5981409.7822199995 2111623.31383 37.7770361978186 -122.50786956100401 (37.7770361978186, -122.507869561004)
187658 92257 1 18 862 47th Ave 1 1 1 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52706 5981411.16308 2109852.88199 37.7721751933845 -122.50773337462299 (37.7721751933845, -122.507733374623)
149511 34721 1 16 5535 Anza St 1 1 1 1 1 07/28/1997 12:00:00 AM 4   Permit Number 38376 5981434.12386 2111625.14448 37.7770426583791 -122.507785493074 (37.7770426583791, -122.507785493074)
62539 183257 2 35 1343 47th Ave 1 1 1 1     2 Width 0ft   5981497.12 2105917.3408 37.7613744008584 -122.50714403834999 (37.7613744008584, -122.50714403835)
105081 36131 1 16 1579 47th Ave 1 1 1 1   04/29/1998 12:00:00 AM     Permit Number 39226 5981546.79724008 2104343.49116474 37.7570559852656 -122.50685548584299 (37.7570559852656, -122.506855485843)
45174 184179 2 35 1607 47th Ave 1 1 1 1     2 Width 0ft   5981558.7987 2104123.9871 37.7564539963073 -122.50679770031401 (37.7564539963073, -122.506797700314)
154522 118420 2 16 5501 Anza St 1 2 1 1     9 Width 3ft   5981593.2087199995 2111630.13422 37.7770657300516 -122.507235548964 (37.7770657300516, -122.507235548964)
170734 67270 1 16 539 46th Ave 1 1 1 1 1 06/09/1992 12:00:00 AM 3   Permit Number 30743 5981594.696269999 2112052.0019099996 37.7782241419477 -122.50726170878299 (37.7782241419477, -122.507261708783)
185931 118627 2 18 494 46th Ave 1 2 1 1     3 Width 3ft   5981628.0956 2112437.91019 37.7792856992778 -122.50717480668301 (37.7792856992778, -122.507174806683)
131729 34701 1 18 546 46th Ave 2 1 1 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52703 5981643.1854 2112019.5317 37.7781378442384 -122.507091560706 (37.7781378442384, -122.507091560706)
148645 34700 1 18 546 46th Ave 1 1 1 1   07/23/2009 12:00:00 AM 1 3x3 Permit Number 52703 5981644.97521 2112008.50675 37.7781076783894 -122.507084551143 (37.7781076783894, -122.507084551143)
65153 50405 1 18 815 46th Ave 1 1 1 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52709 5981666.2240699995 2110158.20965 37.7730285573555 -122.506873764155 (37.7730285573555, -122.506873764155)
31693 119100 2 18 855 46th Ave 1 1 1 1     2 Width 3ft   5981674.98764 2109913.6134599997 37.772357483762704 -122.50682530453399 (37.7723574837627, -122.506825304534)
24853 47834 1 16 891 46th Ave 1 1 1 1   10/17/2007 12:00:00 AM 4 3x3 Permit Number 49787 5981681.239030001 2109702.6053299997 37.7717784851525 -122.50678802713199 (37.7717784851525, -122.506788027132)
9777 88104 1 16 1247 46th Ave   1 1 1   06/30/2008 12:00:00 AM   4x10 Permit Number 51108 5981754.7 2106590.8 37.763238693975296 -122.50630313344999 (37.7632386939753, -122.50630313345)
72566 83831 1 16 1249-1249 46th Ave 1 1 1 1   01/23/2008 12:00:00 AM 3 4x9 Permit Number 50162 5981782.7749 2106603.6182 37.7632755418665 -122.50620698388599 (37.7632755418665, -122.506206983886)
177635 118425 2 35 5421 Anza St 1 2 1 1     11 Width 3ft   5981790.15899 2111638.01027 37.7770989536906 -122.506554832582 (37.7770989536906, -122.506554832582)
189051 118424 2 35 5421 Anza St 2 2 1 1     10 Width 3ft   5981802.00316 2111639.4369 37.7771035681701 -122.50651396642 (37.7771035681701, -122.50651396642)
56421 118423 2 35 5421 Anza St 3 2 1 1     11 Width 3ft   5981811.815769999 2111640.57092 37.7771072596016 -122.50648010623001 (37.7771072596016, -122.50648010623)
68693 118431 2 35 5400 Anza St 6 1 1 1     7 Width 4ft   5981816.64658 2111695.18358 37.7772574943259 -122.506467446284 (37.7772574943259, -122.506467446284)
131523 118430 2 16 5400 Anza St 5 1 1 1     5 Width 4ft   5981830.664890001 2111695.69394 37.7772597209712 -122.506418991145 (37.7772597209712, -122.506418991145)
170362 118429 2 35 5400 Anza St 4 1 1 1     9 Width 4ft   5981844.98436 2111695.06236 37.7772588298958 -122.50636940951 (37.7772588298958, -122.50636940951)
185018 118428 2 16 5400 Anza St 3 1 1 1     2 Width 4ft   5981858.846609999 2111695.90062 37.7772619476301 -122.50632151854099 (37.7772619476301, -122.506321518541)
43146 118427 2 35 5400 Anza St 2 1 1 1     6 Width 4ft   5981873.51616 2111696.39703 37.7772641742522 -122.506270809551 (37.7772641742522, -122.506270809551)
111879 68559 1 35 511 45th Ave 1 1 1 1 1 10/18/1993 12:00:00 AM     Permit Number 32449 5981895.88613984 2112278.88841287 37.778864841011796 -122.50623662905001 (37.7788648410118, -122.50623662905)
160579 68561 1 16 531 45th Ave 1 1 1 1 1 10/18/1993 12:00:00 AM 4   Permit Number 32451 5981904.26903 2112120.67838 37.7784309363863 -122.50619589543699 (37.7784309363863, -122.506195895437)
168261 68777 1 16 555 45th Ave 1 1 1 1 1 11/16/1993 12:00:00 AM 4   Permit Number 32707 5981911.30335 2111941.60843 37.777939677133205 -122.506158280277 (37.7779396771332, -122.506158280277)
148211 68564 1 18 575 45th Ave 1 1 1 1 1 10/18/1993 12:00:00 AM 4   Permit Number 32454 5981914.34705 2111854.14558 37.7776997090602 -122.506141264398 (37.7776997090602, -122.506141264398)
147767 119067 2 18 575 45th Ave 2 1 1 1     1 Width 3ft   5981914.59302 2111829.39054 37.7776317534825 -122.506138577528 (37.7776317534825, -122.506138577528)
100869 68558 1 35 508 45th Ave 1 1 1 1 1 10/18/1993 12:00:00 AM     Permit Number 32448 5981947.34598034 2112294.26948127 37.7789101022126 -122.50605975288799 (37.7789101022126, -122.506059752888)
45509 68562 1 16 532 45th Ave 1 1 1 1 1 10/18/1993 12:00:00 AM 5   Permit Number 32452 5981948.24889 2112111.86912 37.7784093377083 -122.50604310187401 (37.7784093377083, -122.506043101874)
33287 118775 2 16 630 45th Ave 1 10 1 1     27 Width 2ft   5981986.088380001 2111427.82901 37.7765333919608 -122.50586147692101 (37.7765333919608, -122.505861476921)
52139 118798 2 18 810 45th Ave 2 1 1 1     3 3x3   5982020.13723 2110219.13712 37.7732166816615 -122.50565407298599 (37.7732166816615, -122.505654072986)
186216 250997 2 16 415 44th Ave 1 4 1 1     5 Width 3ft   5982186.75835 2112941.64621 37.7807016980586 -122.505279538125 (37.7807016980586, -122.505279538125)
107860 81964 1 16 455 44th Ave 2 1 1 1   12/11/2007 12:00:00 AM   3x3 Permit Number 50002 5982191.84204192 2112715.55923715 37.780081229053 -122.505245190233 (37.780081229053, -122.505245190233)
30707 250995 2 16 453 44th Ave 2 4 1 1     5 Width 3ft   5982194.00965 2112744.27477 37.780160200984604 -122.505239820464 (37.7801602009846, -122.505239820464)
46117 68549 1 18 543 44th Ave 1 1 1 1 1 10/18/1993 12:00:00 AM 3   Permit Number 32436 5982217.68828 2112054.92779 37.7782688503059 -122.50510680493 (37.7782688503059, -122.50510680493)
26055 70169 2 16 5233 Anza St 1 1 1 1 1 07/10/1993 12:00:00 AM 3     5982394.507019999 2111657.31782 37.777187531817496 -122.504465669217 (37.7771875318175, -122.504465669217)
55330 37078 1 16 1318 44th Ave 1 1 1 1 1 04/20/2002 12:00:00 AM 2   Permit Number 39680 5982466.3981 2106106.9098 37.761951943280394 -122.50380580728 (37.7619519432804, -122.50380580728)
171448 83913 1 16 1659 44th Ave 1 1 1 1   01/23/2008 12:00:00 AM 1 3x3 Permit Number 50155 5982499.5096 2103826.5104 37.7556925599446 -122.503522416925 (37.7556925599446, -122.503522416925)
34490 68541 1 18 501 43rd Ave 1 1 1 1 1 10/18/1993 12:00:00 AM 6   Permit Number 32425 5982517.9924800005 2112299.68917 37.778958557712606 -122.504086094205 (37.7789585577126, -122.504086094205)
186975 119011 2 18 501 43rd Ave 3 1 1 1     3 Width 3ft   5982518.7729400005 2112266.03771 37.778866206576794 -122.504080901039 (37.7788662065768, -122.504080901039)
181943 119012 2 18 501 43rd Ave 2 1 1 1     3 Width 3ft   5982519.09297 2112280.9796700003 37.778907251633704 -122.50408090101801 (37.7789072516337, -122.504080901018)
105625 68543 1 18 519 43rd Ave 1 1 1 1 1 10/18/1993 12:00:00 AM     Permit Number 32427 5982523.73467 2112217.34809 37.7787328109508 -122.504060129291 (37.7787328109508, -122.504060129291)
183324 68544 1 18 571 43rd Ave 1 1 1 1 1 10/18/1993 12:00:00 AM 8   Permit Number 32430 5982530.7498 2111896.5441900003 37.777852390021 -122.504012093664 (37.777852390021, -122.504012093664)
163678 81982 1 18 563 43rd Ave 1 1 1 1   12/11/2007 12:00:00 AM 1 3x3 Permit Number 49998 5982533.65676 2111927.12728 37.7779365331701 -122.504004303472 (37.7779365331701, -122.504004303472)
54483 119001 2 18 623 43rd Ave 1 1 1 1     3 Width 3ft   5982546.8216699995 2111525.4630400003 37.7768344548721 -122.503929004913 (37.7768344548721, -122.503929004913)
59474 119000 2 18 623 43rd Ave 2 1 1 1     4 Width 3ft   5982547.10807 2111503.78055 37.776774937935 -122.503926407866 (37.776774937935, -122.503926407866)
Powered by Datasette · Query took 88.18ms · Data source: data.sfgov.org