trees
861 rows where qSpecies_id = 18 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 46343 | 89117 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 727 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990344.4993 | 2110412.80162 | 37.7742348306427 | -122.476873456227 | (37.7742348306427, -122.476873456227) | 11 | 6 | 2 | 55 | 26 | ||
| 46641 | 191352 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015101.55033 | 2107682.63159 | 37.7681434121179 | -122.391042763138 | (37.7681434121179, -122.391042763138) | 14 | 3 | 9 | 310 | 20 | |||
| 46941 | 89426 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2550X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990714.58322 | 2112013.96736 | 37.7786526533285 | -122.475710228678 | (37.7786526533285, -122.475710228678) | 11 | 6 | 2 | 54 | 26 | ||
| 47462 | 247480 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.7728446187699 | -122.434043773953 | (37.7728446187699, -122.434043773953) | 15 | 5 | 11 | 29492 | 9 | |||
| 47953 | 105316 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | ||||
| 48071 | 108754 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200x Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012760.63999 | 2087707.78234 | 37.7131665099896 | -122.397738543111 | (37.7131665099896, -122.397738543111) | 10 | 3 | 8 | 309 | 1 | |||
| 48303 | 115988 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.403255425209 | (37.7963995082912, -122.403255425209) | 3 | 1 | 10 | 28860 | 4 | |
| 48341 | 191313 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015141.50158 | 2107991.42305 | 37.7689935025667 | -122.390926158818 | (37.7689935025667, -122.390926158818) | 14 | 3 | 9 | 310 | 20 | |||
| 48383 | 129395 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3383 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998662.11007 | 2115556.58452 | 37.7888373034598 | -122.448471976104 | (37.7888373034598, -122.448471976104) | 13 | 6 | 1 | 54 | 31 | |||
| 48510 | 207092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991411.79539 | 2097355.25398 | 37.738444095618 | -122.4722295024 | (37.738444095618, -122.4722295024) | 1 | 8 | 4 | 29491 | 40 | |||
| 48527 | 4552 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.427279741881 | (37.7839147367985, -122.427279741881) | 7 | 9 | 11 | 28858 | 41 | |||
| 49037 | 183441 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2434 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989549.5958 | 2098772.4148 | 37.7422273048614 | -122.478771630638 | (37.7422273048614, -122.478771630638) | 1 | 8 | 3 | 29491 | 35 | |||
| 49081 | 191346 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015085.76507 | 2107965.02098 | 37.7689179154613 | -122.391117103785 | (37.7689179154613, -122.391117103785) | 14 | 3 | 9 | 310 | 20 | |||
| 49095 | 105027 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x6 | 6015075.47854 | 2108137.72551 | 37.7693915533068 | -122.391164757946 | (37.7693915533068, -122.391164757946) | 14 | 3 | 9 | 310 | 20 | |||
| 49133 | 81638 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.401916029713 | (37.7237978701092, -122.401916029713) | 10 | 3 | 7 | 309 | 28 | ||
| 49165 | 227649 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.443080347989 | (37.7597108865789, -122.443080347989) | 2 | 4 | 5 | 28862 | 3 | |||
| 49177 | 176922 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003957.47292 | 2089506.69936 | 37.7176117887305 | -122.428293410708 | (37.7176117887305, -122.428293410708) | 9 | 7 | 6 | 28861 | 5 | |||
| 49373 | 200112 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263 | -122.391053863847 | (37.726602519263, -122.391053863847) | 10 | 3 | 8 | 58 | 1 | |||
| 50235 | 191277 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014120.49796 | 2110919.75939 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | 6 | 2 | 9 | 28856 | 20 | |||
| 50505 | 89071 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 606 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990364.94891 | 2111219.79426 | 37.7764517969468 | -122.476861693703 | (37.7764517969468, -122.476861693703) | 11 | 6 | 2 | 55 | 26 | ||
| 50537 | 200113 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | 10 | 3 | 8 | 58 | 1 | |||
| 50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
| 50767 | 227610 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6006250.04952 | 2097648.94567 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | 2 | 7 | 7 | 28859 | 2 | ||||
| 50918 | 227611 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6008811.16325 | 2101739.45031 | 37.751473726132 | -122.412380510571 | (37.751473726132, -122.412380510571) | 2 | 4 | 7 | 28859 | 19 | |||
| 51145 | 114219 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 31 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012347.17965 | 2087849.72367 | 37.7135332193584 | -122.399177569 | (37.7135332193584, -122.399177569) | 10 | 3 | 8 | 309 | 1 | |||
| 51303 | 200000 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | 10 | 3 | 8 | 58 | 1 | |||
| 51411 | 99394 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 17 | 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 | ||
| 51545 | 103458 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 212 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769919 | 5999039.39992 | 2115859.35215 | 37.7896901880985 | -122.447188409728 | (37.7896901880985, -122.447188409728) | 13 | 6 | 1 | 29490 | 31 | |
| 51728 | 191273 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014193.41583 | 2110841.84159 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | 6 | 2 | 9 | 28856 | 20 | |||
| 51842 | 191319 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015133.57873 | 2108141.42692 | 37.7694049406179 | -122.390964049067 | (37.7694049406179, -122.390964049067) | 14 | 3 | 9 | 310 | 20 | |||
| 52238 | 244059 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.448006327683 | (37.7708917674934, -122.448006327683) | 15 | 5 | 11 | 29492 | 9 | |||
| 52515 | 191285 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.3938874078 | (37.776017035092, -122.3938874078) | 6 | 2 | 9 | 310 | 20 | |||
| 53743 | 98180 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 622 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768099 | 6007169.16242 | 2091641.99398 | 37.7236560602499 | -122.417343266399 | (37.7236560602499, -122.417343266399) | 9 | 7 | 7 | 309 | 28 | |
| 54124 | 129398 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3729 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997021.62902 | 2114999.75252 | 37.7872144597187 | -122.454107547129 | (37.7872144597187, -122.454107547129) | 11 | 6 | 1 | 54 | 31 | |||
| 54279 | 102559 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 6 | 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 | ||||
| 54297 | 227624 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4283 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002006.21213 | 2101168.55205 | 37.7495219535904 | -122.435871975115 | (37.7495219535904, -122.435871975115) | 2 | 4 | 5 | 28862 | 22 | |||
| 54762 | 89072 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 578 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990352.95655 | 2111441.21881 | 37.7770590720957 | -122.47691936106 | (37.7770590720957, -122.47691936106) | 11 | 6 | 2 | 55 | 26 | ||
| 55623 | 120374 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 433 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5988073.52579 | 2113031.79545 | 37.7812938539051 | -122.484921243675 | (37.7812938539051, -122.484921243675) | 11 | 6 | 2 | 55 | 26 | |||
| 55735 | 227590 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 33 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005514.01431 | 2098729.37498 | 37.7430231709906 | -122.423568480604 | (37.7430231709906, -122.423568480604) | 2 | 7 | 5 | 28859 | 22 | |||
| 55769 | 176926 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200 Morse St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6000586.22066 | 2087873.89241 | 37.7129371316064 | -122.439829268227 | (37.7129371316064, -122.439829268227) | 9 | 7 | 6 | 28861 | 5 | |||
| 55950 | 200104 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.390452952009 | (37.726258938018, -122.390452952009) | 10 | 3 | 8 | 58 | 1 |
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) );