trees
339 rows where qSpecies_id = 30 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |
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 | ||
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 | |
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 | |
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 | ||
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 | ||
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 | |||
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 | |||
34578 | 203292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 10 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994458.02189 | 2089982.35817 | 37.7183757412389 | -122.461162923744 | (37.7183757412389, -122.461162923744) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
108354 | 221438 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005446.19377 | 2108068.29327 | 37.7686618344154 | -122.424467115559 | (37.7686618344154, -122.424467115559) | 8 | 4 | 5 | 28853 | 19 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||||
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 | ||
2332 | 91282 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
2725 | 118348 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:19:00 AM | 3 | |||||||||||||
2731 | 91284 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
3534 | 118354 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:05:00 AM | 3 | |||||||||||||
5912 | 221553 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.11141 | 2102791.4847 | 37.7541892146839 | -122.423096111708 | (37.7541892146839, -122.423096111708) | 2 | 4 | 5 | 28859 | 19 | ||
6358 | 208585 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1424 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784722 | 5993062.7204 | 2105752.14993 | 37.7615952234535 | -122.467131790705 | (37.7615952234535, -122.467131790705) | 1 | 8 | 4 | 56 | 12 | |
8707 | 118349 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:43:00 AM | 3 | |||||||||||||
8919 | 91244 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 852x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:21:00 AM | 3 | 6005625 | 2104006 | 37.7575178330554 | -122.423559787953 | (37.7575178330554, -122.423559787953) | 2 | 4 | 5 | 28859 | 19 | |||
9030 | 221418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353201 | -122.423415847665 | (37.757466353201, -122.423415847665) | 2 | 4 | 5 | 28859 | 19 | ||
9161 | 118352 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:56:00 AM | 3 | |||||||||||||
9435 | 221556 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 14 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.423062156895 | (37.753875475376, -122.423062156895) | 2 | 4 | 5 | 28859 | 19 | ||
10576 | 118350 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:53:00 AM | 3 | |||||||||||||
13786 | 221552 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.10722 | 2102815.94179 | 37.7542563679477 | -122.423097864468 | (37.7542563679477, -122.423097864468) | 2 | 4 | 5 | 28859 | 19 | ||
14601 | 118347 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:39:00 AM | 3 | |||||||||||||
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 | ||
15770 | 118355 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:48:00 AM | 3 | |||||||||||||
15879 | 221486 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | 8 | 4 | 5 | 28859 | 19 | ||
15920 | 221557 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 15 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.423054419131 | (37.7537703032837, -122.423054419131) | 2 | 4 | 5 | 28859 | 19 | ||
18813 | 118351 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:32:00 AM | 3 | |||||||||||||
18821 | 118346 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:47:00 AM | 3 | |||||||||||||
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 | ||
19189 | 118353 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:58:00 AM | 3 | |||||||||||||
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 | ||
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 | ||
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 | ||
28021 | 187781 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | 14 | 3 | 8 | 310 | 29 | ||||
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 | ||
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 | |||
36635 | 110623 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:20:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
36834 | 110620 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:30:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
38198 | 91254 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 928x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.979082 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
42708 | 110627 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:29:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
43244 | 91259 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 952x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
47290 | 110626 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 04/29/2015 09:37:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
47649 | 91278 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
49439 | 37574 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 30 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/2014 12:00:00 AM | 3 | Permit Number 773155 | 6001973.00287599 | 2105680.02476784 | 37.7619074866084 | -122.436309645561 | (37.7619074866084, -122.436309645561) | 15 | 4 | 5 | 28862 | 3 | |
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 | ||
50929 | 91248 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 888x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:34:00 AM | 3 | 6005668.887935 | 2103795.421709 | 37.7569421113624 | -122.423393035961 | (37.7569421113624, -122.423393035961) | 2 | 4 | 5 | 28859 | 19 | |||
51627 | 91264 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 978X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.521495 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | 2 | 4 | 5 | 28859 | 19 | ||
52461 | 110625 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:13:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
52768 | 110774 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
53870 | 110778 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:43:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
54019 | 91241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
57081 | 91242 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
57604 | 91292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1286x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005762 | 2101471 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | 2 | 4 | 5 | 28859 | 19 | |||
57813 | 91247 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 880x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:29:00 AM | 3 | 6005634 | 2103838 | 37.7570570522806 | -122.423516718678 | (37.7570570522806, -122.423516718678) | 2 | 4 | 5 | 28859 | 19 | |||
59561 | 109696 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
59581 | 91291 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1282x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005761 | 2101495 | 37.7506308843168 | -122.422910986406 | (37.7506308843168, -122.422910986406) | 2 | 4 | 5 | 28859 | 19 | |||
62248 | 110628 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:18:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
63230 | 91280 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1180x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005731 | 2102090 | 37.7522629243783 | -122.423057015276 | (37.7522629243783, -122.423057015276) | 2 | 4 | 5 | 28859 | 19 | |||
63393 | 91276 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1156x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005723 | 2102230 | 37.7526468806007 | -122.4230946307 | (37.7526468806007, -122.4230946307) | 2 | 4 | 5 | 28859 | 19 | |||
63421 | 91285 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
65226 | 110621 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:27:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
66601 | 110619 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:33:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
67854 | 91236 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 804 Guerrero St | 1 | Median : | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 3x100 | 6005614 | 2104300 | 37.7583244674077 | -122.423618732861 | (37.7583244674077, -122.423618732861) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
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 | |||
75467 | 91279 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
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 |
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) );