Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 71808 | 71808 | 190649 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1164 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6014097.05519 | 2105748.35032 | 37.7627765099393 | -122.394381783993 | (37.7627765099393, -122.394381783993) | |||
| 105119 | 105119 | 93303 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236.0 | 2105969.0 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | ||
| 139363 | 139363 | 93304 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236.0 | 2105969.0 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | ||
| 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) | |||
| 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) | ||
| 118603 | 118603 | 35763 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3321 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558786999 | (37.7633323895219, -122.41994558787) | ||
| 127481 | 127481 | 35764 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3321 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558786999 | (37.7633323895219, -122.41994558787) | ||
| 140879 | 140879 | 93306 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 465 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004251.0 | 2106168.0 | 37.7633765197798 | -122.428465731621 | (37.7633765197798, -122.428465731621) | ||
| 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) | ||
| 141131 | 141131 | 93307 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 445 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 07:00:00 AM | 3 | 3x3 | 6004245.0 | 2106273.0 | 37.763664485103895 | -122.42849396833701 | (37.7636644851039, -122.428493968337) | ||
| 30267 | 30267 | 228488 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008610.437969999 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | |||
| 40043 | 40043 | 228498 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 450 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6004181.58169 | 2106402.65123 | 37.764016887284704 | -122.42872255552 | (37.7640168872847, -122.42872255552) | |||
| 68672 | 68672 | 228487 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.764069559682206 | -122.41325481347401 | (37.7640695596822, -122.413254813474) | |||
| 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) | |||
| 166771 | 166771 | 228450 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.764209660560205 | -122.41109273536699 | (37.7642096605602, -122.411092735367) | |||
| 160222 | 160222 | 228451 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009297.41402 | 2106368.8801700003 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | |||
| 153175 | 153175 | 228452 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009318.2366 | 2106370.18067 | 37.7642171069559 | -122.41095401853799 | (37.7642171069559, -122.410954018538) | |||
| 73664 | 73664 | 228453 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.41088209075899 | (37.7642218454873, -122.410882090759) | |||
| 149630 | 149630 | 228454 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009362.10361 | 2106372.48972 | 37.7642259068175 | -122.410802457572 | (37.7642259068175, -122.410802457572) | |||
| 56231 | 56231 | 228455 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009383.67351 | 2106374.02164 | 37.7642313225287 | -122.410727961341 | (37.7642313225287, -122.410727961341) | |||
| 57920 | 57920 | 228456 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009403.2734199995 | 2106375.12773 | 37.7642354585115 | -122.410660248687 | (37.7642354585115, -122.410660248687) | |||
| 188130 | 188130 | 228457 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009423.8763 | 2106376.9257400003 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) | |||
| 56576 | 56576 | 228499 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 38 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000241.54312 | 2106649.97851 | 37.764472207742294 | -122.442367702717 | (37.7644722077423, -122.442367702717) | |||
| 113551 | 113551 | 39284 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 142789 | 142789 | 39301 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 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) | |||
| 140863 | 140863 | 36113 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39210 | 5991731.11313688 | 2106919.21929981 | 37.764722731307394 | -122.47182229152901 | (37.7647227313074, -122.471822291529) | ||
| 157193 | 157193 | 228478 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 99 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998158.0059 | 2106821.83124 | 37.7648250972209 | -122.44958643847299 | (37.7648250972209, -122.449586438473) | |||
| 123137 | 123137 | 67115 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1000 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1992 12:00:00 AM | Permit Number 30534 | 5998132.38450691 | 2106832.35950645 | 37.764852539386894 | -122.449675814605 | (37.7648525393869, -122.449675814605) | ||
| 80305 | 80305 | 32927 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1550 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 136455 | 136455 | 228479 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998955.25722 | 2107101.1921200003 | 37.7656377291263 | -122.446849065839 | (37.7656377291263, -122.446849065839) | |||
| 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) | |||
| 122875 | 122875 | 44082 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 2 | 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) | |||
| 159768 | 159768 | 228465 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 321 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004210.24642 | 2107036.07535 | 37.7657577400449 | -122.42866856921101 | (37.7657577400449, -122.428668569211) | |||
| 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) | |||
| 167042 | 167042 | 228432 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004140.61494 | 2107068.90552 | 37.7658439427747 | -122.42891175039301 | (37.7658439427747, -122.428911750393) | |||
| 186641 | 186641 | 228467 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004207.05311 | 2107076.17172 | 37.7658676543027 | -122.428682472728 | (37.7658676543027, -122.428682472728) | |||
| 112069 | 112069 | 93308 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 315 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2015 01:54:00 PM | 3 | 3x3 | 6004205.0 | 2107085.0 | 37.7658917784387 | -122.428690203394 | (37.7658917784387, -122.428690203394) | ||
| 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) | |||
| 183998 | 183998 | 228468 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 305 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004204.63343 | 2107110.4699 | 37.765961691906796 | -122.42869328709101 | (37.7659616919068, -122.428693287091) | |||
| 143858 | 143858 | 93234 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 306 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | ||
| 143449 | 143449 | 93309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6004203.0 | 2107120.0 | 37.7659877668224 | -122.428699616217 | (37.7659877668224, -122.428699616217) | ||
| 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) | ||
| 102377 | 102377 | 93232 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004136.0 | 2107205.0 | 37.766217364214604 | -122.42893741621 | (37.7662173642146, -122.42893741621) | ||
| 96195 | 96195 | 122809 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 105341 | 105341 | 122811 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 146097 | 146097 | 122810 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 101754 | 101754 | 36675 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1815 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 15 | 3x3 | Permit Number 39480 | 6005408.20742805 | 2107215.17723629 | 37.7663172364539 | -122.42453781561001 | (37.7663172364539, -122.42453781561) | |
| 155900 | 155900 | 228461 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005355.14245 | 2107219.1964 | 37.766325275216296 | -122.424721643507 | (37.7663252752163, -122.424721643507) | |||
| 159222 | 159222 | 228434 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004130.46793 | 2107245.14017 | 37.7663272663153 | -122.428959412666 | (37.7663272663153, -122.428959412666) | |||
| 83968 | 83968 | 49189 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 301 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46293 | 6005519.89358109 | 2107236.54938111 | 37.7663822259368 | -122.424153033894 | (37.7663822259368, -122.424153033894) | |||
| 179503 | 179503 | 228469 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 251 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004187.68386 | 2107403.8081400003 | 37.766766168745896 | -122.428772825825 | (37.7667661687459, -122.428772825825) | |||
| 100180 | 100180 | 93311 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 253 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004187.0 | 2107409.0 | 37.766780385636395 | -122.428775561342 | (37.7667803856364, -122.428775561342) | ||
| 168299 | 168299 | 228470 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004187.12028 | 2107418.48366 | 37.766806432287 | -122.42877582146299 | (37.766806432287, -122.428775821463) | |||
| 104608 | 104608 | 93312 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004185.0 | 2107449.0 | 37.7668901027922 | -122.428785330871 | (37.7668901027922, -122.428785330871) | ||
| 155607 | 155607 | 228471 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 237 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004185.6843 | 2107453.8801 | 37.7669035410995 | -122.428783311922 | (37.7669035410995, -122.428783311922) | |||
| 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) | ||
| 116747 | 116747 | 61667 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 235 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/2016 12:00:00 AM | 3 | Permit Number 777577 | 6004178.04494694 | 2107496.55994699 | 37.7670202972864 | -122.42881277819099 | (37.7670202972864, -122.428812778191) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 168166 | 168166 | 228462 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.768304778378294 | -122.418472926402 | (37.7683047783783, -122.418472926402) | |||
| 132350 | 132350 | 228436 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004092.7276 | 2107966.58323 | 37.768306038331794 | -122.42914139496 | (37.7683060383318, -122.42914139496) | |||
| 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) | ||
| 120948 | 120948 | 93230 | 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 | 3 | 3x3 | 6004092.0 | 2108018.0 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | ||
| 145340 | 145340 | 93231 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092.0 | 2108018.0 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | ||
| 21376 | 21376 | 29881 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6006056.280590001 | 2108026.10587 | 37.7685804313738 | -122.42235387246001 | (37.7685804313738, -122.42235387246) | |||
| 173298 | 173298 | 228431 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006055.135530001 | 2108039.7727 | 37.7686178926417 | -122.42235880430799 | (37.7686178926417, -122.422358804308) | |||
| 105905 | 105905 | 29880 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3x3 | 6006057.16025 | 2108040.46288 | 37.76861990192471 | -122.42235185 | (37.7686199019247, -122.42235185) | ||
| 154443 | 154443 | 245065 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1150 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000577.9392 | 2108943.6108 | 37.7707891181366 | -122.441368793683 | (37.7707891181366, -122.441368793683) | |||
| 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) | ||
| 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) | |||
| 94980 | 94980 | 49194 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 107014 | 107014 | 49199 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 109938 | 109938 | 49193 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 111515 | 111515 | 49197 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 113150 | 113150 | 49190 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 113347 | 113347 | 49191 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 115581 | 115581 | 49195 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 126223 | 126223 | 49196 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 127802 | 127802 | 49192 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 140076 | 140076 | 49200 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 3x3 | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |
| 182749 | 182749 | 228503 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007243.83648 | 2109064.60146 | 37.7714988123571 | -122.418319846488 | (37.7714988123571, -122.418319846488) | |||
| 115984 | 115984 | 10311 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 657 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1999 12:00:00 AM | 8 | 3X3 | 6003004.4895 | 2109163.37188 | 37.7715304629462 | -122.43299101798401 | (37.7715304629462, -122.432991017984) | ||
| 148748 | 148748 | 246382 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006956.341 | 2109096.7729 | 37.77157095990471 | -122.41931659334999 | (37.7715709599047, -122.41931659335) | |||
| 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) | ||
| 152814 | 152814 | 247323 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 752 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002559.2743 | 2109218.8363 | 37.771657491274205 | -122.434535006264 | (37.7716574912742, -122.434535006264) | |||
| 156077 | 156077 | 246383 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006970.497 | 2109128.1185 | 37.771657824727 | -122.419269850794 | (37.771657824727, -122.419269850794) | |||
| 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) | ||
| 120939 | 120939 | 10320 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 758 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1992 12:00:00 AM | 25 | 3X3 | 6002531.73322 | 2109228.96362 | 37.771683734938996 | -122.43463099668699 | (37.771683734939, -122.434630996687) | ||
| 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) | ||
| 19533 | 19533 | 25491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003026.26997 | 2109233.55885 | 37.7717244144917 | -122.43292069334998 | (37.7717244144917, -122.43292069335) | ||
| 42373 | 42373 | 246384 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006982.6308 | 2109153.3972 | 37.7717279173795 | -122.419229672629 | (37.7717279173795, -122.419229672629) | |||
| 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) | ||
| 23175 | 23175 | 25492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 645 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2001 12:00:00 AM | 5 | 3X3 | 6003043.5783 | 2109236.3656 | 37.7717331028377 | -122.43286102333299 | (37.7717331028377, -122.432861023333) | ||
| 117982 | 117982 | 91221 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 597 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 3x3 | 6003327.2605 | 2109254.11842 | 37.7717979333979 | -122.431881016883 | (37.7717979333979, -122.431881016883) | ||
| 56739 | 56739 | 246385 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006994.7646 | 2109179.687 | 37.7718007862576 | -122.419189566122 | (37.7718007862576, -122.419189566122) | |||
| 105139 | 105139 | 91222 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 589 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 3 | 6003354.82967 | 2109257.95569 | 37.7718100324239 | -122.43178592736099 | (37.7718100324239, -122.431785927361) | |||
| 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) |
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");