sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14406 120561 2 82 245 Mississippi St 1 1 1 1     14 3x3   6014054.5814 2105863.37396 37.7630899785332 -122.394536741704 (37.7630899785332, -122.394536741704)
15797 101777 2 82 1700 Yosemite Ave 3 1 1 1     8 3x3   6014038.07825 2093123.5904299999 37.72810829704029 -122.39370208181101 (37.7281082970403, -122.393702081811)
19725 114507 2 82 10 LOMBARD ST 2 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
20863 112866 2 82 750 VICENTE ST 3 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
22361 213977 2 82 271 Faxon Ave 1 1 1 1     7 Width 3ft   5994717.86147 2090376.1855099997 37.719472047173205 -122.460293291905 (37.7194720471732, -122.460293291905)
22370 244046 2 82 401 Clayton St 1 1 1 1     12 Width 0ft   5998376.5126 2109253.6935 37.771514871030995 -122.44900587960699 (37.771514871031, -122.449005879607)
22887 120259 2 82 130 24th Ave 3 2 1 1     6 Width 4ft   5988369.32629 2115004.14379 37.7867265878172 -122.484042609601 (37.7867265878172, -122.484042609601)
23398 138455 2 82 1901 FILLMORE ST 5 1 1 1     8 Width 0ft   6002947.3238 2114874.0081 37.787207199109204 -122.433596947338 (37.7872071991092, -122.433596947338)
23424 197132 2 82 201 Newhall St 4 4 1 1     2 Width 3ft   6016788.78445 2098277.43468 37.742412193171795 -122.384551543811 (37.7424121931718, -122.384551543811)
23538 213933 2 82 2176 16th Ave 1 2 1 1     7 Width 3ft   5991344.08373 2100608.05246 37.7473715261751 -122.472700716564 (37.7473715261751, -122.472700716564)
23669 138324 2 82 2492 Bush St 1 1 1 1     5 Width 0ft   6001634.5236 2114647.8572 37.7865116723619 -122.438122738022 (37.7865116723619, -122.438122738022)
23795 239276 2 82 313 South Van Ness Ave 1 1 1 1     2 Width 4ft   6007404.6677 2107881.43658 37.768259172860105 -122.41767964611 (37.7682591728601, -122.41767964611)
23815 239298 2 82 1475 York St 1 1 1 1     7 Width 10ft   6010135.52625 2100699.74587 37.7486931572616 -122.407727378721 (37.7486931572616, -122.407727378721)
23839 239303 2 82 827 York St 1 1 1 1     12 Width 3ft   6009943.30832 2104181.7840400003 37.7582432964097 -122.408637674287 (37.7582432964097, -122.408637674287)
23855 213936 2 82 15 Forest Side Ave 1 1 1 1     7 Width 3ft   5992721.86042 2099019.1696099997 37.7430885175375 -122.46782095827801 (37.7430885175375, -122.467820958278)
23930 246508 2 82 241 Duncan St 1 4 1 1     8 Width 6ft   6004932.15845 2099866.5422 37.7461127118493 -122.425661300149 (37.7461127118493, -122.425661300149)
24461 138424 2 82 1901 SUTTER ST 2 1 1 1     11 Width 0ft   6003330.8547 2114478.3784 37.786142653739 -122.432241748584 (37.786142653739, -122.432241748584)
24603 239251 2 82 3741 26th St 1 1 1 1     16 Width 3ft   6005376.329919999 2100765.1364700003 37.748605134322794 -122.42418930690901 (37.7486051343228, -122.424189306909)
24904 136239 2 82 1679 Washington St 1 1 1 1     8 Width 3ft   6006621.33402 2116991.57937 37.7932292991375 -122.4210360509 (37.7932292991375, -122.4210360509)
25009 197076 2 82 1101 23rd St 1 1 1 1     8 Width 4ft   6014915.77906 2102946.7050400004 37.7551292724085 -122.39135422264098 (37.7551292724085, -122.391354222641)
25023 213915 2 82 1221 07th Ave 1 1 1 1     5 Width 3ft   5993897.03256 2107168.07527 37.7655311082052 -122.464349072465 (37.7655311082052, -122.464349072465)
25141 213923 2 82 20 Hill Point Ave 1 1 1 1     5 Width 3ft   5996379.96302 2106767.55131 37.76457417918571 -122.455732270441 (37.7645741791857, -122.455732270441)
25291 179283 2 82 126 Prague St 1 1 1 1     4 Width 3ft   6004517.28509 2090394.86473 37.7200821580385 -122.426421596896 (37.7200821580385, -122.426421596896)
25564 197127 2 82 101 Newhall St 13 4 1 1     3 Width 3ft   6017303.080490001 2098110.9339400004 37.7419834431736 -122.382761660942 (37.7419834431736, -122.382761660942)
25584 123293 2 82 566 06th Ave 1 1 1 1     10 Width 3ft   5994099.84027 2111646.79244 37.7778401670229 -122.46397274776301 (37.7778401670229, -122.463972747763)
25710 138447 2 82 1820 POST ST 9 1 1 1     2 Width 0ft   6003269.2692 2114178.8859 37.7853168309586 -122.432433419204 (37.7853168309586, -122.432433419204)
25838 75303 2 82 376 Utah St 2 1 1 1 1 09/17/1994 12:00:00 AM 1     6010591.15079 2106579.14528 37.7648621726769 -122.40656607695699 (37.7648621726769, -122.406566076957)
25963 179311 2 82 427 Cambridge St 1 1 1 1     10 Width 2ft   6006943.30245 2092535.62338 37.7260970640242 -122.418187352968 (37.7260970640242, -122.418187352968)
26025 136191 2 82 2914 Fillmore St 3 1 1 1     11 Width 2ft   6002535.252730001 2118218.14981 37.7963659626655 -122.435261914602 (37.7963659626655, -122.435261914602)
26041 239277 2 82 150 Lexington St 1 1 1 1     10 Width 3ft   6006452.39888 2105218.17632 37.760892854741996 -122.420784359417 (37.760892854742, -122.420784359417)
26202 239326 2 82 26 Mullen Ave 2 1 1 1     2 Width 3ft   6009380.8265 2099841.0915200002 37.746293204883706 -122.41027651786001 (37.7462932048837, -122.41027651786)
26220 136266 2 82 220 Joice St 2 1 1 1     7 Width 3ft   6010225.4664 2116932.79358 37.793270394575295 -122.40856131286101 (37.7932703945753, -122.408561312861)
26335 239363 2 82 3995 26th St 1 1 1 1     9 Width 3ft   6003937.45795 2100690.36733 37.748318487114894 -122.429159577477 (37.7483184871149, -122.429159577477)
26386 136222 2 82 3159 Baker St 1 1 1 1     7 Width 3ft   5999346.78651 2119715.31037 37.8002951834309 -122.446402399571 (37.8002951834309, -122.446402399571)
26410 138128 2 82 1850 FILLMORE ST 8 1 1 1     4 Width 0ft   6003016.992000001 2114720.1259 37.786788630304706 -122.433344910367 (37.7867886303047, -122.433344910367)
26447 213937 2 82 155 Wawona St 1 1 1 1     11 Width 3ft   5992856.26396 2098093.99646 37.740555986160494 -122.467288974202 (37.7405559861605, -122.467288974202)
26458 139278 2 82 725 FULTON ST 5 1 1 1     4 Width 0ft   6004349.2802 2111499.4808 37.7780210326226 -122.42850585599199 (37.7780210326226, -122.428505855992)
26489 139379 2 82 1409 LYON ST 1 1 1 1     2 Width 0ft   5999686.4389 2113792.3684 37.7840517388464 -122.44480108896799 (37.7840517388464, -122.444801088968)
26493 239366 2 82 3544 22nd St 1 1 1 1     8 Width 3ft   6004780.37134 2103118.67558 37.7550337374315 -122.426417677652 (37.7550337374315, -122.426417677652)
26558 136248 2 82 2023 Taylor St 1 1 1 1     7 Width 3ft   6008588.60584 2119742.27726 37.800892734360296 -122.414423864695 (37.8008927343603, -122.414423864695)
26661 213931 2 82 23 Hill Point Ave 3 1 1 1     6 Width 3ft   5996332.88729 2106669.96482 37.7643035299972 -122.455888036623 (37.7643035299972, -122.455888036623)
26777 138037 2 82 1928 FILLMORE ST 1 1 1 1     12 Width 0ft   6002982.5354 2114995.4141 37.7875425469434 -122.433483802199 (37.7875425469434, -122.433483802199)
26848 239353 2 82 333 Day St 1 1 1 1     9 Width 2ft   6003763.4516900005 2098632.19433 37.7426573690441 -122.429614519315 (37.7426573690441, -122.429614519315)
26988 248441 2 82 739 Clayton St 1 1 1 1     9 Width 0ft   5998553.128 2108007.4759 37.7681031739849 -122.44830520423099 (37.7681031739849, -122.448305204231)
27054 239274 2 82 400 South Van Ness Ave 4 1 1 1     3 Width 3ft   6007375.13668 2107234.3347 37.7664807212325 -122.41773591849702 (37.7664807212325, -122.417735918497)
27161 197088 2 82 1098 Pennsylvania Ave 6 9 1 1     5 Width 5ft   6014473.69906 2102184.6927400003 37.753012404101 -122.39282976818998 (37.753012404101, -122.39282976819)
27228 239271 2 82 400 South Van Ness Ave 1 1 1 1     3 Width 3ft   6007373.17462 2107313.6356599997 37.7666983526646 -122.417748326439 (37.7666983526646, -122.417748326439)
27334 240136 2 82 277 27th St 2 1 1 1     9 Width 4ft   6004700.17371 2100146.19558 37.7468674642611 -122.426483383002 (37.7468674642611, -122.426483383002)
27611 239367 2 82 17 Chattanooga St 1 1 1 1     11 Width 2ft   6004711.71138 2103517.26847 37.756124298509896 -122.42668350644101 (37.7561242985099, -122.426683506441)
27910 183007 2 82 2440 22nd Ave 1 1 1 1     5 Width 0ft   5989549.7088 2098739.1145 37.742135877465294 -122.478768805014 (37.7421358774653, -122.478768805014)
27916 197079 2 82 690 18th St 1 1 1 1     6 Width 4ft   6015561.72583 2105828.91514 37.763079033783605 -122.389321587544 (37.7630790337836, -122.389321587544)
28029 124413 2 82 3900 Clay St 1 1 1 1     7 Width 4ft   5996133.62205 2115253.7929599998 37.787861027515895 -122.45719822521299 (37.7878610275159, -122.457198225213)
28069 239272 2 82 400 South Van Ness Ave 2 1 1 1     3 Width 3ft   6007373.32106 2107298.89674 37.7666578912871 -122.417746775107 (37.7666578912871, -122.417746775107)
28124 239362 2 82 1400 Sanchez St 2 1 1 1     3 Width 3ft   6003888.14228 2100073.30368 37.7466213818866 -122.429286114783 (37.7466213818866, -122.429286114783)
28183 246963 2 82 238 Noe St 2 4 1 1     8 Width 4ft   6002871.51875 2106887.2406200003 37.765273220394796 -122.433288301134 (37.7652732203948, -122.433288301134)
28239 120254 2 82 150 24th Ave 2 2 1 1     3 Width 6ft   5988369.36546 2114920.76145 37.7864976459369 -122.4840363573 (37.7864976459369, -122.4840363573)
28339 73442 2 82 314 Athens St 1 1 1 1 1 08/06/1994 12:00:00 AM 8     6004223.020830001 2091452.87155 37.72297057362721 -122.42751410409402 (37.7229705736272, -122.427514104094)
28416 99761 2 82 4212 25th St 2 1 1 1       3x3 4212-4216 25th St (4214 is visible address) 6002485.0 2101232.0 37.749723353108294 -122.434220849449 (37.7497233531083, -122.434220849449)
28424 239318 2 82 2765 23rd St 1 1 1 1     11 Width 3ft   6010143.74039 2102787.8018900002 37.7544269567524 -122.407846193561 (37.7544269567524, -122.407846193561)
28532 120778 2 82 57 21st Ave 5 1 1 1     8 Width 3ft   5989252.84217 2114809.1452099998 37.7862425746859 -122.480971607416 (37.7862425746859, -122.480971607416)
28556 136259 2 82 2110 Leavenworth St 2 1 1 1     8 Width 3ft   6007679.1852400005 2119665.2919900003 37.800630222272794 -122.417565392635 (37.8006302222728, -122.417565392635)
28648 213960 2 82 360 Faxon Ave 9 1 1 1     13 Width 3ft   5994774.81066 2091163.6355700002 37.7216374725616 -122.460153459937 (37.7216374725616, -122.460153459937)
28756 213918 2 82 50 Hill Point Ave 1 1 1 1     1 Width 3ft   5996378.4642199995 2106655.73366 37.76426707058221 -122.455729371032 (37.7642670705822, -122.455729371032)
28760 136243 2 82 1679 Washington St 5 1 1 1     8 Width 3ft   6006695.60451 2117001.64443 37.7932611216587 -122.42077978456999 (37.7932611216587, -122.42077978457)
29126 140884 2 82 642 SPRUCE ST 1 1 1 1     1 Width 0ft   5997209.5584 2113437.661 37.782936144733 -122.453344534721 (37.782936144733, -122.453344534721)
29146 179293 2 82 180 Edinburgh St 2 1 1 1     11 Width 3ft   6004018.855 2092658.23186 37.7262686762461 -122.428305729646 (37.7262686762461, -122.428305729646)
29178 197081 2 82 690 18th St 3 1 1 1     5 Width 4ft   6015537.3565 2105827.07749 37.7630726369229 -122.389405745189 (37.7630726369229, -122.389405745189)
29245 240195 2 82 1787 Sanchez St 1 1 1 1     17 Width 3ft   6004009.05897 2097810.30767 37.7404145605961 -122.42870670406401 (37.7404145605961, -122.428706704064)
29246 138000 2 82 1932 FILLMORE ST 2 1 1 1     10 Width 0ft   6002970.878 2115057.2879 37.78771177526961 -122.433528557906 (37.7877117752696, -122.433528557906)
29544 213971 2 82 1061 Capitol Ave 4 1 1 1     10 Width 3ft   5995026.07265 2091112.6142099998 37.7215118291791 -122.459281227253 (37.7215118291791, -122.459281227253)
29555 142821 2 82 1760 POLK ST 1 1 1 1     1 Width 0ft   6006596.1444 2116951.8546 37.7931188048508 -122.421120386791 (37.7931188048508, -122.421120386791)
29644 239343 2 82 225 Mullen Ave 1 1 1 1     12 Width 3ft   6010133.75357 2099974.1699200002 37.7467007857307 -122.407682355972 (37.7467007857307, -122.407682355972)
30190 136213 2 82 107 Spruce St 2 1 1 1     10 Width 3ft   5997027.70911 2115921.73522 37.78974632646779 -122.45415312837099 (37.7897463264678, -122.454153128371)
30243 138452 2 82 1901 FILLMORE ST 2 1 1 1     8 Width 0ft   6002940.8815 2114925.0507 37.7873469835854 -122.433622885577 (37.7873469835854, -122.433622885577)
30247 179306 2 82 272 Edinburgh St 1 1 1 1     8 Width 2ft   6003680.49546 2092115.04602 37.7247580571263 -122.429436701757 (37.7247580571263, -122.429436701757)
30274 239311 2 82 464 Fair Oaks St 2 1 1 1     10 Width 3ft   6005494.12674 2100990.71225 37.7492311640921 -122.423798003785 (37.7492311640921, -122.423798003785)
30381 197107 2 82 1468 25th St 6 9 1 1     6 Width 5ft   6014386.38736 2102037.52751 37.7526034697945 -122.393121414743 (37.7526034697945, -122.393121414743)
30474 138425 2 82 1901 SUTTER ST 3 1 1 1     9 Width 0ft   6003355.5073 2114484.6624 37.786161305767706 -122.432156906104 (37.7861613057677, -122.432156906104)
30825 240180 2 82 415 Gates St 1 1 1 1     5 Width 3ft   6008254.09787 2096890.0031299999 37.738126944293796 -122.413963894722 (37.7381269442938, -122.413963894722)
30852 240192 2 82 15 Whitney St 1 1 1 1     15 Width 3ft   6004287.41019 2098213.31975 37.7415368893219 -122.42777298295401 (37.7415368893219, -122.427772982954)
30856 197169 2 82 2 Baldwin Ct 6 9 1 1     11 Width 4ft   6017690.0216 2093651.3665 37.7297597257339 -122.38111373781 (37.7297597257339, -122.38111373781)
30857 239336 2 82 3206 Harrison St 1 1 1 1     11 Width 3ft   6008986.81884 2099989.0905299997 37.74667748337421 -122.41164940941201 (37.7466774833742, -122.411649409412)
30859 136223 2 82 3699 Divisadero St 1 1 1 1     6 Width 3ft   6000162.373980001 2120896.2706299997 37.8035843324119 -122.44366504043501 (37.8035843324119, -122.443665040435)
31141 123173 2 82 691 10th Ave 3 1 1 1     7 Width 3ft   5992843.890869999 2110769.52892 37.7753589775368 -122.468253641396 (37.7753589775368, -122.468253641396)
31164 240161 2 82 504 Belvedere St 1 1 1 1     10 Width 4ft   5998591.56873 2106281.83073 37.7633671855679 -122.448047979048 (37.7633671855679, -122.448047979048)
31491 239296 2 82 1114 York St 1 1 1 1     18 Width 3ft   6009989.84018 2102603.83852 37.753913217229 -122.408365447707 (37.753913217229, -122.408365447707)
32020 197170 2 82 1440 Galvez Ave 1 1 1 1     4 Width 3ft   6016200.17093 2097456.77974 37.740126273917 -122.386529601766 (37.740126273917, -122.386529601766)
32309 137616 2 82 2260 Turk Blvd 3 1 1 1     4 Width 0ft   5999176.7198 2111892.1732 37.77880519340229 -122.446427777449 (37.7788051934023, -122.446427777449)
32581 197122 2 82 2 Napoleon St 4 4 1 1     5 Width 4ft   6013973.73168 2100142.08459 37.747376054258105 -122.394415755007 (37.7473760542581, -122.394415755007)
32797 139276 2 82 725 FULTON ST 3 1 1 1     3 Width 0ft   6004285.6861 2111490.9383 37.777993978047704 -122.428725241569 (37.7779939780477, -122.428725241569)
32871 74007 2 82 2030 23rd St 2 1 1 1 1 08/25/1984 12:00:00 AM 8     6012344.40813 2102849.33443 37.754718867688105 -122.40023998938999 (37.7547188676881, -122.40023998939)
33109 197147 2 82 65 Whitney Young Cir 22 1 1 1     3 Width 3ft   6017204.67342 2094944.70699 37.7332841805136 -122.38288162868099 (37.7332841805136, -122.382881628681)
33299 239254 2 82 3715 26th St 6 1 1 1     4 Width 3ft   6005705.30849 2100786.77225 37.748683110956996 -122.423053239242 (37.748683110957, -122.423053239242)
33428 197157 2 82 106 Whitney Young Cir 5 1 1 1     1 Width 3ft   6016598.7871900005 2095669.6865 37.7352413346217 -122.385026857123 (37.7352413346217, -122.385026857123)
33654 141285 2 82 303 Anza St 1 2 1 1     5 Width 0ft   5998264.5884 2112604.2973 37.780708361851396 -122.449634513412 (37.7807083618514, -122.449634513412)
33655 239250 2 82 3743 26th St 1 1 1 1     12 Width 3ft   6005344.37171 2100764.27917 37.7486009758548 -122.42429975714701 (37.7486009758548, -122.424299757147)
33676 136238 2 82 1378 Pacific Ave 2 1 1 1     4 Width 3ft   6007522.032000001 2117818.3708599997 37.7955501948379 -122.41797820753901 (37.7955501948379, -122.417978207539)
33788 213974 2 82 1061 Capitol Ave 7 1 1 1     7 Width 3ft   5995026.3935 2091022.299 37.7212638636298 -122.459273581222 (37.7212638636298, -122.459273581222)
34091 197124 2 82 2 Napoleon St 12 4 1 1     3 Width 4ft   6013733.0286 2100130.5529400003 37.747331007214896 -122.395247287949 (37.7473310072149, -122.395247287949)
34193 122096 2 82 515 16th Ave 1 1 1 1     9 Width 3ft   5990911.764769999 2111862.01127 37.778246853274105 -122.475017013162 (37.7782468532741, -122.475017013162)
34519 136225 2 82 3699 Divisadero St 3 1 1 1     7 Width 3ft   6000164.78748 2120871.42318 37.803516245636004 -122.44365490235201 (37.803516245636, -122.443654902352)
Powered by Datasette · Query took 12.425ms · Data source: data.sfgov.org