trees
7,157 rows where qSpecies_id = 36
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66 | 132469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3135 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
363 | 234091 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 460 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005712.20409 | 2107866.30498 | 37.7681222411638 | -122.423532643536 | (37.7681222411638, -122.423532643536) | 8 | 4 | 5 | 28853 | 19 | |||
368 | 234039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 93 Scott St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6002347.86623 | 2108745.44445 | 37.7703456710482 | -122.435232412346 | (37.7703456710482, -122.435232412346) | 15 | 5 | 5 | 29492 | 9 | |||
412 | 121036 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1830 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006566 | 2117108 | 37.7935458417616 | -122.421235781398 | (37.7935458417616, -122.421235781398) | 13 | 9 | 10 | 28858 | 32 | ||||
448 | 17338 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/18/1993 12:00:00 AM | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||
467 | 211626 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 5994442.33797 | 2100102.58449 | 37.7461624991943 | -122.461950600334 | (37.7461624991943, -122.461950600334) | 1 | 8 | 4 | 29491 | 40 | |||
511 | 23082 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1304 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1990 12:00:00 AM | 12 | 4x4 | 6006396.78239 | 2101930.96357 | 37.7518637944919 | -122.420743341327 | (37.7518637944919, -122.420743341327) | 2 | 4 | 5 | 28859 | 19 | ||
535 | 50166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 159 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46878 | 6010492.5895 | 2111415.08321 | 37.7781350293519 | -122.407247904281 | (37.7781350293519, -122.407247904281) | 14 | 2 | 9 | 28853 | 34 | |
592 | 211675 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785250 | 5994473.3982 | 2090822.99818 | 37.7206848225258 | -122.461170675896 | (37.7206848225258, -122.461170675896) | 9 | 8 | 6 | 28861 | 24 | |
596 | 234286 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 803 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007964.56694 | 2103204.29318 | 37.7554483078008 | -122.415411844593 | (37.7554483078008, -122.415411844593) | 2 | 4 | 7 | 28859 | 19 | |||
602 | 234309 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3221 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008660.48476 | 2104460.24756 | 37.7589359632462 | -122.413093942738 | (37.7589359632462, -122.413093942738) | 2 | 4 | 7 | 28859 | 19 | |||
634 | 79736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 705 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008945.3206 | 2110776.64932 | 37.7762953249107 | -122.412555345054 | (37.7762953249107, -122.412555345054) | 8 | 2 | 9 | 28853 | 34 | |||
641 | 132666 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3408 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998390.41513 | 2115562.86415 | 37.7888390076521 | -122.449412451134 | (37.7888390076521, -122.449412451134) | 13 | 6 | 1 | 54 | 31 | |||
669 | 30402 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2800 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.7781192320704 | -122.451583952943 | (37.7781192320704, -122.451583952943) | 15 | 6 | 2 | 54 | 16 | |||
702 | 62566 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 484 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22767 | 6011457.1056 | 2106150.727 | 37.7637342411783 | -122.403540799888 | (37.7637342411783, -122.403540799888) | 8 | 3 | 8 | 28856 | 29 | |
731 | 262111 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2021 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991247 | 2101647 | 37.7502185858925 | -122.473112177678 | (37.7502185858925, -122.473112177678) | 1 | 8 | 4 | 29491 | 12 | ||||
781 | 98761 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.433167654376 | (37.8041696588781, -122.433167654376) | 13 | 9 | 1 | 57 | 17 | |||
808 | 19837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY25 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
817 | 132762 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.53227 | 2121230.80772 | 37.8046665028104 | -122.43373589191 | (37.8046665028104, -122.43373589191) | 13 | 9 | 1 | 57 | 17 | |||
818 | 71164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2118 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988230.9552 | 2100880.1949 | 37.7479380567645 | -122.483485514105 | (37.7479380567645, -122.483485514105) | 1 | 8 | 3 | 29491 | 35 | |||
864 | 71270 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1215 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6001794.92 | 2112753.6259 | 37.7813197166319 | -122.437432113692 | (37.7813197166319, -122.437432113692) | 15 | 5 | 11 | 29490 | 41 | |||
869 | 62385 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 642 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1985 12:00:00 AM | 12 | Permit Number 22535 | 6001098.1348 | 2110956.5992 | 37.7763458992435 | -122.439713770865 | (37.7763458992435, -122.439713770865) | 15 | 5 | 11 | 29492 | 10 | |
877 | 140007 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005073.8071 | 2111650.2628 | 37.778476017163 | -122.426010193621 | (37.778476017163, -122.426010193621) | 7 | 9 | 11 | 28852 | 41 | |||
901 | 124502 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2721 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996533.72285 | 2111260.82962 | 37.7769203792262 | -122.455525245928 | (37.7769203792262, -122.455525245928) | 11 | 6 | 2 | 54 | 16 | |||
914 | 72135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 720 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011518.46823 | 2104995.10588 | 37.7605645914089 | -122.403247266572 | (37.7605645914089, -122.403247266572) | 10 | 3 | 8 | 28856 | 29 | |||
926 | 120780 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989259.72068 | 2114624.20771 | 37.7857351884005 | -122.48093426444 | (37.7857351884005, -122.48093426444) | 11 | 6 | 2 | 55 | 26 | |||
931 | 211755 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 78 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993084.56789 | 2098632.31996 | 37.7420472635629 | -122.466538712105 | (37.7420472635629, -122.466538712105) | 1 | 8 | 4 | 59 | 40 | |||
935 | 132500 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2512 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000920.49838 | 2118292.02212 | 37.796476965998 | -122.440854593363 | (37.796476965998, -122.440854593363) | 13 | 9 | 1 | 57 | 17 | |||
944 | 211787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 145 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994159.28368 | 2097331.60357 | 37.7385377797886 | -122.462728377219 | (37.7385377797886, -122.462728377219) | 9 | 8 | 4 | 59 | 40 | |||
948 | 62575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 836 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22778 | 6011550.65022 | 2104487.06027 | 37.7591714084613 | -122.403100226493 | (37.7591714084613, -122.403100226493) | 10 | 3 | 8 | 28856 | 29 | |
959 | 49689 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2235 NOTES) Hayes St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2003 12:00:00 AM | Permit Number 46511 | 5997175.15188937 | 2109805.23760487 | 37.7729604879505 | -122.453201252207 | (37.7729604879505, -122.453201252207) | 15 | 5 | 11 | 29492 | 16 | |||
978 | 8142 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.7777073047982 | -122.432059137251 | (37.7777073047982, -122.432059137251) | 15 | 9 | 11 | 29492 | 41 | |||
989 | 40872 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3456 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | 13 | 6 | 1 | 54 | 31 | |||
1018 | 41589 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2601 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | 4 | Permit Number 770702 | 6001047.66976 | 2117208.8358 | 37.7935100620898 | -122.440336832983 | (37.7935100620898, -122.440336832983) | 13 | 9 | 1 | 29490 | 27 | ||
1034 | 194657 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012465.19562 | 2105138.61132 | 37.7610114537331 | -122.39998302521 | (37.7610114537331, -122.39998302521) | 10 | 3 | 8 | 28856 | 29 | |||
1090 | 260553 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151x Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 09/21/2019 12:00:00 AM | 3 | ||||||||||||
1098 | 31784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 7 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35255 | 6001631.05677 | 2108636.54376 | 37.7700059251571 | -122.437704050605 | (37.7700059251571, -122.437704050605) | 15 | 5 | 5 | 29492 | 9 | |
1167 | 33310 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1549 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37457 | 6005491.84423 | 2119228.52143 | 37.7993076406048 | -122.425103401209 | (37.7993076406048, -122.425103401209) | 13 | 9 | 1 | 57 | 17 | |
1225 | 70200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | 9 | 7 | 6 | 28861 | 5 | |||
1316 | 79413 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1666 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 5987817.2161 | 2103952.4133 | 37.7563494532381 | -122.485141568367 | (37.7563494532381, -122.485141568367) | 1 | 8 | 3 | 56 | 35 | ||
1362 | 244521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 577 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003849.83 | 2109698.0755 | 37.7730465408764 | -122.430105090767 | (37.7730465408764, -122.430105090767) | 7 | 9 | 11 | 29492 | 10 | |||
1379 | 19129 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Sanchez St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2009 12:00:00 AM | 3 | 3X4 | 6003497.27744 | 2108239.16815 | 37.7690207646335 | -122.431220458483 | (37.7690207646335, -122.431220458483) | 7 | 9 | 5 | 28862 | 3 | ||
1385 | 101200 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 502 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994231.2 | 2106687.3 | 37.7642302811549 | -122.463158383346 | (37.7642302811549, -122.463158383346) | 11 | 5 | 11 | 56 | 12 | |||||
1387 | 11448 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2017 12:09:00 PM | 3 | 3 | 5995519.82754 | 2115841.84115 | 37.7894403785598 | -122.459364428968 | (37.7894403785598, -122.459364428968) | 11 | 6 | 1 | 54 | 31 | ||
1436 | 256792 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 120 Cedar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006815 | 2114489 | 37.7863687502832 | -122.420188259313 | (37.7863687502832, -122.420188259313) | 13 | 9 | 10 | 28858 | 36 | ||||
1444 | 256097 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:12:00 PM | 3 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.408668755752 | (37.8072676263732, -122.408668755752) | 3 | 1 | 10 | 308 | 23 | ||
1521 | 244457 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003333.6569 | 2109668.6973 | 37.7729366277203 | -122.43188849891 | (37.7729366277203, -122.43188849891) | 15 | 9 | 11 | 29492 | 10 | |||
1645 | 72886 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2535 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988595.3153 | 2098048.3561 | 37.740183772916 | -122.482018168499 | (37.740183772916, -122.482018168499) | 1 | 8 | 3 | 29491 | 35 | |||
1734 | 262292 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
1751 | 121138 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
1803 | 55831 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 584 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1973 12:00:00 AM | 28 | Permit Number 11880 | 6002591.13434063 | 2102708.25019663 | 37.7537828093918 | -122.43395934272 | (37.7537828093918, -122.43395934272) | 2 | 4 | 5 | 28862 | 22 | ||
1825 | 45715 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 475 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 44386 | 6010097.78481 | 2106045.52558 | 37.7633693601423 | -122.408234872453 | (37.7633693601423, -122.408234872453) | 8 | 4 | 8 | 28859 | 19 | |
1827 | 133032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1170 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009033.32157 | 2117038.62296 | 37.7934941386994 | -122.412693713858 | (37.7934941386994, -122.412693713858) | 3 | 1 | 10 | 28857 | 21 | |||
1835 | 51024 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 704 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | 3 | Permit Number 47501 | 6010956.41705 | 2104990.6383 | 37.7605209185267 | -122.405190840894 | (37.7605209185267, -122.405190840894) | 10 | 3 | 8 | 28856 | 29 | |
1838 | 124332 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 152 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995942.54974 | 2113332.59688 | 37.7825749622762 | -122.457720227236 | (37.7825749622762, -122.457720227236) | 11 | 6 | 1 | 54 | 31 | |||
1868 | 37331 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 700 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39840 | 6003021.44463533 | 2104165.68333023 | 37.7578089842605 | -122.432575328482 | (37.7578089842605, -122.432575328482) | 2 | 4 | 5 | 28862 | 3 | ||
1898 | 1593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 699 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995612.08469 | 2111572.44274 | 37.7777230574603 | -122.458736017911 | (37.7777230574603, -122.458736017911) | 11 | 6 | 2 | 54 | 11 | |||
1900 | 141936 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1101 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 10/12/1994 12:00:00 AM | 8 | Width 0ft | 6003954.1428 | 2112136.7195 | 37.7797483635991 | -122.429918243479 | (37.7797483635991, -122.429918243479) | 7 | 9 | 11 | 29490 | 41 | ||
1930 | 71294 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 917 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5999486.7141 | 2111759.5119 | 37.7784586401748 | -122.445345848057 | (37.7784586401748, -122.445345848057) | 15 | 5 | 11 | 54 | 16 | |||
1949 | 70301 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2240 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987950.7299 | 2100020.9476 | 37.7455624781653 | -122.484391497727 | (37.7455624781653, -122.484391497727) | 1 | 8 | 3 | 29491 | 35 | |||
1957 | 5266 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6001289.7409 | 2112772.8314 | 37.781343716873 | -122.439181159104 | (37.781343716873, -122.439181159104) | 15 | 5 | 11 | 29490 | 41 | |||
1976 | 42727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 11 | Permit Number 42732 | 6013660.48405 | 2093404.57029 | 37.7288588208724 | -122.395027119533 | (37.7288588208724, -122.395027119533) | 10 | 3 | 8 | 58 | 1 | |
1990 | 132531 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2201 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000159.7629 | 2120220.59264 | 37.8017289527983 | -122.443625508009 | (37.8017289527983, -122.443625508009) | 13 | 9 | 1 | 57 | 17 | |||
2012 | 51564 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2301 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | 14 | Permit Number 47862 | 5990398.312 | 2099641.3886 | 37.7446625258422 | -122.475900510235 | (37.7446625258422, -122.475900510235) | 1 | 8 | 3 | 29491 | 35 | ||
2036 | 32123 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 65 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 11 | Permit Number 35485 | 6003888.57079 | 2106782.96667 | 37.7650445542853 | -122.429763121469 | (37.7650445542853, -122.429763121469) | 8 | 4 | 5 | 28862 | 3 | |
2038 | 8035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005070.3181 | 2111601.5224 | 37.7783419907871 | -122.426018792814 | (37.7783419907871, -122.426018792814) | 7 | 9 | 11 | 28852 | 10 | |||
2061 | 187165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2301 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5984939.6487 | 2099318.7286 | 37.7434585810539 | -122.494751436092 | (37.7434585810539, -122.494751436092) | 1 | 8 | 3 | 29491 | 35 | |||
2062 | 112894 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1x WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004219 | 2108568 | 37.7699645303419 | -122.428747509741 | (37.7699645303419, -122.428747509741) | 7 | 9 | 5 | 28862 | 10 | ||||
2077 | 2574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1660 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 10:41:00 AM | 3 | 4x4 | 6005572.29299 | 2115192.6753 | 37.788230768278 | -122.424537786114 | (37.788230768278, -122.424537786114) | 13 | 9 | 1 | 28858 | 41 | ||
2104 | 132472 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001487.88028 | 2118402.43157 | 37.7968124185064 | -122.438899249622 | (37.7968124185064, -122.438899249622) | 13 | 9 | 1 | 57 | 17 | |||
2158 | 95238 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | |||
2208 | 8032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | |||
2214 | 20033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
2262 | 211600 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500x Saint Francis Blvd | 2 | Median : Yard | Tree | DPW 1 | 24 | 5993318.7926 | 2096075.03242 | 37.7350391058631 | -122.465543105951 | (37.7350391058631, -122.465543105951) | 1 | 8 | 4 | 59 | 40 | ||||
2341 | 50690 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015829.14658 | 2115263.74647 | 37.7889998109335 | -122.389055445747 | (37.7889998109335, -122.389055445747) | 6 | 2 | 9 | 28855 | 6 | |
2350 | 132920 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2311 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002441.57111 | 2117401.95011 | 37.7941195695148 | -122.435527653476 | (37.7941195695148, -122.435527653476) | 13 | 9 | 1 | 29490 | 27 | |||
2465 | 133092 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | Width 3ft | 6006306.20218 | 2119734.15962 | 37.800741963924 | -122.422321379938 | (37.800741963924, -122.422321379938) | 13 | 9 | 1 | 28858 | 32 | ||
2517 | 20187 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1225 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6002803.937717 | 2112440.9213574 | 37.7805184210702 | -122.433919051618 | (37.7805184210702, -122.433919051618) | 15 | 9 | 11 | 29490 | 41 | |||
2521 | 32694 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3732 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37102 | 6004840.63533052 | 2102540.6946209 | 37.7534501432299 | -122.426168121736 | (37.7534501432299, -122.426168121736) | 2 | 4 | 5 | 28862 | 22 | |||
2575 | 62964 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 75 Glover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 7 | Permit Number 23350 | 6007969.66121 | 2118374.9398 | 37.7971035776345 | -122.416468771935 | (37.7971035776345, -122.416468771935) | 5 | 1 | 10 | 28858 | 21 | |
2593 | 19154 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 64 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774356 | 6003450.27402 | 2107953.58185 | 37.7682339504649 | -122.431362651168 | (37.7682339504649, -122.431362651168) | 15 | 9 | 5 | 28862 | 3 | |
2619 | 159371 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 371 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:23:00 AM | 3 | Width 0ft | 5998688.30625 | 2087727.08101 | 37.7124258040723 | -122.446378503676 | (37.7124258040723, -122.446378503676) | 9 | 7 | 6 | 28861 | 25 | ||
2651 | 116177 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 94X Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 2x2 | 6013088.14132 | 2114773.98934 | 37.7875027311189 | -122.3985046459 | (37.7875027311189, -122.3985046459) | 12 | 2 | 9 | 28855 | 6 | |||
2659 | 122325 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1310 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006613.81531 | 2119776.94391 | 37.8008767857834 | -122.421259948789 | (37.8008767857834, -122.421259948789) | 13 | 9 | 1 | 28858 | 32 | |||
2674 | 230818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 84 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001685.69002 | 2105325.03561 | 37.760916443951 | -122.43727792663 | (37.760916443951, -122.43727792663) | 15 | 4 | 5 | 28862 | 3 | |||
2676 | 194649 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1800 20th St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6012472.71707 | 2104722.42647 | 37.759869121389 | -122.399927785234 | (37.759869121389, -122.399927785234) | 10 | 3 | 8 | 28856 | 29 | |||
2682 | 62568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 549 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 9 | Permit Number 22769 | 6011537.01637 | 2105794.87658 | 37.7627616189737 | -122.403239377718 | (37.7627616189737, -122.403239377718) | 8 | 3 | 8 | 28856 | 29 | |
2721 | 15354 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1917 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006811.0895 | 2107161.9183 | 37.7662501256127 | -122.419681721231 | (37.7662501256127, -122.419681721231) | 8 | 4 | 7 | 28853 | 19 | |||
2728 | 73494 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007943.92592 | 2117747.18516 | 37.7953784719812 | -122.41651333244 | (37.7953784719812, -122.41651333244) | 5 | 1 | 10 | 28858 | 21 | |||
2736 | 234976 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 900 Alvarado St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000479.02302 | 2102589.02943 | 37.7533353695522 | -122.441254932895 | (37.7533353695522, -122.441254932895) | 2 | 4 | 5 | 28862 | 22 | |||
2781 | 256736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1266 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6000975.18369 | 2087214.83327 | 37.7111496346342 | -122.438437697477 | (37.7111496346342, -122.438437697477) | 9 | 7 | 6 | 28861 | 5 | ||||
2787 | 194758 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 750 Phelps St | 43 | : | Tree | Private 2 | 1 | Width 2ft | 6015105.78884 | 2097790.25184 | 37.740981275571 | -122.390336854658 | (37.740981275571, -122.390336854658) | 10 | 3 | 8 | 58 | 1 | |||
2789 | 8033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005024.9178 | 2111594.5788 | 37.7783203593831 | -122.426175354969 | (37.7783203593831, -122.426175354969) | 7 | 9 | 11 | 28852 | 10 | |||
2791 | 140089 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1230 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001847.5446 | 2112676.9734 | 37.781112239936 | -122.437244568568 | (37.781112239936, -122.437244568568) | 15 | 5 | 11 | 29490 | 41 | |||
2804 | 115921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777610 | 6013791.45387 | 2116146.74475 | 37.7913111540478 | -122.396167553395 | (37.7913111540478, -122.396167553395) | 12 | 2 | 9 | 28855 | 6 | |
2859 | 31668 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 215#3 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | 11 | Permit Number 35176 | 6010250.9256 | 2121284.082 | 37.8052193918816 | -122.408780346054 | (37.8052193918816, -122.408780346054) | 3 | 1 | 10 | 308 | 23 | |
2905 | 1627 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 793 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995638.85175 | 2110861.15065 | 37.7757715757475 | -122.458591918245 | (37.7757715757475, -122.458591918245) | 11 | 6 | 2 | 54 | 11 | |||
2918 | 258100 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 250 Woolsey St | 2 | Sidewalk: Curb side : | Tree | DPW 1 | 3 | 4x5 | 6011000.65781 | 2092015.53827 | 37.7248965615024 | -122.404124654724 | (37.7248965615024, -122.404124654724) | 10 | 3 | 7 | 309 | 28 |
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) );