Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3093 | 3093 | 124473 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 356 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45077 | 5996305.70499 | 2110483.22678 | 37.774772198948796 | -122.456257787006 | (37.7747721989488, -122.456257787006) | |
| 5146 | 5146 | 228435 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 178 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004070.0 | 2107898.0 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | |||
| 5169 | 5169 | 228433 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004139.02513 | 2107107.02985 | 37.7659485330168 | -122.4289199675 | (37.7659485330168, -122.4289199675) | |||
| 6152 | 6152 | 34989 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2447 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 10 | Permit Number 38568 | 6002987.46694 | 2116484.72723 | 37.7916321004801 | -122.433573216253 | (37.7916321004801, -122.433573216253) | ||
| 10069 | 10069 | 7948 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1701 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2014 12:00:00 AM | 6 | 3X3 | 6005705.32484 | 2116013.7592599997 | 37.790492771869005 | -122.42413593393499 | (37.790492771869, -122.424135933935) | ||
| 14629 | 14629 | 14993 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1445 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6016309.01096 | 2097636.9306 | 37.740626956171496 | -122.38616582959 | (37.7406269561715, -122.38616582959) | ||
| 15010 | 15010 | 6841 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.0043599997 | 37.7408861578704 | -122.38663127193199 | (37.7408861578704, -122.386631271932) | ||
| 15580 | 15580 | 100252 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 540 Delancey St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 6015236.96681 | 2113599.67086 | 37.784397795653 | -122.39098797374201 | (37.784397795653, -122.390987973742) | |||
| 17937 | 17937 | 25490 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2008 12:00:00 AM | 6 | 3x3 | 6003008.9663 | 2109230.9780099997 | 37.771716346673 | -122.432980363376 | (37.771716346673, -122.432980363376) | ||
| 18989 | 18989 | 10323 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 774 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2009 12:00:00 AM | 3 | 3X3 | 6002445.3097 | 2109202.4042 | 37.771605902741705 | -122.43492804083999 | (37.7716059027417, -122.43492804084) | ||
| 21953 | 21953 | 29956 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.43228248973699 | (37.7719405092432, -122.432282489737) | ||
| 23433 | 23433 | 228490 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 512 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004210.50257 | 2105904.81342 | 37.762651580625 | -122.428587037577 | (37.762651580625, -122.428587037577) | |||
| 23437 | 23437 | 139746 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1314 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004648.3504 | 2113539.1351 | 37.783638338734995 | -122.427616619318 | (37.783638338735, -122.427616619318) | |||
| 24406 | 24406 | 228482 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006464.96947 | 2105462.2206200003 | 37.7615636518725 | -122.42075820894699 | (37.7615636518725, -122.420758208947) | |||
| 26787 | 26787 | 228493 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3748 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003428.54428 | 2103628.48028 | 37.7563570304699 | -122.431129066663 | (37.7563570304699, -122.431129066663) | |||
| 27192 | 27192 | 228497 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 487 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004262.22293 | 2106063.80962 | 37.7630910730105 | -122.428419488484 | (37.7630910730105, -122.428419488484) | |||
| 27224 | 27224 | 190666 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6013164.18283 | 2111305.0882200003 | 37.7779821643861 | -122.397998114425 | (37.7779821643861, -122.397998114425) | |||
| 29229 | 29229 | 244127 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 398 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004270.549 | 2109462.5132 | 37.7724235634161 | -122.42863297607501 | (37.7724235634161, -122.428632976075) | |||
| 29747 | 29747 | 190661 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1400 Fairfax Ave | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016311.597030001 | 2097718.64456 | 37.7408514692121 | -122.386162583062 | (37.7408514692121, -122.386162583062) | |||
| 30267 | 30267 | 228488 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008610.437969999 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | |||
| 30430 | 30430 | 190662 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1498 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | |||
| 30449 | 30449 | 143026 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2027 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009443.5652 | 2120635.2508 | 37.80339260933211 | -122.411528458224 | (37.8033926093321, -122.411528458224) | |||
| 31656 | 31656 | 228466 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004209.32869 | 2107056.55416 | 37.7658139179905 | -122.42867320340599 | (37.7658139179905, -122.428673203406) | |||
| 32337 | 32337 | 219178 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991732.81966 | 2106918.29037 | 37.7647202794542 | -122.471816321464 | (37.7647202794542, -122.471816321464) | |||
| 33760 | 33760 | 228480 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 602 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007650.87527 | 2096524.2069599999 | 37.7370886509206 | -122.416023645289 | (37.7370886509206, -122.416023645289) | |||
| 34455 | 34455 | 228481 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 430 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008039.5755 | 2096830.96729 | 37.7379527941736 | -122.414701431422 | (37.7379527941736, -122.414701431422) | |||
| 35360 | 35360 | 190656 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 358 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012906.49923 | 2105280.1318200002 | 37.7614246319699 | -122.39846666842101 | (37.7614246319699, -122.398466668421) | |||
| 36077 | 36077 | 37655 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1521 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40065 | 5990857.78217 | 2110597.46577 | 37.774771629499796 | -122.475111419797 | (37.7747716294998, -122.475111419797) | |
| 36751 | 36751 | 190659 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016267.561869999 | 2097668.72921 | 37.740711974479 | -122.38631136240299 | (37.740711974479, -122.386311362403) | |||
| 38824 | 38824 | 51853 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1639 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2005 12:00:00 AM | 8 | Permit Number 48077 | 6012728.89469 | 2105155.76009 | 37.7610732389628 | -122.39907220261999 | (37.7610732389628, -122.39907220262) | ||
| 39026 | 39026 | 129088 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011425.38411 | 2120792.86026 | 37.803936329766294 | -122.40468136238 | (37.8039363297663, -122.40468136238) | |||
| 40043 | 40043 | 228498 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 450 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6004181.58169 | 2106402.65123 | 37.764016887284704 | -122.42872255552 | (37.7640168872847, -122.42872255552) | |||
| 40233 | 40233 | 129086 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008124.6291 | 2115843.7412 | 37.7901622440508 | -122.41575322364599 | (37.7901622440508, -122.415753223646) | |||
| 40773 | 40773 | 123610 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 135 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994873.21088 | 2114645.23418 | 37.7861176222016 | -122.46151484664301 | (37.7861176222016, -122.461514846643) | |||
| 41126 | 41126 | 67427 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1515 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30929 | 5990869.16638 | 2110599.51462 | 37.7747779148712 | -122.475072189476 | (37.7747779148712, -122.475072189476) | |
| 41730 | 41730 | 122013 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1502 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5990886.70839 | 2110660.9525099997 | 37.774947623169204 | -122.475015994442 | (37.7749476231692, -122.475015994442) | |||
| 42373 | 42373 | 246384 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006982.6308 | 2109153.3972 | 37.7717279173795 | -122.419229672629 | (37.7717279173795, -122.419229672629) | |||
| 44241 | 44241 | 64733 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 135 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1988 12:00:00 AM | 8 | Permit Number 25692 | 5994873.94035 | 2114654.72726 | 37.786143729617294 | -122.461513011375 | (37.7861437296173, -122.461513011375) | ||
| 46133 | 46133 | 228504 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 60 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006682.42728 | 2109519.39101 | 37.7727159377106 | -122.420294078716 | (37.7727159377106, -122.420294078716) | |||
| 46354 | 46354 | 244230 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 546 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003542.3247 | 2109354.0057 | 37.7720843887684 | -122.43114422654699 | (37.7720843887684, -122.431144226547) | |||
| 46527 | 46527 | 30692 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52599 | 6005954.788 | 2109697.461 | 37.7731638465829 | -122.42282372387301 | (37.7731638465829, -122.422823723873) | |
| 46854 | 46854 | 190660 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1395 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016617.23425 | 2097405.156 | 37.7400076047554 | -122.385083956852 | (37.7400076047554, -122.385083956852) | |||
| 47551 | 47551 | 244231 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.772022330462796 | -122.43161454270799 | (37.7720223304628, -122.431614542708) | |||
| 47929 | 47929 | 228459 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006042.870080001 | 2100850.33706 | 37.748876688223795 | -122.421890467095 | (37.7488766882238, -122.421890467095) | |||
| 48889 | 48889 | 190650 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.760932794527704 | -122.39917787837601 | (37.7609327945277, -122.399177878376) | |||
| 50045 | 50045 | 190657 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 301 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784693998 | (37.7411279765664, -122.38435784694) | |||
| 50889 | 50889 | 228496 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004270.1448800005 | 2105926.96043 | 37.762715766133 | -122.428382334783 | (37.762715766133, -122.428382334783) | |||
| 51149 | 51149 | 228500 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1230 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002502.463830001 | 2101939.70334 | 37.7516675300559 | -122.434211046008 | (37.7516675300559, -122.434211046008) | |||
| 51365 | 51365 | 140195 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 801 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003913.9155 | 2111095.4696 | 37.7768870709162 | -122.429983110687 | (37.7768870709162, -122.429983110687) | |||
| 52316 | 52316 | 190655 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 354 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | |||
| 53257 | 53257 | 228494 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004270.96724 | 2105879.99485 | 37.7625868564077 | -122.42837614294201 | (37.7625868564077, -122.428376142942) | |||
| 53813 | 53813 | 190675 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1381 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016616.1402 | 2097404.54592 | 37.7400058690806 | -122.385087697166 | (37.7400058690806, -122.385087697166) | |||
| 53848 | 53848 | 66602 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1235 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/29/1992 12:00:00 AM | 13 | Permit Number 29795 | 6008012.17093 | 2115828.0191200003 | 37.7901127525459 | -122.41614120735399 | (37.7901127525459, -122.416141207354) | |
| 54440 | 54440 | 228473 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004983.40723 | 2109552.71485 | 37.7727115526285 | -122.426173552181 | (37.7727115526285, -122.426173552181) | |||
| 55117 | 55117 | 190674 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 446 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010985.96747 | 2112156.82627 | 37.7801992828204 | -122.405593378352 | (37.7801992828204, -122.405593378352) | |||
| 55309 | 55309 | 190664 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013137.75359 | 2111279.19954 | 37.7779096079765 | -122.398087726493 | (37.7779096079765, -122.398087726493) | |||
| 56231 | 56231 | 228455 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009383.67351 | 2106374.02164 | 37.7642313225287 | -122.410727961341 | (37.7642313225287, -122.410727961341) | |||
| 56243 | 56243 | 228489 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001576.285680001 | 2101774.2319 | 37.751160574113605 | -122.437402036675 | (37.7511605741136, -122.437402036675) | |||
| 56576 | 56576 | 228499 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 38 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000241.54312 | 2106649.97851 | 37.764472207742294 | -122.442367702717 | (37.7644722077423, -122.442367702717) | |||
| 56606 | 56606 | 219177 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991107.88095 | 2106214.54011 | 37.7627517902819 | -122.473926451152 | (37.7627517902819, -122.473926451152) | |||
| 56681 | 56681 | 190671 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013262.027919999 | 2111394.33223 | 37.7782326570475 | -122.397665892288 | (37.7782326570475, -122.397665892288) | |||
| 56739 | 56739 | 246385 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006994.7646 | 2109179.687 | 37.7718007862576 | -122.419189566122 | (37.7718007862576, -122.419189566122) | |||
| 57920 | 57920 | 228456 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009403.2734199995 | 2106375.12773 | 37.7642354585115 | -122.410660248687 | (37.7642354585115, -122.410660248687) | |||
| 58955 | 58955 | 37026 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39636 | 6003698.16480104 | 2100138.36684077 | 37.746789273196796 | -122.429947677166 | (37.7467892731968, -122.429947677166) | ||
| 59088 | 59088 | 190668 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 151 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013191.282000001 | 2111332.8508900004 | 37.7780599035854 | -122.397906316128 | (37.7780599035854, -122.397906316128) | |||
| 60274 | 60274 | 228460 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2625 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010714.680480001 | 2102241.99741 | 37.7529602452298 | -122.40583328059601 | (37.7529602452298, -122.405833280596) | |||
| 60791 | 60791 | 228485 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4158 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002879.00201 | 2100672.89334 | 37.7482105324925 | -122.432818439532 | (37.7482105324925, -122.432818439532) | |||
| 61878 | 61878 | 244232 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003376.0691 | 2109331.3272 | 37.77201269653779 | -122.431717698222 | (37.7720126965378, -122.431717698222) | |||
| 62047 | 62047 | 190658 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | |||
| 63250 | 63250 | 228464 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005334.7155 | 2104318.69082 | 37.7583600194211 | -122.424585951974 | (37.7583600194211, -122.424585951974) | |||
| 63557 | 63557 | 120865 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990028.78526 | 2110554.03114 | 37.7746042888084 | -122.47797588313801 | (37.7746042888084, -122.477975883138) | |||
| 64722 | 64722 | 129090 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.803924702438394 | -122.404815037597 | (37.8039247024384, -122.404815037597) | |||
| 68617 | 68617 | 228483 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.44363115936198 | (37.751787354827, -122.443631159362) | |||
| 68672 | 68672 | 228487 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.764069559682206 | -122.41325481347401 | (37.7640695596822, -122.413254813474) | |||
| 68876 | 68876 | 228449 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009256.91005 | 2106366.76259 | 37.76420428262279 | -122.411165888909 | (37.7642042826228, -122.411165888909) | |||
| 69661 | 69661 | 190652 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 310 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.39852852018299 | (37.7621425904374, -122.398528520183) | |||
| 70029 | 70029 | 129087 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.803946988513104 | -122.40461329806801 | (37.8039469885131, -122.404613298068) | |||
| 70201 | 70201 | 32479 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 81 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 8 | Permit Number 36987 | 6000177.30918 | 2105965.99025 | 37.762590484284395 | -122.44254075744499 | (37.7625904842844, -122.442540757445) | |
| 70341 | 70341 | 228445 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 391 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004290.10245 | 2109410.4526299997 | 37.7722817243588 | -122.428561627213 | (37.7722817243588, -122.428561627213) | |||
| 70920 | 70920 | 219180 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | |||
| 71186 | 71186 | 106356 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | ||
| 71808 | 71808 | 190649 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1164 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6014097.05519 | 2105748.35032 | 37.7627765099393 | -122.394381783993 | (37.7627765099393, -122.394381783993) | |||
| 72860 | 72860 | 228438 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 597 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003321.74278 | 2109274.9224400003 | 37.7718547433349 | -122.43190158878599 | (37.7718547433349, -122.431901588786) | |||
| 73664 | 73664 | 228453 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.41088209075899 | (37.7642218454873, -122.410882090759) | |||
| 73706 | 73706 | 120866 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990027.965580001 | 2110538.28947 | 37.774561018937796 | -122.477977567474 | (37.7745610189378, -122.477977567474) | |||
| 74043 | 74043 | 67428 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.774932181016204 | -122.47517347719901 | (37.7749321810162, -122.475173477199) | |
| 74343 | 74343 | 190667 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013174.92981 | 2111315.77599 | 37.7780121091073 | -122.39796168649099 | (37.7780121091073, -122.397961686491) | |||
| 74581 | 74581 | 228446 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 379 Haight St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 5ft | 6004344.901769999 | 2109415.2001400003 | 37.7722978608825 | -122.428372409862 | (37.7722978608825, -122.428372409862) | |||
| 74585 | 74585 | 228472 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004182.38579 | 2107503.9785 | 37.767040912528294 | -122.428798292811 | (37.7670409125283, -122.428798292811) | |||
| 75156 | 75156 | 35578 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1001 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38947 | 6006352.71975705 | 2103759.98649975 | 37.7568833861691 | -122.421025568698 | (37.7568833861691, -122.421025568698) | ||
| 78873 | 78873 | 94419 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 80305 | 80305 | 32927 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1550 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 82415 | 82415 | 49456 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 83968 | 83968 | 49189 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 301 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46293 | 6005519.89358109 | 2107236.54938111 | 37.7663822259368 | -122.424153033894 | (37.7663822259368, -122.424153033894) | |||
| 84002 | 84002 | 32443 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36965 | 6001261.23901245 | 2105800.41566985 | 37.762197583242795 | -122.438779978808 | (37.7621975832428, -122.438779978808) | ||
| 84617 | 84617 | 106357 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | |||
| 85659 | 85659 | 43634 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2000 12:00:00 AM | Permit Number 43284 | 6006090.90673928 | 2100856.20266776 | 37.7488955027959 | -122.42172477262301 | (37.7488955027959, -122.421724772623) | ||
| 85917 | 85917 | 35327 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 248 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 775509 | 6006668.16520495 | 2104669.17235853 | 37.759397576581 | -122.41999915657499 | (37.759397576581, -122.419999156575) | ||
| 86179 | 86179 | 6837 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1475 FAIRFAX AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | 6 | 3X3 | 6016157.0 | 2097767.0 | 37.740975685587394 | -122.386700497992 | (37.7409756855874, -122.386700497992) | ||
| 86257 | 86257 | 49459 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");