trees
7,157 rows where qSpecies_id = 36 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66 | 132469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3135 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
412 | 121036 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1830 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006566 | 2117108 | 37.7935458417616 | -122.421235781398 | (37.7935458417616, -122.421235781398) | 13 | 9 | 10 | 28858 | 32 | ||||
781 | 98761 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.433167654376 | (37.8041696588781, -122.433167654376) | 13 | 9 | 1 | 57 | 17 | |||
817 | 132762 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.53227 | 2121230.80772 | 37.8046665028104 | -122.43373589191 | (37.8046665028104, -122.43373589191) | 13 | 9 | 1 | 57 | 17 | |||
877 | 140007 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005073.8071 | 2111650.2628 | 37.778476017163 | -122.426010193621 | (37.778476017163, -122.426010193621) | 7 | 9 | 11 | 28852 | 41 | |||
935 | 132500 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2512 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000920.49838 | 2118292.02212 | 37.796476965998 | -122.440854593363 | (37.796476965998, -122.440854593363) | 13 | 9 | 1 | 57 | 17 | |||
978 | 8142 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.7777073047982 | -122.432059137251 | (37.7777073047982, -122.432059137251) | 15 | 9 | 11 | 29492 | 41 | |||
1018 | 41589 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2601 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | 4 | Permit Number 770702 | 6001047.66976 | 2117208.8358 | 37.7935100620898 | -122.440336832983 | (37.7935100620898, -122.440336832983) | 13 | 9 | 1 | 29490 | 27 | ||
1167 | 33310 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1549 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37457 | 6005491.84423 | 2119228.52143 | 37.7993076406048 | -122.425103401209 | (37.7993076406048, -122.425103401209) | 13 | 9 | 1 | 57 | 17 | |
1362 | 244521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 577 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003849.83 | 2109698.0755 | 37.7730465408764 | -122.430105090767 | (37.7730465408764, -122.430105090767) | 7 | 9 | 11 | 29492 | 10 | |||
1379 | 19129 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Sanchez St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2009 12:00:00 AM | 3 | 3X4 | 6003497.27744 | 2108239.16815 | 37.7690207646335 | -122.431220458483 | (37.7690207646335, -122.431220458483) | 7 | 9 | 5 | 28862 | 3 | ||
1436 | 256792 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 120 Cedar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006815 | 2114489 | 37.7863687502832 | -122.420188259313 | (37.7863687502832, -122.420188259313) | 13 | 9 | 10 | 28858 | 36 | ||||
1521 | 244457 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003333.6569 | 2109668.6973 | 37.7729366277203 | -122.43188849891 | (37.7729366277203, -122.43188849891) | 15 | 9 | 11 | 29492 | 10 | |||
1900 | 141936 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1101 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 10/12/1994 12:00:00 AM | 8 | Width 0ft | 6003954.1428 | 2112136.7195 | 37.7797483635991 | -122.429918243479 | (37.7797483635991, -122.429918243479) | 7 | 9 | 11 | 29490 | 41 | ||
1990 | 132531 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2201 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000159.7629 | 2120220.59264 | 37.8017289527983 | -122.443625508009 | (37.8017289527983, -122.443625508009) | 13 | 9 | 1 | 57 | 17 | |||
2038 | 8035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005070.3181 | 2111601.5224 | 37.7783419907871 | -122.426018792814 | (37.7783419907871, -122.426018792814) | 7 | 9 | 11 | 28852 | 10 | |||
2062 | 112894 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1x WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004219 | 2108568 | 37.7699645303419 | -122.428747509741 | (37.7699645303419, -122.428747509741) | 7 | 9 | 5 | 28862 | 10 | ||||
2077 | 2574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1660 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 10:41:00 AM | 3 | 4x4 | 6005572.29299 | 2115192.6753 | 37.788230768278 | -122.424537786114 | (37.788230768278, -122.424537786114) | 13 | 9 | 1 | 28858 | 41 | ||
2104 | 132472 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001487.88028 | 2118402.43157 | 37.7968124185064 | -122.438899249622 | (37.7968124185064, -122.438899249622) | 13 | 9 | 1 | 57 | 17 | |||
2208 | 8032 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | |||
2350 | 132920 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2311 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002441.57111 | 2117401.95011 | 37.7941195695148 | -122.435527653476 | (37.7941195695148, -122.435527653476) | 13 | 9 | 1 | 29490 | 27 | |||
2465 | 133092 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | Width 3ft | 6006306.20218 | 2119734.15962 | 37.800741963924 | -122.422321379938 | (37.800741963924, -122.422321379938) | 13 | 9 | 1 | 28858 | 32 | ||
2517 | 20187 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1225 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6002803.937717 | 2112440.9213574 | 37.7805184210702 | -122.433919051618 | (37.7805184210702, -122.433919051618) | 15 | 9 | 11 | 29490 | 41 | |||
2593 | 19154 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 64 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774356 | 6003450.27402 | 2107953.58185 | 37.7682339504649 | -122.431362651168 | (37.7682339504649, -122.431362651168) | 15 | 9 | 5 | 28862 | 3 | |
2659 | 122325 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1310 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006613.81531 | 2119776.94391 | 37.8008767857834 | -122.421259948789 | (37.8008767857834, -122.421259948789) | 13 | 9 | 1 | 28858 | 32 | |||
2789 | 8033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005024.9178 | 2111594.5788 | 37.7783203593831 | -122.426175354969 | (37.7783203593831, -122.426175354969) | 7 | 9 | 11 | 28852 | 10 | |||
3104 | 71279 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2922 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004338.76046 | 2119216.84729 | 37.7992103816196 | -122.429092640025 | (37.7992103816196, -122.429092640025) | 13 | 9 | 1 | 57 | 17 | |||
3179 | 8036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005091.683 | 2111605.7953 | 37.7783549305744 | -122.425945187873 | (37.7783549305744, -122.425945187873) | 7 | 9 | 11 | 28852 | 10 | |||
3629 | 140363 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1750 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002930.8274 | 2113434.8001 | 37.7832545622139 | -122.433551128922 | (37.7832545622139, -122.433551128922) | 13 | 9 | 11 | 29490 | 41 | |||
3749 | 133080 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1323 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006658.05063 | 2119385.33071 | 37.7998040088165 | -122.421079053765 | (37.7998040088165, -122.421079053765) | 13 | 9 | 1 | 28858 | 32 | |||
3751 | 132937 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2459 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003649.5548 | 2116872.9582 | 37.7927356271009 | -122.431310124485 | (37.7927356271009, -122.431310124485) | 13 | 9 | 1 | 29490 | 27 | |||
3793 | 66047 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 465 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1990 12:00:00 AM | 9 | Permit Number 29210 | 6001137.14728 | 2121594.78406 | 37.8055578110078 | -122.440341924044 | (37.8055578110078, -122.440341924044) | 13 | 9 | 1 | 57 | 17 | |
3878 | 14819 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | 15 | 9 | 11 | 29490 | 41 | |||
3901 | 8039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005222.0085 | 2111622.3531 | 37.778407758667 | -122.425495521768 | (37.778407758667, -122.425495521768) | 7 | 9 | 11 | 28852 | 10 | |||
4282 | 64889 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50994 | 6006338.45294 | 2119739.76181 | 37.8007591652634 | -122.422210176984 | (37.8007591652634, -122.422210176984) | 13 | 9 | 1 | 28858 | 32 | |
4383 | 132545 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1990 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000779.58513 | 2120984.3589 | 37.8038613820664 | -122.441535482685 | (37.8038613820664, -122.441535482685) | 13 | 9 | 1 | 57 | 17 | |||
4552 | 250073 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1599X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083 | 2115238 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | 13 | 9 | 1 | 28858 | 41 | |
4721 | 44169 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2100 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | Permit Number 43638 | 6003503.99505303 | 2117958.62597334 | 37.795708342081 | -122.431891323133 | (37.795708342081, -122.431891323133) | 13 | 9 | 1 | 57 | 17 | |||
4744 | 116025 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1425 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 3x3 | 6006694.6941 | 2118351.37216 | 37.796967084814 | -122.420878805335 | (37.796967084814, -122.420878805335) | 13 | 9 | 10 | 28858 | 32 | ||
4753 | 137893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1700 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005266.7921 | 2115153.1008 | 37.7881048492405 | -122.425591951126 | (37.7881048492405, -122.425591951126) | 13 | 9 | 11 | 28858 | 27 | |||
4798 | 138995 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 611 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003540 | 2110455 | 37.7751073166065 | -122.431230870083 | (37.7751073166065, -122.431230870083) | 15 | 9 | 11 | 29492 | 10 | |||
5127 | 261795 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | ||||
5197 | 132921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2307 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002461.11828 | 2117406.23377 | 37.7941324415101 | -122.435460324857 | (37.7941324415101, -122.435460324857) | 13 | 9 | 1 | 29490 | 27 | |||
5329 | 8038 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 12 | 3X3 | 6005189.4271 | 2111616.4778 | 37.7783897855843 | -122.425607814865 | (37.7783897855843, -122.425607814865) | 7 | 9 | 11 | 28852 | 10 | ||
5457 | 138379 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2000 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002976.0662 | 2114481.5252 | 37.7861311714309 | -122.433469446582 | (37.7861311714309, -122.433469446582) | 13 | 9 | 11 | 29490 | 27 | |||
5524 | 13219 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2233 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001693 | 2119338 | 37.7993929119919 | -122.438256546601 | (37.7993929119919, -122.438256546601) | 13 | 9 | 1 | 57 | 17 | ||
5595 | 138084 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003830.6412 | 2114896.4777 | 37.7873189738892 | -122.430542464211 | (37.7873189738892, -122.430542464211) | 13 | 9 | 11 | 29490 | 27 | |||
5618 | 137892 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005288.3833 | 2115155.435 | 37.7881124783388 | -122.425517415448 | (37.7881124783388, -122.425517415448) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
9407 | 51009 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2502 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | 6 | Permit Number 47486 | 6002662.86161 | 2116482.89118 | 37.7916086362759 | -122.434696214977 | (37.7916086362759, -122.434696214977) | 13 | 9 | 1 | 29490 | 27 | ||
9523 | 132919 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2311 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002415.78178 | 2117399.35825 | 37.7941109881849 | -122.435616701668 | (37.7941109881849, -122.435616701668) | 13 | 9 | 1 | 29490 | 27 | |||
9653 | 247307 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 311 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003219.2087 | 2109482.81 | 37.7724197383315 | -122.432271110524 | (37.7724197383315, -122.432271110524) | 15 | 9 | 11 | 29492 | 9 | |||
9769 | 72164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004416.60562 | 2120115.89629 | 37.8016833445826 | -122.42888739946 | (37.8016833445826, -122.42888739946) | 13 | 9 | 1 | 57 | 17 | |||
10380 | 5959 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1499X Eddy St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 6 | 3X3 | 6003487.34677 | 2112767.17991 | 37.7814530042955 | -122.431578116755 | (37.7814530042955, -122.431578116755) | 15 | 9 | 11 | 29490 | 41 | ||
10596 | 98772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003427.71574 | 2121076.45183 | 37.804264757687 | -122.432378054112 | (37.804264757687, -122.432378054112) | 13 | 9 | 1 | 57 | 17 | |||
10625 | 8037 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 6 | 3X3 | 6005159.5163 | 2111612.2048 | 37.7783763628277 | -122.425710983373 | (37.7783763628277, -122.425710983373) | 7 | 9 | 11 | 28852 | 10 | ||
10825 | 133096 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1069 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006198.01577 | 2120713.57476 | 37.8034250849665 | -122.422765393206 | (37.8034250849665, -122.422765393206) | 5 | 9 | 1 | 28858 | 32 | |||
10842 | 7846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 885 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1997 12:00:00 AM | 3 | 4X4 | 6006112.07352 | 2113078.82451 | 37.7824571234444 | -122.422519969114 | (37.7824571234444, -122.422519969114) | 7 | 9 | 11 | 28852 | 41 | ||
10992 | 98625 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002285.2374 | 2120040.843 | 37.8013564005351 | -122.43625752619 | (37.8013564005351, -122.43625752619) | 13 | 9 | 1 | 57 | 17 | ||
11146 | 246588 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 68 Waller St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6005380.13328 | 2109258.65002 | 37.7719265371042 | -122.42478030806 | (37.7719265371042, -122.42478030806) | 7 | 9 | 11 | 28852 | 10 | |||
11400 | 65756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2902 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 12 | Permit Number 28719 | 6004350.14123 | 2119136.9474 | 37.7989916413017 | -122.429047558797 | (37.7989916413017, -122.429047558797) | 13 | 9 | 1 | 57 | 17 | |
11460 | 63576 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1338 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 15 | Permit Number 24199 | 6006572.91263 | 2119424.6078 | 37.7999070540349 | -122.421376454187 | (37.7999070540349, -122.421376454187) | 13 | 9 | 1 | 28858 | 32 | |
11570 | 66036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3737 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 7 | Permit Number 29073 | 6000613.44807 | 2121211.22675 | 37.8044748339084 | -122.442126703295 | (37.8044748339084, -122.442126703295) | 13 | 9 | 1 | 57 | 17 | ||
11780 | 73541 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1944 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003405.1717 | 2115462.6704 | 37.7888494837108 | -122.432054945508 | (37.7888494837108, -122.432054945508) | 13 | 9 | 1 | 29490 | 27 | |||
12176 | 8052 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 604 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | |||
12425 | 132893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2625 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001143.29931 | 2117400.39133 | 37.7940414678908 | -122.440019689778 | (37.7940414678908, -122.440019689778) | 13 | 9 | 1 | 57 | 27 | |||
12466 | 16906 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 444 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004850.54878 | 2110241.10729 | 37.774594200606 | -122.426682154766 | (37.774594200606, -122.426682154766) | 7 | 9 | 11 | 28852 | 10 | |||
12523 | 132728 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2659 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6000218.30691 | 2118493.83649 | 37.7969910787183 | -122.443298822996 | (37.7969910787183, -122.443298822996) | 13 | 9 | 1 | 57 | 17 | |||
12768 | 5972 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.433110458849 | (37.7813844410266, -122.433110458849) | 15 | 9 | 11 | 29490 | 41 | ||
13073 | 16756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1432X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6002754.8302515 | 2113154.9795466 | 37.7824762583226 | -122.434139998025 | (37.7824762583226, -122.434139998025) | 15 | 9 | 11 | 29490 | 41 | |||
13178 | 132505 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2610 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | Width 3ft | 6000427.78493 | 2118570.10742 | 37.7972124414658 | -122.442579459794 | (37.7972124414658, -122.442579459794) | 13 | 9 | 1 | 57 | 17 | ||
13479 | 244472 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 350 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003253.411 | 2109566.7633 | 37.7726521926592 | -122.432158798069 | (37.7726521926592, -122.432158798069) | 15 | 9 | 11 | 29492 | 10 | |||
13503 | 8051 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 601X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 12 | 3x3 | 6004844.36674 | 2111570.09006 | 37.7782429126773 | -122.426798203905 | (37.7782429126773, -122.426798203905) | 7 | 9 | 11 | 28852 | 10 | ||
13684 | 244955 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 281 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005255.613 | 2109889.914 | 37.7736528015152 | -122.425255960871 | (37.7736528015152, -122.425255960871) | 7 | 9 | 11 | 28852 | 10 | |||
13888 | 8055 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 612 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1990 12:00:00 AM | 8 | 3X3 | 6004743.4186 | 2111609.3148 | 37.7783449060882 | -122.427150215382 | (37.7783449060882, -122.427150215382) | 7 | 9 | 11 | 28852 | 41 | ||
13979 | 140605 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 821 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003852 | 2111440 | 37.7778295595765 | -122.430221880635 | (37.7778295595765, -122.430221880635) | 7 | 9 | 11 | 29492 | 10 | |||
14041 | 71278 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2906 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004343.56511 | 2119183.30119 | 37.7991185446364 | -122.42907362116 | (37.7991185446364, -122.42907362116) | 13 | 9 | 1 | 57 | 17 | |||
14162 | 72634 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2010 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6003244.46137 | 2118963.59637 | 37.7984530148543 | -122.432861186113 | (37.7984530148543, -122.432861186113) | 13 | 9 | 1 | 57 | 17 | |||
14354 | 102358 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3551 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769877 | 6000705.04573 | 2120562.75931 | 37.8026995353058 | -122.441763154152 | (37.8026995353058, -122.441763154152) | 13 | 9 | 1 | 57 | 17 |
14529 | 132720 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1899 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003947.47486 | 2118663.22841 | 37.7976681297383 | -122.43040710083 | (37.7976681297383, -122.43040710083) | 13 | 9 | 1 | 57 | 17 | |||
14790 | 16747 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1760 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1997 12:00:00 AM | 12 | 4X4 | 6002883.2905878 | 2113428.1185512 | 37.783233519123 | -122.433715109442 | (37.783233519123, -122.433715109442) | 13 | 9 | 11 | 29490 | 41 | ||
14800 | 132963 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005044.81632 | 2118169.60189 | 37.7963748551747 | -122.426574830578 | (37.7963748551747, -122.426574830578) | 13 | 9 | 1 | 57 | 17 | |||
14978 | 9722 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 417X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005731.65964 | 2111697.2808 | 37.77864227467 | -122.423737774312 | (37.77864227467, -122.423737774312) | 7 | 9 | 11 | 28852 | 10 | |||
15000 | 20198 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Steiner St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002788.752 | 2112893.404 | 37.7817599629104 | -122.434003939845 | (37.7817599629104, -122.434003939845) | 15 | 9 | 11 | 29490 | 41 | ||
15051 | 48711 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1800X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 7 | 2x2 | Permit Number 45978 | 6006039.87759 | 2116625.53054 | 37.7921914266393 | -122.423021901452 | (37.7921914266393, -122.423021901452) | 13 | 9 | 1 | 28858 | 27 | |
15253 | 132480 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2204 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002399.23412 | 2118150.89241 | 37.7961735661988 | -122.43572775266 | (37.7961735661988, -122.43572775266) | 13 | 9 | 1 | 57 | 17 | |||
15320 | 80077 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2410 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6001426.32378 | 2118363.43589 | 37.7967018441792 | -122.439109452666 | (37.7967018441792, -122.439109452666) | 13 | 9 | 1 | 57 | 17 |
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) );