trees
336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by Longitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
191007 | 96222 | Significant Tree 6 | Tree(s) :: 17 | 176 Holladay Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/18/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767739 | 6010842.9 | 2100101.6 | 37.7470903528282 | -122.405239158587 | (37.7470903528282, -122.405239158587) | 2 | 7 | 7 | 28859 | 2 | |
145228 | 173889 | Significant Tree 6 | Gleditsia triacanthos :: Honey Locust 182 | 190 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779949 | 6010824 | 2099939 | 37.7466428319545 | -122.405293064953 | (37.7466428319545, -122.405293064953) | 2 | 7 | 7 | 28859 | 2 | |||
168346 | 251480 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010641 | 2100362 | 37.7477940646116 | -122.405955656592 | (37.7477940646116, -122.405955656592) | 2 | 7 | 7 | 28859 | 2 | ||||
8163 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | 2 | 7 | 7 | 28859 | 2 | |||
9889 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | |||||
3313 | 262482 | Significant Tree 6 | Tree(s) :: 17 | 45 Delta St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010254 | 2089941 | 37.7191585615903 | -122.406559656354 | (37.7191585615903, -122.406559656354) | 10 | 7 | 8 | 309 | 39 | ||||
48619 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 78 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010457 | 2100357 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | 2 | 7 | 7 | 28859 | 2 | ||||
6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
52276 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Holladay Ave | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | ||||
84450 | 104867 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Holladay Ave | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | ||||
123534 | 104868 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
156992 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x Montcalm St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010036 | 2099760 | 37.7461072494139 | -122.408005278478 | (37.7461072494139, -122.408005278478) | 2 | 7 | 7 | 28859 | 2 | ||||
51717 | 115446 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 2 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
74590 | 115445 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 1 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
66441 | 109838 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x MONTCALM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009924 | 2099647 | 37.7457907048197 | -122.408384592716 | (37.7457907048197, -122.408384592716) | 2 | 7 | 7 | 28859 | 2 | |||
100702 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 654 Precita Ave | Front Yard : Yard | Tree | Private 2 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | 2 | 7 | 7 | 28859 | 2 | |||||
167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
63157 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 450 PERALTA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
59436 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 261 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176 | 37.7444805424074 | -122.409394598776 | (37.7444805424074, -122.409394598776) | 2 | 7 | 7 | 28859 | 2 | ||
18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
7930 | 223763 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.7408787078943 | -122.409618578334 | (37.7408787078943, -122.409618578334) | 10 | 7 | 7 | 28859 | 2 | |||
4813 | 223765 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009530.59471 | 2097856.4038 | 37.7408520807582 | -122.409618578357 | (37.7408520807582, -122.409618578357) | 10 | 7 | 7 | 28859 | 2 | |||
3385 | 223764 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.409618578359 | (37.7408634922583, -122.409618578359) | 10 | 7 | 7 | 28859 | 2 | |||
4207 | 247626 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6009494.96271 | 2096975.40444 | 37.7384310509429 | -122.409679612625 | (37.7384310509429, -122.409679612625) | 10 | 7 | 7 | 28859 | 2 | ||||
6178 | 247627 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6009494.82009 | 2096968.41626 | 37.7384118549208 | -122.409679612627 | (37.7384118549208, -122.409679612627) | 10 | 7 | 7 | 28859 | 2 | ||||
12344 | 247628 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6009493.85882 | 2096962.27736 | 37.7383949449624 | -122.409682503062 | (37.7383949449624, -122.409682503062) | 10 | 7 | 7 | 28859 | 2 | ||||
16054 | 247629 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | 6009493.3855 | 2096955.46231 | 37.7383762057861 | -122.409683658684 | (37.7383762057861, -122.409683658684) | 10 | 7 | 7 | 28859 | 2 | ||||
8454 | 247630 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6009492.89578 | 2096949.07994 | 37.7383586537362 | -122.409684901541 | (37.7383586537362, -122.409684901541) | 10 | 7 | 7 | 28859 | 2 | ||||
156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 | ||||
155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
15717 | 221238 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 55 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6009363.02974 | 2097125.97708 | 37.7388370966643 | -122.41014640214 | (37.7388370966643, -122.41014640214) | 10 | 7 | 7 | 28859 | 2 | |||
11129 | 236516 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6009359.84862 | 2097078.24448 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | 10 | 7 | 7 | 28859 | 2 | |||
190141 | 100043 | Significant Tree 6 | Tree(s) :: 17 | 50 Bronte St | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2012 12:00:00 AM | Permit Number 769001 | 6009337 | 2097155 | 37.7389153282678 | -122.410238449764 | (37.7389153282678, -122.410238449764) | 10 | 7 | 7 | 28859 | 2 | |||
32139 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
42938 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
126350 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : | Tree | Private 2 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261909 | (37.740765720819, -122.41052261909) | 10 | 7 | 7 | 28859 | 2 | |||
151159 | 107322 | Significant Tree 6 | Tree(s) :: 17 | 68 ROSENKRANZ ST | 1 | Front Yard : Yard | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773942 | 6009212 | 2098349 | 37.7421867844178 | -122.410754944355 | (37.7421867844178, -122.410754944355) | 10 | 7 | 7 | 28859 | 2 | ||
551 | 234021 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6009064.54563 | 2097789.74594 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | 10 | 7 | 7 | 28859 | 2 | |||
12676 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 50 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 782183 | 6009049 | 2099828 | 37.7462386522881 | -122.411423013741 | (37.7462386522881, -122.411423013741) | 2 | 7 | 7 | 28859 | 2 | |||
77320 | 116457 | Significant Tree 6 | Tree(s) :: 17 | 412 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | Permit Number 777591 | 6008890.4 | 2096365.2 | 37.736721665261 | -122.41172680033 | (37.736721665261, -122.41172680033) | 10 | 7 | 7 | 28859 | 2 | ||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
100356 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
110541 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
18860 | 229626 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3658 Folsom St | 1 | Side Yard : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008459.0571 | 2097864.523 | 37.7408142714666 | -122.413324142211 | (37.7408142714666, -122.413324142211) | 2 | 7 | 7 | 28859 | 2 | |||
69512 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 500 Raymond Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.87951 | 2088473.93147 | 37.7150170728648 | -122.413438766187 | (37.7150170728648, -122.413438766187) | 9 | 7 | 8 | 309 | 18 | ||
94002 | 113187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3340 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008444 | 2099179 | 37.7444226899799 | -122.413469145285 | (37.7444226899799, -122.413469145285) | 2 | 7 | 7 | 28859 | 2 | |||
108320 | 104865 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 80 Stoneman St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770375 | 6007947.7 | 2099422 | 37.7450620347132 | -122.415202450973 | (37.7450620347132, -122.415202450973) | 2 | 7 | 7 | 28859 | 2 | ||||
10162 | 230434 | Significant Tree 6 | Magnolia x soulangiana :: Saucer Magnolia 147 | 272 Anderson St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 6007874.82314 | 2097362.07469 | 37.7394018403099 | -122.415308650074 | (37.7394018403099, -122.415308650074) | 2 | 7 | 7 | 28859 | 2 | |||
129559 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 766 Anderson St | Front Yard : Yard | Tree | Private 2 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723 | 2095324 | 37.7337971999422 | -122.415689321062 | (37.7337971999422, -122.415689321062) | 2 | 7 | 7 | 28859 | 2 | |||
184595 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 100x OGDEN AVE | 4 | Back Yard : Yard | Tree | Private 2 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | |||||
92509 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 | 500 Cortland Ave | 2 | Back Yard : Yard | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | 2 | 7 | 7 | 28859 | 2 | ||
110002 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 | 500 Cortland Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | 2 | 7 | 7 | 28859 | 2 | ||
17239 | 32497 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 665 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 16 | Permit Number 37002 | 6007442.30694 | 2095863.10154 | 37.7352616718948 | -122.416697941676 | (37.7352616718948, -122.416697941676) | 2 | 7 | 7 | 28859 | 2 | |
154007 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 101 LUNDYS LN | 1 | Front Yard : Cutout | Tree | Private 2 | 18 | 6006875 | 2098969 | 37.7437578546964 | -122.418879543436 | (37.7437578546964, -122.418879543436) | 2 | 7 | 7 | 28859 | 2 | ||||
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
90315 | 112398 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 246 CRESCENT AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6006552 | 2095759 | 37.7349257177289 | -122.419768681192 | (37.7349257177289, -122.419768681192) | 2 | 7 | 7 | 28859 | 2 | |||||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
20298 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 7 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
41027 | 113738 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 15 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
42851 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 4 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
61015 | 113741 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1580 Valencia St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | ||||
61399 | 113734 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 11 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
67938 | 113739 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 16 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
86304 | 113736 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 13 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
87807 | 113732 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 9 | Front Yard : Yard | Tree | Private 2 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||
98904 | 113735 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 12 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
105980 | 113733 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 10 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
117937 | 113726 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 3 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
124470 | 105858 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
128240 | 113740 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 17 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
159232 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
185143 | 113737 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 14 | Front Yard : Yard | Tree | Private 2 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||
185504 | 113729 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 6 | Front Yard : Yard | Tree | Private 2 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||
192790 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 8 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
152685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
55458 | 255165 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 371 Prospect Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781717 | 6006352.58239 | 2097791.19314 | 37.7404944317648 | -122.420602351048 | (37.7404944317648, -122.420602351048) | 2 | 7 | 7 | 28859 | 2 | |
22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
61885 | 105866 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 3555 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
73380 | 105869 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
76185 | 105867 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
145596 | 105870 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
178545 | 105871 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
186539 | 105868 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
10910 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
98953 | 114193 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 1 | Front Yard : Yard | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
109570 | 114194 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/23/2015 12:00:00 AM | 30 | 3x3 | Permit Number 777057 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
108135 | 108305 | Significant Tree 6 | Tree(s) :: 17 | 360 GAMBIER ST | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | Permit Number 774454 | 6006059.9 | 2092154.5 | 37.725000818071 | -122.421214176486 | (37.725000818071, -122.421214176486) | 9 | 7 | 7 | 309 | 5 | ||
27222 | 258201 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
33311 | 258200 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
163996 | 258199 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
84220 | 104654 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 352-354 Coleridge St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768244 | 6006091.8 | 2098091.1 | 37.7413032079582 | -122.421525330669 | (37.7413032079582, -122.421525330669) | 2 | 7 | 7 | 28859 | 2 | ||||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
144689 | 253283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 673 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005929 | 2099335 | 37.7447094953859 | -122.422176588207 | (37.7447094953859, -122.422176588207) | 2 | 7 | 5 | 28859 | 2 | ||||
73655 | 253718 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 227 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | Permit Number 780760 | 6005690 | 2092595 | 37.7261894743752 | -122.422524168298 | (37.7261894743752, -122.422524168298) | 9 | 7 | 7 | 309 | 5 | ||
22846 | 105861 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 |
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) );