Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2291 | 2291 | 228437 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 6 | Width 3ft | 6004091.19769 | 2108012.29591 | 37.7684314676748 | -122.429149946611 | (37.7684314676748, -122.429149946611) | ||
2946 | 2946 | 228442 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 413 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | ||
2970 | 2970 | 228443 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 401 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.42901857547301 | (37.7722283522845, -122.429018575473) | ||
2984 | 2984 | 228440 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.42962941028401 | (37.7721427080557, -122.429629410284) | ||
3025 | 3025 | 228441 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 419 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
131234 | 131234 | 228502 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 157 Randall St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6004514.7040099995 | 2097528.46975 | 37.739669302297294 | -122.426938314049 | (37.7396693022973, -122.426938314049) | |||
132350 | 132350 | 228436 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004092.7276 | 2107966.58323 | 37.768306038331794 | -122.42914139496 | (37.7683060383318, -122.42914139496) | |||
134674 | 134674 | 228506 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006728.215419999 | 2109473.21902 | 37.7725917404536 | -122.420132414803 | (37.7725917404536, -122.420132414803) | |||
136265 | 136265 | 228501 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004538.94965 | 2097529.04935 | 37.7396722646649 | -122.426854524238 | (37.7396722646649, -122.426854524238) | |||
146757 | 146757 | 129085 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008098.74192 | 2115839.1342 | 37.790148139064 | -122.41584246517701 | (37.790148139064, -122.415842465177) | |||
146861 | 146861 | 228492 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003450.5613 | 2103629.24333 | 37.756360373235204 | -122.431052978634 | (37.7563603732352, -122.431052978634) | |||
147535 | 147535 | 129089 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.40474881240601 | (37.8039285776094, -122.404748812406) | |||
148393 | 148393 | 228505 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006699.63588 | 2109500.73575 | 37.772665684492395 | -122.420233227899 | (37.7726656844924, -122.420233227899) | |||
154238 | 154238 | 190663 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1360 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016747.40621 | 2097393.1689400002 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | |||
155607 | 155607 | 228471 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 237 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004185.6843 | 2107453.8801 | 37.7669035410995 | -122.428783311922 | (37.7669035410995, -122.428783311922) | |||
155900 | 155900 | 228461 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005355.14245 | 2107219.1964 | 37.766325275216296 | -122.424721643507 | (37.7663252752163, -122.424721643507) | |||
159222 | 159222 | 228434 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004130.46793 | 2107245.14017 | 37.7663272663153 | -122.428959412666 | (37.7663272663153, -122.428959412666) | |||
159768 | 159768 | 228465 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 321 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004210.24642 | 2107036.07535 | 37.7657577400449 | -122.42866856921101 | (37.7657577400449, -122.428668569211) | |||
160550 | 160550 | 228458 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1332 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009514.46513 | 2101394.10676 | 37.7505649315368 | -122.409924021381 | (37.7505649315368, -122.409924021381) | |||
161401 | 161401 | 228484 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000983.78885 | 2101507.81072 | 37.750395343677795 | -122.439431853304 | (37.7503953436778, -122.439431853304) | |||
161698 | 161698 | 228439 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 589 Haight St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003347.45965 | 2109278.2341 | 37.7718652941806 | -122.43181286889099 | (37.7718652941806, -122.431812868891) | |||
162506 | 162506 | 190651 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012696.96101 | 2105116.13755 | 37.760962664614 | -122.399179866755 | (37.760962664614, -122.399179866755) | |||
165619 | 165619 | 228447 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 365 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004400.01174 | 2109424.0096400003 | 37.7723251679145 | -122.428182407399 | (37.7723251679145, -122.428182407399) | |||
165639 | 165639 | 228444 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 399 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004268.91864 | 2109406.8209700002 | 37.772270553861496 | -122.428634644993 | (37.7722705538615, -122.428634644993) | |||
167042 | 167042 | 228432 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004140.61494 | 2107068.90552 | 37.7658439427747 | -122.42891175039301 | (37.7658439427747, -122.428911750393) | |||
168166 | 168166 | 228462 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.768304778378294 | -122.418472926402 | (37.7683047783783, -122.418472926402) | |||
168299 | 168299 | 228470 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004187.12028 | 2107418.48366 | 37.766806432287 | -122.42877582146299 | (37.766806432287, -122.428775821463) | |||
169717 | 169717 | 228491 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004217.2996 | 2105758.4451200003 | 37.762250072909104 | -122.428553095368 | (37.7622500729091, -122.428553095368) | |||
172245 | 172245 | 190653 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 320 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012892.66651 | 2105479.7779900003 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | |||
173298 | 173298 | 228431 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006055.135530001 | 2108039.7727 | 37.7686178926417 | -122.42235880430799 | (37.7686178926417, -122.422358804308) | |||
174174 | 174174 | 228474 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004967.29881 | 2109550.52085 | 37.772704617954105 | -122.42622911677601 | (37.7727046179541, -122.426229116776) | |||
174253 | 174253 | 190654 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 330 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012898.89819 | 2105464.4496299997 | 37.7619303045744 | -122.398505891451 | (37.7619303045744, -122.398505891451) | |||
174866 | 174866 | 228507 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006742.36606 | 2109459.07113 | 37.772553691019894 | -122.420082461948 | (37.7725536910199, -122.420082461948) | |||
175553 | 175553 | 228486 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 62 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009328.577269999 | 2097075.3639 | 37.7386961926807 | -122.41026195063 | (37.7386961926807, -122.41026195063) | |||
179503 | 179503 | 228469 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 251 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004187.68386 | 2107403.8081400003 | 37.766766168745896 | -122.428772825825 | (37.7667661687459, -122.428772825825) | |||
180413 | 180413 | 228448 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 353 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004452.39919 | 2109432.87501 | 37.7723524740195 | -122.42800182623002 | (37.7723524740195, -122.42800182623) | |||
181483 | 181483 | 120833 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989987.953 | 2110566.55394 | 37.7746363029346 | -122.478118044214 | (37.7746363029346, -122.478118044214) | |||
181692 | 181692 | 228475 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004951.6216 | 2109548.73886 | 37.772698838907 | -122.426283219097 | (37.772698838907, -122.426283219097) | |||
182542 | 182542 | 228508 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006756.01858 | 2109446.24098 | 37.7725192316996 | -122.420034325725 | (37.7725192316996, -122.420034325725) | |||
182749 | 182749 | 228503 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007243.83648 | 2109064.60146 | 37.7714988123571 | -122.418319846488 | (37.7714988123571, -122.418319846488) | |||
183998 | 183998 | 228468 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 305 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004204.63343 | 2107110.4699 | 37.765961691906796 | -122.42869328709101 | (37.7659616919068, -122.428693287091) | |||
186052 | 186052 | 228495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004273.17296 | 2105900.1551200002 | 37.762642336504705 | -122.42836995111999 | (37.7626423365047, -122.42836995112) | |||
186493 | 186493 | 228463 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 246 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006676.82806 | 2104669.9679099997 | 37.7594002490446 | -122.419969252575 | (37.7594002490446, -122.419969252575) | |||
186641 | 186641 | 228467 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004207.05311 | 2107076.17172 | 37.7658676543027 | -122.428682472728 | (37.7658676543027, -122.428682472728) |
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");