Data source: data.sfgov.org
This data as json, CSV (advanced)
qCaretaker ✖
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22000 | 22000 | 4189 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1998 12:00:00 AM | 6 | 3X3 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | ||
| 113062 | 113062 | 4198 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3885X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6004619.1213 | 2100435.76727 | 37.7476579790206 | -122.42678427332199 | (37.7476579790206, -122.426784273322) | ||
| 21380 | 21380 | 4200 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3890 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6004657.19405 | 2100480.3462900002 | 37.7477825352565 | -122.42665579384399 | (37.7477825352565, -122.426655793844) | ||
| 17744 | 17744 | 4206 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3920 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004377.17948 | 2100465.22503 | 37.7477251809744 | -122.427622993127 | (37.7477251809744, -122.427622993127) | ||
| 19167 | 19167 | 4207 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3925 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004350.15957 | 2100418.81646 | 37.747596225391504 | -122.427713120473 | (37.7475962253915, -122.427713120473) | ||
| 16975 | 16975 | 4208 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3928 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004332.42415 | 2100461.61534 | 37.747712737955105 | -122.427777497548 | (37.7477127379551, -122.427777497548) | ||
| 21356 | 21356 | 4210 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3932 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2004 12:00:00 AM | 3 | 3X3 | 6004303.84786 | 2100460.14425 | 37.7477070821197 | -122.427876208032 | (37.7477070821197, -122.427876208032) | ||
| 21328 | 21328 | 4211 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 3935 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004300.14403 | 2100415.02402 | 37.7475829828864 | -122.427885801087 | (37.7475829828864, -122.427885801087) | |||
| 18600 | 18600 | 4218 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3955 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1998 12:00:00 AM | 3 | 3X3 | 6004198.47443 | 2100405.87482 | 37.747552109146206 | -122.42823671656099 | (37.7475521091462, -122.428236716561) | ||
| 87057 | 87057 | 4219 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3957 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004180.2435918 | 2100406.5432146 | 37.7475529128468 | -122.428299805317 | (37.7475529128468, -122.428299805317) | ||
| 21681 | 21681 | 4232 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3997 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 12 | 3x3 | 6003965.74465 | 2100395.01673 | 37.7475091242643 | -122.429040707768 | (37.7475091242643, -122.429040707768) | ||
| 9219 | 9219 | 4233 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4000X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003879.3665122 | 2100440.460437 | 37.7476290122472 | -122.429342637933 | (37.7476290122472, -122.429342637933) | ||
| 19154 | 19154 | 4234 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4013X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003806.79862 | 2100387.84018 | 37.7474804205949 | -122.429589821227 | (37.7474804205949, -122.429589821227) | ||
| 17528 | 17528 | 4246 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4038 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/1995 12:00:00 AM | 3 | 3X3 | 6003621.03642 | 2100422.76167 | 37.747565786929 | -122.43023466569599 | (37.747565786929, -122.430234665696) | ||
| 22128 | 22128 | 4249 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4043 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 12 | 3X3 | 6003613.964 | 2100376.48243 | 37.7474383143284 | -122.43025582047599 | (37.7474383143284, -122.430255820476) | ||
| 17093 | 17093 | 4261 | Permitted Site 1 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 4140 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6002986.31011 | 2100390.0422900002 | 37.7474399753816 | -122.43242717239201 | (37.7474399753816, -122.432427172392) | ||
| 20989 | 20989 | 4262 | Permitted Site 1 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 4140 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2013 12:00:00 AM | 3 | 3X3 | Permit Number 769862 | 6002957.66271 | 2100387.9842 | 37.747432699854706 | -122.432526086131 | (37.7474326998547, -122.432526086131) | |
| 19764 | 19764 | 4267 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4182 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6002831.44442 | 2100380.32351 | 37.7474045070076 | -122.43296199290899 | (37.7474045070076, -122.432961992909) | ||
| 21429 | 21429 | 4275 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 4215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002481.0949 | 2100316.7179400004 | 37.7472099827631 | -122.434168929879 | (37.7472099827631, -122.434168929879) | |||
| 20836 | 20836 | 4276 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4221 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1995 12:00:00 AM | 3 | 3x3 | 6002451.40883 | 2100314.3802 | 37.7472018789671 | -122.434271414787 | (37.7472018789671, -122.434271414787) | ||
| 20787 | 20787 | 4288 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4314 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001830.459 | 2100325.99082 | 37.7471984948291 | -122.436419438314 | (37.7471984948291, -122.436419438314) | ||
| 21715 | 21715 | 4289 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4318 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001802.38664 | 2100324.70976 | 37.747193382168604 | -122.43651641850799 | (37.7471933821686, -122.436516418508) | ||
| 17135 | 17135 | 4290 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4319 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001811.82225 | 2100290.20269 | 37.7470991700926 | -122.43648132156099 | (37.7470991700926, -122.436481321561) | ||
| 21277 | 21277 | 4291 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4324 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001780.20994 | 2100324.37087 | 37.7471911914402 | -122.43659307941999 | (37.7471911914402, -122.43659307942) | ||
| 19895 | 19895 | 4295 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4342 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2003 12:00:00 AM | 3 | 3X3 | 6001671.89746 | 2100317.83526 | 37.7471670905043 | -122.436967147015 | (37.7471670905043, -122.436967147015) | ||
| 19182 | 19182 | 4299 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4366 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001539.555819999 | 2100311.7976 | 37.747142989565 | -122.437424340763 | (37.747142989565, -122.437424340763) | ||
| 18253 | 18253 | 4301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4374 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001502.87912 | 2100307.76951 | 37.7471298441855 | -122.43755087718 | (37.7471298441855, -122.43755087718) | |||
| 22002 | 22002 | 4306 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4390 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001409.31695 | 2100304.12131 | 37.747114507137205 | -122.437874145675 | (37.7471145071372, -122.437874145675) | ||
| 22236 | 22236 | 4405 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.42777434091299 | (37.7540702011025, -122.427774340913) | ||
| 20087 | 20087 | 4439 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1302 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004459.83721 | 2101280.4453 | 37.749968261937106 | -122.42739523262699 | (37.7499682619371, -122.427395232627) | |||
| 21867 | 21867 | 4450 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.29512 | 2100913.96053 | 37.748963363065 | -122.427284553034 | (37.748963363065, -122.427284553034) | |||
| 21005 | 21005 | 4464 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1467 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004576.21057 | 2100336.17551 | 37.7473820968062 | -122.42692556438801 | (37.7473820968062, -122.426925564388) | ||
| 125619 | 125619 | 4829 | DPW Maintained 3 | Prunus x 'Amanogawa' :: Flowering Cherry 57 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2011 12:00:00 AM | 3 | 3x3 | 6006236.958897 | 2097686.3159311 | 37.740199945442704 | -122.42099468815701 | (37.7401999454427, -122.420994688157) | ||
| 17409 | 17409 | 4836 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 6 | 3X3 | 6006379.67825 | 2097659.7420099997 | 37.7401350234134 | -122.420499335499 | (37.7401350234134, -122.420499335499) | ||
| 18906 | 18906 | 5095 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2611 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 6 | 3X3 | 6002301.7516 | 2096545.88638 | 37.7368459778655 | -122.43451950896099 | (37.7368459778655, -122.434519508961) | ||
| 21743 | 21743 | 5096 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2617 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2005 12:00:00 AM | 15 | 4x7 | 6002321.1773 | 2096442.08451 | 37.7365620645731 | -122.43444492640499 | (37.7365620645731, -122.434444926405) | ||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 104519 | 104519 | 5100 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6002314.2781061 | 2096520.2165863998 | 37.7367762056107 | -122.43447436453998 | (37.7367762056107, -122.43447436454) | |||
| 17693 | 17693 | 5140 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2922 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2011 12:00:00 AM | 3 | 3x3 | 6002319.208819999 | 2095185.9682200002 | 37.7331129460068 | -122.43436195314399 | (37.7331129460068, -122.434361953144) | ||
| 17462 | 17462 | 5454 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 561 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2009 12:00:00 AM | 3 | 8 | 6004988.38949 | 2105109.00015 | 37.76051045761329 | -122.42583995496099 | (37.7605104576133, -122.425839954961) | ||
| 18067 | 18067 | 5516 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.756042537557605 | -122.425422183901 | (37.7560425375576, -122.425422183901) | ||
| 17474 | 17474 | 5669 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1411 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005264.89314 | 2100092.7159 | 37.746752529107596 | -122.42452683054701 | (37.7467525291076, -122.424526830547) | |||
| 21108 | 21108 | 5697 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1551 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2007 12:00:00 AM | 3 | 6X6 | 6005311.69042 | 2099268.6032 | 37.7444923466503 | -122.424306405838 | (37.7444923466503, -122.424306405838) | ||
| 18004 | 18004 | 5790 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 573 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002988.46433 | 2108287.7672099997 | 37.769125358463995 | -122.43298388241301 | (37.769125358464, -122.432983882413) | |||
| 19442 | 19442 | 5816 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 949 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6000363.39173 | 2099612.7288599997 | 37.745156576909 | -122.441441255331 | (37.745156576909, -122.441441255331) | ||
| 127211 | 127211 | 5818 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 959 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000256.5254907 | 2099603.3351939 | 37.7451246954454 | -122.441810105191 | (37.7451246954454, -122.441810105191) | |||
| 14939 | 14939 | 6391 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | ||
| 102400 | 102400 | 6398 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977002 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | ||
| 17606 | 17606 | 6944 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 561 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6004740.44786 | 2110511.39404 | 37.7753301167361 | -122.42708227125601 | (37.7753301167361, -122.427082271256) | ||
| 5641 | 5641 | 7950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1735 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3X3 | 6005696.54994 | 2116082.67925 | 37.7906815134801 | -122.424171198144 | (37.7906815134801, -122.424171198144) | ||
| 5843 | 5843 | 8073 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 664 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004507.0606 | 2111574.6856 | 37.77823645397079 | -122.42796539753 | (37.7782364539708, -122.42796539753) | |||
| 5269 | 5269 | 8090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004349.2473 | 2111557.1689 | 37.7781794280627 | -122.428510082803 | (37.7781794280627, -122.428510082803) | ||
| 5536 | 5536 | 8091 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004317.1512 | 2111553.1108 | 37.7781664691559 | -122.42862082556499 | (37.7781664691559, -122.428620825565) | ||
| 4504 | 4504 | 8092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004291.3267 | 2111546.8391 | 37.778147787093 | -122.428709714706 | (37.778147787093, -122.428709714706) | ||
| 129364 | 129364 | 8097 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 762 Fulton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004143.8911021 | 2111521.3201229 | 37.7780693729621 | -122.42921792780001 | (37.7780693729621, -122.4292179278) | ||
| 5542 | 5542 | 8104 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 780 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004088.9733 | 2111516.0342 | 37.7780517500412 | -122.429407531137 | (37.7780517500412, -122.429407531137) | ||
| 7425 | 7425 | 8168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1160 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002214.9627 | 2111253.4218 | 37.7772244047313 | -122.435871600468 | (37.7772244047313, -122.435871600468) | |||
| 8873 | 8873 | 8201 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1360 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001243.6294 | 2111120.8056 | 37.7768050488635 | -122.439222237812 | (37.7768050488635, -122.439222237812) | |||
| 20164 | 20164 | 8289 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995199.8326 | 2099398.11528 | 37.7442717834334 | -122.459280291049 | (37.7442717834334, -122.459280291049) | |||
| 19524 | 19524 | 8290 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 5995181.45452 | 2099378.2291200003 | 37.7442161243666 | -122.45934239824899 | (37.7442161243666, -122.459342398249) | |||
| 111299 | 111299 | 8409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1570 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | ||
| 108584 | 108584 | 8437 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1720X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774582 | 6003236.76685 | 2113929.6842 | 37.7846307428776 | -122.432528061255 | (37.7846307428776, -122.432528061255) |
| 106414 | 106414 | 8449 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2016 05:20:00 AM | 3 | 3X3 | 6002863.14639 | 2113881.31105 | 37.7844767282199 | -122.433817202745 | (37.7844767282199, -122.433817202745) | ||
| 145655 | 145655 | 8486 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | ||
| 141683 | 141683 | 8518 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2099X Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | ||
| 102392 | 102392 | 8520 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | ||
| 94053 | 94053 | 8779 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3520 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996174.45541 | 2112935.09179 | 37.78149683844121 | -122.45688917879801 | (37.7814968384412, -122.456889178798) | |||
| 95889 | 95889 | 9346 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1999 12:00:00 AM | 20 | 2X2 | 6000803.9441694 | 2098478.3891844 | 37.742067037249 | -122.43983659070601 | (37.742067037249, -122.439836590706) | ||
| 19795 | 19795 | 9378 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001091.814301901 | 2097867.0769738997 | 37.740404899832896 | -122.438797433034 | (37.7404048998329, -122.438797433034) | |||
| 17743 | 17743 | 9991 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 43 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005443.377280001 | 2108628.68203 | 37.7702003684767 | -122.424516723968 | (37.7702003684767, -122.424516723968) | |||
| 19389 | 19389 | 9994 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | |||
| 18416 | 18416 | 10006 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 165 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1991 12:00:00 AM | 6 | 3X2 | 6005478.902319999 | 2108028.91066 | 37.76855554623621 | -122.42435117768999 | (37.7685555462362, -122.42435117769) | ||
| 122521 | 122521 | 10018 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 205 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1993 12:00:00 AM | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.767291517220706 | -122.42420766586201 | (37.7672915172207, -122.424207665862) | ||
| 127019 | 127019 | 10019 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 205 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.767291517220706 | -122.42420766586201 | (37.7672915172207, -122.424207665862) | |||
| 18298 | 18298 | 10022 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.766767762334794 | -122.42441947400499 | (37.7667677623348, -122.424419474005) | ||
| 20708 | 20708 | 10039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1991 12:00:00 AM | 20 | 3X3 | 6005477.1925800005 | 2106955.99773 | 37.765609486820004 | -122.424280773358 | (37.76560948682, -122.424280773358) | ||
| 21906 | 21906 | 10040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005476.568580001 | 2106925.6543400004 | 37.7655261358546 | -122.424280773346 | (37.7655261358546, -122.424280773346) | |||
| 10080 | 10080 | 10041 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 20 | 3X3 | 6005475.31081 | 2106892.46038 | 37.765434922114295 | -122.42428276264299 | (37.7654349221143, -122.424282762643) | ||
| 19778 | 19778 | 10042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005475.5325 | 2106875.27322 | 37.7653877427782 | -122.424280773365 | (37.7653877427782, -122.424280773365) | |||
| 143257 | 143257 | 10045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 375 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 6 | 2X2 | 6005552.9439989 | 2106809.2959801997 | 37.7652109557568 | -122.424008332395 | (37.7652109557568, -122.424008332395) | ||
| 21989 | 21989 | 10059 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6005579.31828 | 2106221.1938400003 | 37.763597655717504 | -122.42387528793002 | (37.7635976557175, -122.42387528793) | ||
| 21684 | 21684 | 10064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | ||
| 22175 | 22175 | 10077 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005621.78486 | 2105416.8204099997 | 37.761391433480895 | -122.423671214664 | (37.7613914334809, -122.423671214664) | |||
| 19892 | 19892 | 10082 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005631.678069999 | 2105272.5638099997 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | |||
| 18264 | 18264 | 10085 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 648 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1998 12:00:00 AM | 13 | 3x2 | 6005571.80442 | 2105186.7253099997 | 37.7607568250935 | -122.423827714701 | (37.7607568250935, -122.423827714701) | ||
| 102338 | 102338 | 10097 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 744 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6005593.39843 | 2104652.72108 | 37.759291793936896 | -122.423715061076 | (37.7592917939369, -122.423715061076) | |||
| 21103 | 21103 | 10099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | ||
| 20555 | 20555 | 10100 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/1995 12:00:00 AM | 40 | 2x2 | 6005607.26399 | 2104540.55602 | 37.758984597670896 | -122.423659132264 | (37.7589845976709, -122.423659132264) | ||
| 21660 | 21660 | 10102 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 2X2 | 6005674.239019999 | 2104513.09601 | 37.758912979273205 | -122.423425548652 | (37.7589129792732, -122.423425548652) | ||
| 17392 | 17392 | 10106 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 785 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005679.329609999 | 2104414.6071 | 37.7586428391006 | -122.42340094141399 | (37.7586428391006, -122.423400941414) | |||
| 17729 | 17729 | 10111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 817 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005691.67507 | 2104204.22323 | 37.758065870971706 | -122.423343289458 | (37.7580658709717, -122.423343289458) | |||
| 20450 | 20450 | 10113 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005696.52511 | 2104103.91625 | 37.757790725171 | -122.423319385483 | (37.757790725171, -122.423319385483) | |||
| 17273 | 17273 | 10114 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005696.25247 | 2104120.31934 | 37.7578357488369 | -122.423321494416 | (37.7578357488369, -122.423321494416) | |||
| 19264 | 19264 | 10115 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005698.17392 | 2104144.57278 | 37.75790245155879 | -122.42331657330901 | (37.7579024515588, -122.423316573309) | |||
| 19926 | 19926 | 10117 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 845 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005699.222580001 | 2104067.01691 | 37.757689560440795 | -122.42330743349301 | (37.7576895604408, -122.423307433493) | |||
| 81532 | 81532 | 10118 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 845 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/1990 12:00:00 AM | 3 | 3X3 | 6005704.2510557 | 2104056.9285895 | 37.7576621440613 | -122.423289325813 | (37.7576621440613, -122.423289325813) | ||
| 145891 | 145891 | 10119 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 850 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/06/1992 12:00:00 AM | 18 | 3X3 | 6005631.880167 | 2104012.3184419 | 37.757535570368 | -122.423536442741 | (37.757535570368, -122.423536442741) | ||
| 20712 | 20712 | 10140 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 906 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/1991 12:00:00 AM | 8 | 2x2 | 6005653.96599 | 2103626.9979 | 37.7564788166491 | -122.423432668582 | (37.7564788166491, -122.423432668582) | ||
| 17320 | 17320 | 10141 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 906 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005654.69613 | 2103615.0906 | 37.7564461631881 | -122.423429297021 | (37.7564461631881, -122.423429297021) | |||
| 19048 | 19048 | 10142 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005723.61297 | 2103645.6305400003 | 37.7565339082426 | -122.42319312877599 | (37.7565339082426, -122.423193128776) |
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");