trees
339 rows where qSpecies_id = 30 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8268 | 221535 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005763.23809 | 2102308.0919 | 37.7528635735186 | -122.422961029952 | (37.7528635735186, -122.422961029952) | 2 | 4 | 5 | 28859 | 19 | ||
8628 | 221426 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005693.61577 | 2103548.60767 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | 2 | 4 | 5 | 28859 | 19 | ||
8919 | 91244 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 852x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:21:00 AM | 3 | 6005625 | 2104006 | 37.7575178330554 | -122.423559787953 | (37.7575178330554, -122.423559787953) | 2 | 4 | 5 | 28859 | 19 | |||
9030 | 221418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353201 | -122.423415847665 | (37.757466353201, -122.423415847665) | 2 | 4 | 5 | 28859 | 19 | ||
9125 | 240676 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005837.06183 | 2100943.32688 | 37.7491204080812 | -122.42260876008 | (37.7491204080812, -122.42260876008) | 2 | 4 | 5 | 28859 | 19 | ||
9435 | 221556 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 14 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.423062156895 | (37.753875475376, -122.423062156895) | 2 | 4 | 5 | 28859 | 19 | ||
10217 | 240681 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005788.04336 | 2101855.46027 | 37.751622151155 | -122.422843082969 | (37.751622151155, -122.422843082969) | 2 | 4 | 5 | 28859 | 19 | ||
10432 | 221544 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005705.62338 | 2103333.32509 | 37.7556753749283 | -122.423233144119 | (37.7556753749283, -122.423233144119) | 2 | 4 | 5 | 28859 | 19 | ||
11768 | 221543 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640819 | (37.7556029507207, -122.42322640819) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
12356 | 152416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005631.99539 | 2104658.58909 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | 2 | 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 | |
13182 | 243321 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005700.91818 | 2103420.38667 | 37.7559141602344 | -122.423255604682 | (37.7559141602344, -122.423255604682) | 2 | 4 | 5 | 28859 | 19 | ||
13462 | 240682 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005773.46778 | 2102086.45101 | 37.7522555760398 | -122.422909902588 | (37.7522555760398, -122.422909902588) | 2 | 4 | 5 | 28859 | 19 | ||
13699 | 152413 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005625.07408 | 2104777.98262 | 37.7596375207611 | -122.423614417069 | (37.7596375207611, -122.423614417069) | 2 | 4 | 5 | 28859 | 19 | |||
13786 | 221552 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.10722 | 2102815.94179 | 37.7542563679477 | -122.423097864468 | (37.7542563679477, -122.423097864468) | 2 | 4 | 5 | 28859 | 19 | ||
14715 | 221546 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005723.96055 | 2103030.09242 | 37.7548438033068 | -122.423148175257 | (37.7548438033068, -122.423148175257) | 2 | 4 | 5 | 28859 | 19 | ||
15879 | 221486 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | 8 | 4 | 5 | 28859 | 19 | ||
15920 | 221557 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 15 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.423054419131 | (37.7537703032837, -122.423054419131) | 2 | 4 | 5 | 28859 | 19 | ||
17216 | 240679 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005802.65315 | 2101583.39169 | 37.7508759377955 | -122.422773227227 | (37.7508759377955, -122.422773227227) | 2 | 4 | 5 | 28859 | 19 | ||
18001 | 243333 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005703.0197 | 2103377.21002 | 37.7557957257993 | -122.423245267872 | (37.7557957257993, -122.423245267872) | 2 | 4 | 5 | 28859 | 19 | ||
18108 | 221419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005664.4202 | 2104015.71487 | 37.7575467328056 | -122.423424147502 | (37.7575467328056, -122.423424147502) | 2 | 4 | 5 | 28859 | 19 | ||
18986 | 221548 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005727.07279 | 2102965.97894 | 37.7546679382008 | -122.423132855309 | (37.7546679382008, -122.423132855309) | 2 | 4 | 5 | 28859 | 19 | ||
19567 | 109693 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
20283 | 221522 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6005804.6365 | 2101559.54048 | 37.7508105597627 | -122.42276467377 | (37.7508105597627, -122.42276467377) | 2 | 4 | 5 | 28859 | 19 | |||
21108 | 243241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005660.54217 | 2104179.64824 | 37.7579966366535 | -122.423449213415 | (37.7579966366535, -122.423449213415) | 2 | 4 | 5 | 28859 | 19 | |||
22666 | 221560 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898 | (37.7534669142699, -122.42159904898) | 2 | 4 | 5 | 28859 | 19 | |||
26192 | 109695 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 02/21/2015 12:00:00 AM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
26579 | 221545 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005721.87722 | 2103062.70747 | 37.7549332390947 | -122.423157698184 | (37.7549332390947, -122.423157698184) | 2 | 4 | 5 | 28859 | 19 | |||
27720 | 221540 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005754.92272 | 2102467.80763 | 37.753301646771 | -122.423001136993 | (37.753301646771, -122.423001136993) | 2 | 4 | 5 | 28859 | 19 | |||
29061 | 221538 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005757.68157 | 2102409.38047 | 37.7531413749784 | -122.422987443927 | (37.7531413749784, -122.422987443927) | 2 | 4 | 5 | 28859 | 19 | |||
29249 | 221506 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005698.11962 | 2103476.06965 | 37.7560668947992 | -122.423269241105 | (37.7560668947992, -122.423269241105) | 2 | 4 | 5 | 28859 | 19 | |||
30628 | 110780 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:30:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
31806 | 221488 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005571.71667 | 2105739.51079 | 37.7622746387822 | -122.42386732622 | (37.7622746387822, -122.42386732622) | 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 | ||
38198 | 91254 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 928x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.979082 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | 2 | 4 | 5 | 28859 | 19 | ||
38474 | 243239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005667.36599 | 2103954.71663 | 37.7573794121443 | -122.423409623453 | (37.7573794121443, -122.423409623453) | 2 | 4 | 5 | 28859 | 19 | |||
40155 | 221518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.422678186848 | (37.7499423731511, -122.422678186848) | 2 | 4 | 5 | 28859 | 19 | |||
40660 | 221528 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005788.73132 | 2101828.76193 | 37.7515488824818 | -122.422838806667 | (37.7515488824818, -122.422838806667) | 2 | 4 | 5 | 28859 | 19 | |||
41721 | 110777 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:47:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
42106 | 221525 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005795.99168 | 2101720.64475 | 37.7512524272579 | -122.422806016491 | (37.7512524272579, -122.422806016491) | 2 | 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 | ||
43244 | 91259 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 952x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | 2 | 4 | 5 | 28859 | 19 | ||
44242 | 221415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005678.5014 | 2103825.14435 | 37.7570242653802 | -122.423361901832 | (37.7570242653802, -122.423361901832) | 2 | 4 | 5 | 28859 | 19 | |||
44318 | 91245 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 870x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005631 | 2103898 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
45188 | 221530 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6005772.5167 | 2102115.11175 | 37.7523342181522 | -122.422915228372 | (37.7523342181522, -122.422915228372) | 2 | 4 | 5 | 28859 | 19 | |||
45689 | 221513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.422634853028 | (37.7494295931996, -122.422634853028) | 2 | 4 | 5 | 28859 | 19 | |||
45759 | 221492 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005579.45797 | 2105601.32396 | 37.7618956473752 | -122.423830725603 | (37.7618956473752, -122.423830725603) | 8 | 4 | 5 | 28859 | 19 | |||
46202 | 152421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | 2 | 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 | ||
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 | ||
47649 | 91278 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
50929 | 91248 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 888x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | 6005668.887935 | 2103795.421709 | 37.7569421113624 | -122.423393035961 | (37.7569421113624, -122.423393035961) | 2 | 4 | 5 | 28859 | 19 | |||
51627 | 91264 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 978X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.521495 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | 2 | 4 | 5 | 28859 | 19 | ||
52094 | 152420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005641.89151 | 2104501.69931 | 37.7588798608311 | -122.42353661134 | (37.7588798608311, -122.42353661134) | 2 | 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 | ||
52768 | 110774 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
53870 | 110778 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:43:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
54019 | 91241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
54220 | 221505 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.7601791311748 | -122.423662162075 | (37.7601791311748, -122.423662162075) | 2 | 4 | 5 | 28859 | 19 | |||
57039 | 152414 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | 2 | 4 | 5 | 28859 | 19 | |||
57081 | 91242 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
57604 | 91292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1286x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005762 | 2101471 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | 2 | 4 | 5 | 28859 | 19 | |||
57813 | 91247 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 880x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:29:00 AM | 3 | 6005634 | 2103838 | 37.7570570522806 | -122.423516718678 | (37.7570570522806, -122.423516718678) | 2 | 4 | 5 | 28859 | 19 | |||
58618 | 152419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005637.90033 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | 2 | 4 | 5 | 28859 | 19 | |||
59561 | 109696 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
59581 | 91291 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1282x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005761 | 2101495 | 37.7506308843168 | -122.422910986406 | (37.7506308843168, -122.422910986406) | 2 | 4 | 5 | 28859 | 19 | |||
60014 | 221500 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 2 | Width 3ft | 6005602.08318 | 2105171.20834 | 37.7607159284129 | -122.423721890569 | (37.7607159284129, -122.423721890569) | 2 | 4 | 5 | 28859 | 19 | ||
61134 | 152423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.7585919644709 | -122.423518008854 | (37.7585919644709, -122.423518008854) | 2 | 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 | ||
62629 | 221502 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.7604709126263 | -122.42369608451 | (37.7604709126263, -122.42369608451) | 2 | 4 | 5 | 28859 | 19 | ||
63104 | 221529 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 3ft | 6005786.9094 | 2101880.52554 | 37.751690910628 | -122.422848785557 | (37.751690910628, -122.422848785557) | 2 | 4 | 5 | 28859 | 19 | |||
63230 | 91280 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1180x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005731 | 2102090 | 37.7522629243783 | -122.423057015276 | (37.7522629243783, -122.423057015276) | 2 | 4 | 5 | 28859 | 19 | |||
63393 | 91276 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1156x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005723 | 2102230 | 37.7526468806007 | -122.4230946307 | (37.7526468806007, -122.4230946307) | 2 | 4 | 5 | 28859 | 19 | |||
63421 | 91285 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 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 | ||
66526 | 221504 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:05:00 PM | 2 | Width 3ft | 6005611.75297 | 2105011.45268 | 37.7602778227802 | -122.423677088129 | (37.7602778227802, -122.423677088129) | 2 | 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 | ||
67854 | 91236 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 804 Guerrero St | 1 | Median : | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 3x100 | 6005614 | 2104300 | 37.7583244674077 | -122.423618732861 | (37.7583244674077, -122.423618732861) | 2 | 4 | 5 | 28859 | 19 | ||
68247 | 221515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005828.19442 | 2101110.33186 | 37.7495784651962 | -122.422651289924 | (37.7495784651962, -122.422651289924) | 2 | 4 | 5 | 28859 | 19 | |||
68623 | 91249 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 870x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:26:00 AM | 3 | 6005631 | 2103898 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | 2 | 4 | 5 | 28859 | 19 | |||
73744 | 221562 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.28805 | 2102498.92878 | 37.75341002046 | -122.421598049829 | (37.75341002046, -122.421598049829) | 2 | 4 | 5 | 28859 | 19 | |||
73812 | 221487 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005570.24356 | 2105766.57088 | 37.7623488562382 | -122.423874345421 | (37.7623488562382, -122.423874345421) | 8 | 4 | 5 | 28859 | 19 | |||
75109 | 221524 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005795.8556 | 2101693.96335 | 37.7511791585977 | -122.422804591074 | (37.7511791585977, -122.422804591074) | 2 | 4 | 5 | 28859 | 19 | |||
75467 | 91279 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
76054 | 221489 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005574.23627 | 2105711.57302 | 37.7621980705008 | -122.423856625205 | (37.7621980705008, -122.423856625205) | 8 | 4 | 5 | 28859 | 19 | |||
76998 | 109698 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:01:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
77452 | 221561 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | 2 | 4 | 5 | 28859 | 19 | |||
79544 | 91239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Hanging Pot | Tree | DPW 1 | 11/20/1989 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
80816 | 221527 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005790.21854 | 2101800.81566 | 37.7514722323764 | -122.422831677752 | (37.7514722323764, -122.422831677752) | 2 | 4 | 5 | 28859 | 19 | |||
81807 | 243240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005663.74872 | 2104041.4182 | 37.7576172702474 | -122.423428296996 | (37.7576172702474, -122.423428296996) | 2 | 4 | 5 | 28859 | 19 | |||
84262 | 221514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005830.22915 | 2101083.18072 | 37.7495040291878 | -122.42264232458 | (37.7495040291878, -122.42264232458) | 2 | 4 | 5 | 28859 | 19 | |||
84453 | 152418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005636.4507 | 2104585.07924 | 37.7591084954784 | -122.42356135619 | (37.7591084954784, -122.42356135619) | 2 | 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 | |||
85812 | 221490 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | 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 | ||
89953 | 109700 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:08:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
90377 | 91287 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 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) );