trees
7,157 rows where qSpecies_id = 36 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9478 | 260514 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3025 22nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5989750.29916 | 2095052.76589 | 37.7320257582668 | -122.477805820702 | (37.7320257582668, -122.477805820702) | 1 | 8 | 4 | 64 | 35 | ||||
17930 | 178466 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1060 19th Ave | 1 | : | Tree | Private 2 | 8 | Width 2ft | 5991486.01297 | 2089088.38412 | 37.7157496246282 | -122.47137071551 | (37.7157496246282, -122.47137071551) | 9 | 8 | 6 | 64 | 24 | |||
18034 | 255666 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 275 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5993722 | 2089019 | 37.7156882061667 | -122.463637144214 | (37.7156882061667, -122.463637144214) | 9 | 8 | 6 | 64 | 24 | ||||
20595 | 211694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 389 Orizaba Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5994001.77202 | 2089064.43875 | 37.7158290869265 | -122.462673425937 | (37.7158290869265, -122.462673425937) | 9 | 8 | 6 | 64 | 24 | |||
28546 | 211737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2620 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5990989.53966 | 2094983.41832 | 37.7319071907544 | -122.473516484424 | (37.7319071907544, -122.473516484424) | 1 | 8 | 4 | 64 | 40 | |||
28842 | 211692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 389 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994002.35315 | 2089131.62839 | 37.7160136071206 | -122.462676288507 | (37.7160136071206, -122.462676288507) | 9 | 8 | 6 | 64 | 24 | |||
28929 | 211721 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 574 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5993531.71485 | 2089666.42893 | 37.7174549244787 | -122.464341829316 | (37.7174549244787, -122.464341829316) | 9 | 8 | 6 | 64 | 24 | |||
41014 | 211716 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 183 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992179.75042 | 2089087.63643 | 37.7157876785354 | -122.468972807246 | (37.7157876785354, -122.468972807246) | 9 | 8 | 6 | 64 | 24 | |||
43303 | 211727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 41 Ralston St | 10 | Back Yard : Yard | Tree | Private 2 | 6 | 5992176.51123 | 2088212.22362 | 37.7133838194885 | -122.468920334526 | (37.7133838194885, -122.468920334526) | 9 | 8 | 6 | 64 | 24 | ||||
45802 | 46737 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1 Sargent St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927279 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | 9 | 8 | 6 | 64 | 24 | |||
49801 | 211741 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Junipero Serra Blvd | 86 | : | Tree | Private 2 | 8 | Width 0ft | 5991245.41265 | 2092162.56077 | 37.7241766355394 | -122.472426315417 | (37.7241766355394, -122.472426315417) | 9 | 8 | 4 | 64 | 40 | |||
50491 | 211736 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2560 Ocean Ave | 2 | : | Tree | Private 2 | 11 | Width 3ft | 5991128.88067 | 2094900.31917 | 37.7316870897845 | -122.473028700209 | (37.7316870897845, -122.473028700209) | 1 | 8 | 4 | 64 | 40 | |||
53614 | 255672 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 231 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993718 | 2088745 | 37.714935637127 | -122.463631095472 | (37.714935637127, -122.463631095472) | 9 | 8 | 6 | 64 | 24 | ||||
55614 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 417 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
67922 | 1308 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4001 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X6 | 5991993.5561 | 2087124.92306 | 37.7103877820393 | -122.46947358665 | (37.7103877820393, -122.46947358665) | 9 | 8 | 4 | 64 | 24 | |||
69492 | 211724 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 41 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 4 | 5992178.33594 | 2088233.19341 | 37.7134415028968 | -122.468915552827 | (37.7134415028968, -122.468915552827) | 9 | 8 | 6 | 64 | 24 | ||||
70279 | 178467 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 47 Payson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991771.40529 | 2087760.02356 | 37.7121187737317 | -122.470287598994 | (37.7121187737317, -122.470287598994) | 9 | 8 | 4 | 64 | 24 | |||
76825 | 99728 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2645 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990840.1 | 2094977 | 37.7318809123737 | -122.474032655501 | (37.7318809123737, -122.474032655501) | 1 | 8 | 4 | 64 | 40 | ||||
79134 | 211732 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2523 Ocean Ave | 4 | : | Tree | Private 2 | 8 | Width 3ft | 5991281.16019 | 2094738.5485 | 37.7312517234746 | -122.472490455065 | (37.7312517234746, -122.472490455065) | 1 | 8 | 4 | 64 | 40 | |||
86327 | 211739 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2636 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5990909.57276 | 2095029.58953 | 37.7320293339707 | -122.473796311156 | (37.7320293339707, -122.473796311156) | 1 | 8 | 4 | 64 | 40 | |||
88903 | 211718 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 431 Arch St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 4ft | 5992705.44853 | 2090061.46649 | 37.7184919399203 | -122.467226533397 | (37.7184919399203, -122.467226533397) | 9 | 8 | 6 | 64 | 24 | |||
97090 | 211734 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2528 Ocean Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5991248.57861 | 2094829.52657 | 37.7314996404756 | -122.472609724971 | (37.7314996404756, -122.472609724971) | 1 | 8 | 4 | 64 | 40 | |||
97955 | 211693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 389 Orizaba Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994001.78179 | 2089084.64033 | 37.7158845562099 | -122.462674856769 | (37.7158845562099, -122.462674856769) | 9 | 8 | 6 | 64 | 24 | |||
99058 | 211738 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2620 Ocean Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5990968.08095 | 2094993.56064 | 37.7319337962922 | -122.473591410528 | (37.7319337962922, -122.473591410528) | 1 | 8 | 4 | 64 | 40 | |||
100420 | 211735 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2560 Ocean Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5991148.534 | 2094888.45325 | 37.7316556467951 | -122.472959890411 | (37.7316556467951, -122.472959890411) | 1 | 8 | 4 | 64 | 40 | |||
102326 | 211725 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 41 Ralston St | 7 | Back Yard : Yard | Tree | Private 2 | 5 | 5992180.34622 | 2088219.99909 | 37.7134053906231 | -122.468907645067 | (37.7134053906231, -122.468907645067) | 9 | 8 | 6 | 64 | 24 | ||||
104061 | 211726 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 41 Ralston St | 8 | Back Yard : Yard | Tree | Private 2 | 7 | 5992180.41529 | 2088216.96306 | 37.7133970584078 | -122.468907185537 | (37.7133970584078, -122.468907185537) | 9 | 8 | 6 | 64 | 24 | ||||
107594 | 211695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 347 Orizaba Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5993991.41433 | 2088846.96973 | 37.7152313723018 | -122.462693460129 | (37.7152313723018, -122.462693460129) | 9 | 8 | 6 | 64 | 24 | ||||
112468 | 211729 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2661 Ocean Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5990794.8642 | 2095022.31972 | 37.7320027284424 | -122.474192349201 | (37.7320027284424, -122.474192349201) | 1 | 8 | 4 | 64 | 40 | |||
125064 | 211723 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 47 Ralston St | 7 | Back Yard : Yard | Tree | Private 2 | 4 | 5992174.6999 | 2088241.19094 | 37.7134632521081 | -122.468928701793 | (37.7134632521081, -122.468928701793) | 9 | 8 | 6 | 64 | 24 | ||||
125330 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 717 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990427 | 2090598 | 37.7198333383806 | -122.475141254145 | (37.7198333383806, -122.475141254145) | 1 | 8 | 4 | 64 | 40 | |||||
126135 | 185061 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 57 Crestlake Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5988586.7909 | 2096247.4529 | 37.7352384655376 | -122.481915754777 | (37.7352384655376, -122.481915754777) | 1 | 8 | 3 | 64 | 35 | |||
127519 | 99727 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2645 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990840.1 | 2094977 | 37.7318809123737 | -122.474032655501 | (37.7318809123737, -122.474032655501) | 1 | 8 | 4 | 64 | 40 | ||||
129724 | 46736 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1 Sargent St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927279 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | 9 | 8 | 6 | 64 | 24 | |||
131601 | 46738 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927279 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | 9 | 8 | 6 | 64 | 24 | |||
131837 | 211740 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Junipero Serra Blvd | 63 | : | Tree | Private 2 | 9 | Width 0ft | 5991241.75535 | 2092369.00082 | 37.7247432569728 | -122.472454001056 | (37.7247432569728, -122.472454001056) | 9 | 8 | 4 | 64 | 40 | |||
142923 | 211731 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2523 Ocean Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5991252.31527 | 2094755.01275 | 37.73129526056 | -122.472591376108 | (37.73129526056, -122.472591376108) | 1 | 8 | 4 | 64 | 40 | |||
144208 | 211719 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 231 Ramsell St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992957.37852 | 2088756.71451 | 37.7149239453467 | -122.466260952875 | (37.7149239453467, -122.466260952875) | 9 | 8 | 6 | 64 | 24 | |||
145813 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
146779 | 116152 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2622 OCEAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990998 | 2095041 | 37.7320657854588 | -122.473491434083 | (37.7320657854588, -122.473491434083) | 1 | 8 | 4 | 64 | 40 | ||||
149957 | 39680 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 519 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41066 | 5992971.37473893 | 2090634.62644589 | 37.7200810456671 | -122.466348977018 | (37.7200810456671, -122.466348977018) | 9 | 8 | 6 | 64 | 24 | ||
151119 | 211728 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2660 Ocean Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5990772.88576 | 2095112.63352 | 37.7322494340502 | -122.474274920447 | (37.7322494340502, -122.474274920447) | 1 | 8 | 4 | 64 | 40 | |||
157727 | 211720 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 519 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992979.50273 | 2090619.40325 | 37.7200397154505 | -122.46631977576 | (37.7200397154505, -122.46631977576) | 9 | 8 | 6 | 64 | 24 | |||
164756 | 116153 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2620 OCEAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990977 | 2095007 | 37.7319712139076 | -122.47356155575 | (37.7319712139076, -122.47356155575) | 1 | 8 | 4 | 64 | 40 | ||||
167837 | 173628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 800X Brotherhood Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||
167846 | 211722 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 47 Ralston St | 6 | Back Yard : Yard | Tree | Private 2 | 8 | 5992176.84648 | 2088244.58976 | 37.7134727084689 | -122.468921529709 | (37.7134727084689, -122.468921529709) | 9 | 8 | 6 | 64 | 24 | ||||
175779 | 173626 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 800X Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||
178390 | 211730 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2645 Ocean Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5990851.63149 | 2094987.64857 | 37.7319108186222 | -122.473993565759 | (37.7319108186222, -122.473993565759) | 1 | 8 | 4 | 64 | 40 | |||
179536 | 46739 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1 Sargent St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927279 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | 9 | 8 | 6 | 64 | 24 | |||
181107 | 211717 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 431 Arch St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 5992705.60308 | 2090068.81731 | 37.7185121324114 | -122.467226533371 | (37.7185121324114, -122.467226533371) | 9 | 8 | 6 | 64 | 24 | |||
181383 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 755 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990427 | 2090598 | 37.7198333383806 | -122.475141254145 | (37.7198333383806, -122.475141254145) | 1 | 8 | 4 | 64 | 40 | |||||
188052 | 211733 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2523 Ocean Ave | 5 | : | Tree | Private 2 | 8 | Width 3ft | 5991297.32334 | 2094728.95859 | 37.7312263275125 | -122.472433877821 | (37.7312263275125, -122.472433877821) | 1 | 8 | 4 | 64 | 40 | |||
189341 | 211742 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Junipero Serra Blvd | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5991230.19236 | 2092152.91218 | 37.7241492619617 | -122.472478226094 | (37.7241492619617, -122.472478226094) | 9 | 8 | 4 | 64 | 40 | |||
5952 | 9359 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 248 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001030.76503 | 2098329.85795 | 37.7416721140896 | -122.439041675227 | (37.7416721140896, -122.439041675227) | 2 | 7 | 5 | 63 | 7 | ||
6208 | 47715 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 178 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45511 | 6001758.80730105 | 2095060.28518468 | 37.7327360238789 | -122.436290415986 | (37.7327360238789, -122.436290415986) | 9 | 7 | 5 | 63 | 40 | ||
7670 | 211848 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 46 Stillings Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000230.33136 | 2095714.69025 | 37.7344459031469 | -122.441621669199 | (37.7344459031469, -122.441621669199) | 9 | 7 | 5 | 63 | 40 | |||
7766 | 30822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | Permit Number 34679 | 6001848.24049432 | 2095191.22581593 | 37.7331006378237 | -122.435990589821 | (37.7331006378237, -122.435990589821) | 9 | 7 | 5 | 63 | 40 | |||
8622 | 256682 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 8 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
8900 | 234194 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 375 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6003458.09568 | 2099493.1742 | 37.7450041256393 | -122.430731778545 | (37.7450041256393, -122.430731778545) | 2 | 7 | 5 | 63 | 22 | |||
10117 | 247028 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 550x Valley St | 6 | Median : Yard | Tree | DPW 1 | 10 | 6002355.44127 | 2099181.99154 | 37.7440871579993 | -122.434522308567 | (37.7440871579993, -122.434522308567) | 2 | 7 | 5 | 63 | 22 | ||||
11160 | 243737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3 | Width 3ft | Permit Number 42146 | 6003566.61414 | 2096423.59732 | 37.7365819207118 | -122.430137601881 | (37.7365819207118, -122.430137601881) | 2 | 7 | 5 | 63 | 7 | |
11200 | 4249 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 4043 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1995 12:00:00 AM | 12 | 4x4 | 6003613.964 | 2100376.48243 | 37.7474383143284 | -122.430255820476 | (37.7474383143284, -122.430255820476) | 2 | 4 | 5 | 63 | 22 | ||
11753 | 211845 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 16 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1973 12:00:00 AM | 15 | Width 3ft | Permit Number 11714 | 6000344.48352 | 2095713.86547 | 37.7344501416455 | -122.441226949568 | (37.7344501416455, -122.441226949568) | 9 | 7 | 5 | 63 | 40 | |
15195 | 211662 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Brompton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002143.70362 | 2095479.08195 | 37.7339078054814 | -122.434989676339 | (37.7339078054814, -122.434989676339) | 2 | 7 | 5 | 63 | 7 | |||
16723 | 234185 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 113 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005061.79994 | 2099288.82021 | 37.7445337442515 | -122.425171915165 | (37.7445337442515, -122.425171915165) | 2 | 7 | 5 | 63 | 22 | |||
18962 | 211850 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 70 Stillings Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6000160.69053 | 2095717.4917 | 37.7344496272448 | -122.441862640756 | (37.7344496272448, -122.441862640756) | 9 | 7 | 5 | 63 | 40 | |||
19435 | 211660 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002152.71446 | 2095506.80314 | 37.7339844331387 | -122.434960505045 | (37.7339844331387, -122.434960505045) | 2 | 7 | 5 | 63 | 7 | |||
21565 | 235058 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 459 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003542.9119 | 2096359.45447 | 37.7364044565879 | -122.430214975956 | (37.7364044565879, -122.430214975956) | 2 | 7 | 5 | 63 | 7 | |||
21808 | 2253 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 40 Brompton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/1990 12:00:00 AM | 6 | 3X3 | 6002131.11056 | 2095479.12403 | 37.7339072059768 | -122.435033217323 | (37.7339072059768, -122.435033217323) | 2 | 7 | 5 | 63 | 7 | ||
22870 | 211846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 20 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000319.15387 | 2095715.02736 | 37.7344518890294 | -122.441314605601 | (37.7344518890294, -122.441314605601) | 9 | 7 | 5 | 63 | 40 | |||
22989 | 234997 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5349 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001815.4555 | 2098735.07088 | 37.7428293508835 | -122.436357476838 | (37.7428293508835, -122.436357476838) | 2 | 7 | 5 | 63 | 22 | |||
23380 | 236149 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 74 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003623.44985 | 2097893.78964 | 37.7406219514548 | -122.43004594206 | (37.7406219514548, -122.43004594206) | 2 | 7 | 5 | 63 | 7 | |||
23587 | 256680 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 6 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
23963 | 2249 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002175.63898 | 2095478.72159 | 37.7339086292652 | -122.434879240483 | (37.7339086292652, -122.434879240483) | 2 | 7 | 5 | 63 | 7 | ||
25442 | 236163 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 136 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004316.79506 | 2097329.09834 | 37.7391106812228 | -122.427608398006 | (37.7391106812228, -122.427608398006) | 2 | 7 | 5 | 63 | 7 | |||
25681 | 236178 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 24 Addison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003507.58493 | 2096904.50368 | 37.7378990363042 | -122.430375992359 | (37.7378990363042, -122.430375992359) | 2 | 7 | 5 | 63 | 7 | |||
25761 | 33837 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3943 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1997 12:00:00 AM | Permit Number 37851 | 6004250.30927987 | 2100701.51542662 | 37.7483668024919 | -122.428078539782 | (37.7483668024919, -122.428078539782) | 2 | 4 | 5 | 63 | 22 | |||
26510 | 211826 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 184 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001802.91254 | 2095182.34305 | 37.7330736726175 | -122.436146664936 | (37.7330736726175, -122.436146664936) | 9 | 7 | 5 | 63 | 40 | |||
28435 | 236181 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 32 Harry St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6003220.63755 | 2097676.79622 | 37.7400033159045 | -122.431423224995 | (37.7400033159045, -122.431423224995) | 2 | 7 | 5 | 63 | 7 | ||||
28572 | 236176 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 44 Miguel St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6003678.32801 | 2097312.06482 | 37.7390277763068 | -122.429814711994 | (37.7390277763068, -122.429814711994) | 2 | 7 | 5 | 63 | 7 | ||||
29979 | 247810 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 30th St | 5 | : | Tree | Private 2 | 12 | Width 3ft | 6003231.63041 | 2098356.70943 | 37.7418708237817 | -122.431433740768 | (37.7418708237817, -122.431433740768) | 2 | 7 | 5 | 63 | 22 | |||
30049 | 235057 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 109 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003455.05837 | 2096167.54613 | 37.7358725435864 | -122.430505033389 | (37.7358725435864, -122.430505033389) | 2 | 7 | 5 | 63 | 7 | |||
33281 | 30818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | 9 | Permit Number 34679 | 6001851.91271 | 2095252.38683 | 37.7332687805252 | -122.435982268868 | (37.7332687805252, -122.435982268868) | 9 | 7 | 5 | 63 | 40 | ||
33835 | 26485 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 168 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6000891.06606 | 2098710.64377 | 37.7427097122815 | -122.439551997339 | (37.7427097122815, -122.439551997339) | 2 | 7 | 5 | 63 | 7 | |||
34120 | 58949 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 91 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1980 12:00:00 AM | 3x3 | Permit Number 50911 | 6003609.463337 | 2097799.84135396 | 37.7403631988963 | -122.43008760169 | (37.7403631988963, -122.43008760169) | 2 | 7 | 5 | 63 | 7 | ||
35531 | 211829 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001864.14804 | 2095290.62534 | 37.733374469757 | -122.4359427032 | (37.733374469757, -122.4359427032) | 9 | 7 | 5 | 63 | 40 | |||
37057 | 234939 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001377.07938 | 2100033.48303 | 37.746369565406 | -122.437966238055 | (37.746369565406, -122.437966238055) | 2 | 4 | 5 | 63 | 22 | |||
39035 | 236159 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004325.74936 | 2097416.45831 | 37.7393510583066 | -122.427583660361 | (37.7393510583066, -122.427583660361) | 2 | 7 | 5 | 63 | 7 | |||
39950 | 236153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003754.04772 | 2097550.76904 | 37.7396874910799 | -122.42956992731 | (37.7396874910799, -122.42956992731) | 2 | 7 | 5 | 63 | 7 | |||
42448 | 234183 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 426 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003760.79939 | 2098969.25061 | 37.7435826976919 | -122.429647724088 | (37.7435826976919, -122.429647724088) | 2 | 7 | 5 | 63 | 22 | |||
43065 | 234188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 431 Day St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003193.94569 | 2098602.90337 | 37.7425446794999 | -122.431581614504 | (37.7425446794999, -122.431581614504) | 2 | 7 | 5 | 63 | 22 | |||
43176 | 94649 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 363 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53787 | 6004189 | 2098364 | 37.7419450553656 | -122.428123987508 | (37.7419450553656, -122.428123987508) | 2 | 7 | 5 | 63 | 7 | |
44325 | 4477 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1525 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004598.54266 | 2099993.54792 | 37.7464425831782 | -122.426823944579 | (37.7464425831782, -122.426823944579) | 2 | 7 | 5 | 63 | 22 | ||
44623 | 235056 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 48 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003703.89788 | 2096567.53718 | 37.7369849213109 | -122.429673216262 | (37.7369849213109, -122.429673216262) | 2 | 7 | 5 | 63 | 7 | |||
45459 | 236183 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 7 | Width 2ft | 6002335.35488 | 2096511.41776 | 37.7367532424671 | -122.434400864109 | (37.7367532424671, -122.434400864109) | 2 | 7 | 5 | 63 | 7 | |||
47499 | 247808 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 30th St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6003260.71831 | 2098357.66513 | 37.7418750964549 | -122.431333232546 | (37.7418750964549, -122.431333232546) | 2 | 7 | 5 | 63 | 22 | |||
48945 | 247813 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 30th St | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6003173.72803 | 2098352.92457 | 37.7418571495882 | -122.431633678058 | (37.7418571495882, -122.431633678058) | 2 | 7 | 5 | 63 | 22 | |||
49559 | 30824 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | 6 | Permit Number 34679 | 6001802.04804 | 2095064.12719 | 37.7327490299235 | -122.436141197052 | (37.7327490299235, -122.436141197052) | 9 | 7 | 5 | 63 | 40 | ||
50693 | 235066 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 596 Dellbrook Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 5997010.19872 | 2103808.86003 | 37.7564865103631 | -122.453338843539 | (37.7564865103631, -122.453338843539) | 1 | 5 | 4 | 63 | 38 | |||
50776 | 35405 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 206 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50565 | 6004580.90644064 | 2098724.42919099 | 37.7429568773749 | -122.426794562995 | (37.7429568773749, -122.426794562995) | 2 | 7 | 5 | 63 | 22 |
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) );