trees
7,157 rows where qSpecies_id = 36
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6198 | 112830 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 2265 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 3 | 3x3 | 6006944 | 2105170 | 37.760788269781 | -122.419080706794 | (37.760788269781, -122.419080706794) | 2 | 4 | 7 | 28859 | 19 | ||
6208 | 47715 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 178 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45511 | 6001758.80730105 | 2095060.28518468 | 37.7327360238789 | -122.436290415986 | (37.7327360238789, -122.436290415986) | 9 | 7 | 5 | 63 | 40 | ||
6220 | 70584 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1801 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989883.84823 | 2113332.42802 | 37.7822245827165 | -122.478680478509 | (37.7822245827165, -122.478680478509) | 11 | 6 | 2 | 55 | 26 | |||
6283 | 71276 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2133 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002723.69312 | 2118844.90685 | 37.7980975740013 | -122.43465471125 | (37.7980975740013, -122.43465471125) | 13 | 9 | 1 | 57 | 17 | |||
6297 | 19148 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 49 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3PL | 6003502.2481852 | 2108041.9364589 | 37.7684794961424 | -122.431189185107 | (37.7684794961424, -122.431189185107) | 7 | 9 | 5 | 28862 | 3 | |||
6299 | 75364 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1335 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6017823.2525 | 2092467.3959 | 37.7265161261373 | -122.380570876773 | (37.7265161261373, -122.380570876773) | 10 | 3 | 8 | 58 | 1 | |||
6301 | 183034 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2487 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989820.2795 | 2098485.3744 | 37.7414548799008 | -122.477814722118 | (37.7414548799008, -122.477814722118) | 1 | 8 | 3 | 29491 | 35 | |||
6309 | 235113 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200X Prospect Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 09:12:00 AM | 3 | 5x5 | 6006667 | 2098452 | 37.7423265745703 | -122.419562086696 | (37.7423265745703, -122.419562086696) | 2 | 7 | 7 | 28859 | 2 | ||
6382 | 141249 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996221.8744 | 2114302.1595 | 37.7852531650895 | -122.456824036395 | (37.7852531650895, -122.456824036395) | 11 | 6 | 1 | 54 | 31 | |||
6403 | 74567 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997978.88772 | 2116072.74607 | 37.7902154587146 | -122.450873051754 | (37.7902154587146, -122.450873051754) | 11 | 6 | 1 | 54 | 31 | |||
6426 | 36849 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
6444 | 262444 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003121 | 2094520 | 37.731329826937 | -122.43154242119 | (37.731329826937, -122.43154242119) | 9 | 7 | 5 | 28861 | 25 | ||
6457 | 95973 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6100 Geary Blvd | 2 | Median : | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 5988036.984 | 2112655.97284 | 37.7802598227503 | -122.485020077411 | (37.7802598227503, -122.485020077411) | 11 | 6 | 2 | 55 | 26 | |||
6480 | 167318 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 95 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6001726.73498 | 2105330.83934 | 37.7609347127879 | -122.437136385953 | (37.7609347127879, -122.437136385953) | 15 | 4 | 5 | 28862 | 3 | |||
6501 | 194992 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6016636.86174 | 2096261.76833 | 37.7368691785546 | -122.384936454554 | (37.7368691785546, -122.384936454554) | 10 | 3 | 8 | 58 | 1 | |||
6550 | 194776 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Flora St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013845.42665 | 2094215.08633 | 37.731094615529 | -122.394444484728 | (37.731094615529, -122.394444484728) | 10 | 3 | 8 | 58 | 1 | |||
6618 | 221977 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 49 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005317.72406 | 2104565.20901 | 37.7590359408747 | -122.424662252273 | (37.7590359408747, -122.424662252273) | 2 | 4 | 5 | 28859 | 19 | |||
6677 | 65895 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 126 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | 6 | Permit Number 28902 | 5995934.2793 | 2113524.40657 | 37.7831011454234 | -122.457762722955 | (37.7831011454234, -122.457762722955) | 11 | 6 | 1 | 54 | 31 | |
6692 | 170465 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 90 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003119.31929 | 2094475.31347 | 37.7312070325781 | -122.431545042679 | (37.7312070325781, -122.431545042679) | 9 | 7 | 5 | 28861 | 25 | |||
6721 | 73570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015400.1677 | 2094895.0317 | 37.7330479153498 | -122.389116887561 | (37.7330479153498, -122.389116887561) | 10 | 3 | 8 | 58 | 1 | |||
6723 | 9723 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 417X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005743.31768 | 2111673.49547 | 37.7785776240411 | -122.423695752999 | (37.7785776240411, -122.423695752999) | 7 | 9 | 11 | 28852 | 10 | |||
6765 | 133006 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2012 12:00:00 AM | 2 | Width 4ft | 6006263.75126 | 2111819.37774 | 37.7790075453106 | -122.421905736669 | (37.7790075453106, -122.421905736669) | 7 | 9 | 11 | 28852 | 10 | ||
6779 | 60387 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1436 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 15 | Permit Number 19967 | 6015759.6141 | 2094635.0651 | 37.7323540184412 | -122.387856042206 | (37.7323540184412, -122.387856042206) | 10 | 3 | 8 | 58 | 1 | |
6789 | 61141 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2139 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1983 12:00:00 AM | 13 | Permit Number 20994 | 5997586.9682 | 2110213.9805 | 37.7741063846604 | -122.451806229049 | (37.7741063846604, -122.451806229049) | 15 | 5 | 11 | 29492 | 16 | |
6811 | 36853 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
6821 | 61205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 156 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 11 | 3x3 | Permit Number 21073 | 6011187.02596 | 2095815.71279 | 37.7353414579279 | -122.403747670028 | (37.7353414579279, -122.403747670028) | 10 | 3 | 8 | 58 | 1 |
6838 | 256837 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1201x Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
6948 | 20199 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | 15 | 9 | 11 | 29490 | 41 | ||
6971 | 123476 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5995636.0481 | 2112739.28679 | 37.780928278722 | -122.458737616907 | (37.780928278722, -122.458737616907) | 11 | 6 | 2 | 54 | 16 | |||
7030 | 260467 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1 Masonic Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
7052 | 156880 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3435 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 2ft | 6006583.11261 | 2105511.47972 | 37.7617055639929 | -122.420353095823 | (37.7617055639929, -122.420353095823) | 2 | 4 | 7 | 28859 | 19 | ||
7082 | 30298 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2751 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | 10 | Permit Number 141 | 6003515.61648 | 2117821.35346 | 37.7953320858627 | -122.43184130454 | (37.7953320858627, -122.43184130454) | 13 | 9 | 1 | 29490 | 27 | ||
7098 | 59888 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 33 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 11 | Permit Number 19354 | 5998823.2054 | 2110908.8953 | 37.7760851682742 | -122.447579919008 | (37.7760851682742, -122.447579919008) | 15 | 6 | 2 | 29492 | 16 | |
7120 | 72080 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 267 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5993668.58228 | 2113717.95988 | 37.7835021698623 | -122.465615116031 | (37.7835021698623, -122.465615116031) | 11 | 6 | 2 | 54 | 11 | |||
7130 | 65543 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1990 12:00:00 AM | 10 | Permit Number 28440 | 5989563.27264 | 2114895.17103 | 37.7864968174229 | -122.479903908482 | (37.7864968174229, -122.479903908482) | 11 | 6 | 1 | 55 | 33 | ||
7149 | 199777 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1699 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016770.5961 | 2092171.5667 | 37.7256456912793 | -122.384189310378 | (37.7256456912793, -122.384189310378) | 10 | 3 | 8 | 58 | 1 | |||
7175 | 194622 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012020.07516 | 2112244.72696 | 37.780498408125 | -122.402022085964 | (37.780498408125, -122.402022085964) | 6 | 2 | 9 | 28856 | 34 | |||
7241 | 74720 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997978.29115 | 2116084.48817 | 37.7902476652453 | -122.450875962856 | (37.7902476652453, -122.450875962856) | 11 | 6 | 1 | 54 | 31 | |||
7261 | 235095 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 14X Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007348 | 2098046 | 37.7412501244927 | -122.417178627297 | (37.7412501244927, -122.417178627297) | 2 | 7 | 7 | 28859 | 2 | |||
7269 | 72440 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6012482 | 2109734 | 37.7736302975223 | -122.400247669168 | (37.7736302975223, -122.400247669168) | 14 | 2 | 9 | 28853 | 34 | ||
7293 | 73439 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5989929.90013 | 2113301.10199 | 37.7821412439294 | -122.478518869802 | (37.7821412439294, -122.478518869802) | 11 | 6 | 2 | 55 | 26 | |||
7304 | 259748 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1539 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015490.3402 | 2096517.67005 | 37.7375083497932 | -122.388918380926 | (37.7375083497932, -122.388918380926) | 10 | 3 | 8 | 58 | 1 | ||
7316 | 48431 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2465 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 3 | Permit Number 45808 | 6001216.64836 | 2118288.01098 | 37.7964828142888 | -122.439829564998 | (37.7964828142888, -122.439829564998) | 13 | 9 | 1 | 57 | 17 | |
7331 | 70585 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1810 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989837.8148 | 2113387.50989 | 37.782373149252 | -122.478843761706 | (37.782373149252, -122.478843761706) | 11 | 6 | 2 | 55 | 26 | |||
7367 | 262291 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
7387 | 235024 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 553 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1986 12:00:00 AM | 12 | Width 3ft | Permit Number 22676 | 6001208.88522 | 2103083.22142 | 37.754733850411 | -122.4387663334 | (37.754733850411, -122.4387663334) | 2 | 4 | 5 | 28862 | 22 | |
7419 | 9585 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1291 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2004 12:00:00 AM | 3 | 3X3 | 6003420.42274 | 2112074.32264 | 37.7795467977493 | -122.431760157134 | (37.7795467977493, -122.431760157134) | 15 | 9 | 11 | 29490 | 41 | ||
7471 | 96417 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2001 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | 3x3 | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||
7495 | 140886 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 0ft | 5996257.2395 | 2113438.3379 | 37.7828833718898 | -122.456639192431 | (37.7828833718898, -122.456639192431) | 11 | 6 | 1 | 54 | 31 | |||
7538 | 235025 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 547 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1986 12:00:00 AM | 12 | Width 3ft | Permit Number 22675 | 6001207.50589 | 2103104.68234 | 37.7547926984423 | -122.438772641251 | (37.7547926984423, -122.438772641251) | 2 | 4 | 5 | 28862 | 22 | |
7594 | 194986 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6016473.13756 | 2096210.02869 | 37.7367180546823 | -122.38549892205 | (37.7367180546823, -122.38549892205) | 10 | 3 | 8 | 58 | 1 | |||
7642 | 55353 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 599 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1972 12:00:00 AM | 12 | Permit Number 11286 | 5993748.41208 | 2113470.19668 | 37.7828264835108 | -122.465320934842 | (37.7828264835108, -122.465320934842) | 11 | 6 | 2 | 54 | 11 | ||
7656 | 41147 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1571 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41880 | 5998098.90766238 | 2108198.23177185 | 37.7686009624438 | -122.449890046711 | (37.7686009624438, -122.449890046711) | 15 | 5 | 11 | 29492 | 9 | ||
7666 | 261515 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 622 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 11:20:00 AM | Width 4ft | 5983216.44703 | 2111516.83265 | 37.7768501112803 | -122.501611967936 | (37.7768501112803, -122.501611967936) | 11 | 6 | 2 | 55 | 26 | |||
7670 | 211848 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 46 Stillings Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000230.33136 | 2095714.69025 | 37.7344459031469 | -122.441621669199 | (37.7344459031469, -122.441621669199) | 9 | 7 | 5 | 63 | 40 | |||
7680 | 259798 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 599x Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
7682 | 76663 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148X Paris St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002979.0601 | 2092519.08061 | 37.725827707182 | -122.431890313086 | (37.725827707182, -122.431890313086) | 9 | 7 | 6 | 28861 | 5 | ||
7707 | 55479 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 950 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1972 12:00:00 AM | 16 | Permit Number 11431 | 6002457.7556 | 2111793.5064 | 37.778721130856 | -122.435070340365 | (37.778721130856, -122.435070340365) | 15 | 5 | 11 | 29490 | 41 | |
7725 | 140230 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2101 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997640.5786 | 2110587.0709 | 37.7751338646154 | -122.45164770021 | (37.7751338646154, -122.45164770021) | 15 | 5 | 2 | 29492 | 16 | |||
7728 | 116230 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 49 Grace St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | 2.5x4 | Permit Number 770598 | 6008318.16403 | 2110322.45497 | 37.7750129977898 | -122.414692709823 | (37.7750129977898, -122.414692709823) | 8 | 2 | 9 | 28853 | 34 | |
7748 | 144911 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 638 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 3ft | 5990057.37145 | 2111010.22952 | 37.7758585430779 | -122.477910356093 | (37.7758585430779, -122.477910356093) | 11 | 6 | 2 | 55 | 26 | ||
7753 | 211631 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 605x Saint Francis Blvd | 2 | Median : Yard | Tree | DPW 1 | 21 | 5993552.90123 | 2096075.99565 | 37.7350552505067 | -122.464733785358 | (37.7350552505067, -122.464733785358) | 1 | 8 | 4 | 59 | 40 | ||||
7757 | 133120 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2031 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007676.88675 | 2119304.67898 | 37.7996399400933 | -122.417547774034 | (37.7996399400933, -122.417547774034) | 5 | 1 | 1 | 28858 | 32 | |||
7766 | 30822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | Permit Number 34679 | 6001848.24049432 | 2095191.22581593 | 37.7331006378237 | -122.435990589821 | (37.7331006378237, -122.435990589821) | 9 | 7 | 5 | 63 | 40 | |||
7767 | 262288 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
7790 | 178430 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 661 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6001092.95814 | 2089944.7413 | 37.7186520516399 | -122.438226080097 | (37.7186520516399, -122.438226080097) | 9 | 7 | 6 | 28861 | 5 | ||||
7814 | 194682 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Jack Balestreri Way | 22 | Front Yard : Yard | Tree | Private 2 | 8 | 6012380.91774 | 2104784.08259 | 37.7600332971117 | -122.400249606728 | (37.7600332971117, -122.400249606728) | 10 | 3 | 8 | 28856 | 29 | ||||
7820 | 194790 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013605.05122 | 2116340.26995 | 37.7918321555771 | -122.396826080181 | (37.7918321555771, -122.396826080181) | 12 | 2 | 9 | 28855 | 6 | |||
7823 | 19798 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY21 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
7824 | 139570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1161 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000814.0044 | 2112720.6298 | 37.781173302356 | -122.440823225006 | (37.781173302356, -122.440823225006) | 15 | 5 | 1 | 29490 | 41 | |||
7845 | 139459 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 818 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001028.7331 | 2111499.2655 | 37.7778319731371 | -122.439992770142 | (37.7778319731371, -122.439992770142) | 15 | 5 | 11 | 29490 | 41 | |||
7889 | 48963 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 525 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/2002 12:00:00 AM | 6 | Permit Number 46149 | 6002117.50475 | 2086471.68653 | 37.7091740273275 | -122.434436461075 | (37.7091740273275, -122.434436461075) | 9 | 7 | 6 | 28861 | 5 | |
7890 | 12638 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 917 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3 | 5992587.66451 | 2114789.03199 | 37.7863806345724 | -122.469432628996 | (37.7863806345724, -122.469432628996) | 11 | 6 | 2 | 54 | 11 | |||
7916 | 133157 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:39:00 PM | 3 | Width 4ft | 6010238.59911 | 2122044.66703 | 37.8073070787122 | -122.408876698811 | (37.8073070787122, -122.408876698811) | 3 | 1 | 10 | 308 | 23 | ||
7926 | 105855 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 4X Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006273.18234 | 2099962.59464 | 37.746452135478 | -122.421031022521 | (37.746452135478, -122.421031022521) | 2 | 7 | 7 | 28859 | 2 | ||||
7943 | 194966 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011517.79907 | 2112391.01147 | 37.7808720251553 | -122.403770001992 | (37.7808720251553, -122.403770001992) | 6 | 2 | 9 | 28853 | 34 | |||
8013 | 162581 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 109 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5995313.94103 | 2090657.06399 | 37.7202775429677 | -122.458253196048 | (37.7202775429677, -122.458253196048) | 9 | 8 | 6 | 28861 | 24 | |||
8014 | 72029 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2049 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007657.13445 | 2119469.15821 | 37.8000904473654 | -122.417627788486 | (37.8000904473654, -122.417627788486) | 5 | 1 | 1 | 28858 | 32 | |||
8157 | 8138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 919 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003262.67464 | 2111347.69223 | 37.7775427083406 | -122.432253966617 | (37.7775427083406, -122.432253966617) | 15 | 9 | 11 | 29492 | 10 | |||
8244 | 20067 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY54 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
8294 | 62825 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1489 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | 11 | Permit Number 23186 | 6002076.0916 | 2111528.467 | 37.777971720143 | -122.436371688889 | (37.777971720143, -122.436371688889) | 15 | 5 | 11 | 29492 | 41 | |
8322 | 50693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015899.29772 | 2115328.09963 | 37.7891803984034 | -122.388817224359 | (37.7891803984034, -122.388817224359) | 6 | 2 | 9 | 28855 | 6 | |
8334 | 258102 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 Woolsey St | 3 | Sidewalk: Curb side : | Tree | DPW 1 | 3 | 4x5 | 6010863.11329 | 2091931.53922 | 37.7246582312756 | -122.404594222384 | (37.7246582312756, -122.404594222384) | 10 | 3 | 7 | 309 | 28 | |||
8401 | 28903 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6011671.18393 | 2112073.93673 | 37.7800099791183 | -122.403217054727 | (37.7800099791183, -122.403217054727) | 14 | 2 | 9 | 28856 | 34 | ||
8410 | 194679 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 905 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011626.96976 | 2104120.55143 | 37.7581693181819 | -122.402810499115 | (37.7581693181819, -122.402810499115) | 10 | 3 | 8 | 28856 | 29 | |||
8422 | 18844 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2135 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1993 12:00:00 AM | 8 | 3x3 | 6004541.20002 | 2116043.53648 | 37.7905087357386 | -122.428165857165 | (37.7905087357386, -122.428165857165) | 13 | 9 | 1 | 28858 | 27 | ||
8423 | 37189 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1486 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 5 | Permit Number 43910 | 5986849.5211 | 2105147.3076 | 37.7595738887086 | -122.488575969719 | (37.7595738887086, -122.488575969719) | 1 | 8 | 3 | 56 | 35 | |
8453 | 132477 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2665 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005685.38019 | 2119478.18291 | 37.800004078292 | -122.424451466457 | (37.800004078292, -122.424451466457) | 13 | 9 | 1 | 57 | 17 | |||
8526 | 20030 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
8590 | 142524 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:52:00 PM | 20 | Width 0ft | 6009733.2838 | 2121208.6135 | 37.8049831671154 | -122.410566384357 | (37.8049831671154, -122.410566384357) | 3 | 1 | 10 | 308 | 23 | ||
8598 | 121137 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
8622 | 256682 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 8 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
8630 | 5179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1071X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6001831.363 | 2109760.4908 | 37.7731033917316 | -122.437091677951 | (37.7731033917316, -122.437091677951) | 15 | 5 | 11 | 29492 | 9 | |||
8706 | 50165 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 175 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47119 | 6010544.92166501 | 2111364.78189969 | 37.7779998423871 | -122.40706332103 | (37.7779998423871, -122.40706332103) | 14 | 2 | 9 | 28853 | 34 | |
8737 | 180668 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | 9 | 7 | 6 | 28861 | 5 | ||
8814 | 32024 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2700 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | 7 | Permit Number 35413 | 6001140.57553 | 2116929.9322 | 37.7927495548871 | -122.439995364902 | (37.7927495548871, -122.439995364902) | 13 | 6 | 1 | 29490 | 27 | ||
8888 | 211674 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 134 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785249 | 5994473.26175 | 2090798.24034 | 37.7206168355785 | -122.46116935389 | (37.7206168355785, -122.46116935389) | 9 | 8 | 6 | 28861 | 24 | |
8900 | 234194 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 375 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6003458.09568 | 2099493.1742 | 37.7450041256393 | -122.430731778545 | (37.7450041256393, -122.430731778545) | 2 | 7 | 5 | 63 | 22 | |||
8914 | 7995 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2250 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1992 12:00:00 AM | 12 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | ||
9119 | 18646 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 55 Reuel Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017250.7089795 | 2096167.8793556 | 37.7366453120483 | -122.382807560554 | (37.7366453120483, -122.382807560554) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );