Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63120 | 63120 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 109 | 1808 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.796275437823894 | -122.427440299436 | (37.7962754378239, -122.427440299436) | |||
787 | 787 | 221428 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.769467407522896 | -122.424551705821 | (37.7694674075229, -122.424551705821) | ||
745 | 745 | 221429 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:39:00 AM | 1 | Width 3ft | 6005428.96653 | 2108339.30361 | 37.76940499098671 | -122.424545983407 | (37.7694049909867, -122.424545983407) | ||
772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
766 | 766 | 221431 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 1 | Width 3ft | 6005433.2519 | 2108280.1340799998 | 37.769242767658 | -122.424526951068 | (37.769242767658, -122.424526951068) | ||
754 | 754 | 221432 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.769168602384205 | -122.42452243915301 | (37.7691686023842, -122.424522439153) | ||
733 | 733 | 221433 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 1 | Width 3ft | 6005435.4614 | 2108218.9893400003 | 37.7690750036386 | -122.42451495861201 | (37.7690750036386, -122.424514958612) | ||
759 | 759 | 221434 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 1 | Width 3ft | 6005437.11129 | 2108190.56795 | 37.7689970584876 | -122.42450722982001 | (37.7689970584876, -122.42450722982) | ||
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) | ||
184620 | 184620 | 221570 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.768688901296294 | -122.437411868978 | (37.7686889012963, -122.437411868978) | |||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
75755 | 75755 | 115513 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:41:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
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) | |||
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) | |||
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) | |||
98416 | 98416 | 115516 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||||
105439 | 105439 | 115510 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:55:00 PM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
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) | |||
106984 | 106984 | 115515 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:34:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
118209 | 118209 | 115511 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:48:00 PM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
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) | |||||
146089 | 146089 | 115514 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
4411 | 4411 | 221455 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:55:00 PM | 1 | Width 3ft | 6005458.8795300005 | 2107745.71785 | 37.7677768358576 | -122.424400289657 | (37.7677768358576, -122.424400289657) | ||
4371 | 4371 | 221454 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:48:00 PM | 1 | Width 3ft | 6005462.2492 | 2107712.58298 | 37.7676860457059 | -122.42438627731501 | (37.7676860457059, -122.424386277315) | ||
4392 | 4392 | 221453 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | ||
4420 | 4420 | 221452 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:41:00 AM | 1 | Width 3ft | 6005465.56003 | 2107641.57919 | 37.7674912732207 | -122.42436977475501 | (37.7674912732207, -122.424369774755) | ||
4377 | 4377 | 221451 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:36:00 AM | 1 | Width 3ft | 6005468.550009999 | 2107589.96825 | 37.76734973074429 | -122.424355761536 | (37.7673497307443, -122.424355761536) | ||
4431 | 4431 | 221450 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:34:00 AM | 1 | Width 3ft | 6005469.47774 | 2107557.31332 | 37.7672601204903 | -122.424350229795 | (37.7672601204903, -122.424350229795) | ||
25703 | 25703 | 221449 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005469.95975 | 2107527.1833200003 | 37.767177417921 | -122.42434641935499 | (37.767177417921, -122.424346419355) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |||
4373 | 4373 | 221456 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:59:00 AM | 2 | Width 3ft | 6005491.36744 | 2107155.48275 | 37.7661580255906 | -122.424245934501 | (37.7661580255906, -122.424245934501) | ||
4372 | 4372 | 221457 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:54:00 AM | 1 | Width 3ft | 6005492.07657 | 2107122.67642 | 37.766067987261295 | -122.42424114830798 | (37.7660679872613, -122.424241148308) | ||
4403 | 4403 | 221458 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:49:00 AM | 2 | Width 3ft | 6005493.2574 | 2107088.45627 | 37.7659740935515 | -122.424234630048 | (37.7659740935515, -122.424234630048) | ||
4381 | 4381 | 221459 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:45:00 AM | 3 | Width 3ft | 6005495.536040001 | 2107056.71588 | 37.7658870706576 | -122.424224491084 | (37.7658870706576, -122.424224491084) | ||
4332 | 4332 | 221460 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:41:00 AM | 2 | Width 3ft | 6005499.89777 | 2107004.0817 | 37.76574279600489 | -122.424205661071 | (37.7657427960049, -122.424205661071) | ||
4325 | 4325 | 221461 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:37:00 AM | 2 | Width 3ft | 6005500.86915 | 2106969.86586 | 37.7656489022957 | -122.42419986763399 | (37.7656489022957, -122.424199867634) | ||
82356 | 82356 | 110764 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:37:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
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) | ||
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) | ||
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) | ||
97820 | 97820 | 110763 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:41:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
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) | ||
101837 | 101837 | 110765 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:33:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
113542 | 113542 | 110761 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:49:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
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) | ||
121602 | 121602 | 110760 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:54:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
122606 | 122606 | 110762 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:45:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
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) | ||
140294 | 140294 | 110759 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:59:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
4338 | 4338 | 221462 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:33:00 AM | 1 | Width 3ft | 6005503.98521 | 2106938.10792 | 37.7655618784892 | -122.424186831055 | (37.7655618784892, -122.424186831055) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||||
4379 | 4379 | 221468 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:37:00 AM | 2 | Width 3ft | 6005525.86145 | 2106563.70328 | 37.764535087455 | -122.42408453767099 | (37.764535087455, -122.424084537671) | ||
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) | ||
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) | ||
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) | ||
85719 | 85719 | 110619 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:33:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
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) | ||
90408 | 90408 | 110621 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:27:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
91609 | 91609 | 110624 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:16:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
95136 | 95136 | 110618 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:37:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
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) | ||
104357 | 104357 | 110622 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
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) | ||
128230 | 128230 | 110620 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:30:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
129058 | 129058 | 110623 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:20:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
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) | ||||
4312 | 4312 | 221469 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:33:00 AM | 1 | 3x3 | 6005528.17729 | 2106528.83552 | 37.7644394796106 | -122.42407404799499 | (37.7644394796106, -122.424074047995) | ||
4354 | 4354 | 221470 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:30:00 AM | 1 | Width 3ft | 6005530.44166 | 2106496.00345 | 37.7643494583795 | -122.42406388114401 | (37.7643494583795, -122.424063881144) | ||
4370 | 4370 | 221471 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:27:00 AM | 1 | Width 3ft | 6005532.14271 | 2106464.3538900004 | 37.764262652233704 | -122.42405574678301 | (37.7642626522337, -122.424055746783) | ||
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) | ||||
4408 | 4408 | 221472 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 1 | Width 3ft | 6005534.310819999 | 2106426.8401 | 37.7641597706703 | -122.424045579956 | (37.7641597706703, -122.424045579956) | ||
4386 | 4386 | 221473 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:20:00 AM | 1 | Width 3ft | 6005534.54232 | 2106397.63335 | 37.764079588928496 | -122.424042702116 | (37.7640795889285, -122.424042702116) | ||
4416 | 4416 | 221474 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:16:00 AM | 1 | Width 3ft | 6005537.16302 | 2106367.52425 | 37.7639970644374 | -122.42403149656401 | (37.7639970644374, -122.424031496564) | ||
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) | ||
47711 | 47711 | 187781 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 101 Pennsylvania Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | ||||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
169767 | 169767 | 221481 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005557.328430001 | 2105982.39063 | 37.7629407171602 | -122.423934361684 | (37.7629407171602, -122.423934361684) | |||
169800 | 169800 | 221482 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005559.28434 | 2105952.19302 | 37.762857912083795 | -122.423925449408 | (37.7628579120838, -122.423925449408) | |||
115942 | 115942 | 221483 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005560.35948 | 2105916.5024900003 | 37.7627599750213 | -122.42391919281201 | (37.7627599750213, -122.423919192812) | |||
65305 | 65305 | 221484 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005563.22827 | 2105880.05418 | 37.7626600585326 | -122.42390667874399 | (37.7626600585326, -122.423906678744) |
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");