trees
339 rows where qSpecies_id = 30 sorted by YCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
| 189657 | 221428 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.7694674075229 | -122.424551705821 | (37.7694674075229, -122.424551705821) | 8 | 4 | 5 | 28853 | 19 | ||
| 45616 | 221429 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:39:00 AM | 1 | Width 3ft | 6005428.96653 | 2108339.30361 | 37.7694049909867 | -122.424545983407 | (37.7694049909867, -122.424545983407) | 8 | 4 | 5 | 28853 | 19 | ||
| 6153 | 221430 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | 8 | 4 | 5 | 28853 | 19 | ||
| 112729 | 221431 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:43:00 AM | 1 | Width 3ft | 6005433.2519 | 2108280.13408 | 37.769242767658 | -122.424526951068 | (37.769242767658, -122.424526951068) | 8 | 4 | 5 | 28853 | 19 | ||
| 85250 | 221432 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.7691686023842 | -122.424522439153 | (37.7691686023842, -122.424522439153) | 8 | 4 | 5 | 28853 | 19 | ||
| 35097 | 221433 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:32:00 AM | 1 | Width 3ft | 6005435.4614 | 2108218.98934 | 37.7690750036386 | -122.424514958612 | (37.7690750036386, -122.424514958612) | 8 | 4 | 5 | 28853 | 19 | ||
| 106689 | 221434 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:56:00 AM | 1 | Width 3ft | 6005437.11129 | 2108190.56795 | 37.7689970584876 | -122.42450722982 | (37.7689970584876, -122.42450722982) | 8 | 4 | 5 | 28853 | 19 | ||
| 5824 | 221435 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:58:00 AM | 1 | Width 3ft | 6005438.10251 | 2108158.21074 | 37.7689082693198 | -122.424501499347 | (37.7689082693198, -122.424501499347) | 8 | 4 | 5 | 28853 | 19 | ||
| 168740 | 221570 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.7686889012963 | -122.437411868978 | (37.7686889012963, -122.437411868978) | 15 | 5 | 5 | 29492 | 3 | |||
| 41302 | 221436 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.7688366949854 | -122.424492330751 | (37.7688366949854, -122.424492330751) | 8 | 4 | 5 | 28853 | 19 | ||
| 142195 | 221437 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.33614 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | 8 | 4 | 5 | 28853 | 19 | ||
| 108354 | 221438 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005446.19377 | 2108068.29327 | 37.7686618344154 | -122.424467115559 | (37.7686618344154, -122.424467115559) | 8 | 4 | 5 | 28853 | 19 | |||
| 137951 | 221439 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005446.76573 | 2108031.65533 | 37.7685612677047 | -122.424462530821 | (37.7685612677047, -122.424462530821) | 8 | 4 | 5 | 28853 | 19 | |||
| 52247 | 221440 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005447.60224 | 2108007.88033 | 37.7684960344855 | -122.424457946087 | (37.7684960344855, -122.424457946087) | 8 | 4 | 5 | 28853 | 19 | |||
| 109381 | 221441 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 14 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005450.56053 | 2107974.49254 | 37.7684045266634 | -122.424445338474 | (37.7684045266634, -122.424445338474) | 8 | 4 | 5 | 28853 | 19 | |||
| 117709 | 221442 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 15 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005450.90289 | 2107942.80866 | 37.768317549645 | -122.424441900367 | (37.768317549645, -122.424441900367) | 8 | 4 | 5 | 28853 | 19 | |||
| 154318 | 221443 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 16 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005451.42839 | 2107920.02985 | 37.7682550341586 | -122.424438462286 | (37.7682550341586, -122.424438462286) | 8 | 4 | 5 | 28853 | 19 | |||
| 31367 | 115513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 55166 | 115517 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:52:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 73685 | 115518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:33:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 80455 | 115520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/09/2016 10:50:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 101099 | 115516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
| 118820 | 115519 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:45:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 128664 | 115510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 131382 | 115515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 162604 | 115521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
| 169041 | 115511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 190513 | 115514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
| 162498 | 221455 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 1 | Width 3ft | 6005458.87953 | 2107745.71785 | 37.7677768358576 | -122.424400289657 | (37.7677768358576, -122.424400289657) | 8 | 4 | 5 | 28853 | 19 | ||
| 88305 | 221454 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 1 | Width 3ft | 6005462.2492 | 2107712.58298 | 37.7676860457059 | -122.424386277315 | (37.7676860457059, -122.424386277315) | 8 | 4 | 5 | 28853 | 19 | ||
| 142764 | 221453 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | 8 | 4 | 5 | 28853 | 19 | ||
| 171592 | 221452 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 1 | Width 3ft | 6005465.56003 | 2107641.57919 | 37.7674912732207 | -122.424369774755 | (37.7674912732207, -122.424369774755) | 8 | 4 | 5 | 28853 | 19 | ||
| 98181 | 221451 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 1 | Width 3ft | 6005468.55001 | 2107589.96825 | 37.7673497307443 | -122.424355761536 | (37.7673497307443, -122.424355761536) | 8 | 4 | 5 | 28853 | 19 | ||
| 187472 | 221450 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 1 | Width 3ft | 6005469.47774 | 2107557.31332 | 37.7672601204903 | -122.424350229795 | (37.7672601204903, -122.424350229795) | 8 | 4 | 5 | 28853 | 19 | ||
| 3421 | 221449 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005469.95975 | 2107527.18332 | 37.767177417921 | -122.424346419355 | (37.767177417921, -122.424346419355) | 8 | 4 | 5 | 28853 | 19 | |||
| 31053 | 221448 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:52:00 PM | 1 | Width 3ft | 6005473.21673 | 2107488.56627 | 37.7670715686321 | -122.42433240701 | (37.7670715686321, -122.42433240701) | 8 | 4 | 5 | 28853 | 19 | ||
| 71684 | 221447 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:33:00 PM | 1 | Width 3ft | 6005477.00515 | 2107432.00792 | 37.7669164868187 | -122.424315280345 | (37.7669164868187, -122.424315280345) | 8 | 4 | 5 | 28853 | 19 | ||
| 69768 | 221446 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:45:00 AM | 1 | Width 3ft | 6005477.30623 | 2107402.8649 | 37.7668364840384 | -122.424312165974 | (37.7668364840384, -122.424312165974) | 8 | 4 | 5 | 28853 | 19 | ||
| 67411 | 221445 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/09/2016 10:50:00 AM | 1 | Width 3ft | 6005479.31495 | 2107369.20417 | 37.7667441731271 | -122.424302823815 | (37.7667441731271, -122.424302823815) | 8 | 4 | 5 | 28853 | 19 | ||
| 126359 | 221444 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005482.04836 | 2107327.01142 | 37.7666284762413 | -122.424290368213 | (37.7666284762413, -122.424290368213) | 8 | 4 | 5 | 28853 | 19 | |||
| 12213 | 221456 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:59:00 AM | 2 | 3x3 | Permit Number 56125 | 6005491.36744 | 2107155.48275 | 37.7661580255906 | -122.424245934501 | (37.7661580255906, -122.424245934501) | 8 | 4 | 5 | 28853 | 19 | |
| 112321 | 221457 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:54:00 AM | 1 | Width 3ft | 6005492.07657 | 2107122.67642 | 37.7660679872613 | -122.424241148308 | (37.7660679872613, -122.424241148308) | 8 | 4 | 5 | 28853 | 19 | ||
| 154412 | 221458 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:49:00 AM | 2 | Width 3ft | 6005493.2574 | 2107088.45627 | 37.7659740935515 | -122.424234630048 | (37.7659740935515, -122.424234630048) | 8 | 4 | 5 | 28853 | 19 | ||
| 129525 | 221459 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:45:00 AM | 3 | Width 3ft | 6005495.53604 | 2107056.71588 | 37.7658870706576 | -122.424224491084 | (37.7658870706576, -122.424224491084) | 8 | 4 | 5 | 28853 | 19 | ||
| 10894 | 221460 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:41:00 AM | 2 | 3x3 | Permit Number 56125 | 6005499.89777 | 2107004.0817 | 37.7657427960049 | -122.424205661071 | (37.7657427960049, -122.424205661071) | 8 | 4 | 5 | 28853 | 19 | |
| 23245 | 221461 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:37:00 AM | 2 | Width 3ft | 6005500.86915 | 2106969.86586 | 37.7656489022957 | -122.424199867634 | (37.7656489022957, -122.424199867634) | 8 | 4 | 5 | 28853 | 19 | ||
| 24729 | 110768 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:21:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 50290 | 110764 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:37:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 77201 | 110769 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:17:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 82341 | 110771 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 13 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:10:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 83735 | 110770 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:14:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 98754 | 110766 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:29:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 102626 | 110765 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:33:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 104966 | 110763 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:41:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 135342 | 110761 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:49:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 158366 | 110767 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:25:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 166262 | 110762 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:45:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 170287 | 110760 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:54:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 176441 | 110759 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:59:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
| 27676 | 221462 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:33:00 AM | 1 | Width 3ft | 6005503.98521 | 2106938.10792 | 37.7655618784892 | -122.424186831055 | (37.7655618784892, -122.424186831055) | 8 | 4 | 5 | 28853 | 19 | ||
| 175781 | 221463 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 06/08/2017 12:00:00 AM | 3 | Width 3ft | 6005505.30672 | 2106900.54865 | 37.7654588242817 | -122.424179588833 | (37.7654588242817, -122.424179588833) | 8 | 4 | 5 | 28853 | 19 | ||
| 53571 | 221464 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:25:00 AM | 2 | Width 3ft | 6005509.87291 | 2106837.48432 | 37.7652859224425 | -122.42415931 | (37.7652859224425, -122.42415931) | 8 | 4 | 5 | 28853 | 19 | ||
| 129550 | 221465 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:21:00 AM | 2 | Width 3ft | 6005511.34873 | 2106807.42823 | 37.7652034788903 | -122.424152067776 | (37.7652034788903, -122.424152067776) | 8 | 4 | 5 | 28853 | 19 | ||
| 20744 | 221466 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:17:00 AM | 2 | Width 3ft | 6005511.21858 | 2106780.74139 | 37.7651301958204 | -122.424150619866 | (37.7651301958204, -122.424150619866) | 8 | 4 | 5 | 28853 | 19 | ||
| 16547 | 221467 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:14:00 AM | 1 | 3x3 | Permit Number 56125 | 6005513.55753 | 2106751.9184 | 37.765051186799 | -122.424140480012 | (37.765051186799, -122.424140480012) | 8 | 4 | 5 | 28853 | 19 | |
| 11084 | 187784 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 35 | Front Yard : Yard | Tree | Private 2 | 4 | 6014258.31464 | 2106694.98019 | 37.7653847111611 | -122.393890307196 | (37.7653847111611, -122.393890307196) | 14 | 3 | 8 | 28856 | 20 | ||||
| 119683 | 221468 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:37:00 AM | 2 | Width 3ft | 6005525.86145 | 2106563.70328 | 37.764535087455 | -122.424084537671 | (37.764535087455, -122.424084537671) | 8 | 4 | 5 | 28859 | 19 | ||
| 36635 | 110623 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:20:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 36834 | 110620 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:30:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 42708 | 110627 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:29:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 47290 | 110626 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 04/29/2015 09:37:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 52461 | 110625 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:13:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 62248 | 110628 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:18:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 65226 | 110621 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:27:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 66601 | 110619 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:33:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 87178 | 110624 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:16:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 94186 | 110618 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:37:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 112749 | 110650 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 13 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:03:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 132204 | 110622 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:24:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 156993 | 110649 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 04/28/2015 07:46:00 PM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 60003 | 187783 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 26 | Front Yard : Yard | Tree | Private 2 | 4 | 6014314.48936 | 2106550.7653 | 37.7649918504189 | -122.393685915597 | (37.7649918504189, -122.393685915597) | 14 | 3 | 8 | 310 | 29 | ||||
| 12077 | 221469 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:33:00 AM | 1 | 3x3 | 6005528.17729 | 2106528.83552 | 37.7644394796106 | -122.424074047995 | (37.7644394796106, -122.424074047995) | 8 | 4 | 5 | 28859 | 19 | ||
| 1516 | 221470 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:30:00 AM | 1 | 3x3 | Permit Number 56125 | 6005530.44166 | 2106496.00345 | 37.7643494583795 | -122.424063881144 | (37.7643494583795, -122.424063881144) | 8 | 4 | 5 | 28859 | 19 | |
| 94976 | 221471 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:27:00 AM | 1 | Width 3ft | 6005532.14271 | 2106464.35389 | 37.7642626522337 | -122.424055746783 | (37.7642626522337, -122.424055746783) | 8 | 4 | 5 | 28859 | 19 | ||
| 135542 | 187782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 14 | Front Yard : Yard | Tree | Private 2 | 1 | 6014325.58247 | 2106437.08289 | 37.764680319858 | -122.393639589702 | (37.764680319858, -122.393639589702) | 14 | 3 | 8 | 310 | 29 | ||||
| 159617 | 221472 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:24:00 AM | 1 | Width 3ft | 6005534.31082 | 2106426.8401 | 37.7641597706703 | -122.424045579956 | (37.7641597706703, -122.424045579956) | 8 | 4 | 5 | 28859 | 19 | ||
| 119880 | 221473 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:20:00 AM | 1 | Width 3ft | 6005534.54232 | 2106397.63335 | 37.7640795889285 | -122.424042702116 | (37.7640795889285, -122.424042702116) | 8 | 4 | 5 | 28859 | 19 | ||
| 169286 | 221474 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:16:00 AM | 1 | Width 3ft | 6005537.16302 | 2106367.52425 | 37.7639970644374 | -122.424031496564 | (37.7639970644374, -122.424031496564) | 8 | 4 | 5 | 28859 | 19 | ||
| 167540 | 221475 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:13:00 AM | 1 | Width 3ft | 6005538.26376 | 2106334.58706 | 37.7639066888645 | -122.424025347 | (37.7639066888645, -122.424025347) | 8 | 4 | 5 | 28859 | 19 | ||
| 28021 | 187781 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | 14 | 3 | 8 | 310 | 29 | ||||
| 44481 | 221476 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 04/29/2015 09:37:00 AM | 1 | Width 3ft | 6005539.09271 | 2106307.48846 | 37.7638323293302 | -122.424020552718 | (37.7638323293302, -122.424020552718) | 8 | 4 | 5 | 28859 | 19 | ||
| 175672 | 221477 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:29:00 AM | 1 | Width 3ft | 6005543.73868 | 2106251.90953 | 37.7636799850545 | -122.424000531101 | (37.7636799850545, -122.424000531101) | 8 | 4 | 5 | 28859 | 19 | ||
| 12484 | 221478 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:18:00 AM | 1 | 3x3 | Permit Number 56125 | 6005544.06849 | 2106215.1538 | 37.7635790811436 | -122.423996776447 | (37.7635790811436, -122.423996776447) | 8 | 4 | 5 | 28859 | 19 | |
| 47327 | 221479 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 04/28/2015 07:46:00 PM | 1 | Width 3ft | 6005545.66803 | 2106187.37905 | 37.7635029085615 | -122.423989268902 | (37.7635029085615, -122.423989268902) | 8 | 4 | 5 | 28859 | 19 | ||
| 193830 | 221480 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:03:00 AM | 1 | Width 3ft | 6005548.13055 | 2106148.77804 | 37.7633970583515 | -122.423978006683 | (37.7633970583515, -122.423978006683) | 8 | 4 | 5 | 28859 | 19 | ||
| 5169 | 221481 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005557.32843 | 2105982.39063 | 37.7629407171602 | -122.423934361684 | (37.7629407171602, -122.423934361684) | 8 | 4 | 5 | 28859 | 19 | ||
| 155313 | 221482 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005559.28434 | 2105952.19302 | 37.7628579120838 | -122.423925449408 | (37.7628579120838, -122.423925449408) | 8 | 4 | 5 | 28859 | 19 | |||
| 99261 | 221483 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005560.35948 | 2105916.50249 | 37.7627599750213 | -122.423919192812 | (37.7627599750213, -122.423919192812) | 8 | 4 | 5 | 28859 | 19 | |||
| 85750 | 221484 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005563.22827 | 2105880.05418 | 37.7626600585326 | -122.423906678744 | (37.7626600585326, -122.423906678744) | 8 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );