Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
1850 | 1850 | 251747 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002959.0 | 2087321.0 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | ||||
2582 | 2582 | 253132 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004047.94044 | 2092448.5749599999 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | ||||
7088 | 7088 | 107943 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | |||
7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
8942 | 8942 | 19287 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | |||
12679 | 12679 | 17228 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000994.2729400005 | 2091122.49333 | 37.721880279621 | -122.43865153853201 | (37.721880279621, -122.438651538532) | |||
17640 | 17640 | 4490 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | ||
18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
22388 | 22388 | 7124 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.787805844908796 | -122.42380084655301 | (37.7878058449088, -122.423800846553) | ||
22516 | 22516 | 7126 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.585390001 | 2115024.0954299998 | 37.7877762068484 | -122.42401618562201 | (37.7877762068484, -122.424016185622) | ||
22560 | 22560 | 7122 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.457909999 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) | ||
22574 | 22574 | 7125 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.176580001 | 2115026.96294 | 37.7877851299198 | -122.42395206753099 | (37.7877851299198, -122.423952067531) | ||
22588 | 22588 | 7129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.6560299997 | 37.787623057713496 | -122.424742207381 | (37.7876230577135, -122.424742207381) | ||
22606 | 22606 | 7130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | ||
22608 | 22608 | 9889 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005347.08674 | 2115527.81747 | 37.78913826426621 | -122.425340821331 | (37.7891382642662, -122.425340821331) | |||
22656 | 22656 | 17785 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.42516394985701 | (37.7891194189645, -122.425163949857) | |||
22660 | 22660 | 28058 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.0390099995 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | ||
22690 | 22690 | 28059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | ||
22706 | 22706 | 7127 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.2576200003 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | ||
22731 | 22731 | 7128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.787613391789705 | -122.424802721882 | (37.7876133917897, -122.424802721882) | ||
22801 | 22801 | 7123 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.42374600408701 | (37.7878131752727, -122.423746004087) | ||
22809 | 22809 | 125505 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6007613.99229 | 2119386.63886 | 37.799861442220895 | -122.41777122496 | (37.7998614422209, -122.41777122496) | ||||
23721 | 23721 | 220632 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.746803608795396 | -122.43508461868299 | (37.7468036087954, -122.435084618683) | |||
24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
24476 | 24476 | 189185 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013378.5695400005 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | |||
24633 | 24633 | 220637 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003700.73164 | 2096802.6587900002 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | |||
25088 | 25088 | 189157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.78108402055079 | -122.40130951984501 | (37.7810840205508, -122.401309519845) | |||
25297 | 25297 | 203469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998711.4385400005 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | ||||
26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
26515 | 26515 | 220605 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006588.43416 | 2095556.2784900002 | 37.7343711416034 | -122.419628336682 | (37.7343711416034, -122.419628336682) | |||
26824 | 26824 | 125535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | |||
27160 | 27160 | 203449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.47029301742901 | (37.7605942249661, -122.470293017429) | |||
27258 | 27258 | 220664 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003819.11819 | 2101351.9934400003 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | |||
27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
27524 | 27524 | 189155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.40120547186899 | (37.7811537953404, -122.401205471869) | |||
27556 | 27556 | 220598 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006787.43083 | 2105854.6831099996 | 37.7626594317184 | -122.41967079188801 | (37.7626594317184, -122.419670791888) | |||
28352 | 28352 | 125438 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 250 Euclid Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5998091.24108 | 2114006.2469099998 | 37.78454782955 | -122.45033529224199 | (37.78454782955, -122.450335292242) | ||||
28571 | 28571 | 203474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | |||
29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
30635 | 30635 | 125520 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.798926272277704 | -122.414435828363 | (37.7989262722777, -122.414435828363) | |||
30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
30833 | 30833 | 220633 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6002213.10405 | 2100169.21088 | 37.7467897493647 | -122.435085071929 | (37.7467897493647, -122.435085071929) | |||
31097 | 31097 | 123452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | |||
31567 | 31567 | 203453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.738340446961104 | -122.47206749851001 | (37.7383404469611, -122.47206749851) | |||
31581 | 31581 | 70151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1993 12:00:00 AM | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.41730487074699 | (37.786282435643, -122.417304870747) | ||
31786 | 31786 | 221763 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3816 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002948.3546400005 | 2103602.92928 | 37.7562596509731 | -122.432787903054 | (37.7562596509731, -122.432787903054) | |||
31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
31906 | 31906 | 220602 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.744229349819896 | -122.43003686791401 | (37.7442293498199, -122.430036867914) | |||
32542 | 32542 | 221762 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001705.956180001 | 2104074.38405 | 37.7574836102927 | -122.43711828977399 | (37.7574836102927, -122.437118289774) | |||
33240 | 33240 | 189153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012332.534469999 | 2112551.48713 | 37.781358134807796 | -122.400962694499 | (37.7813581348078, -122.400962694499) | |||
33358 | 33358 | 220588 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1285 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010337.44954 | 2101779.52105 | 37.7516692837277 | -122.40710522684499 | (37.7516692837277, -122.407105226845) | |||
33494 | 33494 | 175166 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004672.7463 | 2094000.25869 | 37.7299905627997 | -122.426140758388 | (37.7299905627997, -122.426140758388) | |||
33529 | 33529 | 175163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.44182642145701 | (37.7251102235329, -122.441826421457) | |||
33827 | 33827 | 203454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993011.06637 | 2099068.7919400004 | 37.743241463417796 | -122.466824576891 | (37.7432414634178, -122.466824576891) | |||
33829 | 33829 | 189162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036411998 | (37.7724260745213, -122.41525036412) | |||
33839 | 33839 | 220603 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 418 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003167.3476 | 2099231.48151 | 37.744269101647795 | -122.43171845176501 | (37.7442691016478, -122.431718451765) | |||
33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
34843 | 34843 | 250128 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.78910907136579 | -122.42525826176399 | (37.7891090713658, -122.425258261764) | |||
35121 | 35121 | 125494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | |||
35158 | 35158 | 125513 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008593.294869999 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | |||
35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) | |||
35686 | 35686 | 125515 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | |||
35750 | 35750 | 250093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.789394379498894 | -122.425398617158 | (37.7893943794989, -122.425398617158) | |||
35891 | 35891 | 125523 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6011207.16585 | 2120734.5295700002 | 37.8037639692824 | -122.40543241409401 | (37.8037639692824, -122.405432414094) | |||
36428 | 36428 | 203476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.743979223173106 | -122.472790471621 | (37.7439792231731, -122.472790471621) | |||
36512 | 36512 | 175167 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | |||
36697 | 36697 | 220597 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.2262 | 2105168.52935 | 37.7608332548635 | -122.416067410784 | (37.7608332548635, -122.416067410784) | |||
36849 | 36849 | 220592 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1383 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007189.08287 | 2107465.79435 | 37.76710578333971 | -122.418395859874 | (37.7671057833397, -122.418395859874) | |||
37156 | 37156 | 189173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1960 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.73616197508429 | -122.396301660307 | (37.7361619750843, -122.396301660307) | |||
37791 | 37791 | 220646 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.41404494431801 | (37.7346828016745, -122.414044944318) | |||
38661 | 38661 | 189188 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6013301.8737 | 2110750.05964 | 37.776465849843895 | -122.39748285416799 | (37.7764658498439, -122.397482854168) | |||
38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
38916 | 38916 | 125482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.41113140348499 | (37.7914679787239, -122.411131403485) | |||
38930 | 38930 | 220655 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008083.69599 | 2096082.2563599998 | 37.735899476465704 | -122.41449592016599 | (37.7358994764657, -122.414495920166) | |||
39363 | 39363 | 249821 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.8759699995 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | |||
39883 | 39883 | 203492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | |||
40273 | 40273 | 125508 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008930.4214699995 | 2118571.4914 | 37.797697242591504 | -122.41315819931299 | (37.7976972425915, -122.413158199313) | |||
40602 | 40602 | 203478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.74234030496479 | -122.469178135975 | (37.7423403049648, -122.469178135975) | |||
40929 | 40929 | 249550 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005507.2276099995 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | |||
40963 | 40963 | 125473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6010077.67437 | 2116003.04391 | 37.7907092485717 | -122.409007053757 | (37.7907092485717, -122.409007053757) | |||
41144 | 41144 | 175153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001323.552619999 | 2092431.0494099997 | 37.7254920046417 | -122.43760697060101 | (37.7254920046417, -122.437606970601) | |||
41206 | 41206 | 189186 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013353.399019999 | 2110803.04971 | 37.776614217315505 | -122.39730832904199 | (37.7766142173155, -122.397308329042) | |||
41654 | 41654 | 125506 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | |||
41677 | 41677 | 249947 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | |||
41684 | 41684 | 203490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001874.24208 | 2094906.2061700001 | 37.7323195164307 | -122.43588030914302 | (37.7323195164307, -122.435880309143) | |||
42654 | 42654 | 125464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 887 Eddy St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.782671211560704 | -122.4219424317 | (37.7826712115607, -122.4219424317) | |||
43229 | 43229 | 220599 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 714 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010100.45141 | 2104938.60727 | 37.7603301624296 | -122.408147577953 | (37.7603301624296, -122.408147577953) | |||
43603 | 43603 | 249538 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6006360.10871 | 2114050.0114700003 | 37.785137754239294 | -122.421730877876 | (37.7851377542393, -122.421730877876) | |||
43773 | 43773 | 189175 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012666.59913 | 2115298.5353200003 | 37.788919518565706 | -122.39999995672599 | (37.7889195185657, -122.399999956726) | |||
43774 | 43774 | 203480 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993659.30191 | 2093497.00296 | 37.7279801058879 | -122.464178756148 | (37.7279801058879, -122.464178756148) | |||
43884 | 43884 | 189176 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012661.31608 | 2115304.6540900003 | 37.7889360247231 | -122.40001866534901 | (37.7889360247231, -122.400018665349) | |||
43939 | 43939 | 203498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999190.87551 | 2094097.9228400001 | 37.72994736206179 | -122.445099202768 | (37.7299473620618, -122.445099202768) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");