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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 31001 | 31001 | 176999 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 906 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6001595.86635 | 2088796.01268 | 37.7155264893371 | -122.436405562669 | (37.7155264893371, -122.436405562669) | |||
| 31099 | 31099 | 226629 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001984.40508 | 2105553.3896 | 37.761560425102 | -122.43626114684099 | (37.761560425102, -122.436261146841) | |||
| 31229 | 31229 | 226622 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004058.08528 | 2103018.40015 | 37.7547175483925 | -122.42890840132799 | (37.7547175483925, -122.428908401328) | |||
| 31369 | 31369 | 207346 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998595.0741 | 2094889.9944099998 | 37.7320881793139 | -122.44721593437201 | (37.7320881793139, -122.447215934372) | |||
| 31710 | 31710 | 207290 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993410.050430001 | 2093515.91328 | 37.7280176597738 | -122.465041791443 | (37.7280176597738, -122.465041791443) | |||
| 32289 | 32289 | 207308 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996630.86084 | 2093949.68597 | 37.7293938887121 | -122.453938729108 | (37.7293938887121, -122.453938729108) | |||
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 33252 | 33252 | 129488 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3320 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999321.62812 | 2120233.7842099997 | 37.801717336245105 | -122.44652677938801 | (37.8017173362451, -122.446526779388) | |||
| 33451 | 33451 | 191410 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 777 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011870.78856 | 2104734.77484 | 37.7598694505299 | -122.402010442428 | (37.7598694505299, -122.402010442428) | |||
| 33808 | 33808 | 207309 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996632.84291 | 2093955.22047 | 37.72940919877011 | -122.45393227647699 | (37.7294091987701, -122.453932276477) | |||
| 33843 | 33843 | 177016 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002658.8277900005 | 2094369.8725599998 | 37.7308914046921 | -122.433129511441 | (37.7308914046921, -122.433129511441) | |||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 34210 | 34210 | 177025 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 300 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009309.80145 | 2092849.9581799998 | 37.727093081168604 | -122.410028653892 | (37.7270930811686, -122.410028653892) | |||
| 34276 | 34276 | 182870 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988127.2852 | 2102724.1956 | 37.752995155363 | -122.483979194232 | (37.752995155363, -122.483979194232) | |||
| 34491 | 34491 | 207157 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992487.55481 | 2097691.20205 | 37.7394287228632 | -122.468534517269 | (37.7394287228632, -122.468534517269) | |||
| 34662 | 34662 | 117967 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984550.3085 | 2111733.18458 | 37.7775224048599 | -122.497013781042 | (37.7775224048599, -122.497013781042) | |||
| 35068 | 35068 | 207355 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 430 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998789.17566 | 2094262.87598 | 37.730377348622106 | -122.446499784464 | (37.7303773486221, -122.446499784464) | ||||
| 35498 | 35498 | 129498 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 6007778.02269 | 2120584.45961 | 37.803159586216395 | -122.417288546245 | (37.8031595862164, -122.417288546245) | |||
| 36484 | 36484 | 207243 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 324 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5996808.75565 | 2089668.4523599998 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | |||
| 36611 | 36611 | 207332 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 139 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000483.56606 | 2095198.0934400002 | 37.7330418734682 | -122.44070911276 | (37.7330418734682, -122.44070911276) | |||
| 37207 | 37207 | 207145 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1418 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991828.31268 | 2105750.01462 | 37.7615180292623 | -122.471400907553 | (37.7615180292623, -122.471400907553) | |||
| 37229 | 37229 | 207260 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 282 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992744.11171 | 2089090.22365 | 37.7158273737034 | -122.46702231894 | (37.7158273737034, -122.46702231894) | |||
| 37320 | 37320 | 207230 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 437 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995450.98225 | 2091203.60917 | 37.7217860999295 | -122.457819021351 | (37.7217860999295, -122.457819021351) | |||
| 37568 | 37568 | 207302 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 65 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5996572.7806400005 | 2094082.116 | 37.72975417960021 | -122.45414907781799 | (37.7297541796002, -122.454149077818) | |||
| 37571 | 37571 | 249979 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 13 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6011649.02488 | 2120183.7348700003 | 37.802276317051 | -122.403864545927 | (37.802276317051, -122.403864545927) | |||
| 37609 | 37609 | 207322 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998892.3170300005 | 2095965.24165 | 37.7350575338629 | -122.44626562436001 | (37.7350575338629, -122.44626562436) | |||
| 37967 | 37967 | 117755 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5983780.251180001 | 2113048.87393 | 37.781089749801204 | -122.499774894099 | (37.7810897498012, -122.499774894099) | |||
| 38221 | 38221 | 177011 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002637.06105 | 2094341.00901 | 37.73081091718 | -122.433202700959 | (37.73081091718, -122.433202700959) | |||
| 38348 | 38348 | 119479 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.21808 | 2112952.33317 | 37.7809338791525 | -122.493319479205 | (37.7809338791525, -122.493319479205) | |||
| 38449 | 38449 | 226599 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002599.9125 | 2100157.5460099997 | 37.746779676940896 | -122.43374669365 | (37.7467796769409, -122.43374669365) | |||
| 39601 | 39601 | 176994 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998658.093780001 | 2087156.70124 | 37.7108579449184 | -122.446441918457 | (37.7108579449184, -122.446441918457) | |||
| 39672 | 39672 | 207255 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 551 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992722.91506 | 2090824.1387 | 37.72058706082171 | -122.467221582632 | (37.7205870608217, -122.467221582632) | |||
| 39694 | 39694 | 191411 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 462 Thornton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012808.38143 | 2094403.0124599999 | 37.7315529172119 | -122.39804293216001 | (37.7315529172119, -122.39804293216) | |||
| 40455 | 40455 | 177006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 271 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009831.15293 | 2088401.27476 | 37.7149071271443 | -122.40791276406 | (37.7149071271443, -122.40791276406) | |||
| 40972 | 40972 | 185610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2251 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986429.217999999 | 2100931.4203 | 37.7479736765682 | -122.48971952481001 | (37.7479736765682, -122.48971952481) | |||
| 41674 | 41674 | 185771 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1325 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989890.4756 | 2102411.1303 | 37.7522380517247 | -122.47785892610399 | (37.7522380517247, -122.477858926104) | |||
| 42179 | 42179 | 207304 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 53 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996585.7495 | 2094006.0145 | 37.72954596675461 | -122.454098749052 | (37.7295459667546, -122.454098749052) | |||
| 42221 | 42221 | 207173 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995323.713819999 | 2098239.63146 | 37.7410979958728 | -122.45876808490601 | (37.7410979958728, -122.458768084906) | |||
| 42565 | 42565 | 226630 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 17 Temple St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6000001.75416 | 2105889.17936 | 37.7623695721306 | -122.443142420082 | (37.7623695721306, -122.443142420082) | |||
| 42650 | 42650 | 207339 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 436 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999175.62485 | 2094995.5474599998 | 37.7324111582276 | -122.445216436593 | (37.7324111582276, -122.445216436593) | |||
| 42681 | 42681 | 207330 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995685.60702 | 2098472.19978 | 37.7417573653183 | -122.45753361969601 | (37.7417573653183, -122.457533619696) | |||
| 42942 | 42942 | 207270 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | |||
| 43666 | 43666 | 207282 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 163 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995118.51339 | 2093829.85755 | 37.7289780403896 | -122.459158347475 | (37.7289780403896, -122.459158347475) | |||
| 43733 | 43733 | 207159 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992101.70168 | 2094641.4985900002 | 37.7310327079752 | -122.469646658486 | (37.7310327079752, -122.469646658486) | |||
| 44325 | 44325 | 207349 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997332.96655 | 2095282.6428599998 | 37.733094101592705 | -122.451607607218 | (37.7330941015927, -122.451607607218) | |||
| 44643 | 44643 | 177014 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002672.79218 | 2094323.6061200001 | 37.7307651596849 | -122.433077929925 | (37.7307651596849, -122.433077929925) | |||
| 44944 | 44944 | 176990 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998584.85135 | 2087137.0809 | 37.7107998882796 | -122.446693649496 | (37.7107998882796, -122.446693649496) | |||
| 45169 | 45169 | 183658 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1487 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981219.3285 | 2104945.9280000003 | 37.7586908149842 | -122.508032687607 | (37.7586908149842, -122.508032687607) | |||
| 46244 | 46244 | 250337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 21 25th Ave North | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5987995.71435 | 2115876.11718 | 37.7890990187437 | -122.485399212222 | (37.7890990187437, -122.485399212222) | |||
| 46658 | 46658 | 207264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 319 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993222.99582 | 2089325.40947 | 37.716500767187 | -122.465384161548 | (37.716500767187, -122.465384161548) | |||
| 47578 | 47578 | 226625 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 311 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002111.00363 | 2104000.9193700003 | 37.7573049096042 | -122.43571221954299 | (37.7573049096042, -122.435712219543) | |||
| 47592 | 47592 | 207190 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999972.7522599995 | 2094392.56954 | 37.7308009895699 | -122.44241731471399 | (37.7308009895699, -122.442417314714) | ||||
| 47869 | 47869 | 129491 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999689.18555 | 2117591.31365 | 37.794482803901296 | -122.445064787505 | (37.7944828039013, -122.445064787505) | |||
| 48128 | 48128 | 207250 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 571 Arch St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992722.93824 | 2090965.0292099998 | 37.7209739131985 | -122.467231741345 | (37.7209739131985, -122.467231741345) | |||
| 48704 | 48704 | 207278 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 575 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994134.4568 | 2099399.45739 | 37.7442141593615 | -122.462964201952 | (37.7442141593615, -122.462964201952) | |||
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 48941 | 48941 | 177000 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 759 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002010.1952 | 2089376.96729 | 37.717145196164395 | -122.435014983257 | (37.7171451961644, -122.435014983257) | |||
| 49438 | 49438 | 226600 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | |||
| 49999 | 49999 | 207214 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997600.50896 | 2093520.6605599998 | 37.7282714349614 | -122.450555663017 | (37.7282714349614, -122.450555663017) | |||
| 50277 | 50277 | 226617 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 58 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005670.60555 | 2097390.14395 | 37.739354782382996 | -122.422931867621 | (37.739354782383, -122.422931867621) | |||
| 51445 | 51445 | 207262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 510 Ramsell St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993010.6580300005 | 2090589.3329599998 | 37.7199589473287 | -122.466209899286 | (37.7199589473287, -122.466209899286) | |||
| 51460 | 51460 | 226589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | |||
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 51759 | 51759 | 207273 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2486 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991107.555 | 2098499.64463 | 37.741568687546604 | -122.473364852413 | (37.7415686875466, -122.473364852413) | |||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 52088 | 52088 | 177024 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 11 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.42366493918301 | (37.7277939084451, -122.423664939183) | ||||
| 52824 | 52824 | 207200 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997508.4902099995 | 2094418.65818 | 37.7307318559937 | -122.45093849993401 | (37.7307318559937, -122.450938499934) | |||
| 53082 | 53082 | 139036 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000642.6462 | 2113889.2265 | 37.784372208438604 | -122.441499920001 | (37.7843722084386, -122.441499920001) | |||
| 53679 | 53679 | 207188 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999995.26886 | 2094392.10213 | 37.7308009895535 | -122.442339437931 | (37.7308009895535, -122.442339437931) | ||||
| 53847 | 53847 | 207299 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | |||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 54128 | 54128 | 247978 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009784.19004 | 2099413.44589 | 37.7451415861154 | -122.40885156275299 | (37.7451415861154, -122.408851562753) | ||||
| 54556 | 54556 | 207281 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993428.290469999 | 2094922.6798 | 37.731881346040794 | -122.46508086700001 | (37.7318813460408, -122.465080867) | |||
| 54753 | 54753 | 207286 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993623.31026 | 2093437.41863 | 37.7278144273955 | -122.464298855206 | (37.7278144273955, -122.464298855206) | |||
| 55280 | 55280 | 184220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3437 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984130.1355 | 2104934.7045 | 37.758831082518896 | -122.49796511397498 | (37.7588310825189, -122.497965113975) | |||
| 55314 | 55314 | 207344 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 543 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5998095.360119999 | 2095203.1187900002 | 37.7329193786311 | -122.448966095125 | (37.7329193786311, -122.448966095125) | |||
| 55980 | 55980 | 207361 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 452 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999521.461730001 | 2093554.76745 | 37.72847484721579 | -122.443917320952 | (37.7284748472158, -122.443917320952) | |||
| 56032 | 56032 | 207275 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993069.797230001 | 2099663.50314 | 37.7448777789813 | -122.46666472241999 | (37.7448777789813, -122.46666472242) | |||
| 56436 | 56436 | 207226 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 224 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995369.52282 | 2091446.6873400002 | 37.722448854419795 | -122.45811818710399 | (37.7224488544198, -122.458118187104) | |||
| 56500 | 56500 | 177008 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 67 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001385.71309 | 2093783.96595 | 37.7292103388668 | -122.43748892737301 | (37.7292103388668, -122.437488927373) | ||||
| 56956 | 56956 | 207310 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996630.650640001 | 2093957.49673 | 37.7294153231391 | -122.453940019643 | (37.7294153231391, -122.453940019643) | |||
| 57155 | 57155 | 207179 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5995334.19857 | 2098241.75122 | 37.741104418845794 | -122.458731986098 | (37.7411044188458, -122.458731986098) | |||
| 57295 | 57295 | 207143 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991127.14012 | 2104370.55559 | 37.7576898140615 | -122.473725315989 | (37.7576898140615, -122.473725315989) | |||
| 57399 | 57399 | 176993 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998644.90157 | 2087151.5668400002 | 37.7108430935156 | -122.44648714447099 | (37.7108430935156, -122.446487144471) | |||
| 57514 | 57514 | 226606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2560 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002251.74918 | 2096967.99127 | 37.7380021417799 | -122.434722564214 | (37.7380021417799, -122.434722564214) | |||
| 57932 | 57932 | 226588 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Treat Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008565.829469999 | 2106391.50298 | 37.7642334332393 | -122.41355789668002 | (37.7642334332393, -122.41355789668) | |||
| 58029 | 58029 | 207272 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5991341.884190001 | 2102447.3188400003 | 37.7524215459225 | -122.472842415544 | (37.7524215459225, -122.472842415544) | |||
| 58147 | 58147 | 207303 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 59 Hazelwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996585.5854400005 | 2094033.89672 | 37.7296225152507 | -122.45410132920601 | (37.7296225152507, -122.454101329206) | |||
| 58753 | 58753 | 185611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2241 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986448.3245 | 2100932.1027 | 37.747976665787895 | -122.489653506406 | (37.7479766657879, -122.489653506406) | |||
| 59000 | 59000 | 227698 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 517 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004312.97566 | 2110291.73585 | 37.7747028072132 | -122.428545336007 | (37.7747028072132, -122.428545336007) | |||
| 59067 | 59067 | 207271 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991354.98649 | 2102448.1922400002 | 37.752424702544296 | -122.47279716974899 | (37.7524247025443, -122.472797169749) | |||
| 59113 | 59113 | 207317 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2146 12th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992616.43475 | 2100823.70057 | 37.748037210643396 | -122.46831674014 | (37.7480372106434, -122.46831674014) | |||
| 59140 | 59140 | 207326 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 43 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998477.362380001 | 2097389.2678 | 37.7389438623547 | -122.447802750104 | (37.7389438623547, -122.447802750104) | |||
| 59196 | 59196 | 78418 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988809.97189 | 2095328.5114400003 | 37.732728266388 | -122.481076880696 | (37.732728266388, -122.481076880696) | ||
| 59419 | 59419 | 207291 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993593.95913 | 2093848.0757900001 | 37.7289402994475 | -122.464430125662 | (37.7289402994475, -122.464430125662) | |||
| 59479 | 59479 | 207337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999331.40158 | 2095537.8442099998 | 37.7339090681372 | -122.44471684701901 | (37.7339090681372, -122.444716847019) | |||
| 59513 | 59513 | 207233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5994045.888719999 | 2089197.1437900001 | 37.7161960040241 | -122.462530559657 | (37.7161960040241, -122.462530559657) | |||
| 59665 | 59665 | 226580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998192.72104 | 2105385.2518599997 | 37.7608825979841 | -122.44936285530599 | (37.7608825979841, -122.449362855306) |
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");