trees
614 rows where qSpecies_id = 29 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51 | 137691 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | 15 | 5 | 11 | 54 | 16 | ||
799 | 72078 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | 11 | 6 | 2 | 55 | 26 | ||
1858 | 124541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | 11 | 6 | 2 | 54 | 11 | |||
2004 | 73758 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.03882 | 2110577.4842 | 37.7745911237516 | -122.482594698718 | (37.7745911237516, -122.482594698718) | 11 | 6 | 2 | 55 | 26 | |||
2407 | 38882 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | 11 | 6 | 1 | 54 | 31 | ||
2638 | 32596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1474 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.7596132973579 | -122.492881221287 | (37.7596132973579, -122.492881221287) | 1 | 8 | 3 | 56 | 35 | |
2740 | 74867 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997417.18704 | 2116038.42588 | 37.7900890536146 | -122.452814005488 | (37.7900890536146, -122.452814005488) | 11 | 6 | 1 | 54 | 31 | |||
2771 | 240393 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Hill St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6006109.51353 | 2103440.58038 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | 2 | 4 | 5 | 28859 | 19 | |||
2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
3428 | 37647 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | 11 | 6 | 2 | 54 | 11 | ||
3822 | 74719 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997437.82689 | 2116041.06971 | 37.7900974955643 | -122.452742784551 | (37.7900974955643, -122.452742784551) | 11 | 6 | 1 | 54 | 31 | |||
4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
4031 | 73753 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | 11 | 6 | 2 | 55 | 26 | |||
5097 | 37962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.39431 | 2106347.66255 | 37.7644148813545 | -122.394872214003 | (37.7644148813545, -122.394872214003) | 14 | 3 | 8 | 28856 | 29 | |
5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
6569 | 82802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | 11 | 6 | 2 | 55 | 26 | ||
7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
8281 | 87805 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | 13 | 9 | 1 | 57 | 17 | |||
8833 | 240424 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 6 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.433987315365 | (37.7363966594644, -122.433987315365) | 2 | 7 | 5 | 63 | 7 | |||
9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
10754 | 41218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431 | (37.8011293999489, -122.43745640431) | 13 | 9 | 1 | 57 | 17 | |
11342 | 141053 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 196 PARKER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | Width 0ft | 5996969.9558 | 2113061.6744 | 37.7818900483272 | -122.45414629098 | (37.7818900483272, -122.45414629098) | 11 | 6 | 1 | 54 | 31 | ||
11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
12126 | 184960 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | 1 | 8 | 3 | 29491 | 35 | |||
12169 | 70387 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003118.96111 | 2094567.61018 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | 9 | 7 | 5 | 28861 | 25 | |||
12537 | 54837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.7743590132093 | -122.447906287477 | (37.7743590132093, -122.447906287477) | 15 | 5 | 11 | 29492 | 16 | |
12760 | 32019 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 900 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.400057399946 | (37.7704413522571, -122.400057399946) | 14 | 2 | 8 | 28856 | 20 | |||
13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
13360 | 75003 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997399.30482 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | 11 | 6 | 1 | 54 | 31 | |||
13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
13949 | 70219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999766.96115 | 2119470.28489 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | 13 | 9 | 1 | 57 | 17 | |||
13999 | 73403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003121.92331 | 2094558.5911 | 37.7314358416937 | -122.43154198317 | (37.7314358416937, -122.43154198317) | 9 | 7 | 5 | 28861 | 25 | |||
14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
14387 | 181350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.7452110255779 | -122.48221942867 | (37.7452110255779, -122.48221942867) | 1 | 8 | 3 | 29491 | 35 | |||
15577 | 61446 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | 11 | 6 | 2 | 55 | 26 | |
15621 | 68830 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32781 | 6000000.33338592 | 2094041.19205625 | 37.7298377607142 | -122.442296747396 | (37.7298377607142, -122.442296747396) | 9 | 7 | 4 | 63 | 40 | ||
15733 | 64781 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | 4 | Permit Number 25773 | 5983728.64713 | 2111021.26009 | 37.7755194830569 | -122.499803502734 | (37.7755194830569, -122.499803502734) | 11 | 6 | 2 | 55 | 26 | |
16030 | 72309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3555 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997281.41005 | 2116017.68654 | 37.7900243276015 | -122.453282282457 | (37.7900243276015, -122.453282282457) | 11 | 6 | 1 | 54 | 31 | |||
16441 | 32611 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | 1 | 8 | 3 | 56 | 35 | |
16645 | 74566 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997456.57692 | 2116043.58234 | 37.7901054689466 | -122.452678092717 | (37.7901054689466, -122.452678092717) | 11 | 6 | 1 | 54 | 31 | |||
16909 | 38635 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 33 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
16920 | 78303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985601.84615 | 2111830.05832 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | 11 | 6 | 2 | 55 | 26 | |||
17790 | 181349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987333.026 | 2099936.24 | 37.7452939056167 | -122.486521176816 | (37.7452939056167, -122.486521176816) | 1 | 8 | 3 | 29491 | 35 | |||
18659 | 68867 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 123 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 32831 | 5999260.75597787 | 2093758.61799029 | 37.7290196985316 | -122.444833238065 | (37.7290196985316, -122.444833238065) | 9 | 7 | 4 | 28861 | 40 | ||
18662 | 72377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | 11 | 6 | 2 | 55 | 26 | |||
19085 | 70121 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988662.20068 | 2110577.24438 | 37.7745886129839 | -122.482704814222 | (37.7745886129839, -122.482704814222) | 11 | 6 | 2 | 55 | 26 | |||
20030 | 81327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | 13 | 9 | 1 | 57 | 17 | |
20270 | 41769 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
20373 | 122290 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990062.61204 | 2111318.02169 | 37.7767039596239 | -122.477914733898 | (37.7767039596239, -122.477914733898) | 11 | 6 | 2 | 55 | 26 | |||
20573 | 122277 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | 11 | 6 | 2 | 55 | 26 | |||
20719 | 32859 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | 2 | 4 | 5 | 28862 | 22 | |||
20853 | 33056 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
21474 | 183295 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.7629688694519 | -122.506035915679 | (37.7629688694519, -122.506035915679) | 1 | 8 | 3 | 56 | 35 | |||
21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
21743 | 9330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.5022559 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | 2 | 7 | 5 | 63 | 7 | ||
21889 | 240418 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001776.14511 | 2096508.83113 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | 2 | 7 | 5 | 63 | 7 | |||
22308 | 33551 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.7400478987016 | -122.418202822848 | (37.7400478987016, -122.418202822848) | 2 | 7 | 7 | 28859 | 2 | |||
22588 | 44207 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 701 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2000 12:00:00 AM | Permit Number 43655 | 6009221.06713893 | 2115299.96241651 | 37.7887307349007 | -122.411921176175 | (37.7887307349007, -122.411921176175) | 5 | 1 | 10 | 28852 | 21 | ||
23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
23194 | 136319 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010537.58998 | 2122003.14861 | 37.8072098224406 | -122.407839040359 | (37.8072098224406, -122.407839040359) | 3 | 1 | 10 | 308 | 23 | |||
23269 | 1772 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | |||
23748 | 124092 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991890.07496 | 2111196.52278 | 37.7764762519633 | -122.471584203691 | (37.7764762519633, -122.471584203691) | 11 | 6 | 2 | 54 | 11 | ||||
24081 | 118563 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.505243048821 | (37.7792296683273, -122.505243048821) | 11 | 6 | 2 | 55 | 26 | |||
24228 | 48907 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
24465 | 48904 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
25363 | 32597 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | 1 | 8 | 3 | 56 | 35 | |
25866 | 32518 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | 2 | 7 | 7 | 28859 | 2 | |
26259 | 217579 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.7143464128453 | -122.468610110073 | (37.7143464128453, -122.468610110073) | 9 | 8 | 6 | 64 | 24 | |||
26389 | 87804 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1953 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50568 | 6004841 | 2117073 | 37.7933523405685 | -122.427201927622 | (37.7933523405685, -122.427201927622) | 13 | 9 | 1 | 28858 | 27 | ||
26602 | 48668 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3362 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2002 12:00:00 AM | 2 | Permit Number 45951 | 5998735.75428 | 2115612.17598 | 37.788994153303 | -122.448221183082 | (37.788994153303, -122.448221183082) | 13 | 6 | 1 | 54 | 31 | ||
26771 | 83492 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2040 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50186 | 5981220.21812771 | 2101179.004699 | 37.7483479647664 | -122.50775007916 | (37.7483479647664, -122.50775007916) | 1 | 8 | 3 | 29491 | 35 | ||
26882 | 37419 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39897 | 6002931.14322816 | 2099749.14332352 | 37.7456770883652 | -122.432572163971 | (37.7456770883652, -122.432572163971) | 2 | 7 | 5 | 63 | 22 | ||
27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
27508 | 68856 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32819 | 6000663.76465174 | 2094326.91833664 | 37.7306600888757 | -122.440023675014 | (37.7306600888757, -122.440023675014) | 9 | 7 | 4 | 63 | 40 | ||
27524 | 37977 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
27785 | 31973 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | 11 | 6 | 1 | 54 | 11 | |
28313 | 32595 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1383 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37063 | 5985531.94877095 | 2105814.83097448 | 37.7613297510328 | -122.493181901529 | (37.7613297510328, -122.493181901529) | 1 | 8 | 3 | 56 | 35 | |
28524 | 34910 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 234 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1997 12:00:00 AM | Permit Number 38511 | 5994034.02525385 | 2087990.46611796 | 37.712882070912 | -122.462484089909 | (37.712882070912, -122.462484089909) | 9 | 8 | 6 | 28861 | 24 | |||
29332 | 40197 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.500488206744 | (37.7773644306872, -122.500488206744) | 11 | 6 | 2 | 55 | 26 | |
29422 | 41661 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 2 | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | |
29514 | 214024 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000768.15588 | 2094464.11739 | 37.7310427480136 | -122.439672611702 | (37.7310427480136, -122.439672611702) | 9 | 7 | 4 | 63 | 40 | |||
30102 | 184465 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.7459170344363 | -122.503759179813 | (37.7459170344363, -122.503759179813) | 1 | 8 | 3 | 29491 | 35 | |||
30225 | 33058 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779143 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | ||
30433 | 40199 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | 11 | 6 | 2 | 55 | 26 | |
30544 | 41593 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 538 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43228 | 6003084.80949648 | 2098934.42438565 | 37.7434487728436 | -122.431982642828 | (37.7434487728436, -122.431982642828) | 2 | 7 | 5 | 63 | 22 | ||
30874 | 18608 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | 9 | 8 | 6 | 64 | 24 | ||
31150 | 214014 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992138.11746 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) | 1 | 8 | 4 | 56 | 12 | |||
31447 | 240421 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002440.89213 | 2096392.57557 | 37.7364329192297 | -122.434027483591 | (37.7364329192297, -122.434027483591) | 2 | 7 | 5 | 63 | 7 | |||
31605 | 118182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 615 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985646.49411 | 2111667.23632 | 37.7774055049593 | -122.493216904169 | (37.7774055049593, -122.493216904169) | 11 | 6 | 2 | 55 | 26 | |||
31613 | 33057 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
31760 | 53143 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1498@ KEITH Underwood Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 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) );