trees
443 rows where qSpecies_id = 32 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34806 | 91741 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2844 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) | 2 | 4 | 7 | 28859 | 19 | |||
| 44013 | 87743 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 335 Wilde Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50406 | 6011180.9 | 2088940.4 | 37.7164629306199 | -122.403285348147 | (37.7164629306199, -122.403285348147) | 9 | 7 | 8 | 309 | 39 | |||
| 81784 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 32 | 2614 Sacramento St | Front Yard : | Tree | Private 2 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291 | 2115777 | 37.7896493226209 | -122.435932319436 | (37.7896493226209, -122.435932319436) | 13 | 6 | 1 | 29490 | 27 | ||||
| 82544 | 91762 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1940 Harrison St | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008660.813755 | 2107281.610975 | 37.7666827970273 | -122.413292321769 | (37.7666827970273, -122.413292321769) | 8 | 4 | 7 | 28853 | 19 | |||
| 124043 | 93976 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3261 Harrison St | : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036 | 2099698 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | 2 | 7 | 7 | 28859 | 2 | ||||
| 143745 | 91737 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | 2 | 4 | 7 | 28859 | 19 | |||
| 157112 | 256075 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 1919 Jennings St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015778 | 2093027 | 37.7279396111572 | -122.387680322808 | (37.7279396111572, -122.387680322808) | 10 | 3 | 8 | 58 | 1 | |||||
| 190640 | 91738 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2900x Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008972.238365 | 2101556.992621 | 37.7509817758285 | -122.411810599761 | (37.7509817758285, -122.411810599761) | 2 | 4 | 7 | 28859 | 19 | |||
| 191679 | 91740 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2840 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008952.188354 | 2101915.380795 | 37.7519647047313 | -122.411905257789 | (37.7519647047313, -122.411905257789) | 2 | 4 | 7 | 28859 | 19 | |||
| 57 | 230549 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 39 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787877 | 6005359.28388 | 2095944.60166 | 37.7353680760624 | -122.423905517743 | (37.7353680760624, -122.423905517743) | 2 | 7 | 7 | 28859 | 2 | |
| 613 | 161126 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001694.7774 | 2090903.55181 | 37.721318940793 | -122.436214417168 | (37.721318940793, -122.436214417168) | 9 | 7 | 6 | 28861 | 5 | ||
| 1087 | 233496 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000227.44313 | 2104506.90628 | 37.7585870568739 | -122.442262614226 | (37.7585870568739, -122.442262614226) | 2 | 4 | 5 | 28862 | 3 | |||
| 2889 | 211318 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 355 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997726.4515 | 2093787.92348 | 37.7290124835257 | -122.450139532341 | (37.7290124835257, -122.450139532341) | 9 | 7 | 4 | 28861 | 40 | |||
| 3388 | 261119 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2067 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6011786.16554 | 2094038.32843 | 37.730494584078 | -122.401551330673 | (37.730494584078, -122.401551330673) | 10 | 3 | 8 | 58 | 1 | ||
| 4192 | 264915 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 1461 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784397 | 6015819.34366 | 2093828.22518 | 37.7301419060949 | -122.387593270969 | (37.7301419060949, -122.387593270969) | 10 | 3 | 8 | 58 | 1 | |
| 4937 | 132212 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2654 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000265.26964 | 2118199.18789 | 37.7961847294893 | -122.443115149071 | (37.7961847294893, -122.443115149071) | 13 | 9 | 1 | 57 | 17 | |||
| 5845 | 96500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
| 6112 | 233465 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2460 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008820.36078 | 2104131.22912 | 37.7580415272211 | -122.41251775699 | (37.7580415272211, -122.41251775699) | 2 | 4 | 7 | 28859 | 19 | |||
| 6345 | 175597 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6001092.21629 | 2090034.68248 | 37.7188989677059 | -122.438235084102 | (37.7188989677059, -122.438235084102) | 9 | 7 | 6 | 28861 | 5 | ||
| 6458 | 211310 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993991.2178 | 2104316.50873 | 37.7577068768914 | -122.46381631408 | (37.7577068768914, -122.46381631408) | 1 | 5 | 4 | 56 | 12 | |||
| 7122 | 194543 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012559.7859 | 2107618.88108 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | 14 | 3 | 8 | 28856 | 20 | |||
| 8498 | 233506 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008710.79759 | 2107246.55273 | 37.7665893413473 | -122.413116956406 | (37.7665893413473, -122.413116956406) | 8 | 4 | 7 | 28853 | 19 | |||
| 8831 | 233416 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008962 | 2103248 | 37.7556243278629 | -122.411965491523 | (37.7556243278629, -122.411965491523) | 2 | 4 | 7 | 28859 | 19 | |||
| 9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
| 9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
| 10307 | 233401 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008031.26632 | 2103842.02923 | 37.7572031342345 | -122.415226318935 | (37.7572031342345, -122.415226318935) | 2 | 4 | 7 | 28859 | 19 | |||
| 10542 | 233492 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001776.45872 | 2103391.52743 | 37.7556126580189 | -122.436825582043 | (37.7556126580189, -122.436825582043) | 2 | 4 | 5 | 28862 | 22 | |||
| 10598 | 91743 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2708 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008911.299202 | 2102677.621362 | 37.7540553520509 | -122.412100523216 | (37.7540553520509, -122.412100523216) | 2 | 4 | 7 | 28859 | 19 | ||
| 10685 | 233450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009002.96054 | 2100768.18815 | 37.7488176180461 | -122.411648631477 | (37.7488176180461, -122.411648631477) | 2 | 4 | 7 | 28859 | 19 | |||
| 10926 | 39982 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 41240 | 6013913.21051 | 2094747.21056 | 37.7325594879289 | -122.394247383904 | (37.7325594879289, -122.394247383904) | 10 | 3 | 8 | 58 | 1 |
| 11621 | 171168 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 61 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004706.69577 | 2093156.0367 | 37.7276744353238 | -122.425963318556 | (37.7276744353238, -122.425963318556) | 9 | 7 | 6 | 28861 | 5 | |||
| 11691 | 233464 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2905 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008837.85782 | 2103822.74046 | 37.7571954693154 | -122.412435439344 | (37.7571954693154, -122.412435439344) | 2 | 4 | 7 | 28859 | 19 | |||
| 12003 | 166317 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008865.69274 | 2103234.56357 | 37.755582030708 | -122.412297603862 | (37.755582030708, -122.412297603862) | 2 | 4 | 7 | 28859 | 19 | |
| 12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
| 13031 | 261121 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 80 Vesta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | ||||||||||||
| 13269 | 211313 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.24128 | 2099598.30232 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | 1 | 8 | 4 | 29491 | 40 | |||
| 13489 | 160999 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 265 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6004550.61216 | 2090876.91947 | 37.7214076589281 | -122.426340700176 | (37.7214076589281, -122.426340700176) | 9 | 7 | 6 | 28861 | 5 | ||
| 14763 | 97267 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2050X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769192 | 5999912.27224 | 2116008.29642 | 37.7901489853223 | -122.444179075813 | (37.7901489853223, -122.444179075813) | 13 | 6 | 1 | 29490 | 27 | |
| 15538 | 233362 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006411.92043 | 2106982.43417 | 37.7657348109283 | -122.421049627935 | (37.7657348109283, -122.421049627935) | 8 | 4 | 7 | 28853 | 19 | |||
| 16103 | 247814 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 532 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003126.49354 | 2098351.09832 | 37.7418494576778 | -122.431796869036 | (37.7418494576778, -122.431796869036) | 2 | 7 | 5 | 63 | 22 | |||
| 16610 | 211317 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993928.12229 | 2102221.55917 | 37.7519510476114 | -122.463882461023 | (37.7519510476114, -122.463882461023) | 1 | 8 | 4 | 29491 | 12 | |||
| 17190 | 233382 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 399x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008169.60603 | 2096545.72694 | 37.7371768914874 | -122.414231675074 | (37.7371768914874, -122.414231675074) | 2 | 7 | 7 | 28859 | 2 | |||
| 17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
| 17511 | 260658 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
| 18435 | 261120 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2901 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | ||||||||||||
| 18592 | 111041 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004870.73043 | 2118877.40927 | 37.7983084704282 | -122.427227648441 | (37.7983084704282, -122.427227648441) | 13 | 9 | 1 | 57 | 17 | |||
| 19222 | 22826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 84 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:48:00 PM | 3 | 3x3 | 5999343.3761 | 2099052.93009 | 37.743561341476 | -122.444928046502 | (37.743561341476, -122.444928046502) | 2 | 7 | 5 | 63 | 7 | ||
| 21910 | 96514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2525 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | 6008931.78407 | 2103601.217 | 37.7565924865992 | -122.412094949605 | (37.7565924865992, -122.412094949605) | 2 | 4 | 7 | 28859 | 19 | ||
| 22785 | 233411 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2709 Harrison St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 6008945.30625 | 2102700.68655 | 37.754120591896 | -122.411984548072 | (37.754120591896, -122.411984548072) | 2 | 4 | 7 | 28859 | 19 | |||
| 23779 | 233442 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 95 Montezuma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007954.1776 | 2099786.14211 | 37.7460622517822 | -122.415205824295 | (37.7460622517822, -122.415205824295) | 2 | 7 | 7 | 28859 | 2 | |||
| 23903 | 107340 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773835 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 | |
| 25550 | 211315 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993849.45223 | 2102159.58974 | 37.7517763614982 | -122.464150012924 | (37.7517763614982, -122.464150012924) | 1 | 8 | 4 | 29491 | 12 | |||
| 26016 | 233380 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 397 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007405.88509 | 2096272.27203 | 37.7363831156735 | -122.416852845398 | (37.7363831156735, -122.416852845398) | 2 | 7 | 7 | 28859 | 2 | |||
| 26635 | 26526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2789 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 3x3 | 6009007 | 2102243 | 37.7528673485866 | -122.411738857609 | (37.7528673485866, -122.411738857609) | 2 | 4 | 7 | 28859 | 19 | ||
| 26805 | 139841 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 855 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005489.2243 | 2112352.6717 | 37.7804281291994 | -122.424623086227 | (37.7804281291994, -122.424623086227) | 7 | 9 | 11 | 28852 | 41 | |||
| 27892 | 9514 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1024 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004658.34921 | 2112287.36137 | 37.7802018438259 | -122.427492819652 | (37.7802018438259, -122.427492819652) | 7 | 9 | 11 | 29490 | 41 | ||
| 28716 | 233494 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 885 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003128.49899 | 2103230.63077 | 37.7552476232057 | -122.432138316435 | (37.7552476232057, -122.432138316435) | 2 | 4 | 5 | 28862 | 22 | |||
| 28926 | 233410 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2727 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008964.10696 | 2102573.01039 | 37.7537710766793 | -122.41191050868 | (37.7537710766793, -122.41191050868) | 2 | 4 | 7 | 28859 | 19 | |||
| 30327 | 34199 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 38018 | 5994287.68885518 | 2098749.96127524 | 37.7424396309737 | -122.462387263533 | (37.7424396309737, -122.462387263533) | 1 | 8 | 4 | 59 | 40 | ||
| 30722 | 91760 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2190X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008735.241541 | 2105700.534049 | 37.7623457027108 | -122.412923089625 | (37.7623457027108, -122.412923089625) | 8 | 4 | 7 | 28859 | 19 | ||
| 31941 | 91751 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2660 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008895.550687 | 2102970.363593 | 37.7548582726151 | -122.412175673836 | (37.7548582726151, -122.412175673836) | 2 | 4 | 7 | 28859 | 19 | ||
| 32774 | 233361 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 28 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | 6005734.12152 | 2106385.89097 | 37.7640586131313 | -122.423351580335 | (37.7640586131313, -122.423351580335) | 8 | 4 | 5 | 28859 | 19 | ||
| 34340 | 45171 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44018 | 6010456.17942581 | 2099626.75633158 | 37.7457649076199 | -122.406542957313 | (37.7457649076199, -122.406542957313) | 2 | 7 | 7 | 28859 | 2 | ||
| 34823 | 108597 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
| 34960 | 115370 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 773523 | 6007887 | 2096619.6 | 37.7373638523191 | -122.415214003631 | (37.7373638523191, -122.415214003631) | 2 | 7 | 7 | 28859 | 2 | ||
| 35068 | 233485 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008609.33505 | 2107860.39921 | 37.7682691247363 | -122.413511317219 | (37.7682691247363, -122.413511317219) | 8 | 4 | 7 | 28853 | 19 | |||
| 36402 | 16950 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 630 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003955.1515 | 2110112.5344 | 37.7741905079368 | -122.429770337641 | (37.7741905079368, -122.429770337641) | 7 | 9 | 11 | 29492 | 10 | |||
| 37190 | 233448 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3250 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008442.79349 | 2104490.88845 | 37.7590078730361 | -122.41384899104 | (37.7590078730361, -122.41384899104) | 2 | 4 | 7 | 28859 | 19 | |||
| 37442 | 87929 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2801x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50953 | 6008059 | 2106775 | 37.7652579548966 | -122.415338031053 | (37.7652579548966, -122.415338031053) | 8 | 4 | 7 | 28859 | 19 | ||
| 37896 | 9519 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1042 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6004584.56967 | 2112292.20585 | 37.780210972327 | -122.427748402246 | (37.780210972327, -122.427748402246) | 7 | 9 | 11 | 29490 | 41 | ||
| 39346 | 50453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2645 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | Permit Number 47099 | 5999591.19502 | 2117968.49826 | 37.7955128594886 | -122.445430979754 | (37.7955128594886, -122.445430979754) | 13 | 9 | 1 | 57 | 17 | ||
| 40590 | 199686 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015608.757 | 2092907.6605 | 37.7276025523971 | -122.388257080086 | (37.7276025523971, -122.388257080086) | 10 | 3 | 8 | 58 | 1 | |||
| 41209 | 91753 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2500X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/07/2007 12:00:00 AM | 5 | 3x3 | 6008845.834759 | 2103888.876448 | 37.7573775113883 | -122.412412526543 | (37.7573775113883, -122.412412526543) | 2 | 4 | 7 | 28859 | 19 | |
| 42619 | 233498 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 101 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000562.67168 | 2104881.27171 | 37.7596340727711 | -122.441130104275 | (37.7596340727711, -122.441130104275) | 2 | 4 | 5 | 28862 | 3 | |||
| 43147 | 233413 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2633 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008936.00153 | 2103092.78204 | 37.7551966757093 | -122.412044433915 | (37.7551966757093, -122.412044433915) | 2 | 4 | 7 | 28859 | 19 | |||
| 43234 | 233495 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 450 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003394.34799 | 2103331.88494 | 37.7555407122568 | -122.431226159276 | (37.7555407122568, -122.431226159276) | 2 | 4 | 5 | 28862 | 22 | |||
| 43559 | 194534 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 25 Lucy St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014175.87087 | 2093939.45878 | 37.7303561623911 | -122.39328279268 | (37.7303561623911, -122.39328279268) | 10 | 3 | 8 | 58 | 1 | |||
| 46793 | 233443 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 550 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008940.03801 | 2105662.09914 | 37.7622516628983 | -122.412212055847 | (37.7622516628983, -122.412212055847) | 8 | 4 | 7 | 28859 | 19 | |||
| 46820 | 233418 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2593 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008919.41987 | 2103390.65129 | 37.7560136270404 | -122.412122828715 | (37.7560136270404, -122.412122828715) | 2 | 4 | 7 | 28859 | 19 | |||
| 47154 | 233360 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 40 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005303.62865 | 2105767.86216 | 37.7623373467104 | -122.42479655971 | (37.7623373467104, -122.42479655971) | 8 | 4 | 5 | 28859 | 19 | |||
| 48429 | 94030 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2576 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2010 12:00:00 AM | 3x3 | Permit Number 53444 | 6008873.8 | 2103464.7 | 37.756214388248 | -122.412285831464 | (37.756214388248, -122.412285831464) | 2 | 4 | 7 | 28859 | 19 | ||
| 49515 | 233400 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009350.24678 | 2103328.60933 | 37.7558674377406 | -122.410628499003 | (37.7558674377406, -122.410628499003) | 2 | 4 | 7 | 28859 | 19 | |||
| 51549 | 123985 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 15 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993608.31847 | 2115347.64983 | 37.7879733773019 | -122.465942059673 | (37.7879733773019, -122.465942059673) | 11 | 6 | 1 | 54 | 11 | |||
| 53615 | 233359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 93 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6004257.74689 | 2109007.55308 | 37.7711736292001 | -122.428644822623 | (37.7711736292001, -122.428644822623) | 7 | 9 | 11 | 29492 | 10 | |||
| 55259 | 178358 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 54 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004690.16722 | 2093211.84688 | 37.7278267435864 | -122.426024429306 | (37.7278267435864, -122.426024429306) | 9 | 7 | 6 | 28861 | 5 | |||
| 55423 | 233455 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2774 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008918.08813 | 2102304.0986 | 37.7530301234427 | -122.412050650042 | (37.7530301234427, -122.412050650042) | 2 | 4 | 7 | 28859 | 19 | |||
| 55832 | 233480 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1962 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008658.08091 | 2107023.31074 | 37.7659734109827 | -122.413283506344 | (37.7659734109827, -122.413283506344) | 8 | 4 | 7 | 28853 | 19 | |||
| 55923 | 91746 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
| 58069 | 233430 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2801 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008012.33322 | 2106763.12966 | 37.7652227387558 | -122.415498600376 | (37.7652227387558, -122.415498600376) | 8 | 4 | 7 | 28859 | 19 | |||
| 58134 | 38018 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.7429295327147 | -122.46804846503 | (37.7429295327147, -122.46804846503) | 1 | 8 | 4 | 29491 | 40 | ||
| 59287 | 233440 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 228 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008985.91579 | 2097299.41691 | 37.7392921796829 | -122.411462541085 | (37.7392921796829, -122.411462541085) | 10 | 7 | 7 | 28859 | 2 | |||
| 59976 | 233441 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 33 Montezuma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007530.9568 | 2099766.89279 | 37.7459856034546 | -122.416667906996 | (37.7459856034546, -122.416667906996) | 2 | 7 | 7 | 28859 | 2 | |||
| 60569 | 66609 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 28- 30 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | Permit Number 773746 | 6005799.80596486 | 2106395.73703004 | 37.7640893550041 | -122.423125096713 | (37.7640893550041, -122.423125096713) | 8 | 4 | 5 | 28859 | 19 | |
| 61436 | 54918 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2836 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 9 | Permit Number 10785 | 5999351.3134 | 2118417.61273 | 37.7967323114142 | -122.446293331595 | (37.7967323114142, -122.446293331595) | 13 | 9 | 1 | 57 | 17 | ||
| 62514 | 233432 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2805 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007955.9785 | 2106758.25417 | 37.7652061840354 | -122.415693173211 | (37.7652061840354, -122.415693173211) | 8 | 4 | 7 | 28859 | 19 | |||
| 63347 | 91750 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008893.124476 | 2103015.18846 | 37.7549812154524 | -122.412187232232 | (37.7549812154524, -122.412187232232) | 2 | 4 | 7 | 28859 | 19 | ||
| 65099 | 28133 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/2018 12:00:00 AM | 3 | 6x9 | Permit Number 778832 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | 2 | 7 | 7 | 28859 | 2 | |
| 65592 | 38311 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 47228 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 66612 | 233437 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4221 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002351.48314 | 2100601.8225 | 37.7479854555773 | -122.434637500016 | (37.7479854555773, -122.434637500016) | 2 | 4 | 5 | 63 | 22 | |||
| 69068 | 233454 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2816 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008939.13168 | 2102033.55386 | 37.7522884489586 | -122.411958759988 | (37.7522884489586, -122.411958759988) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );