trees
339 rows where qSpecies_id = 30 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109163 | 221526 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005792.85635 | 2101748.62489 | 37.7513290773756 | -122.422818847126 | (37.7513290773756, -122.422818847126) | 2 | 4 | 5 | 28859 | 19 | |||
109381 | 221441 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 14 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005450.56053 | 2107974.49254 | 37.7684045266634 | -122.424445338474 | (37.7684045266634, -122.424445338474) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
117709 | 221442 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 15 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005450.90289 | 2107942.80866 | 37.768317549645 | -122.424441900367 | (37.768317549645, -122.424441900367) | 8 | 4 | 5 | 28853 | 19 | |||
118210 | 221517 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.4134 | 2101214.1336 | 37.7498632112216 | -122.422675198428 | (37.7498632112216, -122.422675198428) | 2 | 4 | 5 | 28859 | 19 | |||
120577 | 221531 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005769.92765 | 2102140.767 | 37.7524045154572 | -122.422926004956 | (37.7524045154572, -122.422926004956) | 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 | |||
124564 | 257893 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 23 Canyon Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003365 | 2086282 | 37.7087239233851 | -122.430111404197 | (37.7087239233851, -122.430111404197) | 9 | 7 | 6 | 28861 | 5 | ||||
124826 | 221551 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005731.5319 | 2102850.00284 | 37.7543497463656 | -122.423109191463 | (37.7543497463656, -122.423109191463) | 2 | 4 | 5 | 28859 | 19 | |||
126324 | 221520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005805.49109 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | 2 | 4 | 5 | 28859 | 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 | |||
128979 | 221516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6005827.473 | 2101138.31675 | 37.749655264584 | -122.422655773047 | (37.749655264584, -122.422655773047) | 2 | 4 | 5 | 28859 | 19 | |||
135542 | 187782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 14 | Front Yard : Yard | Tree | Private 2 | 1 | 6014325.58247 | 2106437.08289 | 37.764680319858 | -122.393639589702 | (37.764680319858, -122.393639589702) | 14 | 3 | 8 | 310 | 29 | ||||
136051 | 221508 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 1 | 6004291.81357 | 2095940.5809 | 37.7352967139782 | -122.427595874056 | (37.7352967139782, -122.427595874056) | 2 | 7 | 5 | 28861 | 2 | ||||
136892 | 201711 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015357.64919 | 2088292.55339 | 37.7149164576082 | -122.388803118478 | (37.7149164576082, -122.388803118478) | 10 | 3 | 8 | 58 | 1 | |||
137951 | 221439 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005446.76573 | 2108031.65533 | 37.7685612677047 | -122.424462530821 | (37.7685612677047, -122.424462530821) | 8 | 4 | 5 | 28853 | 19 | |||
140820 | 221534 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005765.63484 | 2102254.12398 | 37.7527155253202 | -122.422948906168 | (37.7527155253202, -122.422948906168) | 2 | 4 | 5 | 28859 | 19 | |||
142437 | 221532 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005770.104 | 2102168.30473 | 37.7524801376575 | -122.422927352112 | (37.7524801376575, -122.422927352112) | 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 | |||
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 | |||
145933 | 221566 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001342.88204 | 2102344.46852 | 37.7527130350975 | -122.438250016433 | (37.7527130350975, -122.438250016433) | 2 | 4 | 5 | 28862 | 22 | |||
150560 | 201715 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015296.60638 | 2088393.85947 | 37.715191240972 | -122.389021178889 | (37.715191240972, -122.389021178889) | 10 | 3 | 8 | 58 | 1 | |||
152774 | 221559 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6010039.89073 | 2101557.14399 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | 2 | 4 | 7 | 28859 | 19 | |||
154018 | 221558 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005728.5881 | 2102926.21051 | 37.7545588288301 | -122.423124788381 | (37.7545588288301, -122.423124788381) | 2 | 4 | 5 | 28859 | 19 | |||
154318 | 221443 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 16 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005451.42839 | 2107920.02985 | 37.7682550341586 | -122.424438462286 | (37.7682550341586, -122.424438462286) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
156067 | 221563 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.7527030580007 | -122.438378727412 | (37.7527030580007, -122.438378727412) | 2 | 4 | 5 | 28862 | 22 | |||
162604 | 115521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
162980 | 96193 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1640 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
168740 | 221570 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.7686889012963 | -122.437411868978 | (37.7686889012963, -122.437411868978) | 15 | 5 | 5 | 29492 | 3 | |||
174659 | 221511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.7492116209326 | -122.422616365666 | (37.7492116209326, -122.422616365666) | 2 | 4 | 5 | 28859 | 19 | |||
176363 | 221550 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005729.97057 | 2102894.68155 | 37.7544723356343 | -122.423117766494 | (37.7544723356343, -122.423117766494) | 2 | 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 | |||
180105 | 221568 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
182549 | 221521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005805.66932 | 2101529.55059 | 37.7507282726947 | -122.422758971142 | (37.7507282726947, -122.422758971142) | 2 | 4 | 5 | 28859 | 19 | |||
182752 | 221536 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.7529328042098 | -122.422966417762 | (37.7529328042098, -122.422966417762) | 2 | 4 | 5 | 28859 | 19 | |||
182979 | 221555 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | 2 | 4 | 5 | 28859 | 19 | |||
185467 | 221510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005838.80296 | 2100921.02333 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | 2 | 4 | 5 | 28859 | 19 | |||
185643 | 221512 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005835.43443 | 2101000.02463 | 37.7492759952973 | -122.422618416129 | (37.7492759952973, -122.422618416129) | 2 | 4 | 5 | 28859 | 19 | |||
186895 | 221549 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005728.89674 | 2102911.59468 | 37.7545187145683 | -122.423122682192 | (37.7545187145683, -122.423122682192) | 2 | 4 | 5 | 28859 | 19 | |||
186954 | 221539 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005756.51513 | 2102435.13947 | 37.753212037416 | -122.422993308391 | (37.753212037416, -122.422993308391) | 2 | 4 | 5 | 28859 | 19 | |||
190176 | 184203 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.7594128206633 | -122.500400782356 | (37.7594128206633, -122.500400782356) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
191122 | 221533 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005767.42939 | 2102227.70946 | 37.75264309841 | -122.422940823082 | (37.75264309841, -122.422940823082) | 2 | 4 | 5 | 28859 | 19 | |||
192188 | 221509 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 38 | Front Yard : Yard | Tree | Private 2 | 2 | 6004439.44088 | 2096038.01178 | 37.7355725864019 | -122.427092409311 | (37.7355725864019, -122.427092409311) | 2 | 7 | 5 | 28861 | 2 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
80455 | 115520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/09/2016 10:50:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
131382 | 115515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
187472 | 221450 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 1 | Width 3ft | 6005469.47774 | 2107557.31332 | 37.7672601204903 | -122.424350229795 | (37.7672601204903, -122.424350229795) | 8 | 4 | 5 | 28853 | 19 | ||
98181 | 221451 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 1 | Width 3ft | 6005468.55001 | 2107589.96825 | 37.7673497307443 | -122.424355761536 | (37.7673497307443, -122.424355761536) | 8 | 4 | 5 | 28853 | 19 | ||
190513 | 115514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
31367 | 115513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
171592 | 221452 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 1 | Width 3ft | 6005465.56003 | 2107641.57919 | 37.7674912732207 | -122.424369774755 | (37.7674912732207, -122.424369774755) | 8 | 4 | 5 | 28853 | 19 | ||
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 | ||
118820 | 115519 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:45:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
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 | ||
73685 | 115518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:33:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
142764 | 221453 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | 8 | 4 | 5 | 28853 | 19 | ||
88305 | 221454 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 1 | Width 3ft | 6005462.2492 | 2107712.58298 | 37.7676860457059 | -122.424386277315 | (37.7676860457059, -122.424386277315) | 8 | 4 | 5 | 28853 | 19 | ||
169041 | 115511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
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 | ||
55166 | 115517 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:52:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
128664 | 115510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
162498 | 221455 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 1 | Width 3ft | 6005458.87953 | 2107745.71785 | 37.7677768358576 | -122.424400289657 | (37.7677768358576, -122.424400289657) | 8 | 4 | 5 | 28853 | 19 | ||
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 | |||
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 | |
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 | ||
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 | |
152652 | 109694 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 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 | ||
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 | ||
95085 | 109697 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:59:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 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 | ||
122027 | 109703 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:05:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 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 | ||
187231 | 109702 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 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 | ||
129565 | 109701 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 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 | |
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 | ||
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 | |
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 | ||
133232 | 109704 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 02/28/2015 10:40:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 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 | ||
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 | ||
171275 | 109699 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 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 | ||
156993 | 110649 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 04/28/2015 07:46:00 PM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
112749 | 110650 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 13 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:03:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
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 |
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) );