Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2291 | 2291 | 228437 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 6 | Width 3ft | 6004091.19769 | 2108012.29591 | 37.7684314676748 | -122.429149946611 | (37.7684314676748, -122.429149946611) | ||
| 2946 | 2946 | 228442 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 413 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | ||
| 2952 | 2952 | 244491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 2 | Width 0ft | 6004006.3051 | 2109418.5142 | 37.7722877948852 | -122.42954388259199 | (37.7722877948852, -122.429543882592) | ||
| 2970 | 2970 | 228443 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 401 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.42901857547301 | (37.7722283522845, -122.429018575473) | ||
| 2975 | 2975 | 244494 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 400 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 0ft | 6004177.5073 | 2109444.4069999997 | 37.7723685822151 | -122.428953525151 | (37.7723685822151, -122.428953525151) | ||
| 2982 | 2982 | 244493 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 418 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 2 | Width 0ft | 6004092.0994 | 2109430.4944 | 37.772325546907794 | -122.42924796682699 | (37.7723255469078, -122.429247966827) | ||
| 2984 | 2984 | 228440 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.42962941028401 | (37.7721427080557, -122.429629410284) | ||
| 3015 | 3015 | 244496 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 478 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 4 | Width 0ft | 6003878.5797 | 2109399.3843 | 37.7722280361906 | -122.429984331292 | (37.7722280361906, -122.429984331292) | ||
| 3016 | 3016 | 244492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 2 | Width 0ft | 6003951.2344 | 2109410.9782 | 37.7722639846023 | -122.429733839468 | (37.7722639846023, -122.429733839468) | ||
| 3025 | 3025 | 228441 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 419 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | ||
| 3093 | 3093 | 124473 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 356 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45077 | 5996305.70499 | 2110483.22678 | 37.774772198948796 | -122.456257787006 | (37.7747721989488, -122.456257787006) | |
| 5146 | 5146 | 228435 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 178 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004070.0 | 2107898.0 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | |||
| 5169 | 5169 | 228433 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004139.02513 | 2107107.02985 | 37.7659485330168 | -122.4289199675 | (37.7659485330168, -122.4289199675) | |||
| 6152 | 6152 | 34989 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2447 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 10 | Permit Number 38568 | 6002987.46694 | 2116484.72723 | 37.7916321004801 | -122.433573216253 | (37.7916321004801, -122.433573216253) | ||
| 13462 | 13462 | 15276 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1563X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.7778199995 | 2109715.95764 | 37.7732881790271 | -122.41831089463699 | (37.7732881790271, -122.418310894637) | ||
| 13712 | 13712 | 6809 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.9784699995 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | ||
| 15010 | 15010 | 6841 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.0043599997 | 37.7408861578704 | -122.38663127193199 | (37.7408861578704, -122.386631271932) | ||
| 16973 | 16973 | 10247 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | ||
| 17937 | 17937 | 25490 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2008 12:00:00 AM | 6 | 3x3 | 6003008.9663 | 2109230.9780099997 | 37.771716346673 | -122.432980363376 | (37.771716346673, -122.432980363376) | ||
| 18351 | 18351 | 10343 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 940 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001599.8151 | 2109085.1313 | 37.7712358586189 | -122.437844249148 | (37.7712358586189, -122.437844249148) | |||
| 18938 | 18938 | 10354 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.771092330601604 | -122.439069286514 | (37.7710923306016, -122.439069286514) | ||
| 18989 | 18989 | 10323 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 774 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2009 12:00:00 AM | 3 | 3X3 | 6002445.3097 | 2109202.4042 | 37.771605902741705 | -122.43492804083999 | (37.7716059027417, -122.43492804084) | ||
| 19165 | 19165 | 10233 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005984.609 | 2109698.904 | 37.77316949126 | -122.422720671561 | (37.77316949126, -122.422720671561) | |||
| 21394 | 21394 | 10288 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 447 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6003998.901740001 | 2109366.95645 | 37.77214581071579 | -122.429565813827 | (37.7721458107158, -122.429565813827) | ||
| 21724 | 21724 | 10299 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 559 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6003469.25661 | 2109295.83619 | 37.7719205287291 | -122.43139282162599 | (37.7719205287291, -122.431392821626) | |||
| 21845 | 21845 | 10257 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 155 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2006 12:00:00 AM | 6 | 3X3 | 6005354.145880001 | 2109555.43017 | 37.7727399559066 | -122.424891318606 | (37.7727399559066, -122.424891318606) | ||
| 21953 | 21953 | 29956 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.43228248973699 | (37.7719405092432, -122.432282489737) | ||
| 23042 | 23042 | 10300 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 548 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003485.1293 | 2109346.6257 | 37.772060883831 | -122.43134154303002 | (37.772060883831, -122.43134154303) | |||
| 23089 | 23089 | 24920 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 430 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6004056.545 | 2109425.8569 | 37.772310800612104 | -122.429370621982 | (37.7723108006121, -122.429370621982) | |||
| 23307 | 23307 | 10286 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6004126.8809 | 2109434.3591 | 37.772338127403394 | -122.429127930043 | (37.7723381274034, -122.429127930043) | |||
| 23433 | 23433 | 228490 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 512 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004210.50257 | 2105904.81342 | 37.762651580625 | -122.428587037577 | (37.762651580625, -122.428587037577) | |||
| 24406 | 24406 | 228482 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006464.96947 | 2105462.2206200003 | 37.7615636518725 | -122.42075820894699 | (37.7615636518725, -122.420758208947) | |||
| 26787 | 26787 | 228493 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3748 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003428.54428 | 2103628.48028 | 37.7563570304699 | -122.431129066663 | (37.7563570304699, -122.431129066663) | |||
| 27192 | 27192 | 228497 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 487 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004262.22293 | 2106063.80962 | 37.7630910730105 | -122.428419488484 | (37.7630910730105, -122.428419488484) | |||
| 30430 | 30430 | 190662 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1498 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | |||
| 31656 | 31656 | 228466 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004209.32869 | 2107056.55416 | 37.7658139179905 | -122.42867320340599 | (37.7658139179905, -122.428673203406) | |||
| 32337 | 32337 | 219178 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991732.81966 | 2106918.29037 | 37.7647202794542 | -122.471816321464 | (37.7647202794542, -122.471816321464) | |||
| 33760 | 33760 | 228480 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 602 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007650.87527 | 2096524.2069599999 | 37.7370886509206 | -122.416023645289 | (37.7370886509206, -122.416023645289) | |||
| 34455 | 34455 | 228481 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 430 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008039.5755 | 2096830.96729 | 37.7379527941736 | -122.414701431422 | (37.7379527941736, -122.414701431422) | |||
| 35360 | 35360 | 190656 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 358 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012906.49923 | 2105280.1318200002 | 37.7614246319699 | -122.39846666842101 | (37.7614246319699, -122.398466668421) | |||
| 36077 | 36077 | 37655 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1521 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40065 | 5990857.78217 | 2110597.46577 | 37.774771629499796 | -122.475111419797 | (37.7747716294998, -122.475111419797) | |
| 38824 | 38824 | 51853 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1639 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2005 12:00:00 AM | 8 | Permit Number 48077 | 6012728.89469 | 2105155.76009 | 37.7610732389628 | -122.39907220261999 | (37.7610732389628, -122.39907220262) | ||
| 41126 | 41126 | 67427 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1515 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30929 | 5990869.16638 | 2110599.51462 | 37.7747779148712 | -122.475072189476 | (37.7747779148712, -122.475072189476) | |
| 44241 | 44241 | 64733 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 135 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1988 12:00:00 AM | 8 | Permit Number 25692 | 5994873.94035 | 2114654.72726 | 37.786143729617294 | -122.461513011375 | (37.7861437296173, -122.461513011375) | ||
| 46354 | 46354 | 244230 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 546 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003542.3247 | 2109354.0057 | 37.7720843887684 | -122.43114422654699 | (37.7720843887684, -122.431144226547) | |||
| 47551 | 47551 | 244231 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.772022330462796 | -122.43161454270799 | (37.7720223304628, -122.431614542708) | |||
| 47929 | 47929 | 228459 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006042.870080001 | 2100850.33706 | 37.748876688223795 | -122.421890467095 | (37.7488766882238, -122.421890467095) | |||
| 48889 | 48889 | 190650 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.760932794527704 | -122.39917787837601 | (37.7609327945277, -122.399177878376) | |||
| 51149 | 51149 | 228500 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1230 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002502.463830001 | 2101939.70334 | 37.7516675300559 | -122.434211046008 | (37.7516675300559, -122.434211046008) | |||
| 51365 | 51365 | 140195 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 801 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003913.9155 | 2111095.4696 | 37.7768870709162 | -122.429983110687 | (37.7768870709162, -122.429983110687) | |||
| 52316 | 52316 | 190655 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 354 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | |||
| 53257 | 53257 | 228494 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004270.96724 | 2105879.99485 | 37.7625868564077 | -122.42837614294201 | (37.7625868564077, -122.428376142942) | |||
| 53848 | 53848 | 66602 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1235 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/29/1992 12:00:00 AM | 13 | Permit Number 29795 | 6008012.17093 | 2115828.0191200003 | 37.7901127525459 | -122.41614120735399 | (37.7901127525459, -122.416141207354) | |
| 55309 | 55309 | 190664 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013137.75359 | 2111279.19954 | 37.7779096079765 | -122.398087726493 | (37.7779096079765, -122.398087726493) | |||
| 56243 | 56243 | 228489 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001576.285680001 | 2101774.2319 | 37.751160574113605 | -122.437402036675 | (37.7511605741136, -122.437402036675) | |||
| 56606 | 56606 | 219177 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991107.88095 | 2106214.54011 | 37.7627517902819 | -122.473926451152 | (37.7627517902819, -122.473926451152) | |||
| 58955 | 58955 | 37026 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39636 | 6003698.16480104 | 2100138.36684077 | 37.746789273196796 | -122.429947677166 | (37.7467892731968, -122.429947677166) | ||
| 59088 | 59088 | 190668 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 151 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013191.282000001 | 2111332.8508900004 | 37.7780599035854 | -122.397906316128 | (37.7780599035854, -122.397906316128) | |||
| 60274 | 60274 | 228460 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2625 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010714.680480001 | 2102241.99741 | 37.7529602452298 | -122.40583328059601 | (37.7529602452298, -122.405833280596) | |||
| 60791 | 60791 | 228485 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4158 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002879.00201 | 2100672.89334 | 37.7482105324925 | -122.432818439532 | (37.7482105324925, -122.432818439532) | |||
| 61878 | 61878 | 244232 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003376.0691 | 2109331.3272 | 37.77201269653779 | -122.431717698222 | (37.7720126965378, -122.431717698222) | |||
| 63250 | 63250 | 228464 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005334.7155 | 2104318.69082 | 37.7583600194211 | -122.424585951974 | (37.7583600194211, -122.424585951974) | |||
| 63557 | 63557 | 120865 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990028.78526 | 2110554.03114 | 37.7746042888084 | -122.47797588313801 | (37.7746042888084, -122.477975883138) | |||
| 68876 | 68876 | 228449 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009256.91005 | 2106366.76259 | 37.76420428262279 | -122.411165888909 | (37.7642042826228, -122.411165888909) | |||
| 69661 | 69661 | 190652 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 310 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.39852852018299 | (37.7621425904374, -122.398528520183) | |||
| 70029 | 70029 | 129087 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.803946988513104 | -122.40461329806801 | (37.8039469885131, -122.404613298068) | |||
| 70201 | 70201 | 32479 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 81 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 8 | Permit Number 36987 | 6000177.30918 | 2105965.99025 | 37.762590484284395 | -122.44254075744499 | (37.7625904842844, -122.442540757445) | |
| 70341 | 70341 | 228445 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 391 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004290.10245 | 2109410.4526299997 | 37.7722817243588 | -122.428561627213 | (37.7722817243588, -122.428561627213) | |||
| 72860 | 72860 | 228438 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 597 Haight St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003321.74278 | 2109274.9224400003 | 37.7718547433349 | -122.43190158878599 | (37.7718547433349, -122.431901588786) | |||
| 74043 | 74043 | 67428 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30930 | 5990841.08394 | 2110656.29148 | 37.774932181016204 | -122.47517347719901 | (37.7749321810162, -122.475173477199) | |
| 74581 | 74581 | 228446 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 379 Haight St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 5ft | 6004344.901769999 | 2109415.2001400003 | 37.7722978608825 | -122.428372409862 | (37.7722978608825, -122.428372409862) | |||
| 74585 | 74585 | 228472 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004182.38579 | 2107503.9785 | 37.767040912528294 | -122.428798292811 | (37.7670409125283, -122.428798292811) | |||
| 75156 | 75156 | 35578 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1001 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38947 | 6006352.71975705 | 2103759.98649975 | 37.7568833861691 | -122.421025568698 | (37.7568833861691, -122.421025568698) | ||
| 78468 | 78468 | 93310 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004202.0 | 2107132.0 | 37.7660206593376 | -122.428703930527 | (37.7660206593376, -122.428703930527) | ||
| 80126 | 80126 | 91203 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2009 12:00:00 AM | 3 | 6003365.215480001 | 2109356.0742599997 | 37.772080030656 | -122.43175700892999 | (37.772080030656, -122.43175700893) | |||
| 85140 | 85140 | 10309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 629 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2011 12:00:00 AM | 3 | 3X3 | 6003124.536169999 | 2109214.79731 | 37.7716784730152 | -122.43257944422399 | (37.7716784730152, -122.432579444224) | ||
| 85155 | 85155 | 1635 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 819 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2014 12:00:00 AM | 3 | 4X4 | 5995645.06873 | 2110681.65476 | 37.775279084646 | -122.458557415767 | (37.775279084646, -122.458557415767) | ||
| 85659 | 85659 | 43634 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2000 12:00:00 AM | Permit Number 43284 | 6006090.90673928 | 2100856.20266776 | 37.7488955027959 | -122.42172477262301 | (37.7488955027959, -122.421724772623) | ||
| 85917 | 85917 | 35327 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 248 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 775509 | 6006668.16520495 | 2104669.17235853 | 37.759397576581 | -122.41999915657499 | (37.759397576581, -122.419999156575) | ||
| 87419 | 87419 | 32861 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37208 | 6000989.97871227 | 2101553.81963673 | 37.7505220253917 | -122.439413745994 | (37.7505220253917, -122.439413745994) | ||
| 87737 | 87737 | 36126 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1331 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39222 | 5993608.5123809995 | 2106430.08869154 | 37.76348815576279 | -122.46529338011999 | (37.7634881557628, -122.46529338012) | ||
| 87775 | 87775 | 66598 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1243 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | Permit Number 29791 | 6007978.50985665 | 2115821.60445069 | 37.79009324672379 | -122.41625721778799 | (37.7900932467238, -122.416257217788) | ||
| 87935 | 87935 | 63738 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 614 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1987 12:00:00 AM | Permit Number 24409 | 6003616.13531823 | 2109713.3650038997 | 37.773075283639706 | -122.430914560979 | (37.7730752836397, -122.430914560979) | ||
| 88787 | 88787 | 93236 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004223.0 | 2105723.0 | 37.762153071666496 | -122.428530853207 | (37.7621530716665, -122.428530853207) | ||
| 89343 | 89343 | 36994 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39614 | 6009898.14777577 | 2102820.5904951002 | 37.754503234678005 | -122.408697833051 | (37.754503234678, -122.408697833051) | ||
| 89601 | 89601 | 35493 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38903 | 6005339.71347882 | 2104322.52965211 | 37.7583708422124 | -122.42456893980601 | (37.7583708422124, -122.424568939806) | ||
| 89626 | 89626 | 91193 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 402 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | 3x3 | 6004165.42779 | 2109456.3421 | 37.772400669344705 | -122.428996160396 | (37.7724006693447, -122.428996160396) | ||
| 89783 | 89783 | 91200 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 482 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6003865.9067400005 | 2109457.56257 | 37.7723870617714 | -122.43003231905001 | (37.7723870617714, -122.43003231905) | ||
| 90135 | 90135 | 93237 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 576 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004202.7 | 2105545.3 | 37.76166400108121 | -122.428588395846 | (37.7616640010812, -122.428588395846) | ||
| 90363 | 90363 | 105778 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 BRADY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.772566058604205 | -122.420171254703 | (37.7725660586042, -122.420171254703) | |
| 90775 | 90775 | 93305 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 489 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004284.5 | 2106064.7 | 37.7630947783555 | -122.42834250308701 | (37.7630947783555, -122.428342503087) | ||
| 91292 | 91292 | 50559 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/2003 12:00:00 AM | Permit Number 47181 | 6003055.27396348 | 2109235.82329281 | 37.7717322771379 | -122.43282052857 | (37.7717322771379, -122.43282052857) | ||
| 91318 | 91318 | 44081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2000 12:00:00 AM | Permit Number 43602 | 5998965.98666911 | 2107110.22903087 | 37.765663155156105 | -122.44681260549 | (37.7656631551561, -122.44681260549) | |||
| 91452 | 91452 | 48986 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 372 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46173 | 6004094.60882476 | 2100160.1254271 | 37.7468714608035 | -122.428578362797 | (37.7468714608035, -122.428578362797) | ||
| 91782 | 91782 | 93313 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 241 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004184.0 | 2107469.0 | 37.766944961369 | -122.428790215647 | (37.766944961369, -122.428790215647) | ||
| 91795 | 91795 | 6840 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1469 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016172.0 | 2097718.0 | 37.740841972016504 | -122.386645216998 | (37.7408419720165, -122.386645216998) | ||
| 91972 | 91972 | 93314 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 227 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004180.0 | 2107540.0 | 37.7671396838414 | -122.42880911313999 | (37.7671396838414, -122.42880911314) | ||
| 93737 | 93737 | 91220 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 401 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6004167.50456 | 2109371.06405 | 37.7721666341778 | -122.428982895538 | (37.7721666341778, -122.428982895538) | ||
| 94224 | 94224 | 91199 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 460 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 6003924.61561 | 2109422.82576 | 37.7722950077597 | -122.429826761418 | (37.7722950077597, -122.429826761418) | ||
| 94475 | 94475 | 91197 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 3 | 3x3 | 6003996.812969999 | 2109443.98025 | 37.772357180985 | -122.429578533241 | (37.772357180985, -122.429578533241) |
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");