Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 147367 | 147367 | 194594 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 22 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014433.28496 | 2105898.16367 | 37.7632065495547 | -122.393229358544 | (37.7632065495547, -122.393229358544) | ||||
| 182983 | 182983 | 194593 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 21 | : Yard 23 | Tree 1 | Private 1 | 19 | 6014441.963140001 | 2105885.02123 | 37.763170945392496 | -122.393198423694 | (37.7631709453925, -122.393198423694) | ||||
| 45715 | 45715 | 234010 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 10 Museum Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000617.506990001 | 2106869.9600299997 | 37.765097643976205 | -122.44108313359301 | (37.7650976439762, -122.441083133593) | |||
| 11243 | 11243 | 19800 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 STAIRWAY21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 6542 | 6542 | 19818 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 STAIRWAY25 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 41833 | 41833 | 211469 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 Terrace Dr | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5993761.6919599995 | 2096603.4346099999 | 37.7365155021795 | -122.46405020255199 | (37.7365155021795, -122.464050202552) | ||||
| 149478 | 149478 | 211470 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 Terrace Dr | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5993769.41475 | 2096594.44879 | 37.736491274435295 | -122.46402284969801 | (37.7364912744353, -122.464022849698) | ||||
| 179175 | 179175 | 211468 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100 Terrace Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5993742.38425 | 2096618.3358099998 | 37.7365553043905 | -122.464118038412 | (37.7365553043905, -122.464118038412) | ||||
| 136941 | 136941 | 211477 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100x Idora Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.45835764690001 | (37.7442441346666, -122.4583576469) | |||
| 12103 | 12103 | 20322 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 101X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 47165 | 47165 | 233997 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1027 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001336.17311 | 2100800.0445 | 37.748472034653204 | -122.438162590655 | (37.7484720346532, -122.438162590655) | |||
| 159317 | 159317 | 233993 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 105 Manchester St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008275.13966 | 2099356.88691 | 37.7449016452007 | -122.414065613435 | (37.7449016452007, -122.414065613435) | |||
| 173576 | 173576 | 233983 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 107 Valley St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6005148.37303 | 2099292.84889 | 37.7445496964121 | -122.42487284919599 | (37.7445496964121, -122.424872849196) | |||
| 30244 | 30244 | 194592 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1098 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014470.31991 | 2105301.99437 | 37.761571655840896 | -122.393059550356 | (37.7615716558409, -122.393059550356) | |||
| 157349 | 157349 | 233978 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1100 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004853.46612 | 2096726.8825 | 37.7374874741536 | -122.42570998043999 | (37.7374874741536, -122.42570998044) | ||||
| 58076 | 58076 | 247523 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1101 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000011.18383 | 2108488.88375 | 37.769508249328 | -122.44329653959801 | (37.769508249328, -122.443296539598) | ||||
| 179133 | 179133 | 247531 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1101 Waller St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6000098.46541 | 2108483.59021 | 37.7694986913322 | -122.44299425679199 | (37.7694986913322, -122.442994256792) | ||||
| 86550 | 86550 | 26088 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 113 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5995784.15621 | 2088035.19399 | 37.7131055131157 | -122.45643833605101 | (37.7131055131157, -122.456438336051) | |||
| 39820 | 39820 | 233996 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1145 Douglass St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6001366.11278 | 2100375.0445 | 37.7473067884747 | -122.438028621322 | (37.7473067884747, -122.438028621322) | |||
| 164996 | 164996 | 233995 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1145 Douglass St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6001366.55787 | 2100367.96717 | 37.7472873811201 | -122.43802657536301 | (37.7472873811201, -122.438026575363) | |||
| 169157 | 169157 | 124548 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1150 Balboa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5991953.60014 | 2111376.98863 | 37.7769754370491 | -122.471377606459 | (37.7769754370491, -122.471377606459) | |||
| 66347 | 66347 | 186804 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1200 Sunset Blvd | 82 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984861.7413 | 2106944.0092 | 37.764390936343396 | -122.495583120993 | (37.7643909363434, -122.495583120993) | |||
| 135558 | 135558 | 186792 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1200 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984833.7733 | 2106884.7068 | 37.764226470840704 | -122.495675478568 | (37.7642264708407, -122.495675478568) | |||
| 158168 | 158168 | 186791 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1200 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984846.9804 | 2106884.4478 | 37.7642265331059 | -122.49562978055599 | (37.7642265331059, -122.495629780556) | |||
| 187048 | 187048 | 184828 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1201 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984677.9194 | 2106908.733 | 37.7642833118986 | -122.496216297403 | (37.7642833118986, -122.496216297403) | |||
| 156090 | 156090 | 211478 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1215 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5995031.11376 | 2091994.61811 | 37.7239338905283 | -122.45932764218 | (37.7239338905283, -122.45932764218) | |||
| 10535 | 10535 | 114182 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 126 Chester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x6 | Permit Number 776810 | 5991719.57231 | 2088350.33 | 37.713736615419606 | -122.470509712677 | (37.7137366154196, -122.470509712677) | ||
| 39743 | 39743 | 248507 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 130 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999267.956 | 2107716.9114 | 37.7673461983853 | -122.445811798931 | (37.7673461983853, -122.445811798931) | |||
| 68502 | 68502 | 248505 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 130 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999316.1058 | 2107725.6935 | 37.767373060939896 | -122.445645887747 | (37.7673730609399, -122.445645887747) | |||
| 149515 | 149515 | 248506 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 130 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999287.9427 | 2107719.9397 | 37.767355654506204 | -122.445742885801 | (37.7673556545062, -122.445742885801) | |||
| 24142 | 24142 | 234004 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1300 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003211.15019 | 2100572.61203 | 37.7479540161859 | -122.431662723473 | (37.7479540161859, -122.431662723473) | |||
| 165069 | 165069 | 194591 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1301 Minnesota St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6015395.46497 | 2102261.8945 | 37.7532755385605 | -122.38964748835501 | (37.7532755385605, -122.389647488355) | ||||
| 133972 | 133972 | 141331 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1314 HAYES ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6001508.4423 | 2110462.1858 | 37.77501170983761 | -122.43825897806101 | (37.7750117098376, -122.438258978061) | |||
| 75693 | 75693 | 84706 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1314 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51012 | 6001521.7618 | 2110464.8497 | 37.775019781788004 | -122.438213093993 | (37.775019781788, -122.438213093993) | |
| 122695 | 122695 | 83413 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1315 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50776 | 5993906.073517201 | 2094457.35212766 | 37.7306312095738 | -122.463395327953 | (37.7306312095738, -122.463395327953) | ||
| 148229 | 148229 | 211474 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1315 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 5993912.048780001 | 2094465.3579400002 | 37.730653535825 | -122.463375251462 | (37.730653535825, -122.463375251462) | |||
| 159016 | 159016 | 211473 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1315 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5993901.96581 | 2094475.8287900002 | 37.730681705290706 | -122.46341086912399 | (37.7306817052907, -122.463410869124) | |||
| 44063 | 44063 | 211456 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1380 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992429.060880001 | 2106083.47981 | 37.7624683707489 | -122.46934745851699 | (37.7624683707489, -122.469347458517) | |||
| 66769 | 66769 | 211455 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1380 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992429.4104 | 2106070.41105 | 37.7624325075809 | -122.469345298373 | (37.7624325075809, -122.469345298373) | |||
| 168543 | 168543 | 132444 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 14 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6008522.99961 | 2119161.3261700002 | 37.7992939016597 | -122.414609756357 | (37.7992939016597, -122.414609756357) | ||||
| 30293 | 30293 | 186656 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984694.4647 | 2105572.7074 | 37.7606159295654 | -122.496060500131 | (37.7606159295654, -122.496060500131) | |||
| 30763 | 30763 | 186646 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984695.8255 | 2105597.2027 | 37.7606832665135 | -122.496057600995 | (37.7606832665135, -122.496057600995) | |||
| 42518 | 42518 | 186648 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984709.2247 | 2105592.1781 | 37.760670255173295 | -122.49601088920299 | (37.7606702551733, -122.496010889203) | |||
| 45350 | 45350 | 186663 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984720.949 | 2105554.1789 | 37.7605666066845 | -122.49596753741301 | (37.7605666066845, -122.495967537413) | |||
| 155645 | 155645 | 186655 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984713.9353 | 2105578.1508 | 37.7606320160305 | -122.49599356275101 | (37.7606320160305, -122.495993562751) | |||
| 164632 | 164632 | 186657 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984716.7617 | 2105568.8342 | 37.7606066007934 | -122.49598310033701 | (37.7606066007934, -122.495983100337) | |||
| 167087 | 167087 | 186647 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984704.6187 | 2105598.4589 | 37.7606872307171 | -122.496027282411 | (37.7606872307171, -122.496027282411) | |||
| 178514 | 178514 | 186645 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984688.7072 | 2105597.6215 | 37.7606839994869 | -122.496082250517 | (37.7606839994869, -122.496082250517) | |||
| 179629 | 179629 | 186650 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984710.0621 | 2105582.1287 | 37.7606427113778 | -122.49600725166401 | (37.7606427113778, -122.496007251664) | |||
| 184488 | 184488 | 186654 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984682.9498 | 2105583.1755 | 37.7606439975841 | -122.49610109666901 | (37.7606439975841, -122.496101096669) | |||
| 99127 | 99127 | 20590 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
| 105316 | 105316 | 20591 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1401X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
| 55865 | 55865 | 211453 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1419 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991125.878830001 | 2105721.1672 | 37.761398162224296 | -122.473828208309 | (37.7613981622243, -122.473828208309) | |||
| 54393 | 54393 | 211454 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1478 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 5991840.401000001 | 2105371.22942 | 37.7604786845549 | -122.471331499675 | (37.7604786845549, -122.471331499675) | |||
| 64572 | 64572 | 233984 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1500 Cole St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 5998354.25958 | 2105273.76497 | 37.7605857218813 | -122.448796136753 | (37.7605857218813, -122.448796136753) | |||
| 158728 | 158728 | 194598 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 22nd St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6013347.3325 | 2103843.81837 | 37.7575053774884 | -122.39684129758801 | (37.7575053774884, -122.396841297588) | ||||
| 170696 | 170696 | 194597 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 22nd St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6013352.62113 | 2103844.18935 | 37.757506690487105 | -122.396823033261 | (37.7575066904871, -122.396823033261) | ||||
| 150075 | 150075 | 186582 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 Sunset Blvd | 53 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5984722.9379 | 2104579.1806 | 37.757889649764294 | -122.495888732757 | (37.7578896497643, -122.495888732757) | |||
| 162494 | 162494 | 186583 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5984720.8443 | 2104581.693 | 37.757896425499794 | -122.49589615853 | (37.7578964254998, -122.49589615853) | |||
| 176746 | 176746 | 186600 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984761.7745 | 2104445.7124 | 37.7575254576625 | -122.49574457656401 | (37.7575254576625, -122.495744576564) | |||
| 77455 | 77455 | 20674 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
| 96248 | 96248 | 20668 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
| 144127 | 144127 | 20669 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
| 173564 | 173564 | 211512 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 160 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994897.8322 | 2099478.1104 | 37.7444740625255 | -122.460330331374 | (37.7444740625255, -122.460330331374) | |||
| 28295 | 28295 | 178408 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001651.1985599995 | 2094173.31719 | 37.7302944985896 | -122.43659898077699 | (37.7302944985896, -122.436598980777) | ||||
| 41576 | 41576 | 178403 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001622.1469 | 2094146.16948 | 37.7302183062155 | -122.436697473612 | (37.7302183062155, -122.436697473612) | ||||
| 51885 | 51885 | 178405 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001634.24365 | 2094157.9299599999 | 37.7302512852578 | -122.436656495109 | (37.7302512852578, -122.436656495109) | ||||
| 61904 | 61904 | 178404 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001626.60618 | 2094150.6328 | 37.730230814892295 | -122.43668237668301 | (37.7302308148923, -122.436682376683) | ||||
| 147916 | 147916 | 178401 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001606.4733 | 2094132.41207 | 37.730179640767105 | -122.43675067480301 | (37.7301796407671, -122.436750674803) | ||||
| 154461 | 154461 | 178407 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001645.05047 | 2094167.64617 | 37.730278577884 | -122.436619829756 | (37.730278577884, -122.436619829756) | ||||
| 165371 | 165371 | 178406 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001639.75964 | 2094163.19973 | 37.7302660683079 | -122.43663780268801 | (37.7302660683079, -122.436637802688) | ||||
| 180464 | 180464 | 178402 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1601 San Jose Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001615.13724 | 2094139.0666599998 | 37.7301984051332 | -122.436721198652 | (37.7301984051332, -122.436721198652) | ||||
| 24930 | 24930 | 233980 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1609 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | Width 3ft | 6005332.72592 | 2098929.24645 | 37.7435617380791 | -122.424209538959 | (37.7435617380791, -122.424209538959) | |||
| 51628 | 51628 | 211457 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1612 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993723.499 | 2104492.49464 | 37.758174657459996 | -122.464754967966 | (37.75817465746, -122.464754967966) | |||
| 52805 | 52805 | 178420 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 164 Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000582.8572 | 2092343.3357400002 | 37.7252090212659 | -122.440161196294 | (37.7252090212659, -122.440161196294) | |||
| 54641 | 54641 | 178419 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 164 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000583.99969 | 2092347.99835 | 37.7252218887704 | -122.44015758103201 | (37.7252218887704, -122.440157581032) | |||
| 183777 | 183777 | 186177 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1700 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984961.556 | 2103549.9107 | 37.755077531997706 | -122.49498761075701 | (37.7550775319977, -122.494987610757) | |||
| 42414 | 42414 | 178412 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001615.63687 | 2094138.09403 | 37.7301957629086 | -122.43671940177201 | (37.7301957629086, -122.436719401772) | ||||
| 73209 | 73209 | 178418 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6001657.79965 | 2094178.37716 | 37.730308767230795 | -122.43657652198999 | (37.7303087672308, -122.43657652199) | ||||
| 135061 | 135061 | 178414 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6001625.71874 | 2094150.1248299999 | 37.7302293696897 | -122.436685408329 | (37.7302293696897, -122.436685408329) | ||||
| 137516 | 137516 | 178413 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6001621.7877 | 2094145.7694700002 | 37.7302171874661 | -122.43669868679 | (37.7302171874661, -122.43669868679) | ||||
| 160773 | 160773 | 178411 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001607.21703 | 2094132.14841 | 37.730178959084796 | -122.43674808476999 | (37.7301789590848, -122.43674808477) | ||||
| 171212 | 171212 | 178415 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001633.0697 | 2094156.39849 | 37.730247013477005 | -122.43666044402399 | (37.730247013477, -122.436660444024) | ||||
| 177748 | 177748 | 178416 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6001641.53674 | 2094164.63815 | 37.7302701188701 | -122.43663176194599 | (37.7302701188701, -122.436631761946) | ||||
| 178678 | 178678 | 178417 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1703 San Jose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001651.54923 | 2094173.3046900001 | 37.730294484195205 | -122.43659776757099 | (37.7302944841952, -122.436597767571) | ||||
| 98348 | 98348 | 16748 | Permitted Site 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1760 O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002837.590688201 | 2113421.7446697 | 37.7832134248204 | -122.43387275689399 | (37.7832134248204, -122.433872756894) | |||
| 27472 | 27472 | 186312 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1800 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984965.9651 | 2102794.0558 | 37.753002421044 | -122.494916634558 | (37.753002421044, -122.494916634558) | |||
| 31532 | 31532 | 186290 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1800 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984992.545 | 2102621.6891 | 37.752530705423496 | -122.49481201009701 | (37.7525307054235, -122.494812010097) | |||
| 146557 | 146557 | 132408 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1900 Jefferson St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000027.88392 | 2121296.8917799997 | 37.804676658858206 | -122.444159252968 | (37.8046766588582, -122.444159252968) | |||
| 46821 | 46821 | 186045 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1900 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984977.5299 | 2102204.8272 | 37.7513852382741 | -122.494833201598 | (37.7513852382741, -122.494833201598) | |||
| 68134 | 68134 | 186046 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1900 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984987.6927 | 2102206.2791 | 37.7513898196771 | -122.49479816500099 | (37.7513898196771, -122.494798165001) | |||
| 39614 | 39614 | 137943 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1934 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003936.5354 | 2115120.5913 | 37.787940331576294 | -122.430192087218 | (37.7879403315763, -122.430192087218) | |||
| 111240 | 111240 | 121001 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1992X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | ||||
| 69268 | 69268 | 116648 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 79334 | 79334 | 116646 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | ||||
| 82496 | 82496 | 116652 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 112164 | 112164 | 116647 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 118788 | 118788 | 116651 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 129308 | 129308 | 116650 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | |||||
| 145521 | 145521 | 116649 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) |
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");