Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46563 | 46563 | 221509 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004439.440880001 | 2096038.0117799998 | 37.735572586401894 | -122.42709240931102 | (37.7355725864019, -122.427092409311) | ||||
| 67739 | 67739 | 187784 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014258.31464 | 2106694.98019 | 37.765384711161104 | -122.393890307196 | (37.7653847111611, -122.393890307196) | ||||
| 76798 | 76798 | 187783 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014314.48936 | 2106550.7653 | 37.764991850418895 | -122.393685915597 | (37.7649918504189, -122.393685915597) | ||||
| 171233 | 171233 | 221443 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005451.42839 | 2107920.02985 | 37.7682550341586 | -122.42443846228599 | (37.7682550341586, -122.424438462286) | |||
| 29150 | 29150 | 221508 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004291.813569999 | 2095940.5809 | 37.73529671397821 | -122.427595874056 | (37.7352967139782, -122.427595874056) | ||||
| 67326 | 67326 | 221557 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.42305441913099 | (37.7537703032837, -122.423054419131) | |||
| 148926 | 148926 | 221442 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005450.9028900005 | 2107942.8086599996 | 37.768317549645 | -122.42444190036699 | (37.768317549645, -122.424441900367) | |||
| 133864 | 133864 | 221441 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005450.56053 | 2107974.49254 | 37.768404526663396 | -122.424445338474 | (37.7684045266634, -122.424445338474) | |||
| 180267 | 180267 | 221556 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.42306215689501 | (37.753875475376, -122.423062156895) | |||
| 181350 | 181350 | 187782 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014325.58247 | 2106437.08289 | 37.764680319857995 | -122.39363958970199 | (37.764680319858, -122.393639589702) | ||||
| 4437 | 4437 | 221480 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:03:00 AM | 1 | Width 3ft | 6005548.13055 | 2106148.7780400002 | 37.7633970583515 | -122.423978006683 | (37.7633970583515, -122.423978006683) | ||
| 42902 | 42902 | 221440 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005447.60224 | 2108007.88033 | 37.7684960344855 | -122.424457946087 | (37.7684960344855, -122.424457946087) | |||
| 93719 | 93719 | 110771 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:10:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 100063 | 100063 | 110650 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:03:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 141015 | 141015 | 110784 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:11:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 150263 | 150263 | 221520 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005805.491090001 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | |||
| 159086 | 159086 | 221493 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.42381549380801 | (37.7617917972666, -122.423815493808) | |||
| 178254 | 178254 | 221510 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005838.80296 | 2100921.0233299998 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | |||
| 182798 | 182798 | 221555 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | |||
| 4340 | 4340 | 221479 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/28/2015 07:46:00 PM | 1 | Width 3ft | 6005545.66803 | 2106187.37905 | 37.7635029085615 | -122.42398926890199 | (37.7635029085615, -122.423989268902) | ||
| 4413 | 4413 | 221467 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:14:00 AM | 1 | Width 3ft | 6005513.55753 | 2106751.9184 | 37.765051186799 | -122.424140480012 | (37.765051186799, -122.424140480012) | ||
| 5127 | 5127 | 152423 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.758591964470895 | -122.423518008854 | (37.7585919644709, -122.423518008854) | |||
| 42667 | 42667 | 221530 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 3ft | 6005772.5167 | 2102115.11175 | 37.75233421815221 | -122.422915228372 | (37.7523342181522, -122.422915228372) | |||
| 47104 | 47104 | 221492 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005579.45797 | 2105601.3239599997 | 37.761895647375205 | -122.42383072560301 | (37.7618956473752, -122.423830725603) | |||
| 48680 | 48680 | 221505 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.760179131174795 | -122.423662162075 | (37.7601791311748, -122.423662162075) | |||
| 76663 | 76663 | 221554 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005736.5559 | 2102753.56312 | 37.754085228758505 | -122.423084962814 | (37.7540852287585, -122.423084962814) | |||
| 94846 | 94846 | 110770 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:14:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 110419 | 110419 | 109704 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 10:40:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 118657 | 118657 | 115521 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||||
| 120306 | 120306 | 110649 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/28/2015 07:46:00 PM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 134894 | 134894 | 221423 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005658.05131 | 2104209.2390900003 | 37.7580777456208 | -122.42345993152901 | (37.7580777456208, -122.423459931529) | |||
| 139744 | 139744 | 110783 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:16:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 151374 | 151374 | 221444 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005482.048359999 | 2107327.01142 | 37.766628476241294 | -122.42429036821301 | (37.7666284762413, -122.424290368213) | |||
| 159995 | 159995 | 221439 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005446.76573 | 2108031.65533 | 37.768561267704705 | -122.424462530821 | (37.7685612677047, -122.424462530821) | |||
| 182320 | 182320 | 221521 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005805.669319999 | 2101529.55059 | 37.7507282726947 | -122.422758971142 | (37.7507282726947, -122.422758971142) | |||
| 4316 | 4316 | 221478 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:18:00 AM | 1 | Width 3ft | 6005544.06849 | 2106215.1538 | 37.763579081143604 | -122.423996776447 | (37.7635790811436, -122.423996776447) | ||
| 4319 | 4319 | 221466 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:17:00 AM | 2 | Width 3ft | 6005511.21858 | 2106780.74139 | 37.7651301958204 | -122.42415061986601 | (37.7651301958204, -122.424150619866) | ||
| 4362 | 4362 | 221445 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 10:50:00 AM | 1 | Width 3ft | 6005479.31495 | 2107369.2041700003 | 37.7667441731271 | -122.424302823815 | (37.7667441731271, -122.424302823815) | ||
| 4487 | 4487 | 221504 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:05:00 PM | 2 | Width 3ft | 6005611.75297 | 2105011.45268 | 37.7602778227802 | -122.42367708812901 | (37.7602778227802, -122.423677088129) | ||
| 5168 | 5168 | 152422 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005644.9376300005 | 2104427.7274700003 | 37.7586769234173 | -122.423520817442 | (37.7586769234173, -122.423520817442) | |||
| 32093 | 32093 | 221522 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 3ft | 6005804.6365 | 2101559.54048 | 37.750810559762705 | -122.42276467376999 | (37.7508105597627, -122.42276467377) | |||
| 68227 | 68227 | 221553 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.111409999 | 2102791.4847 | 37.7541892146839 | -122.42309611170799 | (37.7541892146839, -122.423096111708) | |||
| 75610 | 75610 | 221438 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005446.19377 | 2108068.2932700003 | 37.7686618344154 | -122.42446711555901 | (37.7686618344154, -122.424467115559) | |||
| 86005 | 86005 | 110628 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:18:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 94270 | 94270 | 110769 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:17:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 97329 | 97329 | 115520 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 10:50:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
| 106423 | 106423 | 109703 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:05:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 121580 | 121580 | 110782 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:21:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 150449 | 150449 | 221531 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005769.92765 | 2102140.767 | 37.7524045154572 | -122.422926004956 | (37.7524045154572, -122.422926004956) | |||
| 179323 | 179323 | 221491 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005578.642000001 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | |||
| 185178 | 185178 | 221511 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.749211620932606 | -122.422616365666 | (37.7492116209326, -122.422616365666) | |||
| 773 | 773 | 221437 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.3361400003 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | ||
| 3111 | 3111 | 118355 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 3 | ||||||||
| 4359 | 4359 | 221446 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:45:00 AM | 1 | Width 3ft | 6005477.30623 | 2107402.8649 | 37.7668364840384 | -122.424312165974 | (37.7668364840384, -122.424312165974) | ||
| 4384 | 4384 | 221465 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:21:00 AM | 2 | Width 3ft | 6005511.348730001 | 2106807.4282299997 | 37.76520347889029 | -122.42415206777599 | (37.7652034788903, -122.424152067776) | ||
| 4419 | 4419 | 221477 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:29:00 AM | 1 | Width 3ft | 6005543.73868 | 2106251.90953 | 37.763679985054495 | -122.424000531101 | (37.7636799850545, -122.424000531101) | ||
| 4517 | 4517 | 221503 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | ||
| 5113 | 5113 | 152421 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | |||
| 66900 | 66900 | 221490 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | |||
| 81226 | 81226 | 110627 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:29:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 102576 | 102576 | 110781 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:26:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 105592 | 105592 | 115519 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:45:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
| 126939 | 126939 | 110768 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:21:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 144040 | 144040 | 109702 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:06:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 159464 | 159464 | 221532 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005770.103999999 | 2102168.30473 | 37.7524801376575 | -122.42292735211201 | (37.7524801376575, -122.422927352112) | |||
| 174460 | 174460 | 221422 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103001 | (37.7579289437835, -122.42344282103) | |||
| 176544 | 176544 | 221552 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.10722 | 2102815.94179 | 37.754256367947704 | -122.423097864468 | (37.7542563679477, -122.423097864468) | |||
| 182868 | 182868 | 221512 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005835.43443 | 2101000.02463 | 37.749275995297296 | -122.422618416129 | (37.7492759952973, -122.422618416129) | |||
| 737 | 737 | 221436 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.768836694985396 | -122.424492330751 | (37.7688366949854, -122.424492330751) | ||
| 4215 | 4215 | 118354 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 3 | ||||||||
| 4334 | 4334 | 221464 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:25:00 AM | 2 | Width 3ft | 6005509.872909999 | 2106837.4843200003 | 37.7652859224425 | -122.42415931 | (37.7652859224425, -122.42415931) | ||
| 4336 | 4336 | 221476 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 09:37:00 AM | 1 | Width 3ft | 6005539.0927099995 | 2106307.4884599997 | 37.7638323293302 | -122.42402055271799 | (37.7638323293302, -122.424020552718) | ||
| 4348 | 4348 | 221447 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:33:00 PM | 1 | Width 3ft | 6005477.00515 | 2107432.0079200002 | 37.7669164868187 | -122.424315280345 | (37.7669164868187, -122.424315280345) | ||
| 4481 | 4481 | 221502 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.760470912626296 | -122.42369608451 | (37.7604709126263, -122.42369608451) | ||
| 5118 | 5118 | 152420 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005641.8915099995 | 2104501.69931 | 37.7588798608311 | -122.42353661133998 | (37.7588798608311, -122.42353661134) | |||
| 41002 | 41002 | 221513 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.42263485302799 | (37.7494295931996, -122.422634853028) | |||
| 51561 | 51561 | 221489 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005574.236269999 | 2105711.57302 | 37.7621980705008 | -122.423856625205 | (37.7621980705008, -122.423856625205) | |||
| 81262 | 81262 | 110626 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 09:37:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 86793 | 86793 | 115518 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:33:00 PM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
| 107320 | 107320 | 109701 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:07:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 116936 | 116936 | 110767 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:25:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 124792 | 124792 | 110780 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:30:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 143107 | 143107 | 221551 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005731.5319 | 2102850.00284 | 37.7543497463656 | -122.423109191463 | (37.7543497463656, -122.423109191463) | |||
| 155282 | 155282 | 221421 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005663.971419999 | 2104121.3615 | 37.7578367884406 | -122.42343320997499 | (37.7578367884406, -122.423433209975) | |||
| 188083 | 188083 | 221533 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005767.42939 | 2102227.70946 | 37.75264309841 | -122.422940823082 | (37.75264309841, -122.422940823082) | |||
| 727 | 727 | 221435 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 1 | Width 3ft | 6005438.10251 | 2108158.21074 | 37.768908269319795 | -122.424501499347 | (37.7689082693198, -122.424501499347) | ||
| 1879 | 1879 | 221463 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/2017 12:00:00 AM | 3 | Width 3ft | 6005505.30672 | 2106900.54865 | 37.7654588242817 | -122.42417958883301 | (37.7654588242817, -122.424179588833) | ||
| 2766 | 2766 | 118353 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 3 | ||||||||
| 4326 | 4326 | 221448 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:52:00 PM | 1 | Width 3ft | 6005473.21673 | 2107488.5662700003 | 37.767071568632105 | -122.42433240701 | (37.7670715686321, -122.42433240701) | ||
| 4412 | 4412 | 221475 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:13:00 AM | 1 | Width 3ft | 6005538.26376 | 2106334.58706 | 37.763906688864495 | -122.42402534700001 | (37.7639066888645, -122.424025347) | ||
| 4526 | 4526 | 221501 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:08:00 PM | 2 | Width 3ft | 6005604.17413 | 2105138.97106 | 37.7606275304574 | -122.423712366728 | (37.7606275304574, -122.423712366728) | ||
| 5122 | 5122 | 152419 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005637.900330001 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | |||
| 25270 | 25270 | 221523 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005797.77147 | 2101666.82906 | 37.751104762181 | -122.42279603761101 | (37.751104762181, -122.422796037611) | |||
| 38301 | 38301 | 221488 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005571.71667 | 2105739.51079 | 37.7622746387822 | -122.42386732621999 | (37.7622746387822, -122.42386732622) | |||
| 73212 | 73212 | 221514 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005830.22915 | 2101083.18072 | 37.7495040291878 | -122.42264232458 | (37.7495040291878, -122.42264232458) | |||
| 80319 | 80319 | 115517 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:52:00 PM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
| 81008 | 81008 | 110625 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:13:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 92681 | 92681 | 109700 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:08:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 93547 | 93547 | 110779 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:35:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 99866 | 99866 | 110766 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:29:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) |
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");