trees
3,267 rows where qSpecies_id = 67 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119172 | 189010 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1734 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014844.65282 | 2096707.75266 | 37.7379944669672 | -122.391164127549 | (37.7379944669672, -122.391164127549) | 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 | |||
119610 | 199922 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1266 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016715.5112 | 2092875.0009 | 37.7275741378954 | -122.384428708392 | (37.7275741378954, -122.384428708392) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
119960 | 27529 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1430 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015974.48783 | 2094842.30112 | 37.7329349481517 | -122.387127616668 | (37.7329349481517, -122.387127616668) | 10 | 3 | 8 | 58 | 1 | |||
120204 | 188982 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1795 Silver Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011420.41619 | 2095369.36572 | 37.7341289182 | -122.402909366101 | (37.7341289182, -122.402909366101) | 10 | 3 | 8 | 58 | 1 | |||
120436 | 188992 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6012717.62552 | 2095118.35856 | 37.7335120543411 | -122.398406869804 | (37.7335120543411, -122.398406869804) | 10 | 3 | 8 | 58 | 1 | |||
121445 | 54628 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | 8 | Permit Number 10451 | 6012754.31078 | 2095657.32991 | 37.734994001272 | -122.398317840498 | (37.734994001272, -122.398317840498) | 10 | 3 | 8 | 58 | 1 | ||
122515 | 188283 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1550 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6015797.00991 | 2097048.5879 | 37.7389831357492 | -122.387895105398 | (37.7389831357492, -122.387895105398) | 10 | 3 | 8 | 58 | 1 | |||
124139 | 199836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1614 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014539.2994 | 2092746.6465 | 37.7271011243984 | -122.39194298147 | (37.7271011243984, -122.39194298147) | 10 | 3 | 8 | 58 | 1 | |||
124267 | 54478 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 107 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10270 | 6012476.33052 | 2095283.47327 | 37.7339519802024 | -122.399252687573 | (37.7339519802024, -122.399252687573) | 10 | 3 | 8 | 58 | 1 | ||
124316 | 188265 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1328 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017184.66383 | 2095498.60443 | 37.7348039673342 | -122.382989344098 | (37.7348039673342, -122.382989344098) | 10 | 3 | 8 | 58 | 1 | |||
125321 | 199917 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1301 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016454.9595 | 2092989.0267 | 37.7278728191084 | -122.385337388901 | (37.7278728191084, -122.385337388901) | 10 | 3 | 8 | 58 | 1 | |||
125540 | 54553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.398188716748 | (37.7349720434069, -122.398188716748) | 10 | 3 | 8 | 58 | 1 | ||
125991 | 66267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.7183287129789 | -122.394793038594 | (37.7183287129789, -122.394793038594) | 10 | 3 | 8 | 58 | 1 | ||
126615 | 188274 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6017787.78599 | 2094078.1936 | 37.7309371055483 | -122.380805411565 | (37.7309371055483, -122.380805411565) | 10 | 3 | 8 | 58 | 1 | |||
127449 | 175613 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 423 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012234.29342 | 2086673.78527 | 37.7102980342056 | -122.399485238767 | (37.7102980342056, -122.399485238767) | 10 | 3 | 8 | 309 | 1 | |||
128843 | 188959 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6014904.41664 | 2096665.80836 | 37.7378826129007 | -122.390954562096 | (37.7378826129007, -122.390954562096) | 10 | 3 | 8 | 58 | 1 | |||
129384 | 188997 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1767 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014660.79146 | 2096773.85465 | 37.7381657644348 | -122.391804452922 | (37.7381657644348, -122.391804452922) | 10 | 3 | 8 | 58 | 1 | |||
129719 | 67678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1566 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 11 | Permit Number 31282 | 6014784.0524 | 2093614.4352 | 37.7294974829563 | -122.391157497644 | (37.7294974829563, -122.391157497644) | 10 | 3 | 8 | 58 | 1 | |
130397 | 189014 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 La Salle Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014907.9841 | 2096659.95705 | 37.7378667443547 | -122.390941818707 | (37.7378667443547, -122.390941818707) | 10 | 3 | 8 | 58 | 1 | |||
130473 | 189007 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1739 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014800.47126 | 2096669.79143 | 37.7378877812889 | -122.39131423337 | (37.7378877812889, -122.39131423337) | 10 | 3 | 8 | 58 | 1 | |||
131166 | 54149 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | 10 | 3 | 8 | 58 | 1 | ||
131733 | 199974 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1415 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6017164.7983 | 2092702.5998 | 37.7271255921495 | -122.382863510542 | (37.7271255921495, -122.382863510542) | 10 | 3 | 8 | 58 | 1 | |||
133897 | 18805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017853.0028401 | 2094472.3604 | 37.7320230094763 | -122.380607331399 | (37.7320230094763, -122.380607331399) | 10 | 3 | 8 | 58 | 1 | |||
134018 | 199831 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1611 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014689.1314 | 2092911.7053 | 37.7275626599151 | -122.391436544053 | (37.7275626599151, -122.391436544053) | 10 | 3 | 8 | 58 | 1 | |||
135039 | 1881 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45X Lillian St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017774.309035 | 2094355.975399 | 37.7316990960952 | -122.380871307769 | (37.7316990960952, -122.380871307769) | 10 | 3 | 8 | 58 | 1 | |||
135531 | 188279 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017754.54552 | 2094265.39597 | 37.7314492919381 | -122.380933340095 | (37.7314492919381, -122.380933340095) | 10 | 3 | 8 | 58 | 1 | |||
135760 | 188273 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017757.59248 | 2094104.75072 | 37.7310083597514 | -122.380911642168 | (37.7310083597514, -122.380911642168) | 10 | 3 | 8 | 58 | 1 | |||
136783 | 189011 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014856.73876 | 2096625.96923 | 37.7377705771381 | -122.391116625339 | (37.7377705771381, -122.391116625339) | 10 | 3 | 8 | 58 | 1 | |||
137319 | 188954 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1715 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014917.05879 | 2096584.25216 | 37.7376593777724 | -122.390905153366 | (37.7376593777724, -122.390905153366) | 10 | 3 | 8 | 58 | 1 | |||
138175 | 56385 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 8 | Permit Number 12536 | 6016338.1795 | 2092806.6957 | 37.7273657127679 | -122.385728401086 | (37.7273657127679, -122.385728401086) | 10 | 3 | 8 | 58 | 1 | ||
138213 | 1898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 95 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017638.1071524 | 2094354.0127634 | 37.7316861888132 | -122.381342053504 | (37.7316861888132, -122.381342053504) | 10 | 3 | 8 | 58 | 1 | |||
138597 | 188266 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 9 Navy Rd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6018074.33224 | 2093577.43791 | 37.7295779385535 | -122.379779984755 | (37.7295779385535, -122.379779984755) | 10 | 3 | 8 | 58 | 1 | |||
139264 | 188259 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017275.09944 | 2095200.58275 | 37.7339906555386 | -122.382655942916 | (37.7339906555386, -122.382655942916) | 10 | 3 | 8 | 58 | 1 | |||
139327 | 188976 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012701.46766 | 2095447.24575 | 37.734414210138 | -122.398485802392 | (37.734414210138, -122.398485802392) | 10 | 3 | 8 | 58 | 1 | |||
139453 | 188964 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014781.8509 | 2096758.64006 | 37.7381307079579 | -122.391384822955 | (37.7381307079579, -122.391384822955) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
141981 | 18789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018114.760056 | 2094395.2295851 | 37.7318256648951 | -122.379697013742 | (37.7318256648951, -122.379697013742) | 10 | 3 | 8 | 58 | 1 | |||
143096 | 188255 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013785.15628 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | 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 | ||||
144127 | 53510 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1326 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12541 | 6016208.73 | 2092903.6451 | 37.7276247527235 | -122.386182668022 | (37.7276247527235, -122.386182668022) | 10 | 3 | 8 | 58 | 1 | ||
144464 | 188967 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1762 La Salle Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6014711.29129 | 2096810.32377 | 37.7382687044232 | -122.391632397311 | (37.7382687044232, -122.391632397311) | 10 | 3 | 8 | 58 | 1 | |||
144466 | 64657 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 160 Boutwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1988 12:00:00 AM | 11 | Permit Number 25583 | 6010631.28531 | 2095737.02804 | 37.7350943449268 | -122.405663540735 | (37.7350943449268, -122.405663540735) | 10 | 3 | 8 | 58 | 1 | ||
145095 | 188978 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6012675.73904 | 2095460.82203 | 37.7344500544215 | -122.398575707611 | (37.7344500544215, -122.398575707611) | 10 | 3 | 8 | 58 | 1 | |||
145586 | 199918 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6017172.7159 | 2092880.7849 | 37.7276152910588 | -122.382848534061 | (37.7276152910588, -122.382848534061) | 10 | 3 | 8 | 58 | 1 | |||
145958 | 202113 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6011995.35784 | 2092813.4202 | 37.7271429099005 | -122.400742097966 | (37.7271429099005, -122.400742097966) | 10 | 3 | 8 | 58 | 1 | |||
146208 | 188276 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017913.92599 | 2094045.4475 | 37.7308541521008 | -122.380367045109 | (37.7308541521008, -122.380367045109) | 10 | 3 | 8 | 58 | 1 | |||
146423 | 53514 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1382 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1969 12:00:00 AM | 3 | Permit Number 6426 | 6015935.5088 | 2093105.8067 | 37.7281647222543 | -122.38714130029 | (37.7281647222543, -122.38714130029) | 10 | 3 | 8 | 58 | 1 | ||
146531 | 188991 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012694.22698 | 2095131.74113 | 37.7335474966104 | -122.398488704497 | (37.7335474966104, -122.398488704497) | 10 | 3 | 8 | 58 | 1 | |||
146724 | 189012 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014880.56648 | 2096608.52309 | 37.7377239958591 | -122.391033021681 | (37.7377239958591, -122.391033021681) | 10 | 3 | 8 | 58 | 1 | |||
146950 | 53727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9406 | 6012545.27593 | 2095206.78524 | 37.7337452530338 | -122.399008939832 | (37.7337452530338, -122.399008939832) | 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 | |||
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 | ||
149580 | 188939 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2225 Jerrold Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012171.90247 | 2099321.56683 | 37.7450227605042 | -122.400588763562 | (37.7450227605042, -122.400588763562) | 10 | 3 | 8 | 58 | 1 | |||
149708 | 99544 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6016344.2389 | 2093074.9592 | 37.7281026467009 | -122.385726142965 | (37.7281026467009, -122.385726142965) | 10 | 3 | 8 | 58 | 1 | |||
150498 | 188998 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1763 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014675.4243 | 2096763.70844 | 37.7381387173342 | -122.391753150211 | (37.7381387173342, -122.391753150211) | 10 | 3 | 8 | 58 | 1 | |||
151316 | 199946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1215 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6017105.5123 | 2092851.5899 | 37.7275314140336 | -122.383078828854 | (37.7275314140336, -122.383078828854) | 10 | 3 | 8 | 58 | 1 | |||
151342 | 175610 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 333 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012573.19218 | 2086887.11282 | 37.7109026735915 | -122.398328885071 | (37.7109026735915, -122.398328885071) | 10 | 3 | 8 | 309 | 1 | |||
152103 | 188983 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012689.1535 | 2095267.6369 | 37.7339203555395 | -122.398515777692 | (37.7339203555395, -122.398515777692) | 10 | 3 | 8 | 58 | 1 | |||
152199 | 5813 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 73 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X4 | 6016158.83077 | 2096436.54005 | 37.7373226140504 | -122.386601417133 | (37.7373226140504, -122.386601417133) | 10 | 3 | 8 | 58 | 1 | |||
153372 | 202110 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6011956.80735 | 2092843.90085 | 37.7272244532319 | -122.40087750799 | (37.7272244532319, -122.40087750799) | 10 | 3 | 8 | 58 | 1 | |||
153655 | 188260 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017298.63225 | 2095158.35952 | 37.7338760189594 | -122.382571644977 | (37.7338760189594, -122.382571644977) | 10 | 3 | 8 | 58 | 1 | |||
153943 | 1890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6017765.907514 | 2094082.2550294 | 37.7309470499267 | -122.380881332108 | (37.7309470499267, -122.380881332108) | 10 | 3 | 8 | 58 | 1 | |||
154087 | 38560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1539 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40525 | 6015686.9214 | 2095659.8019 | 37.7351637119843 | -122.388178849076 | (37.7351637119843, -122.388178849076) | 10 | 3 | 8 | 58 | 1 | |
154372 | 199842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1600 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6014590.4616 | 2092707.6658 | 37.7269969314771 | -122.391763388572 | (37.7269969314771, -122.391763388572) | 10 | 3 | 8 | 58 | 1 | |||
154820 | 188284 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1535 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015844.31945 | 2096941.47577 | 37.7386916484079 | -122.387724057934 | (37.7386916484079, -122.387724057934) | 10 | 3 | 8 | 58 | 1 | |||
155826 | 202069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Jamestown Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012889.60074 | 2090482.04244 | 37.7207912554832 | -122.397487253644 | (37.7207912554832, -122.397487253644) | 10 | 3 | 8 | 58 | 1 | |||
156418 | 188280 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017796.93346 | 2094324.7108 | 37.7316144983135 | -122.380790917192 | (37.7316144983135, -122.380790917192) | 10 | 3 | 8 | 58 | 1 | |||
156554 | 199840 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014663.7903 | 2092751.8046 | 37.7271221981368 | -122.391512974974 | (37.7271221981368, -122.391512974974) | 10 | 3 | 8 | 58 | 1 | |||
156580 | 175607 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Hester Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6012544.08177 | 2088322.31575 | 37.7148418345529 | -122.398530142577 | (37.7148418345529, -122.398530142577) | 10 | 3 | 8 | 309 | 1 | |||
157206 | 188944 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015253.92457 | 2099115.96743 | 37.7446296326645 | -122.389917233688 | (37.7446296326645, -122.389917233688) | 10 | 3 | 8 | 58 | 1 | ||||
157731 | 188950 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1739 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014798.53304 | 2096673.37347 | 37.7378975092664 | -122.391321185129 | (37.7378975092664, -122.391321185129) | 10 | 3 | 8 | 58 | 1 | |||
158120 | 199874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1471 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015597.8383 | 2093627.4608 | 37.7295783756022 | -122.388345043424 | (37.7295783756022, -122.388345043424) | 10 | 3 | 8 | 58 | 1 | |||
158245 | 199924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1262 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016730.9349 | 2092862.3314 | 37.727540202809 | -122.384374505972 | (37.727540202809, -122.384374505972) | 10 | 3 | 8 | 58 | 1 | |||
158311 | 1876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017644.79908 | 2094278.98738 | 37.7314805532838 | -122.381313702976 | (37.7314805532838, -122.381313702976) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
160463 | 202109 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6011952.26669 | 2092845.65038 | 37.7272290038035 | -122.400893327982 | (37.7272290038035, -122.400893327982) | 10 | 3 | 8 | 58 | 1 | |||
161159 | 189002 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1751 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014734.97611 | 2096719.27261 | 37.7380200113206 | -122.391544142355 | (37.7380200113206, -122.391544142355) | 10 | 3 | 8 | 58 | 1 | |||
161366 | 46208 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 297 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | 12 | Permit Number 44524 | 6012148.34549 | 2087261.89541 | 37.711908076982 | -122.399823563722 | (37.711908076982, -122.399823563722) | 10 | 3 | 8 | 309 | 1 | ||
161750 | 202070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Jamestown Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012852.30909 | 2090513.27274 | 37.7208749311243 | -122.39761834962 | (37.7208749311243, -122.39761834962) | 10 | 3 | 8 | 58 | 1 | |||
162824 | 200063 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1898 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014797.2431 | 2094040.9343 | 37.7306692955134 | -122.391141695293 | (37.7306692955134, -122.391141695293) | 10 | 3 | 8 | 58 | 1 | |||
162944 | 54555 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 38 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 12 | 3x3 | Permit Number 10350 | 6012738.64094 | 2095530.58324 | 37.73464510839 | -122.398363126764 | (37.73464510839, -122.398363126764) | 10 | 3 | 8 | 58 | 1 | |
163711 | 188272 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017665.18673 | 2094248.36681 | 37.7313976007006 | -122.381241089926 | (37.7313976007006, -122.381241089926) | 10 | 3 | 8 | 58 | 1 | |||
167470 | 1885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | 10 | 3 | 8 | 58 | 1 | |||
168064 | 105549 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6017207.7562 | 2092857.3745 | 37.7275529466122 | -122.382725769768 | (37.7275529466122, -122.382725769768) | 10 | 3 | 8 | 58 | 1 | |||
169896 | 199679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1367 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016002.7124 | 2092981.3148 | 37.7278266134379 | -122.386900294245 | (37.7278266134379, -122.386900294245) | 10 | 3 | 8 | 58 | 1 | |||
170078 | 188995 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1778 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014630.30597 | 2096869.69067 | 37.7384272180298 | -122.391916557016 | (37.7384272180298, -122.391916557016) | 10 | 3 | 8 | 58 | 1 | |||
170129 | 188945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6015211.76442 | 2099058.69599 | 37.744470038975 | -122.390059016307 | (37.744470038975, -122.390059016307) | 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 | ||
170599 | 1887 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | 10 | 3 | 8 | 58 | 1 | |||
172398 | 200734 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1434 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 6015941.8417 | 2094834.993 | 37.7329130736504 | -122.387239974213 | (37.7329130736504, -122.387239974213) | 10 | 3 | 8 | 58 | 1 | |||
172467 | 38559 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1538 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 9 | Permit Number 40524 | 6015720.042 | 2095709.5571 | 37.7353021647635 | -122.388067809168 | (37.7353021647635, -122.388067809168) | 10 | 3 | 8 | 58 | 1 | |
172584 | 1886 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | 10 | 3 | 8 | 58 | 1 | |||
172692 | 50945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1356 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | 11 | Permit Number 47441 | 6016050.0855 | 2093024.8319 | 37.7279487256885 | -122.386739556348 | (37.7279487256885, -122.386739556348) | 10 | 3 | 8 | 58 | 1 | ||
172819 | 189000 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1758 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014726.1313 | 2096798.25376 | 37.7382363863881 | -122.391580243831 | (37.7382363863881, -122.391580243831) | 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 | ||||
174469 | 199925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1314 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6016264.3657 | 2092862.8823 | 37.727515905313 | -122.385987492696 | (37.727515905313, -122.385987492696) | 10 | 3 | 8 | 58 | 1 | |||
175046 | 189016 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1708 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014940.47928 | 2096636.31619 | 37.7378036344353 | -122.390827814378 | (37.7378036344353, -122.390827814378) | 10 | 3 | 8 | 58 | 1 | |||
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 |
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) );