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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 44547 | 44547 | 191291 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.39328832798701 | (37.7755965678638, -122.393288327987) | |||
| 44629 | 44629 | 129403 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | |||
| 44632 | 44632 | 176950 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012544.33708 | 2087727.46225 | 37.7132084993531 | -122.398487544387 | (37.7132084993531, -122.398487544387) | |||
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 45223 | 45223 | 129442 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010104.97756 | 2114284.6760299997 | 37.785992551769795 | -122.408791302782 | (37.7859925517698, -122.408791302782) | |||
| 45275 | 45275 | 227654 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004930.05045 | 2104005.07306 | 37.7574760371124 | -122.42596313868201 | (37.7574760371124, -122.425963138682) | |||
| 45357 | 45357 | 120682 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2917 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989597.69972 | 2111917.78775 | 37.7783237566214 | -122.479566877639 | (37.7783237566214, -122.479566877639) | |||
| 45384 | 45384 | 119342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.78070095968079 | -122.492222971302 | (37.7807009596808, -122.492222971302) | |||
| 45505 | 45505 | 176953 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012671.13481 | 2087736.7840599997 | 37.713241158228705 | -122.39804993876999 | (37.7132411582287, -122.39804993877) | |||
| 45787 | 45787 | 207074 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994502.2451599995 | 2100385.66213 | 37.7469432078786 | -122.46176397213301 | (37.7469432078786, -122.461763972133) | |||
| 46075 | 46075 | 191248 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010994.55519 | 2105384.5641 | 37.7616046825239 | -122.405086676019 | (37.7616046825239, -122.405086676019) | |||
| 46195 | 46195 | 207077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | |||
| 46359 | 46359 | 129457 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | |||
| 46474 | 46474 | 129453 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007720.64474 | 2120576.4205400003 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | |||
| 46688 | 46688 | 207094 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994559.61163 | 2093655.1393099998 | 37.728466159762505 | -122.46107783977101 | (37.7284661597625, -122.461077839771) | |||
| 46965 | 46965 | 176936 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012351.49393 | 2087873.7751200001 | 37.713599500286 | -122.399164344459 | (37.713599500286, -122.399164344459) | |||
| 47633 | 47633 | 129418 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003255.2303 | 2117874.11084 | 37.795462179980895 | -122.432746053085 | (37.7954621799809, -122.432746053085) | |||
| 47675 | 47675 | 176920 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 671 London St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6001061.12784 | 2089906.70665 | 37.718545806627205 | -122.43833338090299 | (37.7185458066272, -122.438333380903) | ||||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 47927 | 47927 | 227620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005907.97007 | 2102264.4901400004 | 37.752752018913796 | -122.422457421298 | (37.7527520189138, -122.422457421298) | |||
| 49285 | 49285 | 129456 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.41748965894199 | (37.803134284681, -122.417489658942) | |||
| 49437 | 49437 | 227622 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221001 | (37.748648223551, -122.43700910221) | |||
| 49816 | 49816 | 207050 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | |||
| 51023 | 51023 | 185052 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | |||
| 51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
| 51341 | 51341 | 117943 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983766.08421 | 2109717.4045599997 | 37.7719416683068 | -122.499577617773 | (37.7719416683068, -122.499577617773) | |||
| 51582 | 51582 | 191305 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015162.58842 | 2107628.3532 | 37.767997762404 | -122.390827843133 | (37.767997762404, -122.390827843133) | |||
| 51890 | 51890 | 207058 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2480 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992066.66369 | 2098534.27865 | 37.7417192754352 | -122.470051132153 | (37.7417192754352, -122.470051132153) | |||
| 52001 | 52001 | 200104 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.39045295200899 | (37.726258938018, -122.390452952009) | |||
| 52098 | 52098 | 207062 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.46675176060499 | (37.7435731145127, -122.466751760605) | |||
| 52561 | 52561 | 114222 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 2x2 | 6012512.59554 | 2087744.0784200002 | 37.713252355697605 | -122.398598420002 | (37.7132523556976, -122.398598420002) |
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");