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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178430 | 178430 | 211694 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 389 Orizaba Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994001.77202 | 2089064.43875 | 37.7158290869265 | -122.462673425937 | (37.7158290869265, -122.462673425937) | |||
| 183904 | 183904 | 211693 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 389 Orizaba Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994001.78179 | 2089084.6403299998 | 37.7158845562099 | -122.46267485676901 | (37.7158845562099, -122.462674856769) | |||
| 185808 | 185808 | 211692 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 389 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994002.35315 | 2089131.6283900002 | 37.7160136071206 | -122.462676288507 | (37.7160136071206, -122.462676288507) | |||
| 87498 | 87498 | 26340 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2608 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5997493.9190197 | 2089064.0598561 | 37.7160285506219 | -122.450602979713 | (37.7160285506219, -122.450602979713) | |||
| 84170 | 84170 | 46737 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Sargent St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | |||
| 108156 | 108156 | 46738 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | |||
| 108219 | 108219 | 46736 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Sargent St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | |||
| 142486 | 142486 | 46739 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Sargent St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | |||
| 4676 | 4676 | 160569 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 797 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:33:00 AM | 3 | Width 0ft | 6002135.10796 | 2089068.7183299998 | 37.7163059047739 | -122.434561191648 | (37.7163059047739, -122.434561191648) | |
| 4633 | 4633 | 160570 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 795 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:41:00 AM | 3 | Width 0ft | 6002146.9194 | 2089087.66438 | 37.716358596934796 | -122.43452171951598 | (37.7163585969348, -122.434521719516) | |
| 185270 | 185270 | 211715 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 125 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997009.51995 | 2089220.21387 | 37.7164295750405 | -122.45228854418501 | (37.7164295750405, -122.452288544185) | |||
| 4688 | 4688 | 160571 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 793 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:54:00 AM | 3 | Width 0ft | 6002167.83829 | 2089121.34733 | 37.716452270331295 | -122.43445182061899 | (37.7164522703313, -122.434451820619) | |
| 60181 | 60181 | 39958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 359 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 11 | Permit Number 41220 | 6011014.50329 | 2089048.3723400002 | 37.7167501060151 | -122.40386809375099 | (37.7167501060151, -122.403868093751) | |
| 46509 | 46509 | 178456 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 45 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009660.24427 | 2089189.1884700002 | 37.7170610061367 | -122.408559046563 | (37.7170610061367, -122.408559046563) | |||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 43445 | 43445 | 65522 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 719 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 12 | Permit Number 28409 | 6001384.5426900005 | 2089392.37473 | 37.717151956363296 | -122.43717866488599 | (37.7171519563633, -122.437178664886) | |
| 49047 | 49047 | 66032 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 743 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1990 12:00:00 AM | 7 | Permit Number 29068 | 6001079.36545 | 2089410.09015 | 37.7171832464915 | -122.43823478371 | (37.7171832464915, -122.43823478371) | ||
| 11799 | 11799 | 117444 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1133 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776191 | 6004090.20732 | 2089350.17003 | 37.7171895030573 | -122.427823460996 | (37.7171895030573, -122.427823460996) | ||
| 53052 | 53052 | 178458 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 33 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009676.68207 | 2089239.02184 | 37.7171987588823 | -122.40850574196399 | (37.7171987588823, -122.408505741964) | |||
| 4656 | 4656 | 160582 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 725 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:12:00 PM | 3 | Width 0ft | 6002352.537690001 | 2089413.73171 | 37.7172655758154 | -122.433834295726 | (37.7172655758154, -122.433834295726) | |
| 168260 | 168260 | 39943 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 29 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 9 | Permit Number 41214 | 6009685.47715 | 2089271.25586 | 37.7172877594055 | -122.40847761386401 | (37.7172877594055, -122.408477613864) | |
| 50039 | 50039 | 211707 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 281 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994268.6956400005 | 2089616.2721799999 | 37.7173596593002 | -122.461790810607 | (37.7173596593002, -122.461790810607) | |||
| 47957 | 47957 | 211708 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 281 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5994276.386419999 | 2089616.24981 | 37.717360040608604 | -122.461764225736 | (37.7173600406086, -122.461764225736) | |||
| 41075 | 41075 | 103529 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 23 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6009696.39175 | 2089318.75297 | 37.717418787914504 | -122.40844323548299 | (37.7174187879145, -122.408443235483) | ||||
| 170039 | 170039 | 211721 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 574 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5993531.71485 | 2089666.42893 | 37.7174549244787 | -122.46434182931601 | (37.7174549244787, -122.464341829316) | |||
| 43594 | 43594 | 178459 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 23 Ervine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009703.10369 | 2089337.52357 | 37.7174707039878 | -122.408421358582 | (37.7174707039878, -122.408421358582) | |||
| 163127 | 163127 | 178460 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 21 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009708.04486 | 2089358.13135 | 37.717527565409895 | -122.408405731934 | (37.7175275654099, -122.408405731934) | |||
| 61004 | 61004 | 178461 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 19 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009712.0453 | 2089376.95758 | 37.7175794823798 | -122.40839323136002 | (37.7175794823798, -122.40839323136) | |||
| 173156 | 173156 | 178462 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 15 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009720.17678 | 2089399.5571700002 | 37.7176419915525 | -122.40836671757401 | (37.7176419915525, -122.408366717574) | |||
| 50985 | 50985 | 178463 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 11 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009725.182580001 | 2089422.6083099998 | 37.7177055655475 | -122.40835103969499 | (37.7177055655475, -122.408351039695) | |||
| 25741 | 25741 | 178464 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 11 Ervine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6009728.21502 | 2089438.3028099998 | 37.717748829219 | -122.40834166424101 | (37.717748829219, -122.408341664241) | |||
| 177149 | 177149 | 178465 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 7 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009733.05519 | 2089453.96045 | 37.7177920929094 | -122.40832603763201 | (37.7177920929094, -122.408326037632) | |||
| 86663 | 86663 | 88313 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 638 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51304 | 6003091.0 | 2089648.0 | 37.7179507025626 | -122.43129849323799 | (37.7179507025626, -122.431298493238) | |||
| 91481 | 91481 | 43730 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 765 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43367 | 5994391.56953299 | 2089904.56856692 | 37.7181583251094 | -122.46138698388 | (37.7181583251094, -122.46138698388) | ||
| 80758 | 80758 | 66245 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 717 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29344 | 5994860.14526787 | 2089894.90916917 | 37.7181587604438 | -122.459766630257 | (37.7181587604438, -122.459766630257) | ||
| 171271 | 171271 | 211687 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 717 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5994862.08279 | 2089903.15332 | 37.718181508344 | -122.45976052994601 | (37.718181508344, -122.459760529946) | |||
| 137644 | 137644 | 211686 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 760 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994384.075230001 | 2089944.9604200001 | 37.7182688001568 | -122.46141581488199 | (37.7182688001568, -122.461415814882) | |||
| 52421 | 52421 | 211689 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994986.56441 | 2089934.02733 | 37.7182734388575 | -122.459332487728 | (37.7182734388575, -122.459332487728) | |||
| 171752 | 171752 | 211691 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994923.94235 | 2089936.05858 | 37.7182754155504 | -122.459549091241 | (37.7182754155504, -122.459549091241) | |||
| 59203 | 59203 | 211690 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994941.539030001 | 2089936.1702400001 | 37.7182767339546 | -122.45948827546101 | (37.7182767339546, -122.459488275461) | |||
| 72688 | 72688 | 211683 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 901 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995004.69694 | 2089953.54253 | 37.7183280654705 | -122.459271224104 | (37.7183280654705, -122.459271224104) | |||
| 149840 | 149840 | 211681 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 207 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994710.07478 | 2089987.72263 | 37.7184049727945 | -122.46029207694401 | (37.7184049727945, -122.460292076944) | |||
| 24358 | 24358 | 211712 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 418 San Miguel St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997865.28032 | 2089936.92549 | 37.7184464872957 | -122.449382239324 | (37.7184464872957, -122.449382239324) | |||
| 59852 | 59852 | 70200 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | ||
| 23569 | 23569 | 211718 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 5992705.448530001 | 2090061.4664900003 | 37.7184919399203 | -122.46722653339701 | (37.7184919399203, -122.467226533397) | |||
| 171576 | 171576 | 211717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5992705.603080001 | 2090068.8173099998 | 37.7185121324114 | -122.46722653337099 | (37.7185121324114, -122.467226533371) | |||
| 70740 | 70740 | 178430 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 661 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001092.95814 | 2089944.7413 | 37.7186520516399 | -122.43822608009701 | (37.7186520516399, -122.438226080097) | ||||
| 157181 | 157181 | 211688 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 23 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995597.1575 | 2090065.2518900002 | 37.7186688374667 | -122.4572314268 | (37.7186688374667, -122.4572314268) | |||
| 176302 | 176302 | 95745 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 612 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767490 | 6001675.81608 | 2089939.2374 | 37.7186700722488 | -122.436210986273 | (37.7186700722488, -122.436210986273) |
| 138167 | 138167 | 57139 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 563 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 8 | Permit Number 14413 | 6003627.018180001 | 2089911.87724 | 37.7187056143591 | -122.42946452138099 | (37.7187056143591, -122.429464521381) | ||
| 4146 | 4146 | 216707 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:46:00 AM | 3 | Width 3ft | 5994758.05727 | 2090129.91465 | 37.7187981581945 | -122.460136518501 | (37.7187981581945, -122.460136518501) | ||
| 4153 | 4153 | 216751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 31 Granada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:38:00 AM | 3 | Width 3ft | 5995599.77101 | 2090122.1597400003 | 37.718825243070604 | -122.45722650749799 | (37.7188252430706, -122.457226507498) | ||
| 92008 | 92008 | 22524 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6600 03rd St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 117609 | 117609 | 22525 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6600 03rd St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 66655 | 66655 | 211682 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 242 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994758.1031599995 | 2090199.23595 | 37.7189885006068 | -122.460141379342 | (37.7189885006068, -122.460141379342) | |||
| 81740 | 81740 | 47330 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 242 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45261 | 5994763.5780735 | 2090205.44685868 | 37.719005869189 | -122.46012290455299 | (37.719005869189, -122.460122904553) | ||
| 105002 | 105002 | 50493 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 639 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778052 | 6002442.45455321 | 2090054.61865068 | 37.719030411332895 | -122.43356927156 | (37.7190304113329, -122.43356927156) | |
| 184548 | 184548 | 178431 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 639 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002445.76182 | 2090069.45072 | 37.719071324550704 | -122.433558899046 | (37.7190713245507, -122.433558899046) | |||
| 35913 | 35913 | 187464 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4900 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000844.9058 | 2090135.8768 | 37.719162755428705 | -122.439097185737 | (37.7191627554287, -122.439097185737) | |||
| 61400 | 61400 | 57137 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 531 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 15 | Permit Number 14410 | 6003728.2701 | 2090076.8001 | 37.7191641885546 | -122.42912628724399 | (37.7191641885546, -122.429126287244) | ||
| 120662 | 120662 | 15802 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4950 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2007 12:00:00 AM | 3 | 4x4 | 6000889.921047701 | 2090200.0223298 | 37.7193414459012 | -122.438946180066 | (37.7193414459012, -122.438946180066) | ||
| 51579 | 51579 | 35121 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 643 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2006 12:00:00 AM | 5 | Permit Number 48980 | 6002195.08031 | 2090177.57435 | 37.7193539814734 | -122.434433133593 | (37.7193539814734, -122.434433133593) | |
| 70179 | 70179 | 178454 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 700x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009463.675319999 | 2090037.3168799998 | 37.719378780282796 | -122.40929831179199 | (37.7193787802828, -122.409298311792) | |||
| 11314 | 11314 | 1055 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2048 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000420.28016 | 2090223.9309099999 | 37.7193803613008 | -122.44057126285 | (37.7193803613008, -122.44057126285) | |||
| 28638 | 28638 | 187463 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4900 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000900.9871 | 2090226.0946 | 37.719413664090204 | -122.438909796369 | (37.7194136640902, -122.438909796369) | |||
| 187848 | 187848 | 178457 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 327 Ordway St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6010945.35772 | 2090025.6456900002 | 37.7194296360547 | -122.40417583815099 | (37.7194296360547, -122.404175838151) | |||
| 153785 | 153785 | 94584 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 629 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6x5 | 6002248.02315 | 2090260.97587 | 37.7195859885866 | -122.434256089464 | (37.7195859885866, -122.434256089464) | |||
| 100118 | 100118 | 15796 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4950 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | |||
| 138539 | 138539 | 15801 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4950 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | |||
| 171979 | 171979 | 78308 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 513 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 11 | 6003542.033009999 | 2090288.27916 | 37.719734319173604 | -122.42978511348801 | (37.7197343191736, -122.429785113488) | ||
| 13096 | 13096 | 25421 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 601X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6010110.04101 | 2090175.58829 | 37.7197946375954 | -122.40707379643801 | (37.7197946375954, -122.407073796438) | |||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 104018 | 104018 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 717 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 142616 | 142616 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 755 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 146751 | 146751 | 211720 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 519 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992979.502730001 | 2090619.40325 | 37.720039715450504 | -122.46631977576 | (37.7200397154505, -122.46631977576) | |||
| 182710 | 182710 | 187459 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001044.847999999 | 2090452.8584 | 37.7200444903713 | -122.438428761504 | (37.7200444903713, -122.438428761504) | |||
| 113042 | 113042 | 39680 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 519 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41066 | 5992971.37473893 | 2090634.62644589 | 37.7200810456671 | -122.466348977018 | (37.7200810456671, -122.466348977018) | ||
| 47093 | 47093 | 211673 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 106 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994470.80245 | 2090644.3945 | 37.7201942702291 | -122.461166708984 | (37.7201942702291, -122.461166708984) | |||
| 23317 | 23317 | 15785 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4840 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 1 | 3X3 | 6001091.1761 | 2090535.7613 | 37.7202747581414 | -122.438274557422 | (37.7202747581414, -122.438274557422) | ||
| 113276 | 113276 | 39651 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 117 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41044 | 5994130.66454495 | 2090696.44616632 | 37.7203176113007 | -122.46234621667101 | (37.7203176113007, -122.462346216671) | ||
| 68060 | 68060 | 178452 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010603.6284 | 2090367.96219 | 37.720350466280706 | -122.405381170718 | (37.7203504662807, -122.405381170718) | |||
| 48631 | 48631 | 211680 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 117 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994133.05736 | 2090713.3428 | 37.7203641431827 | -122.46233917041599 | (37.7203641431827, -122.462339170416) | |||
| 77292 | 77292 | 178453 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010524.67693 | 2090375.89747 | 37.7203678402927 | -122.40565464016501 | (37.7203678402927, -122.405654640165) | |||
| 125534 | 125534 | 65464 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 118 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28342 | 5994182.95740399 | 2090714.30483177 | 37.7203696579549 | -122.46216675324499 | (37.7203696579549, -122.462166753245) | ||
| 188369 | 188369 | 211679 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 118 Ashton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994177.1078 | 2090720.2532400002 | 37.7203856540458 | -122.462187404445 | (37.7203856540458, -122.462187404445) | |||
| 12876 | 12876 | 15783 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4840 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 03:01:00 PM | 3 | 3X3 | 6001146.6106 | 2090614.741 | 37.7204947713768 | -122.43808859365 | (37.7204947713768, -122.43808859365) | ||
| 144541 | 144541 | 15787 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4840 MISSION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2015 10:02:00 AM | 3 | 3X3 | 6001135.0 | 2090627.0 | 37.720527771508 | -122.438129605408 | (37.720527771508, -122.438129605408) | ||
| 10922 | 10922 | 15782 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4840 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 12:38:00 PM | 3 | 3X3 | 6001159.6334 | 2090631.0194 | 37.720540208809204 | -122.43804474352801 | (37.7205402088092, -122.438044743528) | ||
| 35942 | 35942 | 178449 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6010808.01085 | 2090450.02432 | 37.7205872173052 | -122.404680457657 | (37.7205872173052, -122.404680457657) | |||
| 87214 | 87214 | 30146 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 410X Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 112506 | 112506 | 30144 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 410X Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 164762 | 164762 | 178450 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6010797.8661 | 2090455.72312 | 37.7206022980317 | -122.404715926025 | (37.7206022980317, -122.404715926025) | |||
| 62557 | 62557 | 178451 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6010787.10356 | 2090456.90218 | 37.720604933939704 | -122.404753211896 | (37.7206049339397, -122.404753211896) | |||
| 64724 | 64724 | 211674 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 134 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994473.26175 | 2090798.2403400003 | 37.7206168355785 | -122.46116935389 | (37.7206168355785, -122.46116935389) | |||
| 183541 | 183541 | 178448 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010856.8057 | 2090466.80243 | 37.720636013633204 | -122.404512968803 | (37.7206360136332, -122.404512968803) | |||
| 73863 | 73863 | 178447 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6010874.01783 | 2090466.7757 | 37.720636902145294 | -122.40445346966601 | (37.7206369021453, -122.404453469666) | |||
| 152455 | 152455 | 178446 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6010876.55341 | 2090479.6601099998 | 37.7206724217895 | -122.40444561137501 | (37.7206724217895, -122.404445611375) | |||
| 10812 | 10812 | 15780 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4834 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6001191.3763 | 2090682.2965 | 37.7206828093365 | -122.43793868957701 | (37.7206828093365, -122.437938689577) | ||
| 187371 | 187371 | 211675 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 140 Jules Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994473.3982 | 2090822.9981799999 | 37.7206848225258 | -122.461170675896 | (37.7206848225258, -122.461170675896) | |||
| 57047 | 57047 | 178445 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6010913.5453 | 2090485.6945900002 | 37.7206910584305 | -122.404318165774 | (37.7206910584305, -122.404318165774) |
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");