Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker
qCareAssistant ✖
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188891 | 188891 | 224697 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.752431548191296 | -122.415947634593 | (37.7524315481913, -122.415947634593) | |||
| 188375 | 188375 | 224570 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007990.36824 | 2105589.83292 | 37.7619999031047 | -122.415491498431 | (37.7619999031047, -122.415491498431) | |||
| 187775 | 187775 | 250901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | |||
| 187652 | 187652 | 218807 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999815.8902199995 | 2094384.2804599998 | 37.7307692875673 | -122.44295901504299 | (37.7307692875673, -122.442959015043) | |||
| 187559 | 187559 | 224649 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | |||
| 187354 | 187354 | 218829 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | |||
| 187298 | 187298 | 111610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.71833459814221 | -122.403290521257 | (37.7183345981422, -122.403290521257) | |||
| 186397 | 186397 | 218803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.46913081273199 | (37.7439598068059, -122.469130812732) | |||
| 185595 | 185595 | 199430 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | |||
| 185528 | 185528 | 55317 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1126 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 4 | Permit Number 11246 | 6011285.28669 | 2089520.6507599999 | 37.7180620109438 | -122.402965322811 | (37.7180620109438, -122.402965322811) | ||
| 185301 | 185301 | 224613 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999489.63243 | 2102445.2352299998 | 37.7528841365055 | -122.44466610455 | (37.7528841365055, -122.44466610455) | |||
| 185283 | 185283 | 224630 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 661 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007657.44331 | 2096273.95417 | 37.7364018809509 | -122.415983219874 | (37.7364018809509, -122.415983219874) | |||
| 185146 | 185146 | 224624 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | |||
| 184726 | 184726 | 224575 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3143 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008614.79517 | 2105624.76629 | 37.7621309001374 | -122.413334311737 | (37.7621309001374, -122.413334311737) | |||
| 184359 | 184359 | 111317 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1114 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011270.9057 | 2089563.6222599999 | 37.7181791988873 | -122.403018052761 | (37.7181791988873, -122.403018052761) | |||
| 184163 | 184163 | 176435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 275 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993714.58235 | 2086792.86785 | 37.7095753489021 | -122.46350132202299 | (37.7095753489021, -122.463501322023) | |||
| 183571 | 183571 | 224487 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6007167.0998599995 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | |||
| 183406 | 183406 | 224652 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 50 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007400.925369999 | 2098998.39155 | 37.74386815689579 | -122.41706309608601 | (37.7438681568958, -122.417063096086) | |||
| 182926 | 182926 | 66628 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 16 | Permit Number 29832 | 6002951.536859999 | 2091458.2652 | 37.7229133848294 | -122.43190974564399 | (37.7229133848294, -122.431909745644) | ||
| 182594 | 182594 | 224610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 87 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000904.1974 | 2097866.66824 | 37.740393101855204 | -122.43944610755699 | (37.7403931018552, -122.439446107557) | |||
| 182441 | 182441 | 224648 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 26 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006463.11483 | 2098326.0770400004 | 37.7419693319081 | -122.420258125606 | (37.7419693319081, -122.420258125606) | |||
| 182435 | 182435 | 224565 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3149 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008534.1903 | 2105038.29661 | 37.760516063079706 | -122.41357161315399 | (37.7605160630797, -122.413571613154) | |||
| 182314 | 182314 | 218832 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | |||
| 182174 | 182174 | 224548 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007664.7835 | 2104406.9953900003 | 37.7587337983464 | -122.416533781209 | (37.7587337983464, -122.416533781209) | |||
| 182052 | 182052 | 224577 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3137 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008697.40376 | 2105629.5564599996 | 37.762148690535795 | -122.413048937978 | (37.7621486905358, -122.413048937978) | |||
| 181817 | 181817 | 66495 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2476 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 14 | Permit Number 772310 | 6001690.937999999 | 2114651.3348 | 37.78652442918529 | -122.437927807736 | (37.7865244291853, -122.437927807736) | |
| 181334 | 181334 | 224503 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006785.203840001 | 2096905.7488900002 | 37.7380875710875 | -122.41904372338301 | (37.7380875710875, -122.419043723383) | |||
| 181310 | 181310 | 218840 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | |||
| 181204 | 181204 | 176413 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6001088.39895 | 2089005.3588599998 | 37.7160724587542 | -122.43817458219999 | (37.7160724587542, -122.4381745822) | |||
| 180807 | 180807 | 176414 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 850 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001021.05329 | 2088894.2263099998 | 37.7157634831843 | -122.43839940283199 | (37.7157634831843, -122.438399402832) | |||
| 180059 | 180059 | 116038 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1401x Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008011.067530001 | 2116537.17208 | 37.792059850433795 | -122.416195270994 | (37.7920598504338, -122.416195270994) | |||
| 179949 | 179949 | 224528 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 281 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006752.8545699995 | 2102173.9944599997 | 37.7525511643191 | -122.41952923228901 | (37.7525511643191, -122.419529232289) | |||
| 179557 | 179557 | 176434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389841999 | (37.714006934552, -122.47040389842) | |||
| 179495 | 179495 | 224576 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3139 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008637.01425 | 2105626.66822 | 37.76213736985971 | -122.41325759868401 | (37.7621373698597, -122.413257598684) | |||
| 179447 | 179447 | 224562 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3107 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008636.342180001 | 2105044.1595400004 | 37.760537896817105 | -122.413218729979 | (37.7605378968171, -122.413218729979) | |||
| 178907 | 178907 | 176419 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 638 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6002178.18938 | 2090229.77829 | 37.719496363045295 | -122.43449524976002 | (37.7194963630453, -122.43449524976) | |||
| 178689 | 178689 | 226475 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008399.696219999 | 2105072.76604 | 37.760603155239295 | -122.41403920664301 | (37.7606031552393, -122.414039206643) | |||
| 178528 | 178528 | 224520 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007846.93969 | 2105383.76914 | 37.7614260366957 | -122.41597297028 | (37.7614260366957, -122.41597297028) | |||
| 178436 | 178436 | 126616 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.797125207219295 | -122.443251440404 | (37.7971252072193, -122.443251440404) | |||
| 178369 | 178369 | 224711 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3287 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006422.5903900005 | 2103751.13112 | 37.756863009738396 | -122.42078330091299 | (37.7568630097384, -122.420783300913) | |||
| 178284 | 178284 | 226485 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544938999 | (37.7622371604259, -122.41372544939) | |||
| 177800 | 177800 | 224612 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999484.75601 | 2102435.63345 | 37.752857494093206 | -122.444682277976 | (37.7528574940932, -122.444682277976) | |||
| 177584 | 177584 | 224595 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3139 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005929.78445 | 2106647.5805099998 | 37.7647881917533 | -122.422693436658 | (37.7647881917533, -122.422693436658) | |||
| 177370 | 177370 | 226489 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2496 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008832.21298 | 2104006.96318 | 37.757700986321 | -122.41246798312001 | (37.757700986321, -122.41246798312) | |||
| 176889 | 176889 | 224504 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3771 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007856.89018 | 2097735.38644 | 37.740425864155604 | -122.41539707591002 | (37.7404258641556, -122.41539707591) | |||
| 176566 | 176566 | 218809 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661001 | (37.720406603762, -122.45403210661) | |||
| 176422 | 176422 | 226481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007993.239469999 | 2105048.9001700003 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | |||
| 176263 | 176263 | 224698 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3196 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007749.279159999 | 2102109.5588 | 37.7524303134304 | -122.416078852874 | (37.7524303134304, -122.416078852874) | |||
| 175781 | 175781 | 126621 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | |||
| 175679 | 175679 | 224635 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007212.97385 | 2098214.14312 | 37.7417042108849 | -122.417657415761 | (37.7417042108849, -122.417657415761) | |||
| 175419 | 175419 | 224660 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 602 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008966.9840400005 | 2105222.67226 | 37.761046609131895 | -122.41208780281 | (37.7610466091319, -122.41208780281) | |||
| 175313 | 175313 | 226469 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3005 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009304.0856800005 | 2104491.35381 | 37.759057483222605 | -122.41087025746 | (37.7590574832226, -122.41087025746) | |||
| 175285 | 175285 | 226493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008772.32666 | 2104949.6501700003 | 37.7602860290962 | -122.41274173856002 | (37.7602860290962, -122.41274173856) | |||
| 175191 | 175191 | 224633 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 196 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007335.08307 | 2097320.51793 | 37.739257384923704 | -122.41717189426599 | (37.7392573849237, -122.417171894266) | |||
| 174580 | 174580 | 218831 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991205.91202 | 2098425.81226 | 37.7413716577778 | -122.473019387736 | (37.7413716577778, -122.473019387736) | |||
| 174569 | 174569 | 218806 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 217 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999893.776380001 | 2094346.53737 | 37.730670094141296 | -122.44268704209 | (37.7306700941413, -122.44268704209) | |||
| 174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) | |||
| 173926 | 173926 | 126630 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | |||
| 173787 | 173787 | 224599 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3316 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006227.0887 | 2103782.97651 | 37.756939428723 | -122.42146168110901 | (37.756939428723, -122.421461681109) | |||
| 173739 | 173739 | 224639 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 150 Kingston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006112.4253 | 2098109.96948 | 37.7413561822494 | -122.42145535528601 | (37.7413561822494, -122.421455355286) | |||
| 173633 | 173633 | 224486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | |||
| 173567 | 173567 | 224636 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | |||
| 172813 | 172813 | 176409 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 45 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998625.6999 | 2087888.85423 | 37.7128664206305 | -122.44660652136999 | (37.7128664206305, -122.44660652137) | |||
| 172582 | 172582 | 224655 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | |||
| 171712 | 171712 | 224488 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998533.31147 | 2106291.41144 | 37.763390161444896 | -122.44825016102502 | (37.7633901614449, -122.448250161025) | |||
| 171666 | 171666 | 250762 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 231 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5985862.1127 | 2114339.7343200003 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | |||
| 171571 | 171571 | 224581 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008597.08192 | 2106800.1507599996 | 37.765357240457604 | -122.413478706001 | (37.7653572404576, -122.413478706001) | |||
| 171450 | 171450 | 224515 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007854.81877 | 2105216.20423 | 37.7609663850986 | -122.41593385338699 | (37.7609663850986, -122.415933853387) | |||
| 171323 | 171323 | 224651 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 157 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006794.80583 | 2098578.82638 | 37.742682009579504 | -122.41912916617599 | (37.7426820095795, -122.419129166176) | |||
| 171301 | 171301 | 218823 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 122 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992474.68721 | 2088695.0453700002 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | |||
| 170821 | 170821 | 176422 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009782.31983 | 2092607.2094299998 | 37.726453016592394 | -122.40837804183701 | (37.7264530165924, -122.408378041837) | |||
| 170759 | 170759 | 224629 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 329 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007740.48208 | 2097528.6384 | 37.7398516362417 | -122.415784934638 | (37.7398516362417, -122.415784934638) | |||
| 170568 | 170568 | 224647 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 11 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006471.9777 | 2098350.49655 | 37.74203688180479 | -122.420229213316 | (37.7420368818048, -122.420229213316) | |||
| 170500 | 170500 | 226479 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008278.21403 | 2105065.6529900003 | 37.7605768005893 | -122.414458856385 | (37.7605768005893, -122.414458856385) | |||
| 170317 | 170317 | 176404 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998751.95541 | 2087834.14028 | 37.712723399629 | -122.44616620971901 | (37.712723399629, -122.446166209719) | |||
| 169537 | 169537 | 218843 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 661 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5997657.5738 | 2098142.0216099997 | 37.740963852094204 | -122.450691444481 | (37.7409638520942, -122.450691444481) | |||
| 169405 | 169405 | 226499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 133 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005600.01114 | 2099028.12585 | 37.7438483268298 | -122.42329235906999 | (37.7438483268298, -122.42329235907) | |||
| 169194 | 169194 | 218815 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.855380001 | 2088132.4441900002 | 37.713377975685205 | -122.456118052609 | (37.7133779756852, -122.456118052609) | |||
| 169115 | 169115 | 224605 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 71 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005897.27948 | 2103429.1332799997 | 37.7559492562604 | -122.42257714351801 | (37.7559492562604, -122.422577143518) | |||
| 168986 | 168986 | 224552 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007727.866880001 | 2104411.29924 | 37.758749163250705 | -122.41631591415899 | (37.7587491632507, -122.416315914159) | |||
| 168974 | 168974 | 224551 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007716.60877 | 2104410.35168 | 37.7587459283935 | -122.416354782871 | (37.7587459283935, -122.416354782871) | |||
| 168890 | 168890 | 61440 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.3750299998 | 37.797131528551795 | -122.443200241996 | (37.7971315285518, -122.443200241996) | ||
| 167883 | 167883 | 224675 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 121 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007745.9196 | 2107233.93005 | 37.7665004685576 | -122.41645341510001 | (37.7665004685576, -122.4164534151) | |||
| 167655 | 167655 | 226484 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008470.16955 | 2105663.03593 | 37.7622278587398 | -122.413837225211 | (37.7622278587398, -122.413837225211) | |||
| 167625 | 167625 | 218817 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 431 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996521.08411 | 2089810.0200599998 | 37.7180210513199 | -122.454019381193 | (37.7180210513199, -122.454019381193) | |||
| 167351 | 167351 | 226478 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008300.96502 | 2105069.13983 | 37.760587652724396 | -122.41438041754 | (37.7605876527244, -122.41438041754) | |||
| 166637 | 166637 | 224506 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2404 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008170.5791 | 2104405.7281 | 37.758758750933204 | -122.414784412782 | (37.7587587509332, -122.414784412782) | |||
| 166587 | 166587 | 224484 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1514 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6007262.01073 | 2107365.0441 | 37.7668332518872 | -122.418136469321 | (37.7668332518872, -122.418136469321) | |||
| 166125 | 166125 | 176425 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011982.06755 | 2090001.3363400002 | 37.71942076063571 | -122.400590586484 | (37.7194207606357, -122.400590586484) | |||
| 166019 | 166019 | 249547 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6006068.98024 | 2114032.1287599998 | 37.7850722314402 | -122.422736821748 | (37.7850722314402, -122.422736821748) | |||
| 165447 | 165447 | 224622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999026.564590001 | 2105047.83376 | 37.7600037939542 | -122.446454694247 | (37.7600037939542, -122.446454694247) | |||
| 165442 | 165442 | 224493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | |||
| 164944 | 164944 | 224679 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007366.7394199995 | 2101988.35955 | 37.752076011999605 | -122.417393153575 | (37.7520760119996, -122.417393153575) | |||
| 164912 | 164912 | 224713 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3546 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006637.61846 | 2104388.97132 | 37.7586264885425 | -122.420084917099 | (37.7586264885425, -122.420084917099) | |||
| 164846 | 164846 | 224634 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 248 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006846.03495 | 2097621.06949 | 37.740055107862 | -122.418884118001 | (37.740055107862, -122.418884118001) | |||
| 164602 | 164602 | 218842 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997801.418330001 | 2096410.61107 | 37.73621804871821 | -122.450069323134 | (37.7362180487182, -122.450069323134) | |||
| 164569 | 164569 | 218837 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 725 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990923.73813 | 2099033.65671 | 37.7430243014348 | -122.474039375442 | (37.7430243014348, -122.474039375442) | |||
| 164535 | 164535 | 218833 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991183.94041 | 2098426.0210599997 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | |||
| 163279 | 163279 | 224602 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3344 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006035.96544 | 2103769.71631 | 37.756892241295 | -122.422121716065 | (37.756892241295, -122.422121716065) | |||
| 163111 | 163111 | 224522 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007847.20121 | 2105421.64723 | 37.7615300558868 | -122.41597474823799 | (37.7615300558868, -122.415974748238) |
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");