trees
614 rows where qSpecies_id = 29 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 69919 | 88224 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1821 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51220 | 5999142 | 2110084 | 37.7738384306008 | -122.446417770519 | (37.7738384306008, -122.446417770519) | 15 | 5 | 11 | 29492 | 16 | |||
| 84430 | 88271 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51257 | 5998321.8 | 2107947.7 | 37.7679258166536 | -122.449101033169 | (37.7679258166536, -122.449101033169) | 15 | 5 | 11 | 29492 | 9 | |||
| 87519 | 112589 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
| 107202 | 88618 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1815 Taraval St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51591 | 5987609 | 2098941 | 37.7425773238376 | -122.485493894781 | (37.7425773238376, -122.485493894781) | 1 | 8 | 3 | 29491 | 35 | ||
| 119382 | 112588 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
| 133264 | 88439 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 837 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51403 | 6007580 | 2095463 | 37.7341708239465 | -122.416193557304 | (37.7341708239465, -122.416193557304) | 2 | 7 | 7 | 28859 | 2 | |||
| 138272 | 87465 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 485 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50381 | 6002157 | 2110126 | 37.7741254934027 | -122.435991418782 | (37.7741254934027, -122.435991418782) | 15 | 5 | 11 | 29492 | 10 | |||
| 148702 | 88222 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1650 Fulton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51218 | 5999862 | 2110923 | 37.7761832078575 | -122.44398747699 | (37.7761832078575, -122.44398747699) | 15 | 5 | 11 | 29492 | 16 | |||
| 159053 | 88274 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 4440 23rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51264 | 6000402 | 2102285 | 37.7524961905728 | -122.441499478589 | (37.7524961905728, -122.441499478589) | 2 | 4 | 5 | 28862 | 22 | |||
| 192914 | 89014 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2147 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2008 12:00:00 AM | 3X3 | Permit Number 51763 | 6008963 | 2120596 | 37.803257869178 | -122.413188701365 | (37.803257869178, -122.413188701365) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 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 | |||
| 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 | ||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||||||||||||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 32542 | 214022 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997050.53703 | 2094389.33231 | 37.7306251064676 | -122.452519591711 | (37.7306251064676, -122.452519591711) | 9 | 7 | 4 | 28861 | 40 | |||
| 33474 | 10670 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002868.6063491 | 2110598.6567928 | 37.7754636919659 | -122.433563635643 | (37.7754636919659, -122.433563635643) | 15 | 5 | 11 | 29492 | 10 | |||
| 34413 | 38029 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2490X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.469656660064 | (37.7415161934278, -122.469656660064) | 1 | 8 | 4 | 29491 | 40 | ||
| 35401 | 26068 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | 9 | 8 | 6 | 28861 | 24 | ||
| 36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
| 36649 | 43585 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 237 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43246 | 6004367.379779 | 2099245.61051184 | 37.7443758465625 | -122.427570002743 | (37.7443758465625, -122.427570002743) | 2 | 7 | 5 | 63 | 22 | ||
| 39191 | 63013 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | 2 | 7 | 7 | 28859 | 2 | |
| 39553 | 214034 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.7291168615442 | -122.447089829625 | (37.7291168615442, -122.447089829625) | 9 | 7 | 4 | 28861 | 40 | |||
| 40073 | 38845 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1333 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40675 | 5989863.06342131 | 2106288.82741716 | 37.7628835816678 | -122.478237218826 | (37.7628835816678, -122.478237218826) | 1 | 8 | 3 | 56 | 35 | ||
| 40275 | 95802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767546 | 6014097.5 | 2102025.1 | 37.7525532940671 | -122.394119575027 | (37.7525532940671, -122.394119575027) | 10 | 3 | 8 | 28856 | 29 | |
| 40883 | 240415 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 751 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.430134113409 | (37.7675888874331, -122.430134113409) | 7 | 9 | 5 | 28862 | 3 | |||
| 40932 | 179375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001912.74857 | 2089301.24621 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | 9 | 7 | 6 | 28861 | 5 | |||
| 42377 | 140854 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 623 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996411.3906 | 2113796.8958 | 37.7838767259243 | -122.456131829019 | (37.7838767259243, -122.456131829019) | 11 | 6 | 1 | 54 | 31 | |||
| 42393 | 69511 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.411588483232 | (37.736290754505, -122.411588483232) | 10 | 7 | 7 | 28859 | 2 | ||
| 42922 | 69007 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2115 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33008 | 5982291.49205895 | 2100703.22551621 | 37.7471046635524 | -122.504010467091 | (37.7471046635524, -122.504010467091) | 1 | 8 | 3 | 29491 | 35 | |
| 43394 | 92109 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | 11 | 6 | 2 | 55 | 26 | |
| 44922 | 38217 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 350 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | 10 | 3 | 7 | 309 | 28 | ||
| 45902 | 67518 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 31054 | 5997814.69503285 | 2093832.35785798 | 37.7291395391527 | -122.449837670115 | (37.7291395391527, -122.449837670115) | 9 | 7 | 4 | 28861 | 40 | ||
| 45935 | 7243 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.433510025097 | (37.7850277993699, -122.433510025097) | 13 | 9 | 11 | 29490 | 13 | |||
| 46117 | 41663 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | ||
| 46450 | 69309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1554 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 3 | Permit Number 33388 | 5986865.46516485 | 2104681.03924788 | 37.7582945739882 | -122.488486559119 | (37.7582945739882, -122.488486559119) | 1 | 8 | 3 | 56 | 35 | |
| 46975 | 82884 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.7706164898271 | -122.412590100264 | (37.7706164898271, -122.412590100264) | 8 | 2 | 9 | 28853 | 19 | ||
| 48198 | 18596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.466428817805 | (37.7141961040887, -122.466428817805) | 9 | 8 | 6 | 64 | 24 | ||
| 48554 | 69006 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2111 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 3 | Permit Number 33007 | 5982290.62244002 | 2100729.28975496 | 37.7471761775601 | -122.504015404359 | (37.7471761775601, -122.504015404359) | 1 | 8 | 3 | 29491 | 35 | |
| 49617 | 39731 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3472 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41103 | 6003734.27078033 | 2106581.04610194 | 37.7644813903829 | -122.430282399811 | (37.7644813903829, -122.430282399811) | 8 | 4 | 5 | 28862 | 3 | ||
| 49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
| 49906 | 41694 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42146 | 6003561.9148943 | 2096429.88916823 | 37.7365989305362 | -122.430154297904 | (37.7365989305362, -122.430154297904) | 2 | 7 | 5 | 63 | 7 | ||
| 50181 | 89199 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51816 | 5999889 | 2119639 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | 13 | 9 | 1 | 57 | 17 | ||
| 50270 | 40783 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
| 51794 | 214043 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | 9 | 7 | 4 | 28861 | 40 | |||
| 52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
| 52155 | 94656 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765 | 2094410 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) | 9 | 7 | 4 | 63 | 40 |
| 53841 | 136322 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.7983349338553 | -122.403601207338 | (37.7983349338553, -122.403601207338) | 3 | 1 | 10 | 308 | 23 | ||
| 55616 | 140094 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | 15 | 5 | 11 | 29492 | 16 | |||
| 55692 | 67377 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 841 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2015 12:00:00 AM | 1 | Permit Number 776566 | 5992946.95858 | 2111357.65552 | 37.7769797668271 | -122.467939896695 | (37.7769797668271, -122.467939896695) | 11 | 6 | 2 | 54 | 11 | |
| 55782 | 47698 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 297 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458918 | 37.7322859754961 | -122.441914392194 | (37.7322859754961, -122.441914392194) | 9 | 7 | 4 | 63 | 40 | ||
| 58083 | 201725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1915 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6013561.8417 | 2095888.78027 | 37.7356744661038 | -122.395542109982 | (37.7356744661038, -122.395542109982) | 10 | 3 | 8 | 58 | 1 | ||||
| 59685 | 41706 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42155 | 6001936.91803675 | 2096162.95952183 | 37.7357738321427 | -122.435753508421 | (37.7357738321427, -122.435753508421) | 2 | 7 | 5 | 63 | 7 |
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) );