Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
| 143612 | 143612 | 94987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 36 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2015 03:25:00 PM | 3 | 3x3 | 6010827.4 | 2087210.2 | 37.711692402207106 | -122.40438551024401 | (37.7116924022071, -122.404385510244) | ||
| 11741 | 11741 | 94992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | |||
| 11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
| 12910 | 12910 | 26795 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.712320301990204 | -122.40679292443501 | (37.7123203019902, -122.406792924435) | ||
| 12204 | 12204 | 95003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | |||
| 12710 | 12710 | 37830 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2007 12:00:00 AM | 3 | 6x6 | Permit Number 49480 | 6003635.85955 | 2090436.9204099998 | 37.7201477680848 | -122.429471383195 | (37.7201477680848, -122.429471383195) |
| 11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
| 10557 | 10557 | 37839 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.0147400005 | 2090473.5929 | 37.720249717041504 | -122.42939741397 | (37.7202497170415, -122.42939741397) |
| 13085 | 13085 | 37840 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2007 12:00:00 AM | 3 | 4x6 | Permit Number 49480 | 6003672.4294 | 2090496.5417099998 | 37.7203135455184 | -122.42934922289801 | (37.7203135455184, -122.429349222898) |
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 54864 | 54864 | 178902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.721497357285706 | -122.401224985361 | (37.7214973572857, -122.401224985361) | |||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
| 119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 14606 | 14606 | 15049 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | ||
| 52167 | 52167 | 214406 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993802.78615 | 2096495.7432 | 37.736222176613104 | -122.463900308969 | (37.7362221766131, -122.463900308969) | ||||
| 66160 | 66160 | 214405 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993807.85396 | 2096495.9519200001 | 37.73622304175571 | -122.46388280274701 | (37.7362230417557, -122.463882802747) | ||||
| 25207 | 25207 | 214407 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5993812.00581 | 2096497.7556200002 | 37.7362282335302 | -122.463868579087 | (37.7362282335302, -122.463868579087) | ||||
| 112336 | 112336 | 24168 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 12546 | 12546 | 86221 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2667 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988934.7468 | 2097197.923 | 37.7378684403296 | -122.480782320208 | (37.7378684403296, -122.480782320208) | ||
| 11906 | 11906 | 86094 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2662 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988979.4233 | 2097220.9939 | 37.7379343837052 | -122.480629541954 | (37.7379343837052, -122.480629541954) | ||
| 13123 | 13123 | 86095 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2654 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988977.4573 | 2097276.4803 | 37.7380866206979 | -122.48064040005501 | (37.7380866206979, -122.480640400055) | ||
| 13034 | 13034 | 86096 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2650 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988977.2111 | 2097298.8814 | 37.7381481139952 | -122.480642890703 | (37.7381481139952, -122.480642890703) | ||
| 101182 | 101182 | 13415 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 430 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 5 | 5999619.6561933 | 2097087.2734828999 | 37.7381798806191 | -122.443831547884 | (37.7381798806191, -122.443831547884) | |||
| 10806 | 10806 | 86097 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2646 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988975.9803 | 2097328.4213 | 37.7382291513586 | -122.480649308029 | (37.7382291513586, -122.480649308029) | ||
| 58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
| 13007 | 13007 | 86098 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2640 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988975.4879 | 2097347.3761 | 37.7382811677 | -122.48065239769899 | (37.7382811677, -122.480652397699) | ||
| 11069 | 11069 | 86218 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2639 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988928.7681 | 2097372.6349 | 37.738347806336 | -122.4808157786 | (37.738347806336, -122.4808157786) | ||
| 12250 | 12250 | 86099 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2632 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097406.2098 | 37.738442552384704 | -122.480666065628 | (37.7384425523847, -122.480666065628) | ||
| 10421 | 10421 | 86100 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2628 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097431.8111 | 37.738512846904996 | -122.48066793928899 | (37.738512846905, -122.480667939289) | ||
| 11235 | 11235 | 86215 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2611 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988923.4537 | 2097544.6896 | 37.7388199149273 | -122.480846746123 | (37.7388199149273, -122.480846746123) | ||
| 13038 | 13038 | 86102 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2602X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988967.6106 | 2097559.0789 | 37.7388619907591 | -122.480695127099 | (37.7388619907591, -122.480695127099) | ||
| 12012 | 12012 | 85885 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2594 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988342.102999999 | 2097683.778 | 37.7391680067391 | -122.482866951392 | (37.7391680067391, -122.482866951392) | ||
| 11982 | 11982 | 86584 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2591 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987986.2976 | 2097695.0377 | 37.7391782139584 | -122.484097976121 | (37.7391782139584, -122.484097976121) | ||
| 12867 | 12867 | 86434 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2590 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988032.3338 | 2097694.7224 | 37.7391800283996 | -122.48393878255 | (37.7391800283996, -122.48393878255) | ||
| 12236 | 12236 | 86103 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2590 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988963.1796 | 2097717.3637 | 37.7392963421237 | -122.48072203189501 | (37.7392963421237, -122.480722031895) | ||
| 10972 | 10972 | 86435 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2578 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988030.7572 | 2097759.3623 | 37.739357420836704 | -122.483948972283 | (37.7393574208367, -122.483948972283) | ||
| 11499 | 11499 | 86104 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2586 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988961.2103 | 2097747.6421 | 37.73937936427271 | -122.48073105683399 | (37.7393793642727, -122.480731056834) | ||
| 13097 | 13097 | 86105 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2580 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988961.7026 | 2097772.2587 | 37.7394469836648 | -122.48073115637199 | (37.7394469836648, -122.480731156372) | ||
| 10616 | 10616 | 86106 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2576 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988959.241 | 2097817.0609999998 | 37.7395698560466 | -122.480742946483 | (37.7395698560466, -122.480742946483) | ||
| 10610 | 10610 | 86583 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2567 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987981.2526 | 2097846.7049 | 37.7395943585814 | -122.48412653866998 | (37.7395943585814, -122.48412653867) | ||
| 12670 | 12670 | 86437 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2566 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988027.6041 | 2097846.7049 | 37.7395970571481 | -122.483966277165 | (37.7395970571481, -122.483966277165) | ||
| 11777 | 11777 | 86107 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2572 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988958.2563 | 2097845.6162 | 37.7396482039595 | -122.480748441073 | (37.7396482039595, -122.480748441073) | ||
| 12594 | 12594 | 86108 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2568 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988957.0255 | 2097873.1868 | 37.73972383411171 | -122.48075471450899 | (37.7397238341117, -122.480754714509) | ||
| 12490 | 12490 | 86438 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2558 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.0275 | 2097893.3718 | 37.7397251004281 | -122.483975149426 | (37.7397251004281, -122.483975149426) | ||
| 12054 | 12054 | 86582 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2555 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.0453 | 2097902.2006 | 37.73974660669621 | -122.484138239161 | (37.7397466066962, -122.484138239161) | ||
| 13118 | 13118 | 86439 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2550 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988024.4509 | 2097942.8764 | 37.7398609352841 | -122.48398422975 | (37.7398609352841, -122.48398422975) | ||
| 10332 | 10332 | 86580 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2539 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987975.8922 | 2098002.1559 | 37.740020874126394 | -122.484156469463 | (37.7400208741264, -122.484156469463) | ||
| 10464 | 10464 | 86111 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2544 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988952.3483 | 2098011.286 | 37.7401027466921 | -122.48078099378901 | (37.7401027466921, -122.480780993789) | ||
| 12953 | 12953 | 86579 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2535 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987974.3156 | 2098044.7236 | 37.7401376620565 | -122.48416504156201 | (37.7401376620565, -122.484165041562) | ||
| 12502 | 12502 | 86578 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2523 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987972.739 | 2098103.6878 | 37.7402994704648 | -122.48417481583799 | (37.7402994704648, -122.484174815838) | ||
| 10350 | 10350 | 86577 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2519 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987971.7931 | 2098127.9672 | 37.740366080244 | -122.484179866453 | (37.740366080244, -122.484179866453) | ||
| 12034 | 12034 | 86112 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2524 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988948.6558 | 2098119.1067 | 37.740398579611 | -122.480801652492 | (37.740398579611, -122.480801652492) | ||
| 19795 | 19795 | 9378 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001091.814301901 | 2097867.0769738997 | 37.740404899832896 | -122.438797433034 | (37.7404048998329, -122.438797433034) | |||
| 13134 | 13134 | 86113 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2516 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988946.1942 | 2098182.6176 | 37.7405728209032 | -122.480814812221 | (37.7405728209032, -122.480814812221) | ||
| 12667 | 12667 | 86440 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2506 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988014.3608 | 2098206.7963 | 37.7405850025908 | -122.484038465173 | (37.7405850025908, -122.484038465173) | ||
| 12343 | 12343 | 86576 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2501 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987968.6399 | 2098226.6612 | 37.740636884435396 | -122.48419800493 | (37.7406368844354, -122.48419800493) | ||
| 12479 | 12479 | 86114 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2492X 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988940.7293 | 2098375.0142 | 37.741100774119396 | -122.48084778996599 | (37.7411007741194, -122.480847789966) | ||
| 12045 | 12045 | 86575 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2487 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987961.675 | 2098399.0421 | 37.7411097915164 | -122.484234725572 | (37.7411097915164, -122.484234725572) | ||
| 13167 | 13167 | 86441 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | ||
| 11620 | 11620 | 86115 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2490X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988938.6988 | 2098392.9506 | 37.7411499047667 | -122.480856123487 | (37.7411499047667, -122.480856123487) | ||
| 13078 | 13078 | 86116 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2482 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988938.3604 | 2098453.8665 | 37.7413171442524 | -122.480861752339 | (37.7413171442524, -122.480861752339) | ||
| 12534 | 12534 | 86442 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2470 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988005.6699 | 2098496.5076 | 37.7413799676446 | -122.484089754678 | (37.7413799676446, -122.484089754678) | ||
| 12494 | 12494 | 86117 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2478 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988937.0067 | 2098483.986 | 37.741399765847504 | -122.480868637542 | (37.7413997658475, -122.480868637542) | ||
| 11171 | 11171 | 86212 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2475 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988890.6429 | 2098502.9376 | 37.741449106920705 | -122.48103033287902 | (37.7414491069207, -122.481030332879) | ||
| 11851 | 11851 | 86118 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988934.9761 | 2098541.5177 | 37.7415576148348 | -122.48087986971201 | (37.7415576148348, -122.480879869712) | ||
| 12514 | 12514 | 86211 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2467 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988889.6276 | 2098553.7009 | 37.7415884306548 | -122.48103755941001 | (37.7415884306548, -122.48103755941) | ||
| 12149 | 12149 | 86210 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2463 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988886.9202 | 2098579.0825 | 37.7416579645084 | -122.48104877859 | (37.7416579645084, -122.48104877859) | ||
| 10703 | 10703 | 86119 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2462 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988932.9456 | 2098582.1283 | 37.7416690029042 | -122.480889862999 | (37.7416690029042, -122.480889862999) | ||
| 12137 | 12137 | 86209 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2459 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988886.5818 | 2098605.141 | 37.741729494664796 | -122.48105185622299 | (37.7417294946648, -122.481051856223) | ||
| 10450 | 10450 | 86208 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2447 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988885.905 | 2098662.6727 | 37.741887422325 | -122.48105840788601 | (37.741887422325, -122.481058407886) | ||
| 12746 | 12746 | 86444 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2438 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988000.2551 | 2098696.1765 | 37.7419278906096 | -122.48412311600401 | (37.7419278906096, -122.484123116004) | ||
| 11155 | 11155 | 86207 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2443 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988885.2281 | 2098689.4081 | 37.7419607913912 | -122.481062705501 | (37.7419607913912, -122.481062705501) | ||
| 10462 | 10462 | 86574 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2435 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987950.8455 | 2098721.8965 | 37.74199563410829 | -122.484295842204 | (37.7419956341083, -122.484295842204) | ||
| 11018 | 11018 | 86445 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | ||
| 10772 | 10772 | 86206 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2439 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988884.8897 | 2098711.7439 | 37.742022099983295 | -122.481065510643 | (37.7420220999833, -122.481065510643) | ||
| 10519 | 10519 | 86446 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.742094952584296 | -122.484139283552 | (37.7420949525843, -122.484139283552) | ||
| 10713 | 10713 | 86573 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2423 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098798.3799 | 37.742205440307295 | -122.48431315163401 | (37.7422054403073, -122.484313151634) | ||
| 12619 | 12619 | 86205 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2431 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988881.5055 | 2098779.7667 | 37.7422086760624 | -122.481082191599 | (37.7422086760624, -122.481082191599) | ||
| 12352 | 12352 | 86120 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2430 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988925.5003 | 2098783.1509 | 37.74222052562529 | -122.48093032071199 | (37.7422205256253, -122.480930320712) | ||
| 10546 | 10546 | 86231 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988617.0288 | 2098793.8112 | 37.7422318603031 | -122.481997687782 | (37.7422318603031, -122.481997687782) | ||
| 10487 | 10487 | 86204 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2427 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988880.8286 | 2098804.4715 | 37.7422764696275 | -122.48108634060499 | (37.7422764696275, -122.481086340605) | ||
| 13154 | 13154 | 86572 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2419 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987948.1382 | 2098840.0058 | 37.7423197734648 | -122.48431386335399 | (37.7423197734648, -122.484313863354) | ||
| 12341 | 12341 | 86203 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2419 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988878.7981 | 2098855.9116 | 37.7424175926379 | -122.48109712708299 | (37.7424175926379, -122.481097127083) | ||
| 11411 | 11411 | 93457 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5987093.9615 | 2098905.6596 | 37.74245026783021 | -122.487272128606 | (37.7424502678302, -122.487272128606) | ||
| 12106 | 12106 | 93458 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987115.9589 | 2098905.998 | 37.7424524797237 | -122.487196094011 | (37.7424524797237, -122.487196094011) | ||
| 13001 | 13001 | 93459 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1901X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987294.6457 | 2098913.1049 | 37.742482411351396 | -122.486578778111 | (37.7424824113514, -122.486578778111) | ||
| 10928 | 10928 | 86448 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | ||
| 13104 | 13104 | 93461 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987454.3807 | 2098917.8428 | 37.7425047306499 | -122.48602681673599 | (37.7425047306499, -122.486026816736) | ||
| 10775 | 10775 | 93460 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987430.6912 | 2098918.5196 | 37.7425052083655 | -122.486108776631 | (37.7425052083655, -122.486108776631) | ||
| 10469 | 10469 | 86571 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2401X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098914.797 | 37.7425250909553 | -122.484321687901 | (37.7425250909553, -122.484321687901) | ||
| 11254 | 11254 | 93464 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1709 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987892.9754 | 2098932.7333 | 37.7425711665628 | -122.484511397018 | (37.7425711665628, -122.484511397018) | ||
| 12005 | 12005 | 93421 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2014 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986933.5496 | 2098966.2371 | 37.7426072419271 | -122.487831227416 | (37.7426072419271, -122.487831227416) | ||
| 12452 | 12452 | 93469 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1501X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988527.5163 | 2098956.0844 | 37.742672213494394 | -122.482319077312 | (37.7426722134944, -122.482319077312) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");