Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145852 | 145852 | 95542 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 537 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767329 | 6002431.0 | 2099434.0 | 37.7447834031825 | -122.43427905661301 | (37.7447834031825, -122.434279056613) | |
145637 | 145637 | 86753 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1376 06th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52654 | 5994310.3 | 2106169.4 | 37.7628128189867 | -122.462847225894 | (37.7628128189867, -122.462847225894) | |||
144754 | 144754 | 94431 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
144722 | 144722 | 110814 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
144532 | 144532 | 56773 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1590X McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53948 | 6015510.638170599 | 2096034.20336208 | 37.736181973612 | -122.38881445867901 | (37.736181973612, -122.388814458679) | |
144497 | 144497 | 101644 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 49 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769556 | 6002658.0 | 2105616.0 | 37.761770587011 | -122.433935935928 | (37.761770587011, -122.433935935928) | |
144445 | 144445 | 49143 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3650 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52395 | 6005965.19234765 | 2104357.23330269 | 37.758501434026606 | -122.422408220084 | (37.7585014340266, -122.422408220084) | ||
144338 | 144338 | 78046 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4278 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2010 12:00:00 AM | 3x3 | Permit Number 53968 | 6002070.11098959 | 2101218.55986767 | 37.749662892833 | -122.435654588507 | (37.749662892833, -122.435654588507) | ||
144021 | 144021 | 66648 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 952 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29859 | 6009925.98754531 | 2103657.07059122 | 37.7568015810734 | -122.40866056162399 | (37.7568015810734, -122.408660561624) | ||
143480 | 143480 | 117482 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
143468 | 143468 | 94171 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 900 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53525 | 5990680.0 | 2101127.0 | 37.7487579569011 | -122.475034924429 | (37.7487579569011, -122.475034924429) | ||
143239 | 143239 | 47980 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2558 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45714 | 5992088.46801551 | 2098030.76622139 | 37.7403380187937 | -122.46993908856399 | (37.7403380187937, -122.469939088564) | ||
142655 | 142655 | 94771 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
142491 | 142491 | 82800 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1942 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53540 | 5990674.38979657 | 2102169.39971398 | 37.751619788601296 | -122.47513041081899 | (37.7516197886013, -122.475130410819) | ||
142434 | 142434 | 108527 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1685 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773678 | 5990568.02917 | 2103933.50348 | 37.7564573872125 | -122.47562701791 | (37.7564573872125, -122.47562701791) |
142271 | 142271 | 94772 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
142173 | 142173 | 94170 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 900 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53525 | 5990680.0 | 2101127.0 | 37.7487579569011 | -122.475034924429 | (37.7487579569011, -122.475034924429) | ||
141997 | 141997 | 83322 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1630 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53558 | 5992802.78725609 | 2104361.64977018 | 37.757762266381 | -122.467929643141 | (37.757762266381, -122.467929643141) | ||
141930 | 141930 | 31078 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90X Elgin Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 4 | 3x3 | Permit Number 34817 | 6005829.36591877 | 2108508.00080397 | 37.769890796995 | -122.42317301085698 | (37.769890796995, -122.423173010857) | |
141209 | 141209 | 94781 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
141153 | 141153 | 50880 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2035 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2004 12:00:00 AM | Permit Number 47390 | 5991589.50004972 | 2101572.19756465 | 37.7500330221911 | -122.47192235120501 | (37.7500330221911, -122.471922351205) | |||
140623 | 140623 | 117481 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
140573 | 140573 | 94768 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
140251 | 140251 | 83377 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 390 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50471 | 6004079.008179099 | 2096201.47422294 | 37.7360010286865 | -122.42835020948999 | (37.7360010286865, -122.42835020949) | ||
139916 | 139916 | 55046 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3775 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1972 12:00:00 AM | 3x3 | Permit Number 53754 | 6003208.53256552 | 2103569.18124739 | 37.7561817396096 | -122.43188570928899 | (37.7561817396096, -122.431885709289) | |
139839 | 139839 | 87808 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3388 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50586 | 6005908.6 | 2098553.3 | 37.7425619734414 | -122.422191602046 | (37.7425619734414, -122.422191602046) | ||
139778 | 139778 | 108879 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301X JESSIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
139739 | 139739 | 95561 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 835 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767355 | 6001294.0 | 2101527.0 | 37.7504656822521 | -122.43836049802401 | (37.7504656822521, -122.438360498024) | |
139654 | 139654 | 116183 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1751 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013485.0 | 2092424.0 | 37.72615661412179 | -122.395565112125 | (37.7261566141218, -122.395565112125) | |||
139461 | 139461 | 33063 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 82-98X Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47189 | 6013414.11525102 | 2106644.78468583 | 37.7651999335347 | -122.3968066986 | (37.7651999335347, -122.3968066986) | ||
139437 | 139437 | 34294 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2868 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2013 12:00:00 AM | Permit Number 769996 | 6010202.37211243 | 2101668.36098933 | 37.7513565026505 | -122.407564507802 | (37.7513565026505, -122.407564507802) | |||
139412 | 139412 | 82676 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1621 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52504 | 6014985.81451712 | 2094439.95411177 | 37.7317753861847 | -122.390517640406 | (37.7317753861847, -122.390517640406) | ||
139398 | 139398 | 108932 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 418 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772806 | 6007857.4 | 2096898.0 | 37.738126614046294 | -122.415336047656 | (37.7381266140463, -122.415336047656) |
139317 | 139317 | 111997 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 69 Divisadero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | 6x3 | Permit Number 775676 | 6001902.9 | 2108046.4 | 37.7684009894266 | -122.436721500778 | (37.7684009894266, -122.436721500778) | ||
138837 | 138837 | 102996 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 533 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2013 12:00:00 AM | 3x3 | Permit Number 770096 | 6002456.0 | 2099436.0 | 37.7447903136679 | -122.434192754421 | (37.7447903136679, -122.434192754421) | ||
138469 | 138469 | 44787 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43883 | 6010080.44912755 | 2105396.9401007 | 37.7615875207802 | -122.40824908368799 | (37.7615875207802, -122.408249083688) | ||
138389 | 138389 | 117211 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | ||
138294 | 138294 | 107376 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2828X 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2014 12:00:00 AM | 3X3 | Permit Number 773434 | 6009529.0 | 2105470.0 | 37.761757232521504 | -122.410161487216 | (37.7617572325215, -122.410161487216) | ||
129346 | 129346 | 110822 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
129151 | 129151 | 108927 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1612 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773055 | 6010381.6 | 2100196.5 | 37.7473251266072 | -122.406840990737 | (37.7473251266072, -122.406840990737) |
129057 | 129057 | 101170 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 420 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769436 | 6002934.0 | 2105795.0 | 37.7622777366985 | -122.432994152167 | (37.7622777366985, -122.432994152167) | |||
128954 | 128954 | 108884 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
128850 | 128850 | 36738 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006056.66890888 | 2108134.46852817 | 37.768877991321204 | -122.42236022963199 | (37.7688779913212, -122.422360229632) | ||
128836 | 128836 | 50699 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 315 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2004 12:00:00 AM | 12 | 6x8 | Permit Number 47261 | 6006595.62338541 | 2097346.13779241 | 37.7392861034365 | -122.419730437543 | (37.7392861034365, -122.419730437543) | |
128499 | 128499 | 96724 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1357 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2011 12:00:00 AM | Permit Number 767997 | 6009298.0 | 2101259.0 | 37.750181824318204 | -122.410663037771 | (37.7501818243182, -122.410663037771) | ||||
128489 | 128489 | 54080 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 412 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2011 12:00:00 AM | 3x3 | Permit Number 768002 | 6002927.97599078 | 2105840.12301402 | 37.7624012918991 | -122.433018210909 | (37.7624012918991, -122.433018210909) | ||
128487 | 128487 | 94424 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
128476 | 128476 | 100894 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1400 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008828.0 | 2109520.0 | 37.7728382767515 | -122.412872323828 | (37.7728382767515, -122.412872323828) | |||
128428 | 128428 | 95139 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 217 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3x3 | Permit Number 54073 | 6000763.0 | 2106514.0 | 37.764128551802 | -122.440554377209 | (37.764128551802, -122.440554377209) | ||
128042 | 128042 | 117483 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
127989 | 127989 | 94576 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3775 21st St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53754 | 6003162.0 | 2103575.0 | 37.7561950785204 | -122.43204705011699 | (37.7561950785204, -122.432047050117) | ||
127476 | 127476 | 98989 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1491 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11313 | 5993631.9 | 2105378.7 | 37.7606026656916 | -122.46513612094601 | (37.7606026656916, -122.465136120946) | |||
127042 | 127042 | 100193 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
126968 | 126968 | 107377 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2828X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2014 12:00:00 AM | 3X3 | Permit Number 773434 | 6009529.0 | 2105470.0 | 37.761757232521504 | -122.410161487216 | (37.7617572325215, -122.410161487216) | ||
126566 | 126566 | 108882 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
126101 | 126101 | 83665 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 40 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769772 | 6002625.0 | 2105668.0 | 37.761911493648 | -122.434053786903 | (37.761911493648, -122.434053786903) |
125600 | 125600 | 99742 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 511 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001875.0 | 2100872.0 | 37.7487002375378 | -122.436304489265 | (37.7487002375378, -122.436304489265) | ||||
125446 | 125446 | 102046 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2853 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 1x1 | Permit Number 769645 | 5999908.6 | 2117385.9 | 37.7939313129836 | -122.444290820426 | (37.7939313129836, -122.444290820426) | ||
125016 | 125016 | 55962 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 231-235 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2013 12:00:00 AM | Permit Number 769518 | 6006188.56935661 | 2101819.0911912 | 37.7515448810816 | -122.421455427946 | (37.7515448810816, -122.421455427946) | |||
124891 | 124891 | 95396 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 913 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767270 | 6003139.0 | 2102931.0 | 37.7544255036425 | -122.432080605043 | (37.7544255036425, -122.432080605043) | |
123998 | 123998 | 102756 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2807 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002069.0 | 2117756.0 | 37.7950705311236 | -122.436842144361 | (37.7950705311236, -122.436842144361) | |||
123913 | 123913 | 117212 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | |||
123569 | 123569 | 108880 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301X JESSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
123565 | 123565 | 47958 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 300 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45688 | 5997800.77741149 | 2096297.42452827 | 37.7359072289386 | -122.450063383576 | (37.7359072289386, -122.450063383576) | ||
123555 | 123555 | 110806 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
123515 | 123515 | 87766 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3896 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50469 | 6002488.0 | 2102987.0 | 37.7545423364482 | -122.434335932006 | (37.7545423364482, -122.434335932006) | |||
123511 | 123511 | 110811 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
123199 | 123199 | 102228 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 621 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2013 12:00:00 AM | 10 | 2x2 | Permit Number 769631 | 6002457.0 | 2100031.0 | 37.746424100900995 | -122.43423182524401 | (37.746424100901, -122.434231825244) | |
122900 | 122900 | 92428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1606 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52819 | 5983797.4 | 2104193.9 | 37.7567775277693 | -122.499061114391 | (37.7567775277693, -122.499061114391) | |
122838 | 122838 | 57178 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 219 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3x3 | Permit Number 54073 | 6000772.77457474 | 2106496.84625241 | 37.764082008440596 | -122.440519339477 | (37.7640820084406, -122.440519339477) | ||
122427 | 122427 | 93005 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006066.0 | 2108133.0 | 37.7688744854504 | -122.42232784963001 | (37.7688744854504, -122.42232784963) | ||
122382 | 122382 | 50282 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4128 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46986 | 6002310.55809201 | 2102400.96619241 | 37.7529231541309 | -122.434907664242 | (37.7529231541309, -122.434907664242) | ||
122343 | 122343 | 107375 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2828X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2014 12:00:00 AM | 3X3 | Permit Number 773434 | 6009529.0 | 2105470.0 | 37.761757232521504 | -122.410161487216 | (37.7617572325215, -122.410161487216) | ||
122076 | 122076 | 115803 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 23 WOODWARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006525.0 | 2108358.0 | 37.7695181628378 | -122.420756172845 | (37.7695181628378, -122.420756172845) | ||||
121867 | 121867 | 105125 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1520 WILLARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x4 | Permit Number 771187 | 5996927.9 | 2105971.4 | 37.7624195807215 | -122.453779617781 | (37.7624195807215, -122.453779617781) | ||
121490 | 121490 | 99723 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
120978 | 120978 | 92218 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2631 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52649 | 6010040.0 | 2105013.0 | 37.7605310430481 | -122.40836189943998 | (37.7605310430481, -122.40836189944) | ||
120922 | 120922 | 108531 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 60 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773683 | 5991872.4302900005 | 2105034.56834 | 37.7595561547996 | -122.47119619773599 | (37.7595561547996, -122.471196197736) |
120903 | 120903 | 108881 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
120776 | 120776 | 99721 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
120763 | 120763 | 117479 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
120652 | 120652 | 52398 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 28@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48519 | 6005791.37113066 | 2097745.41692411 | 37.7403370957557 | -122.422539551549 | (37.7403370957557, -122.422539551549) | ||
120201 | 120201 | 100430 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
119810 | 119810 | 94428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
119718 | 119718 | 94425 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
119532 | 119532 | 61149 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 639 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2013 12:00:00 AM | Permit Number 770286 | 6009856.18087269 | 2105304.12445974 | 37.761320109502705 | -122.40901819024499 | (37.7613201095027, -122.409018190245) | |||
119473 | 119473 | 94422 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
119160 | 119160 | 87771 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 173 Laidley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50476 | 6004033.0 | 2097383.0 | 37.7392426262863 | -122.42859347367599 | (37.7392426262863, -122.428593473676) | |||
118692 | 118692 | 60397 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1445 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52466 | 6016065.49318693 | 2093986.4863783 | 37.730590090931294 | -122.38675332477 | (37.7305900909313, -122.38675332477) | ||
118555 | 118555 | 36736 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006056.66890888 | 2108134.46852817 | 37.768877991321204 | -122.42236022963199 | (37.7688779913212, -122.422360229632) | ||
118357 | 118357 | 50425 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 26 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47078 | 5996739.2697017 | 2091227.18329804 | 37.7219247572556 | -122.45336747188999 | (37.7219247572556, -122.45336747189) | ||
117929 | 117929 | 99932 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 277 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2012 12:00:00 AM | 3x3 | Permit Number 768952 | 6006756.8 | 2104530.9 | 37.7590229060886 | -122.41968280256701 | (37.7590229060886, -122.419682802567) | ||
117790 | 117790 | 110813 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
117694 | 117694 | 106552 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 207 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 3X3 | Permit Number 768265 | 5998005.6 | 2096224.8 | 37.7357195377121 | -122.44935000292601 | (37.7357195377121, -122.449350002926) | |||
117679 | 117679 | 117480 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
117301 | 117301 | 72691 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 143 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/01/2011 12:00:00 AM | Permit Number 768196 | 5996238.58765499 | 2094412.40177524 | 37.7306418958229 | -122.455328273496 | (37.7306418958229, -122.455328273496) | |||
116374 | 116374 | 95641 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4444 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767410 | 6001257.0 | 2105261.0 | 37.7607162386451 | -122.438755985042 | (37.7607162386451, -122.438755985042) | |
116301 | 116301 | 102103 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 705X Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2012 12:00:00 AM | 3x3 | Permit Number 769483 | 6009386.0 | 2110546.0 | 37.775686737909496 | -122.411014612047 | (37.7756867379095, -122.411014612047) | ||
115740 | 115740 | 64676 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3652 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52395 | 6005952.88192889 | 2104356.55028011 | 37.7584988641554 | -122.422450746558 | (37.7584988641554, -122.422450746558) | ||
115349 | 115349 | 100186 | DPW Maintained 3 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2445 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6008897.0 | 2104213.0 | 37.758270352242796 | -122.41225848424999 | (37.7582703522428, -122.41225848425) |
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");