Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21920 | 21920 | 4841 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 142 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x9 | 6006480.033919999 | 2097559.50493 | 37.7398654498357 | -122.420145233727 | (37.7398654498357, -122.420145233727) | |||
| 21993 | 21993 | 16119 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000050.07874 | 2094632.71852 | 37.7314647899581 | -122.442167217764 | (37.7314647899581, -122.442167217764) | |||
| 22088 | 22088 | 16025 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 131 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001203.7257900005 | 2094613.91575 | 37.7314788418574 | -122.438177502293 | (37.7314788418574, -122.438177502293) | |||
| 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) | |||
| 22196 | 22196 | 4409 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1097 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6004456.37766 | 2102543.07479 | 37.753434952361495 | -122.427497136583 | (37.7534349523615, -122.427497136583) | |||
| 22222 | 22222 | 4815 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 36 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005920.0488599995 | 2097862.788 | 37.740666628859294 | -122.42210297059799 | (37.7406666288593, -122.422102970598) | |||
| 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) | |||
| 22410 | 22410 | 9892 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005332.72699 | 2115570.2247599997 | 37.7892538927886 | -122.42539352339199 | (37.7892538927886, -122.425393523392) | |||
| 22450 | 22450 | 17763 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005669.54525 | 2115550.54053 | 37.7892188686951 | -122.42422677084998 | (37.7892188686951, -122.42422677085) | |||
| 22500 | 22500 | 17776 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1762 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005516.07608 | 2115531.08967 | 37.7891567948058 | -122.424756371721 | (37.7891567948058, -122.424756371721) | |||
| 22519 | 22519 | 17782 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1791 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005428.2033400005 | 2115468.32597 | 37.788979497959296 | -122.425055933202 | (37.7889794979593, -122.425055933202) | |||
| 22570 | 22570 | 9891 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005334.61917 | 2115551.7772 | 37.7892033473078 | -122.425385663344 | (37.7892033473078, -122.425385663344) | |||
| 22653 | 22653 | 17778 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1770 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005458.75733 | 2115520.73995 | 37.7891251395545 | -122.424953950985 | (37.7891251395545, -122.424953950985) | |||
| 22805 | 22805 | 17745 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006152.6648 | 2115617.75127 | 37.7894306797229 | -122.422560011429 | (37.7894306797229, -122.422560011429) | |||
| 23051 | 23051 | 10656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 940 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6003283.9904 | 2110703.7361 | 37.7757757730917 | -122.432134230107 | (37.7757757730917, -122.432134230107) | |||
| 23085 | 23085 | 11553 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 29 | 3X3 | 6018940.8378099995 | 2097294.9489700003 | 37.7398332568108 | -122.377042159778 | (37.7398332568108, -122.377042159778) | ||
| 23178 | 23178 | 11964 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6015715.011390001 | 2096321.03931 | 37.7369808923559 | -122.38812786163 | (37.7369808923559, -122.38812786163) | |||
| 23186 | 23186 | 17762 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 6005688.226009999 | 2115553.43335 | 37.7892278664309 | -122.424162343438 | (37.7892278664309, -122.424162343438) | ||||
| 23241 | 23241 | 11550 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6018907.35155 | 2097248.08652 | 37.7397027373041 | -122.37715469195601 | (37.7397027373041, -122.377154691956) | |||
| 23270 | 23270 | 11971 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1022X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6015641.62594 | 2096289.89853 | 37.736891319872896 | -122.388379417299 | (37.7368913198729, -122.388379417299) | |||
| 23295 | 23295 | 9894 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/1997 12:00:00 AM | 23 | 3X3 | 6005329.1496 | 2115601.42673 | 37.7893393634754 | -122.425408122112 | (37.7893393634754, -122.425408122112) | ||
| 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) | |||
| 25039 | 25039 | 199364 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 6ft | 6009993.3485 | 2108173.3882400002 | 37.7692061355694 | -122.408746211675 | (37.7692061355694, -122.408746211675) | |||
| 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) | |||
| 27310 | 27310 | 199370 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3550 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | Width 4ft | 6016015.91083 | 2099228.15232 | 37.74497989792071 | -122.38729023576799 | (37.7449798979207, -122.387290235768) | |||
| 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) | |||
| 33628 | 33628 | 176389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6009439.980830001 | 2090047.93275 | 37.719406601704 | -122.40938096396499 | (37.719406601704, -122.409380963965) | |||
| 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) | |||
| 37403 | 37403 | 11269 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1176X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1990 12:00:00 AM | 3 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 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) | |||
| 42536 | 42536 | 176390 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009150.9462 | 2089957.5754799999 | 37.7191423008581 | -122.410373676998 | (37.7191423008581, -122.410373676998) | |||
| 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) | |||
| 42622 | 42622 | 200508 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5999 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6013714.4021 | 2091674.1069999998 | 37.7241103165863 | -122.394719584244 | (37.7241103165863, -122.394719584244) | |||
| 43433 | 43433 | 123307 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5994333.67454 | 2112494.59894 | 37.7801814895167 | -122.46322537368 | (37.7801814895167, -122.46322537368) | |||
| 44072 | 44072 | 218788 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 380 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5999450.96536 | 2094715.0251900002 | 37.7316566225397 | -122.444244371989 | (37.7316566225397, -122.444244371989) | |||
| 44352 | 44352 | 206286 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6000787.19541 | 2095992.57825 | 37.735240630441396 | -122.439716327743 | (37.7352406304414, -122.439716327743) | |||
| 44357 | 44357 | 224428 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Arbor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001850.79221 | 2096807.3936 | 37.737538406363 | -122.436097379408 | (37.737538406363, -122.436097379408) | |||
| 44606 | 44606 | 206273 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 335 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5992818.8463 | 2096062.89914 | 37.734976942936 | -122.46727070178301 | (37.734976942936, -122.467270701783) | |||
| 45323 | 45323 | 224434 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 11 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6007430.10011 | 2098092.51153 | 37.741382453248896 | -122.416898048032 | (37.7413824532489, -122.416898048032) | |||
| 45604 | 45604 | 11962 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 945X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015820.0973 | 2096449.8462 | 37.7373403917231 | -122.38777351408001 | (37.7373403917231, -122.38777351408) | |||
| 46757 | 46757 | 244461 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 402 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6003240.6392 | 2109670.6251 | 37.772936647465 | -122.43221039578 | (37.772936647465, -122.43221039578) | |||
| 47085 | 47085 | 218783 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998795.47023 | 2095343.3571900001 | 37.7333444548841 | -122.44655572948099 | (37.7333444548841, -122.446555729481) | ||||
| 48142 | 48142 | 224439 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3883 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003903.27581 | 2102441.01038 | 37.7531234083377 | -122.429402602143 | (37.7531234083377, -122.429402602143) | |||
| 48470 | 48470 | 206295 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1289 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5993598.25468 | 2106726.01097 | 37.76430008921321 | -122.465350355136 | (37.7643000892132, -122.465350355136) | |||
| 49328 | 49328 | 199385 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1650 Owen St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014336.83861 | 2107435.43762 | 37.7674222079956 | -122.39367053897101 | (37.7674222079956, -122.393670538971) | |||
| 49495 | 49495 | 224027 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1350 Noe St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6003197.19524 | 2100390.33495 | 37.7474527349542 | -122.431697967013 | (37.7474527349542, -122.431697967013) | ||||
| 50076 | 50076 | 58511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1430 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1979 12:00:00 AM | Permit Number 17687 | 5998871.25967783 | 2108358.36156462 | 37.7690847998305 | -122.447230081169 | (37.7690847998305, -122.447230081169) | |||
| 50686 | 50686 | 139597 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1122 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6000883.0425 | 2112553.4494 | 37.7807181991979 | -122.440572393516 | (37.7807181991979, -122.440572393516) | |||
| 50774 | 50774 | 199342 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6015732.89393 | 2106644.75831 | 37.7653286510121 | -122.38878652777201 | (37.7653286510121, -122.388786527772) | |||
| 51352 | 51352 | 206266 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1217 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5995764.33389 | 2107222.76394 | 37.76578872620429 | -122.457894496039 | (37.7657887262043, -122.457894496039) |
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");