trees
575 rows where qSpecies_id = 123 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |||
| 42600 | 91638 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.536844 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | 2 | 4 | 7 | 28859 | 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 | |||
| 94776 | 91627 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1468 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007730.662506 | 2101106.855019 | 37.7496760688109 | -122.416072228065 | (37.7496760688109, -122.416072228065) | 2 | 4 | 7 | 28859 | 19 | |||
| 68475 | 91629 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
| 111472 | 91628 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
| 92727 | 241365 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1475 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010134.56863 | 2100721.5441 | 37.7487529567978 | -122.407732226982 | (37.7487529567978, -122.407732226982) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 59988 | 91630 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) | 2 | 4 | 7 | 28859 | 19 | |||
| 60318 | 91631 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.416020863166 | (37.7491392078361, -122.416020863166) | 2 | 4 | 7 | 28859 | 19 | |||
| 75362 | 91635 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 3 | 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 | ||
| 111602 | 91634 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | ||
| 35315 | 88470 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1519 Innes Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51424 | 6015916 | 2096861 | 37.7384746486807 | -122.387470605672 | (37.7384746486807, -122.387470605672) | 10 | 3 | 8 | 58 | 1 | |||
| 89642 | 90894 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.86617 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | 11 | 6 | 2 | 54 | 26 | ||
| 105683 | 241297 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1534 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007142.6566 | 2107359.78421 | 37.7668120908263 | -122.418548923599 | (37.7668120908263, -122.418548923599) | 8 | 4 | 7 | 28853 | 19 | |||
| 100115 | 91632 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1540 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007748.949212 | 2100776.810346 | 37.748770868614 | -122.415985622241 | (37.748770868614, -122.415985622241) | 2 | 4 | 7 | 28859 | 19 | |||
| 106851 | 90892 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1543 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990781.4854 | 2110598.61863 | 37.7747703727015 | -122.475375427468 | (37.7747703727015, -122.475375427468) | 11 | 6 | 2 | 54 | 26 | ||
| 39500 | 32941 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1546 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | Permit Number 37260 | 6013066.21805 | 2105223.63069 | 37.7612783887065 | -122.397910300117 | (37.7612783887065, -122.397910300117) | 10 | 3 | 8 | 28856 | 29 | |
| 125452 | 196979 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.397014079838 | (37.7599198521353, -122.397014079838) | 10 | 3 | 8 | 28856 | 29 | |||
| 160886 | 196978 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6013296.03231 | 2104723.49575 | 37.7599179239891 | -122.397080394946 | (37.7599179239891, -122.397080394946) | 10 | 3 | 8 | 28856 | 29 | |||
| 105176 | 88473 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1554 Jerrold Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51426 | 6015626.2 | 2096846 | 37.7384174065816 | -122.388471555996 | (37.7384174065816, -122.388471555996) | 10 | 3 | 8 | 58 | 1 | |||
| 150853 | 34256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.39441 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | 11 | 6 | 1 | 54 | 11 | |
| 171562 | 88315 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 157 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51306 | 6004192.4 | 2092727.9 | 37.7264697879052 | -122.427710754996 | (37.7264697879052, -122.427710754996) | 9 | 7 | 6 | 28861 | 5 | |||
| 23399 | 101632 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 46025 | 101631 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 77304 | 101627 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 86262 | 101634 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 93279 | 101630 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | |
| 104346 | 101628 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 132977 | 101633 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 193442 | 101629 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
| 123373 | 88498 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1599 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | 10 | 3 | 8 | 58 | 1 | ||
| 74147 | 88499 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1599@ Lane Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 109700 | 89324 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2008 12:00:00 AM | 3x3 | Permit Number 51914 | 6010434.1 | 2094994.4 | 37.7330442175155 | -122.40629297735 | (37.7330442175155, -122.40629297735) | 10 | 3 | 7 | 309 | 28 | |||
| 193922 | 179281 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010435.48171 | 2094947.68687 | 37.7329160304499 | -122.406284910247 | (37.7329160304499, -122.406284910247) | 10 | 3 | 7 | 309 | 28 | |||
| 123918 | 34257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39597 | 5993997.84726 | 2114498.92628 | 37.7856654774057 | -122.464532720679 | (37.7856654774057, -122.464532720679) | 11 | 6 | 1 | 54 | 11 | |
| 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 | ||
| 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 | |||
| 62748 | 196988 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
| 111720 | 196987 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
| 141990 | 196989 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
| 146245 | 196984 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
| 168607 | 196986 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
| 170158 | 196985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
| 176314 | 196982 | 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 | |||
| 61090 | 104044 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 70 | 9x9 | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
| 80922 | 104045 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 144340 | 43686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.79836 | 2114426.59889 | 37.785431180637 | -122.46666917492 | (37.785431180637, -122.46666917492) | 11 | 6 | 2 | 54 | 11 | |
| 97177 | 82510 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 162 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52478 | 6009746.4088 | 2094920.98232 | 37.7328041358849 | -122.408665340153 | (37.7328041358849, -122.408665340153) | 10 | 3 | 7 | 309 | 28 | |
| 43779 | 89201 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1627 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371 | 2111438 | 37.7776832317385 | -122.438804361006 | (37.7776832317385, -122.438804361006) | 15 | 5 | 11 | 29492 | 41 | |||
| 157100 | 122016 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.7747259547528 | -122.476394881461 | (37.7747259547528, -122.476394881461) | 11 | 6 | 2 | 55 | 26 | |||
| 74281 | 34259 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.464534489449 | (37.7855927810379, -122.464534489449) | 11 | 6 | 1 | 54 | 11 | |
| 55070 | 90888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.38922 | 2110587.78256 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | 11 | 6 | 2 | 55 | 26 | ||
| 55570 | 100314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | 10 | 3 | 8 | 58 | 1 | |||
| 186419 | 100315 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015443.91077 | 2097940.33755 | 37.7414121299803 | -122.389178220304 | (37.7414121299803, -122.389178220304) | 10 | 3 | 8 | 58 | 1 | |||
| 74482 | 91579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.782992 | 37.7706855226421 | -122.418025303656 | (37.7706855226421, -122.418025303656) | 8 | 2 | 9 | 28853 | 19 | |||
| 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 | ||
| 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 | ||
| 79595 | 90884 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.90659 | 37.7746647760157 | -122.477624799049 | (37.7746647760157, -122.477624799049) | 11 | 6 | 2 | 55 | 26 | ||
| 109816 | 241388 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003420.97531 | 2097978.60034 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | 2 | 7 | 5 | 63 | 7 | |||
| 60643 | 89323 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 18 Hale St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2008 12:00:00 AM | 3x3 | Permit Number 51913 | 6010478.7 | 2094954.8 | 37.7329379790561 | -122.406135993698 | (37.7329379790561, -122.406135993698) | 10 | 3 | 7 | 309 | 28 | |||
| 155023 | 80092 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.7988960100912 | -122.429310324527 | (37.7988960100912, -122.429310324527) | 13 | 9 | 1 | 57 | 17 | |
| 169587 | 83336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004282.92403 | 2119104.69719 | 37.7988992854406 | -122.429277851819 | (37.7988992854406, -122.429277851819) | 13 | 9 | 1 | 57 | 17 | |
| 140091 | 88138 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 181 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804 | 2097893 | 37.7403456543781 | -122.446709627058 | (37.7403456543781, -122.446709627058) | 9 | 7 | 4 | 59 | 40 | |||
| 77851 | 90569 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.28238 | 2110623.46415 | 37.7747886345028 | -122.478356290001 | (37.7747886345028, -122.478356290001) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 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 | |||
| 62144 | 65529 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | 11 | 6 | 2 | 55 | 26 | ||
| 48428 | 90571 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989655.61233 | 2110613.51621 | 37.7747459519392 | -122.479271100153 | (37.7747459519392, -122.479271100153) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 88525 | 90879 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.02381 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | 11 | 6 | 2 | 55 | 26 | ||
| 42514 | 90572 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989583.92326 | 2110610.46088 | 37.7747333989447 | -122.479518860914 | (37.7747333989447, -122.479518860914) | 11 | 6 | 2 | 55 | 26 | ||
| 23421 | 90874 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1941 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989523.27614 | 2110553.23403 | 37.7745727468597 | -122.479724461021 | (37.7745727468597, -122.479724461021) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 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 | ||
| 124252 | 88468 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1950 Donner Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51422 | 6011569.2 | 2093583.7 | 37.7292341601061 | -122.402269464083 | (37.7292341601061, -122.402269464083) | 10 | 3 | 8 | 58 | 1 | |||
| 67177 | 241335 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 20599 | 196997 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 11 | : | Tree | Private 2 | 7 | Width 4ft | 6013762.67186 | 2100131.60985 | 37.7473355578075 | -122.395144856947 | (37.7473355578075, -122.395144856947) | 10 | 3 | 8 | 58 | 1 | |||
| 70671 | 196993 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 6 | : | Tree | Private 2 | 7 | Width 4ft | 6013912.09606 | 2100139.02388 | 37.7473642236913 | -122.394628673985 | (37.7473642236913, -122.394628673985) | 10 | 3 | 8 | 58 | 1 | |||
| 88076 | 196990 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.393830644379 | (37.7474110756645, -122.393830644379) | 10 | 3 | 8 | 58 | 1 | |||
| 92182 | 196991 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6014086.84637 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | 10 | 3 | 8 | 58 | 1 | |||
| 97589 | 196999 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 14 | : | Tree | Private 2 | 4 | Width 4ft | 6013629.21679 | 2100123.8728 | 37.7473068910098 | -122.395605796394 | (37.7473068910098, -122.395605796394) | 10 | 3 | 8 | 58 | 1 | |||
| 121622 | 197000 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 15 | : | Tree | Private 2 | 6 | Width 4ft | 6013614.06576 | 2100123.51682 | 37.7473050707808 | -122.395658162994 | (37.7473050707808, -122.395658162994) | 10 | 3 | 8 | 58 | 1 | |||
| 124135 | 196995 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 8 | : | Tree | Private 2 | 8 | Width 4ft | 6013853.97089 | 2100136.72086 | 37.7473546683845 | -122.394829506973 | (37.7473546683845, -122.394829506973) | 10 | 3 | 8 | 58 | 1 | |||
| 148421 | 196998 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 13 | : | Tree | Private 2 | 5 | Width 4ft | 6013702.50003 | 2100126.86267 | 37.7473191766464 | -122.395352595851 | (37.7473191766464, -122.395352595851) | 10 | 3 | 8 | 58 | 1 | |||
| 184445 | 196996 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | 10 | 3 | 8 | 58 | 1 | |||
| 193907 | 196992 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 5 | : | Tree | Private 2 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.7473701394162 | -122.394524516312 | (37.7473701394162, -122.394524516312) | 10 | 3 | 8 | 58 | 1 | |||
| 22012 | 90575 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2008 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989345.62252 | 2110602.70137 | 37.7746982485552 | -122.480342614213 | (37.7746982485552, -122.480342614213) | 11 | 6 | 2 | 55 | 26 | ||
| 40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
| 60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
| 15597 | 91581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
| 95941 | 91580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
| 23759 | 95623 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 201 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767388 | 6007162.9 | 2106147.3 | 37.7634840327412 | -122.418392924595 | (37.7634840327412, -122.418392924595) | 8 | 4 | 7 | 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) );