trees
575 rows where qSpecies_id = 123 sorted by qCaretaker_id
This data as json, CSV (advanced)
qSiteInfo ✖
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115541 | 90885 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1733 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990174.4288 | 2110576.33984 | 37.7746739946122 | -122.477473709626 | (37.7746739946122, -122.477473709626) | 11 | 6 | 2 | 55 | 26 | ||
| 115832 | 104046 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
| 120276 | 90868 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989180.48685 | 2110539.97505 | 37.7745164219339 | -122.480909251758 | (37.7745164219339, -122.480909251758) | 11 | 6 | 2 | 55 | 26 | ||
| 121645 | 90588 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2242 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988605.86031 | 2110576.30478 | 37.7745827550651 | -122.48289963544 | (37.7745827550651, -122.48289963544) | 11 | 6 | 2 | 55 | 26 | ||
| 122308 | 91633 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
| 123994 | 121589 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007359 | 2108191 | 37.7691065911809 | -122.417859552844 | (37.7691065911809, -122.417859552844) | 8 | 4 | 7 | 28853 | 19 | ||||
| 125523 | 104460 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
| 128004 | 90862 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2233 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988638.67322 | 2110518.90236 | 37.7744270531648 | -122.4827819229 | (37.7744270531648, -122.4827819229) | 11 | 6 | 2 | 55 | 26 | ||
| 128361 | 91689 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 335 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007402.197577 | 2107728.718925 | 37.7678397070843 | -122.417677364286 | (37.7678397070843, -122.417677364286) | 8 | 4 | 7 | 28853 | 19 | |||
| 128961 | 91690 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 315 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007395.800334 | 2107840.638089 | 37.7681466508094 | -122.417707425394 | (37.7681466508094, -122.417707425394) | 8 | 4 | 7 | 28853 | 19 | |||
| 129554 | 120951 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6007568 | 2105341 | 37.7612929159977 | -122.416934678899 | (37.7612929159977, -122.416934678899) | 2 | 4 | 7 | 28859 | 19 | |||
| 129945 | 91693 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 253 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007399.603267 | 2108201.969765 | 37.7691389965346 | -122.417719885805 | (37.7691389965346, -122.417719885805) | 8 | 4 | 7 | 28853 | 19 | |||
| 132267 | 91658 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1073 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007642.630657 | 2103418.725072 | 37.7560189888407 | -122.416540390694 | (37.7560189888407, -122.416540390694) | 2 | 4 | 7 | 28859 | 19 | |||
| 132731 | 26278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/1998 12:00:00 AM | 3 | 6000476.90225 | 2093497.19967 | 37.7283712336437 | -122.440610195428 | (37.7283712336437, -122.440610195428) | 9 | 7 | 6 | 28861 | 25 | |||
| 133771 | 91586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 356 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007369.299728 | 2107603.325202 | 37.7674935541002 | -122.417782265097 | (37.7674935541002, -122.417782265097) | 8 | 4 | 7 | 28853 | 19 | |||
| 134217 | 91699 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
| 135561 | 91626 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1450 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007725.085674 | 2101207.507592 | 37.749952124518 | -122.416098640357 | (37.749952124518, -122.416098640357) | 2 | 4 | 7 | 28859 | 19 | |||
| 136593 | 91668 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
| 139468 | 91692 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 263 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007399.273892 | 2108147.255986 | 37.7689887468538 | -122.417717146452 | (37.7689887468538, -122.417717146452) | 8 | 4 | 7 | 28853 | 19 | |||
| 139882 | 91608 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | 2 | 4 | 7 | 28859 | 19 | |||
| 141497 | 90865 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988736.61915 | 2110526.67364 | 37.7744540891609 | -122.482443682946 | (37.7744540891609, -122.482443682946) | 11 | 6 | 2 | 55 | 26 | ||
| 142131 | 91614 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1140 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007588 | 2102997 | 37.7548579556474 | -122.416699447347 | (37.7548579556474, -122.416699447347) | 2 | 4 | 7 | 28859 | 19 | |||
| 143144 | 91583 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 280 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 6007340.222146 | 2108038.912892 | 37.7686879390349 | -122.417913721993 | (37.7686879390349, -122.417913721993) | 8 | 4 | 7 | 28853 | 19 | |||
| 143430 | 91578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:03:00 PM | 4 | 3x3 | 6007300.496664 | 2108846.846012 | 37.7709040967706 | -122.418108415168 | (37.7709040967706, -122.418108415168) | 8 | 2 | 9 | 28853 | 19 | ||
| 145660 | 91669 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 765 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007543.215311 | 2105213.393874 | 37.7609411449227 | -122.417011357225 | (37.7609411449227, -122.417011357225) | 2 | 4 | 7 | 28859 | 19 | |||
| 146984 | 91609 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 976 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007571.644451 | 2103976.864237 | 37.7575475186204 | -122.416825426207 | (37.7575475186204, -122.416825426207) | 2 | 4 | 7 | 28859 | 19 | ||
| 147178 | 90863 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988677.47069 | 2110522.18301 | 37.7744383181626 | -122.482647957161 | (37.7744383181626, -122.482647957161) | 11 | 6 | 2 | 55 | 26 | ||
| 147966 | 90873 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2015 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989357.49508 | 2110545.80132 | 37.7745427066681 | -122.480297379549 | (37.7745427066681, -122.480297379549) | 11 | 6 | 2 | 55 | 26 | ||
| 148664 | 91605 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 814 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007520.10207 | 2104907.355044 | 37.7600995328259 | -122.417069610712 | (37.7600995328259, -122.417069610712) | 2 | 4 | 7 | 28859 | 19 | ||
| 148837 | 90580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989065.94752 | 2110592.46721 | 37.7746538923373 | -122.481309305666 | (37.7746538923373, -122.481309305666) | 11 | 6 | 2 | 55 | 26 | ||
| 148991 | 22243 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4434 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
| 149728 | 91698 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
| 149994 | 91642 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | 2 | 4 | 7 | 28859 | 19 | |||
| 152443 | 91602 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007474 | 2105260 | 37.7610652207705 | -122.417254045994 | (37.7610652207705, -122.417254045994) | 2 | 4 | 7 | 28859 | 19 | ||
| 153861 | 120915 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | |||
| 153876 | 241326 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 395 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007429.44982 | 2107410.61084 | 37.7669677904545 | -122.417560553376 | (37.7669677904545, -122.417560553376) | 8 | 4 | 7 | 28853 | 19 | ||
| 155550 | 91589 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 442 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007397.135958 | 2107116.333394 | 37.7661579552478 | -122.417651462281 | (37.7661579552478, -122.417651462281) | 8 | 4 | 7 | 28853 | 19 | |||
| 155950 | 90585 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988755.94443 | 2110581.0496 | 37.7746045146176 | -122.482380818852 | (37.7746045146176, -122.482380818852) | 11 | 6 | 2 | 55 | 26 | ||
| 157671 | 91653 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1199 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007683.015377 | 2102689.848948 | 37.7540199323813 | -122.416349102661 | (37.7540199323813, -122.416349102661) | 2 | 4 | 7 | 28859 | 19 | ||
| 158272 | 91620 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1290 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007671.629207 | 2102150.724826 | 37.7525389797951 | -122.41635029552 | (37.7525389797951, -122.41635029552) | 2 | 4 | 7 | 28859 | 19 | |||
| 161059 | 90582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989019.95807 | 2110588.86895 | 37.7746413386268 | -122.481468126933 | (37.7746413386268, -122.481468126933) | 11 | 6 | 2 | 55 | 26 | ||
| 161394 | 91673 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.417061293148 | (37.7614631059869, -122.417061293148) | 2 | 4 | 7 | 28859 | 19 | ||
| 162699 | 22272 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4720 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1995 12:00:00 AM | 6 | 3x3 | 6014914.77079 | 2095774.79236 | 37.7354366396256 | -122.390856509346 | (37.7354366396256, -122.390856509346) | 10 | 3 | 8 | 58 | 1 | ||
| 163045 | 91611 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1086 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007607.027989 | 2103338.253155 | 37.7557960290434 | -122.416657816418 | (37.7557960290434, -122.416657816418) | 2 | 4 | 7 | 28859 | 19 | |||
| 163157 | 85249 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 163714 | 90587 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988720.72128 | 2110579.96701 | 37.7745994931186 | -122.482502581896 | (37.7745994931186, -122.482502581896) | 11 | 6 | 2 | 55 | 26 | ||
| 164866 | 91649 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
| 170208 | 91664 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 815 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007560.040875 | 2104909.5668 | 37.7601078524477 | -122.4169316378 | (37.7601078524477, -122.4169316378) | 2 | 4 | 7 | 28859 | 19 | ||
| 170751 | 90866 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2151X Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988924.29434 | 2110530.35666 | 37.7744751174123 | -122.481794756145 | (37.7744751174123, -122.481794756145) | 11 | 6 | 2 | 55 | 26 | ||
| 171522 | 91648 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
| 171747 | 91681 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | ||
| 174631 | 91637 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1459 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007767.503009 | 2101164.985993 | 37.749837754658 | -122.415948947877 | (37.749837754658, -122.415948947877) | 2 | 4 | 7 | 28859 | 19 | |||
| 176270 | 91644 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1343 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007729.450223 | 2101838.070556 | 37.7516837533185 | -122.416128199355 | (37.7516837533185, -122.416128199355) | 2 | 4 | 7 | 28859 | 19 | |||
| 177005 | 91676 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 629 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007499.688693 | 2105999.37525 | 37.7630968189144 | -122.417217594449 | (37.7630968189144, -122.417217594449) | 8 | 4 | 7 | 28859 | 19 | |||
| 177404 | 91685 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007417.550959 | 2107460.112945 | 37.7671030420828 | -122.417605218645 | (37.7671030420828, -122.417605218645) | 8 | 4 | 7 | 28853 | 19 | ||
| 177434 | 91643 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1367 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007737.207562 | 2101703.625981 | 37.7513150351075 | -122.416091852961 | (37.7513150351075, -122.416091852961) | 2 | 4 | 7 | 28859 | 19 | |||
| 177703 | 91647 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1271 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | 2 | 4 | 7 | 28859 | 19 | ||
| 179949 | 91585 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007359.06414 | 2107782.395856 | 37.7679846640127 | -122.417830363455 | (37.7679846640127, -122.417830363455) | 8 | 4 | 7 | 28853 | 19 | ||
| 181100 | 90574 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1950 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989503.12005 | 2110610.6462 | 37.7747292138807 | -122.479798386077 | (37.7747292138807, -122.479798386077) | 11 | 6 | 2 | 55 | 26 | ||
| 182007 | 90886 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1715 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990248.62617 | 2110577.36646 | 37.7746811185578 | -122.477217123809 | (37.7746811185578, -122.477217123809) | 11 | 6 | 2 | 55 | 26 | ||
| 183387 | 22238 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4420 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
| 185524 | 91700 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
| 187830 | 91683 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 395 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007421.389304 | 2107392.96146 | 37.7669188758381 | -122.41758718246 | (37.7669188758381, -122.41758718246) | 8 | 4 | 7 | 28853 | 19 | |||
| 188061 | 90880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1901X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989653.27368 | 2110557.04805 | 37.7745907701264 | -122.479275058131 | (37.7745907701264, -122.479275058131) | 11 | 6 | 2 | 55 | 26 | ||
| 188771 | 91621 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1358 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007694.688201 | 2101746.136705 | 37.7514293691601 | -122.416241900686 | (37.7514293691601, -122.416241900686) | 2 | 4 | 7 | 28859 | 19 | |||
| 188806 | 90577 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2050X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989223.999 | 2110597.65544 | 37.7746773254621 | -122.480762960202 | (37.7746773254621, -122.480762960202) | 11 | 6 | 2 | 55 | 26 | ||
| 190395 | 91010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988937.91177 | 2110588.16813 | 37.7746346435588 | -122.481751886766 | (37.7746346435588, -122.481751886766) | 11 | 6 | 2 | 55 | 26 | ||
| 190505 | 85250 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 191286 | 90883 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1827 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989887.73623 | 2110565.21832 | 37.7746268180643 | -122.478464612476 | (37.7746268180643, -122.478464612476) | 11 | 6 | 2 | 55 | 26 | ||
| 193505 | 91666 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
| 599 | 78256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | 9 | 7 | 6 | 28861 | 5 | |||
| 925 | 34964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Permit Number 38553 | 6014444.74274 | 2102850.73033 | 37.7548395926778 | -122.392976501569 | (37.7548395926778, -122.392976501569) | 10 | 3 | 8 | 28856 | 29 | ||
| 2485 | 59880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.74506 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | 13 | 9 | 1 | 57 | 17 | |
| 3710 | 70389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.479670271059 | (37.7747342353889, -122.479670271059) | 11 | 6 | 2 | 55 | 26 | |||
| 4053 | 196973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Width 4ft | 6014457.83967 | 2102608.37301 | 37.7541748588033 | -122.392914253189 | (37.7541748588033, -122.392914253189) | 10 | 3 | 8 | 28856 | 29 | ||
| 4479 | 83223 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1446-48 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50888 | 5993687.91761966 | 2105648.90031529 | 37.7613477954461 | -122.464962006978 | (37.7613477954461, -122.464962006978) | 1 | 8 | 11 | 56 | 12 | |
| 4592 | 196983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
| 4814 | 72022 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6010599.26481 | 2116134.30998 | 37.7910988780658 | -122.407211626534 | (37.7910988780658, -122.407211626534) | 5 | 1 | 10 | 28857 | 6 | |||
| 4885 | 71351 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50915 | 5999898.11886666 | 2105092.21291824 | 37.7601753897516 | -122.44344360556 | (37.7601753897516, -122.44344360556) | 2 | 4 | 5 | 28862 | 3 | ||
| 5120 | 197001 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 16 | : | Tree | Private 2 | 9 | Width 4ft | 6013598.90827 | 2100122.82985 | 37.7473023413409 | -122.395710528743 | (37.7473023413409, -122.395710528743) | 10 | 3 | 8 | 58 | 1 | |||
| 5657 | 41933 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42292 | 5994729.71498 | 2111330.05881 | 37.7770067806052 | -122.461770835952 | (37.7770067806052, -122.461770835952) | 11 | 6 | 2 | 54 | 11 | |
| 6340 | 33134 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3107 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 10 | Permit Number 37364 | 6001390.00916 | 2119109.09622 | 37.7987471650933 | -122.439288583214 | (37.7987471650933, -122.439288583214) | 13 | 9 | 1 | 57 | 17 | |
| 7828 | 196969 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015866.24342 | 2105844.60301 | 37.763138987107 | -122.388269449981 | (37.763138987107, -122.388269449981) | 14 | 3 | 8 | 28856 | 29 | |||
| 7907 | 91707 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
| 8545 | 241289 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 9715 | 196963 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015947.26389 | 2105849.11258 | 37.7631558583726 | -122.387989539601 | (37.7631558583726, -122.387989539601) | 14 | 3 | 8 | 28856 | 29 | |||
| 9813 | 201661 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 149 Dore St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6009207.44548 | 2109499.94346 | 37.7728044975557 | -122.411558355748 | (37.7728044975557, -122.411558355748) | 8 | 2 | 9 | 28853 | 34 | |||
| 10563 | 220139 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 11064 | 196994 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 7 | : | Tree | Private 2 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.394724774624 | (37.7473596740254, -122.394724774624) | 10 | 3 | 8 | 58 | 1 | |||
| 11610 | 241384 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008146.34247 | 2105906.05304 | 37.7628769363446 | -122.414974425147 | (37.7628769363446, -122.414974425147) | 8 | 4 | 7 | 28859 | 19 | |||
| 13557 | 220140 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 13645 | 70110 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 79 Stoneyford Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6006114.15907 | 2093862.38939 | 37.7296933683514 | -122.421147824905 | (37.7296933683514, -122.421147824905) | 9 | 7 | 7 | 28861 | 5 | |||
| 14811 | 241276 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010713.5875 | 2101085.71194 | 37.7497852786664 | -122.405755620526 | (37.7497852786664, -122.405755620526) | 10 | 4 | 7 | 28859 | 19 | |||
| 14984 | 68126 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 8 | Permit Number 31876 | 6013566.56944 | 2105672.60835 | 37.7625390358578 | -122.396211251447 | (37.7625390358578, -122.396211251447) | 14 | 3 | 8 | 28856 | 29 | |
| 15698 | 241342 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2122 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009546.72381 | 2104789.44467 | 37.7598895755605 | -122.410052140597 | (37.7598895755605, -122.410052140597) | 2 | 4 | 7 | 28859 | 19 | |||
| 16220 | 179280 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010456.33755 | 2094955.50587 | 37.7329386663832 | -122.406213356571 | (37.7329386663832, -122.406213356571) | 10 | 3 | 7 | 309 | 28 | |||
| 16388 | 241286 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 16406 | 241355 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009659.81185 | 2101050.9246 | 37.7496307742409 | -122.409397182327 | (37.7496307742409, -122.409397182327) | 2 | 4 | 7 | 28859 | 19 | |||
| 16550 | 88330 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 544 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.7206352284922 | -122.437157897339 | (37.7206352284922, -122.437157897339) | 9 | 7 | 6 | 28861 | 5 | |||
| 16583 | 241346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009581.66758 | 2105919.15522 | 37.7629934624139 | -122.410011039795 | (37.7629934624139, -122.410011039795) | 8 | 4 | 8 | 28859 | 19 |
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) );