trees
203 rows where qSpecies_id = 39 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103835 | 10244 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 99X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 6 | 3X3 | 6005773.33687 | 2109613.89968 | 37.7729241676403 | -122.42344544616 | (37.7729241676403, -122.42344544616) | 7 | 9 | 11 | 28852 | 10 | ||
142837 | 91029 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 967 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 5 | 3x3 | 6007608.48742 | 2104034.949256 | 37.7577090789947 | -122.416702122814 | (37.7577090789947, -122.416702122814) | 2 | 4 | 7 | 28859 | 19 | ||
117785 | 82259 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 850 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2011 12:00:00 AM | 3 | 4x4 | Permit Number 768603 | 6007525.28639452 | 2104705.22805815 | 37.7595448304107 | -122.417037358657 | (37.7595448304107, -122.417037358657) | 2 | 4 | 7 | 28859 | 19 |
189987 | 82263 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 850 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768603 | 6007525.28639452 | 2104705.22805815 | 37.7595448304107 | -122.417037358657 | (37.7595448304107, -122.417037358657) | 2 | 4 | 7 | 28859 | 19 | |
69432 | 239228 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 819 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009935.7806 | 2104272.52927 | 37.7584920407792 | -122.408670110163 | (37.7584920407792, -122.408670110163) | 2 | 4 | 7 | 28859 | 19 | |||
176674 | 43127 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 8 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52578 | 6007298.20406204 | 2099606.09068899 | 37.7455309835883 | -122.417461342572 | (37.7455309835883, -122.417461342572) | 2 | 7 | 7 | 28859 | 2 | ||
8531 | 239148 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 8 Octavia St | 12 | : | Tree | Private 2 | 3 | Width 6ft | 6005748.59719 | 2109565.89201 | 37.7727909537754 | -122.423527610038 | (37.7727909537754, -122.423527610038) | 7 | 9 | 11 | 28852 | 10 | |||
79147 | 239147 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 8 Octavia St | 11 | : | Tree | Private 2 | 5 | Width 6ft | 6005750.76035 | 2109550.79453 | 37.7727496218289 | -122.423519053867 | (37.7727496218289, -122.423519053867) | 7 | 9 | 11 | 28852 | 10 | |||
151092 | 239149 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 8 Octavia St | 13 | : | Tree | Private 2 | 3 | Width 6ft | 6005748.02057 | 2109577.94621 | 37.7728240191579 | -122.423530461786 | (37.7728240191579, -122.423530461786) | 7 | 9 | 11 | 28852 | 10 | |||
119193 | 39176 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 754 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2009 12:00:00 AM | Permit Number 53085 | 6007474 | 2105260 | 37.7610652207705 | -122.417254045994 | (37.7610652207705, -122.417254045994) | 2 | 4 | 7 | 28859 | 19 | |||
142290 | 239184 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 754 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007487.61608 | 2105246.87358 | 37.7610299446873 | -122.417206023563 | (37.7610299446873, -122.417206023563) | 2 | 4 | 7 | 28859 | 19 | |||
26357 | 91026 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 722 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.7615776005454 | -122.417211018518 | (37.7615776005454, -122.417211018518) | 2 | 4 | 7 | 28859 | 19 | ||
43599 | 91027 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 722 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.7615776005454 | -122.417211018518 | (37.7615776005454, -122.417211018518) | 2 | 4 | 7 | 28859 | 19 | ||
146320 | 91028 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 722 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.7615776005454 | -122.417211018518 | (37.7615776005454, -122.417211018518) | 2 | 4 | 7 | 28859 | 19 | ||
130061 | 239183 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 720 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007476.35772 | 2105397.09343 | 37.761441780224 | -122.41725560676 | (37.761441780224, -122.41725560676) | 2 | 4 | 7 | 28859 | 19 | |||
89830 | 102104 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 705X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52427 | 6009386 | 2110546 | 37.7756867379095 | -122.411014612047 | (37.7756867379095, -122.411014612047) | 8 | 2 | 9 | 28853 | 34 | |||
161495 | 239172 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 66 Dorland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005143.16857 | 2105759.69419 | 37.7623058551435 | -122.425350950383 | (37.7623058551435, -122.425350950383) | 8 | 4 | 5 | 28859 | 19 | |||
108986 | 249356 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 625 Leavenworth St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008325.07213 | 2114654.93665 | 37.7869093422284 | -122.414975526796 | (37.7869093422284, -122.414975526796) | 13 | 1 | 9 | 28858 | 36 | |||
179552 | 217747 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 625 Frederick St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5996570.53056 | 2107292.29818 | 37.7660259340648 | -122.455111074526 | (37.7660259340648, -122.455111074526) | 15 | 5 | 11 | 29492 | 12 | |||
148854 | 61801 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 564 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52595 | 6003001.78864481 | 2108933.54346304 | 37.7708992574252 | -122.432983937695 | (37.7708992574252, -122.432983937695) | 15 | 5 | 11 | 29492 | 9 | ||
2327 | 108056 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 535X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773596 | 6013160.27922 | 2115313.8399 | 37.7889890532579 | -122.398292953274 | (37.7889890532579, -122.398292953274) | 12 | 2 | 9 | 28855 | 6 | |
99478 | 108058 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 535X Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773596 | 6013160.27922 | 2115313.8399 | 37.7889890532579 | -122.398292953274 | (37.7889890532579, -122.398292953274) | 12 | 2 | 9 | 28855 | 6 | |
122986 | 108055 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 535X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773596 | 6013160.27922 | 2115313.8399 | 37.7889890532579 | -122.398292953274 | (37.7889890532579, -122.398292953274) | 12 | 2 | 9 | 28855 | 6 | |
128643 | 108057 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 535X Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773596 | 6013160.27922 | 2115313.8399 | 37.7889890532579 | -122.398292953274 | (37.7889890532579, -122.398292953274) | 12 | 2 | 9 | 28855 | 6 | |
48163 | 82751 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 52 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52446 | 6009256.89976445 | 2109417.42292722 | 37.772580689338 | -122.41138145626 | (37.772580689338, -122.41138145626) | 8 | 2 | 9 | 28853 | 34 | |
118616 | 95059 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5115X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014711.63884 | 2094587.79956 | 37.7321661259618 | -122.391475861678 | (37.7321661259618, -122.391475861678) | 10 | 3 | 8 | 58 | 1 | |||
84045 | 22308 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5033 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2000 12:00:00 AM | 3 | 3x3 | 6014806.84876 | 2094754.47288 | 37.7326290611665 | -122.391158343086 | (37.7326290611665, -122.391158343086) | 10 | 3 | 8 | 58 | 1 | ||
156139 | 95060 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5033 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6014806.53085 | 2094754.47288 | 37.7326290435242 | -122.391159442188 | (37.7326290435242, -122.391159442188) | 10 | 3 | 8 | 58 | 1 | |||
134355 | 22306 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5015 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6014803.86419 | 2094824.41992 | 37.7328209559263 | -122.39117354906 | (37.7328209559263, -122.39117354906) | 10 | 3 | 8 | 58 | 1 | |||
168668 | 22304 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 5012X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6014702.6472 | 2094891.22359 | 37.7329987676998 | -122.391528153423 | (37.7329987676998, -122.391528153423) | 10 | 3 | 8 | 58 | 1 | |||
160955 | 22295 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 4910 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014801.71028 | 2095185.44595 | 37.7338121405587 | -122.391206222681 | (37.7338121405587, -122.391206222681) | 10 | 3 | 8 | 58 | 1 | |||
167251 | 95064 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 4849X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014989.6 | 2095442.3 | 37.734527834908 | -122.390574568357 | (37.734527834908, -122.390574568357) | 10 | 3 | 8 | 58 | 1 | |||
140365 | 102175 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 484 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769767 | 5999426.4 | 2104189.2 | 37.7576690270565 | -122.445010134311 | (37.7576690270565, -122.445010134311) | 2 | 5 | 5 | 28862 | 3 |
19695 | 239185 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 483 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007463.11739 | 2106828.6922 | 37.7653718724361 | -122.417402858182 | (37.7653718724361, -122.417402858182) | 8 | 4 | 7 | 28853 | 19 | |||
92109 | 239186 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 483 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007463.67946 | 2106844.52399 | 37.7654153744566 | -122.417402036177 | (37.7654153744566, -122.417402036177) | 8 | 4 | 7 | 28853 | 19 | |||
101161 | 239187 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 483 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007459.99284 | 2106907.97241 | 37.7655893815639 | -122.417419284297 | (37.7655893815639, -122.417419284297) | 8 | 4 | 7 | 28853 | 19 | |||
37418 | 92866 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 4800 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014889.77806 | 2095498.93005 | 37.7346777911521 | -122.390923645427 | (37.7346777911521, -122.390923645427) | 10 | 3 | 8 | 58 | 1 | |||
37563 | 92591 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 445 Wawona St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
69597 | 92590 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 445 Wawona St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
87707 | 92593 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 445 Wawona St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
89316 | 92592 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 445 Wawona St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
93457 | 84670 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 4089 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6002616.95424138 | 2101785.02656585 | 37.7512493217958 | -122.433804069341 | (37.7512493217958, -122.433804069341) | 2 | 4 | 5 | 28862 | 22 |
69764 | 84663 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 4023 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003022.50968447 | 2101807.41144942 | 37.7513337904703 | -122.43240321347 | (37.7513337904703, -122.43240321347) | 2 | 4 | 5 | 28862 | 22 |
13217 | 109951 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
23235 | 109950 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
41644 | 109948 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
86051 | 109944 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
86412 | 109945 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
93470 | 109942 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
108791 | 109943 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
118512 | 109946 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
145260 | 109947 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
191841 | 109941 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
192360 | 109949 | Section 143 10 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 400x CLEMENTINA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439 | 2112324 | 37.7806836249396 | -122.404037890761 | (37.7806836249396, -122.404037890761) | 14 | 2 | 9 | 28853 | 34 | ||
93516 | 84571 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3991 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003245.44934651 | 2101819.71675357 | 37.7513802170554 | -122.431633141487 | (37.7513802170554, -122.431633141487) | 2 | 4 | 5 | 28862 | 22 |
25897 | 239229 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 391 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004228.5151 | 2106643.84143 | 37.764681793855 | -122.428577420229 | (37.764681793855, -122.428577420229) | 8 | 4 | 5 | 28862 | 3 | |||
30634 | 239231 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 391 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004225.70382 | 2106680.81705 | 37.764783160934 | -122.428589779597 | (37.764783160934, -122.428589779597) | 8 | 4 | 5 | 28862 | 3 | |||
58529 | 239230 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 391 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004227.15082 | 2106664.32977 | 37.7647379727106 | -122.428583599467 | (37.7647379727106, -122.428583599467) | 8 | 4 | 5 | 28862 | 3 | |||
74165 | 102120 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3906 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003747.7 | 2101944.5 | 37.751751298202 | -122.429905200436 | (37.751751298202, -122.429905200436) | 2 | 4 | 5 | 28862 | 22 |
184594 | 61618 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003796.89718088 | 2101902.23350187 | 37.7516380302781 | -122.429732055701 | (37.7516380302781, -122.429732055701) | 2 | 4 | 5 | 28862 | 22 |
75767 | 239181 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 380 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006215.67613 | 2107893.94566 | 37.7682265409602 | -122.42179314696 | (37.7682265409602, -122.42179314696) | 8 | 4 | 7 | 28853 | 19 | |||
76680 | 239173 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3705 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005734.96606 | 2101372.66505 | 37.7502935116564 | -122.422992320041 | (37.7502935116564, -122.422992320041) | 2 | 4 | 5 | 28859 | 19 | |||
44677 | 239179 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 370 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006290.70185 | 2107898.44552 | 37.7682431271357 | -122.421533959636 | (37.7682431271357, -122.421533959636) | 8 | 4 | 7 | 28853 | 19 | |||
100905 | 239178 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 370 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006302.56864 | 2107899.15692 | 37.7682457495759 | -122.421492964039 | (37.7682457495759, -122.421492964039) | 8 | 4 | 7 | 28853 | 19 | |||
164569 | 239180 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 370 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006264.72566 | 2107896.23328 | 37.7682355881421 | -122.421623651723 | (37.7682355881421, -122.421623651723) | 8 | 4 | 7 | 28853 | 19 | |||
72149 | 239182 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3599 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005021.22782 | 2106010.41037 | 37.7629873721785 | -122.425790544398 | (37.7629873721785, -122.425790544398) | 8 | 4 | 5 | 28859 | 19 | |||
51753 | 136188 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3598 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002648.6286 | 2120880.08452 | 37.8036813773578 | -122.435060090577 | (37.8036813773578, -122.435060090577) | 13 | 9 | 1 | 57 | 17 | |||
52907 | 82094 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 356 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50622 | 5991881.95379836 | 2113031.51992267 | 37.7815141826847 | -122.471746056837 | (37.7815141826847, -122.471746056837) | 11 | 6 | 2 | 54 | 11 | ||
189471 | 51377 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 356 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52402 | 6008497.808835 | 2108622.2239572 | 37.7703546548295 | -122.413950975697 | (37.7703546548295, -122.413950975697) | 8 | 2 | 9 | 28853 | 19 | ||
43730 | 55657 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 349 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52575 | 6006153.21523754 | 2098012.87204699 | 37.7410918742968 | -122.421307424196 | (37.7410918742968, -122.421307424196) | 2 | 7 | 7 | 28859 | 2 | ||
106471 | 65681 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 345 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2011 12:00:00 AM | 3 | Permit Number 767215 | 5993370.6959 | 2113311.72647 | 37.782369577363 | -122.466616141073 | (37.782369577363, -122.466616141073) | 11 | 6 | 2 | 54 | 11 | ||
157456 | 95602 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 345 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769429 | 5993373.11205 | 2113255.69639 | 37.7822158734246 | -122.466603708408 | (37.7822158734246, -122.466603708408) | 11 | 6 | 2 | 54 | 11 | |
111916 | 80773 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 317 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767266 | 6004338.6764807 | 2102152.37621846 | 37.7523555276075 | -122.427876335011 | (37.7523555276075, -122.427876335011) | 2 | 4 | 5 | 28862 | 22 | |
7169 | 114201 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 310 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012278.4302 | 2106502.4698 | 37.7647458912325 | -122.40072478603 | (37.7647458912325, -122.40072478603) | 14 | 3 | 8 | 28856 | 29 | |||
38627 | 114204 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 310 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012281.59873 | 2106430.00707 | 37.764547101481 | -122.400708735836 | (37.764547101481, -122.400708735836) | 14 | 3 | 8 | 28856 | 29 | |||
84108 | 114205 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 310 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012283.24048 | 2106396.5985 | 37.7644554605731 | -122.400700710264 | (37.7644554605731, -122.400700710264) | 14 | 3 | 8 | 28856 | 29 | |||
108073 | 114202 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 310 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012278.21126 | 2106491.69166 | 37.7647162846561 | -122.400724786045 | (37.7647162846561, -122.400724786045) | 14 | 3 | 8 | 28856 | 29 | |||
127840 | 114203 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 310 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012282.10678 | 2106442.32004 | 37.7645809384837 | -122.400707843686 | (37.7645809384837, -122.400707843686) | 14 | 3 | 8 | 28856 | 29 | |||
145611 | 239225 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 3041 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009370.46908 | 2100985.69041 | 37.7494354397039 | -122.410393138328 | (37.7494354397039, -122.410393138328) | 2 | 4 | 7 | 28859 | 19 | |||
145625 | 249388 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 301 Eddy St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6008934.66326 | 2113525.78003 | 37.7838431855658 | -122.412786614726 | (37.7838431855658, -122.412786614726) | 7 | 10 | 9 | 28852 | 36 | |||
20785 | 239226 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2851 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010136.75438 | 2101030.89604 | 37.7496024914637 | -122.407746478521 | (37.7496024914637, -122.407746478521) | 2 | 4 | 7 | 28859 | 19 | |||
62633 | 239227 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2851 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010159.00691 | 2101032.65482 | 37.7496085663777 | -122.407669652152 | (37.7496085663777, -122.407669652152) | 2 | 4 | 7 | 28859 | 19 | |||
74646 | 239223 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2850 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010195.06778 | 2101081.2894 | 37.7497441247919 | -122.407548380357 | (37.7497441247919, -122.407548380357) | 2 | 4 | 7 | 28859 | 19 | |||
98663 | 239224 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2850 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010131.27143 | 2101077.30272 | 37.7497296070346 | -122.407768710669 | (37.7497296070346, -122.407768710669) | 2 | 4 | 7 | 28859 | 19 | |||
61224 | 239222 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2830 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010232.06115 | 2101082.77231 | 37.749750267174 | -122.407420559713 | (37.749750267174, -122.407420559713) | 2 | 4 | 7 | 28859 | 19 | |||
29978 | 239221 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2810 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010295.22869 | 2101085.95879 | 37.7497625519161 | -122.407202347334 | (37.7497625519161, -122.407202347334) | 2 | 4 | 7 | 28859 | 19 | |||
69110 | 239220 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2730 Bryant St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | Width 7ft | 6009770.49444 | 2101313.01983 | 37.7503566305768 | -122.409032927236 | (37.7503566305768, -122.409032927236) | 2 | 4 | 7 | 28859 | 19 | |||
126270 | 239219 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2730 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009767.82555 | 2101370.89854 | 37.7505154031821 | -122.409046239907 | (37.7505154031821, -122.409046239907) | 2 | 4 | 7 | 28859 | 19 | |||
176681 | 102170 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 270 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | 6001983.1 | 2104294.8 | 37.7581045689631 | -122.436175590041 | (37.7581045689631, -122.436175590041) | 2 | 4 | 5 | 28862 | 3 | |
71958 | 87950 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 263a States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50972 | 6000485 | 2106698 | 37.7646179360441 | -122.441529100685 | (37.7646179360441, -122.441529100685) | 15 | 5 | 5 | 28862 | 3 | ||
2777 | 256912 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
97965 | 116523 | Undocumented 4 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2486 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5995798 | 2110374 | 37.7744431335528 | -122.458006125331 | (37.7744431335528, -122.458006125331) | 11 | 6 | 2 | 54 | 16 | |||
89400 | 197032 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2425 Mendell St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6013410.89228 | 2092904.94236 | 37.7274730618297 | -122.395854985916 | (37.7274730618297, -122.395854985916) | 10 | 3 | 8 | 58 | 1 | |||
170786 | 197033 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 2421 Mendell St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6013404.92157 | 2092933.78448 | 37.7275519242636 | -122.395877647031 | (37.7275519242636, -122.395877647031) | 10 | 3 | 8 | 58 | 1 | |||
45170 | 82942 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 236 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52427 | 6009386 | 2110546 | 37.7756867379095 | -122.411014612047 | (37.7756867379095, -122.411014612047) | 8 | 2 | 9 | 28853 | 34 | ||
160303 | 83748 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 235 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51439 | 6013723.72454 | 2094177.53037 | 37.7309847282642 | -122.39486260383 | (37.7309847282642, -122.39486260383) | 10 | 3 | 8 | 58 | 1 | |
189710 | 102100 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 234 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006253 | 2110945 | 37.7766061096379 | -122.421880802459 | (37.7766061096379, -122.421880802459) | 7 | 9 | 11 | 28852 | 10 | |||
146723 | 95702 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 231 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767451 | 5995312 | 2091520.8 | 37.7226490447139 | -122.458322390694 | (37.7226490447139, -122.458322390694) | 9 | 8 | 4 | 28861 | 24 | |
66647 | 87768 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 200 Beacon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50472 | 6003134 | 2097619 | 37.7398397101769 | -122.431718656253 | (37.7398397101769, -122.431718656253) | 2 | 7 | 5 | 63 | 7 | |||
112264 | 87767 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 200 Beacon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50472 | 6003134 | 2097619 | 37.7398397101769 | -122.431718656253 | (37.7398397101769, -122.431718656253) | 2 | 7 | 5 | 63 | 7 |
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) );