Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1013 | 1013 | 223102 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 247 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779888 | 6004283.79281 | 2099537.35517 | 37.74517218196571 | -122.42787981341101 | (37.7451721819657, -122.427879813411) | |
| 2031 | 2031 | 251786 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
| 3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
| 16913 | 16913 | 24553 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 404 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6007222.65374 | 2097265.29025 | 37.7390994163072 | -122.41755671238501 | (37.7390994163072, -122.417556712385) | |||
| 17396 | 17396 | 28296 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1432 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2003 12:00:00 AM | 6 | 2X3 | 6005818.9272 | 2100626.68333 | 37.7482499542668 | -122.42264897149599 | (37.7482499542668, -122.422648971496) | ||
| 17882 | 17882 | 52665 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774794 | 6000815.0 | 2109317.0 | 37.77182785317 | -122.440575583218 | (37.77182785317, -122.440575583218) | |
| 18010 | 18010 | 24554 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 412 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6007266.67907 | 2097258.15357 | 37.7390822977194 | -122.41740398679899 | (37.7390822977194, -122.417403986799) | |||
| 18096 | 18096 | 24588 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | ||
| 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) | |||
| 18475 | 18475 | 26484 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 154 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000987.64369 | 2098692.2557200002 | 37.7426647191989 | -122.439216742684 | (37.7426647191989, -122.439216742684) | |||
| 19410 | 19410 | 42456 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42599 | 5997659.71395367 | 2095289.95204904 | 37.733132877616896 | -122.45047848670099 | (37.7331328776169, -122.450478486701) | ||
| 19500 | 19500 | 68125 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.744400650970604 | -122.42180635131201 | (37.7444006509706, -122.421806351312) | ||
| 19529 | 19529 | 24597 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.41685698498101 | (37.7391518611665, -122.416856984981) | ||
| 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) | |||
| 20614 | 20614 | 65804 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.47384127538099 | (37.7459566686168, -122.473841275381) | ||
| 20665 | 20665 | 24587 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 804 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1996 12:00:00 AM | 18 | 3X3 | 6008146.87115 | 2097150.7739799998 | 37.738836941075 | -122.414353078142 | (37.738836941075, -122.414353078142) | ||
| 20916 | 20916 | 24556 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 416 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6007294.81147 | 2097256.19199 | 37.739078494466 | -122.41730657855801 | (37.739078494466, -122.417306578558) | |||
| 22356 | 22356 | 223022 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6006257.519669999 | 2099541.04409 | 37.745293770294104 | -122.42105525588998 | (37.7452937702941, -122.42105525589) | |||
| 25122 | 25122 | 206533 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.45831551006201 | (37.7288857636427, -122.458315510062) | |||
| 25265 | 25265 | 223034 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007664.494030001 | 2096661.03983 | 37.7374651296141 | -122.41598624606199 | (37.7374651296141, -122.415986246062) | |||
| 29378 | 29378 | 95906 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1323 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767607 | 5987385.7768 | 2106255.5896 | 37.7626482044987 | -122.486802739667 | (37.7626482044987, -122.486802739667) |
| 29986 | 29986 | 206673 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995261.57654 | 2095226.1050200001 | 37.7328200206111 | -122.45876481406201 | (37.7328200206111, -122.458764814062) | |||
| 34642 | 34642 | 223020 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6006199.74889 | 2099432.38497 | 37.7449921601655 | -122.421247303447 | (37.7449921601655, -122.421247303447) | |||
| 34880 | 34880 | 206682 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 647 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995986.285069999 | 2096009.4987 | 37.7350126577011 | -122.45631595293699 | (37.7350126577011, -122.456315952937) | |||
| 35057 | 35057 | 31228 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.738523749481104 | -122.47111005511002 | (37.7385237494811, -122.47111005511) | |
| 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) | |||
| 35567 | 35567 | 206696 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000774.6257 | 2094855.9884099998 | 37.7321191034008 | -122.439678327791 | (37.7321191034008, -122.439678327791) | |||
| 36017 | 36017 | 31915 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1996 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | |
| 37239 | 37239 | 41230 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3618 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41935 | 6002625.18254 | 2121047.68706 | 37.804140238442 | -122.43515322167102 | (37.804140238442, -122.435153221671) |
| 39350 | 39350 | 223040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 567 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007699.61186 | 2096703.5074099998 | 37.7375837106174 | -122.41586783322799 | (37.7375837106174, -122.415867833228) | |||
| 39830 | 39830 | 70315 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 226 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 5 | 5997860.8667 | 2109778.6627 | 37.7729267975155 | -122.450827376517 | (37.7729267975155, -122.450827376517) | ||
| 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) | |||
| 42708 | 42708 | 206685 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.45608116333099 | (37.734938180348, -122.456081163331) | |||
| 42780 | 42780 | 200073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1500 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014933.989 | 2093151.8218 | 37.7282355589188 | -122.390606833955 | (37.7282355589188, -122.390606833955) | |||
| 42989 | 42989 | 39658 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.45626220721901 | (37.7199614976995, -122.456262207219) | ||
| 43403 | 43403 | 223031 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 38 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998471.48427 | 2106911.98504 | 37.7650905653978 | -122.448508695418 | (37.7650905653978, -122.448508695418) | |||
| 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) | |||
| 47365 | 47365 | 141302 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 208 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998449.1975 | 2112684.3341 | 37.780938681749895 | -122.449001631605 | (37.7809386817499, -122.449001631605) | |||
| 48597 | 48597 | 47077 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 135 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 3 | Permit Number 45064 | 5996788.5617 | 2112098.8644 | 37.779236022786606 | -122.454704245524 | (37.7792360227866, -122.454704245524) | |
| 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) | |||
| 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) | |||
| 50581 | 50581 | 38530 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | ||
| 51810 | 51810 | 206519 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991734.05463 | 2099933.45812 | 37.7455418303067 | -122.471303093689 | (37.7455418303067, -122.471303093689) | |||
| 52114 | 52114 | 223023 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006515.400219999 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | |||
| 53148 | 53148 | 206498 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | |||
| 55179 | 55179 | 184366 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | |||
| 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) | |||
| 58097 | 58097 | 206689 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.45576252094901 | (37.734869823774, -122.455762520949) | |||
| 61636 | 61636 | 223021 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | |||
| 62392 | 62392 | 206521 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991723.002619999 | 2099864.63418 | 37.7453522181485 | -122.471336295754 | (37.7453522181485, -122.471336295754) | |||
| 63545 | 63545 | 223038 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 10 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002089.19721 | 2096067.16423 | 37.7355194490575 | -122.435220170783 | (37.7355194490575, -122.435220170783) | |||
| 64063 | 64063 | 122404 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5994085.0 | 2099826.0 | 37.74538248907739 | -122.46316615516001 | (37.7453824890774, -122.46316615516) | ||||
| 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) | |||
| 65033 | 65033 | 31914 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2286 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42223 | 5991731.014359999 | 2099907.3159 | 37.7454698746265 | -122.471311701978 | (37.7454698746265, -122.471311701978) | |
| 66473 | 66473 | 206691 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5996439.41867 | 2095873.6949599998 | 37.734665775709296 | -122.45473950971599 | (37.7346657757093, -122.454739509716) | |||
| 68623 | 68623 | 63086 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1209 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1986 12:00:00 AM | 3 | Permit Number 23570 | 5983326.3714 | 2106866.623 | 37.7640884282736 | -122.500887729919 | (37.7640884282736, -122.500887729919) | ||
| 69745 | 69745 | 223042 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.736354605390204 | -122.418528488295 | (37.7363546053902, -122.418528488295) | |||
| 69773 | 69773 | 223051 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 24 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001422.87059 | 2107990.68113 | 37.7682207070445 | -122.438377882942 | (37.7682207070445, -122.438377882942) | |||
| 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) | |||
| 69960 | 69960 | 68121 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31868 | 6006245.31002458 | 2099503.96919514 | 37.745191282743896 | -122.421094842871 | (37.7451912827439, -122.421094842871) | ||
| 70255 | 70255 | 206531 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.730879244086296 | -122.46533008801399 | (37.7308792440863, -122.465330088014) | |||
| 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) | |
| 73002 | 73002 | 31750 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | |
| 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) | |||
| 73810 | 73810 | 223029 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997728.707169999 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | |||
| 74063 | 74063 | 31296 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 431 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34940 | 5991578.61319 | 2097704.4347 | 37.7394125098801 | -122.47167817211201 | (37.7394125098801, -122.471678172112) | |
| 74097 | 74097 | 223041 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007256.618290001 | 2097259.39898 | 37.7390851512711 | -122.41743886071899 | (37.7390851512711, -122.417438860719) | |||
| 74719 | 74719 | 206524 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.742716096581894 | -122.467054169341 | (37.7427160965819, -122.467054169341) | |||
| 75089 | 75089 | 206565 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991740.0000599995 | 2097213.7223099996 | 37.7380744742606 | -122.471084432514 | (37.7380744742606, -122.471084432514) | |||
| 75714 | 75714 | 206568 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991380.56657 | 2098286.2467799997 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | |||
| 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) | |||
| 77159 | 77159 | 176073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155267999 | (37.7169766182659, -122.43531155268) | |||
| 77680 | 77680 | 63803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.41075136529899 | (37.7385764323817, -122.410751365299) | ||
| 77698 | 77698 | 68120 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.745340567320106 | -122.42120066595501 | (37.7453405673201, -122.421200665955) | ||
| 77864 | 77864 | 34431 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38175 | 6002613.57489862 | 2096408.07550267 | 37.736485277081705 | -122.433431554421 | (37.7364852770817, -122.433431554421) | ||
| 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) | ||
| 78398 | 78398 | 62968 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1136 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | Permit Number 23354 | 6007556.73602589 | 2118875.23289672 | 37.7984540273893 | -122.41793308103901 | (37.7984540273893, -122.417933081039) | ||
| 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) | ||
| 79811 | 79811 | 62908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23285 | 6007239.73762584 | 2097259.44248715 | 37.7390843209207 | -122.41749722959699 | (37.7390843209207, -122.417497229597) | ||
| 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) | ||
| 80468 | 80468 | 51543 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 47842 | 6006500.80110502 | 2104175.14616456 | 37.7580316646871 | -122.4205429163 | (37.7580316646871, -122.4205429163) | ||
| 80515 | 80515 | 94075 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116.0 | 2095941.0 | 37.734832022473 | -122.45586253488399 | (37.734832022473, -122.455862534884) | ||
| 81651 | 81651 | 82780 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3946 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50814 | 6003353.51076321 | 2104798.51931181 | 37.75956542629571 | -122.43147208276001 | (37.7595654262957, -122.43147208276) | ||
| 82231 | 82231 | 48500 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1584(REVISED) Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2003 12:00:00 AM | Permit Number 46340 | 5998006.8549345005 | 2108237.90665559 | 37.7687046321234 | -122.45021130824301 | (37.7687046321234, -122.450211308243) | |||
| 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) | ||
| 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) | ||
| 83530 | 83530 | 68124 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31872 | 6006189.84017158 | 2099400.84484915 | 37.7449049995041 | -122.421279326768 | (37.7449049995041, -122.421279326768) | ||
| 84074 | 84074 | 66157 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1765 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29228 | 6013882.21689766 | 2094959.68148484 | 37.733141166757896 | -122.39436940843201 | (37.7331411667579, -122.394369408432) | ||
| 84739 | 84739 | 40751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) | ||
| 86251 | 86251 | 39660 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | ||
| 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) | |||
| 88498 | 88498 | 35377 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38834 | 6011637.61839103 | 2091581.433538 | 37.7237401685956 | -122.401892240977 | (37.7237401685956, -122.401892240977) | ||
| 89728 | 89728 | 82956 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
| 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) | ||
| 90333 | 90333 | 53193 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.745921466667205 | -122.419059278748 | (37.7459214666672, -122.419059278748) | ||
| 91932 | 91932 | 62709 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1171 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | Permit Number 23049 | 6007422.95308964 | 2118804.22805474 | 37.798251535762205 | -122.418390975112 | (37.7982515357622, -122.418390975112) | ||
| 91943 | 91943 | 60436 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 474 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 20020 | 6003505.36219814 | 2098957.85837164 | 37.743536950172206 | -122.43053014999599 | (37.7435369501722, -122.430530149996) | ||
| 94076 | 94076 | 48468 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1409 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/2002 12:00:00 AM | Permit Number 45831 | 6003303.13281599 | 2100036.19716336 | 37.746486359598705 | -122.431306366847 | (37.7464863595987, -122.431306366847) | ||
| 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) | |||
| 96993 | 96993 | 63825 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24513 | 6009008.49456519 | 2097079.12708776 | 37.738688578203295 | -122.41136891509899 | (37.7386885782033, -122.411368915099) |
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");