trees
339 rows where qSpecies_id = 30 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
127657 | 91271 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1130x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005715 | 2102383 | 37.7530665317795 | -122.423133170481 | (37.7530665317795, -122.423133170481) | 2 | 4 | 5 | 28859 | 19 | |||
94933 | 91269 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1120x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005712 | 2102441 | 37.7532256170659 | -122.423147667433 | (37.7532256170659, -122.423147667433) | 2 | 4 | 5 | 28859 | 19 | |||
120886 | 221547 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005723.41397 | 2102999.7023 | 37.7547603282456 | -122.423147905453 | (37.7547603282456, -122.423147905453) | 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 | ||
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 | |||
6280 | 221541 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005710.1718 | 2103251.3867 | 37.7554506478492 | -122.423211590049 | (37.7554506478492, -122.423211590049) | 2 | 4 | 5 | 28859 | 19 | |||
3021 | 221542 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005709.18006 | 2103278.94714 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | 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 | |||
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 | ||
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 | ||
140454 | 91265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 986x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | 2 | 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 | ||
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 | ||
116250 | 221507 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005699.48542 | 2103446.59299 | 37.7559860358317 | -122.42326242244 | (37.7559860358317, -122.42326242244) | 2 | 4 | 5 | 28859 | 19 | |||
151302 | 91263 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 970x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.423268931776 | (37.7556426634019, -122.423268931776) | 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 | |||
2093 | 221427 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.423275433821 | (37.7561368116793, -122.423275433821) | 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 | ||
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 | ||
6810 | 243265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005691.43766 | 2103575.20205 | 37.7563387121803 | -122.42329939627 | (37.7563387121803, -122.42329939627) | 2 | 4 | 5 | 28859 | 19 | ||
102302 | 91258 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 948x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005688.196047 | 2103445.549621 | 37.7559825338488 | -122.423301390711 | (37.7559825338488, -122.423301390711) | 2 | 4 | 5 | 28859 | 19 | ||
5313 | 221425 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.423307021613 | (37.7563992716189, -122.423307021613) | 2 | 4 | 5 | 28859 | 19 | |||
981 | 221424 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005689.53453 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | 2 | 4 | 5 | 28859 | 19 | ||
123034 | 91255 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 4 | 5 | 28859 | 19 | ||
159092 | 91256 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 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 | ||
148907 | 91252 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 908x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.762116 | 2103670.859284 | 37.7566004799608 | -122.423360407709 | (37.7566004799608, -122.423360407709) | 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 | |||
1991 | 110775 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:57:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 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 | ||
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 | ||
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 | ||
94316 | 110779 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:35:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
95760 | 110776 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:53:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
106696 | 110781 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:26:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
141491 | 110772 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:10:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
163402 | 110782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:21:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
172006 | 110783 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:16:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
179554 | 110784 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 13 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:11:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
193458 | 110773 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:06:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
185336 | 91251 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 906X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.14042 | 2103682.124768 | 37.7566313772663 | -122.423363358583 | (37.7566313772663, -122.423363358583) | 2 | 4 | 5 | 28859 | 19 | ||
7774 | 221416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005677.18728 | 2103848.76992 | 37.7570890615162 | -122.423368126034 | (37.7570890615162, -122.423368126034) | 2 | 4 | 5 | 28859 | 19 | ||
143846 | 221417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.423384724831 | (37.7571924071266, -122.423384724831) | 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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
103645 | 221420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 5 | Width 3ft | 6005663.71373 | 2104068.90036 | 37.7576927278639 | -122.423430371709 | (37.7576927278639, -122.423430371709) | 2 | 4 | 5 | 28859 | 19 | ||
6246 | 221421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005663.97142 | 2104121.3615 | 37.7578367884406 | -122.423433209975 | (37.7578367884406, -122.423433209975) | 2 | 4 | 5 | 28859 | 19 | ||
165700 | 221422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103 | (37.7579289437835, -122.42344282103) | 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 | |||
110959 | 221423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005658.05131 | 2104209.23909 | 37.7580777456208 | -122.423459931529 | (37.7580777456208, -122.423459931529) | 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 | |||
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 | |||
190784 | 152422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005644.93763 | 2104427.72747 | 37.7586769234173 | -122.423520817442 | (37.7586769234173, -122.423520817442) | 2 | 4 | 5 | 28859 | 19 | |||
109528 | 91246 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 876x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005633 | 2103862 | 37.7571228942355 | -122.423521883288 | (37.7571228942355, -122.423521883288) | 2 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
115886 | 91243 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 850x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/10/2009 12:00:00 AM | 3 | 6005625 | 2104018 | 37.7575507822519 | -122.423560641088 | (37.7575507822519, -122.423560641088) | 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 | |||
107424 | 152417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | 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 | |||
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 | |||
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 | |||
191935 | 91240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 2 | 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 | |||
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 | |||
96333 | 152415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | 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 | |||
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 | |||
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 | ||
157919 | 91293 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2001 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
159812 | 91238 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
106244 | 152412 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) | 2 | 4 | 5 | 28859 | 19 | |||
177826 | 91237 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 808 Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 4x15 | 6005611 | 2104262 | 37.7582199589604 | -122.423626406477 | (37.7582199589604, -122.423626406477) | 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 | |||
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 | ||
160656 | 221503 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | 2 | 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 | ||
7635 | 221501 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:08:00 PM | 2 | 3x3 | Permit Number 56125 | 6005604.17413 | 2105138.97106 | 37.7606275304574 | -122.423712366728 | (37.7606275304574, -122.423712366728) | 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 | ||
96256 | 221499 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:01:00 PM | 2 | Width 3ft | 6005601.09047 | 2105206.48742 | 37.7608127404289 | -122.423727832389 | (37.7608127404289, -122.423727832389) | 2 | 4 | 5 | 28859 | 19 | ||
181202 | 221498 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | 2 | 4 | 5 | 28859 | 19 | |||
98803 | 221497 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 2 | Width 3ft | 6005595.06917 | 2105295.44768 | 37.7610566644632 | -122.423754982925 | (37.7610566644632, -122.423754982925) | 2 | 4 | 5 | 28859 | 19 | ||
1562 | 221496 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/21/2015 12:00:00 AM | 2 | 3x3 | Permit Number 56125 | 6005594.03058 | 2105332.56679 | 37.7611585261709 | -122.423761214331 | (37.7611585261709, -122.423761214331) | 2 | 4 | 5 | 28859 | 19 | |
3217 | 221495 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 2 | 3x3 | Permit Number 56125 | 6005593.17627 | 2105367.35468 | 37.7612539972982 | -122.423766642643 | (37.7612539972982, -122.423766642643) | 2 | 4 | 5 | 28859 | 19 | |
813 | 221494 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 2 | 3x3 | Permit Number 56125 | 6005589.49697 | 2105398.29386 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | 2 | 4 | 5 | 28859 | 19 | |
143760 | 221493 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.423815493808 | (37.7617917972666, -122.423815493808) | 8 | 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 | |||
177960 | 221491 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005578.642 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | 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 | |||
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 | |||
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 | |||
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 |
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) );