trees
3,267 rows where qSpecies_id = 67 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60084 | 108595 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1599x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005333 | 2119502 | 37.8000495685335 | -122.42567253315 | (37.8000495685335, -122.42567253315) | 13 | 9 | 1 | 57 | 17 | ||||
| 159796 | 108689 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1x LEXINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006493 | 2105817 | 37.7625393728527 | -122.420686449222 | (37.7625393728527, -122.420686449222) | 8 | 4 | 7 | 28859 | 19 | ||||
| 141001 | 10874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 170151 | 10875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1991 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 183819 | 10880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 188377 | 10883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 78278 | 108844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.7244529081486 | -122.405842528314 | (37.7244529081486, -122.405842528314) | 10 | 3 | 7 | 309 | 28 | |
| 54030 | 10885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1997 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 148501 | 10886 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1999 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 184439 | 10891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 147960 | 10892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 58006 | 10893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
| 111849 | 108950 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | |
| 121827 | 108969 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 678 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5994435.96542 | 2110902.37424 | 37.7758155585136 | -122.462755965343 | (37.7758155585136, -122.462755965343) | 11 | 6 | 2 | 54 | 11 | |||
| 159030 | 10904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017110.58947 | 2095748.73218 | 37.7354866750771 | -122.38326285221 | (37.7354866750771, -122.38326285221) | 10 | 3 | 8 | 58 | 1 | |||
| 39937 | 10905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.73561848511 | -122.383303451209 | (37.73561848511, -122.383303451209) | 10 | 3 | 8 | 58 | 1 | |||
| 152564 | 109192 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773182 | 5984114.7 | 2098211 | 37.7403687376469 | -122.497522091318 | (37.7403687376469, -122.497522091318) | 1 | 8 | 3 | 29491 | 35 |
| 22981 | 109263 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |
| 67897 | 109264 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |
| 105935 | 109717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.504020225851 | (37.7550220459753, -122.504020225851) | 1 | 8 | 3 | 56 | 35 |
| 15573 | 10975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 60964 | 10978 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 44905 | 1098 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5999519.61819 | 2089252.78521 | 37.7166624877513 | -122.443614779103 | (37.7166624877513, -122.443614779103) | 9 | 7 | 6 | 28861 | 25 | |||
| 79667 | 110211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | |
| 124940 | 110691 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 216 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774675 | 6005029.7 | 2100275 | 37.7472397544319 | -122.425353075464 | (37.7472397544319, -122.425353075464) | 2 | 7 | 5 | 63 | 22 | |
| 135291 | 111055 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 617 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5993600.71482 | 2113464.55815 | 37.7828024828617 | -122.465831491429 | (37.7828024828617, -122.465831491429) | 11 | 6 | 2 | 54 | 11 | |||
| 119857 | 111259 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 MADDUX AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2095211 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | 10 | 3 | 8 | 58 | 1 | ||||
| 173265 | 111260 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 MADDUX AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2095211 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | 10 | 3 | 8 | 58 | 1 | ||||
| 38494 | 111261 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 MADDUX AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2095211 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | 10 | 3 | 8 | 58 | 1 | ||||
| 143367 | 111262 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 MADDUX AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2095211 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | 10 | 3 | 8 | 58 | 1 | ||||
| 108884 | 111564 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 92463 | 111565 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 95331 | 111566 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
| 119607 | 111567 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6017125.6309 | 2092720.9201 | 37.727173731995 | -122.38300018763 | (37.727173731995, -122.38300018763) | 10 | 3 | 8 | 58 | 1 | |||
| 61271 | 111727 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 MAYWOOD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5994266 | 2095568 | 37.7337015061884 | -122.462231535938 | (37.7337015061884, -122.462231535938) | 9 | 8 | 4 | 59 | 40 | ||||
| 12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
| 150344 | 112155 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 501 SANCHEZ ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003633 | 2105226 | 37.7607550226872 | -122.430535972829 | (37.7607550226872, -122.430535972829) | 2 | 4 | 5 | 28862 | 3 | |||||
| 153112 | 112334 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 159 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992822 | 2097531 | 37.7390081617687 | -122.467366516657 | (37.7390081617687, -122.467366516657) | 1 | 8 | 4 | 59 | 40 | ||||
| 173082 | 112342 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 24 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993136 | 2098114 | 37.7406270554642 | -122.466323216699 | (37.7406270554642, -122.466323216699) | 1 | 8 | 4 | 59 | 40 | ||||
| 30374 | 112344 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 40 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993136 | 2098044 | 37.7404348530896 | -122.466318130629 | (37.7404348530896, -122.466318130629) | 1 | 8 | 4 | 59 | 40 | ||||
| 188 | 112351 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992711 | 2097652 | 37.7393339885882 | -122.467759098278 | (37.7393339885882, -122.467759098278) | 1 | 8 | 4 | 59 | 40 | ||||
| 15598 | 112413 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 469x IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
| 12234 | 112475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988753.5421 | 2104412.2034 | 37.7576664111078 | -122.481937145542 | (37.7576664111078, -122.481937145542) | 1 | 8 | 3 | 56 | 35 | |||
| 131266 | 112476 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X LAWTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988671 | 2104385 | 37.7575869171128 | -122.482220613518 | (37.7575869171128, -122.482220613518) | 1 | 8 | 3 | 56 | 35 | |||
| 148642 | 112477 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X LAWTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988671 | 2104385 | 37.7575869171128 | -122.482220613518 | (37.7575869171128, -122.482220613518) | 1 | 8 | 3 | 56 | 35 | |||
| 58174 | 112478 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X LAWTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988671 | 2104385 | 37.7575869171128 | -122.482220613518 | (37.7575869171128, -122.482220613518) | 1 | 8 | 3 | 56 | 35 | |||
| 90837 | 112479 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X LAWTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988671 | 2104385 | 37.7575869171128 | -122.482220613518 | (37.7575869171128, -122.482220613518) | 1 | 8 | 3 | 56 | 35 | |||
| 25143 | 112508 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 648 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993454.86238 | 2113520.61586 | 37.7829479875441 | -122.466340150769 | (37.7829479875441, -122.466340150769) | 11 | 6 | 2 | 54 | 11 | |||
| 120987 | 1126 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5998746.09202 | 2088752.48006 | 37.7152446168065 | -122.446252494655 | (37.7152446168065, -122.446252494655) | 9 | 7 | 6 | 28861 | 25 | |||
| 49840 | 112662 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
| 68604 | 112663 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
| 48078 | 112664 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
| 66884 | 112665 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
| 140643 | 112666 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
| 24252 | 112667 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
| 78634 | 112789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 8 | 3x3 | 6010300.14411 | 2116243.45137 | 37.7913818092657 | -122.408254279811 | (37.7913818092657, -122.408254279811) | 5 | 1 | 10 | 28857 | 21 | |||
| 100416 | 112791 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 7 | 6010302.18584 | 2116235.66689 | 37.7913605492861 | -122.408246666156 | (37.7913605492861, -122.408246666156) | 5 | 1 | 10 | 28857 | 21 | ||||
| 190625 | 112792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5 | 6010303.89255 | 2116225.84414 | 37.7913336739481 | -122.408240067851 | (37.7913336739481, -122.408240067851) | 5 | 1 | 10 | 28857 | 21 | ||||
| 40060 | 112793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 4 | Unaccepted Street : Cutout | Tree | Private 2 | 8 | 6010304.6147 | 2116218.08658 | 37.7913124139936 | -122.408237021841 | (37.7913124139936, -122.408237021841) | 5 | 1 | 10 | 28857 | 21 | ||||
| 187045 | 112794 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21x JOICE ST | 5 | Unaccepted Street : Cutout | Tree | Private 2 | 6010276 | 2116206 | 37.7912776248382 | -122.408335175586 | (37.7912776248382, -122.408335175586) | 5 | 1 | 10 | 28857 | 21 | |||||
| 184021 | 113500 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | 6011183.30408 | 2090581.60768 | 37.7209694867258 | -122.403392432416 | (37.7209694867258, -122.403392432416) | 10 | 3 | 7 | 309 | 28 | |||
| 68776 | 113504 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | 6011150.15882 | 2090569.37703 | 37.7209340525347 | -122.403506146294 | (37.7209340525347, -122.403506146294) | 10 | 3 | 7 | 309 | 28 | |||
| 59457 | 113505 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 13 | 3x3 | 6011134.80907 | 2090561.37437 | 37.7209112214707 | -122.403558643321 | (37.7209112214707, -122.403558643321) | 10 | 3 | 7 | 309 | 28 | |||
| 67586 | 113508 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 203 WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:06:00 AM | 3 | 4x4 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||
| 187941 | 113544 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 182 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6005841.47064 | 2092905.54198 | 37.7270506988092 | -122.422022592774 | (37.7270506988092, -122.422022592774) | 9 | 7 | 7 | 309 | 5 | |||
| 138590 | 113558 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998649 | 2106025 | 37.7626652756279 | -122.447830852725 | (37.7626652756279, -122.447830852725) | 15 | 5 | 11 | 29492 | 9 | ||||
| 154700 | 113559 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998649 | 2106025 | 37.7626652756279 | -122.447830852725 | (37.7626652756279, -122.447830852725) | 15 | 5 | 11 | 29492 | 9 | ||||
| 184646 | 113694 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009441 | 2103786 | 37.7571284172194 | -122.410346937481 | (37.7571284172194, -122.410346937481) | 2 | 4 | 7 | 28859 | 19 | |||
| 160717 | 113755 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6001200.73843 | 2089055.692 | 37.7162170508648 | -122.437789887305 | (37.7162170508648, -122.437789887305) | 9 | 7 | 6 | 28861 | 5 | |||
| 142504 | 113756 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Amazon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001223.92516 | 2089044.4895 | 37.7161876097347 | -122.437708941119 | (37.7161876097347, -122.437708941119) | 9 | 7 | 6 | 28861 | 5 | |||
| 51668 | 113856 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011184 | 2102716 | 37.7542879873687 | -122.40424363426 | (37.7542879873687, -122.40424363426) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4862 | 113857 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011184 | 2102716 | 37.7542879873687 | -122.40424363426 | (37.7542879873687, -122.40424363426) | 10 | 4 | 8 | 28859 | 19 | ||||
| 122957 | 114252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 514 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5990028.22875 | 2111827.59243 | 37.7781011043298 | -122.478070938377 | (37.7781011043298, -122.478070938377) | 11 | 6 | 2 | 55 | 26 | |||
| 189956 | 114253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5990028.62528 | 2111858.48615 | 37.778185952947 | -122.478071825887 | (37.778185952947, -122.478071825887) | 11 | 6 | 2 | 55 | 26 | |||
| 31295 | 114254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5990028.31515 | 2111880.20085 | 37.7782455574988 | -122.478074486712 | (37.7782455574988, -122.478074486712) | 11 | 6 | 2 | 55 | 26 | |||
| 114252 | 114255 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5990027.42737 | 2111898.86293 | 37.7782967468716 | -122.478078922587 | (37.7782967468716, -122.478078922587) | 11 | 6 | 2 | 55 | 26 | |||
| 80803 | 114256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5990027.88863 | 2111908.55807 | 37.7783233938141 | -122.478078035938 | (37.7783233938141, -122.478078035938) | 11 | 6 | 2 | 55 | 26 | |||
| 59639 | 114414 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 786 SANTIAGO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990542 | 2099782 | 37.7450569383371 | -122.475413934806 | (37.7450569383371, -122.475413934806) | 1 | 8 | 4 | 29491 | 40 | ||||
| 66943 | 114662 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | |||
| 157117 | 114663 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | ||||
| 130083 | 114664 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | ||||
| 23237 | 114665 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | ||||
| 110050 | 114702 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774513 | 6006534.54774 | 2092840.44849 | 37.7269110313963 | -122.41962201445 | (37.7269110313963, -122.41962201445) | 9 | 7 | 7 | 309 | 5 | ||
| 162462 | 114749 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3808 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2103620 | 37.7563089416613 | -122.432641640203 | (37.7563089416613, -122.432641640203) | 2 | 4 | 5 | 28862 | 3 | ||||
| 95657 | 114750 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3808 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002991 | 2103620 | 37.7563089416613 | -122.432641640203 | (37.7563089416613, -122.432641640203) | 2 | 4 | 5 | 28862 | 3 | ||||
| 164050 | 114792 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | ||||
| 87728 | 114804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2427 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 775689 | 5989172 | 2098830.2 | 37.7423640356628 | -122.480081453283 | (37.7423640356628, -122.480081453283) | 1 | 8 | 3 | 29491 | 35 | |||
| 181812 | 114958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 66 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | 1 | Permit Number 775977 | 5999698.38088 | 2087820.43772 | 37.7127397789845 | -122.44289408849 | (37.7127397789845, -122.44289408849) | 9 | 7 | 6 | 28861 | 5 | ||
| 169143 | 114980 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 281 32ND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5985853 | 2114037 | 37.7839242715215 | -122.492677119536 | (37.7839242715215, -122.492677119536) | 11 | 6 | 1 | 55 | 33 | ||||
| 38082 | 115170 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2483 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775167 | 5983603.3 | 2098266.1 | 37.7404900382804 | -122.499294352828 | (37.7404900382804, -122.499294352828) | 1 | 8 | 3 | 29491 | 35 | |||
| 19893 | 115197 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001219.3 | 2101182.5 | 37.7495155185031 | -122.438594134479 | (37.7495155185031, -122.438594134479) | 2 | 4 | 5 | 28862 | 22 | |||
| 74980 | 115241 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2401 FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6005332 | 2118242 | 37.7965898731316 | -122.425586268684 | (37.7965898731316, -122.425586268684) | 13 | 9 | 1 | 57 | 17 | |||
| 164827 | 115242 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2401 FRANKLIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6005332 | 2118242 | 37.7965898731316 | -122.425586268684 | (37.7965898731316, -122.425586268684) | 13 | 9 | 1 | 57 | 17 | |||
| 28706 | 115314 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 884 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001256 | 2101255 | 37.7497166738267 | -122.438472418798 | (37.7497166738267, -122.438472418798) | 2 | 4 | 5 | 28862 | 22 | ||||
| 153129 | 115315 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 884 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001256 | 2101255 | 37.7497166738267 | -122.438472418798 | (37.7497166738267, -122.438472418798) | 2 | 4 | 5 | 28862 | 22 | ||||
| 176776 | 116121 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1649x Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2x2 | 6014089.22572 | 2095251.14899 | 37.7339529820313 | -122.393674111091 | (37.7339529820313, -122.393674111091) | 10 | 3 | 8 | 58 | 1 | |||
| 171165 | 116590 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 830x PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002569 | 2111577 | 37.778132974581 | -122.434670017402 | (37.778132974581, -122.434670017402) | 15 | 5 | 11 | 29492 | 41 | |||
| 140570 | 116592 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 830x PIERCE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002569 | 2111577 | 37.778132974581 | -122.434670017402 | (37.778132974581, -122.434670017402) | 15 | 5 | 11 | 29492 | 41 | |||
| 32380 | 116594 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 830x PIERCE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002569 | 2111577 | 37.778132974581 | -122.434670017402 | (37.778132974581, -122.434670017402) | 15 | 5 | 11 | 29492 | 41 | |||
| 49756 | 116671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 |
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) );