trees
3,587 rows where qSpecies_id = 28 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184686 | 189453 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 110 Mendell St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6016986.81524 | 2098398.61469 | 37.7427558780826 | -122.383875241966 | (37.7427558780826, -122.383875241966) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
184652 | 27412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1340X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004655.03099 | 2113461.96066 | 37.7834268147862 | -122.427588006915 | (37.7834268147862, -122.427588006915) | 7 | 9 | 11 | 28858 | 41 | |||
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 | |||
184525 | 6312 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1819 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002200.59773 | 2112898.10851 | 37.7817394844201 | -122.43603901137 | (37.7817394844201, -122.43603901137) | 15 | 5 | 11 | 29490 | 41 | |||
184476 | 248760 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2989 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008348.54161 | 2103274.24588 | 37.7556619561402 | -122.414088886997 | (37.7556619561402, -122.414088886997) | 2 | 4 | 7 | 28859 | 19 | |||
184361 | 248813 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 66 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 5997123.14904 | 2106092.58883 | 37.762763526431 | -122.453113075912 | (37.762763526431, -122.453113075912) | 15 | 5 | 11 | 29492 | 12 | |||
184334 | 12591 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 540 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 135 | 3X3 | 5993752.44537 | 2114880.64385 | 37.7866994199903 | -122.465409472784 | (37.7866994199903, -122.465409472784) | 11 | 6 | 1 | 54 | 11 | |||
184304 | 212260 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991277.37814 | 2090844.74627 | 37.7205600928662 | -122.472219800499 | (37.7205600928662, -122.472219800499) | 9 | 8 | 6 | 64 | 24 | |||
184250 | 206387 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 San Pablo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5994342.8206 | 2097706.80674 | 37.7395785633932 | -122.46212100211 | (37.7395785633932, -122.46212100211) | 1 | 8 | 4 | 59 | 40 | |||
184173 | 124253 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Lake St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5994641.05728 | 2114931.34747 | 37.7868898466259 | -122.462338789499 | (37.7868898466259, -122.462338789499) | 11 | 6 | 1 | 54 | 11 | |||
184140 | 14905 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017111.44356 | 2098535.62444 | 37.7431389677975 | -122.383453844133 | (37.7431389677975, -122.383453844133) | 10 | 3 | 8 | 58 | 1 | |||
184126 | 23942 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2334X Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003622.99851 | 2115966.72014 | 37.7902458233354 | -122.431337290596 | (37.7902458233354, -122.431337290596) | 13 | 9 | 1 | 29490 | 27 | |||
184113 | 212051 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 60 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993395.8495 | 2093423.18821 | 37.7277622406113 | -122.465084152224 | (37.7277622406113, -122.465084152224) | 9 | 8 | 4 | 59 | 40 | |||
184107 | 98549 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5.5x5.5 | 5996260 | 2091802.8 | 37.7234777811703 | -122.45506574959 | (37.7234777811703, -122.45506574959) | 9 | 8 | 4 | 28861 | 24 | ||||
184077 | 248741 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2225 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008194.44585 | 2105088.16613 | 37.7606339102356 | -122.414750166581 | (37.7606339102356, -122.414750166581) | 2 | 4 | 7 | 28859 | 19 | |||
184012 | 248705 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 307 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 6006497.3648 | 2096085.76853 | 37.7358198738733 | -122.419980755825 | (37.7358198738733, -122.419980755825) | 2 | 7 | 7 | 28859 | 2 | |||
183931 | 212152 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 6 | 5995399.05929 | 2094305.60657 | 37.7303004565891 | -122.458222905079 | (37.7303004565891, -122.458222905079) | 9 | 7 | 4 | 28861 | 40 | ||||
183873 | 126175 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2937 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6000994.24789 | 2118486.23794 | 37.7970144314291 | -122.440613342127 | (37.7970144314291, -122.440613342127) | 13 | 9 | 1 | 57 | 17 | |||
183839 | 50315 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
183716 | 16814 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2103 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6001244.3116739 | 2113148.4047409 | 37.7823723603633 | -122.439365250899 | (37.7823723603633, -122.439365250899) | 15 | 5 | 11 | 29490 | 41 | |||
183566 | 12268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 649 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004914.9427 | 2111132.93586 | 37.7770465844733 | -122.426522919775 | (37.7770465844733, -122.426522919775) | 7 | 9 | 11 | 28852 | 10 | |||
183501 | 212219 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Bosworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6001099.22416 | 2095737.89591 | 37.7345590873286 | -122.438619289753 | (37.7345590873286, -122.438619289753) | 9 | 7 | 5 | 63 | 7 | ||||
183493 | 23408 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1748X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006154.75993 | 2116452.26997 | 37.7917221783851 | -122.422612088488 | (37.7917221783851, -122.422612088488) | 13 | 9 | 10 | 28858 | 21 | |||
183489 | 16182 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 460 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999000.84123 | 2094724.10263 | 37.7316558563346 | -122.445801187471 | (37.7316558563346, -122.445801187471) | 9 | 7 | 4 | 59 | 40 | |||
183477 | 11717 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
183413 | 45817 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1168 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44444 | 6015539.10076278 | 2103555.89602939 | 37.7568365560705 | -122.389241112249 | (37.7568365560705, -122.389241112249) | 10 | 3 | 8 | 28856 | 29 | |||
183410 | 126310 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011567.70518 | 2121110.48267 | 37.804816396425 | -122.404211216594 | (37.804816396425, -122.404211216594) | 3 | 1 | 10 | 28860 | 6 | |||
183315 | 189525 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017891.20284 | 2096231.89923 | 37.7368564639644 | -122.38059752247 | (37.7368564639644, -122.38059752247) | 10 | 3 | 8 | 58 | 1 | |||
183286 | 256164 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Ripley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009435.00947 | 2099104.35545 | 37.7442733266503 | -122.410037156982 | (37.7442733266503, -122.410037156982) | 2 | 7 | 7 | 28859 | 2 | ||||
183285 | 222090 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3745 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003457.17118 | 2103586.87018 | 37.7562444011758 | -122.431027095231 | (37.7562444011758, -122.431027095231) | 2 | 4 | 5 | 28862 | 22 | |||
183274 | 43870 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1690 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2000 12:00:00 AM | Permit Number 43486 | 6005912.19454128 | 2092867.44050546 | 37.7269500690586 | -122.421775395752 | (37.7269500690586, -122.421775395752) | 9 | 7 | 7 | 309 | 5 | |||
183251 | 4771 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 20 Commer Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6016532.61927 | 2094742.5477 | 37.7326919364855 | -122.385191045451 | (37.7326919364855, -122.385191045451) | 10 | 3 | 8 | 58 | 1 | |||
183203 | 17737 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1802X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6002240.5506838 | 2112991.3064345 | 37.78199765203 | -122.435907463701 | (37.78199765203, -122.435907463701) | 15 | 5 | 11 | 29490 | 41 | |||
183180 | 250880 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 123 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5986777.36802 | 2114746.25153 | 37.7859256790604 | -122.489531361397 | (37.7859256790604, -122.489531361397) | 11 | 6 | 1 | 55 | 33 | |||
183101 | 13302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
183061 | 23267 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006632.0860756 | 2113221.2018047 | 37.7828773790282 | -122.420731060153 | (37.7828773790282, -122.420731060153) | 7 | 9 | 9 | 28852 | 36 | |||
183058 | 139812 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1624 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | 32 | Width 0ft | 6002737.4248 | 2112708.2774 | 37.7812487388446 | -122.434168269296 | (37.7812487388446, -122.434168269296) | 15 | 5 | 11 | 29490 | 41 | ||
183041 | 189443 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6017001.71377 | 2098118.43003 | 37.7419873714259 | -122.383804222493 | (37.7419873714259, -122.383804222493) | 10 | 3 | 8 | 58 | 1 | |||
182986 | 101306 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010065.3 | 2110009.9 | 37.7742528016184 | -122.408626907078 | (37.7742528016184, -122.408626907078) | 8 | 2 | 9 | 28853 | 34 | |||
182955 | 205496 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1651 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5993684.9556 | 2104264.78094 | 37.7575471923763 | -122.464871729673 | (37.7575471923763, -122.464871729673) | 1 | 8 | 4 | 56 | 12 | |||
182863 | 212039 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 55 San Leandro Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992379.72844 | 2096347.13539 | 37.7357320254043 | -122.468809550633 | (37.7357320254043, -122.468809550633) | 1 | 8 | 4 | 59 | 40 | |||
182744 | 29971 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 510X Junipero Serra Blvd | 15 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991358.83331002 | 2093789.78166754 | 37.7286511429928 | -122.472152796239 | (37.7286511429928, -122.472152796239) | 9 | 8 | 4 | 64 | 40 | ||
182735 | 63191 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 480 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 14 | 4x9 | Permit Number 23731 | 5984103.00663 | 2112603.98729 | 37.7798871547077 | -122.498625465556 | (37.7798871547077, -122.498625465556) | 11 | 6 | 2 | 55 | 26 |
182576 | 126326 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012125.00664 | 2117298.30563 | 37.7943802029417 | -122.40201444441 | (37.7943802029417, -122.40201444441) | 3 | 1 | 10 | 28860 | 4 | |||
182528 | 107815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 311 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5986808.71714 | 2113837.73031 | 37.7834329707826 | -122.489356078034 | (37.7834329707826, -122.489356078034) | 11 | 6 | 2 | 55 | 26 | |||
182506 | 30320 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 867 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/1955 12:00:00 AM | Permit Number 14 | 5988182.28713273 | 2110079.61323567 | 37.77319432354 | -122.484328404455 | (37.77319432354, -122.484328404455) | 11 | 6 | 2 | 55 | 26 | |||
182421 | 189487 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1402 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 4ft | 6016128.97098 | 2095756.63378 | 37.735454075532 | -122.38665725965 | (37.735454075532, -122.38665725965) | 10 | 3 | 8 | 58 | 1 | |||
182407 | 222953 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002449.55702 | 2102903.83172 | 37.7543117940721 | -122.434462931727 | (37.7543117940721, -122.434462931727) | 2 | 4 | 5 | 28862 | 22 | |||
182406 | 248780 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 114 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004544.44225 | 2095961.80754 | 37.7353692838552 | -122.42672395436 | (37.7353692838552, -122.42672395436) | 2 | 7 | 5 | 28861 | 2 | |||
182346 | 212031 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 77 San Leandro Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 8ft | 5992386.20843 | 2096111.49565 | 37.7350853921813 | -122.468770005625 | (37.7350853921813, -122.468770005625) | 1 | 8 | 4 | 59 | 40 | |||
182284 | 122330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2112291 | 37.7797254357482 | -122.45701712634 | (37.7797254357482, -122.45701712634) | 11 | 6 | 2 | 54 | 16 | ||||
182262 | 212208 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001453.89018 | 2095626.12972 | 37.7342723726763 | -122.437385092546 | (37.7342723726763, -122.437385092546) | 9 | 7 | 5 | 63 | 7 | |||
182102 | 113494 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2850 LAKE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986565 | 2114493 | 37.7852179229774 | -122.490247450243 | (37.7852179229774, -122.490247450243) | 11 | 6 | 1 | 55 | 33 | ||||
182086 | 109181 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 301x 28TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003894 | 2099493 | 37.7450283339929 | -122.429224487562 | (37.7450283339929, -122.429224487562) | 2 | 7 | 5 | 63 | 22 | ||||
182041 | 248886 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2250 Harrison St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008759.22642 | 2105202.36551 | 37.760979192353 | -122.412804913217 | (37.760979192353, -122.412804913217) | 2 | 4 | 7 | 28859 | 19 | |||
182033 | 176049 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989054.79394 | 2089564.29309 | 37.716915411303 | -122.479808833919 | (37.716915411303, -122.479808833919) | 1 | 8 | 4 | 64 | 14 | ||||
182001 | 248894 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2180 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008743.38004 | 2105510.25377 | 37.7618236935412 | -122.412881487815 | (37.7618236935412, -122.412881487815) | 2 | 4 | 7 | 28859 | 19 | |||
181950 | 189506 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Ironwood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018006.17491 | 2096063.96927 | 37.7364017055594 | -122.380188342614 | (37.7364017055594, -122.380188342614) | 10 | 3 | 8 | 58 | 1 | |||
181912 | 2131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
181894 | 248895 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2180 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008739.84494 | 2105526.86138 | 37.7618690957999 | -122.412894888598 | (37.7618690957999, -122.412894888598) | 2 | 4 | 7 | 28859 | 19 | |||
181852 | 248539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 107 Beulah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997585.1348 | 2107785.048 | 37.7674370554132 | -122.451637327839 | (37.7674370554132, -122.451637327839) | 15 | 5 | 11 | 29492 | 9 | |||
181845 | 121355 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
181789 | 11847 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
181765 | 97636 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
181719 | 137868 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1940 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003411.7404 | 2115439.0231 | 37.7887849266319 | -122.432030529424 | (37.7887849266319, -122.432030529424) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
181703 | 121352 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
181641 | 26469 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
181619 | 248792 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1607 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003371.3832 | 2098808.90761 | 37.7431203751162 | -122.430982787448 | (37.7431203751162, -122.430982787448) | 2 | 7 | 5 | 63 | 22 | |||
181568 | 1267 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5992203.06147 | 2087231.00688 | 37.7106911683351 | -122.468757212784 | (37.7106911683351, -122.468757212784) | 9 | 8 | 4 | 64 | 24 | |||
181483 | 11653 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
181411 | 26472 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
181309 | 108961 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X ORTEGA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992998 | 2102542 | 37.7527772506572 | -122.467122225509 | (37.7527772506572, -122.467122225509) | 1 | 8 | 4 | 29491 | 12 | ||||
181183 | 140397 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1250 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004651.2611 | 2113160.9476 | 37.7826000944505 | -122.427579596679 | (37.7826000944505, -122.427579596679) | 7 | 9 | 11 | 29490 | 41 | |||
181181 | 121348 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
181179 | 126201 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2475 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000210.86121 | 2117050.03799 | 37.7930263644331 | -122.443220836491 | (37.7930263644331, -122.443220836491) | 13 | 6 | 1 | 29490 | 27 | |||
181159 | 5075 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2518 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002273.67466 | 2097186.93566 | 37.7386045571491 | -122.434662408564 | (37.7386045571491, -122.434662408564) | 2 | 7 | 5 | 63 | 7 | |||
181147 | 138770 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1801 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6001966.8277 | 2114966.2509 | 37.7874047930646 | -122.436995853206 | (37.7874047930646, -122.436995853206) | 13 | 6 | 11 | 29490 | 27 | |||
181134 | 126325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6012207.85144 | 2117304.67676 | 37.7944023199544 | -122.401728237874 | (37.7944023199544, -122.401728237874) | 3 | 1 | 10 | 28860 | 4 | |||
181061 | 212291 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5991484.87009 | 2094085.30911 | 37.7294698805282 | -122.471738611971 | (37.7294698805282, -122.471738611971) | 9 | 8 | 4 | 59 | 40 | |||
180999 | 141645 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 540 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6000636.238 | 2110849.6046 | 37.7760258178517 | -122.441303917522 | (37.7760258178517, -122.441303917522) | 15 | 5 | 11 | 29492 | 10 | |||
180996 | 124402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3966 Washington St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5995735.18889 | 2115521.97935 | 37.7885745043372 | -122.45859614302 | (37.7885745043372, -122.45859614302) | 11 | 6 | 1 | 54 | 31 | |||
180975 | 189486 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1402 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6016163.54314 | 2095728.93709 | 37.7353799399286 | -122.386535798986 | (37.7353799399286, -122.386535798986) | 10 | 3 | 8 | 58 | 1 | |||
180961 | 4351 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 28 | 3X3 | 6001420.13833 | 2095958.45484 | 37.735182941645 | -122.437525573868 | (37.735182941645, -122.437525573868) | 2 | 7 | 5 | 63 | 7 | ||
180894 | 12964 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 68 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6001941.08695 | 2095682.00478 | 37.7344534781365 | -122.435704695831 | (37.7344534781365, -122.435704695831) | 2 | 7 | 5 | 63 | 7 | |||
180686 | 212228 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1101 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6001076.49288 | 2095660.41467 | 37.7343450486906 | -122.438692329104 | (37.7343450486906, -122.438692329104) | 9 | 7 | 5 | 63 | 40 | |||
180657 | 16569 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95X Nido Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 5999200.4791331 | 2112280.3747819 | 37.7798724518028 | -122.446373519186 | (37.7798724518028, -122.446373519186) | 15 | 5 | 1 | 54 | 16 | ||
180469 | 206403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 190 San Pablo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5994311.54051 | 2096607.92248 | 37.7365594988302 | -122.462149481812 | (37.7365594988302, -122.462149481812) | 9 | 8 | 4 | 59 | 40 | |||
180416 | 206397 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 170 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994276.74774 | 2096834.22345 | 37.7371788619233 | -122.462286182385 | (37.7371788619233, -122.462286182385) | 9 | 8 | 4 | 59 | 40 | |||
180389 | 212115 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1902x Monterey Blvd | 3 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 5992194.67664 | 2095416.97281 | 37.7331673397011 | -122.469381656144 | (37.7331673397011, -122.469381656144) | 9 | 8 | 4 | 59 | 40 | |||
180304 | 29634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
180254 | 212254 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1025 Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991244.17466 | 2090280.96155 | 37.7190101571753 | -122.472293496369 | (37.7190101571753, -122.472293496369) | 9 | 8 | 6 | 64 | 24 | |||
180209 | 99091 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
180049 | 11844 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
179978 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600X OAKDALE AVE | 1 | Front Yard : Yard | Tree | Arts Commission 19 | 13 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
179973 | 206383 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 20 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994405.70437 | 2097759.62337 | 37.7397272051417 | -122.461907407719 | (37.7397272051417, -122.461907407719) | 1 | 8 | 4 | 59 | 40 | |||
179912 | 176053 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989219.15665 | 2089312.55172 | 37.7162337395604 | -122.479222313162 | (37.7162337395604, -122.479222313162) | 1 | 8 | 4 | 64 | 14 | ||||
179907 | 189494 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 623 Mendell St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6016484.96155 | 2097341.92923 | 37.7398266791685 | -122.385536900409 | (37.7398266791685, -122.385536900409) | 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) );