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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70570 | 70570 | 207314 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994021.19813 | 2104903.51705 | 37.759320377550395 | -122.46375523571999 | (37.7593203775504, -122.46375523572) | |||
| 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) | ||
| 133963 | 133963 | 184221 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3435 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984145.6537 | 2104934.9816 | 37.7588327531435 | -122.49791146613899 | (37.7588327531435, -122.497911466139) | |||
| 154080 | 154080 | 207315 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994029.69886 | 2104725.63145 | 37.7588324395785 | -122.463712925326 | (37.7588324395785, -122.463712925326) | |||
| 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) | |||
| 173335 | 173335 | 183659 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1487 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981220.5326 | 2104962.3842 | 37.7587360699481 | -122.50802974468701 | (37.7587360699481, -122.508029744687) | |||
| 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) | |||
| 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) | |||
| 73802 | 73802 | 207144 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991126.06401 | 2104353.71257 | 37.757643505256205 | -122.473727808906 | (37.7576435052562, -122.473727808906) | |||
| 23484 | 23484 | 226621 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2498 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008827.83459 | 2103955.23814 | 37.7575587153899 | -122.412479469249 | (37.7575587153899, -122.412479469249) | |||
| 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) | |||
| 129805 | 129805 | 226626 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Liberty St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6004198.11867 | 2103939.92108 | 37.757255752658295 | -122.42848980825899 | (37.7572557526583, -122.428489808259) | |||
| 180537 | 180537 | 226627 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Liberty St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6004024.53424 | 2103933.71517 | 37.7572288881251 | -122.42908968844401 | (37.7572288881251, -122.429089688444) | |||
| 184010 | 184010 | 226628 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 572 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002604.15441 | 2103877.17293 | 37.7569931308375 | -122.433997867125 | (37.7569931308375, -122.433997867125) | |||
| 62758 | 62758 | 207140 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990920.30999 | 2103955.3917900003 | 37.7565379030086 | -122.474410316087 | (37.7565379030086, -122.474410316087) | |||
| 147909 | 147909 | 226624 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 366 Eureka St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.5255 | 2103604.00302 | 37.75617816071271 | -122.437929936033 | (37.7561781607127, -122.437929936033) | |||
| 133915 | 133915 | 226620 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 688 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007284.68348 | 2103336.34747 | 37.7557726618001 | -122.417772455244 | (37.7557726618001, -122.417772455244) | |||
| 52623 | 52623 | 40627 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | ||
| 158138 | 158138 | 226603 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 12 Worth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6000852.5389 | 2103221.37405 | 37.755092904720996 | -122.44000857865801 | (37.755092904721, -122.440008578658) | |||
| 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) | |||
| 76282 | 76282 | 226604 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Collingwood St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6002163.6712 | 2103050.21539 | 37.7546974962127 | -122.435462066843 | (37.7546974962127, -122.435462066843) | |||
| 166888 | 166888 | 207141 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990964.44749 | 2102904.31775 | 37.7536544876696 | -122.474180983561 | (37.7536544876696, -122.474180983561) | |||
| 24701 | 24701 | 226623 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004079.6139400005 | 2102598.16626 | 37.7535649035083 | -122.428803992713 | (37.7535649035083, -122.428803992713) | |||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 186756 | 186756 | 182869 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988126.7611 | 2102732.0567 | 37.753016709320995 | -122.48398158304701 | (37.753016709321, -122.483981583047) | |||
| 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) | |||
| 169719 | 169719 | 207149 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 830 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5991414.091469999 | 2102515.7859 | 37.7526137184551 | -122.47259770464198 | (37.7526137184551, -122.472597704642) | |||
| 68943 | 68943 | 207150 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 830 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5991404.13851 | 2102515.6148 | 37.752612672541105 | -122.47263211090099 | (37.7526126725411, -122.472632110901) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 137025 | 137025 | 185770 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1325 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989884.1917 | 2102410.6066 | 37.752236249076205 | -122.477880618296 | (37.7522362490762, -122.477880618296) | |||
| 61927 | 61927 | 184535 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1914 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981673.4595 | 2102023.0319999997 | 37.7506921190217 | -122.506245385817 | (37.7506921190217, -122.506245385817) | |||
| 59680 | 59680 | 207153 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 37 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992857.79641 | 2101696.45596 | 37.750447510654396 | -122.467545586773 | (37.7504475106544, -122.467545586773) | |||
| 52741 | 52741 | 92437 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1974 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52827 | 5982618.164 | 2101679.0263 | 37.7498031456316 | -122.502953108098 | (37.7498031456316, -122.502953108098) |
| 26283 | 26283 | 226595 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 880 Douglass St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6001269.3073 | 2101283.04072 | 37.749794423884794 | -122.438428410468 | (37.7497944238848, -122.438428410468) | |||
| 73666 | 73666 | 184518 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4108 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982209.6889 | 2101522.5062 | 37.7493493689338 | -122.504354014902 | (37.7493493689338, -122.504354014902) | |||
| 161773 | 161773 | 226598 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4222 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002345.605769999 | 2100643.12019 | 37.7480985156327 | -122.434660776296 | (37.7480985156327, -122.434660776296) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 68986 | 68986 | 185609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2261 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986412.841 | 2100929.3732 | 37.747967099583 | -122.489776004492 | (37.747967099583, -122.489776004492) | |||
| 147919 | 147919 | 226594 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6001878.86211 | 2100572.13278 | 37.747877092657795 | -122.43626967691799 | (37.7478770926578, -122.436269676918) | |||
| 73346 | 73346 | 226593 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001851.9880099995 | 2100572.11343 | 37.7478755125637 | -122.43636260477301 | (37.7478755125637, -122.436362604773) | |||
| 159577 | 159577 | 226592 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001848.149780001 | 2100568.16422 | 37.7478644508775 | -122.43637559457198 | (37.7478644508775, -122.436375594572) | |||
| 165558 | 165558 | 226619 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007856.36673 | 2100270.38915 | 37.747386388365705 | -122.415578321691 | (37.7473863883657, -122.415578321691) | |||
| 188359 | 188359 | 226618 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007884.76815 | 2100264.95114 | 37.7473730532316 | -122.415479726319 | (37.7473730532316, -122.415479726319) | |||
| 26934 | 26934 | 227699 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 194 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005300.17225 | 2100223.67209 | 37.7471140970563 | -122.42441415180099 | (37.7471140970563, -122.424414151801) | |||
| 177328 | 177328 | 226612 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008238.81555 | 2100053.8415599996 | 37.7468132873058 | -122.41424051718 | (37.7468132873058, -122.41424051718) | |||
| 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) | |||
| 178122 | 178122 | 207321 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995570.24881 | 2100282.2016 | 37.746720553705 | -122.458063448969 | (37.746720553705, -122.458063448969) | |||
| 177980 | 177980 | 207320 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995605.62076 | 2100279.71012 | 37.746715745033 | -122.45794095682699 | (37.746715745033, -122.457940956827) | |||
| 133848 | 133848 | 207319 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995627.90301 | 2100275.99182 | 37.7467068156796 | -122.45786363851299 | (37.7467068156796, -122.457863638513) | |||
| 175015 | 175015 | 207318 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.386969999 | 2100270.85159 | 37.746693763801204 | -122.457799351359 | (37.7466937638012, -122.457799351359) | |||
| 163615 | 163615 | 207164 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995446.92636 | 2100264.89737 | 37.7466659540754 | -122.45848863046001 | (37.7466659540754, -122.45848863046) | |||
| 67812 | 67812 | 207165 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995466.11989 | 2100230.17484 | 37.746571717707205 | -122.458419748693 | (37.7465717177072, -122.458419748693) | |||
| 161495 | 161495 | 226597 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1 Newburg St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6002589.21192 | 2100000.55478 | 37.746348008668 | -122.433772476325 | (37.746348008668, -122.433772476325) | |||
| 61 | 61 | 226596 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1 Newburg St | 4 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 4 | Width 4ft | 6002583.45295 | 2099992.19698 | 37.746324733318 | -122.433791792881 | (37.746324733318, -122.433791792881) | |||
| 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) | |||
| 161784 | 161784 | 226591 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 793 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001403.92595 | 2099956.05685 | 37.7461584981302 | -122.43786786123998 | (37.7461584981302, -122.43786786124) | ||||
| 138152 | 138152 | 226584 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 116 Franconia St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010066.87681 | 2099747.40872 | 37.746074405213704 | -122.40789762220301 | (37.7460744052137, -122.407897622203) | ||||
| 151291 | 151291 | 246438 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 498 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6003357.50799 | 2099800.56839 | 37.745842459268296 | -122.431101528529 | (37.7458424592683, -122.431101528529) | |||
| 162174 | 162174 | 226611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008212.2428 | 2099629.64736 | 37.745647051868 | -122.414302395044 | (37.745647051868, -122.414302395044) | |||
| 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) | |||
| 172660 | 172660 | 226590 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | |||
| 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) | ||||
| 183896 | 183896 | 226577 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 370 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003494.445309999 | 2099538.93677 | 37.745131838370206 | -122.43060935295601 | (37.7451318383702, -122.430609352956) | |||
| 188027 | 188027 | 207154 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 606 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990999.639880001 | 2099781.66866 | 37.745082545627106 | -122.47383148903299 | (37.7450825456271, -122.473831489033) | |||
| 153744 | 153744 | 207155 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 606 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990983.67458 | 2099779.50243 | 37.7450756729987 | -122.473886535662 | (37.7450756729987, -122.473886535662) | |||
| 136074 | 136074 | 207276 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5992917.36629 | 2099685.98724 | 37.7449307166945 | -122.467193430259 | (37.7449307166945, -122.467193430259) | |||
| 163785 | 163785 | 207274 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993100.15501 | 2099667.06703 | 37.7448893164068 | -122.466560010732 | (37.7448893164068, -122.466560010732) | |||
| 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) | |||
| 181523 | 181523 | 226601 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1518 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003286.59929 | 2099387.77612 | 37.7447050093281 | -122.431317259697 | (37.7447050093281, -122.431317259697) | |||
| 59492 | 59492 | 31354 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2324 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34964 | 5992033.25034 | 2099586.3658 | 37.7446061063992 | -122.47024325973 | (37.7446061063992, -122.47024325973) | |
| 183532 | 183532 | 227705 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1552 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005224.91638 | 2099272.18009 | 37.744497267738105 | -122.424606707457 | (37.7444972677381, -122.424606707457) | |||
| 67340 | 67340 | 246731 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ripley St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6008584.453369999 | 2099107.91594 | 37.7442353941634 | -122.41297845991001 | (37.7442353941634, -122.41297845991) | |||
| 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) | |||
| 173676 | 173676 | 207279 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 186 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5994221.53046 | 2099188.36085 | 37.743639556416504 | -122.462647812372 | (37.7436395564165, -122.462647812372) | |||
| 80194 | 80194 | 4999 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 88236 | 88236 | 4991 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 94015 | 94015 | 4992 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 95563 | 95563 | 4998 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 97805 | 97805 | 4994 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 99734 | 99734 | 4993 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 110729 | 110729 | 4995 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 143370 | 143370 | 5001 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 171392 | 171392 | 227706 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002827.0352300005 | 2098917.62308 | 37.743388023245394 | -122.432872760368 | (37.7433880232454, -122.432872760368) | |||
| 75923 | 75923 | 226602 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5200x Diamond Heights Blvd | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6001604.7772 | 2098884.15576 | 37.7432267298424 | -122.437096613431 | (37.7432267298424, -122.437096613431) | ||||
| 172332 | 172332 | 226576 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003654.19113 | 2098670.4327700003 | 37.7427561757625 | -122.42999503773501 | (37.7427561757625, -122.429995037735) | |||
| 131369 | 131369 | 207156 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991402.6198 | 2098893.19012 | 37.7426663442825 | -122.472373311184 | (37.7426663442825, -122.472373311184) | |||
| 183022 | 183022 | 207329 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 307 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5995854.78749 | 2098571.2519 | 37.7420390545738 | -122.45695581607401 | (37.7420390545738, -122.456955816074) | |||
| 89568 | 89568 | 87364 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 94485 | 94485 | 87363 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 102463 | 102463 | 87366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 138958 | 138958 | 87365 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 171196 | 171196 | 31366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2475 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34971 | 5991057.56391 | 2098576.78296 | 37.7417775946723 | -122.473543328283 | (37.7417775946723, -122.473543328283) | |
| 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) | |||
| 178747 | 178747 | 47762 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2462 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2002 12:00:00 AM | 4 | Permit Number 45541 | 5988312.7876 | 2098561.9922 | 37.741577647038 | -122.48303266006 | (37.741577647038, -122.48303266006) | |
| 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) | |||
| 63970 | 63970 | 227703 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 200 Kingston St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 8ft | 6006269.2438199995 | 2098023.2428599996 | 37.7411268910989 | -122.420906974789 | (37.7411268910989, -122.420906974789) |
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");