4,014 rows where qSpecies_id = 40 sorted by DBH

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
1895 73501 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.7492053706113 -122.436016109621 (37.7492053706113, -122.436016109621) 2 4 5 28862 22
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
2670 262494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2989 261184 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006769 2095411 37.733982408401 -122.41899375969 (37.733982408401, -122.41899375969) 2 7 7 28859 2
3267 50930 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2287 Cecelia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47426 5991460.4982554 2099833.27531374 37.7452509262864 -122.472241698597 (37.7452509262864, -122.472241698597) 1 8 4 29491 40
3776 261180 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2095420 37.7340017140914 -122.419326300122 (37.7340017140914, -122.419326300122) 2 7 7 28859 2
3941 92078 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1151 Sutter St   Sidewalk: Curb side : Cutout Tree Private 2   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083 2115004 37.7877979108835 -122.419297592258 (37.7877979108835, -122.419297592258) 13 9 10 28858 21
4116 262380 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008843.96123 2117672.51917 37.7952240323069 -122.413393767718 (37.7952240323069, -122.413393767718) 5 1 10 308 21
6337 55153 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3933 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2009 12:00:00 AM   3x3 Permit Number 52132 6003602.67369464 2101839.43403285 37.7514545976895 -122.430399225072 (37.7514545976895, -122.430399225072) 2 4 5 28862 22
6608 47030 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
7565 121637 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 298x Otsego Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000311 2091736 37.7235259352509 -122.441057424661 (37.7235259352509, -122.441057424661) 9 7 6 28861 25
8641 41286 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 494 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52403 6005499.65147882 2107857.73967205 37.7680867232876 -122.424267232407 (37.7680867232876, -122.424267232407) 8 4 5 28853 19
8800 53644 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4051 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM   3x3 Permit Number 52604 6002653.10802153 2105292.31520624 37.7608815491861 -122.433929717717 (37.7608815491861, -122.433929717717) 2 4 5 28862 3
9283 94134 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 18 Nebraska St   Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53498 6009291 2097948 37.7410901551317 -122.410453476975 (37.7410901551317, -122.410453476975) 10 7 7 28859 2
9573 108831 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 774658 6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
9716 91569 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 301 Girard St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2009 12:00:00 AM   3x3 Permit Number 52142 6010768 2093361 37.7285779166605 -122.405023621917 (37.7285779166605, -122.405023621917) 10 3 7 309 28
10348 91136 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 480 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2009 12:00:00 AM   3x3 Permit Number 52024 6005604 2107874.4 37.7681383601012 -122.423907486341 (37.7681383601012, -122.423907486341) 8 4 5 28853 19
10377 91396 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2009 12:00:00 AM   3x3 Permit Number 52091 5996731.3 2091236.4 37.7219496073249 -122.453395686079 (37.7219496073249, -122.453395686079) 9 8 4 28861 24
10881 50928 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2261 Cecelia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47425 5991475.24491559 2099916.59093812 37.7454805429508 -122.472196779655 (37.7454805429508, -122.472196779655) 1 8 4 29491 40
12131 253666 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 578 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868) 11 6 2 54 11
14218 92323 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2595 27th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.7390868384366 -122.484151218827 (37.7390868384366, -122.484151218827) 1 8 3 29491 35
14565 99798 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 723-725 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001735 2102034 37.7518828570558 -122.436871780919 (37.7518828570558, -122.436871780919) 2 4 5 28862 22
14747 260897 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Colin P Kelly Jr St 10 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6015356.8087 2112701.67439 37.7819387497011 -122.390510590187 (37.7819387497011, -122.390510590187) 6 2 9 28856 6
14998 101958 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200X Ripley St 1 Sidewalk: Property side : Cutout Tree Private 2   06/12/2013 12:00:00 AM   3x3 Permit Number 770180 6009339 2099105 37.744269714821 -122.410369184032 (37.744269714821, -122.410369184032) 2 7 7 28859 2
15257 258903 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1 Massasoit St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010100 2099291 37.7448230609493 -122.407750909418 (37.7448230609493, -122.407750909418) 2 7 7 28859 2
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
16267 261182 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 360 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006757 2095391 37.733926817061 -122.41903382937 (37.733926817061, -122.41903382937) 2 7 7 28859 2
16351 92032 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4232 21st St   Sidewalk: Curb side : Cutout Tree Private 2   06/12/2009 12:00:00 AM   3x3 Permit Number 52175 6001386.1 2103403.9 37.75562443672 -122.43817644846 (37.75562443672, -122.43817644846) 2 4 5 28862 3
16667 261183 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 360 Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006757 2095391 37.733926817061 -122.41903382937 (37.733926817061, -122.41903382937) 2 7 7 28859 2
16894 51883 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 209 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48099 6006849.08815448 2097918.82782797 37.740872857816 -122.418894673949 (37.740872857816, -122.418894673949) 2 7 7 28859 2
17096 95570 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 564 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767361 6001501 2101469 37.7503181999041 -122.437640524789 (37.7503181999041, -122.437640524789) 2 4 5 28862 22
17260 57706 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 268 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2009 12:00:00 AM   3x3 Permit Number 52597 6003986.30319774 2108724.10323801 37.7703799791966 -122.429563538214 (37.7703799791966, -122.429563538214) 7 9 11 29492 10
17312 261181 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2095420 37.7340017140914 -122.419326300122 (37.7340017140914, -122.419326300122) 2 7 7 28859 2
17422 260898 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Colin P Kelly Jr St 11 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6015356.8087 2112701.67439 37.7819387497011 -122.390510590187 (37.7819387497011, -122.390510590187) 6 2 9 28856 6
17599 60775 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 709 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53493 6001812.90268629 2102029.53608066 37.7518750275232 -122.436602063487 (37.7518750275232, -122.436602063487) 2 4 5 28862 22
18326 97050 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1841 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/2011 12:00:00 AM   4x4 Permit Number 768113 5989656.1 2102823.3 37.7533561549786 -122.478699565369 (37.7533561549786, -122.478699565369) 1 8 3 56 35
18504 96157 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 539 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767790 6006264.3 2096224.2 37.7361868423382 -122.420796378515 (37.7361868423382, -122.420796378515) 2 7 7 28859 2
19755 40666 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Maynard St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767516 6004070.62612566 2093782.39936272 37.7293583191123 -122.428206841061 (37.7293583191123, -122.428206841061) 9 7 6 28861 5
19764 82642 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2902 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52206 6010042.71011314 2101659.66288347 37.7513236811165 -122.408116026593 (37.7513236811165, -122.408116026593) 2 4 7 28859 19
19833 92520 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 243 Holly Park Cir 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52872 6006893.7 2096608.3 37.7372769513992 -122.418647509778 (37.7372769513992, -122.418647509778) 2 7 7 28859 2
19874 84078 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 651 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53502 6009810.41708937 2098392.72899134 37.7423403893422 -122.408688879288 (37.7423403893422, -122.408688879288) 10 7 7 28859 2
20213 49303 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 301-329X Santa Rosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46312 6000618.30444023 2093710.90436804 37.7289660686913 -122.440136680877 (37.7289660686913, -122.440136680877) 9 7 6 28861 25
20710 95694 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767442 5997236 2108822 37.7702642586668 -122.452919787946 (37.7702642586668, -122.452919787946) 15 5 11 29492 9
21200 93748 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 455 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2010 12:00:00 AM   3x3 Permit Number 53324 6003563 2100087 37.7466405761834 -122.43041139941 (37.7466405761834, -122.43041139941) 2 7 5 63 22
22165 108189 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 490X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013735.53307 2112587.71036 37.7815357570631 -122.396111508062 (37.7815357570631, -122.396111508062) 6 2 9 28856 6
22245 94798 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495@Ulloa 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM     Permit Number 767295 5989187.3 2098380.9 37.741131264018 -122.479995678002 (37.741131264018, -122.479995678002) 1 8 3 29491 35
22763 95579 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3874 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767367 6003977 2101906 37.7516585690455 -122.429109505532 (37.7516585690455, -122.429109505532) 2 4 5 28862 22
22955 40530 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 130 San Aleso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45382 5993353.73347688 2094704.41991722 37.7312777588569 -122.46532277559 (37.7312777588569, -122.46532277559) 9 8 4 59 40
23125 95991 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 741 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM   3x3 Permit Number 767643 5986614.1 2110873.8 37.7752834997455 -122.489811316179 (37.7752834997455, -122.489811316179) 11 6 2 55 26
23477 94834 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1256 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53912 5993662.6 2106952.2 37.7649248555896 -122.465144234508 (37.7649248555896, -122.465144234508) 11 8 11 56 12
23777 88528 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 771 14th St   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51478 6003493 2107743 37.7676581652647 -122.431199833454 (37.7676581652647, -122.431199833454) 15 9 5 28862 3
24127 46734 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 315 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/2002 12:00:00 AM     Permit Number 44844 5993734.25176167 2089288.64398892 37.7164292900251 -122.463614355193 (37.7164292900251, -122.463614355193) 9 8 6 64 24
25013 93220 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1675 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2010 12:00:00 AM   3x3 Permit Number 53212 6004290 2108739 37.7704380729677 -122.42851411253 (37.7704380729677, -122.42851411253) 7 9 5 29492 10
25135 99865 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2012 12:00:00 AM   3x3 Permit Number 768884 5986943.1 2112080 37.7786145879683 -122.488761926719 (37.7786145879683, -122.488761926719) 11 6 2 55 26
25179 105960 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1937 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2014 12:00:00 AM   3x3 Permit Number 772672 5989989.1 2102175.5 37.7515967965888 -122.477500650678 (37.7515967965888, -122.477500650678) 1 8 3 29491 35
25691 68751 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3995 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM   3x3 Permit Number 52617 6003060.85993218 2104730.20209392 37.7593612527154 -122.432479334541 (37.7593612527154, -122.432479334541) 2 4 5 28862 3
25801 33423 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 163 Westgate Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/01/2015 12:00:00 AM     Permit Number 774515 5993446.55612201 2094023.66864414 37.7294139362366 -122.464952451879 (37.7294139362366, -122.464952451879) 9 8 4 59 40
26554 62872 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 184 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1986 12:00:00 AM     Permit Number 768360 6008262.44852126 2097761.23005493 37.7405196112884 -122.413996637761 (37.7405196112884, -122.413996637761) 2 7 7 28859 2
26800 93720 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2329 Cecelia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2010 12:00:00 AM   3x3 Permit Number 53311 5991400.2 2099543.1 37.7444506897731 -122.472429047351 (37.7444506897731, -122.472429047351) 1 8 4 29491 40
27189 82702 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 863 Meade Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52463 6013030.57044013 2089280.70970627 37.7175004844817 -122.396915777424 (37.7175004844817, -122.396915777424) 10 3 8 58 1
27760 80277 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1968 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53550 5992884.37444854 2102265.05022371 37.7520102585728 -122.467495021948 (37.7520102585728, -122.467495021948) 1 8 4 29491 12
28058 114800 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1587 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2015 12:00:00 AM     Permit Number 770932 5990525.1 2104605.1 37.7582989241527 -122.475824523864 (37.7582989241527, -122.475824523864) 1 8 4 56 12
28106 87131 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 De Montfort Ave   Sidewalk: Curb side : Cutout Tree Private 2   01/11/2008 12:00:00 AM   3x3 Permit Number 50083 5995245.2 2091924 37.7237522965749 -122.458582475556 (37.7237522965749, -122.458582475556) 9 8 4 28861 24
29041 92309 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 25th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52753 5988779.9 2097863.1 37.7396858417248 -122.481366393427 (37.7396858417248, -122.481366393427) 1 8 3 29491 35
29227 50891 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2262 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47401 5991327.25038556 2100016.48416047 37.7457462581236 -122.472715798528 (37.7457462581236, -122.472715798528) 1 8 4 29491 40
29290 46791 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 85 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM     Permit Number 44882 5994768.24159511 2095318.09377142 37.733044230994 -122.460477049077 (37.733044230994, -122.460477049077) 9 8 4 59 40
29338 95937 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 730 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM   3x3 Permit Number 767633 5987294.2 2110946.4 37.7755225253955 -122.487464059213 (37.7755225253955, -122.487464059213) 11 6 2 55 26
29686 114760 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2849 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM     Permit Number 777140 6009026.4 2101883.5 37.7518813304133 -122.41164636992 (37.7518813304133, -122.41164636992) 2 4 7 28859 19
29781 68081 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 201 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54056 6001211.28738215 2093268.78253612 37.7277858449169 -122.438055042052 (37.7277858449169, -122.438055042052) 9 7 6 28861 25
29809 47252 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1001 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   3x3 Permit Number 767654 6013117.42744406 2089558.25653077 37.718267407089 -122.396634995972 (37.718267407089, -122.396634995972) 10 3 8 58 1
29810 51964 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 624 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/2005 12:00:00 AM     Permit Number 48186 6004986.46742486 2111098.21623731 37.7769552960255 -122.426273020817 (37.7769552960255, -122.426273020817) 7 9 11 28852 10
30026 36031 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1660X BRYANT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1998 12:00:00 AM   3x3 Permit Number 39178 6009346 2106886 37.7656349852358 -122.410894426294 (37.7656349852358, -122.410894426294) 8 4 7 28853 19
30236 94788 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2461 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/2010 12:00:00 AM   3x3 Permit Number 53886 6008244 2104101 37.757926162272 -122.414508925782 (37.757926162272, -122.414508925782) 2 4 7 28859 19
30305 115302 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 333 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2016 12:00:00 AM     Permit Number 775906 5992046.2 2097184.7 37.738012491984 -122.470023644047 (37.738012491984, -122.470023644047) 1 8 4 59 40
30334 52177 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1X Albion St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2005 12:00:00 AM     Permit Number 48366 6005910.85537193 2107243.06588365 37.766422185477 -122.422801230733 (37.766422185477, -122.422801230733) 8 4 5 28853 19
30472 100032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
30963 51859 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2701 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1982 12:00:00 AM     Permit Number 48081 6008321.98610065 2102690.0223994 37.7540563193351 -122.414139393949 (37.7540563193351, -122.414139393949) 2 4 7 28859 19
31193 68713 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3851 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2007 12:00:00 AM   3x3 Permit Number 49736 6003257.9110422 2105909.73709682 37.7626111445272 -122.431882059419 (37.7626111445272, -122.431882059419) 15 4 5 28862 3
31454 47161 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200 San Fernando Way 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2002 12:00:00 AM     Permit Number 45129 5992116.68521556 2095408.98560737 37.7331409014555 -122.469650709796 (37.7331409014555, -122.469650709796) 9 8 4 59 40
31532 47313 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1420 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/2002 12:00:00 AM     Permit Number 45244 6010384.18455371 2100995.83638931 37.7495200736312 -122.406888381765 (37.7495200736312, -122.406888381765) 2 4 7 28859 19
31944 94585 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2725 Greenwich St   Sidewalk: Curb side : Cutout Tree Private 2   09/29/2010 12:00:00 AM   3x3 Permit Number 53761 5999865 2118793 37.7977923490456 -122.444542858 (37.7977923490456, -122.444542858) 13 9 1 57 17
32057 108634 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Lake St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787) 11 6 1 55 33
33621 105147 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Mirabel Ave   Sidewalk: Curb side : Cutout Landscaping Private 2   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.416220575031 (37.7464458666696, -122.416220575031) 2 7 7 28859 2
34019 99712 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Paloma Ave 5 Sidewalk: Property side : Yard Tree Private 2           5992094.2 2093835.6 37.7288194775612 -122.469613947177 (37.7288194775612, -122.469613947177) 9 8 4 59 40
34021 92324 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2595 27th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.7390868384366 -122.484151218827 (37.7390868384366, -122.484151218827) 1 8 3 29491 35
34371 51464 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 187 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47778 6008133.81898598 2097762.9616442 37.7405171406151 -122.414441512607 (37.7405171406151, -122.414441512607) 2 7 7 28859 2
34649 98361 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 729 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2012 12:00:00 AM   2x3 Permit Number 768618 5994749.5 2089887.4 37.7181317785027 -122.460148537137 (37.7181317785027, -122.460148537137) 9 8 6 28861 24
34779 104448 Private 9 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2490X Folsom St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
34787 121397 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4098x 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002425 2104765 37.7594207214866 -122.434680934086 (37.7594207214866, -122.434680934086) 2 4 5 28862 3
34795 94655 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 540 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53794 6003382 2095642 37.7344253745893 -122.430720133335 (37.7344253745893, -122.430720133335) 2 7 5 63 7
34986 113307 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 COLONIAL WAY 1 Sidewalk: Curb side : Cutout Tree Private 2       3x2   6000472 2093592 37.7286312543271 -122.440633939625 (37.7286312543271, -122.440633939625) 9 7 6 28861 25
35023 47932 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 428 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/2002 12:00:00 AM     Permit Number 45997 6000124.48691005 2095037.23587713 37.7325797406911 -122.441938998864 (37.7325797406911, -122.441938998864) 9 7 5 63 40
35532 99775 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800x Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 4205 24th St corner property 6001819.1 2101713.8 37.7510084437682 -122.436558035286 (37.7510084437682, -122.436558035286) 2 4 5 28862 22
36583 47700 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45497 6003509.82655426 2097791.42406059 37.7403344433628 -122.430431505695 (37.7403344433628, -122.430431505695) 2 7 5 63 7
36730 88755 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 990 Polk St 12 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
36861 121590 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1633 Diamond St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002085 2099267 37.7443052155581 -122.435463512838 (37.7443052155581, -122.435463512838) 2 7 5 63 22
36914 35999 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 64 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/2009 12:00:00 AM   3x3 Permit Number 52570 6007704.91330377 2099967.11209055 37.7465451430817 -122.416080564044 (37.7465451430817, -122.416080564044) 2 7 7 28859 2
38067 121684 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 208 Joost Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000684 2094988 37.7324764179648 -122.440001102333 (37.7324764179648, -122.440001102333) 9 7 5 63 40
38586 73075 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 212-214 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2010 12:00:00 AM   3x3 Permit Number 53964 6005141.46475823 2099927.4876788 37.7462918791242 -122.424941880524 (37.7462918791242, -122.424941880524) 2 7 5 63 22
38750 48567 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 482 Orizaba Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/2002 12:00:00 AM     Permit Number 45986 5994053.29361641 2089800.73897296 37.7178537586229 -122.462548722634 (37.7178537586229, -122.462548722634) 9 8 6 28861 24

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);