trees
953 rows where qSpecies_id = 60 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4049 | 185126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) | 1 | 8 | 3 | 64 | 35 | |||
24116 | 175767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | 1 | 8 | 4 | 64 | 14 | ||||
35216 | 204656 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Sargent St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993464.3561 | 2089166.28112 | 37.7160777557502 | -122.464538359982 | (37.7160777557502, -122.464538359982) | 9 | 8 | 6 | 64 | 24 | |||
36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
51550 | 175773 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990089.90179 | 2089410.48117 | 37.7165531625873 | -122.476219779021 | (37.7165531625873, -122.476219779021) | 1 | 8 | 4 | 64 | 14 | ||||
60384 | 204655 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 452 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.465299811433 | (37.7188834957636, -122.465299811433) | 9 | 8 | 6 | 64 | 24 | |||
60641 | 204654 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 222 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.468865962403 | (37.7165410523041, -122.468865962403) | 9 | 8 | 6 | 64 | 24 | |||
89898 | 175769 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989661.94364 | 2089233.64885 | 37.7160427982152 | -122.477686080452 | (37.7160427982152, -122.477686080452) | 1 | 8 | 4 | 64 | 14 | ||||
100041 | 19417 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.1028282 | 2096024.0271709 | 37.7346489082814 | -122.480477366023 | (37.7346489082814, -122.480477366023) | 1 | 8 | 3 | 64 | 35 | ||
101122 | 175771 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989791.93538 | 2089208.15493 | 37.7159803412063 | -122.477234910356 | (37.7159803412063, -122.477234910356) | 1 | 8 | 4 | 64 | 14 | ||||
108590 | 19415 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.8312093 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | 1 | 8 | 3 | 64 | 35 | ||
113811 | 175774 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | 1 | 8 | 4 | 64 | 14 | ||||
116061 | 19416 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 700X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989518.2187007 | 2096039.5354251 | 37.7347217027544 | -122.4786803033 | (37.7347217027544, -122.4786803033) | 1 | 8 | 3 | 64 | 35 | ||
119024 | 175766 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135 | (37.7167583770722, -122.47966897135) | 1 | 8 | 4 | 64 | 14 | ||||
120870 | 204653 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 131 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991405.61668 | 2090064.78105 | 37.7184259206928 | -122.471719713606 | (37.7184259206928, -122.471719713606) | 9 | 8 | 6 | 64 | 24 | |||
147837 | 52957 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 227 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48944 | 5992946.65383726 | 2088708.6513983 | 37.714791356792 | -122.466294530657 | (37.714791356792, -122.466294530657) | 9 | 8 | 6 | 64 | 24 | ||
164959 | 47376 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 454 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45293 | 5993277.02762299 | 2090193.33113846 | 37.718886987019 | -122.465260409649 | (37.718886987019, -122.465260409649) | 9 | 8 | 6 | 64 | 24 | ||
176963 | 175772 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.476824346492 | (37.716026738112, -122.476824346492) | 1 | 8 | 4 | 64 | 14 | ||||
183539 | 185068 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989159.6219 | 2096046.6038 | 37.7347202832405 | -122.47992059791 | (37.7347202832405, -122.47992059791) | 1 | 8 | 3 | 64 | 35 | |||
184553 | 175768 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989578.68884 | 2089185.36564 | 37.7159053925979 | -122.477970317478 | (37.7159053925979, -122.477970317478) | 1 | 8 | 4 | 64 | 14 | ||||
191530 | 175770 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | 1 | 8 | 4 | 64 | 14 | ||||
711 | 57691 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759 | 2096663 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | 2 | 7 | 5 | 63 | 7 | |
953 | 4237 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4018 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003765.90932 | 2100430.48709 | 37.747595203776 | -122.429734255035 | (37.747595203776, -122.429734255035) | 2 | 4 | 5 | 63 | 22 | |||
7037 | 222537 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 540 28th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6002401.94091 | 2099473.87361 | 37.7448912373558 | -122.43438238755 | (37.7448912373558, -122.43438238755) | 2 | 7 | 5 | 63 | 22 | |||
10865 | 260932 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 249 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001134 | 2098325 | 37.7416646487467 | -122.438684376046 | (37.7416646487467, -122.438684376046) | 2 | 7 | 5 | 63 | 7 | ||||
15684 | 204670 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999483.78605 | 2094717.68964 | 37.7316658109241 | -122.4441310961 | (37.7316658109241, -122.4441310961) | 9 | 7 | 4 | 63 | 40 | |||
22997 | 26483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 148 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2001 12:00:00 AM | 10 | 3X3 | 6001028.50664 | 2098685.10655 | 37.7426474144589 | -122.43907493846 | (37.7426474144589, -122.43907493846) | 2 | 7 | 5 | 63 | 7 | ||
23954 | 221341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 217 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.425437478672 | (37.7469275767478, -122.425437478672) | 2 | 7 | 5 | 63 | 22 | |||
24510 | 204663 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000334.21865 | 2095199.11319 | 37.7330361672695 | -122.44122551784 | (37.7330361672695, -122.44122551784) | 9 | 7 | 5 | 63 | 40 | ||||
24546 | 22552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | 2 | 7 | 5 | 63 | 7 | ||
31918 | 222594 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1701 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003405.54742 | 2098267.585 | 37.7416359640346 | -122.430826033811 | (37.7416359640346, -122.430826033811) | 2 | 7 | 5 | 63 | 7 | |||
34069 | 247043 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6002094.89222 | 2099164.93967 | 37.7440255436471 | -122.435422008318 | (37.7440255436471, -122.435422008318) | 2 | 7 | 5 | 63 | 22 | ||||
34526 | 22825 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.445084674243 | (37.7436157369876, -122.445084674243) | 2 | 7 | 5 | 63 | 7 | ||
34811 | 109380 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.445412771855 | (37.7506760851616, -122.445412771855) | 2 | 5 | 5 | 63 | 38 | |||||
36294 | 16142 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5999632.4946283 | 2094718.5075125 | 37.7316765391045 | -122.443617041287 | (37.7316765391045, -122.443617041287) | 9 | 7 | 4 | 63 | 40 | |||
37810 | 222597 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002444.78145 | 2096589.20481 | 37.7369730385666 | -122.434028087935 | (37.7369730385666, -122.434028087935) | 2 | 7 | 5 | 63 | 7 | |||
37830 | 31102 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.442077177628 | (37.7309993521219, -122.442077177628) | 9 | 7 | 4 | 63 | 40 | |
39796 | 222546 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002452.45425 | 2095510.12485 | 37.734010568315 | -122.433924450977 | (37.734010568315, -122.433924450977) | 2 | 7 | 5 | 63 | 7 | |||
41037 | 2244 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002231.00143 | 2095678.63178 | 37.7344606799209 | -122.434702126219 | (37.7344606799209, -122.434702126219) | 2 | 7 | 5 | 63 | 7 | |||
44101 | 4392 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.7345352795846 | -122.436474498408 | (37.7345352795846, -122.436474498408) | 2 | 7 | 5 | 63 | 7 | |||
51152 | 108581 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999463 | 2102872 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | 2 | 5 | 5 | 63 | 38 | |||||
51488 | 57741 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762 | 2096689 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | 2 | 7 | 5 | 63 | 7 | |
52992 | 4194 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | 2 | 4 | 5 | 63 | 22 | |||
59817 | 221362 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | 2 | 4 | 5 | 63 | 22 | |||
63468 | 204661 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 218 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001436.20899 | 2095068.95473 | 37.7327414936084 | -122.437406337246 | (37.7327414936084, -122.437406337246) | 9 | 7 | 5 | 63 | 40 | |||
65282 | 221342 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 211 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005048.208 | 2100165.37235 | 37.7469397877337 | -122.425281276331 | (37.7469397877337, -122.425281276331) | 2 | 7 | 5 | 63 | 22 | |||
65589 | 22551 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 33 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 20 | 2X3 | 6001555.69902 | 2098568.2188 | 37.74235645138 | -122.437243695762 | (37.74235645138, -122.437243695762) | 2 | 7 | 5 | 63 | 7 | ||
66818 | 222545 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002444.04339 | 2095477.86439 | 37.7339215111673 | -122.43395122468 | (37.7339215111673, -122.43395122468) | 2 | 7 | 5 | 63 | 7 | |||
73047 | 222544 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2885 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002432.22505 | 2095435.01424 | 37.7338031837708 | -122.433989022279 | (37.7338031837708, -122.433989022279) | 2 | 7 | 5 | 63 | 7 | |||
76615 | 4316 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002232.19854 | 2095653.46786 | 37.7343916535381 | -122.434696188605 | (37.7343916535381, -122.434696188605) | 2 | 7 | 5 | 63 | 7 | |||
77816 | 221364 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1243 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001375.81776 | 2100058.24789 | 37.7464374920934 | -122.437972374152 | (37.7464374920934, -122.437972374152) | 2 | 4 | 5 | 63 | 22 | |||
78470 | 222543 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004445.20895 | 2097256.60692 | 37.7389188989883 | -122.427159238823 | (37.7389188989883, -122.427159238823) | 2 | 7 | 5 | 63 | 7 | |||
85373 | 32334 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | Permit Number 36897 | 6000779.60429895 | 2103438.99609434 | 37.7556862897816 | -122.440276412657 | (37.7556862897816, -122.440276412657) | 2 | 4 | 5 | 63 | 38 | |||
99347 | 41261 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 136 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41948 | 6003783.84120513 | 2096452.6287084 | 37.73667393521 | -122.429388624637 | (37.73667393521, -122.429388624637) | 2 | 7 | 5 | 63 | 7 | |||
101498 | 204672 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 370 Monterey Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999659.74264 | 2094714.76051 | 37.7316678047238 | -122.443522570705 | (37.7316678047238, -122.443522570705) | 9 | 7 | 4 | 63 | 40 | |||
105406 | 95411 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467 | 2095594 | 37.734241695714 | -122.433880155045 | (37.734241695714, -122.433880155045) | 2 | 7 | 5 | 63 | 7 | |
106403 | 221358 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100 Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000996.09085 | 2097469.17329 | 37.7393069033887 | -122.439099895546 | (37.7393069033887, -122.439099895546) | 2 | 7 | 5 | 63 | 7 | |||
109634 | 9360 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 249 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 18 | 2X2 | 6001058.1823583 | 2098369.3077978 | 37.7417819940633 | -122.438949702005 | (37.7417819940633, -122.438949702005) | 2 | 7 | 5 | 63 | 7 | ||
113252 | 24476 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002281.2265789 | 2096676.7830479 | 37.7372042247503 | -122.43459982975 | (37.7372042247503, -122.43459982975) | 2 | 7 | 5 | 63 | 7 | |||
113673 | 9345 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 216 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/1992 12:00:00 AM | 25 | 2X2 | 6000780.1302 | 2098439.42056 | 37.7419586830354 | -122.439916138241 | (37.7419586830354, -122.439916138241) | 2 | 7 | 5 | 63 | 7 | ||
115356 | 34434 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38178 | 6002507.14171464 | 2096534.38214196 | 37.7368260470236 | -122.433808563627 | (37.7368260470236, -122.433808563627) | 2 | 7 | 5 | 63 | 7 | ||
115919 | 222538 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.433884694622 | (37.746271638232, -122.433884694622) | 2 | 7 | 5 | 63 | 22 | |||
116046 | 247045 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6002079.02681 | 2099155.53035 | 37.7439988068049 | -122.435476194275 | (37.7439988068049, -122.435476194275) | 2 | 7 | 5 | 63 | 22 | |||
123226 | 99273 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | DPW for City Agency | 02/01/2013 12:00:00 AM | 3 | 3x3 | 6002499 | 2095479.8 | 37.7339299445382 | -122.433761361452 | (37.7339299445382, -122.433761361452) | 2 | 7 | 5 | 63 | 7 | |
124805 | 204665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 368 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999628.00963 | 2094984.63036 | 37.7324069943666 | -122.443651657603 | (37.7324069943666, -122.443651657603) | 9 | 7 | 4 | 63 | 40 | ||||
127617 | 204671 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5999561.20485 | 2094716.80736 | 37.7316678047194 | -122.443863381386 | (37.7316678047194, -122.443863381386) | 9 | 7 | 4 | 63 | 40 | |||
130712 | 5081 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2562 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 6002249.017 | 2096934.71698 | 37.7379106231627 | -122.434729631968 | (37.7379106231627, -122.434729631968) | 2 | 7 | 5 | 63 | 7 | |||
134692 | 3447 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 26 Cameo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5999491.3304257 | 2099768.5267533 | 37.7455346409258 | -122.44446787704 | (37.7455346409258, -122.44446787704) | 2 | 7 | 5 | 63 | 22 | |||
139369 | 204660 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Vista Verde Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999210.55823 | 2096011.88167 | 37.7352037663304 | -122.445168706887 | (37.7352037663304, -122.445168706887) | 9 | 7 | 4 | 63 | 40 | |||
139909 | 3458 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 58 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 20 | 3X3 | 5999628.35603 | 2099484.01235 | 37.7447612502235 | -122.443973626603 | (37.7447612502235, -122.443973626603) | 2 | 7 | 5 | 63 | 22 | ||
140597 | 221357 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001001.40276 | 2097453.08562 | 37.7392630326712 | -122.439080376676 | (37.7392630326712, -122.439080376676) | 2 | 7 | 5 | 63 | 7 | |||
144714 | 4336 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001641.12667 | 2095893.97724 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | 2 | 7 | 5 | 63 | 7 | |||
147364 | 247042 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6002114.96817 | 2099165.77298 | 37.7440289718731 | -122.435352649906 | (37.7440289718731, -122.435352649906) | 2 | 7 | 5 | 63 | 22 | ||||
152126 | 204662 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 324 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000779.52136 | 2095089.88794 | 37.7327616159437 | -122.439678165028 | (37.7327616159437, -122.439678165028) | 9 | 7 | 5 | 63 | 40 | |||
153219 | 5139 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2895 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | Permit Number 772999 | 6002420.62305 | 2095396.76149 | 37.7336974920456 | -122.43402640033 | (37.7336974920456, -122.43402640033) | 2 | 7 | 5 | 63 | 7 | ||
153627 | 221363 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001383.2027 | 2099881.79885 | 37.7459534248155 | -122.437934201507 | (37.7459534248155, -122.437934201507) | 2 | 4 | 5 | 63 | 22 | |||
161172 | 222539 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1 Newburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002564.39948 | 2099984.11426 | 37.7463014588556 | -122.433857099823 | (37.7463014588556, -122.433857099823) | 2 | 7 | 5 | 63 | 22 | |||
164498 | 82438 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 34 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50574 | 6003937.17383095 | 2095914.17170256 | 37.7352041342879 | -122.42882011217 | (37.7352041342879, -122.42882011217) | 2 | 7 | 5 | 63 | 7 | ||
166131 | 31624 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 437 Burnett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | Permit Number 35141 | 5999729.14661554 | 2103006.40603622 | 37.7544386392977 | -122.443878137556 | (37.7544386392977, -122.443878137556) | 2 | 5 | 5 | 63 | 38 | |||
168450 | 221338 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005011.95513 | 2099285.1526 | 37.7445208578632 | -122.425344007646 | (37.7445208578632, -122.425344007646) | 2 | 7 | 5 | 63 | 22 | |||
168691 | 4867 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 35 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6000770.19287 | 2098181.89069 | 37.7412510011371 | -122.43993203733 | (37.7412510011371, -122.43993203733) | 2 | 7 | 5 | 63 | 7 | |||
168861 | 95412 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467 | 2095594 | 37.734241695714 | -122.433880155045 | (37.734241695714, -122.433880155045) | 2 | 7 | 5 | 63 | 7 | |
173979 | 4393 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001738.9434437 | 2095739.8615837 | 37.7346008554747 | -122.436407710795 | (37.7346008554747, -122.436407710795) | 2 | 7 | 5 | 63 | 7 | |||
176870 | 221340 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1370 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6003881.33957 | 2100275.34472 | 37.7471757545597 | -122.429324042781 | (37.7471757545597, -122.429324042781) | 2 | 7 | 5 | 63 | 22 | |||
177903 | 30798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 142 Acadia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | Permit Number 34664 | 6001440.7282053 | 2094773.69226545 | 37.7319310278176 | -122.437369578033 | (37.7319310278176, -122.437369578033) | 9 | 7 | 4 | 63 | 40 | ||
178518 | 222595 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002381.71285 | 2096266.74074 | 37.736084047029 | -122.434223097845 | (37.736084047029, -122.434223097845) | 2 | 7 | 5 | 63 | 7 | |||
179500 | 222596 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 73 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6002296.29369 | 2096683.33913 | 37.73722308157 | -122.43454820456 | (37.73722308157, -122.43454820456) | 2 | 7 | 5 | 63 | 7 | |||
182813 | 221339 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 451 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002975.42772 | 2099463.08044 | 37.7448941376564 | -122.432398607207 | (37.7448941376564, -122.432398607207) | 2 | 7 | 5 | 63 | 22 | |||
188063 | 247044 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6002079.83003 | 2099170.11996 | 37.7440389120707 | -122.435474460402 | (37.7440389120707, -122.435474460402) | 2 | 7 | 5 | 63 | 22 | |||
188225 | 84181 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50119 | 6004433.25452855 | 2097264.30389086 | 37.738939357085 | -122.427201119802 | (37.738939357085, -122.427201119802) | 2 | 7 | 5 | 63 | 7 | ||
189029 | 222540 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.7463254608451 | -122.433827665916 | (37.7463254608451, -122.433827665916) | 2 | 7 | 5 | 63 | 22 | |||
4688 | 204667 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 582 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997581.48097 | 2095279.2111 | 37.7330989075759 | -122.450748183599 | (37.7330989075759, -122.450748183599) | 9 | 7 | 4 | 59 | 40 | |||
9453 | 260830 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
18512 | 260829 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
27376 | 35610 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | 9 | 8 | 4 | 59 | 40 | |||
46413 | 218271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.7382161345768 | -122.467513887457 | (37.7382161345768, -122.467513887457) | 1 | 8 | 4 | 59 | 40 | |||
53155 | 46798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.462081536077 | (37.7338125312017, -122.462081536077) | 9 | 8 | 4 | 59 | 40 | ||
54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
60638 | 116949 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992936 | 2097647 | 37.7393332491746 | -122.466980791321 | (37.7393332491746, -122.466980791321) | 1 | 8 | 4 | 59 | 40 |
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) );