trees
7,157 rows where qSpecies_id = 36 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1898 | 1593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 699 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995612.08469 | 2111572.44274 | 37.7777230574603 | -122.458736017911 | (37.7777230574603, -122.458736017911) | 11 | 6 | 2 | 54 | 11 | |||
29599 | 1559 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 552 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 5995643.10859 | 2112475.92175 | 37.7802055542204 | -122.458694119583 | (37.7802055542204, -122.458694119583) | 11 | 6 | 2 | 54 | 16 | |||
38652 | 1382 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995593.50257 | 2112100.09905 | 37.7791707937226 | -122.458838511201 | (37.7791707937226, -122.458838511201) | 11 | 6 | 2 | 54 | 11 | |||
44589 | 1636 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 827 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 5995647.41415 | 2110653.56158 | 37.7752020829683 | -122.458547268394 | (37.7752020829683, -122.458547268394) | 11 | 6 | 2 | 54 | 11 | |||
50349 | 1608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 738 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995691.98224 | 2111083.1431 | 37.7763841618607 | -122.458424200101 | (37.7763841618607, -122.458424200101) | 11 | 6 | 2 | 54 | 16 | |||
53196 | 1582 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 633 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995604.58017 | 2111830.53845 | 37.778431288562 | -122.458780668658 | (37.778431288562, -122.458780668658) | 11 | 6 | 2 | 54 | 11 | |||
74817 | 1574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 595 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995589.69887 | 2112254.70561 | 37.7795950836314 | -122.45886286632 | (37.7795950836314, -122.45886286632) | 11 | 6 | 2 | 54 | 11 | |||
146158 | 1552 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 531 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3PL | 5995576.8395 | 2112621.27904 | 37.780600857583 | -122.458933900576 | (37.780600857583, -122.458933900576) | 11 | 6 | 2 | 54 | 11 | |||
161157 | 1584 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 653 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995606.55902 | 2111798.94869 | 37.7783446651954 | -122.458771535508 | (37.7783446651954, -122.458771535508) | 11 | 6 | 2 | 54 | 11 | |||
167034 | 10495 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | 15 | 5 | 11 | 29492 | 9 | |||
1098 | 31784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 7 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35255 | 6001631.05677 | 2108636.54376 | 37.7700059251571 | -122.437704050605 | (37.7700059251571, -122.437704050605) | 15 | 5 | 5 | 29492 | 9 | |
1225 | 70200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
2682 | 62568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 549 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 9 | Permit Number 22769 | 6011537.01637 | 2105794.87658 | 37.7627616189737 | -122.403239377718 | (37.7627616189737, -122.403239377718) | 8 | 3 | 8 | 28856 | 29 | |
2958 | 71259 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1645 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001742.1262 | 2111827.7039 | 37.7787743674935 | -122.437548426148 | (37.7787743674935, -122.437548426148) | 15 | 5 | 11 | 29490 | 41 | |||
3463 | 72267 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 366 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002326.2319 | 2091479.20483 | 37.7229354119295 | -122.43407278875 | (37.7229354119295, -122.43407278875) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |
4088 | 32087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3964 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 9 | Permit Number 35460 | 6003256.89159 | 2104790.94057 | 37.759539140336 | -122.431805698599 | (37.759539140336, -122.431805698599) | 2 | 4 | 5 | 28862 | 3 | |
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 | |||
4909 | 194805 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015913.1436 | 2114020.02003 | 37.7855894765281 | -122.388677968825 | (37.7855894765281, -122.388677968825) | 6 | 2 | 9 | 28856 | 6 | |||
4929 | 246370 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1999 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006824.5951 | 2106962.8564 | 37.7657043092438 | -122.419620882946 | (37.7657043092438, -122.419620882946) | 8 | 4 | 7 | 28853 | 19 | |||
5152 | 43235 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1718 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 9 | Permit Number 43022 | 5989693.2293 | 2103631.2748 | 37.7555767947293 | -122.47863024953 | (37.7555767947293, -122.47863024953) | 1 | 8 | 3 | 56 | 35 | |
5166 | 246272 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2097 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006864.7942 | 2106195.7269 | 37.7636002158578 | -122.419427415102 | (37.7636002158578, -122.419427415102) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||
5832 | 194684 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Jack Balestreri Way | 28 | Front Yard : Yard | Tree | Private 2 | 9 | 6012406.88691 | 2104790.52602 | 37.7600524373766 | -122.400160243821 | (37.7600524373766, -122.400160243821) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
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 | |||
10587 | 72371 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 656 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5990684.35587 | 2110897.8962 | 37.7755864763334 | -122.475733274071 | (37.7755864763334, -122.475733274071) | 11 | 6 | 2 | 54 | 26 | |||
10854 | 31785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 15 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35256 | 6001632.60531 | 2108617.48502 | 37.7699536826355 | -122.437697329081 | (37.7699536826355, -122.437697329081) | 15 | 5 | 5 | 29492 | 9 | |
11889 | 246929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 349 Frederick St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.449096088512 | (37.7668065294199, -122.449096088512) | 15 | 5 | 11 | 29492 | 9 | |||
12731 | 107057 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 601X Davis St | 2 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 9 | Permit Number 771755 | 6013145.32204 | 2118507.86888 | 37.7977582696821 | -122.398568926718 | (37.7977582696821, -122.398568926718) | 3 | 1 | 10 | 28860 | 6 | ||
16253 | 62571 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 777 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 9 | 5x7 | Permit Number 22773 | 6011591.71748 | 2104764.61331 | 37.759935800723 | -122.402977717253 | (37.759935800723, -122.402977717253) | 10 | 3 | 8 | 28856 | 29 |
16736 | 73545 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1620 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007910.76881 | 2117984.0068 | 37.7960268607141 | -122.4166448466 | (37.7960268607141, -122.4166448466) | 5 | 1 | 10 | 28858 | 21 | |||
16925 | 63583 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2351 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 9 | Permit Number 24208 | 6006705.30109 | 2119319.99984 | 37.7996272902269 | -122.420910908407 | (37.7996272902269, -122.420910908407) | 5 | 9 | 1 | 28858 | 32 | |
18189 | 235133 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 802 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007927.709 | 2103213.95846 | 37.7554727747606 | -122.415539995268 | (37.7554727747606, -122.415539995268) | 2 | 4 | 7 | 28859 | 19 | |||
18275 | 110955 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 5x5 | 6008486.88199 | 2119694.39066 | 37.8007555347125 | -122.414772482377 | (37.8007555347125, -122.414772482377) | 5 | 1 | 10 | 308 | 32 | ||
18552 | 60416 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19997 | 6015487.5561 | 2094405.0524 | 37.7317073747329 | -122.388780566326 | (37.7317073747329, -122.388780566326) | 10 | 3 | 8 | 58 | 1 | |
18763 | 60860 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 249 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1983 12:00:00 AM | 9 | Permit Number 20641 | 5994284.20429 | 2113855.74961 | 37.7839159920389 | -122.463495321911 | (37.7839159920389, -122.463495321911) | 11 | 6 | 2 | 54 | 11 | |
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 | ||
19922 | 52251 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2703 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2006 12:00:00 AM | 9 | Permit Number 48418 | 6006531.73824 | 2120517.37905 | 37.802905204862 | -122.42159658841 | (37.802905204862, -122.42159658841) | 5 | 9 | 1 | 28858 | 32 | |
20225 | 235264 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 585 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003679.80428 | 2104890.24659 | 37.7598357754089 | -122.430350142263 | (37.7598357754089, -122.430350142263) | 2 | 4 | 5 | 28862 | 3 | |||
20441 | 9592 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1321 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6003210.81431 | 2112031.15046 | 37.7794163737998 | -122.432482197381 | (37.7794163737998, -122.432482197381) | 15 | 9 | 11 | 29490 | 41 | |||
21796 | 235127 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007432.46177 | 2100180.44226 | 37.7471155773181 | -122.417037787358 | (37.7471155773181, -122.417037787358) | 2 | 7 | 7 | 28859 | 2 | |||
22670 | 65099 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 202 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 9 | Permit Number 27064 | 5989334.04972 | 2113896.48912 | 37.7837413984837 | -122.480623818366 | (37.7837413984837, -122.480623818366) | 11 | 6 | 2 | 55 | 26 | |
22691 | 123637 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 309 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995519.02891 | 2114141.6809 | 37.7847721511746 | -122.459244025086 | (37.7847721511746, -122.459244025086) | 11 | 6 | 2 | 54 | 11 | |||
23511 | 132749 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2068 Jefferson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999296.53972 | 2121195.84078 | 37.8043574507926 | -122.446682856733 | (37.8043574507926, -122.446682856733) | 13 | 9 | 1 | 57 | 17 | |||
23651 | 15497 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2702 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6006947.92485 | 2102555.20761 | 37.7536088741542 | -122.418881678848 | (37.7536088741542, -122.418881678848) | 2 | 4 | 7 | 28859 | 19 | |||
23664 | 132637 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3255 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998680.39359 | 2116211.26741 | 37.7906359349439 | -122.448455884535 | (37.7906359349439, -122.448455884535) | 13 | 6 | 1 | 54 | 31 | |||
25380 | 116004 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 945 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012685.45612 | 2119344.92547 | 37.8000309958941 | -122.400219019899 | (37.8000309958941, -122.400219019899) | 3 | 1 | 10 | 28860 | 6 | |||
26218 | 45716 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 475 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2001 12:00:00 AM | 9 | Permit Number 44386 | 6010095.7321 | 2106068.08707 | 37.7634311939257 | -122.408243563496 | (37.7634311939257, -122.408243563496) | 8 | 4 | 8 | 28859 | 19 | ||
26758 | 211543 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992701.43266 | 2097858.41008 | 37.7399001861538 | -122.467807186075 | (37.7399001861538, -122.467807186075) | 1 | 8 | 4 | 59 | 40 | |||
26829 | 139989 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 420 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005762.6649 | 2111745.7942 | 37.7787772308277 | -122.423633965181 | (37.7787772308277, -122.423633965181) | 7 | 9 | 11 | 28852 | 41 | |||
26967 | 60923 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 209 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/1983 12:00:00 AM | 9 | Permit Number 20723 | 5992726.03909 | 2114047.31569 | 37.7843520811772 | -122.468899896592 | (37.7843520811772, -122.468899896592) | 11 | 6 | 2 | 54 | 11 | ||
27221 | 133034 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1140 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008647.68395 | 2117973.21451 | 37.7960386454118 | -122.414094203805 | (37.7960386454118, -122.414094203805) | 5 | 1 | 10 | 308 | 21 | |||
27536 | 234239 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 377 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007210.56069 | 2096026.64434 | 37.7356976874983 | -122.417510762427 | (37.7356976874983, -122.417510762427) | 2 | 7 | 7 | 28859 | 2 | |||
27803 | 132916 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002340.8707 | 2117800.76509 | 37.7952088922237 | -122.435904636691 | (37.7952088922237, -122.435904636691) | 13 | 9 | 1 | 57 | 17 | |||
27913 | 142912 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1365x Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010980 | 2119621 | 37.8006937860332 | -122.406140040303 | (37.8006937860332, -122.406140040303) | 3 | 1 | 10 | 308 | 23 | |||
28212 | 211625 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5994395.62739 | 2100058.6055 | 37.7460390546617 | -122.462108929608 | (37.7460390546617, -122.462108929608) | 1 | 8 | 4 | 29491 | 40 | |||
29716 | 64648 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 326 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1988 12:00:00 AM | 9 | Permit Number 25565 | 5999812.52008 | 2091906.81164 | 37.7239665394999 | -122.442792834745 | (37.7239665394999, -122.442792834745) | 9 | 7 | 6 | 28861 | 25 | ||
29949 | 194816 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015723.9379 | 2114119.71149 | 37.7858527188632 | -122.389339535303 | (37.7858527188632, -122.389339535303) | 6 | 2 | 9 | 28856 | 6 | |||
30633 | 211691 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994923.94235 | 2089936.05858 | 37.7182754155504 | -122.459549091241 | (37.7182754155504, -122.459549091241) | 9 | 8 | 6 | 28861 | 24 | |||
30672 | 132652 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3627 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997490.76869 | 2115065.27185 | 37.7874212480436 | -122.452489163147 | (37.7874212480436, -122.452489163147) | 11 | 6 | 1 | 54 | 31 | |||
32519 | 234241 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 347 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006908.27462 | 2096052.45563 | 37.7357515460871 | -122.418557714468 | (37.7357515460871, -122.418557714468) | 2 | 7 | 7 | 28859 | 2 | |||
32530 | 235308 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 283 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002103.01122 | 2104169.29235 | 37.7577667672463 | -122.435751906619 | (37.7577667672463, -122.435751906619) | 2 | 4 | 5 | 28862 | 3 | |||
33281 | 30818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | 9 | Permit Number 34679 | 6001851.91271 | 2095252.38683 | 37.7332687805252 | -122.435982268868 | (37.7332687805252, -122.435982268868) | 9 | 7 | 5 | 63 | 40 | ||
33617 | 234098 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 33 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006010.43527 | 2105281.10911 | 37.7610407329761 | -122.422317390543 | (37.7610407329761, -122.422317390543) | 2 | 4 | 5 | 28859 | 19 | |||
33624 | 141972 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 612 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004763.7564 | 2111611.5134 | 37.7783520929835 | -122.427080015976 | (37.7783520929835, -122.427080015976) | 7 | 9 | 11 | 28852 | 41 | |||
35309 | 62097 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 291 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 9 | Permit Number 22188 | 6013218.62092 | 2105748.57667 | 37.7627282613102 | -122.397420014939 | (37.7627282613102, -122.397420014939) | 14 | 3 | 8 | 28856 | 29 | |
35681 | 120030 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5250 Fulton St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5987030.11387 | 2109846.23506 | 37.7724863769702 | -122.488296717273 | (37.7724863769702, -122.488296717273) | 11 | 6 | 2 | 55 | 26 | |||
36190 | 133270 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
36217 | 60600 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 28 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1983 12:00:00 AM | 9 | Permit Number 20222 | 5994274.38941 | 2115375.13124 | 37.7880872355118 | -122.463639586862 | (37.7880872355118, -122.463639586862) | 11 | 6 | 1 | 54 | 11 | ||
36716 | 133093 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006284.8877 | 2119731.21115 | 37.800732665844 | -122.422394927384 | (37.800732665844, -122.422394927384) | 13 | 9 | 1 | 28858 | 32 | |||
36859 | 201928 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 118 Elmira St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6011173.64176 | 2096032.19931 | 37.7359351363972 | -122.403809172877 | (37.7359351363972, -122.403809172877) | 10 | 3 | 8 | 58 | 1 | |||
37403 | 123378 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 749 03rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5995025.44611 | 2110513.91513 | 37.7747828859294 | -122.460688658903 | (37.7747828859294, -122.460688658903) | 11 | 6 | 2 | 54 | 11 | |||
37408 | 8135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 910X Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/1992 12:00:00 AM | 9 | 3X3 | 6003396.69428 | 2111417.2604 | 37.777741323222 | -122.431795316553 | (37.777741323222, -122.431795316553) | 15 | 9 | 11 | 29492 | 41 | ||
37922 | 133078 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1335 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006533.54828 | 2119369.06247 | 37.7997523211659 | -122.421508722869 | (37.7997523211659, -122.421508722869) | 13 | 9 | 1 | 28858 | 32 | |||
38189 | 235073 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1142 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998924.20961 | 2105973.11364 | 37.7625385349346 | -122.446875271204 | (37.7625385349346, -122.446875271204) | 15 | 5 | 5 | 29492 | 9 | |||
38611 | 194719 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 686 Connecticut St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013263.42241 | 2103904.54929 | 37.7576674605002 | -122.397135752739 | (37.7576674605002, -122.397135752739) | 10 | 3 | 8 | 28856 | 29 | |||
39121 | 138998 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 611 Fillmore St | 4 | 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 | |||
39240 | 194965 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6011526.58461 | 2112400.4179 | 37.7808983438113 | -122.403740270404 | (37.7808983438113, -122.403740270404) | 6 | 2 | 9 | 28853 | 34 | |||
39334 | 133209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 641 Davis St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013123.8854 | 2118671.56036 | 37.798206533163 | -122.398654597049 | (37.798206533163, -122.398654597049) | 3 | 1 | 10 | 28860 | 6 | |||
39468 | 99019 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 520 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010049.73515 | 2105870.79075 | 37.7628868873314 | -122.408388735644 | (37.7628868873314, -122.408388735644) | 8 | 4 | 8 | 28859 | 19 | |||
39793 | 139614 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1770 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001591.0209 | 2112203.3521 | 37.7797972102007 | -122.438098073618 | (37.7797972102007, -122.438098073618) | 15 | 5 | 11 | 29490 | 41 | |||
40234 | 98607 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6002988.21052 | 2116859.68166 | 37.7926616713417 | -122.433597452086 | (37.7926616713417, -122.433597452086) | 13 | 9 | 1 | 29490 | 27 | ||
40295 | 211620 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2320 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5992936.31897 | 2100466.6121 | 37.7470752076621 | -122.467184642958 | (37.7470752076621, -122.467184642958) | 1 | 8 | 4 | 29491 | 40 | |||
40364 | 73549 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2174 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2013 12:00:00 AM | 9 | 5x9 | Permit Number 770741 | 6002210.5144 | 2114377.4195 | 37.785801860206 | -122.436110595993 | (37.785801860206, -122.436110595993) | 13 | 6 | 1 | 29490 | 27 |
40626 | 138458 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002909.6613 | 2114824.4522 | 37.7870689941975 | -122.433723708162 | (37.7870689941975, -122.433723708162) | 13 | 9 | 11 | 29490 | 27 | |||
40958 | 140037 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 415 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005768.8236 | 2111698.6656 | 37.7786481748213 | -122.423609308166 | (37.7786481748213, -122.423609308166) | 7 | 9 | 11 | 28852 | 10 | |||
42699 | 141177 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1989 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001811.4181 | 2113225.809 | 37.7826171495156 | -122.437408860584 | (37.7826171495156, -122.437408860584) | 15 | 5 | 11 | 29490 | 41 | |||
42900 | 66014 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3427 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1990 12:00:00 AM | 9 | Permit Number 29048 | 6000274.1087 | 2120069.54266 | 37.8013207307327 | -122.443218965005 | (37.8013207307327, -122.443218965005) | 13 | 9 | 1 | 57 | 17 | ||
43492 | 246206 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1364 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999569.1195 | 2107980.2213 | 37.7680863722852 | -122.444789049217 | (37.7680863722852, -122.444789049217) | 15 | 5 | 11 | 29492 | 9 | |||
43510 | 121827 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 286 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5989969.55995 | 2113444.85819 | 37.7825382607767 | -122.478392181292 | (37.7825382607767, -122.478392181292) | 11 | 6 | 2 | 55 | 26 | |||
43573 | 42850 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1522 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 9 | Permit Number 42780 | 6006252.60895 | 2118339.52861 | 37.7969096370378 | -122.422407686078 | (37.7969096370378, -122.422407686078) | 13 | 9 | 10 | 28858 | 32 | |
44193 | 211700 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 224 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994781.29962 | 2088724.86797 | 37.7149415702587 | -122.459954451661 | (37.7149415702587, -122.459954451661) | 9 | 8 | 6 | 28861 | 24 | |||
45023 | 132525 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3700 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000688.77119 | 2120998.47252 | 37.8038949600465 | -122.44185076252 | (37.8038949600465, -122.44185076252) | 13 | 9 | 1 | 57 | 17 | |||
45408 | 194707 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Arkansas St | 6 | : | Tree | Private 2 | 9 | Width 2ft | 6012996.59489 | 2103785.35445 | 37.7573253197232 | -122.398050195986 | (37.7573253197232, -122.398050195986) | 10 | 3 | 8 | 28856 | 29 | |||
45714 | 139457 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 806 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001030.7636 | 2111471.5149 | 37.7777558926089 | -122.439983755649 | (37.7777558926089, -122.439983755649) | 15 | 5 | 11 | 29490 | 41 | |||
46136 | 194630 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1130 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013849.73558 | 2106200.7814 | 37.7640050351258 | -122.395268876153 | (37.7640050351258, -122.395268876153) | 14 | 3 | 8 | 28856 | 29 | |||
46320 | 120616 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010384.51701 | 2122042.28091 | 37.8073086993106 | -122.408371546927 | (37.8073086993106, -122.408371546927) | 3 | 1 | 10 | 308 | 23 | |||
46989 | 66135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3465 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 9 | Permit Number 29198 | 5999730.8614 | 2120470.7804 | 37.8023914302916 | -122.445127696883 | (37.8023914302916, -122.445127696883) | 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) );