trees
3,587 rows where qSpecies_id = 28 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127971 | 142408 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5997793.8437 | 2114545.4848 | 37.7860114098886 | -122.451403087084 | (37.7860114098886, -122.451403087084) | 11 | 6 | 1 | 54 | 31 | |||
133516 | 142397 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5997908.5687 | 2114561.3906 | 37.7860616516624 | -122.451007318993 | (37.7860616516624, -122.451007318993) | 11 | 6 | 1 | 54 | 31 | |||
136901 | 142434 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5997490.7869 | 2114502.336 | 37.7858755765928 | -122.452448461146 | (37.7858755765928, -122.452448461146) | 11 | 6 | 1 | 54 | 31 | |||
141465 | 142392 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | Width 0ft | 5997992.4973 | 2114571.2048 | 37.7860934034035 | -122.450717657836 | (37.7860934034035, -122.450717657836) | 11 | 6 | 1 | 54 | 31 | |||
158968 | 142441 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5997429.025 | 2114493.8755 | 37.7858488076403 | -122.452661528246 | (37.7858488076403, -122.452661528246) | 11 | 6 | 1 | 54 | 31 | |||
167085 | 142411 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5997746.1262 | 2114536.3474 | 37.7859835885172 | -122.45156751655 | (37.7859835885172, -122.45156751655) | 11 | 6 | 1 | 54 | 31 | |||
168333 | 142445 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5997392.137 | 2114489.8144 | 37.7858355432461 | -122.452788856559 | (37.7858355432461, -122.452788856559) | 11 | 6 | 1 | 54 | 31 | |||
168578 | 142439 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5997443.9155 | 2114497.5981 | 37.7858598821031 | -122.452610280289 | (37.7858598821031, -122.452610280289) | 11 | 6 | 1 | 54 | 31 | |||
172257 | 142412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5997733.6046 | 2114534.6553 | 37.7859782253852 | -122.45161071556 | (37.7859782253852, -122.45161071556) | 11 | 6 | 1 | 54 | 31 | |||
176395 | 142389 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5998056.7974 | 2114581.3575 | 37.7861249604509 | -122.450495929916 | (37.7861249604509, -122.450495929916) | 11 | 6 | 1 | 54 | 31 | |||
177026 | 142431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 0ft | 5997523.9523 | 2114506.3971 | 37.785888627357 | -122.452334011803 | (37.785888627357, -122.452334011803) | 11 | 6 | 1 | 54 | 31 | |||
181666 | 142430 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 0ft | 5997534.1049 | 2114507.4123 | 37.7858919964517 | -122.452298960079 | (37.7858919964517, -122.452298960079) | 11 | 6 | 1 | 54 | 31 | |||
181708 | 142410 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5997761.6936 | 2114540.07 | 37.7859947012667 | -122.451513926458 | (37.7859947012667, -122.451513926458) | 11 | 6 | 1 | 54 | 31 | |||
194242 | 142394 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5997948.164 | 2114566.1285 | 37.7860769274284 | -122.450870672307 | (37.7860769274284, -122.450870672307) | 11 | 6 | 1 | 54 | 31 | |||
85687 | 212013 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 San Leandro Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 8ft | 5992290.98987 | 2096599.94632 | 37.7364210535804 | -122.469134745476 | (37.7364210535804, -122.469134745476) | 1 | 8 | 4 | 59 | 40 | |||
184671 | 212012 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 San Leandro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 8ft | 5992283.16393 | 2096610.94284 | 37.7364507950541 | -122.469162602898 | (37.7364507950541, -122.469162602898) | 1 | 8 | 4 | 59 | 40 | |||
57866 | 47600 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
117053 | 47599 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
36447 | 57112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 3x3 | Permit Number 14382 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||
41049 | 245880 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6001356.1804 | 2109123.6874 | 37.771327867059 | -122.438689752936 | (37.771327867059, -122.438689752936) | 15 | 5 | 11 | 29492 | 9 | |||
48290 | 245882 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6001380 | 2109122 | 37.7713245889133 | -122.438607239112 | (37.7713245889133, -122.438607239112) | 15 | 5 | 11 | 29492 | 9 | |||
66649 | 121100 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||||
97995 | 121098 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||||
111727 | 245879 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 20 | Width 0ft | Permit Number 14382 | 6001380 | 2109122 | 37.7713245889133 | -122.438607239112 | (37.7713245889133, -122.438607239112) | 15 | 5 | 11 | 29492 | 9 | |
141191 | 245881 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6001380 | 2109122 | 37.7713245889133 | -122.438607239112 | (37.7713245889133, -122.438607239112) | 15 | 5 | 11 | 29492 | 9 | |||
152061 | 121099 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||||
33929 | 126323 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6013218.19178 | 2116960.71116 | 37.7935142007749 | -122.398208171762 | (37.7935142007749, -122.398208171762) | 4 | 1 | 10 | 28860 | 6 | |||
61486 | 67390 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1992 12:00:00 AM | 21 | Permit Number 30887 | 6013339.22791 | 2116980.96183 | 37.7935765453846 | -122.397790795502 | (37.7935765453846, -122.397790795502) | 4 | 1 | 10 | 28860 | 6 | ||
76298 | 126322 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6013251.89041 | 2116966.13143 | 37.7935309605345 | -122.398091951502 | (37.7935309605345, -122.398091951502) | 4 | 1 | 10 | 28860 | 6 | |||
148249 | 126320 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6013315.31247 | 2116974.36665 | 37.7935571047345 | -122.397873082591 | (37.7935571047345, -122.397873082591) | 4 | 1 | 10 | 28860 | 6 | |||
189363 | 126321 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6013275.05108 | 2116971.76517 | 37.7935477194132 | -122.398012208604 | (37.7935477194132, -122.398012208604) | 4 | 1 | 10 | 28860 | 6 | |||
118999 | 94568 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Carl St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
28479 | 126251 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6007028.01622 | 2112773.92137 | 37.7816715629397 | -122.419329563908 | (37.7816715629397, -122.419329563908) | 7 | 9 | 9 | 28852 | 36 | |||
82317 | 206370 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37411 | 5995131.60036 | 2099773.99475 | 37.7452999315413 | -122.45954343988 | (37.7452999315413, -122.45954343988) | 1 | 8 | 4 | 59 | 40 | |
88319 | 248805 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Portola Dr | 1 | : | Tree | Private 2 | 17 | Width 0ft | 5999637.97904 | 2100901.53104 | 37.7486539639231 | -122.444042185502 | (37.7486539639231, -122.444042185502) | 2 | 4 | 5 | 28862 | 22 | |||
1723 | 19755 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
3449 | 19754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1845 | 20002 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
4083 | 19998 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
45933 | 33219 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
126326 | 33217 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
136387 | 33218 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
150835 | 206374 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/06/1996 12:00:00 AM | 16 | Width 3ft | Permit Number 37411 | 5995150.27092 | 2099717.15619 | 37.7451449406021 | -122.459474764954 | (37.7451449406021, -122.459474764954) | 1 | 8 | 4 | 59 | 40 | |
161760 | 33216 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
161824 | 206373 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995163.12674 | 2099738.31218 | 37.7452037688521 | -122.459431843925 | (37.7452037688521, -122.459431843925) | 1 | 8 | 4 | 59 | 40 | |||
170739 | 206421 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vista Verde Ct | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 5999151.52522 | 2096101.94804 | 37.7354476975529 | -122.445379278655 | (37.7354476975529, -122.445379278655) | 9 | 7 | 4 | 63 | 40 | |||
43481 | 107218 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.473576991848 | (37.7269912477326, -122.473576991848) | 9 | 8 | 4 | 64 | 40 | ||||
141196 | 107220 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 WINSTON DR | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.473576991848 | (37.7269912477326, -122.473576991848) | 9 | 8 | 4 | 64 | 40 | |||||
194483 | 265134 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Winston Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | ||||
34221 | 248857 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008571.44851 | 2095653.7232 | 37.7347502067579 | -122.41277927356 | (37.7347502067579, -122.41277927356) | 10 | 7 | 7 | 28859 | 2 | |||
41128 | 8145 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6002886.96217 | 2111360.68278 | 37.7775570672136 | -122.433554609066 | (37.7775570672136, -122.433554609066) | 15 | 5 | 11 | 29492 | 41 | |||
82745 | 8148 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002886.96217 | 2111360.68278 | 37.7775570672136 | -122.433554609066 | (37.7775570672136, -122.433554609066) | 15 | 5 | 11 | 29492 | 41 | |||
173278 | 8147 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002886.96217 | 2111360.68278 | 37.7775570672136 | -122.433554609066 | (37.7775570672136, -122.433554609066) | 15 | 5 | 11 | 29492 | 41 | |||
22935 | 12652 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5992352.41288 | 2114839.20557 | 37.7865047992766 | -122.470250187524 | (37.7865047992766, -122.470250187524) | 11 | 6 | 1 | 54 | 11 | |||
124735 | 12651 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992370.23809 | 2114839.71142 | 37.7865072187383 | -122.470188554132 | (37.7865072187383, -122.470188554132) | 11 | 6 | 1 | 54 | 11 | |||
35907 | 248657 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 111 | Front Yard : Yard | Tree | Private 2 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | 2 | 7 | 5 | 63 | 7 | ||||
63771 | 248654 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 81 | Front Yard : Yard | Tree | Private 2 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.424913285419 | (37.7383130275105, -122.424913285419) | 2 | 7 | 5 | 28859 | 7 | ||||
169341 | 248656 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 110 | Front Yard : Yard | Tree | Private 2 | 16 | 6005044.37292 | 2096931.03803 | 37.7380588251561 | -122.42506444708 | (37.7380588251561, -122.42506444708) | 2 | 7 | 5 | 63 | 7 | ||||
192711 | 248655 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 107 | Front Yard : Yard | Tree | Private 2 | 16 | 6005056.20315 | 2096946.76695 | 37.7381026814961 | -122.425024662861 | (37.7381026814961, -122.425024662861) | 2 | 7 | 5 | 63 | 7 | ||||
23585 | 2101 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
100422 | 2100 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
158607 | 2102 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
177013 | 2095 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
184582 | 2097 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
192084 | 2099 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
49495 | 16378 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Moraga St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.7562325975726 | -122.473821451692 | (37.7562325975726, -122.473821451692) | 1 | 8 | 4 | 56 | 12 | |||
26505 | 212298 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991179.12071 | 2090094.55389 | 37.7184945623549 | -122.472504777687 | (37.7184945623549, -122.472504777687) | 9 | 8 | 4 | 64 | 24 | |||
29710 | 205081 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 32 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.472431176281 | (37.7198427189488, -122.472431176281) | 9 | 8 | 4 | 64 | 24 | |||
33604 | 212310 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 5991202.25987 | 2090434.65049 | 37.7194297232904 | -122.472449576395 | (37.7194297232904, -122.472449576395) | 9 | 8 | 4 | 64 | 24 | |||
40099 | 212306 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.7191513597144 | -122.472463376508 | (37.7191513597144, -122.472463376508) | 9 | 8 | 4 | 64 | 24 | |||
47699 | 205077 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 28 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991206.77223 | 2090490.87743 | 37.7195843698014 | -122.472438075876 | (37.7195843698014, -122.472438075876) | 9 | 8 | 4 | 64 | 24 | |||
48819 | 205088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 41 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 5991229.30633 | 2090865.43732 | 37.7206141232198 | -122.472387475503 | (37.7206141232198, -122.472387475503) | 9 | 8 | 4 | 64 | 24 | |||
63500 | 212305 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5991194.3003 | 2090309.58448 | 37.7190858620976 | -122.472467976539 | (37.7190858620976, -122.472467976539) | 9 | 8 | 4 | 64 | 24 | |||
65602 | 212292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991164.37326 | 2089829.54432 | 37.7177660575462 | -122.472536442798 | (37.7177660575462, -122.472536442798) | 9 | 8 | 4 | 64 | 24 | |||
73900 | 205076 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991204.86961 | 2090463.7504 | 37.7195097755318 | -122.472442675902 | (37.7195097755318, -122.472442675902) | 9 | 8 | 4 | 64 | 24 | |||
75104 | 212303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5991192.11842 | 2090269.21075 | 37.7189748794765 | -122.472472576576 | (37.7189748794765, -122.472472576576) | 9 | 8 | 4 | 64 | 24 | |||
77599 | 205083 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 35 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991217.1837 | 2090700.70485 | 37.720161106826 | -122.472417376171 | (37.720161106826, -122.472417376171) | 9 | 8 | 4 | 64 | 24 | |||
79244 | 212297 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 11 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991177.82743 | 2090064.76298 | 37.7184126889791 | -122.47250707726 | (37.7184126889791, -122.47250707726) | 9 | 8 | 4 | 64 | 24 | |||
80166 | 212307 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 23 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991200.21272 | 2090369.09522 | 37.7192496061609 | -122.47245187595 | (37.7192496061609, -122.47245187595) | 9 | 8 | 4 | 64 | 24 | |||
80664 | 205087 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 40 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991229.32936 | 2090834.95737 | 37.7205304341251 | -122.472385175045 | (37.7205304341251, -122.472385175045) | 9 | 8 | 4 | 64 | 24 | |||
85091 | 205082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 34 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991216.27623 | 2090657.65451 | 37.7200428486756 | -122.472417376165 | (37.7200428486756, -122.472417376165) | 9 | 8 | 4 | 64 | 24 | |||
85551 | 212308 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 24 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.472449576408 | (37.7193278390954, -122.472449576408) | 9 | 8 | 4 | 64 | 24 | |||
90111 | 205090 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 44 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991232.93514 | 2090942.88536 | 37.7208269864641 | -122.472380575028 | (37.7208269864641, -122.472380575028) | 9 | 8 | 4 | 64 | 24 | |||
93497 | 205084 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 36 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991220.51447 | 2090732.43963 | 37.7202484354919 | -122.472408175222 | (37.7202484354919, -122.472408175222) | 9 | 8 | 4 | 64 | 24 | |||
95983 | 205079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 5991209.09369 | 2090537.87387 | 37.7197135448202 | -122.47243347583 | (37.7197135448202, -122.47243347583) | 9 | 8 | 4 | 64 | 24 | |||
126423 | 212299 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991184.2984 | 2090150.76712 | 37.7186492097602 | -122.472490976674 | (37.7186492097602, -122.472490976674) | 9 | 8 | 4 | 64 | 24 | |||
134308 | 205078 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991207.21899 | 2090512.07145 | 37.7196425892212 | -122.472438075876 | (37.7196425892212, -122.472438075876) | 9 | 8 | 4 | 64 | 24 | |||
134716 | 212302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5991190.15994 | 2090239.43451 | 37.7188930078858 | -122.47247717658 | (37.7188930078858, -122.47247717658) | 9 | 8 | 4 | 64 | 24 | |||
136840 | 212294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991166.95703 | 2089883.01903 | 37.7179130355286 | -122.472531408396 | (37.7179130355286, -122.472531408396) | 9 | 8 | 4 | 64 | 24 | |||
138333 | 212304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 20 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991192.55124 | 2090289.74279 | 37.7190312804608 | -122.472472576553 | (37.7190312804608, -122.472472576553) | 9 | 8 | 4 | 64 | 24 | |||
142560 | 205085 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 38 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991225.77549 | 2090792.62573 | 37.720413996187 | -122.472394375116 | (37.720413996187, -122.472394375116) | 9 | 8 | 4 | 64 | 24 | |||
151461 | 212296 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5991176.06439 | 2090044.25898 | 37.7183562879852 | -122.472511677268 | (37.7183562879852, -122.472511677268) | 9 | 8 | 4 | 64 | 24 | |||
158230 | 205089 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 42 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991231.16702 | 2090890.57712 | 37.7206832586037 | -122.472382875496 | (37.7206832586037, -122.472382875496) | 9 | 8 | 4 | 64 | 24 | |||
158682 | 212300 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991186.31185 | 2090192.49351 | 37.7187638967107 | -122.472487057435 | (37.7187638967107, -122.472487057435) | 9 | 8 | 4 | 64 | 24 | |||
161552 | 212309 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991201.91083 | 2090418.09259 | 37.7193842391693 | -122.472449576413 | (37.7193842391693, -122.472449576413) | 9 | 8 | 4 | 64 | 24 | |||
161638 | 205080 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 31 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991211.60542 | 2090562.33735 | 37.7197808608892 | -122.47242657625 | (37.7197808608892, -122.47242657625) | 9 | 8 | 4 | 64 | 24 | |||
162570 | 212293 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991165.05081 | 2089858.71083 | 37.7178461808423 | -122.472536226064 | (37.7178461808423, -122.472536226064) | 9 | 8 | 4 | 64 | 24 | |||
185411 | 205086 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 39 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991226.90116 | 2090814.46771 | 37.7204740340313 | -122.472392075543 | (37.7204740340313, -122.472392075543) | 9 | 8 | 4 | 64 | 24 | |||
188138 | 212301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991188.84719 | 2090215.08791 | 37.7188260821255 | -122.472479940192 | (37.7188260821255, -122.472479940192) | 9 | 8 | 4 | 64 | 24 | |||
190136 | 212295 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991170.53267 | 2089939.68134 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | 9 | 8 | 4 | 64 | 24 |
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) );