Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1485 | 1485 | 115988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.40325542520901 | (37.7963995082912, -122.403255425209) | |
| 3030 | 3030 | 224462 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.40714655877301 | (37.7497653433983, -122.407146558773) | |
| 3035 | 3035 | 240686 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.749767577309605 | -122.40709853768499 | (37.7497675773096, -122.407098537685) | |
| 5667 | 5667 | 102263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2037 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001878.76288 | 2115606.3786400002 | 37.78915741351871 | -122.437346392945 | (37.7891574135187, -122.437346392945) | |||
| 5858 | 5858 | 18862 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3PL | 6004143.20725 | 2116038.00121 | 37.790471010977505 | -122.42954249260201 | (37.7904710109775, -122.429542492602) | |||
| 5887 | 5887 | 94203 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | |
| 6585 | 6585 | 44092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.790485736467296 | -122.429415161181 | (37.7904857364673, -122.429415161181) | |
| 7288 | 7288 | 111098 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 754 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.78760928190211 | -122.414263235869 | (37.7876092819021, -122.414263235869) | ||
| 8677 | 8677 | 18861 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6004226.06461 | 2116051.48796 | 37.790512733214 | -122.42925677349 | (37.790512733214, -122.42925677349) | |||
| 9120 | 9120 | 4533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 03:02:00 PM | 6 | 5x5 | 6005057.0165 | 2113679.5647 | 37.7840470307287 | -122.42621279071001 | (37.7840470307287, -122.42621279071) | ||
| 9146 | 9146 | 4532 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005027.0371 | 2113673.2533 | 37.784028006637996 | -122.42631605911998 | (37.784028006638, -122.42631605912) | |||
| 9151 | 9151 | 4530 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | |||
| 9193 | 9193 | 4549 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004652.295 | 2113623.5507 | 37.7838703460943 | -122.427608988739 | (37.7838703460943, -122.427608988739) | |||
| 9249 | 9249 | 4552 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.42727974188101 | (37.7839147367985, -122.427279741881) | |||
| 9257 | 9257 | 4531 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | |||
| 9465 | 9465 | 4553 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004771.4236 | 2113636.9625 | 37.7839139091534 | -122.427197803426 | (37.7839139091534, -122.427197803426) | |||
| 10378 | 10378 | 98180 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768099 | 6007169.16242 | 2091641.99398 | 37.7236560602499 | -122.417343266399 | (37.7236560602499, -122.417343266399) | |
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 16738 | 16738 | 28934 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 260 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009412.25627 | 2110486.9627400003 | 37.775526107775704 | -122.41091961406299 | (37.7755261077757, -122.410919614063) | ||
| 16799 | 16799 | 57069 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | |
| 20605 | 20605 | 23 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 729 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2011 12:00:00 AM | 3 | 4x4 | 6003875.846919999 | 2107718.3128400003 | 37.7676120683604 | -122.429873853201 | (37.7676120683604, -122.429873853201) | ||
| 22918 | 22918 | 191269 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | ||||
| 23366 | 23366 | 227653 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.43128265198901 | (37.7563447763019, -122.431282651989) | |||
| 23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
| 23772 | 23772 | 191299 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015177.82762 | 2107330.32237 | 37.767180280481895 | -122.390754301979 | (37.7671802804819, -122.390754301979) | |||
| 23969 | 23969 | 176943 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 19 Lois Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012322.95001 | 2087866.52725 | 37.713578008300296 | -122.39926249466801 | (37.7135780083003, -122.399262494668) | |||
| 24380 | 24380 | 129424 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6003346.86179 | 2117886.37825 | 37.7955010594853 | -122.43242986946699 | (37.7955010594853, -122.432429869467) | |||
| 24787 | 24787 | 56080 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 723 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2011 12:00:00 AM | 2 | 3x3 | Permit Number 51743 | 5981333.03596 | 2110794.79787 | 37.774756814986794 | -122.50807353876199 | (37.7747568149868, -122.508073538762) | |
| 25932 | 25932 | 207066 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993124.54928 | 2098622.04482 | 37.7420213577054 | -122.46639972369101 | (37.7420213577054, -122.466399723691) | |||
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 26269 | 26269 | 207097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 451 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996075.95126 | 2096408.69413 | 37.7361138982453 | -122.45603479789301 | (37.7361138982453, -122.456034797893) | |||
| 26316 | 26316 | 176960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 242 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012452.5611 | 2087695.0016599998 | 37.7131142557927 | -122.39880247885701 | (37.7131142557927, -122.398802478857) | |||
| 26349 | 26349 | 129413 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2111 Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003291.44456 | 2115944.18125 | 37.79016514166771 | -122.43248283141399 | (37.7901651416677, -122.432482831414) | |||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 27568 | 27568 | 191287 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014360.2734 | 2110545.30097 | 37.7759625028975 | -122.393807184665 | (37.7759625028975, -122.393807184665) | |||
| 27723 | 27723 | 129402 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3000 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999090.32735 | 2119096.86414 | 37.7985824452762 | -122.44724531075 | (37.7985824452762, -122.44724531075) | |||
| 27806 | 27806 | 129444 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1338 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008418.059880001 | 2116953.62618 | 37.793226207275794 | -122.414816555443 | (37.7932262072758, -122.414816555443) | |||
| 28130 | 28130 | 191253 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.39071873558599 | (37.7617882296504, -122.390718735586) | |||
| 28179 | 28179 | 227598 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005393.4683 | 2107800.6400599997 | 37.7679239451627 | -122.424630446843 | (37.7679239451627, -122.424630446843) | |||
| 28468 | 28468 | 129406 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3545 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000708.230719999 | 2120533.5731200003 | 37.8026195792908 | -122.44175003663099 | (37.8026195792908, -122.441750036631) | |||
| 28660 | 28660 | 142575 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2251 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.803978459247205 | -122.41333149055401 | (37.8039784592472, -122.413331490554) | |||
| 28685 | 28685 | 99380 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 28729 | 28729 | 191333 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014865.84277 | 2110042.3598599997 | 37.7746096212801 | -122.392023095184 | (37.7746096212801, -122.392023095184) | |||
| 28952 | 28952 | 176968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004019.9865 | 2094083.3714700001 | 37.7301818557853 | -122.428403350153 | (37.7301818557853, -122.428403350153) | |||
| 29311 | 29311 | 199962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018011.0370000005 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | |||
| 29379 | 29379 | 105035 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015087.4436800005 | 2107939.01173 | 37.768846592924 | -122.391109479333 | (37.768846592924, -122.391109479333) | |||
| 29524 | 29524 | 108754 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012760.63999 | 2087707.7823400002 | 37.7131665099896 | -122.397738543111 | (37.7131665099896, -122.397738543111) | |||
| 29861 | 29861 | 227623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001957.40527 | 2101134.69618 | 37.7494262207603 | -122.43603832812599 | (37.7494262207603, -122.436038328126) | |||
| 30187 | 30187 | 97675 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000810.80569 | 2117928.4487099997 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | ||||
| 30701 | 30701 | 71808 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5989823.9383 | 2098417.3202 | 37.741268233056395 | -122.477797097779 | (37.7412682330564, -122.477797097779) | ||
| 31053 | 31053 | 191303 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015172.36775 | 2107445.68773 | 37.7674967456035 | -122.39078125017099 | (37.7674967456035, -122.390781250171) | |||
| 31094 | 31094 | 87873 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | |
| 31281 | 31281 | 227616 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 246 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999006.659659999 | 2106731.5709599997 | 37.764625778676 | -122.44664468051 | (37.764625778676, -122.44664468051) | |||
| 31453 | 31453 | 207072 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 245 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994440.698340001 | 2100406.16627 | 37.7469959638947 | -122.46197828057899 | (37.7469959638947, -122.461978280579) | |||
| 33222 | 33222 | 207070 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.752311011160295 | -122.464510933358 | (37.7523110111603, -122.464510933358) | |||
| 33248 | 33248 | 94086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53469 | 5987161.9603 | 2103493.9012 | 37.7550523122054 | -122.48737396285101 | (37.7550523122054, -122.487373962851) | |
| 33465 | 33465 | 191315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015139.91127 | 2108041.11608 | 37.7691298604716 | -122.390935133173 | (37.7691298604716, -122.390935133173) | |||
| 33924 | 33924 | 38574 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | |
| 34205 | 34205 | 207067 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 319 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992889.43355 | 2094705.1306900003 | 37.731252923187796 | -122.466927982745 | (37.7312529231878, -122.466927982745) | |||
| 34421 | 34421 | 191258 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011671.67609 | 2106498.8214 | 37.7647020133105 | -122.402823145387 | (37.7647020133105, -122.402823145387) | |||
| 34489 | 34489 | 183440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098754.1113 | 37.7421770482141 | -122.47877029228998 | (37.7421770482141, -122.47877029229) | |||
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 34951 | 34951 | 191312 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015149.38015 | 2107824.64473 | 37.768536003056504 | -122.390887249657 | (37.7685360030565, -122.390887249657) | |||
| 35185 | 35185 | 129454 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713002 | (37.8031318169374, -122.41748848713) | |||
| 35192 | 35192 | 191336 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015056.82202 | 2108488.85287 | 37.7703546363753 | -122.391253838509 | (37.7703546363753, -122.391253838509) | |||
| 35287 | 35287 | 35365 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | |
| 35610 | 35610 | 176951 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 63 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012562.34064 | 2087723.35892 | 37.7131982353775 | -122.398425029786 | (37.7131982353775, -122.398425029786) | |||
| 36009 | 36009 | 186909 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.49368611859501 | (37.7362904860675, -122.493686118595) | |||
| 36363 | 36363 | 207082 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992234.50744 | 2102126.7079 | 37.7515928656239 | -122.46973226583799 | (37.7515928656239, -122.469732265838) | |||
| 36838 | 36838 | 191250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | |||
| 37043 | 37043 | 191271 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014227.23158 | 2110805.88928 | 37.776670625478395 | -122.394285663563 | (37.7766706254784, -122.394285663563) | |||
| 37113 | 37113 | 176939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012245.82216 | 2087941.3179099998 | 37.7137790697309 | -122.399534325569 | (37.7137790697309, -122.399534325569) | |||
| 37197 | 37197 | 191320 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015132.04881 | 2108165.57051 | 37.769471148715894 | -122.39097102870701 | (37.7694711487159, -122.390971028707) | |||
| 37307 | 37307 | 191325 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015118.6002 | 2108416.5397200002 | 37.7701595086914 | -122.391035090994 | (37.7701595086914, -122.391035090994) | |||
| 37316 | 37316 | 35009 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | ||
| 37340 | 37340 | 227600 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 308 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6006510.89149 | 2104242.1298 | 37.7582161548565 | -122.420512774045 | (37.7582161548565, -122.420512774045) | |||
| 37486 | 37486 | 227656 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 148 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001371.492269999 | 2107387.94373 | 37.7665628167523 | -122.43851240444799 | (37.7665628167523, -122.438512404448) | |||
| 37575 | 37575 | 176976 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002487.993290001 | 2086859.8664400002 | 37.710260908397395 | -122.433183714473 | (37.7102609083974, -122.433183714473) | |||
| 38136 | 38136 | 46819 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 366 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 10 | Permit Number 44897 | 6004049.020819999 | 2091179.47735 | 37.7222100502291 | -122.428096112963 | (37.7222100502291, -122.428096112963) | |
| 38656 | 38656 | 176952 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.713231664082706 | -122.39812684519698 | (37.7132316640827, -122.398126845197) | |||
| 38876 | 38876 | 142250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | |||
| 38881 | 38881 | 129421 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447998999 | (37.795493917972, -122.43256447999) | |||
| 39185 | 39185 | 191296 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014597.305819999 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 40498 | 40498 | 129411 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2111 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003275.408009999 | 2116033.9816799997 | 37.790410801365105 | -122.43254473354901 | (37.7904108013651, -122.432544733549) | |||
| 41237 | 41237 | 207083 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992235.15443 | 2102157.44312 | 37.7516772939722 | -122.469732265856 | (37.7516772939722, -122.469732265856) | |||
| 41440 | 41440 | 191311 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.76846592338129 | -122.39087719613501 | (37.7684659233813, -122.390877196135) | |||
| 41678 | 41678 | 227637 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6006174.20556 | 2101172.48753 | 37.7497686457084 | -122.421459183712 | (37.7497686457084, -122.421459183712) | |||
| 41714 | 41714 | 115987 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011766.1004 | 2118039.4815599998 | 37.7963952562896 | -122.40330847443 | (37.7963952562896, -122.40330847443) | |||
| 42249 | 42249 | 105036 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x6 | Permit Number 771181 | 6015089.32821 | 2107914.09587 | 37.7687782840212 | -122.39110121906201 | (37.7687782840212, -122.391101219062) | ||
| 42271 | 42271 | 207076 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | |||
| 42869 | 42869 | 129448 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008230.449580001 | 2115909.44994 | 37.79034861235171 | -122.415391745646 | (37.7903486123517, -122.415391745646) | |||
| 43089 | 43089 | 46211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.43261542476299 | (37.7915512424562, -122.432615424763) | ||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 43673 | 43673 | 247493 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 806 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | |||
| 43823 | 43823 | 191356 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.39098263356199 | (37.7674880383618, -122.390982633562) | |||
| 43921 | 43921 | 227634 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3238 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008149.92124 | 2100968.79152 | 37.7493205414166 | -122.414612642259 | (37.7493205414166, -122.414612642259) | |||
| 44145 | 44145 | 191295 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014582.55786 | 2110345.63689 | 37.7754266202868 | -122.393024265473 | (37.7754266202868, -122.393024265473) | |||
| 44149 | 44149 | 30586 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481001 | (37.7726573855875, -122.43410610481) | |
| 44196 | 44196 | 129400 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5996779.47393 | 2115339.45033 | 37.7881332907605 | -122.454969901653 | (37.7881332907605, -122.454969901653) |
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");