Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94 | 94 | 201404 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1051 Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1990 12:00:00 AM | 14 | Width 3ft | 6018112.6185 | 2094686.77545 | 37.732626074632705 | -122.379724665662 | (37.7326260746327, -122.379724665662) | ||
| 1150 | 1150 | 246081 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1390 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999109.7278 | 2108387.5264 | 37.769178502070204 | -122.44640733565201 | (37.7691785020702, -122.446407335652) | |||
| 1197 | 1197 | 224424 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2500X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002246.98159 | 2097281.36199 | 37.738862314555 | -122.43476145089501 | (37.738862314555, -122.434761450895) | |||
| 2071 | 2071 | 252870 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 716 McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | ||||
| 2951 | 2951 | 246120 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17675 | 5999562.003 | 2108407.0589 | 37.769257954715705 | -122.44484435027799 | (37.7692579547157, -122.444844350278) | |
| 3022 | 3022 | 246073 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1209 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 18 | Width 0ft | Permit Number 17669 | 5999896.6292 | 2108453.3917 | 37.7694042640863 | -122.44369022814199 | (37.7694042640863, -122.443690228142) | |
| 4178 | 4178 | 246147 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1504 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998476.2094 | 2108299.706 | 37.768901165807705 | -122.448592305739 | (37.7689011658077, -122.448592305739) | |||
| 4228 | 4228 | 248327 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5998303.294 | 2108219.7591 | 37.768671763303104 | -122.449184645334 | (37.7686717633031, -122.449184645334) | |||
| 4288 | 4288 | 248328 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998322.9779 | 2108222.7874 | 37.768681204074895 | -122.44911677876101 | (37.7686812040749, -122.449116778761) | |||
| 4294 | 4294 | 248325 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 19 | Width 0ft | Permit Number 17699 | 5998266.3488 | 2108214.611 | 37.7686555147255 | -122.44931206435 | (37.7686555147255, -122.44931206435) | |
| 4299 | 4299 | 248326 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998285.1242 | 2108217.0336 | 37.768663240508 | -122.44924729658001 | (37.768663240508, -122.44924729658) | |||
| 4566 | 4566 | 176382 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2112 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6011978.0 | 2087840.0 | 37.7134859388755 | -122.40045291074101 | (37.7134859388755, -122.400452910741) | |||
| 4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 6470 | 6470 | 110846 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2776 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000368.55091 | 2117170.43785 | 37.793365941237894 | -122.44268387196999 | (37.7933659412379, -122.44268387197) | |||
| 7110 | 7110 | 10652 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 931 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003404.4622 | 2110674.9336 | 37.775703518104 | -122.431715431116 | (37.775703518104, -122.431715431116) | |||
| 7855 | 7855 | 10655 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 937 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003345.7495 | 2110667.1791 | 37.775678897926 | -122.43191797899799 | (37.775678897926, -122.431917978998) | |||
| 7947 | 7947 | 2629 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1872 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004578.2934 | 2115053.5876 | 37.787792683911 | -122.427966943787 | (37.787792683911, -122.427966943787) | |||
| 9063 | 9063 | 4830 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 44 | 5x5 | 6006270.256805 | 2097668.3997492 | 37.740152628556 | -122.42087828555401 | (37.740152628556, -122.420878285554) | |||
| 9234 | 9234 | 4832 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 104X CORTLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 3X3 | 6006272.0 | 2097672.0 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | |||
| 9298 | 9298 | 17755 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005983.055346799 | 2115593.0882202997 | 37.789353391125104 | -122.42314508816901 | (37.7893533911251, -122.423145088169) | |||
| 9377 | 9377 | 17756 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |||
| 9401 | 9401 | 4822 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 60 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6006061.0289274 | 2097780.9763268996 | 37.7404499429552 | -122.421609705422 | (37.7404499429552, -122.421609705422) | |||
| 9504 | 9504 | 17758 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005894.5926 | 2115584.1297299997 | 37.7893238007876 | -122.423450522313 | (37.7893238007876, -122.423450522313) | |||
| 9564 | 9564 | 17759 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005845.8328233 | 2115574.0220236 | 37.7892932953595 | -122.42361850671999 | (37.7892932953595, -122.42361850672) | |||
| 10033 | 10033 | 54506 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 5x5 | Permit Number 10300 | 5995769.71808299 | 2107217.0895637 | 37.7657734551651 | -122.457875462722 | (37.7657734551651, -122.457875462722) | ||
| 10973 | 10973 | 55642 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 422 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775006 | 6002423.93112 | 2090348.58782 | 37.719836534298 | -122.433654298202 | (37.719836534298, -122.433654298202) | |
| 11298 | 11298 | 25444 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2155 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6011824.01572 | 2087503.73336 | 37.7125540294141 | -122.40096152627399 | (37.7125540294141, -122.400961526274) | |||
| 11921 | 11921 | 61836 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 209 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1985 12:00:00 AM | 14 | 3x3 | Permit Number 21875 | 6001956.61236 | 2093885.6272599997 | 37.7295219188836 | -122.435522552544 | (37.7295219188836, -122.435522552544) | |
| 13479 | 13479 | 22442 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 6025 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6013654.8805 | 2091521.7057 | 37.7236885437418 | -122.394914674123 | (37.7236885437418, -122.394914674123) | |||
| 13710 | 13710 | 3708 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016594.5506 | 2099214.51013 | 37.744974467789504 | -122.385288434823 | (37.7449744677895, -122.385288434823) | |||
| 13891 | 13891 | 26809 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1471 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016061.043 | 2095379.9811 | 37.7344161021924 | -122.38686585494 | (37.7344161021924, -122.38686585494) | |||
| 15843 | 15843 | 107072 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 50x5 | Permit Number 773144 | 6015855.633230001 | 2106318.50292 | 37.7644396262057 | -122.388339224777 | (37.7644396262057, -122.388339224777) | |
| 16272 | 16272 | 107070 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 20x6 | Permit Number 773144 | 6015880.83246 | 2106317.74548 | 37.7644389427302 | -122.388252013943 | (37.7644389427302, -122.388252013943) | |
| 16316 | 16316 | 107069 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 8x8 | Permit Number 773144 | 6015928.73625 | 2106322.43558 | 37.764454474908 | -122.388086653778 | (37.764454474908, -122.388086653778) | |
| 16319 | 16319 | 26014 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 3 | 3X3 | 6014769.7753099995 | 2095716.92157 | 37.735269692036205 | -122.39135377296002 | (37.7352696920362, -122.39135377296) | ||
| 17950 | 17950 | 4408 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1091 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6004454.91155 | 2102571.21825 | 37.7535121447905 | -122.42750421154301 | (37.7535121447905, -122.427504211543) | |||
| 18729 | 18729 | 4825 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 72 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6006134.02134 | 2097745.6697400003 | 37.7403571145946 | -122.421354819194 | (37.7403571145946, -122.421354819194) | |||
| 18780 | 18780 | 16006 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 95 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001386.18936 | 2094608.8979 | 37.7314754397255 | -122.43754633291799 | (37.7314754397255, -122.437546332918) | |||
| 19493 | 19493 | 4411 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1101 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004460.022890001 | 2102441.95426 | 37.7531575052231 | -122.42747732723801 | (37.7531575052231, -122.427477327238) | |||
| 20016 | 20016 | 16033 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 159 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6001012.52549 | 2094617.56697 | 37.7314779911003 | -122.438838778307 | (37.7314779911003, -122.438838778307) | |||
| 21392 | 21392 | 4831 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006324.12928 | 2097690.18327 | 37.74021547767221 | -122.420693562078 | (37.7402154776722, -122.420693562078) | |||
| 22192 | 22192 | 4813 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 29 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6005915.07365 | 2097910.62237 | 37.740797690665396 | -122.422123570454 | (37.7407976906654, -122.422123570454) | |||
| 22379 | 22379 | 17784 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005418.97388 | 2115516.65721 | 37.7891116821071 | -122.42509130621599 | (37.7891116821071, -122.425091306216) | |||
| 23710 | 23710 | 199357 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 929 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6011910.785069999 | 2104052.6476 | 37.757998712287204 | -122.401824164069 | (37.7579987122872, -122.401824164069) | |||
| 23931 | 23931 | 140150 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 280 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5998837.1325 | 2109760.3619 | 37.772932385832895 | -122.447449052578 | (37.7729323858329, -122.447449052578) | |||
| 24203 | 24203 | 137837 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 24596 | 24596 | 138923 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 970 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6003200.9063 | 2110690.9965 | 37.7757360824046 | -122.432420728644 | (37.7757360824046, -122.432420728644) | |||
| 24715 | 24715 | 200566 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1440 McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 0ft | 6016135.6208 | 2095382.4464 | 37.734427000383 | -122.386608184543 | (37.734427000383, -122.386608184543) | |||
| 24830 | 24830 | 199390 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201 Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6018025.5889 | 2093953.39853 | 37.730607564281605 | -122.379974610641 | (37.7306075642816, -122.379974610641) | |||
| 25006 | 25006 | 182753 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1788 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5986606.1894 | 2103114.4157 | 37.753977921823 | -122.489268052608 | (37.753977921823, -122.489268052608) | |||
| 25332 | 25332 | 200710 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1483 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6016005.5719 | 2095421.2762 | 37.734526418728 | -122.387060517703 | (37.734526418728, -122.387060517703) | |||
| 25340 | 25340 | 199360 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1451 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012046.6036 | 2101626.2388 | 37.7513439035983 | -122.401183943899 | (37.7513439035983, -122.401183943899) | ||||
| 25829 | 25829 | 218789 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999445.613919999 | 2094740.51345 | 37.7317263020196 | -122.44426470386101 | (37.7317263020196, -122.444264703861) | ||||
| 26359 | 26359 | 199356 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2151 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6011640.657000001 | 2104629.31608 | 37.759567037301004 | -122.40279894282301 | (37.759567037301, -122.402798942823) | |||
| 26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
| 27571 | 27571 | 224007 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005150.44635 | 2097206.47879 | 37.7388211148085 | -122.42471728718 | (37.7388211148085, -122.42471728718) | ||||
| 27587 | 27587 | 224437 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6006291.67485 | 2097655.32793 | 37.7401179434992 | -122.420803302726 | (37.7401179434992, -122.420803302726) | |||
| 28031 | 28031 | 199363 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2001 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6012400.8175099995 | 2101833.78107 | 37.7519335243359 | -122.39997359673 | (37.7519335243359, -122.39997359673) | |||
| 28059 | 28059 | 206279 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 201 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6000804.900880001 | 2095895.32742 | 37.7349746100829 | -122.439648143869 | (37.7349746100829, -122.439648143869) | |||
| 28308 | 28308 | 67884 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5X Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1993 12:00:00 AM | 15 | Permit Number 31577 | 6003921.69231 | 2093425.09481 | 37.72836881267121 | -122.428696258429 | (37.7283688126712, -122.428696258429) | ||
| 28422 | 28422 | 199384 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1650 Owen St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014197.25358 | 2107577.39089 | 37.7678042229128 | -122.394163287405 | (37.7678042229128, -122.394163287405) | |||
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 28943 | 28943 | 206276 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1575 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5993975.596059999 | 2104757.26291 | 37.758916173673605 | -122.463902332454 | (37.7589161736736, -122.463902332454) | |||
| 29174 | 29174 | 224014 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 87 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005008.4122 | 2096950.18798 | 37.7381093751439 | -122.425190143511 | (37.7381093751439, -122.425190143511) | ||||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) | ||||
| 31211 | 31211 | 224444 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 50 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003894.23838 | 2108432.6331700003 | 37.7695744601141 | -122.42986119705 | (37.7695744601141, -122.42986119705) | |||
| 31502 | 31502 | 141200 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1825 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002183.0052 | 2112931.3819999998 | 37.7818298455487 | -122.436102254923 | (37.7818298455487, -122.436102254923) | |||
| 31630 | 31630 | 199351 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 875 Vermont St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011310.4458099995 | 2104289.7069599996 | 37.7586161031593 | -122.403917085224 | (37.7586161031593, -122.403917085224) | ||||
| 31839 | 31839 | 108738 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5x6 | 5988982.34798 | 2115051.76356 | 37.786893008658296 | -122.481925214884 | (37.7868930086583, -122.481925214884) | |||
| 32141 | 32141 | 140165 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 210 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5998802.9582 | 2110001.4341 | 37.7735923554748 | -122.447584621644 | (37.7735923554748, -122.447584621644) | |||
| 32861 | 32861 | 141292 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1835 ELLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001970.8148 | 2112901.9393 | 37.7817369459936 | -122.436834225266 | (37.7817369459936, -122.436834225266) | |||
| 33400 | 33400 | 123284 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 06th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5994067.51233 | 2112489.4392 | 37.780151985503004 | -122.46414576865699 | (37.780151985503, -122.464145768657) | |||
| 33431 | 33431 | 199352 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2201 20th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 6011438.777290001 | 2104618.08684 | 37.7595249301544 | -122.403496357191 | (37.7595249301544, -122.403496357191) | |||
| 33604 | 33604 | 206271 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1510 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5993525.3861 | 2095199.14432 | 37.7326460476786 | -122.46476525891899 | (37.7326460476786, -122.464765258919) | |||
| 34483 | 34483 | 201405 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1051 Ingalls St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6018105.253280001 | 2094684.7781099998 | 37.732620184068296 | -122.379749990578 | (37.7326201840683, -122.379749990578) | |||
| 34797 | 34797 | 137849 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1900 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004722.1533 | 2115420.5894 | 37.7888085164114 | -122.42749537127199 | (37.7888085164114, -122.427495371272) | |||
| 35053 | 35053 | 123308 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994328.16527 | 2112546.87269 | 37.7803247018036 | -122.46324822682399 | (37.7803247018036, -122.463248226824) | |||
| 35112 | 35112 | 250107 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005911.45005 | 2115583.3816299997 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | |||
| 36323 | 36323 | 182757 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1768 31st Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5986603.8813 | 2103201.6608 | 37.7542173383784 | -122.489282448699 | (37.7542173383784, -122.489282448699) | |||
| 37030 | 37030 | 250127 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1798 Pine St | 4 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6005361.6989 | 2115505.86135 | 37.789078803778295 | -122.425288702018 | (37.7890788037783, -122.425288702018) | |||
| 38019 | 38019 | 224020 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003561.5892199995 | 2095667.7300200001 | 37.7345061963941 | -122.430101069605 | (37.7345061963941, -122.430101069605) | ||||
| 38240 | 38240 | 176381 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2020 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 6012133.88275 | 2088039.9913700002 | 37.714043767182105 | -122.39992815667699 | (37.7140437671821, -122.399928156677) | |||
| 38508 | 38508 | 206297 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 565 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996520.85452 | 2095770.92684 | 37.7343882701062 | -122.454450538684 | (37.7343882701062, -122.454450538684) | |||
| 39216 | 39216 | 224006 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005147.55847 | 2097214.3851400004 | 37.738842660756795 | -122.42472783442601 | (37.7388426607568, -122.424727834426) | ||||
| 39572 | 39572 | 247122 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002767.913930001 | 2098805.6060200003 | 37.743077097036796 | -122.433069184902 | (37.7430770970368, -122.433069184902) | ||||
| 39777 | 39777 | 199354 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2201 20th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6011487.25188 | 2104620.43012 | 37.759534071763 | -122.403328871935 | (37.759534071763, -122.403328871935) | |||
| 39832 | 39832 | 141203 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1813 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6002244.2596 | 2112941.8731 | 37.7818621312845 | -122.435891094436 | (37.7818621312845, -122.435891094436) | |||
| 40055 | 40055 | 250106 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005930.7358800005 | 2115585.60481 | 37.7893298908963 | -122.42332557552601 | (37.7893298908963, -122.423325575526) | |||
| 40266 | 40266 | 246174 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1602 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5997866.0088 | 2108213.3997 | 37.768629281127296 | -122.45069671469 | (37.7686292811273, -122.45069671469) | |||
| 40659 | 40659 | 62578 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 739 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 9 | Permit Number 22783 | 6011302.7424099995 | 2104925.74778 | 37.7603620991639 | -122.403988486898 | (37.7603620991639, -122.403988486898) | |
| 40661 | 40661 | 199343 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6015732.2545300005 | 2106672.58002 | 37.7654050079639 | -122.388790681754 | (37.7654050079639, -122.388790681754) | |||
| 41379 | 41379 | 224035 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1619 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003374.882069999 | 2098756.34444 | 37.7429762470666 | -122.430966938682 | (37.7429762470666, -122.430966938682) | |||
| 41393 | 41393 | 248493 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 748 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997645.2464 | 2107858.3326 | 37.7676417185294 | -122.451434697353 | (37.7676417185294, -122.451434697353) | |||
| 41851 | 41851 | 224024 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003500.27869 | 2095632.3533400001 | 37.7344055874315 | -122.43031051723801 | (37.7344055874315, -122.430310517238) | ||||
| 41887 | 41887 | 248497 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 114 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997504.128 | 2107818.662 | 37.7675247113964 | -122.45191994324699 | (37.7675247113964, -122.451919943247) | |||
| 41921 | 41921 | 206270 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993141.97199 | 2095936.7158400002 | 37.7346491229581 | -122.46614438456801 | (37.7346491229581, -122.466144384568) | |||
| 42087 | 42087 | 206272 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 70 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 10ft | 5993269.28362 | 2097133.14802 | 37.7379415715549 | -122.46579112907 | (37.7379415715549, -122.46579112907) | |||
| 42606 | 42606 | 224426 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001898.6057400005 | 2096858.66767 | 37.7376819093764 | -122.435935733463 | (37.7376819093764, -122.435935733463) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");