Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89159 | 89159 | 116393 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
| 89201 | 89201 | 63396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/1987 12:00:00 AM | Permit Number 23978 | 6001653.34817436 | 2104704.40880226 | 37.759210515065 | -122.437345341266 | (37.759210515065, -122.437345341266) | ||
| 89556 | 89556 | 60840 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 315 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20614 | 6004809.28697134 | 2101883.59513704 | 37.7516441291888 | -122.426229752639 | (37.7516441291888, -122.426229752639) | ||
| 89586 | 89586 | 56750 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21307 | 6002862.2859563 | 2108898.25983772 | 37.770794463527395 | -122.433463958699 | (37.7707944635274, -122.433463958699) | ||
| 89802 | 89802 | 66224 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 32 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29318 | 6005343.90687 | 2105779.62004334 | 37.762371905949294 | -122.424658088706 | (37.7623719059493, -122.424658088706) | ||
| 90068 | 90068 | 34157 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 90109 | 90109 | 60554 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.49526942507799 | (37.7783990952425, -122.495269425078) | ||
| 90199 | 90199 | 65243 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.754513650320504 | -122.411231929366 | (37.7545136503205, -122.411231929366) | ||
| 90236 | 90236 | 48791 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 90327 | 90327 | 61785 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.750732029491296 | -122.40115133594601 | (37.7507320294913, -122.401151335946) | ||
| 90375 | 90375 | 116392 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
| 90546 | 90546 | 64702 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 110 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25683 | 6010200.02442425 | 2113768.63085544 | 37.7845809377612 | -122.40842605163701 | (37.7845809377612, -122.408426051637) | ||
| 90592 | 90592 | 62334 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 66 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22476 | 6005174.05627534 | 2096389.57268342 | 37.7365794079222 | -122.424577561345 | (37.7365794079222, -122.424577561345) | ||
| 91026 | 91026 | 59961 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 444 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | Permit Number 19440 | 6005671.77527769 | 2111387.84010103 | 37.7777892453109 | -122.4239229277 | (37.7777892453109, -122.4239229277) | ||
| 91059 | 91059 | 30886 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.40601460797501 | (37.8012494094877, -122.406014607975) | ||||
| 91089 | 91089 | 65540 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2154 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 3x3 | Permit Number 28437 | 6002291.71421754 | 2114386.89695038 | 37.78583249572021 | -122.43583034619199 | (37.7858324957202, -122.435830346192) | |
| 91179 | 91179 | 117224 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 91480 | 91480 | 30505 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | |||
| 91790 | 91790 | 36252 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 243 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39269 | 6005153.47922718 | 2108192.45520893 | 37.7689862189606 | -122.42548843025 | (37.7689862189606, -122.42548843025) | ||
| 91851 | 91851 | 114017 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
| 91896 | 91896 | 33764 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
| 92014 | 92014 | 103152 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
| 92404 | 92404 | 55576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2309 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24775 | 6002194.69587728 | 2107036.79090461 | 37.76564542937879 | -122.43563996790199 | (37.7656454293788, -122.435639967902) | ||
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 92579 | 92579 | 114018 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
| 92829 | 92829 | 63410 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23993 | 6007543.2306715 | 2095481.74721631 | 37.7342202321398 | -122.41632200823601 | (37.7342202321398, -122.416322008236) | ||
| 92840 | 92840 | 48042 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
| 92970 | 92970 | 54514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | ||
| 93347 | 93347 | 115029 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 93573 | 93573 | 66119 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29179 | 6005470.38749546 | 2110092.46405208 | 37.7742210861409 | -122.424527432779 | (37.7742210861409, -122.424527432779) | ||
| 93578 | 93578 | 63203 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.78070467946971 | -122.496631747831 | (37.7807046794697, -122.496631747831) | ||
| 93794 | 93794 | 64591 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1988 12:00:00 AM | Permit Number 25492 | 6005853.76544152 | 2103715.18666196 | 37.756732237337395 | -122.422747957423 | (37.7567322373374, -122.422747957423) | ||
| 94045 | 94045 | 62670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1328 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1986 12:00:00 AM | Permit Number 23002 | 6002790.04269178 | 2111680.73625558 | 37.7784303546549 | -122.43391276835101 | (37.7784303546549, -122.433912768351) | ||
| 94180 | 94180 | 61525 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.47371658077299 | (37.7861960776153, -122.473716580773) | ||
| 94506 | 94506 | 58807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 40 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23661 | 6007506.51736783 | 2099215.13200372 | 37.744469217231 | -122.416713333977 | (37.744469217231, -122.416713333977) | ||
| 94531 | 94531 | 65486 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 801 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1989 12:00:00 AM | Permit Number 28370 | 6009649.36997858 | 2115707.80146662 | 37.7898745823318 | -122.410468114048 | (37.7898745823318, -122.410468114048) | ||
| 94548 | 94548 | 66852 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 805 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30158 | 6008246.52380896 | 2115214.16051417 | 37.788440420773796 | -122.415286889274 | (37.7884404207738, -122.415286889274) | ||
| 94873 | 94873 | 97190 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
| 94880 | 94880 | 34155 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 95118 | 95118 | 40081 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 22 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41303 | 5996321.69068784 | 2112123.86441597 | 37.7792778762225 | -122.456321143761 | (37.7792778762225, -122.456321143761) | ||||
| 95128 | 95128 | 101426 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 95201 | 95201 | 59876 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504483999 | (37.7976647031079, -122.43551504484) | ||
| 95737 | 95737 | 98531 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
| 95832 | 95832 | 98577 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 301X Francisco St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6x7 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 95847 | 95847 | 60832 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 210 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20605 | 6004728.24272246 | 2102435.29497545 | 37.7531543871846 | -122.42654929494499 | (37.7531543871846, -122.426549294945) | ||
| 95951 | 95951 | 97189 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
| 96095 | 96095 | 31350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.43025162922702 | (37.7758829003399, -122.430251629227) | ||
| 96102 | 96102 | 55379 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.46630065915501 | (37.7651839347095, -122.466300659155) | |||
| 96162 | 96162 | 60279 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 890 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19841 | 6007951.11915857 | 2102749.5563076 | 37.7541989479338 | -122.415426159541 | (37.7541989479338, -122.415426159541) | ||
| 96192 | 96192 | 65478 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1989 12:00:00 AM | Permit Number 28359 | 6010541.36110634 | 2116214.27782437 | 37.7913152098094 | -122.407417612453 | (37.7913152098094, -122.407417612453) | ||
| 96257 | 96257 | 64024 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2356 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24781 | 6001973.19869493 | 2107076.19337817 | 37.7657410355678 | -122.436408897131 | (37.7657410355678, -122.436408897131) | ||
| 96551 | 96551 | 33508 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | |||
| 96682 | 96682 | 66375 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 612 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29499 | 6003620.76837837 | 2110432.17499844 | 37.775049221566206 | -122.430949845165 | (37.7750492215662, -122.430949845165) | ||
| 96990 | 96990 | 99016 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | ||||
| 96992 | 96992 | 62435 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 297 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22596 | 5999684.09914601 | 2105294.09451438 | 37.760717499173396 | -122.44419830300801 | (37.7607174991734, -122.444198303008) | ||
| 97035 | 97035 | 47045 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 111 Maiden Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45035 | 6011125.92683466 | 2115044.13243826 | 37.7881349707775 | -122.40531257909599 | (37.7881349707775, -122.405312579096) | |||
| 97042 | 97042 | 59954 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 559 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | Permit Number 19431 | 6005185.88290556 | 2110921.14903305 | 37.7764803824816 | -122.42557057591002 | (37.7764803824816, -122.42557057591) | ||
| 97049 | 97049 | 66374 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 600 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29498 | 6003626.18476729 | 2110393.01425684 | 37.7749420027203 | -122.430928313262 | (37.7749420027203, -122.430928313262) | ||
| 97387 | 97387 | 98238 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 97456 | 97456 | 61733 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.42728435687401 | (37.7492349189645, -122.427284356874) | ||
| 97471 | 97471 | 61306 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1494 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | Permit Number 21205 | 6011999.58311152 | 2101400.41872379 | 37.7507212274206 | -122.401330679383 | (37.7507212274206, -122.401330679383) | ||
| 97475 | 97475 | 64063 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1421 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1988 12:00:00 AM | Permit Number 25296 | 6010151.38612308 | 2118964.80181049 | 37.7988456450066 | -122.408961074202 | (37.7988456450066, -122.408961074202) | |||
| 97562 | 97562 | 66216 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 438 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29307 | 6008473.34152559 | 2106010.06053059 | 37.763180886532396 | -122.41385080311501 | (37.7631808865324, -122.413850803115) | ||
| 97580 | 97580 | 48043 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
| 97722 | 97722 | 59421 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 59 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25134 | 6004314.38183356 | 2097887.85689933 | 37.7406447683968 | -122.42765654126998 | (37.7406447683968, -122.42765654127) | ||
| 97958 | 97958 | 66869 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 640 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30178 | 6009507.57601331 | 2115392.34348399 | 37.789000460867 | -122.410936420318 | (37.789000460867, -122.410936420318) | ||
| 98302 | 98302 | 63872 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24575 | 6003557.23375757 | 2103346.48170692 | 37.7555900208672 | -122.43066389151699 | (37.7555900208672, -122.430663891517) | ||
| 98642 | 98642 | 64717 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 35 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25671 | 6010371.58706878 | 2113906.86566108 | 37.7849701038252 | -122.407842251054 | (37.7849701038252, -122.407842251054) | ||
| 98701 | 98701 | 99964 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769385 | 6003671.0 | 2116729.0 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | ||||
| 99208 | 99208 | 56883 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 229 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 14121 | 6003628.47766901 | 2109141.87347388 | 37.7715068072846 | -122.430831075204 | (37.7715068072846, -122.430831075204) | ||
| 99439 | 99439 | 39878 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 301 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | |||
| 100167 | 100167 | 61712 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 239 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21712 | 6005177.32533199 | 2108193.82077345 | 37.768991315779 | -122.42540604522301 | (37.768991315779, -122.425406045223) | ||
| 100334 | 100334 | 36098 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 299 on 16th Street Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/1998 12:00:00 AM | Permit Number 39198 | 6004891.74541508 | 2106619.46330166 | 37.7646523685012 | -122.426281744676 | (37.7646523685012, -122.426281744676) | |||
| 100679 | 100679 | 64576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3524 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1988 12:00:00 AM | Permit Number 25474 | 6006109.43020381 | 2104951.42696267 | 37.760141086622 | -122.421951589354 | (37.760141086622, -122.421951589354) | ||
| 100744 | 100744 | 62669 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 299 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1992 12:00:00 AM | Permit Number 23001 | 6003308.50596463 | 2109097.30161721 | 37.7713662897526 | -122.43193469053101 | (37.7713662897526, -122.431934690531) | ||
| 100915 | 100915 | 103153 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
| 101030 | 101030 | 61727 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 106 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21732 | 6004453.38447501 | 2101057.16682643 | 37.7493548261549 | -122.42740164255501 | (37.7493548261549, -122.427401642555) | ||
| 101209 | 101209 | 61524 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 5301 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.784297623281105 | -122.474274166868 | (37.7842976232811, -122.474274166868) | ||
| 101414 | 101414 | 66836 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | ||
| 101844 | 101844 | 56884 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 219 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 14122 | 6003674.18790761 | 2109148.24088129 | 37.771526880372 | -122.430673415548 | (37.771526880372, -122.430673415548) | ||
| 102057 | 102057 | 104050 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 145X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012363.0 | 2119165.0 | 37.7995189786281 | -122.40132219698201 | (37.7995189786281, -122.401322196982) | |||||
| 102110 | 102110 | 30891 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
| 102130 | 102130 | 64725 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.785406080036296 | -122.409096504402 | (37.7854060800363, -122.409096504402) | ||
| 102308 | 102308 | 54295 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3761 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20600 | 6004679.68604313 | 2102479.51319776 | 37.7532730549459 | -122.426720362353 | (37.7532730549459, -122.426720362353) | ||
| 102524 | 102524 | 34150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 102612 | 102612 | 61431 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 682 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1985 12:00:00 AM | Permit Number 22021 | 6002437.42157042 | 2108855.24055446 | 37.7706522292485 | -122.434930494274 | (37.7706522292485, -122.434930494274) | ||
| 102917 | 102917 | 60837 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20610 | 6004792.83349827 | 2102193.60003035 | 37.7524944004681 | -122.426308720309 | (37.7524944004681, -122.426308720309) | ||
| 103274 | 103274 | 67815 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31469 | 6003802.17585758 | 2102641.49083741 | 37.7536681560563 | -122.42976652391701 | (37.7536681560563, -122.429766523917) | ||
| 103405 | 103405 | 34156 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 103549 | 103549 | 60834 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 233 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20607 | 6004786.50329151 | 2102315.79263057 | 37.752829555056 | -122.426339310434 | (37.752829555056, -122.426339310434) | ||
| 103603 | 103603 | 48038 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2005 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | ||
| 103906 | 103906 | 48039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
| 104397 | 104397 | 65917 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | ||
| 104415 | 104415 | 101428 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 104444 | 104444 | 34154 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 104494 | 104494 | 66311 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.43779972754601 | (37.7336304648573, -122.437799727546) | ||
| 104502 | 104502 | 33585 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.740543028887295 | -122.418608458082 | (37.7405430288873, -122.418608458082) | |||
| 104854 | 104854 | 92018 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4182 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001163.0 | 2105841.0 | 37.7623034284238 | -122.439122658321 | (37.7623034284238, -122.439122658321) | ||||
| 104912 | 104912 | 116391 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
| 105138 | 105138 | 61754 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3208 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21766 | 6005459.89972761 | 2106676.78980679 | 37.764841871773896 | -122.424320725398 | (37.7648418717739, -122.424320725398) |
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");