Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32230 | 32230 | 126541 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1301 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007346.83481 | 2121683.4961099997 | 37.80615299312171 | -122.41885867979299 | (37.8061529931217, -122.418858679793) | |||
| 43055 | 43055 | 126514 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 54 Casa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001509.62012 | 2121629.4389400003 | 37.8056741643903 | -122.439055417799 | (37.8056741643903, -122.439055417799) | |||
| 154465 | 154465 | 42845 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 704 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 1 | Permit Number 42776 | 6007326.6292 | 2121624.2795 | 37.8059892616711 | -122.41892440226101 | (37.8059892616711, -122.418924402261) | |
| 179524 | 179524 | 126517 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3835 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000579.5194 | 2121468.07283 | 37.8051781307269 | -122.44226256568001 | (37.8051781307269, -122.44226256568) | |||
| 49277 | 49277 | 68253 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3825 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32055 | 6000581.64191 | 2121452.9297599997 | 37.805136672889205 | -122.44225413274799 | (37.8051366728892, -122.442254132748) | |
| 153041 | 153041 | 126524 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1550 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002732.935959999 | 2121317.83643 | 37.8048881155466 | -122.434799663981 | (37.8048881155466, -122.434799663981) | |||
| 1527 | 1527 | 103937 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | ||
| 59943 | 59943 | 126513 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1775 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001669.3138 | 2121059.84725 | 37.804119302216705 | -122.438461940777 | (37.8041193022167, -122.438461940777) | |||
| 30583 | 30583 | 68237 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1775 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32032 | 6001656.99546 | 2121058.17098 | 37.8041139989306 | -122.438504449024 | (37.8041139989306, -122.438504449024) | |
| 56938 | 56938 | 33335 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) |
| 35578 | 35578 | 33334 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788581999 | (37.8033246198945, -122.42991788582) |
| 57693 | 57693 | 61998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3337 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 10 | Permit Number 22065 | 6004092.37742 | 2120634.4827 | 37.8030888913932 | -122.430046392648 | (37.8030888913932, -122.430046392648) | |
| 175775 | 175775 | 40609 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1262 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 10 | Permit Number 41619 | 6005248.55961 | 2120627.0899799997 | 37.8031340049926 | -122.42604486639799 | (37.8031340049926, -122.426044866398) | ||
| 62630 | 62630 | 61995 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3324 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52348 | 6004148.34958 | 2120589.64511 | 37.802968948823704 | -122.429849499548 | (37.8029689488237, -122.429849499548) | |
| 69402 | 69402 | 126525 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3321 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6004100.5255 | 2120576.79123 | 37.802930947069704 | -122.43001407818701 | (37.8029309470697, -122.430014078187) | |||
| 57646 | 57646 | 65832 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2205 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 1 | Permit Number 28822 | 6000136.86621 | 2120563.93301 | 37.802670367617104 | -122.443729421089 | (37.8026703676171, -122.443729421089) | |
| 86572 | 86572 | 61992 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3315 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | Permit Number 22059 | 6004110.15533963 | 2120501.76517011 | 37.8027254903671 | -122.429975398963 | (37.8027254903671, -122.429975398963) | ||
| 130662 | 130662 | 61989 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3245 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 9 | Permit Number 22056 | 6004135.50024 | 2120335.1617400004 | 37.802269475902 | -122.42987580203699 | (37.802269475902, -122.429875802037) | |
| 30322 | 30322 | 126523 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1436 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004946.35763 | 2120239.41034 | 37.8020524524204 | -122.427063015844 | (37.8020524524204, -122.427063015844) | |||
| 137341 | 137341 | 61986 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3219 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 13 | Permit Number 22053 | 6004150.64271 | 2120237.5343299997 | 37.8020022738516 | -122.42981643418699 | (37.8020022738516, -122.429816434187) | |
| 6712 | 6712 | 55965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.142580001 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | |
| 149899 | 149899 | 61985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3212 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 11 | Permit Number 22052 | 6004200.44828 | 2120220.07156 | 37.8019571458696 | -122.429642837148 | (37.8019571458696, -122.429642837148) | |
| 66251 | 66251 | 126508 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2241 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000053.49785 | 2120204.95376 | 37.801679951426 | -122.443992108573 | (37.801679951426, -122.443992108573) | |||
| 131434 | 131434 | 126509 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2259 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999989.15096 | 2120195.3405400002 | 37.801649885296 | -122.44421408640699 | (37.801649885296, -122.444214086407) | |||
| 38763 | 38763 | 68965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2271 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52893 | 5999938.800530001 | 2120187.4575099996 | 37.8016253679701 | -122.444387754501 | (37.8016253679701, -122.444387754501) | |
| 170438 | 170438 | 126505 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3434 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000801.450619999 | 2120178.5293 | 37.8016500345732 | -122.44140195853201 | (37.8016500345732, -122.441401958532) | |||
| 165576 | 165576 | 66089 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.971469999 | 2120081.10266 | 37.8017685454413 | -122.41780324801701 | (37.8017685454413, -122.417803248017) | |
| 74779 | 74779 | 126518 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6001004.1141099995 | 2120049.67751 | 37.8013077849919 | -122.440691404186 | (37.8013077849919, -122.440691404186) | |||
| 150681 | 150681 | 126519 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000986.5183 | 2120044.44522 | 37.8012924164688 | -122.440751917771 | (37.8012924164688, -122.440751917771) | |||
| 76609 | 76609 | 126520 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000968.94208 | 2120040.14536 | 37.8012796092356 | -122.440812430464 | (37.8012796092356, -122.440812430464) | |||
| 173425 | 173425 | 126521 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6000953.24503 | 2120036.11736 | 37.8012676554495 | -122.44086645991301 | (37.8012676554495, -122.440866459913) | |||
| 59806 | 59806 | 112676 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.40789309729799 | (37.8017163995107, -122.407893097298) | |||
| 138041 | 138041 | 126510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 251 Alhambra St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000996.0409699995 | 2120002.9764400003 | 37.8011790965073 | -122.440715988969 | (37.8011790965073, -122.440715988969) | |||
| 151584 | 151584 | 126511 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 251 Alhambra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000979.360280001 | 2119998.9635799997 | 37.8011671283179 | -122.44077342326 | (37.8011671283179, -122.44077342326) | |||
| 137827 | 137827 | 126512 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 251 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000962.49695 | 2119994.9542 | 37.8011551592542 | -122.440831489795 | (37.8011551592542, -122.440831489795) | |||
| 40465 | 40465 | 84616 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50830 | 6001046.02752 | 2119987.7015 | 37.8011400020673 | -122.440541917971 | (37.8011400020673, -122.440541917971) | |
| 51697 | 51697 | 87865 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50830 | 6001049.0728400005 | 2119968.8143 | 37.801088316234704 | -122.440530024452 | (37.8010883162347, -122.440530024452) | |
| 145990 | 145990 | 61982 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3150 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1989 12:00:00 AM | Permit Number 22049 | 6004241.15992791 | 2119938.65131172 | 37.8011867438319 | -122.429481874601 | (37.8011867438319, -122.429481874601) | ||
| 66125 | 66125 | 126507 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000262.11092 | 2119933.43499 | 37.8009463312723 | -122.443250701178 | (37.8009463312723, -122.443250701178) | |||
| 45309 | 45309 | 126506 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000233.97348 | 2119929.48889 | 37.8009338918396 | -122.44334778477 | (37.8009338918396, -122.44334778477) | |||
| 143406 | 143406 | 83360 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2322 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50843 | 6000204.02563621 | 2119927.77926672 | 37.8009274898516 | -122.443451293811 | (37.8009274898516, -122.443451293811) | ||
| 74615 | 74615 | 78962 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2324 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000164.38759 | 2119919.6080400003 | 37.8009027932886 | -122.443587870495 | (37.8009027932886, -122.443587870495) | |||
| 60983 | 60983 | 84618 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2334 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000130.7318 | 2119914.64406 | 37.8008872440121 | -122.44370397656601 | (37.8008872440121, -122.443703976566) | |
| 171223 | 171223 | 87872 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2334 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000114.75256 | 2119911.95547 | 37.80087895046729 | -122.44375907803699 | (37.8008789504673, -122.443759078037) | |
| 78728 | 78728 | 87868 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059.0 | 2119911.0 | 37.800930138770106 | -122.440491523393 | (37.8009301387701, -122.440491523393) | ||
| 95886 | 95886 | 87866 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059.0 | 2119911.0 | 37.800930138770106 | -122.440491523393 | (37.8009301387701, -122.440491523393) | ||
| 142965 | 142965 | 87867 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059.0 | 2119911.0 | 37.800930138770106 | -122.440491523393 | (37.8009301387701, -122.440491523393) | ||
| 71263 | 71263 | 72055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1990 12:00:00 AM | 11 | 6008082.6141 | 2119894.2799400003 | 37.8012816578905 | -122.41618558619301 | (37.8012816578905, -122.416185586193) | ||
| 186882 | 186882 | 61980 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.42960375979999 | (37.8009411736685, -122.4296037598) | |
| 162390 | 162390 | 126526 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3101 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004207.10509 | 2119826.7769 | 37.8008776374509 | -122.429591735885 | (37.8008776374509, -122.429591735885) | |||
| 53129 | 53129 | 126549 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2113 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008108.43544 | 2119716.18601 | 37.8007941084157 | -122.416083612992 | (37.8007941084157, -122.416083612992) | |||
| 72728 | 72728 | 126522 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3318 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002338.78522 | 2119619.0030099996 | 37.800201180891 | -122.436042024317 | (37.800201180891, -122.436042024317) | |||
| 129944 | 129944 | 66093 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.41689421958799 | (37.8004974059005, -122.416894219588) | |
| 127425 | 127425 | 87390 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3318 Fillmore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.43601829666099 | (37.8000499325498, -122.436018296661) | |||
| 29474 | 29474 | 121021 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.800075448478204 | -122.42658871161001 | (37.8000754484782, -122.42658871161) | |||
| 53704 | 53704 | 64964 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.106240001 | 2119511.2308099996 | 37.8000586419391 | -122.42666941405899 | (37.8000586419391, -122.426669414059) | |
| 39194 | 39194 | 126540 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1926 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6008669.99624 | 2119504.05364 | 37.800243203509005 | -122.414125355424 | (37.800243203509, -122.414125355424) | |||
| 187788 | 187788 | 126543 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008144.06268 | 2119447.51141 | 37.8000583982326 | -122.415941290758 | (37.8000583982326, -122.415941290758) | |||
| 75709 | 75709 | 126544 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008150.08042 | 2119430.1089 | 37.800010953609 | -122.415919233995 | (37.800010953609, -122.415919233995) | |||
| 187770 | 187770 | 33945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.7642900003 | 37.799801537482296 | -122.42753193854601 | (37.7998015374823, -122.427531938546) | |
| 164841 | 164841 | 71618 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 950 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 10 | 6012375.885290001 | 2119419.34267 | 37.8002180611838 | -122.401295492211 | (37.8002180611838, -122.401295492211) | ||
| 48078 | 48078 | 126537 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 846 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008941.49289 | 2119413.64812 | 37.8000102179579 | -122.413179470958 | (37.8000102179579, -122.413179470958) | |||
| 53224 | 53224 | 126538 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 846 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | |||
| 39940 | 39940 | 126545 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008151.874919999 | 2119410.8388 | 37.799958143615704 | -122.41591165898899 | (37.7999581436157, -122.415911658989) | |||
| 50517 | 50517 | 126539 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 846 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008917.81168 | 2119409.9991900004 | 37.799998869415 | -122.413261159078 | (37.799998869415, -122.413261159078) | |||
| 70733 | 70733 | 71444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | ||
| 177336 | 177336 | 126546 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008154.11673 | 2119394.0589400004 | 37.7999121963461 | -122.415902712567 | (37.7999121963461, -122.415902712567) | |||
| 180698 | 180698 | 126554 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | |||
| 153146 | 153146 | 126547 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.799862715653894 | -122.41589197732999 | (37.7998627156539, -122.41589197733) | |||
| 161908 | 161908 | 126548 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008157.98833 | 2119355.87849 | 37.7998075800257 | -122.415886610195 | (37.7998075800257, -122.415886610195) | |||
| 151638 | 151638 | 126555 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | |||
| 187496 | 187496 | 73575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | ||
| 133212 | 133212 | 126556 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499875996 | -122.402609980888 | (37.799883499876, -122.402609980888) | |||
| 51112 | 51112 | 126557 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | |||
| 52331 | 52331 | 126558 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | |||
| 61380 | 61380 | 126499 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1636 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005076.86043 | 2119214.79365 | 37.7992464965988 | -122.426538412535 | (37.7992464965988, -122.426538412535) | |||
| 155894 | 155894 | 126559 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.799622020198605 | -122.402563960758 | (37.7996220201986, -122.402563960758) | |||
| 31343 | 31343 | 55507 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 20 | Permit Number 23375 | 6004977.3709 | 2119202.3279 | 37.7992066440205 | -122.426881792584 | (37.7992066440205, -122.426881792584) | |
| 184298 | 184298 | 64968 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1674 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 1 | Permit Number 26003 | 6004952.75334 | 2119199.4547099997 | 37.799197363023794 | -122.426966773099 | (37.7991973630238, -122.426966773099) | |
| 166319 | 166319 | 64966 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1690 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 9 | Permit Number 26001 | 6004915.29698 | 2119193.66495 | 37.799179347809996 | -122.42709597241199 | (37.79917934781, -122.427095972412) | |
| 55656 | 55656 | 126560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | |||
| 74122 | 74122 | 55804 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.79914877534139 | -122.42632699542 | (37.7991487753414, -122.42632699542) | ||
| 99343 | 99343 | 64972 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1627 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1989 12:00:00 AM | Permit Number 26007 | 6005156.95767536 | 2119176.82289308 | 37.799146766320895 | -122.426258543392 | (37.7991467663209, -122.426258543392) | ||
| 167155 | 167155 | 126498 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1645 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005080.33881 | 2119170.38355 | 37.799124754463705 | -122.42652321217501 | (37.7991247544637, -122.426523212175) | |||
| 159215 | 159215 | 64971 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1645 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1989 12:00:00 AM | 10 | Permit Number 26006 | 6005064.1075 | 2119167.5364099997 | 37.7991160193549 | -122.42657917520901 | (37.7991160193549, -122.426579175209) | |
| 45044 | 45044 | 126497 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | |||
| 149468 | 149468 | 64970 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1651 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 11 | Permit Number 26005 | 6005030.07255 | 2119163.06773 | 37.7991018253479 | -122.426696629358 | (37.7991018253479, -122.426696629358) | |
| 76366 | 76366 | 126496 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1695 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004921.92717 | 2119147.2014599997 | 37.7990521458892 | -122.42706971848999 | (37.7990521458892, -122.42706971849) | |||
| 152451 | 152451 | 64965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1695 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 9 | Permit Number 26000 | 6004890.47461 | 2119142.0833400004 | 37.7990363142334 | -122.42717819021999 | (37.7990363142334, -122.42717819022) | |
| 146993 | 146993 | 126553 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.40217926767099 | (37.7993378371204, -122.402179267671) | |||
| 66822 | 66822 | 126552 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 247 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012094.9021 | 2119101.47961 | 37.7993296056227 | -122.40224544877701 | (37.7993296056227, -122.402245448777) | |||
| 60664 | 60664 | 126491 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3041 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002852.033969999 | 2119100.62162 | 37.7988069853068 | -122.434228905666 | (37.7988069853068, -122.434228905666) | |||
| 112669 | 112669 | 88403 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071.0 | 2119078.0 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | ||
| 30932 | 30932 | 74829 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | ||
| 148494 | 148494 | 126542 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 789 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009244.5501 | 2119059.64752 | 37.7990552287775 | -122.412105741595 | (37.7990552287775, -122.412105741595) | |||
| 30000 | 30000 | 72470 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1996 12:00:00 AM | 7 | 6012030.25538 | 2119045.5342200003 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | ||
| 3489 | 3489 | 74967 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 8 | 3x3 | 6012084.12824 | 2119041.9172900002 | 37.799165460472295 | -122.40227854024401 | (37.7991654604723, -122.402278540244) | |
| 96635 | 96635 | 87186 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3041 Webster St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864.0 | 2119027.0 | 37.798605518649296 | -122.43418223343599 | (37.7986055186493, -122.434182233436) | |||
| 58907 | 58907 | 74852 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | ||
| 71745 | 71745 | 74989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.41216221273199 | (37.798876023557, -122.412162212732) |
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");