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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
160435 | 160435 | 206511 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.757983346478795 | -122.474289787164 | (37.7579833464788, -122.474289787164) | |||
55765 | 55765 | 206510 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.757981610781606 | -122.474340288587 | (37.7579816107816, -122.474340288587) | |||
50270 | 50270 | 206508 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | |||
153105 | 153105 | 206509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.75798161076639 | -122.47438420248501 | (37.7579816107664, -122.474384202485) | |||
139629 | 139629 | 68592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | ||
141520 | 141520 | 35070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | ||
82844 | 82844 | 51539 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
89767 | 89767 | 51538 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
93350 | 93350 | 51537 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
113070 | 113070 | 51536 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
88086 | 88086 | 104352 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 304 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | Permit Number 770823 | 6001744.6 | 2103958.8 | 37.757168440961706 | -122.43697636949601 | (37.7571684409617, -122.436976369496) | |||
40226 | 40226 | 223024 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 979 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009975.926030001 | 2103539.78877 | 37.756482348291996 | -122.40847958248399 | (37.756482348292, -122.408479582484) | |||
128961 | 128961 | 54717 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 24726 | 6004298.03079874 | 2103629.31683929 | 37.756408560199 | -122.428122138519 | (37.756408560199, -122.428122138519) | ||
46262 | 46262 | 223026 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 114 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004706.47094 | 2102901.67728 | 37.7544337331488 | -122.42665779482799 | (37.7544337331488, -122.426657794828) | |||
35553 | 35553 | 223027 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 116 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004711.2067599995 | 2102860.50548 | 37.754320952762 | -122.426638485476 | (37.754320952762, -122.426638485476) | |||
106851 | 106851 | 94159 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53536 | 5993712.5 | 2103021.2 | 37.754134227954005 | -122.464686168912 | (37.754134227954, -122.464686168912) | ||
96862 | 96862 | 121558 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 400X Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 6003675.0 | 2102779.0 | 37.754038521377794 | -122.430216135756 | (37.7540385213778, -122.430216135756) | |||
107049 | 107049 | 121560 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 400X Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 6003675.0 | 2102779.0 | 37.754038521377794 | -122.430216135756 | (37.7540385213778, -122.430216135756) | |||
82611 | 82611 | 66726 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 416 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31446 | 6003651.13955938 | 2102766.75784402 | 37.754003555820105 | -122.430297777513 | (37.7540035558201, -122.430297777513) | ||
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) | |||
106193 | 106193 | 47123 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.753887161855104 | -122.47200398758899 | (37.7538871618551, -122.472003987589) | ||
18434 | 18434 | 28792 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008964.243480001 | 2102548.86607 | 37.753704789464294 | -122.411908330514 | (37.7537047894643, -122.411908330514) | |||
20561 | 20561 | 28791 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.41189526514799 | (37.7535963186214, -122.411895265148) | |||
55439 | 55439 | 223036 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | |||
119254 | 119254 | 65260 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) | ||
69893 | 69893 | 223047 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6004003.36703 | 2102490.39098 | 37.7532646621477 | -122.429059987437 | (37.7532646621477, -122.429059987437) | |||
77157 | 77157 | 223048 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3880 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6003922.515380001 | 2102484.70879 | 37.7532444831531 | -122.429339183778 | (37.7532444831531, -122.429339183778) | |||
122539 | 122539 | 190926 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1303 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6012003.88758 | 2102215.75937 | 37.7529602155494 | -122.40137308660401 | (37.7529602155494, -122.401373086604) | |||
132401 | 132401 | 206621 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993175.256709999 | 2102431.1044799997 | 37.7524829903015 | -122.46650118519301 | (37.7524829903015, -122.466501185193) | |||
173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
49647 | 49647 | 206622 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.752445798858396 | -122.466499759777 | (37.7524457988584, -122.466499759777) | |||
116961 | 116961 | 68613 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.75205353684021 | -122.474266156198 | (37.7520535368402, -122.474266156198) | ||
115026 | 115026 | 34301 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38089 | 6010337.06875453 | 2101902.38195398 | 37.7520066112995 | -122.407115203053 | (37.7520066112995, -122.407115203053) | ||
140639 | 140639 | 68598 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.47300685208599 | (37.7520016305294, -122.473006852086) | ||
72290 | 72290 | 82688 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | |
128328 | 128328 | 67340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.75196069589111 | -122.403505842523 | (37.7519606958911, -122.403505842523) | ||
99952 | 99952 | 34302 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38090 | 6010338.30191232 | 2101880.05024725 | 37.7519453623814 | -122.407109364623 | (37.7519453623814, -122.407109364623) | ||
167733 | 167733 | 206503 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.751788644440495 | -122.46662048837 | (37.7517886444405, -122.46662048837) | |||
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) | |||
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) | |||
143418 | 143418 | 68621 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.47423624838899 | (37.7516236388925, -122.474236248389) | ||
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) | |||
83006 | 83006 | 68501 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.751535602028206 | -122.46642090906602 | (37.7515356020282, -122.466420909066) | ||
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) | |||
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) | |||
137122 | 137122 | 206507 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.46657295558599 | (37.751190371338, -122.466572955586) | |||
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) | |||
186378 | 186378 | 206627 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994076.75455 | 2101874.6545700002 | 37.751007100296604 | -122.463343302157 | (37.7510071002966, -122.463343302157) | |||
184549 | 184549 | 206626 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994084.99265 | 2101862.2244599997 | 37.750973444992205 | -122.46331391231199 | (37.7509734449922, -122.463313912312) | |||
165454 | 165454 | 206630 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 81 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994323.8061 | 2101846.4166200003 | 37.7509437961254 | -122.46248693172701 | (37.7509437961254, -122.462486931727) | |||
154984 | 154984 | 206629 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.46257206157101 | (37.7509117433916, -122.462572061571) | |||
121588 | 121588 | 34344 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1325 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38101 | 6010099.44079349 | 2101484.52277039 | 37.7508459613928 | -122.40790749535499 | (37.7508459613928, -122.407907495355) | ||
185968 | 185968 | 206624 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994298.51296 | 2101800.2527099997 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | |||
174439 | 174439 | 206625 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374828999 | (37.7507963531822, -122.46262374829) | |||
73565 | 73565 | 223025 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 380 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005467.6636 | 2101500.58617 | 37.750629666539396 | -122.423925765973 | (37.7506296665394, -122.423925765973) | |||
125044 | 125044 | 46345 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 382 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2002 12:00:00 AM | Permit Number 44591 | 6005460.79581087 | 2101487.62598308 | 37.7505936931274 | -122.423948593876 | (37.7505936931274, -122.423948593876) | ||
78925 | 78925 | 69199 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1342 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33247 | 6009509.54623645 | 2101351.16759285 | 37.7504467544428 | -122.409938000531 | (37.7504467544428, -122.409938000531) | ||
189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
181807 | 181807 | 206656 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994277.8238699995 | 2101540.85875 | 37.75010216378529 | -122.46262377888 | (37.7501021637853, -122.46262377888) | |||
175120 | 175120 | 206659 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | |||
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) | |||
157129 | 157129 | 206655 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994255.40167 | 2101538.8525799997 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | |||
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) | |||
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) | |||
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) | |||
115230 | 115230 | 52741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 409@ ALTON Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48790 | 5994026.96721275 | 2101530.61038788 | 37.750059574115895 | -122.46349050523399 | (37.7500595741159, -122.463490505234) | |||
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) | |||
118821 | 118821 | 47955 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 59 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2002 12:00:00 AM | Permit Number 45685 | 6001000.20919275 | 2101375.03881203 | 37.7500317183297 | -122.439365554728 | (37.7500317183297, -122.439365554728) | |||
64939 | 64939 | 206563 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2047 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993157.06576 | 2101533.95115 | 37.750018588 | -122.466498890138 | (37.750018588, -122.466498890138) | |||
188058 | 188058 | 206537 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | |||
74950 | 74950 | 206661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | |||
78195 | 78195 | 47741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1384 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 45524 | 6010066.05430582 | 2101146.00958918 | 37.7499146097647 | -122.40799907978399 | (37.7499146097647, -122.407999079784) | ||
79903 | 79903 | 63792 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4094 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24478 | 6003252.0069667995 | 2101284.19573809 | 37.7499101740217 | -122.43157223645099 | (37.7499101740217, -122.431572236451) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
70281 | 70281 | 206632 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 99 Castenada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994454.48924 | 2101216.21265 | 37.749220940594604 | -122.46198932515 | (37.7492209405946, -122.46198932515) | |||
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) | |||
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) | |||
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) | |||
151567 | 151567 | 206554 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993895.61602 | 2101166.1129900003 | 37.749051188161296 | -122.46391826663401 | (37.7490511881613, -122.463918266634) | |||
148350 | 148350 | 206542 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 351 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994154.36407 | 2101104.3868400003 | 37.748896611800106 | -122.46301904261999 | (37.7488966118001, -122.46301904262) | |||
174659 | 174659 | 206543 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 347 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994159.12368 | 2101087.0695700003 | 37.7488493371331 | -122.463001327749 | (37.7488493371331, -122.463001327749) | |||
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) | |||
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) | |||
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) | |||
180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
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) | |||
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) | |||
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) | |||
177772 | 177772 | 206633 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994552.3071099995 | 2100925.23177 | 37.7484276117632 | -122.461629977659 | (37.7484276117632, -122.461629977659) | |||
76418 | 76418 | 206650 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994518.14401 | 2100922.4103 | 37.748417898168995 | -122.461747907542 | (37.748417898169, -122.461747907542) | |||
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) | |||
164232 | 164232 | 206634 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994552.462069999 | 2100915.6770099998 | 37.748401385725 | -122.461628749166 | (37.748401385725, -122.461628749166) | |||
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) | |||
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) | |||
161837 | 161837 | 206649 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994518.46873 | 2100904.0082799997 | 37.7483673895631 | -122.461745450587 | (37.7483673895631, -122.461745450587) |
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");