trees
4,014 rows where qSpecies_id = 40 sorted by DBH
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );