trees
339 rows where qSpecies_id = 30 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | |||
116925 | 221485 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005566.92978 | 2105826.00789 | 37.7625118691551 | -122.423890033211 | (37.7625118691551, -122.423890033211) | 8 | 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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |
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 | |
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 | ||
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 | |||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );