trees
3,587 rows where qSpecies_id = 28 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126093 | 142248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 603 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004941.624 | 2110891.392 | 37.7763848724075 | -122.42641341835 | (37.7763848724075, -122.42641341835) | 7 | 9 | 11 | 28852 | 10 | |||
| 127905 | 23236 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006679.1992926 | 2112885.0865653 | 37.7819571437982 | -122.420544201112 | (37.7819571437982, -122.420544201112) | 7 | 9 | 9 | 28852 | 36 | |||
| 129784 | 126253 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006795.27678 | 2111915.96388 | 37.7793027090834 | -122.420073828465 | (37.7793027090834, -122.420073828465) | 7 | 9 | 9 | 28852 | 36 | |||
| 130295 | 9424 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 701X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1994 12:00:00 AM | 12 | 3X3 | 6006118.83278 | 2112436.92682 | 37.7806950106942 | -122.422450960554 | (37.7806950106942, -122.422450960554) | 7 | 9 | 11 | 28852 | 41 | ||
| 130373 | 22580 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006453.23929 | 2112834.51188 | 37.7818055412449 | -122.42132232756 | (37.7818055412449, -122.42132232756) | 7 | 9 | 11 | 28852 | 41 | |||
| 131992 | 24318 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006459.0655 | 2112530.31056 | 37.7809706070487 | -122.421280563062 | (37.7809706070487, -122.421280563062) | 7 | 9 | 11 | 28852 | 41 | |||
| 134711 | 112416 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 469x IVY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
| 135627 | 248676 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6004877.40051 | 2108844.08516 | 37.7707598349224 | -122.426489774494 | (37.7707598349224, -122.426489774494) | 7 | 9 | 5 | 28852 | 10 | |||
| 135868 | 7802 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 690X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006253.103271 | 2112460.108328 | 37.7807662350176 | -122.421988100815 | (37.7807662350176, -122.421988100815) | 7 | 9 | 11 | 28852 | 41 | |||
| 136491 | 126254 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006800.64594 | 2111822.15614 | 37.779045438234 | -122.420048595269 | (37.779045438234, -122.420048595269) | 7 | 9 | 9 | 28852 | 36 | |||
| 137742 | 126252 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6006776.64999 | 2112003.50648 | 37.7795420303743 | -122.420144480992 | (37.7795420303743, -122.420144480992) | 7 | 9 | 9 | 28852 | 36 | |||
| 139986 | 126241 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 640 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6006270.93535 | 2112347.20357 | 37.78045723176 | -122.42191838834 | (37.78045723176, -122.42191838834) | 7 | 9 | 11 | 28852 | 41 | |||
| 147176 | 24329 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
| 148256 | 126246 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 675 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006387.81901 | 2112474.09096 | 37.780812224756 | -122.421523046354 | (37.780812224756, -122.421523046354) | 7 | 9 | 11 | 28852 | 41 | |||
| 150125 | 126248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 649 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006464.49419 | 2112484.99744 | 37.780846494311 | -122.42125856383 | (37.780846494311, -122.42125856383) | 7 | 9 | 11 | 28852 | 41 | |||
| 151213 | 96529 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 176 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | Permit Number 29070 | 6005710 | 2109998 | 37.7739752394086 | -122.423691851196 | (37.7739752394086, -122.423691851196) | 7 | 9 | 11 | 28852 | 10 | ||
| 152411 | 244246 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 176 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005729.1606 | 2110007.7269 | 37.7740030286949 | -122.423626263081 | (37.7740030286949, -122.423626263081) | 7 | 9 | 11 | 28852 | 10 | |||
| 153858 | 248675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6004907.9602 | 2108848.83767 | 37.7707746116773 | -122.426384406326 | (37.7707746116773, -122.426384406326) | 7 | 9 | 5 | 28852 | 10 | |||
| 156763 | 103599 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
| 157600 | 9429 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 727 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005901.79421 | 2112405.20993 | 37.7805956778943 | -122.423199547232 | (37.7805956778943, -122.423199547232) | 7 | 9 | 11 | 28852 | 41 | |||
| 160542 | 23169 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 202X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.7774868330979 | -122.419726396954 | (37.7774868330979, -122.419726396954) | 7 | 9 | 9 | 28852 | 36 | |||
| 163079 | 23179 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
| 163630 | 22573 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006249.78714 | 2112806.77447 | 37.7817179085863 | -122.422024207046 | (37.7817179085863, -122.422024207046) | 7 | 9 | 11 | 28852 | 41 | |||
| 164009 | 258522 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 164538 | 24321 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006368.77272 | 2112521.86674 | 37.7809423314653 | -122.42159233104 | (37.7809423314653, -122.42159233104) | 7 | 9 | 11 | 28852 | 41 | |||
| 167054 | 23233 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006624.19189 | 2113053.59601 | 37.782416729491 | -122.420746468298 | (37.782416729491, -122.420746468298) | 7 | 9 | 9 | 28852 | 36 | |||
| 167594 | 7811 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006219.73405 | 2112674.25147 | 37.7813523377843 | -122.422118759068 | (37.7813523377843, -122.422118759068) | 7 | 9 | 11 | 28852 | 41 | |||
| 168238 | 22576 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006347.61377 | 2112822.41919 | 37.7817663820541 | -122.421686883966 | (37.7817663820541, -122.421686883966) | 7 | 9 | 11 | 28852 | 41 | |||
| 168630 | 22578 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006396.3025 | 2112828.52249 | 37.7817858856438 | -122.421518877095 | (37.7817858856438, -122.421518877095) | 7 | 9 | 11 | 28852 | 41 | |||
| 168811 | 138845 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005114.3585 | 2111100.6999 | 37.7769693436674 | -122.425830782814 | (37.7769693436674, -122.425830782814) | 7 | 9 | 11 | 28852 | 10 | |||
| 169313 | 24319 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 6006449.33086 | 2112523.89037 | 37.7809524299494 | -122.421313783999 | (37.7809524299494, -122.421313783999) | 7 | 9 | 11 | 28852 | 41 | |||
| 171690 | 22581 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006522.42636 | 2112846.04587 | 37.7818411112169 | -122.421083791398 | (37.7818411112169, -122.421083791398) | 7 | 9 | 11 | 28852 | 41 | |||
| 171902 | 23232 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006628.60579 | 2113016.72655 | 37.7823157437221 | -122.420728579873 | (37.7823157437221, -122.420728579873) | 7 | 9 | 9 | 28852 | 36 | |||
| 175431 | 126242 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 640 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6006265.8936 | 2112400.21626 | 37.7806025073478 | -122.421939597053 | (37.7806025073478, -122.421939597053) | 7 | 9 | 11 | 28852 | 41 | |||
| 177079 | 24326 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | |||
| 177146 | 33677 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 455 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 773435 | 6005180.13897934 | 2111093.89138396 | 37.776954366261 | -122.425602743023 | (37.776954366261, -122.425602743023) | 7 | 9 | 11 | 28852 | 10 | |||
| 177684 | 112415 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 469x IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
| 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 | |||
| 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 | |||
| 184873 | 47012 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 190 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45008 | 6004362.86360721 | 2108776.26099442 | 37.7705445057003 | -122.428264732992 | (37.7705445057003, -122.428264732992) | 7 | 9 | 11 | 28852 | 10 | |||
| 185309 | 24328 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
| 185412 | 117356 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6005443.21862963 | 2111009.61442816 | 37.7767378239513 | -122.424686672119 | (37.7767378239513, -122.424686672119) | 7 | 9 | 11 | 28852 | 10 | |||
| 185635 | 24325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | 3X3 | 6006278.38926 | 2112509.01094 | 37.7809019357225 | -122.42190409899 | (37.7809019357225, -122.42190409899) | 7 | 9 | 11 | 28852 | 41 | |||
| 186173 | 126244 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 679 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6006310.63597 | 2112467.1291 | 37.7807887569329 | -122.421789565841 | (37.7807887569329, -122.421789565841) | 7 | 9 | 11 | 28852 | 41 | |||
| 187011 | 258524 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 189260 | 138841 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 451 IVY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005188.6254 | 2111110.5576 | 37.7770006071382 | -122.425574572293 | (37.7770006071382, -122.425574572293) | 7 | 9 | 11 | 28852 | 10 | |||
| 190002 | 33685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
| 8922 | 222961 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 36 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 4ft | 6006486.54397 | 2109181.00608 | 37.771775773859 | -122.420947632224 | (37.771775773859, -122.420947632224) | 8 | 2 | 9 | 28853 | 19 | |||
| 15776 | 245828 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009169.65844 | 2107587.30571 | 37.7675507193221 | -122.411553908588 | (37.7675507193221, -122.411553908588) | 8 | 4 | 7 | 28853 | 19 | |||
| 16242 | 100094 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 11X Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007856.7 | 2107724 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | 8 | 4 | 7 | 28853 | 19 | |||
| 21335 | 248633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009395.0721 | 2107534.93214 | 37.767419555005 | -122.410770529855 | (37.767419555005, -122.410770529855) | 8 | 4 | 7 | 28853 | 19 | |||
| 22671 | 248642 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 101 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007785.69421 | 2107933.31633 | 37.7684230563089 | -122.416365384082 | (37.7684230563089, -122.416365384082) | 8 | 4 | 7 | 28853 | 19 | |||
| 25000 | 101302 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 385 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |||
| 29983 | 101305 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 2 | 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 | |||
| 30283 | 94848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |
| 32596 | 248634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6009398.26583 | 2107520.38321 | 37.7673797860689 | -122.410758455532 | (37.7673797860689, -122.410758455532) | 8 | 4 | 7 | 28853 | 19 | |||
| 41214 | 248723 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6007992.80316 | 2107612.22254 | 37.7675530521539 | -122.415626273556 | (37.7675530521539, -122.415626273556) | 8 | 4 | 7 | 28853 | 19 | |||
| 41984 | 100907 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 44972 | 101304 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 385 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |||
| 48830 | 62536 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1986 12:00:00 AM | 12 | 4x4 | Permit Number 22719 | 6009399.23291724 | 2107572.54203964 | 37.7675230564079 | -122.410758794521 | (37.7675230564079, -122.410758794521) | 8 | 4 | 7 | 28853 | 19 | |
| 57135 | 248757 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 89 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007137.77987 | 2106830.1877 | 37.7653576685452 | -122.418528233792 | (37.7653576685452, -122.418528233792) | 8 | 4 | 7 | 28853 | 19 | |||
| 59781 | 245831 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009391.30468 | 2107606.84722 | 37.7676168059854 | -122.410788640404 | (37.7676168059854, -122.410788640404) | 8 | 4 | 7 | 28853 | 19 | |||
| 69293 | 100901 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 4x4 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 69740 | 100897 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 70746 | 109021 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800x FOLSOM ST | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 71758 | 248721 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007987.30171 | 2107714.11427 | 37.7678325137828 | -122.415652517556 | (37.7678325137828, -122.415652517556) | 8 | 4 | 7 | 28853 | 19 | |||
| 74775 | 100903 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 75413 | 245826 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 McCoppin St | 3 | : | Tree | Private 2 | 33 | Width 4ft | 6006425.97269 | 2109173.2697 | 37.7717511171398 | -122.421156603211 | (37.7717511171398, -122.421156603211) | 8 | 2 | 9 | 28853 | 19 | |||
| 78725 | 109023 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800x FOLSOM ST | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 79033 | 248724 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007994.35171 | 2107578.85676 | 37.7674615245632 | -122.415618554655 | (37.7674615245632, -122.415618554655) | 8 | 4 | 7 | 28853 | 19 | |||
| 80913 | 245830 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009390.15238 | 2107621.64367 | 37.767657369013 | -122.410793671187 | (37.767657369013, -122.410793671187) | 8 | 4 | 7 | 28853 | 19 | |||
| 85109 | 100905 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 87338 | 109022 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800x FOLSOM ST | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 90533 | 248726 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007996.84764 | 2107526.36051 | 37.7673175224207 | -122.41560620428 | (37.7673175224207, -122.41560620428) | 8 | 4 | 7 | 28853 | 19 | |||
| 91092 | 248722 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6007990.99054 | 2107654.48225 | 37.767668985552 | -122.415635535654 | (37.767668985552, -122.415635535654) | 8 | 4 | 7 | 28853 | 19 | |||
| 95858 | 256023 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99 Heron St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010037 | 2109967 | 37.7741334231767 | -122.408721775232 | (37.7741334231767, -122.408721775232) | 8 | 2 | 9 | 28853 | 34 | ||||
| 99351 | 245824 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 McCoppin St | 1 | : | Tree | Private 2 | 35 | Width 5ft | 6006487.65936 | 2109176.30964 | 37.7717629414288 | -122.420943440509 | (37.7717629414288, -122.420943440509) | 8 | 2 | 9 | 28853 | 19 | |||
| 100777 | 248632 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6009392.45808 | 2107577.85658 | 37.7675372690481 | -122.410782603259 | (37.7675372690481, -122.410782603259) | 8 | 4 | 7 | 28853 | 19 | |||
| 101671 | 248719 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007985.54368 | 2107759.03962 | 37.767955769466 | -122.41566177967 | (37.767955769466, -122.41566177967) | 8 | 4 | 7 | 28853 | 19 | |||
| 102360 | 100090 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 11X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007856.7 | 2107724 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | 8 | 4 | 7 | 28853 | 19 | |||
| 108059 | 100898 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 111225 | 200941 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1582 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6008203.2052 | 2108886.962 | 37.7710650131933 | -122.414988753585 | (37.7710650131933, -122.414988753585) | 8 | 2 | 9 | 28853 | 19 | |||
| 123987 | 248861 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007717.35187 | 2107784.08445 | 37.7680094571928 | -122.416591202031 | (37.7680094571928, -122.416591202031) | 8 | 4 | 7 | 28853 | 19 | |||
| 125348 | 100904 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 125696 | 248718 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6007977.12835 | 2107871.21259 | 37.768263297146 | -122.415698830857 | (37.768263297146, -122.415698830857) | 8 | 4 | 7 | 28853 | 19 | |||
| 126666 | 48445 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 510 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | Permit Number 45816 | 6011222.45390726 | 2109921.84553885 | 37.7740757645304 | -122.404617880494 | (37.7740757645304, -122.404617880494) | 14 | 2 | 9 | 28853 | 34 | |||
| 129928 | 245832 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009391.00904 | 2107592.36955 | 37.7675770370677 | -122.4107886404 | (37.7675770370677, -122.4107886404) | 8 | 4 | 7 | 28853 | 19 | |||
| 133355 | 109015 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800x FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 134640 | 100899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 137179 | 111064 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007219 | 2106804 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | 8 | 4 | 7 | 28853 | 19 | |||
| 139282 | 100902 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 140617 | 245825 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 McCoppin St | 2 | : | Tree | Private 2 | 18 | Width 4ft | 6006460.60937 | 2109175.25024 | 37.7717585077816 | -122.421036933125 | (37.7717585077816, -122.421036933125) | 8 | 2 | 9 | 28853 | 19 | |||
| 140633 | 248720 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007986.94611 | 2107740.34397 | 37.7679045144173 | -122.415655604923 | (37.7679045144173, -122.415655604923) | 8 | 4 | 7 | 28853 | 19 | |||
| 140725 | 248727 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6007997.72225 | 2107503.6752 | 37.7672552830191 | -122.415601572777 | (37.7672552830191, -122.415601572777) | 8 | 4 | 7 | 28853 | 19 | |||
| 144625 | 109024 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800x FOLSOM ST | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 145505 | 222964 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 36 McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6006397.29808 | 2109175.15121 | 37.7717546667683 | -122.421255924348 | (37.7717546667683, -122.421255924348) | 8 | 2 | 9 | 28853 | 19 | |||
| 145675 | 100909 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 111x 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 145806 | 57994 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1582 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1983 12:00:00 AM | 16 | Permit Number 20710 | 6008213.2287 | 2108904.5033 | 37.7711137407294 | -122.414955323601 | (37.7711137407294, -122.414955323601) | 8 | 2 | 9 | 28853 | 19 | ||
| 153196 | 10005 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 156 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005408.68432 | 2108096.72474 | 37.7687377821415 | -122.424598880629 | (37.7687377821415, -122.424598880629) | 8 | 4 | 5 | 28853 | 19 | |||
| 154639 | 248725 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007995.53614 | 2107549.49888 | 37.7673809812602 | -122.415612379018 | (37.7673809812602, -122.415612379018) | 8 | 4 | 7 | 28853 | 19 |
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) );