Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69957 | 69957 | 98409 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 55 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||||
| 249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
| 30299 | 30299 | 206560 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | |||
| 30345 | 30345 | 206561 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5995302.34368 | 2095238.1668900002 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | |||
| 33508 | 33508 | 206699 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998907.63682 | 2095545.7294400001 | 37.7339065275492 | -122.44618249194599 | (37.7339065275492, -122.446182491946) | |||
| 36687 | 36687 | 206698 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | |||
| 40516 | 40516 | 206701 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998876.80466 | 2095558.4978900002 | 37.733939825858606 | -122.446290005877 | (37.7339398258586, -122.446290005877) | |||
| 51664 | 51664 | 206697 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998934.9538199995 | 2095541.69667 | 37.733897014518206 | -122.446087759167 | (37.7338970145182, -122.446087759167) | |||
| 61905 | 61905 | 190927 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1050 Wisconsin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6012767.00645 | 2102579.68997 | 37.7540020378723 | -122.39875959738 | (37.7540020378723, -122.39875959738) | |||
| 70261 | 70261 | 126380 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1136 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.799775542566294 | -122.41812617837401 | (37.7997755425663, -122.418126178374) | |||
| 134815 | 134815 | 206702 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.733959270110795 | -122.446316727449 | (37.7339592701108, -122.446316727449) | |||
| 136744 | 136744 | 206664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 135 San Marcos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993646.4962 | 2100328.84926 | 37.7467379151376 | -122.464718926731 | (37.7467379151376, -122.464718926731) | |||
| 160368 | 160368 | 126382 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1001 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6008670.39988 | 2118624.74661 | 37.7978288673746 | -122.414061717575 | (37.7978288673746, -122.414061717575) | |||
| 160923 | 160923 | 206700 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998900.2822900005 | 2095547.61505 | 37.7339112849776 | -122.446208054284 | (37.7339112849776, -122.446208054284) | |||
| 175387 | 175387 | 126379 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1136 Havens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | |||
| 181759 | 181759 | 206559 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | |||
| 60482 | 60482 | 247587 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008949.04431 | 2096428.8077599998 | 37.7368996080238 | -122.41152853331499 | (37.7368996080238, -122.411528533315) | ||||
| 63732 | 63732 | 247588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 800 Tompkins Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008943.011630001 | 2096440.0672900002 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | ||||
| 76330 | 76330 | 126383 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1116 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | ||||
| 115431 | 115431 | 223053 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 701 Church St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 6004342.543869999 | 2104435.23189 | 37.7586239308804 | -122.42802562498998 | (37.7586239308804, -122.42802562499) | |||
| 148524 | 148524 | 126381 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1022 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008596.5256900005 | 2118672.84077 | 37.7979567725457 | -122.414320748412 | (37.7979567725457, -122.414320748412) | ||||
| 156749 | 156749 | 126384 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1120 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007500.24433 | 2119896.2377400002 | 37.8012542708165 | -122.418200985801 | (37.8012542708165, -122.418200985801) | ||||
| 159806 | 159806 | 249677 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2400 Baker St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999741.70445 | 2117184.6990900002 | 37.79336934518339 | -122.444853823654 | (37.7933693451834, -122.444853823654) | ||||
| 164342 | 164342 | 249691 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2400 Baker St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5999714.93782 | 2117284.79533 | 37.793642655433004 | -122.44495363669701 | (37.793642655433, -122.444953636697) | ||||
| 177824 | 177824 | 249686 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2400 Baker St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999708.23219 | 2117360.34158 | 37.7938497027636 | -122.444982272037 | (37.7938497027636, -122.444982272037) | ||||
| 187180 | 187180 | 223054 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 701 Church St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004339.171130001 | 2104460.25399 | 37.758692444824206 | -122.42803907256099 | (37.7586924448242, -122.428039072561) | |||
| 87649 | 87649 | 121661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 118078 | 118078 | 121664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 126565 | 126565 | 121663 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 142340 | 142340 | 121660 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 72707 | 72707 | 190928 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1778 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.39288202418301 | (37.73426491189, -122.392882024183) | |||
| 150656 | 150656 | 247816 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 550 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.741839226995204 | -122.43212766126899 | (37.7418392269952, -122.432127661269) | |||
| 539 | 539 | 206615 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | ||
| 553 | 553 | 206616 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.6803900003 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | ||
| 565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
| 571 | 571 | 206618 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | ||
| 23989 | 23989 | 206572 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | |||
| 24031 | 24031 | 206557 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 517 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995503.23656 | 2100160.4413400004 | 37.7463823798599 | -122.458286357642 | (37.7463823798599, -122.458286357642) | |||
| 24597 | 24597 | 206648 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.46176019139799 | (37.748320765087, -122.461760191398) | |||
| 25120 | 25120 | 206614 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.45992114704399 | (37.7468396428317, -122.459921147044) | |||
| 26518 | 26518 | 206504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.46661639913602 | (37.7517116786758, -122.466616399136) | |||
| 27341 | 27341 | 206556 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | |||
| 27743 | 27743 | 206657 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | |||
| 27805 | 27805 | 206612 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Sola Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994889.66342 | 2100721.49656 | 37.7478876192364 | -122.460448654307 | (37.7478876192364, -122.460448654307) | |||
| 28309 | 28309 | 206505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993138.76599 | 2102124.2403700002 | 37.7516383146611 | -122.46660507218701 | (37.7516383146611, -122.466605072187) | |||
| 29329 | 29329 | 206551 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 308 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994320.14066 | 2100781.15308 | 37.74801864146029 | -122.462422349606 | (37.7480186414603, -122.462422349606) | |||
| 29530 | 29530 | 218122 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | |||
| 29674 | 29674 | 206651 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994510.63767 | 2100971.03236 | 37.7485509699531 | -122.461777389118 | (37.7485509699531, -122.461777389118) | |||
| 30002 | 30002 | 206592 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993721.8716 | 2099672.6551599996 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | |||
| 33057 | 33057 | 206553 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 352 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5994206.928780001 | 2101186.05332 | 37.74912387497 | -122.462843199074 | (37.74912387497, -122.462843199074) | |||
| 33279 | 33279 | 206578 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993312.03833 | 2099686.0969 | 37.7449537923783 | -122.46582874591199 | (37.7449537923783, -122.465828745912) | |||
| 33381 | 33381 | 206506 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993143.71774 | 2101970.98373 | 37.7512177970674 | -122.46657681008301 | (37.7512177970674, -122.466576810083) | |||
| 34016 | 34016 | 206586 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.745094043463396 | -122.46346102880699 | (37.7450940434634, -122.463461028807) | |||
| 34122 | 34122 | 206658 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | |||
| 35264 | 35264 | 206544 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 337 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994178.74316 | 2101030.22278 | 37.7486943803622 | -122.462929360401 | (37.7486943803622, -122.462929360401) | |||
| 39199 | 39199 | 206623 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | |||
| 39280 | 39280 | 206536 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | |||
| 39798 | 39798 | 206669 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994007.62455 | 2100906.4247 | 37.74834460433671 | -122.463512099503 | (37.7483446043367, -122.463512099503) | |||
| 40135 | 40135 | 206582 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765798996 | -122.464803087101 | (37.745215765799, -122.464803087101) | |||
| 40559 | 40559 | 206571 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993219.180819999 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | |||
| 41542 | 41542 | 206581 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.745210335700605 | -122.46487003355301 | (37.7452103357006, -122.464870033553) | |||
| 42406 | 42406 | 182596 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.746680511997496 | -122.47664737488998 | (37.7466805119975, -122.47664737489) | |||
| 43524 | 43524 | 206628 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | |||
| 44246 | 44246 | 206584 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993659.8453 | 2099783.1011200002 | 37.745240198571295 | -122.464633144905 | (37.7452401985713, -122.464633144905) | |||
| 44510 | 44510 | 218322 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.745697098249394 | -122.466270063011 | (37.7456970982494, -122.466270063011) | |||
| 45428 | 45428 | 206576 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993684.51151 | 2099645.64672 | 37.744864205510204 | -122.46453787523501 | (37.7448642055102, -122.464537875235) | |||
| 46146 | 46146 | 206555 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.74907516320621 | -122.463926929805 | (37.7490751632062, -122.463926929805) | |||
| 47868 | 47868 | 206574 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993698.095930001 | 2099619.5133 | 37.744793232835605 | -122.464489006068 | (37.7447932328356, -122.464489006068) | |||
| 49358 | 49358 | 206666 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993976.53914 | 2100938.08553 | 37.74842974584271 | -122.46362188875901 | (37.7484297458427, -122.463621888759) | |||
| 49506 | 49506 | 206607 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2 Sola Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994975.69537 | 2100714.97086 | 37.7478746501056 | -122.460150689128 | (37.7478746501056, -122.460150689128) | |||
| 51395 | 51395 | 206653 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 150 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994496.6283 | 2101014.48441 | 37.748669471824 | -122.46182898323 | (37.748669471824, -122.46182898323) | |||
| 51397 | 51397 | 206539 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.46316740736499 | (37.749759810788, -122.463167407365) | |||
| 52949 | 52949 | 206549 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 308 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994338.43004 | 2100748.81738 | 37.7479309089808 | -122.462356761175 | (37.7479309089808, -122.462356761175) | |||
| 53756 | 53756 | 206652 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994516.45103 | 2100943.3174900003 | 37.74847520657389 | -122.4617552775 | (37.7484752065739, -122.4617552775) | |||
| 54773 | 54773 | 206638 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 167 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994538.83302 | 2100858.6540099997 | 37.7482440304446 | -122.46167174395 | (37.7482440304446, -122.46167174395) | |||
| 55162 | 55162 | 206635 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994551.94388 | 2100907.9053700003 | 37.7483800169362 | -122.461629977657 | (37.7483800169362, -122.461629977657) | |||
| 56091 | 56091 | 206541 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 375 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994147.31458 | 2101302.53521 | 37.7494402708691 | -122.463057794403 | (37.7494402708691, -122.463057794403) | |||
| 56263 | 56263 | 206670 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994011.71818 | 2100897.82655 | 37.7483212318599 | -122.463497320046 | (37.7483212318599, -122.463497320046) | |||
| 56319 | 56319 | 206573 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | |||
| 57787 | 57787 | 206540 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.46310540451401 | (37.7496241156629, -122.463105404514) | |||
| 58009 | 58009 | 206641 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.748079875384796 | -122.462020618849 | (37.7480798753848, -122.462020618849) | |||
| 58785 | 58785 | 206665 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.748285339014295 | -122.463983980089 | (37.7482853390143, -122.463983980089) | |||
| 59046 | 59046 | 206654 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994247.90783 | 2101537.24109 | 37.7500905076701 | -122.46272696707399 | (37.7500905076701, -122.462726967074) | |||
| 61321 | 61321 | 206667 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.74840637335971 | -122.46358599590499 | (37.7484063733597, -122.463585995905) | |||
| 62866 | 62866 | 206570 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993230.1067699995 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | |||
| 63202 | 63202 | 206604 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995043.01031 | 2100739.53906 | 37.747945979831 | -122.45991969824 | (37.747945979831, -122.45991969824) | |||
| 64527 | 64527 | 206668 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993998.36893 | 2100916.3469700003 | 37.7483713150869 | -122.46354482495501 | (37.7483713150869, -122.463544824955) | |||
| 66424 | 66424 | 206580 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993286.92729 | 2099684.15258 | 37.7449470052046 | -122.46591543334401 | (37.7449470052046, -122.465915433344) | |||
| 66445 | 66445 | 206538 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 399 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994103.277319999 | 2101446.93652 | 37.749834223367294 | -122.463220551898 | (37.7498342233673, -122.463220551898) | |||
| 66581 | 66581 | 206606 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Magellan Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995035.92285 | 2100721.97488 | 37.747897345392 | -122.459942934033 | (37.747897345392, -122.459942934033) | |||
| 67067 | 67067 | 206660 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994227.712619999 | 2101539.78712 | 37.750096335277796 | -122.462796987411 | (37.7500963352778, -122.462796987411) | |||
| 68099 | 68099 | 206662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994173.63187 | 2101468.0491400003 | 37.749896246027106 | -122.462978796147 | (37.7498962460271, -122.462978796147) | |||
| 68999 | 68999 | 206663 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994181.82756 | 2101452.31219 | 37.7498535084399 | -122.46294931367399 | (37.7498535084399, -122.462949313674) | |||
| 69565 | 69565 | 206610 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Sola Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994851.290519999 | 2100738.8321 | 37.7479330107067 | -122.46058260112 | (37.7479330107067, -122.46058260112) | |||
| 69850 | 69850 | 206611 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Sola Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994869.30829 | 2100730.97603 | 37.7479124764813 | -122.460519727717 | (37.7479124764813, -122.460519727717) | |||
| 72564 | 72564 | 206631 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994365.2652199995 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | |||
| 72855 | 72855 | 206620 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993657.1596800005 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | |||
| 72889 | 72889 | 206577 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993636.2641900005 | 2099712.16168 | 37.745044057332294 | -122.464709533316 | (37.7450440573323, -122.464709533316) | |||
| 74247 | 74247 | 206636 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 159 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994544.936980001 | 2100878.69027 | 37.7482993963164 | -122.461652089281 | (37.7482993963164, -122.461652089281) |
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");