trees
4,014 rows where qSpecies_id = 40 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
136751 | 250881 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 154 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986823.25063 | 2114733.91146 | 37.7858944753023 | -122.489371714655 | (37.7858944753023, -122.489371714655) | 11 | 6 | 1 | 55 | 33 | |||
152903 | 250902 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 266 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5986843.33005 | 2114156.49339 | 37.7843102232907 | -122.489259776936 | (37.7843102232907, -122.489259776936) | 11 | 6 | 1 | 55 | 33 | |||
176438 | 119948 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 318 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5986856.97433 | 2113783.13757 | 37.7832858916453 | -122.489185114233 | (37.7832858916453, -122.489185114233) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
74983 | 67962 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 859 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 3 | Permit Number 31683 | 5986944.37754 | 2110090.62613 | 37.7731524036412 | -122.488611249777 | (37.7731524036412, -122.488611249777) | 11 | 6 | 2 | 55 | 26 | |
65484 | 92493 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1942 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52863 | 5986947 | 2097598 | 37.7388512102115 | -122.487684224147 | (37.7388512102115, -122.487684224147) | 1 | 8 | 3 | 29491 | 35 | |
140591 | 45544 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 79 Riverton Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44297 | 5987024.26021 | 2095319.08797 | 37.7325984222842 | -122.487249757963 | (37.7325984222842, -122.487249757963) | 1 | 8 | 4 | 64 | 35 | |
22657 | 250934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 259 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987104.95893 | 2114216.89652 | 37.7844913413477 | -122.488359085227 | (37.7844913413477, -122.488359085227) | 11 | 6 | 1 | 55 | 33 | |||
143517 | 51052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 326 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | 10 | Permit Number 47522 | 5987167.50591 | 2113744.97071 | 37.7831992171669 | -122.488108007262 | (37.7831992171669, -122.488108007262) | 11 | 6 | 2 | 55 | 26 | ||
137360 | 50876 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 322 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | 7 | Permit Number 47534 | 5987167.73714 | 2113766.40078 | 37.7832580715076 | -122.488108782534 | (37.7832580715076, -122.488108782534) | 11 | 6 | 2 | 55 | 26 | ||
105048 | 119955 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 330 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987168.01965 | 2113716.37962 | 37.7831207441699 | -122.48810412836 | (37.7831207441699, -122.48810412836) | 11 | 6 | 2 | 55 | 26 | |||
83767 | 119956 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 330 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5987168.10276 | 2113699.18526 | 37.7830735382158 | -122.488102576965 | (37.7830735382158, -122.488102576965) | 11 | 6 | 2 | 55 | 26 | |||
76841 | 96900 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 334 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987168.76751 | 2113688.04029 | 37.7830429760908 | -122.488099458022 | (37.7830429760908, -122.488099458022) | 11 | 6 | 2 | 55 | 26 | |
146527 | 96898 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 334 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987169.6042 | 2113664.32132 | 37.7829778993822 | -122.48809482 | (37.7829778993822, -122.48809482) | 11 | 6 | 2 | 55 | 26 | |
57491 | 96899 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 334 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987170.52326 | 2113675.9123 | 37.78300977852 | -122.488092492463 | (37.78300977852, -122.488092492463) | 11 | 6 | 2 | 55 | 26 | |
181333 | 119957 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 346 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5987171.5706 | 2113609.12864 | 37.7828264707534 | -122.488083960264 | (37.7828264707534, -122.488083960264) | 11 | 6 | 2 | 55 | 26 | |||
22020 | 95934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 674 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767631 | 5987254.50705 | 2111348.98787 | 37.7766256032795 | -122.487630947058 | (37.7766256032795, -122.487630947058) | 11 | 6 | 2 | 55 | 26 |
81333 | 109901 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2271 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775113 | 5987275.3 | 2099830 | 37.7449988337527 | -122.486712981387 | (37.7449988337527, -122.486712981387) | 1 | 8 | 3 | 29491 | 35 |
117685 | 45540 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.486285522858 | (37.7314359091244, -122.486285522858) | 1 | 8 | 4 | 64 | 35 | |
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 | |
64169 | 250645 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | : | Tree | Private 2 | 1 | Width 3ft | 5987300.52243 | 2114656.77456 | 37.7857105288548 | -122.487714838772 | (37.7857105288548, -122.487714838772) | 11 | 6 | 1 | 55 | 33 | |||
186102 | 250644 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 5987312.10464 | 2114657.57566 | 37.785713403992 | -122.487674827026 | (37.785713403992, -122.487674827026) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
174379 | 108635 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 |
54032 | 250328 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 161 27th Ave | 3 | : | Tree | Private 2 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | 11 | 6 | 1 | 55 | 33 | |||
46482 | 86034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987415.003943 | 2106546.656914 | 37.7634490992174 | -122.486723028948 | (37.7634490992174, -122.486723028948) | 1 | 8 | 3 | 56 | 35 | ||
119262 | 86018 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1550 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5987476.600405 | 2104728.077894 | 37.7584593699036 | -122.486376466049 | (37.7584593699036, -122.486376466049) | 1 | 8 | 3 | 56 | 35 | ||
19654 | 86060 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1869 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987511.195169 | 2102571.591241 | 37.7525402584661 | -122.486098523179 | (37.7525402584661, -122.486098523179) | 1 | 8 | 3 | 56 | 35 | ||
79298 | 93907 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 733 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2010 12:00:00 AM | 3x3 | Permit Number 53380 | 5987516.1 | 2110955.9 | 37.7755615483313 | -122.486697161376 | (37.7755615483313, -122.486697161376) | 11 | 6 | 2 | 55 | 26 | ||
48355 | 95931 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 691 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767628 | 5987521.80961 | 2111256.95198 | 37.7763884852693 | -122.486699521672 | (37.7763884852693, -122.486699521672) | 11 | 6 | 2 | 55 | 26 |
39748 | 86007 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987522.322672 | 2103422.53403 | 37.7548773659795 | -122.486122503429 | (37.7548773659795, -122.486122503429) | 1 | 8 | 3 | 56 | 35 | ||
186326 | 86065 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1939 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987527.802452 | 2102087.307549 | 37.7512115136965 | -122.486005547987 | (37.7512115136965, -122.486005547987) | 1 | 8 | 3 | 29491 | 35 | ||
38224 | 86070 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2115 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987568.946045 | 2100884.101082 | 37.7479102288924 | -122.485774970523 | (37.7479102288924, -122.485774970523) | 1 | 8 | 3 | 29491 | 35 | ||
15161 | 45552 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987586.87726 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | 1 | 8 | 4 | 64 | 35 | |
26990 | 45553 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) | 1 | 8 | 4 | 64 | 35 | |
137627 | 86074 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2237 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987597.115499 | 2100061.217249 | 37.7456524507082 | -122.485617181185 | (37.7456524507082, -122.485617181185) | 1 | 8 | 3 | 29491 | 35 | ||
178434 | 86075 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2241 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987598.017854 | 2100035.189447 | 37.7455810378659 | -122.485612151202 | (37.7455810378659, -122.485612151202) | 1 | 8 | 3 | 29491 | 35 | ||
119865 | 86078 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2253 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987600.724922 | 2099957.105994 | 37.7453667992034 | -122.485597061296 | (37.7453667992034, -122.485597061296) | 1 | 8 | 3 | 29491 | 35 | ||
50439 | 85991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2222 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987633.933236 | 2100153.700526 | 37.7459085303186 | -122.48549665823 | (37.7459085303186, -122.48549665823) | 1 | 8 | 3 | 29491 | 35 | ||
47254 | 85988 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2258 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.054438 | 2099919.450203 | 37.7452658143921 | -122.485451389583 | (37.7452658143921, -122.485451389583) | 1 | 8 | 3 | 29491 | 35 | ||
37177 | 250524 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.45058 | 2115374.99193 | 37.7877049922276 | -122.486435864334 | (37.7877049922276, -122.486435864334) | 11 | 6 | 1 | 55 | 33 | |||
131806 | 250521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.5238 | 2115445.0256 | 37.7878972888638 | -122.486440754852 | (37.7878972888638, -122.486440754852) | 11 | 6 | 1 | 55 | 33 | |||
54488 | 250523 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.92853 | 2115397.50584 | 37.7877668368263 | -122.48643586434 | (37.7877668368263, -122.48643586434) | 11 | 6 | 1 | 55 | 33 | |||
74721 | 86519 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1309 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.436672 | 2106370.804533 | 37.7629823684162 | -122.485754041828 | (37.7629823684162, -122.485754041828) | 1 | 8 | 3 | 56 | 35 | ||
188387 | 86539 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1719 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987787.197497 | 2103588.458912 | 37.7553483843071 | -122.485218677787 | (37.7553483843071, -122.485218677787) | 1 | 8 | 3 | 56 | 35 | ||
161853 | 86542 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1731 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987789.915173 | 2103510.132538 | 37.7551334795723 | -122.485203532524 | (37.7551334795723, -122.485203532524) | 1 | 8 | 3 | 56 | 35 | ||
163592 | 86543 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1739 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2011 12:00:00 AM | 3 | 3x3 | 5987791.726956 | 2103457.914967 | 37.7549902097756 | -122.485193435735 | (37.7549902097756, -122.485193435735) | 1 | 8 | 3 | 56 | 35 | ||
124758 | 86544 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987792.632848 | 2103431.806163 | 37.7549185748248 | -122.485188387352 | (37.7549185748248, -122.485188387352) | 1 | 8 | 3 | 56 | 35 | ||
192603 | 50228 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 741 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 5 | Permit Number 46935 | 5987844.86264 | 2110914.45258 | 37.7754669057327 | -122.485556863724 | (37.7754669057327, -122.485556863724) | 11 | 6 | 2 | 55 | 26 | |
137354 | 120094 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 749 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987846.68793 | 2110842.25702 | 37.7752687833001 | -122.485545250327 | (37.7752687833001, -122.485545250327) | 11 | 6 | 2 | 55 | 26 | |||
112624 | 88140 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2445 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51172 | 5987869.62117 | 2113257.19571 | 37.7819008606603 | -122.485643191826 | (37.7819008606603, -122.485643191826) | 11 | 6 | 2 | 55 | 26 |
127370 | 84326 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 728 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53994 | 5987888.08845 | 2110995.20666 | 37.7756911522049 | -122.485413264439 | (37.7756911522049, -122.485413264439) | 11 | 6 | 2 | 55 | 26 |
79616 | 94696 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2443 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53831 | 5987889.1247 | 2113258.01396 | 37.7819042437171 | -122.485575779552 | (37.7819042437171, -122.485575779552) | 11 | 6 | 2 | 55 | 26 |
134835 | 95928 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 758 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767625 | 5987895.38433 | 2110807.039 | 37.7751749215678 | -122.485374215588 | (37.7751749215678, -122.485374215588) | 11 | 6 | 2 | 55 | 26 |
32388 | 120359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2420 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987914.20542 | 2114679.4285 | 37.7858085051505 | -122.485593360498 | (37.7858085051505, -122.485593360498) | 11 | 6 | 1 | 55 | 33 | |||
75509 | 94697 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2443 Clement St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53831 | 5987960 | 2113267 | 37.7819330460656 | -122.485331246452 | (37.7819330460656, -122.485331246452) | 11 | 6 | 2 | 55 | 26 | ||
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 | |
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 | |
159410 | 92322 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2595 27th Ave | 2 | 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 | |
57569 | 86581 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2547 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.82634 | 2097967.749244 | 37.7399266315394 | -122.484140344437 | (37.7399266315394, -122.484140344437) | 1 | 8 | 3 | 29491 | 35 | ||
74320 | 84692 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2595 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987984.46067049 | 2097655.73005422 | 37.7390701785197 | -122.484101445526 | (37.7390701785197, -122.484101445526) | 1 | 8 | 3 | 29491 | 35 | |
110085 | 86443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | 1 | 8 | 3 | 29491 | 35 | |
184657 | 86370 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1299X 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987998.480578 | 2106474.452955 | 37.7632848451172 | -122.484699699179 | (37.7632848451172, -122.484699699179) | 1 | 8 | 3 | 56 | 35 | ||
138147 | 85959 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1298X 26TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988007 | 2106798 | 37.764173712799 | -122.484693968894 | (37.764173712799, -122.484693968894) | 1 | 8 | 3 | 56 | 35 | ||
44635 | 86376 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988009.291975 | 2106160.192246 | 37.7624226008214 | -122.484639253233 | (37.7624226008214, -122.484639253233) | 1 | 8 | 3 | 56 | 35 | ||
169666 | 86378 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1361 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988013.321416 | 2106043.06626 | 37.7621012395333 | -122.484616725198 | (37.7621012395333, -122.484616725198) | 1 | 8 | 3 | 56 | 35 | ||
184811 | 86436 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.00444 | 2097787.220267 | 37.7394336348182 | -122.48396744726 | (37.7394336348182, -122.48396744726) | 1 | 8 | 3 | 29491 | 35 | ||
75697 | 85958 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988039.866297 | 2106434.861495 | 37.7631785479619 | -122.48455365718 | (37.7631785479619, -122.48455365718) | 1 | 8 | 3 | 56 | 35 | ||
143089 | 85956 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1334 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988047.477463 | 2106213.623528 | 37.7625715322437 | -122.484511104656 | (37.7625715322437, -122.484511104656) | 1 | 8 | 3 | 56 | 35 | ||
110583 | 86387 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1515 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988049.80199 | 2104982.670278 | 37.7591918054497 | -122.4844127767 | (37.7591918054497, -122.4844127767) | 1 | 8 | 3 | 56 | 35 | ||
82755 | 86392 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1579 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988064.154428 | 2104565.481775 | 37.7580471547733 | -122.484332542242 | (37.7580471547733, -122.484332542242) | 1 | 8 | 3 | 56 | 35 | ||
62778 | 85946 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1490 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988083.436249 | 2105168.393711 | 37.7597037099979 | -122.484310075897 | (37.7597037099979, -122.484310075897) | 1 | 8 | 3 | 56 | 35 | ||
55019 | 85943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1538 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988095.160504 | 2104827.59989 | 37.7587686653948 | -122.484244534442 | (37.7587686653948, -122.484244534442) | 1 | 8 | 3 | 56 | 35 | ||
51415 | 85942 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988096.057532 | 2104801.525596 | 37.7586971246889 | -122.484239519903 | (37.7586971246889, -122.484239519903) | 1 | 8 | 3 | 56 | 35 | ||
118975 | 85940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1554 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988098.748614 | 2104723.302763 | 37.7584825026991 | -122.484224476356 | (37.7584825026991, -122.484224476356) | 1 | 8 | 3 | 56 | 35 | ||
167365 | 85937 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988110.016747 | 2104395.766944 | 37.7575838341785 | -122.484161486754 | (37.7575838341785, -122.484161486754) | 1 | 8 | 3 | 56 | 35 | ||
41201 | 85934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1630 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988116.725594 | 2104200.7569 | 37.7570487799795 | -122.484123984508 | (37.7570487799795, -122.484123984508) | 1 | 8 | 3 | 56 | 35 | ||
55399 | 92310 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2591 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 10/18/2008 12:00:00 AM | 3x3 | 5988279 | 2097698.2 | 37.7392039339278 | -122.483086187221 | (37.7392039339278, -122.483086187221) | 1 | 8 | 3 | 29491 | 35 | ||
184014 | 45531 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 47 Inverness Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 3 | Permit Number 44290 | 5988290.9031 | 2095585.94321 | 37.7334049189832 | -122.482890269181 | (37.7334049189832, -122.482890269181) | 1 | 8 | 4 | 64 | 35 | |
167418 | 90860 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2325 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988359.69279 | 2110509.77218 | 37.7743857485973 | -122.483746287708 | (37.7743857485973, -122.483746287708) | 11 | 6 | 2 | 55 | 26 | ||
182729 | 120241 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 288 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988396.42783 | 2114046.03734 | 37.7840974774898 | -122.483878566425 | (37.7840974774898, -122.483878566425) | 11 | 6 | 2 | 55 | 26 | |||
16956 | 103454 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 3x3 | 5988396.69633 | 2114118.88325 | 37.7842975073391 | -122.483882980771 | (37.7842975073391, -122.483882980771) | 11 | 6 | 2 | 55 | 26 | ||
145640 | 43804 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 284 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 5 | 6x5 | Permit Number 43434 | 5988398.11573 | 2114095.55756 | 37.7842335442368 | -122.483876359267 | (37.7842335442368, -122.483876359267) | 11 | 6 | 2 | 55 | 26 |
96170 | 86320 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988402.93355 | 2103727.210237 | 37.7557652078647 | -122.483099472181 | (37.7557652078647, -122.483099472181) | 1 | 8 | 3 | 56 | 35 | ||
58893 | 86321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1723 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988408.134093 | 2103583.601964 | 37.7553712008265 | -122.483070961912 | (37.7553712008265, -122.483070961912) | 1 | 8 | 3 | 56 | 35 | ||
68770 | 12835 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2240 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 12 | 5 | 5988460.73959 | 2114698.14797 | 37.7858917318965 | -122.48370390161 | (37.7858917318965, -122.48370390161) | 11 | 6 | 1 | 55 | 33 | ||
122741 | 12834 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 16 | 5 | 5988481.05496 | 2114714.7558 | 37.7859385147967 | -122.483634834967 | (37.7859385147967, -122.483634834967) | 11 | 6 | 1 | 55 | 33 | ||
51846 | 120353 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5988483.64082 | 2114700.05239 | 37.7858982939261 | -122.483624810328 | (37.7858982939261, -122.483624810328) | 11 | 6 | 1 | 55 | 33 | |||
83256 | 116721 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1766 25TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5988485 | 2103297 | 37.7545887414361 | -122.482784137069 | (37.7545887414361, -122.482784137069) | 1 | 8 | 3 | 56 | 35 | |||
61818 | 50771 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 638 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2004 12:00:00 AM | 7 | Permit Number 47314 | 5988487.78798 | 2111617.79391 | 37.7774355226981 | -122.483384430148 | (37.7774355226981, -122.483384430148) | 11 | 6 | 2 | 55 | 26 | ||
154082 | 12830 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2224 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5 | 5988512.18064 | 2114699.82463 | 37.7858993297316 | -122.483526054934 | (37.7858993297316, -122.483526054934) | 11 | 6 | 1 | 55 | 33 | |||
157886 | 86332 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988533.319976 | 2099923.844835 | 37.745329766428 | -122.482369901671 | (37.745329766428, -122.482369901671) | 1 | 8 | 3 | 29491 | 35 | ||
84550 | 45513 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44278 | 5988534.98014 | 2095768.80664 | 37.733921213495 | -122.482059828009 | (37.733921213495, -122.482059828009) | 1 | 8 | 4 | 64 | 35 | |
11099 | 45514 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 2 | Permit Number 44278 | 5988535.25971 | 2095760.72309 | 37.7338990344167 | -122.482058269478 | (37.7338990344167, -122.482058269478) | 1 | 8 | 4 | 64 | 35 | |
7882 | 68956 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.33246 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | 11 | 6 | 2 | 55 | 26 | |
47504 | 45526 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3001 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2001 12:00:00 AM | 3 | Permit Number 44287 | 5988554.87545 | 2095154.91197 | 37.7322367742884 | -122.481946089834 | (37.7322367742884, -122.481946089834) | 1 | 8 | 4 | 64 | 35 | |
25185 | 86250 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2242 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988568.630653 | 2100055.451314 | 37.7456931770541 | -122.48225744502 | (37.7456931770541, -122.48225744502) | 1 | 8 | 3 | 29491 | 35 | ||
186754 | 86249 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988574.227066 | 2099899.242089 | 37.7452645932744 | -122.482226651217 | (37.7452645932744, -122.482226651217) | 1 | 8 | 3 | 29491 | 35 | ||
102829 | 12827 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2212 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3 | 3X3 | 5988580.16808 | 2114701.52791 | 37.7859079633533 | -122.483290964922 | (37.7859079633533, -122.483290964922) | 11 | 6 | 1 | 55 | 33 | ||
168359 | 12826 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2212 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2010 12:00:00 AM | 3 | 3X3 | 5988595.84675 | 2114702.32759 | 37.7859110714864 | -122.483236780343 | (37.7859110714864, -122.483236780343) | 11 | 6 | 1 | 55 | 33 |
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) );