Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5901 | 5901 | 13142 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1799 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6003833.3629 | 2119660.0062 | 37.8003985594643 | -122.43087313241999 | (37.8003985594643, -122.43087313242) | ||
| 19209 | 19209 | 7446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008276.38457 | 2103575.68647 | 37.7564855903503 | -122.414359757402 | (37.7564855903503, -122.414359757402) | |||
| 100175 | 100175 | 10387 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1352 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999669.18514 | 2108830.5589 | 37.7704268951205 | -122.44450405514799 | (37.7704268951205, -122.444504055148) | |||
| 171701 | 171701 | 175770 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | ||||
| 175317 | 175317 | 188295 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 3 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.771047726812604 | -122.41517858743799 | (37.7710477268126, -122.415178587438) | |||
| 20005 | 20005 | 9345 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 216 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/1992 12:00:00 AM | 25 | 2X2 | 6000780.1302 | 2098439.42056 | 37.7419586830354 | -122.439916138241 | (37.7419586830354, -122.439916138241) | ||
| 21739 | 21739 | 22825 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.44508467424299 | (37.7436157369876, -122.445084674243) | ||
| 179938 | 179938 | 221344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 116 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008115.05984 | 2098024.5819 | 37.74123443831 | -122.414524882834 | (37.74123443831, -122.414524882834) | |||
| 61588 | 61588 | 56137 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 23 | Permit Number 12241 | 6012457.22858 | 2104373.65416 | 37.7589106059655 | -122.399956860327 | (37.7589106059655, -122.399956860327) | ||
| 47824 | 47824 | 204629 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 5997855.18506 | 2096638.3314 | 37.7368463906537 | -122.449899836933 | (37.7368463906537, -122.449899836933) | |||
| 133067 | 133067 | 204658 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5994773.2638 | 2095284.74721 | 37.732952958415105 | -122.46045727068001 | (37.7329529584151, -122.46045727068) | |||
| 176616 | 176616 | 112176 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 5986882.73557 | 2111785.73395 | 37.7778030939685 | -122.48894910976601 | (37.7778030939685, -122.488949109766) | |||
| 182374 | 182374 | 188342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 21 | Width 2ft | 6013082.28487 | 2096418.14951 | 37.7371013178729 | -122.397237243906 | (37.7371013178729, -122.397237243906) | |||
| 17274 | 17274 | 22551 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 33 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2X3 | 6001555.699019999 | 2098568.2188 | 37.74235645138 | -122.437243695762 | (37.74235645138, -122.437243695762) | ||
| 21278 | 21278 | 3458 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 58 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 20 | 3X3 | 5999628.35603 | 2099484.01235 | 37.7447612502235 | -122.443973626603 | (37.7447612502235, -122.443973626603) | ||
| 21641 | 21641 | 22552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | ||
| 180711 | 180711 | 188316 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.40005818423799 | (37.7578394396596, -122.400058184238) | |||
| 46843 | 46843 | 54597 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 630 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10420 | 6014092.76415 | 2104176.14538 | 37.7584593387525 | -122.394286543097 | (37.7584593387525, -122.394286543097) | ||
| 64374 | 64374 | 222581 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6001755.3451 | 2104807.77266 | 37.7595001250595 | -122.436999987566 | (37.7595001250595, -122.436999987566) | |||
| 147315 | 147315 | 222595 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002381.71285 | 2096266.74074 | 37.736084047029 | -122.434223097845 | (37.736084047029, -122.434223097845) | |||
| 174395 | 174395 | 188293 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6008175.899180001 | 2108871.2472900003 | 37.771020329842294 | -122.415082093787 | (37.7710203298423, -122.415082093787) | |||
| 185574 | 185574 | 188315 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012418.401980001 | 2104012.51765 | 37.757916839799705 | -122.400065779927 | (37.7579168397997, -122.400065779927) | |||
| 17603 | 17603 | 10401 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1360 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999635.0074 | 2108810.0697 | 37.770368686739396 | -122.44462080278 | (37.7703686867394, -122.44462080278) | |||
| 18107 | 18107 | 4392 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.734535279584605 | -122.43647449840799 | (37.7345352795846, -122.436474498408) | |||
| 21100 | 21100 | 4336 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001641.12667 | 2095893.9772400002 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | |||
| 22257 | 22257 | 125 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1032 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1990 12:00:00 AM | 18 | 3X3 | 6002008.22654 | 2107658.0827 | 37.767340750994 | -122.436329391899 | (37.767340750994, -122.436329391899) | ||
| 68293 | 68293 | 188331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 612 Texas St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.39528210428101 | (37.7585970807056, -122.395282104281) | |||
| 83292 | 83292 | 56149 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 18 | 4x4 | Permit Number 12256 | 5990938.77862 | 2112472.88916 | 37.7799257212488 | -122.474968166346 | (37.7799257212488, -122.474968166346) | |
| 99643 | 99643 | 9360 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 249 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 18 | 2X2 | 6001058.1823583 | 2098369.3077978003 | 37.741781994063295 | -122.438949702005 | (37.7417819940633, -122.438949702005) | ||
| 102340 | 102340 | 56923 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1974 12:00:00 AM | 18 | 3x3 | Permit Number 14165 | 6003709.0 | 2101851.0 | 37.751492377455705 | -122.430032361 | (37.7514923774557, -122.430032361) | |
| 135399 | 135399 | 221340 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1370 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6003881.33957 | 2100275.34472 | 37.747175754559706 | -122.42932404278099 | (37.7471757545597, -122.429324042781) | |||
| 140827 | 140827 | 4393 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001738.943443701 | 2095739.8615836997 | 37.7346008554747 | -122.436407710795 | (37.7346008554747, -122.436407710795) | |||
| 158902 | 158902 | 188314 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 209 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6012920.39435 | 2106015.17263 | 37.7634436657274 | -122.39847018924999 | (37.7634436657274, -122.39847018925) | |||
| 167088 | 167088 | 175765 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5988629.85447 | 2089774.3019599998 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | ||||
| 29365 | 29365 | 222548 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007220.93745 | 2097850.24968 | 37.740705488567706 | -122.417604094958 | (37.7407054885677, -122.417604094958) | |||
| 61670 | 61670 | 222577 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002861.59805 | 2105354.01605 | 37.7610627942241 | -122.433213052158 | (37.7610627942241, -122.433213052158) | |||
| 123294 | 123294 | 112175 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5986883.70014 | 2111802.41515 | 37.7778489521099 | -122.488946999613 | (37.7778489521099, -122.488946999613) | |||
| 132011 | 132011 | 204664 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 494 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5998245.72554 | 2095284.33404 | 37.73315097474371 | -122.448452092092 | (37.7331509747437, -122.448452092092) | ||||
| 176253 | 176253 | 56136 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 755 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 17 | Permit Number 12240 | 6012456.10249 | 2104419.18715 | 37.7590355667492 | -122.3999639524 | (37.7590355667492, -122.3999639524) | ||
| 181876 | 181876 | 204665 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 368 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999628.00963 | 2094984.6303599998 | 37.732406994366606 | -122.443651657603 | (37.7324069943666, -122.443651657603) | ||||
| 32947 | 32947 | 222552 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007202.63127 | 2097897.94559 | 37.740835420825206 | -122.417670770702 | (37.7408354208252, -122.417670770702) | |||
| 41763 | 41763 | 222502 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.764079039426704 | -122.42292369548599 | (37.7640790394267, -122.422923695486) | |||
| 74603 | 74603 | 66582 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 425 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 16 | Permit Number 29772 | 6004685.90241 | 2092879.2867599998 | 37.7269133660376 | -122.426015508917 | (37.7269133660376, -122.426015508917) | |
| 116738 | 116738 | 33527 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | 16 | Permit Number 37637 | 6007243.54484492 | 2097878.27946769 | 37.740783724234 | -122.41752791305001 | (37.740783724234, -122.41752791305) | ||
| 165755 | 165755 | 116373 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 366 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6014023.28278 | 2105408.18049 | 37.761838376751896 | -122.394613116617 | (37.7618383767519, -122.394613116617) | |||
| 173059 | 173059 | 221331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 38 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010755.04761 | 2100475.47625 | 37.7481120234562 | -122.40556927472 | (37.7481120234562, -122.40556927472) | |||
| 180450 | 180450 | 218271 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.738216134576795 | -122.467513887457 | (37.7382161345768, -122.467513887457) | |||
| 187063 | 187063 | 204661 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 218 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001436.20899 | 2095068.9547299999 | 37.7327414936084 | -122.437406337246 | (37.7327414936084, -122.437406337246) | |||
| 420 | 420 | 54426 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.758841631549394 | -122.400163199892 | (37.7588416315494, -122.400163199892) | |
| 92630 | 92630 | 112551 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 HIDALGO TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6004993.0 | 2107524.0 | 37.7671417328885 | -122.425995926974 | (37.7671417328885, -122.425995926974) | |||
| 137468 | 137468 | 175776 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004111.17595 | 2091728.8824200002 | 37.723722111883504 | -122.427920387213 | (37.7237221118835, -122.427920387213) | |||
| 149875 | 149875 | 222550 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 225 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007079.56626 | 2097589.10899 | 37.7399804982916 | -122.41807439541701 | (37.7399804982916, -122.418074395417) | |||
| 157176 | 157176 | 175775 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 17 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000241.49713 | 2093189.3269599997 | 37.7275124782167 | -122.44140191715799 | (37.7275124782167, -122.441401917158) | |||
| 158507 | 158507 | 221330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 44 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010719.770409999 | 2100462.45977 | 37.7480743103861 | -122.40569034596001 | (37.7480743103861, -122.40569034596) | |||
| 159199 | 159199 | 221332 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 20 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010823.13421 | 2100501.91136 | 37.7481884154637 | -122.405335693806 | (37.7481884154637, -122.405335693806) | |||
| 161999 | 161999 | 218270 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5992782.12061 | 2097251.65776 | 37.73823885594471 | -122.46748409202 | (37.7382388559447, -122.46748409202) | |||
| 187841 | 187841 | 221327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 936 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010186.18174 | 2103764.32859 | 37.757110656958204 | -122.407768272711 | (37.7571106569582, -122.407768272711) | |||
| 10112 | 10112 | 5081 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2562 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6002249.017000001 | 2096934.71698 | 37.737910623162705 | -122.434729631968 | (37.7379106231627, -122.434729631968) | |||
| 52591 | 52591 | 222563 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007620.90266 | 2100266.50742 | 37.747362491591296 | -122.41639226749201 | (37.7473624915913, -122.416392267492) | |||
| 55473 | 55473 | 222549 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.740603802237295 | -122.417680295405 | (37.7406038022373, -122.417680295405) | |||
| 73593 | 73593 | 222551 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 192 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007190.09246 | 2097874.19927 | 37.740769513115794 | -122.4177124426 | (37.7407695131158, -122.4177124426) | |||
| 97590 | 97590 | 104767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1111 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | |||
| 97932 | 97932 | 175756 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 837 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000844.62416 | 2089035.80235 | 37.7161421822999 | -122.439019362161 | (37.7161421822999, -122.439019362161) | |||
| 100229 | 100229 | 104766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1111 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | |||
| 115420 | 115420 | 68441 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 137 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 14 | Permit Number 32298 | 6009913.44601622 | 2099873.29602914 | 37.7464114730886 | -122.40843704647 | (37.7464114730886, -122.40843704647) | ||
| 180214 | 180214 | 175773 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990089.9017900005 | 2089410.48117 | 37.716553162587296 | -122.476219779021 | (37.7165531625873, -122.476219779021) | ||||
| 181339 | 181339 | 124077 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 701 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991933.739630001 | 2110279.93645 | 37.7739620806591 | -122.471366355942 | (37.7739620806591, -122.471366355942) | |||
| 24143 | 24143 | 221342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 211 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005048.208 | 2100165.37235 | 37.7469397877337 | -122.425281276331 | (37.7469397877337, -122.425281276331) | |||
| 24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
| 24896 | 24896 | 204623 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1880 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993786.05175 | 2102711.73048 | 37.7532887441949 | -122.46440934321801 | (37.7532887441949, -122.464409343218) | |||
| 31017 | 31017 | 222574 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 382 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003928.91308 | 2102165.887 | 37.752369435600706 | -122.429294326484 | (37.7523694356007, -122.429294326484) | |||
| 34144 | 34144 | 71268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | ||
| 34992 | 34992 | 222570 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.43643417821698 | (37.7496020939667, -122.436434178217) | |||
| 38265 | 38265 | 222573 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003673.95782 | 2101843.15091 | 37.7514688410299 | -122.43015298120301 | (37.7514688410299, -122.430152981203) | |||
| 41434 | 41434 | 175767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | ||||
| 41982 | 41982 | 188330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 214 Texas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013707.236830001 | 2106019.4851599997 | 37.763499309471506 | -122.395749036807 | (37.7634993094715, -122.395749036807) | |||
| 44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
| 46013 | 46013 | 221321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | |||
| 50304 | 50304 | 221348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.41789669659401 | (37.7380362287807, -122.417896696594) | |||
| 50847 | 50847 | 222571 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.43813013861099 | (37.7501768003212, -122.438130138611) | |||
| 53435 | 53435 | 222583 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001753.50389 | 2104887.2031 | 37.7597181171131 | -122.43701204208 | (37.7597181171131, -122.43701204208) | |||
| 60191 | 60191 | 188333 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013450.6432300005 | 2105637.1609900002 | 37.7624352541126 | -122.396609715869 | (37.7624352541126, -122.396609715869) | |||
| 67719 | 67719 | 222596 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 73 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002296.29369 | 2096683.33913 | 37.73722308157 | -122.43454820456002 | (37.73722308157, -122.43454820456) | |||
| 72610 | 72610 | 204630 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 304 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5997471.23605 | 2094490.2943 | 37.7309264189197 | -122.45107245665501 | (37.7309264189197, -122.451072456655) | |||
| 72824 | 72824 | 221349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007249.14169 | 2097018.19512 | 37.7384224381557 | -122.41744762190399 | (37.7384224381557, -122.417447621904) | |||
| 74635 | 74635 | 188296 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6008131.8967699995 | 2108889.4185900004 | 37.7710677511061 | -122.41523558646601 | (37.7710677511061, -122.415235586466) | |||
| 90156 | 90156 | 104503 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157 ALBION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | ||||
| 114222 | 114222 | 104501 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157163 ALBION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | |||
| 114944 | 114944 | 107444 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3333 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6x6 | 6006088.7 | 2103711.1 | 37.75673426875029 | -122.42193517624901 | (37.7567342687503, -122.421935176249) | |||
| 117266 | 117266 | 104504 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157-163 ALBION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | |||
| 154690 | 154690 | 222594 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1701 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003405.54742 | 2098267.585 | 37.7416359640346 | -122.430826033811 | (37.7416359640346, -122.430826033811) | |||
| 155534 | 155534 | 221325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006242.86506 | 2104074.32841 | 37.757740302885104 | -122.42142781086001 | (37.7577403028851, -122.42142781086) | |||
| 160599 | 160599 | 200647 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1579 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015511.5711 | 2095791.0834 | 37.735514467209995 | -122.388794265849 | (37.73551446721, -122.388794265849) | |||
| 161577 | 161577 | 188334 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013355.939119999 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | |||
| 175431 | 175431 | 204612 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992412.91605 | 2102688.13741 | 37.7531447159591 | -122.469156169131 | (37.7531447159591, -122.469156169131) | |||
| 177802 | 177802 | 222564 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007476.41433 | 2100201.5835700002 | 37.747176098992796 | -122.41688730020701 | (37.7471760989928, -122.416887300207) | |||
| 15038 | 15038 | 101157 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x5 | 6013434.11839 | 2105245.8196900003 | 37.7613597971466 | -122.396639434871 | (37.7613597971466, -122.396639434871) | |||
| 15120 | 15120 | 101159 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.39680143245701 | (37.7613518552239, -122.396801432457) | |||
| 18758 | 18758 | 4194 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | |||
| 18825 | 18825 | 3878 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 7 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2014 11:33:00 AM | 12 | 3X3 | 6002011.6108099995 | 2108665.28098 | 37.7701064612771 | -122.436389779582 | (37.7701064612771, -122.436389779582) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");