trees
861 rows where qSpecies_id = 18
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25573 | 227644 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3801 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003004.72038 | 2103560.48994 | 37.7561463193185 | -122.432589939789 | (37.7561463193185, -122.432589939789) | 2 | 4 | 5 | 28862 | 22 | |||
| 25613 | 37524 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1154 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779577 | 6007313.66795 | 2115327.60271 | 37.7886994328701 | -122.418522478123 | (37.7886994328701, -122.418522478123) | 13 | 9 | 10 | 28858 | 21 |
| 25784 | 99395 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 26105 | 111098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.7876092819021 | -122.414263235869 | (37.7876092819021, -122.414263235869) | 5 | 1 | 10 | 28858 | 21 | ||
| 26392 | 207081 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1967 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992237.02413 | 2102091.85973 | 37.7514973270376 | -122.469721026126 | (37.7514973270376, -122.469721026126) | 1 | 8 | 4 | 29491 | 12 | |||
| 26449 | 37034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 266 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.425773019549 | (37.7422146471398, -122.425773019549) | 2 | 7 | 5 | 63 | 22 | ||
| 26534 | 227625 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4283 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002039.82763 | 2101169.84079 | 37.749527401673 | -122.435755824069 | (37.749527401673, -122.435755824069) | 2 | 4 | 5 | 28862 | 22 | |||
| 26676 | 176934 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 52 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012523.28008 | 2087764.2105 | 37.7133082296521 | -122.398562902163 | (37.7133082296521, -122.398562902163) | 10 | 3 | 8 | 309 | 1 | |||
| 26722 | 176965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 327 Craut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 6004071.24912 | 2093653.41815 | 37.7290042007626 | -122.428195498837 | (37.7290042007626, -122.428195498837) | 9 | 7 | 6 | 28861 | 5 | |||
| 26767 | 129422 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003322.87221 | 2117886.87369 | 37.7955010594859 | -122.432512912861 | (37.7955010594859, -122.432512912861) | 13 | 9 | 1 | 29490 | 27 | |||
| 27188 | 227606 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | 2 | 7 | 5 | 28861 | 2 | ||||
| 27439 | 227588 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 435 Oak St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6004887.16184 | 2110182.76224 | 37.7744360692067 | -122.42655134748 | (37.7744360692067, -122.42655134748) | 7 | 9 | 11 | 28852 | 10 | |||
| 27460 | 89673 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2605 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990503.98311 | 2111947.71017 | 37.7784585176582 | -122.476433926742 | (37.7784585176582, -122.476433926742) | 11 | 6 | 2 | 55 | 26 | ||
| 27516 | 97113 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1345 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 18860 | 5989785.9448 | 2103084.5073 | 37.7540808992005 | -122.478269637351 | (37.7540808992005, -122.478269637351) | 1 | 8 | 3 | 56 | 35 | |||
| 27627 | 200009 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.7259609644208 | -122.381063162948 | (37.7259609644208, -122.381063162948) | 10 | 3 | 8 | 58 | 1 | |||
| 27980 | 191314 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015140.28305 | 2108016.70866 | 37.7690628636861 | -122.390932141124 | (37.7690628636861, -122.390932141124) | 14 | 3 | 9 | 310 | 20 | |||
| 28352 | 102555 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
| 28569 | 227599 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3542 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005268.27661 | 2106072.00608 | 37.7631704570704 | -122.424940469222 | (37.7631704570704, -122.424940469222) | 8 | 4 | 5 | 28859 | 19 | |||
| 29176 | 129412 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003281.29754 | 2115999.00202 | 37.790315090121 | -122.432521856625 | (37.790315090121, -122.432521856625) | 13 | 9 | 1 | 29490 | 27 | |||
| 29211 | 89090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 411 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990267.41171 | 2112525.37211 | 37.7800308943669 | -122.477294535249 | (37.7800308943669, -122.477294535249) | 11 | 6 | 2 | 55 | 26 | ||
| 29337 | 191321 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015124.16384 | 2108316.28371 | 37.7698845364842 | -122.391008838006 | (37.7698845364842, -122.391008838006) | 14 | 3 | 9 | 310 | 20 | |||
| 29417 | 27607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001133.4058 | 2111053.0447 | 37.7766127217509 | -122.439598674592 | (37.7766127217509, -122.439598674592) | 15 | 5 | 11 | 29492 | 10 | |||
| 30144 | 129421 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447999 | (37.795493917972, -122.43256447999) | 13 | 9 | 1 | 29490 | 27 | |||
| 30355 | 89427 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2550 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990691.39312 | 2112012.68258 | 37.7786477812116 | -122.475790357508 | (37.7786477812116, -122.475790357508) | 11 | 6 | 2 | 54 | 26 | ||
| 30654 | 89103 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 625 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990317.85123 | 2111122.02756 | 37.7761806243316 | -122.477017470561 | (37.7761806243316, -122.477017470561) | 11 | 6 | 2 | 55 | 26 | ||
| 31086 | 191288 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014381.59657 | 2110521.77598 | 37.7758990935001 | -122.39373177471 | (37.7758990935001, -122.39373177471) | 6 | 2 | 9 | 310 | 20 | |||
| 31088 | 142250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | 7 | 9 | 11 | 28852 | 10 | |||
| 31268 | 30586 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481 | (37.7726573855875, -122.43410610481) | 15 | 5 | 11 | 29492 | 9 | |
| 31289 | 89069 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 622 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990366.55326 | 2111125.77489 | 37.7761937387005 | -122.476849272694 | (37.7761937387005, -122.476849272694) | 11 | 6 | 2 | 55 | 26 | ||
| 31466 | 45705 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2919 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44379 | 6009358.73784624 | 2102738.93586586 | 37.754248802934 | -122.410557495705 | (37.754248802934, -122.410557495705) | 2 | 4 | 7 | 28859 | 19 | ||
| 31494 | 4538 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 31563 | 227640 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3300X 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006270.9018 | 2103197.69782 | 37.7553348592182 | -122.421268598461 | (37.7553348592182, -122.421268598461) | 2 | 4 | 5 | 28859 | 19 | |||
| 31738 | 207091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 520 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991320.33113 | 2097065.30066 | 37.7376426638631 | -122.47252460502 | (37.7376426638631, -122.47252460502) | 1 | 8 | 4 | 29491 | 40 | |||
| 31742 | 191316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015137.82836 | 2108066.41916 | 37.7691992215952 | -122.390944106589 | (37.7691992215952, -122.390944106589) | 14 | 3 | 9 | 310 | 20 | |||
| 31849 | 129400 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3766 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5996779.47393 | 2115339.45033 | 37.7881332907605 | -122.454969901653 | (37.7881332907605, -122.454969901653) | 11 | 6 | 1 | 54 | 31 | |||
| 32476 | 227594 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005345.94103 | 2107798.56704 | 37.7679155688764 | -122.424794690941 | (37.7679155688764, -122.424794690941) | 8 | 4 | 5 | 28853 | 19 | |||
| 32655 | 25179 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3226 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999420.68533 | 2104753.24612 | 37.7592174321694 | -122.445070446966 | (37.7592174321694, -122.445070446966) | 2 | 4 | 5 | 28862 | 3 | ||
| 32692 | 191309 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015155.38149 | 2107742.43002 | 37.768310592479 | -122.390860744836 | (37.768310592479, -122.390860744836) | 14 | 3 | 9 | 310 | 20 | |||
| 32742 | 227643 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3801 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002989.53011 | 2103560.80368 | 37.7561463193257 | -122.432642495251 | (37.7561463193257, -122.432642495251) | 2 | 4 | 5 | 28862 | 22 | |||
| 32806 | 89664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2801X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989889.68723 | 2111928.16653 | 37.77836921046 | -122.478557554871 | (37.77836921046, -122.478557554871) | 11 | 6 | 2 | 55 | 26 | ||
| 32862 | 102563 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
| 33337 | 108294 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | |||
| 33411 | 227589 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 23 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006036.6609 | 2100222.07218 | 37.7471512660344 | -122.42186731675 | (37.7471512660344, -122.42186731675) | 2 | 7 | 5 | 28859 | 22 | |||
| 33798 | 191304 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015169.51274 | 2107473.76779 | 37.7675736888995 | -122.390793087953 | (37.7675736888995, -122.390793087953) | 14 | 3 | 9 | 310 | 20 | |||
| 34048 | 176951 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 63 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012562.34064 | 2087723.35892 | 37.7131982353775 | -122.398425029786 | (37.7131982353775, -122.398425029786) | 10 | 3 | 8 | 309 | 1 | |||
| 34535 | 176943 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 19 Lois Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012322.95001 | 2087866.52725 | 37.7135780083003 | -122.399262494668 | (37.7135780083003, -122.399262494668) | 10 | 3 | 8 | 309 | 1 | |||
| 34539 | 245954 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.449203198504 | (37.7671425117336, -122.449203198504) | 15 | 5 | 11 | 29492 | 9 | |||
| 34923 | 207085 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2091 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993168.90781 | 2101284.15218 | 37.7493333873359 | -122.466439786693 | (37.7493333873359, -122.466439786693) | 1 | 8 | 4 | 29491 | 12 | |||
| 35676 | 66298 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2920 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1990 12:00:00 AM | 6 | 3x3 | Permit Number 29409 | 6014606.2975 | 2089345.5816 | 37.7177661944335 | -122.391473700889 | (37.7177661944335, -122.391473700889) | 10 | 3 | 8 | 58 | 1 | |
| 35814 | 51087 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.420299857748 | (37.7966452201661, -122.420299857748) | 13 | 9 | 10 | 28858 | 32 | ||
| 35863 | 99398 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 36210 | 102562 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
| 36272 | 108295 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
| 36673 | 129452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.8031318169312 | -122.417485363758 | (37.8031318169312, -122.417485363758) | 5 | 1 | 1 | 308 | 32 | |||
| 36949 | 227666 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.7728946968577 | -122.421599203664 | (37.7728946968577, -122.421599203664) | 8 | 2 | 9 | 28853 | 19 | |||
| 37272 | 31363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2295 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1995 12:00:00 AM | 2 | Permit Number 34969 | 5991013.00778 | 2099881.4668 | 37.7453573397732 | -122.473792544798 | (37.7453573397732, -122.473792544798) | 1 | 8 | 4 | 29491 | 40 | ||
| 37373 | 48451 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.7839652911282 | -122.457709472605 | (37.7839652911282, -122.457709472605) | 11 | 6 | 1 | 54 | 31 | ||
| 37381 | 207050 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | 11 | 8 | 3 | 56 | 12 | |||
| 38362 | 35009 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | 15 | 6 | 1 | 29490 | 31 | ||
| 38814 | 207094 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Kenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994559.61163 | 2093655.13931 | 37.7284661597625 | -122.461077839771 | (37.7284661597625, -122.461077839771) | 9 | 8 | 4 | 59 | 40 | |||
| 38886 | 129431 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004108.39045 | 2116309.70837 | 37.7912150785667 | -122.429682343483 | (37.7912150785667, -122.429682343483) | 13 | 9 | 1 | 29490 | 27 | |||
| 39091 | 191280 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014475.48285 | 2110565.83203 | 37.7760252782883 | -122.393410079138 | (37.7760252782883, -122.393410079138) | 6 | 2 | 9 | 28856 | 20 | |||
| 39235 | 191325 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015118.6002 | 2108416.53972 | 37.7701595086914 | -122.391035090994 | (37.7701595086914, -122.391035090994) | 14 | 3 | 9 | 310 | 20 | |||
| 39314 | 117939 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 6300 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5983833.68211 | 2109720.90427 | 37.7719552435785 | -122.499344054001 | (37.7719552435785, -122.499344054001) | 11 | 6 | 2 | 55 | 26 | |||
| 39393 | 129411 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003275.40801 | 2116033.98168 | 37.7904108013651 | -122.432544733549 | (37.7904108013651, -122.432544733549) | 13 | 9 | 1 | 29490 | 27 | |||
| 39525 | 89670 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2643 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990382.48871 | 2111946.22044 | 37.7784473803471 | -122.476854108344 | (37.7784473803471, -122.476854108344) | 11 | 6 | 2 | 55 | 26 | ||
| 39834 | 89433 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2750X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990101.18873 | 2111991.79472 | 37.7785561929756 | -122.477830552774 | (37.7785561929756, -122.477830552774) | 11 | 6 | 2 | 55 | 26 | ||
| 40480 | 227628 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4222 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001065.76771 | 2102912.44614 | 37.7542567996348 | -122.43924903191 | (37.7542567996348, -122.43924903191) | 2 | 4 | 5 | 28862 | 22 | |||
| 40522 | 182960 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5990064.3236 | 2098390.6107 | 37.7412088438098 | -122.476963988193 | (37.7412088438098, -122.476963988193) | 1 | 8 | 3 | 29491 | 35 | |||
| 40637 | 31733 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) | 1 | 8 | 3 | 29491 | 35 |
| 41237 | 191340 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015061.94317 | 2108389.30473 | 37.7700815833249 | -122.39122916471 | (37.7700815833249, -122.39122916471) | 14 | 3 | 9 | 310 | 20 | |||
| 41389 | 191296 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014597.30582 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | 6 | 2 | 9 | 310 | 20 | |||
| 41576 | 207097 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 451 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.95126 | 2096408.69413 | 37.7361138982453 | -122.456034797893 | (37.7361138982453, -122.456034797893) | 9 | 7 | 4 | 59 | 40 | |||
| 41810 | 191276 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.7769306051104 | -122.394602513603 | (37.7769306051104, -122.394602513603) | 6 | 2 | 9 | 28856 | 20 | |||
| 42036 | 1713 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085 | -122.40074798855 | (37.796643729085, -122.40074798855) | 3 | 1 | 10 | 28860 | 4 | |||
| 42195 | 1714 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.7965506870182 | -122.400732648813 | (37.7965506870182, -122.400732648813) | 3 | 1 | 10 | 28860 | 4 | |||
| 42307 | 4533 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 45 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2016 03:02:00 PM | 6 | 5x5 | 6005057.0165 | 2113679.5647 | 37.7840470307287 | -122.42621279071 | (37.7840470307287, -122.42621279071) | 7 | 9 | 11 | 28858 | 41 | ||
| 42397 | 4516 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
| 42693 | 105034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
| 42904 | 31734 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005 | 2098357 | 37.7411131158778 | -122.477166650257 | (37.7411131158778, -122.477166650257) | 1 | 8 | 3 | 29491 | 35 | ||
| 43158 | 227617 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | 10 | 7 | 7 | 28859 | 2 | |||
| 43491 | 89431 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2650 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990408.54993 | 2112000.5588 | 37.7785980902022 | -122.476767924851 | (37.7785980902022, -122.476767924851) | 11 | 6 | 2 | 55 | 26 | ||
| 43790 | 176958 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 214 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012631.12356 | 2087648.56031 | 37.7129966847253 | -122.398182046487 | (37.7129966847253, -122.398182046487) | 10 | 3 | 8 | 309 | 1 | |||
| 43874 | 20250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1880 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6002537.9918 | 2114673.3066 | 37.7866328903431 | -122.434998786713 | (37.7866328903431, -122.434998786713) | 13 | 9 | 11 | 29490 | 27 | |||
| 43906 | 227618 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009077.39378 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | 10 | 7 | 7 | 28859 | 2 | |||
| 44002 | 191344 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015083.27036 | 2108014.27768 | 37.7690530250991 | -122.39112917627 | (37.7690530250991, -122.39112917627) | 14 | 3 | 9 | 310 | 20 | |||
| 44144 | 207062 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.466751760605 | (37.7435731145127, -122.466751760605) | 1 | 8 | 4 | 29491 | 40 | |||
| 44221 | 176952 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.7132316640827 | -122.398126845197 | (37.7132316640827, -122.398126845197) | 10 | 3 | 8 | 309 | 1 | |||
| 44408 | 37644 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.46053 | 2111993.16181 | 37.7785610650821 | -122.477763984945 | (37.7785610650821, -122.477763984945) | 11 | 6 | 2 | 55 | 26 | |
| 44640 | 46211 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.432615424763 | (37.7915512424562, -122.432615424763) | 13 | 9 | 1 | 29490 | 27 | ||
| 44766 | 227650 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000006.33119 | 2104908.86672 | 37.759678136856 | -122.443056184107 | (37.759678136856, -122.443056184107) | 2 | 4 | 5 | 28862 | 3 | |||
| 44775 | 227659 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003786.3248 | 2109251.28052 | 37.771816154325 | -122.430292880621 | (37.771816154325, -122.430292880621) | 7 | 9 | 11 | 29492 | 10 | |||
| 44928 | 38574 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | 10 | 3 | 8 | 58 | 1 | |
| 45087 | 114222 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 2x2 | 6012512.59554 | 2087744.07842 | 37.7132523556976 | -122.398598420002 | (37.7132523556976, -122.398598420002) | 10 | 3 | 8 | 309 | 1 | |||
| 45106 | 246316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | 8 | 2 | 9 | 28853 | 19 | |||
| 45487 | 89055 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 788 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.29878 | 2110035.18225 | 37.7732014599794 | -122.476639007633 | (37.7732014599794, -122.476639007633) | 11 | 6 | 2 | 55 | 26 | ||
| 45765 | 99380 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
| 45814 | 89086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 406 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990312.19916 | 2112568.90758 | 37.7801530292127 | -122.477142779252 | (37.7801530292127, -122.477142779252) | 11 | 6 | 2 | 55 | 26 | ||
| 46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
| 46340 | 129439 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010043.54378 | 2115756.33064 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | 5 | 1 | 10 | 28857 | 21 |
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) );