trees
7,157 rows where qSpecies_id = 36 sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108194 | 21564 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1450 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | dead | 6005645.68769 | 2114853.19648 | 37.7873027884337 | -122.424259698627 | (37.7873027884337, -122.424259698627) | 13 | 9 | 1 | 28858 | 41 | ||
155070 | 93151 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 284X Funston Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Tree 5 on Funston. | 5991864.0342 | 2113562.75305 | 37.7829717659308 | -122.471846777677 | (37.7829717659308, -122.471846777677) | 11 | 6 | 2 | 54 | 11 | |||
19747 | 92977 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1741 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Tree 4 on Seymour St. | 6001670.119 | 2112142.3771 | 37.779634286354 | -122.437820070618 | (37.779634286354, -122.437820070618) | 15 | 5 | 11 | 29490 | 41 | |||
120665 | 92976 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1741 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Tree 3 on Seymour St. | 6001673.9808 | 2112126.93 | 37.7795920921164 | -122.437805604344 | (37.7795920921164, -122.437805604344) | 15 | 5 | 11 | 29490 | 41 | |||
21699 | 93149 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 284X Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Tree 3 on Funston. | 5991868.14141 | 2113524.63495 | 37.7828673417723 | -122.471829789625 | (37.7828673417723, -122.471829789625) | 11 | 6 | 2 | 54 | 11 | |||
111634 | 92975 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1741 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Tree 2 on Seymour St. | 6001675.9117 | 2112115.8273 | 37.7795617167054 | -122.437798129123 | (37.7795617167054, -122.437798129123) | 15 | 5 | 11 | 29490 | 41 | |||
89665 | 93148 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 284X Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x5 | Tree 2 on Funston. | 5991866.59303 | 2113502.9352 | 37.7828076706429 | -122.471833564338 | (37.7828076706429, -122.471833564338) | 11 | 6 | 2 | 54 | 11 | ||
182397 | 93147 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 284X Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Tree 1 on Funston. | 5991866.22681 | 2113485.5569 | 37.7827599334256 | -122.471833564358 | (37.7827599334256, -122.471833564358) | 11 | 6 | 2 | 54 | 11 | |||
19664 | 93051 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2010 12:00:00 AM | 3 | 3x3 | Planted for DPW by FUF | 6015509.3 | 2098161.9 | 37.7420241196322 | -122.388967590374 | (37.7420241196322, -122.388967590374) | 10 | 3 | 8 | 58 | 1 | |
44041 | 93052 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/2010 12:00:00 AM | 3 | 3x3 | Planted by FUF for BUF | 6015509.3 | 2098161.9 | 37.7420241196322 | -122.388967590374 | (37.7420241196322, -122.388967590374) | 10 | 3 | 8 | 58 | 1 | |
172710 | 54041 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2855 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 14 | Permit Number 9763 | 6001036.63383 | 2118177.80488 | 37.7961699689158 | -122.440444544776 | (37.7961699689158, -122.440444544776) | 13 | 9 | 1 | 57 | 17 | ||
71333 | 54040 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2815 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 13 | Permit Number 9762 | 6001043.48682 | 2118118.78953 | 37.7960083184722 | -122.440416597468 | (37.7960083184722, -122.440416597468) | 13 | 9 | 1 | 57 | 17 | ||
119562 | 54039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2813 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 11 | Permit Number 9761 | 6001046.84176 | 2118093.62628 | 37.7959394178222 | -122.440403183184 | (37.7959394178222, -122.440403183184) | 13 | 9 | 1 | 57 | 17 | ||
126174 | 53881 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2715 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/1972 12:00:00 AM | 21 | Permit Number 9592 | 5999588.3128 | 2113961.1528 | 37.7845095766598 | -122.445152707185 | (37.7845095766598, -122.445152707185) | 15 | 6 | 11 | 29490 | 31 | ||
69669 | 53822 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2865 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 11 | Permit Number 9519 | 6000482.39335 | 2116463.10454 | 37.7914302782425 | -122.442239169804 | (37.7914302782425, -122.442239169804) | 13 | 6 | 1 | 29490 | 27 | ||
62622 | 30446 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 357 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 95 | 6011194.45133 | 2119670.62732 | 37.8008420431764 | -122.405401443236 | (37.8008420431764, -122.405401443236) | 3 | 1 | 10 | 308 | 23 | ||
191346 | 30439 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 387 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 15 | Permit Number 92 | 6011071.27916 | 2119657.83609 | 37.8008000340602 | -122.405826771312 | (37.8008000340602, -122.405826771312) | 3 | 1 | 10 | 308 | 23 | ||
150937 | 30438 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 324 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 15 | Permit Number 91 | 6011339.87851 | 2119740.52253 | 37.8010420883794 | -122.404903125306 | (37.8010420883794, -122.404903125306) | 3 | 1 | 10 | 308 | 23 | ||
148320 | 30434 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 312 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 20 | Permit Number 87 | 6011372.10185 | 2119743.57684 | 37.8010522759047 | -122.404791833276 | (37.8010522759047, -122.404791833276) | 3 | 1 | 10 | 308 | 23 | ||
19887 | 30431 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 255 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 9 | Permit Number 84 | 6010587.196 | 2120972.0532 | 37.8043814669615 | -122.407594621587 | (37.8043814669615, -122.407594621587) | 3 | 1 | 10 | 308 | 23 | ||
97586 | 30428 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 434 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 13 | 7x3 | Permit Number 82 | 6010847.2664 | 2119670.2518 | 37.8008215943087 | -122.406602828336 | (37.8008215943087, -122.406602828336) | 3 | 1 | 10 | 308 | 23 | |
194450 | 234943 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 4339 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 788007 | 6001670.90597 | 2100562.91239 | 37.7478399578525 | -122.436988118323 | (37.7478399578525, -122.436988118323) | 2 | 4 | 5 | 63 | 22 | ||
194459 | 248440 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 724 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Permit Number 788001 | 5997627.8337 | 2107978.5557 | 37.7679708233346 | -122.451503597918 | (37.7679708233346, -122.451503597918) | 15 | 5 | 11 | 29492 | 9 | ||
194262 | 262537 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | ||||
592 | 211675 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785250 | 5994473.3982 | 2090822.99818 | 37.7206848225258 | -122.461170675896 | (37.7206848225258, -122.461170675896) | 9 | 8 | 6 | 28861 | 24 | |
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 | |
194263 | 15782 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/2015 12:38:00 PM | 3 | 3X3 | Permit Number 785142 | 6001159.6334 | 2090631.0194 | 37.7205402088092 | -122.438044743528 | (37.7205402088092, -122.438044743528) | 9 | 7 | 6 | 28861 | 25 | |
194268 | 15788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2020 12:00:00 AM | 12 | 3X3 | Permit Number 785142 | 6001054.6013 | 2090473.5841 | 37.7201019532463 | -122.438396531841 | (37.7201019532463, -122.438396531841) | 9 | 7 | 6 | 28861 | 25 | |
194271 | 15783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 03:01:00 PM | 3 | 3X3 | Permit Number 785142 | 6001146.6106 | 2090614.741 | 37.7204947713768 | -122.43808859365 | (37.7204947713768, -122.43808859365) | 9 | 7 | 6 | 28861 | 25 | |
11127 | 234129 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 30 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784531 | 6005403.94341 | 2104612.96948 | 37.7591719489519 | -122.424367461684 | (37.7591719489519, -122.424367461684) | 2 | 4 | 5 | 28859 | 19 | |
30656 | 256908 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 751 25th Ave | : | Tree | Private 2 | FUF | 01/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782750 | 5988160.57678 | 2110864.58172 | 37.7753483638678 | -122.484461088261 | (37.7753483638678, -122.484461088261) | 11 | 6 | 2 | 55 | 26 | |
48115 | 256907 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 751 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782750 | 5988160.57678 | 2110864.58172 | 37.7753483638678 | -122.484461088261 | (37.7753483638678, -122.484461088261) | 11 | 6 | 2 | 55 | 26 | |
14774 | 15553 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2847 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2018 12:00:00 AM | 3 | 4X4 | Permit Number 781883 | 6007107.4417 | 2101776.5099 | 37.7514797285918 | -122.418274826958 | (37.7514797285918, -122.418274826958) | 2 | 4 | 7 | 28859 | 19 | |
101666 | 127182 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2011 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781749 | 5999884.37822 | 2115873.98153 | 37.7897786004407 | -122.444265930542 | (37.7897786004407, -122.444265930542) | 13 | 6 | 1 | 29490 | 27 | |
160537 | 205150 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 250 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781736 | 5994962.18094 | 2106723.12455 | 37.764370728241 | -122.4606327428 | (37.764370728241, -122.4606327428) | 15 | 5 | 11 | 56 | 12 | |
155396 | 1522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 422 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2013 12:00:00 AM | 3 | 3X3 | Permit Number 781664 | 5995605.60631 | 2113581.85062 | 37.7832399843175 | -122.458903950762 | (37.7832399843175, -122.458903950762) | 11 | 6 | 1 | 54 | 31 | |
177913 | 1592 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | Permit Number 781663 | 5995684.42266 | 2111472.80477 | 37.7774536354298 | -122.458478563446 | (37.7774536354298, -122.458478563446) | 11 | 6 | 2 | 54 | 16 | ||
49267 | 2675 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2059 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2018 12:00:00 AM | 3 | 4X4 | Permit Number 781507 | 6003660.5178 | 2114875.7424 | 37.7872524011428 | -122.431129574605 | (37.7872524011428, -122.431129574605) | 13 | 9 | 11 | 29490 | 27 | |
57136 | 254420 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1232 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781394 | 5991448.19583 | 2107029.01028 | 37.765007814143 | -122.472808824857 | (37.765007814143, -122.472808824857) | 11 | 8 | 11 | 56 | 12 |
78022 | 104755 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 781111 | 5998481.68854 | 2116256.67872 | 37.7907492594091 | -122.449146662803 | (37.7907492594091, -122.449146662803) | 13 | 6 | 1 | 54 | 31 | ||
188866 | 104754 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781111 | 5998483.43829 | 2116249.0389 | 37.7907283825673 | -122.449140058165 | (37.7907283825673, -122.449140058165) | 13 | 6 | 1 | 54 | 31 | |
13744 | 240879 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3659 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780848 | 6005174.01235 | 2105435.79092 | 37.7614182359708 | -122.425221224092 | (37.7614182359708, -122.425221224092) | 2 | 4 | 5 | 28859 | 19 | |
37766 | 150676 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 548 Rhode Island St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.98399 | 2105812.52377 | 37.7628222449765 | -122.402486741392 | (37.7628222449765, -122.402486741392) | 8 | 3 | 8 | 28856 | 29 | |
50450 | 27604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003185.1314 | 2111389.5656 | 37.7776532852192 | -122.43252520607 | (37.7776532852192, -122.43252520607) | 15 | 9 | 11 | 29492 | 41 | |
56063 | 27606 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003145.1713 | 2111385.063 | 37.7776386560762 | -122.432663119808 | (37.7776386560762, -122.432663119808) | 15 | 9 | 11 | 29492 | 41 | |
125729 | 27601 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003246.4786 | 2111399.6963 | 37.7776845802664 | -122.432313709128 | (37.7776845802664, -122.432313709128) | 15 | 9 | 11 | 29492 | 41 | |
34077 | 256492 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 280 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780675 | 6001741.51076 | 2104267.16046 | 37.7580149486389 | -122.437009129166 | (37.7580149486389, -122.437009129166) | 2 | 4 | 5 | 28862 | 3 | |
38312 | 167082 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 280 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780675 | 6001741.51076 | 2104267.16046 | 37.7580149486389 | -122.437009129166 | (37.7580149486389, -122.437009129166) | 2 | 4 | 5 | 28862 | 3 | |
4820 | 253072 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 6x10 | Permit Number 780489 | 5981849.66657 | 2105897.22193 | 37.7613399178539 | -122.50592325662 | (37.7613399178539, -122.50592325662) | 1 | 8 | 3 | 56 | 35 | |
48746 | 100153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.466099823613 | (37.7773444498569, -122.466099823613) | 11 | 6 | 2 | 54 | 11 | |||
189637 | 123240 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | Permit Number 780398 | 5993479.44876 | 2111515.72827 | 37.777444527227 | -122.466109353825 | (37.777444527227, -122.466109353825) | 11 | 6 | 2 | 54 | 11 | ||
104239 | 251429 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779991 | 6003307 | 2100429 | 37.7475651236724 | -122.431321029201 | (37.7475651236724, -122.431321029201) | 2 | 4 | 5 | 63 | 22 | |
4265 | 129451 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1147 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779607 | 6007395.89235 | 2119499.90916 | 37.8001601781003 | -122.418533970572 | (37.8001601781003, -122.418533970572) | 5 | 1 | 1 | 28858 | 32 |
16037 | 135812 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1147 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 779607 | 6007418.27175 | 2119501.50723 | 37.8001658258642 | -122.418456642358 | (37.8001658258642, -122.418456642358) | 5 | 1 | 1 | 28858 | 32 | ||
179761 | 160920 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 666 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779533 | 6002104.11317 | 2090113.36167 | 37.7191725036747 | -122.434742983299 | (37.7191725036747, -122.434742983299) | 9 | 7 | 6 | 28861 | 5 | |
77555 | 232299 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 108 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779438 | 6005119.98151 | 2099339.98705 | 37.7446775233394 | -122.424974374591 | (37.7446775233394, -122.424974374591) | 2 | 7 | 5 | 63 | 22 | |
106854 | 251131 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 354 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875 | 2111882 | 37.7794943458843 | -122.402498458881 | (37.7794943458843, -122.402498458881) | 14 | 2 | 9 | 28856 | 34 | |
189387 | 251132 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 354 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875 | 2111882 | 37.7794943458843 | -122.402498458881 | (37.7794943458843, -122.402498458881) | 14 | 2 | 9 | 28856 | 34 | |
161137 | 92967 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3022 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779165 | 6000091.47375 | 2115801.73595 | 37.7895920459934 | -122.443544210206 | (37.7895920459934, -122.443544210206) | 13 | 6 | 1 | 29490 | 27 | |
163376 | 253126 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 182 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779117 | 6002742.73008 | 2092646.20381 | 37.7261633586637 | -122.432716365158 | (37.7261633586637, -122.432716365158) | 9 | 7 | 6 | 28861 | 5 | ||
52723 | 7976 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2007 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 4X4 | Permit Number 779097 | 6005561.28008 | 2117067.6166 | 37.793378265541 | -122.424709321884 | (37.793378265541, -122.424709321884) | 13 | 9 | 1 | 28858 | 27 | |
12611 | 121264 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3053 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778943 | 5996367 | 2111408 | 37.7773149020317 | -122.456112630584 | (37.7773149020317, -122.456112630584) | 11 | 6 | 2 | 54 | 16 | |||
162812 | 121265 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3053 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778943 | 5996367 | 2111408 | 37.7773149020317 | -122.456112630584 | (37.7773149020317, -122.456112630584) | 11 | 6 | 2 | 54 | 16 | |||
119324 | 253343 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 200 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | Permit Number 778434 | 5995550.18022 | 2114806.2223 | 37.7865985940285 | -122.459184390305 | (37.7865985940285, -122.459184390305) | 11 | 6 | 1 | 54 | 31 | |||
184490 | 253342 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | Permit Number 778434 | 5995550.18022 | 2114806.2223 | 37.7865985940285 | -122.459184390305 | (37.7865985940285, -122.459184390305) | 11 | 6 | 1 | 54 | 31 | |||
148640 | 57347 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 4006 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1976 12:00:00 AM | 20 | Permit Number 778373 | 6001804.25600707 | 2102958.17712895 | 37.7544243620634 | -122.436698432015 | (37.7544243620634, -122.436698432015) | 2 | 4 | 5 | 28862 | 22 | ||
139856 | 49914 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2140 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778261 | 6008088.06345917 | 2105963.11156728 | 37.7630303308354 | -122.415180031733 | (37.7630303308354, -122.415180031733) | 8 | 4 | 7 | 28859 | 19 | |
146339 | 49915 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2140 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778261 | 6008088.06345917 | 2105963.11156728 | 37.7630303308354 | -122.415180031733 | (37.7630303308354, -122.415180031733) | 8 | 4 | 7 | 28859 | 19 | |
117732 | 254359 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 41 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778173 | 6012132.40915 | 2088469.86278 | 37.7152240259545 | -122.399963419046 | (37.7152240259545, -122.399963419046) | 10 | 7 | 8 | 309 | 39 |
115980 | 50493 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 639 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778052 | 6002442.45455321 | 2090054.61865068 | 37.7190304113329 | -122.43356927156 | (37.7190304113329, -122.43356927156) | 9 | 7 | 6 | 28861 | 5 | |
77889 | 4254 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4079 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777901 | 6003404.0668529 | 2100364.8685588 | 37.7473945342564 | -122.430980801713 | (37.7473945342564, -122.430980801713) | 2 | 4 | 5 | 63 | 22 | |
135156 | 116178 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 94X Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2x2 | Permit Number 777858 | 6013051.68778 | 2114735.35229 | 37.7873946119181 | -122.39862805626 | (37.7873946119181, -122.39862805626) | 12 | 2 | 9 | 28855 | 6 | ||
2804 | 115921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777610 | 6013791.45387 | 2116146.74475 | 37.7913111540478 | -122.396167553395 | (37.7913111540478, -122.396167553395) | 12 | 2 | 9 | 28855 | 6 | |
81103 | 156905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
105170 | 252909 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
176471 | 252908 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
176658 | 252906 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
178976 | 252905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
36893 | 152811 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009988.15821 | 2101607.87857 | 37.7511784382559 | -122.40830102207 | (37.7511784382559, -122.40830102207) | 2 | 4 | 7 | 28859 | 19 | |
46028 | 152812 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6010002.42353 | 2101608.75594 | 37.7511816461268 | -122.408251752714 | (37.7511816461268, -122.408251752714) | 2 | 4 | 7 | 28859 | 19 | |
134654 | 152810 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.7511779795992 | -122.408352609887 | (37.7511779795992, -122.408352609887) | 2 | 4 | 7 | 28859 | 19 | |
109201 | 56400 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 203 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 12 | Permit Number 776836 | 5992106.73149 | 2114059.68671 | 37.7843502487637 | -122.471043366703 | (37.7843502487637, -122.471043366703) | 11 | 6 | 2 | 54 | 11 | ||
164047 | 15420 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2090 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3 | 4x4 | Permit Number 776475 | 6006807.3195 | 2106193.613 | 37.7635911742402 | -122.419626052426 | (37.7635911742402, -122.419626052426) | 8 | 4 | 7 | 28859 | 19 | |
135398 | 117444 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1133 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776191 | 6004090.20732 | 2089350.17003 | 37.7171895030573 | -122.427823460996 | (37.7171895030573, -122.427823460996) | 9 | 7 | 6 | 28861 | 5 | ||
100024 | 258333 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 215X Raccoon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/29/2019 12:00:00 AM | 3 | 3X3 | Permit Number 776074 | |||||||||||
172077 | 258332 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 215X Raccoon Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/29/2019 12:00:00 AM | 3 | 3X3 | Permit Number 776074 | |||||||||||
110183 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 561X Folsom St | 1 | Front Yard : Yard | Tree | Private 2 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.90646 | 37.7859605214302 | -122.396175324952 | (37.7859605214302, -122.396175324952) | 6 | 2 | 9 | 28856 | 6 | |
158786 | 34676 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2000 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2015 12:00:00 AM | 3 | Permit Number 775668 | 6003314.31901 | 2118972.51824 | 37.7984814738846 | -122.432620094941 | (37.7984814738846, -122.432620094941) | 13 | 9 | 1 | 57 | 17 | |
188396 | 93150 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 284X Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2015 12:00:00 AM | 3 | Permit Number 775609 | 5991864.69021 | 2113542.09367 | 37.7829150789203 | -122.471843002028 | (37.7829150789203, -122.471843002028) | 11 | 6 | 2 | 54 | 11 | ||
150250 | 110301 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3727 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775502 | 6003051.71719 | 2121145.37774 | 37.8044326826855 | -122.4336841548 | (37.8044326826855, -122.4336841548) | 13 | 9 | 1 | 57 | 17 | |
130412 | 107618 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 599x CHINA BASIN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775477 | 6015291 | 2109063 | 37.7719441112286 | -122.390483933976 | (37.7719441112286, -122.390483933976) | 14 | 3 | 9 | 310 | 20 | |
131027 | 107614 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 599x CHINA BASIN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775477 | 6015291 | 2109063 | 37.7719441112286 | -122.390483933976 | (37.7719441112286, -122.390483933976) | 14 | 3 | 9 | 310 | 20 | |
177538 | 107613 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 599x CHINA BASIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775477 | 6015291 | 2109063 | 37.7719441112286 | -122.390483933976 | (37.7719441112286, -122.390483933976) | 14 | 3 | 9 | 310 | 20 | |
89570 | 115232 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775420 | 5985904.5 | 2112316.6 | 37.7792035589465 | -122.49237222008 | (37.7792035589465, -122.49237222008) | 11 | 6 | 2 | 55 | 26 | |||
137450 | 99107 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1766 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | 3x3 | Permit Number 775193 | 6001658.68735 | 2121105.16624 | 37.8042431316708 | -122.438501963298 | (37.8042431316708, -122.438501963298) | 13 | 9 | 1 | 57 | 17 | |
106027 | 69186 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2459 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 775037 | 6003656.25511506 | 2116791.97327804 | 37.7925136429048 | -122.431281157687 | (37.7925136429048, -122.431281157687) | 13 | 9 | 1 | 29490 | 27 | |||
136337 | 59894 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 912 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 9x6 | Permit Number 775027 | 6009913.676206 | 2103880.39060941 | 37.75741407817 | -122.408718893172 | (37.75741407817, -122.408718893172) | 2 | 4 | 7 | 28859 | 19 | |
62113 | 114560 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1513 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 775026 | 6000098.8 | 2114218 | 37.7852439369624 | -122.443405056634 | (37.7852439369624, -122.443405056634) | 15 | 6 | 1 | 29490 | 31 | |||
119423 | 114977 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 183 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 774982 | 5996484.3 | 2091092.2 | 37.7215395068839 | -122.454239087603 | (37.7215395068839, -122.454239087603) | 9 | 8 | 6 | 28861 | 24 | |||
12632 | 67562 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1165 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 774855 | 6011714 | 2102959 | 37.7549848131441 | -122.402427835541 | (37.7549848131441, -122.402427835541) | 10 | 3 | 8 | 28856 | 29 |
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) );