Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8508 | 8508 | 23534 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005725.00193 | 2119903.11609 | 37.801173073737296 | -122.42434460004999 | (37.8011730737373, -122.42434460005) | |||
14917 | 14917 | 21989 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015918.99863 | 2103291.42641 | 37.7561314319344 | -122.38790881913401 | (37.7561314319344, -122.387908819134) | |||
15669 | 15669 | 117221 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013696.95586 | 2111359.6496200003 | 37.778161635782396 | -122.39615887494499 | (37.7781616357824, -122.396158874945) | |
16663 | 16663 | 100274 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015236.2818 | 2113554.4161799997 | 37.7842734985691 | -122.390987179627 | (37.7842734985691, -122.390987179627) | |||
24093 | 24093 | 128339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6011923.93675 | 2120509.9323 | 37.803187330300496 | -122.40293616766701 | (37.8031873303005, -122.402936167667) | |||
27683 | 27683 | 225509 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Church St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6004197.80145 | 2106206.80833 | 37.7634800675805 | -122.42865249471201 | (37.7634800675805, -122.428652494712) | |||
27960 | 27960 | 246686 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6004961.87116 | 2097597.9446799997 | 37.7398853392354 | -122.425397143159 | (37.7398853392354, -122.425397143159) | |||
28533 | 28533 | 128604 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 302 Clay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012720.62392 | 2117571.18335 | 37.7951626850618 | -122.399972696483 | (37.7951626850618, -122.399972696483) | |||
29101 | 29101 | 127927 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Leavenworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007301.7835 | 2122057.61602 | 37.80717769417 | -122.41904114053499 | (37.80717769417, -122.419041140535) | |||
29909 | 29909 | 192029 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012902.721580001 | 2110721.58768 | 37.7763654396501 | -122.39886164526301 | (37.7763654396501, -122.398861645263) | |||
35364 | 35364 | 128452 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Leidesdorff St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012151.25811 | 2116572.97679 | 37.7923900877774 | -122.401872599739 | (37.7923900877774, -122.401872599739) | |||
35476 | 35476 | 128030 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2601 Jones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007872.77059 | 2121403.52137 | 37.805413852943104 | -122.41701873613 | (37.8054138529431, -122.41701873613) | |||
35622 | 35622 | 116053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 4x4 | 6011508.109619999 | 2105241.51829 | 37.761240606399795 | -122.40330042728901 | (37.7612406063998, -122.403300427289) | ||
35874 | 35874 | 189706 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Wisconsin St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6012644.064180001 | 2105069.3805400003 | 37.760831332131296 | -122.399359532434 | (37.7608313321313, -122.399359532434) | |||
38110 | 38110 | 128157 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 200 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008823.92017 | 2122168.8612 | 37.8075687418561 | -122.413781315277 | (37.8075687418561, -122.413781315277) | |||
38702 | 38702 | 128595 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 298 Clay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013078.47756 | 2117624.4089200003 | 37.79532877454321 | -122.398738196213 | (37.7953287745432, -122.398738196213) | |||
40437 | 40437 | 189735 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 Carolina St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6012410.52829 | 2105115.38305 | 37.7609446260225 | -122.400170465508 | (37.7609446260225, -122.400170465508) | |||
41494 | 41494 | 128260 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011214.5858 | 2119722.1779400003 | 37.8009847143318 | -122.40533540152 | (37.8009847143318, -122.40533540152) | |||
42266 | 42266 | 127096 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1550 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003346.89879 | 2120714.49093 | 37.8032663249393 | -122.432631856298 | (37.8032663249393, -122.432631856298) | |||
42541 | 42541 | 128135 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Jones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007852.40976 | 2121884.93258 | 37.8067345406434 | -122.417123330884 | (37.8067345406434, -122.417123330884) | |||
44223 | 44223 | 128534 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012182.93636 | 2116816.5819200003 | 37.7930607374112 | -122.40178012248 | (37.7930607374112, -122.40178012248) | |||
46411 | 46411 | 192099 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6010725.77317 | 2108634.4169099997 | 37.7705130105866 | -122.406245268117 | (37.7705130105866, -122.406245268117) | |||
46504 | 46504 | 225362 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 127 Otis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007088.618530001 | 2109536.64947 | 37.7727862053595 | -122.418890239704 | (37.7727862053595, -122.418890239704) | |||
48002 | 48002 | 128673 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013372.48948 | 2117974.54062 | 37.7963065300838 | -122.397745431009 | (37.7963065300838, -122.397745431009) | |||
51376 | 51376 | 190212 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Main St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013901.3012 | 2116638.71234 | 37.7926680934122 | -122.395821969133 | (37.7926680934122, -122.395821969133) | |||
51831 | 51831 | 112704 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6010051.400909999 | 2121995.09516 | 37.807160479332104 | -122.409521041462 | (37.8071604793321, -122.409521041462) | |||
52937 | 52937 | 126686 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Divisadero St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 6000576.75881 | 2117918.99228 | 37.795433141791705 | -122.44201721443999 | (37.7954331417917, -122.44201721444) | |||
53515 | 53515 | 189632 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1455 11th St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007298.00895 | 2110457.3775 | 37.775326093154504 | -122.4182312237 | (37.7753260931545, -122.4182312237) | |||
54156 | 54156 | 190161 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 70 Steuart St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6014398.2376 | 2117062.09788 | 37.7938582436193 | -122.39413219064899 | (37.7938582436193, -122.394132190649) | |||
54564 | 54564 | 192069 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011186.3676 | 2107464.93063 | 37.7673276208966 | -122.404569722336 | (37.7673276208966, -122.404569722336) | |||
54954 | 54954 | 127069 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 9 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6001380.49031 | 2119587.4899 | 37.800060166303396 | -122.439355830906 | (37.8000601663034, -122.439355830906) | |||
56249 | 56249 | 128189 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 151 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009528.348040001 | 2122220.78416 | 37.8077508429053 | -122.411347139176 | (37.8077508429053, -122.411347139176) | |||
58222 | 58222 | 190248 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012269.23486 | 2114994.91979 | 37.788063699414394 | -122.401353446303 | (37.7880636994144, -122.401353446303) | |||
58333 | 58333 | 127698 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 751 Powell St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 5ft | 6010051.434780001 | 2116188.24535 | 37.7912162971438 | -122.409110915531 | (37.7912162971438, -122.409110915531) | |||
60340 | 60340 | 190103 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6014885.29467 | 2113497.67268 | 37.784098211716596 | -122.392197511514 | (37.7840982117166, -122.392197511514) | |||
60981 | 60981 | 189618 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1022 Harrison St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 0ft | 6010891.122930001 | 2110540.49572 | 37.7757559115527 | -122.40580760405199 | (37.7757559115527, -122.405807604052) | |||
62608 | 62608 | 128226 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 68 Green St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012467.83694 | 2119552.09835 | 37.800587705929104 | -122.40098663443001 | (37.8005877059291, -122.40098663443) | |||
65977 | 65977 | 189814 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 San Bruno Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010837.6944 | 2107202.68017 | 37.766588048125 | -122.40575726540399 | (37.766588048125, -122.405757265404) | |||
65987 | 65987 | 128151 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007611.874369999 | 2121662.99743 | 37.806111628806 | -122.417940009725 | (37.806111628806, -122.417940009725) | |||
66986 | 66986 | 128118 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2300 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009758.48929 | 2122143.44991 | 37.807551407435604 | -122.41054521191799 | (37.8075514074356, -122.410545211918) | |||
68361 | 68361 | 128175 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009042.02771 | 2122152.12434 | 37.80753503259 | -122.413025316376 | (37.80753503259, -122.413025316376) | |||
68408 | 68408 | 128092 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009993.77559 | 2121931.64675 | 37.806983036790704 | -122.409715985714 | (37.8069830367907, -122.409715985714) | |||
71337 | 71337 | 190343 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014833.65153 | 2116067.9736900004 | 37.7911528005014 | -122.39255603344499 | (37.7911528005014, -122.392556033445) | |||
74412 | 74412 | 126993 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3298 Lyon St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5998985.37551 | 2120178.1493599997 | 37.8015453660859 | -122.447686356233 | (37.8015453660859, -122.447686356233) | ||||
74607 | 74607 | 189822 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 9ft | 6010499.44736 | 2107381.21521 | 37.767059343243105 | -122.40693979295901 | (37.7670593432431, -122.406939792959) | |||
75046 | 75046 | 117412 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6010061.45891 | 2122289.54556 | 37.8079695301268 | -122.409507028246 | (37.8079695301268, -122.409507028246) | |||
75508 | 75508 | 190106 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Utah St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010614.87251 | 2107171.0183599996 | 37.7664886487543 | -122.406525739687 | (37.7664886487543, -122.406525739687) | |||
85620 | 85620 | 102343 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401X Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007842.0 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | |||
120435 | 120435 | 192078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Vermont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011151.47451 | 2107676.74683 | 37.7679072699252 | -122.40470532661502 | (37.7679072699252, -122.404705326615) | |||
130481 | 130481 | 128101 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2021 Grant Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010201.6794300005 | 2122072.10494 | 37.807380348299205 | -122.409006405322 | (37.8073803482992, -122.409006405322) | |||
132399 | 132399 | 128278 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011061.67313 | 2121388.2914299998 | 37.805550902426795 | -122.40598198527901 | (37.8055509024268, -122.405981985279) | |||
136917 | 136917 | 128294 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6011739.96085 | 2120785.45853 | 37.8039335832322 | -122.403592222228 | (37.8039335832322, -122.403592222228) | |||
137177 | 137177 | 127669 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Gough St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005967.66445 | 2111019.78524 | 37.7767953560506 | -122.422873178776 | (37.7767953560506, -122.422873178776) | |||
147723 | 147723 | 128329 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012232.63736 | 2119812.905 | 37.801290695179894 | -122.40181886884199 | (37.8012906951799, -122.401818868842) | |||
148770 | 148770 | 128757 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 Geary St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6010952.86492 | 2114849.98538 | 37.7875922118533 | -122.40589766486201 | (37.7875922118533, -122.405897664862) | |||
153450 | 153450 | 128423 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 California St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011652.824019999 | 2116681.38522 | 37.792659922157796 | -122.403604835222 | (37.7926599221578, -122.403604835222) | |||
155682 | 155682 | 189052 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1498 Fairfax Ave | 9 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6016122.19881 | 2097851.77649 | 37.741206537755296 | -122.38682673957199 | (37.7412065377553, -122.386826739572) | |||
156454 | 156454 | 190181 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014094.610119999 | 2116862.4766700002 | 37.7932932499214 | -122.395168788833 | (37.7932932499214, -122.395168788833) | |||
157931 | 157931 | 192127 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 807 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6011174.16734 | 2113444.92425 | 37.7837466199541 | -122.405033027869 | (37.7837466199541, -122.405033027869) | |||
158073 | 158073 | 124713 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3801 Jackson St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5996049.91136 | 2115838.85181 | 37.78946263352571 | -122.457530193146 | (37.7894626335257, -122.457530193146) | |||
158853 | 158853 | 127636 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 11 Hyde St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008243.47914 | 2111763.6926700003 | 37.778966097334106 | -122.415053096938 | (37.7789660973341, -122.415053096938) | |||
162473 | 162473 | 224416 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Treat Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6008516.77997 | 2105987.6049 | 37.7631216679456 | -122.413698975134 | (37.7631216679456, -122.413698975134) | |||
162895 | 162895 | 128018 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 590 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008038.597 | 2121376.6539 | 37.8053494084019 | -122.416442965895 | (37.8053494084019, -122.416442965895) | |||
163817 | 163817 | 128697 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012777.65332 | 2117891.0241099996 | 37.7960440710348 | -122.399797834099 | (37.7960440710348, -122.399797834099) | |||
165230 | 165230 | 127620 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 888 O'Farrell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6007042.74082 | 2114007.27438 | 37.7850588791954 | -122.419366145639 | (37.7850588791954, -122.419366145639) | |||
168612 | 168612 | 192113 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 367 Tehama St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011501.93196 | 2112608.02873 | 37.7814670175328 | -122.403840169795 | (37.7814670175328, -122.403840169795) | |||
169328 | 169328 | 128578 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012817.381680001 | 2117842.3154700003 | 37.795912543372296 | -122.39965694361901 | (37.7959125433723, -122.399656943619) | |||
171440 | 171440 | 127601 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7 Ada Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008097.935930001 | 2114185.63609 | 37.785607990854004 | -122.415728126257 | (37.785607990854, -122.415728126257) | |||
173820 | 173820 | 127515 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 335 Powell St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6010244.58304 | 2114855.01998 | 37.787566398622495 | -122.40834854674699 | (37.7875663986225, -122.408348546747) | |||
177604 | 177604 | 190238 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013026.80272 | 2115299.87413 | 37.7889432705555 | -122.398753786863 | (37.7889432705555, -122.398753786863) | |||
177893 | 177893 | 128360 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1335 Battery St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012168.05905 | 2120565.84348 | 37.8033544773788 | -122.402095303366 | (37.8033544773788, -122.402095303366) | |||
178009 | 178009 | 126887 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Laurel St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5997958.22351 | 2116171.20498 | 37.7904846177085 | -122.450951650704 | (37.7904846177085, -122.450951650704) | |||
178477 | 178477 | 192089 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 09th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6010646.91946 | 2108374.2192599997 | 37.7697941564051 | -122.406499687216 | (37.7697941564051, -122.406499687216) | |||
179009 | 179009 | 128067 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 262 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6009106.30735 | 2121812.3096 | 37.8066055949469 | -122.412778821206 | (37.8066055949469, -122.412778821206) | |||
180400 | 180400 | 127645 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 30 Grove St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007914.85136 | 2111702.90673 | 37.7787807209819 | -122.41618564914499 | (37.7787807209819, -122.416185649145) | |||
181140 | 181140 | 218860 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1251 Funston Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5992040.08055 | 2106742.72997 | 37.764256010743296 | -122.470740807837 | (37.7642560107433, -122.470740807837) | |||
181561 | 181561 | 190308 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6014212.34397 | 2115184.6648 | 37.7886929154874 | -122.39464387161999 | (37.7886929154874, -122.39464387162) | |||
183921 | 183921 | 128686 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 270 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012997.953840001 | 2117920.58434 | 37.796137515079 | -122.399037621889 | (37.796137515079, -122.399037621889) |
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");