trees
3,709 rows where qSpecies_id = 9 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
1727 | 249457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.7841702168319 | -122.421845255461 | (37.7841702168319, -122.421845255461) | 7 | 9 | 11 | 28858 | 41 | |||
1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
2288 | 50724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 2 | Permit Number 47275 | 6001439.94101 | 2119110.04202 | 37.798752603299 | -122.439115871123 | (37.798752603299, -122.439115871123) | 13 | 9 | 1 | 57 | 17 | |
2601 | 71109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004811.8428 | 2113348.9801 | 37.7831254666613 | -122.427037449556 | (37.7831254666613, -122.427037449556) | 7 | 9 | 11 | 28858 | 41 | |||
2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
3065 | 131818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 245 Alhambra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001145.96871 | 2120047.09018 | 37.8013087580395 | -122.440200340178 | (37.8013087580395, -122.440200340178) | 13 | 9 | 1 | 57 | 17 | |||
3891 | 232910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004811.55535 | 2109480.0616 | 37.7725023496476 | -122.426762832059 | (37.7725023496476, -122.426762832059) | 7 | 9 | 5 | 28852 | 10 | |||
4117 | 17881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | 13 | 9 | 11 | 29490 | 27 | |||
4258 | 232897 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 188 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004783.23018 | 2109050.50758 | 37.7713212969648 | -122.426830214663 | (37.7713212969648, -122.426830214663) | 7 | 9 | 5 | 28852 | 10 | |||
4903 | 88595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 399 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52536 | 6004228 | 2109402 | 37.7722550008378 | -122.428775842479 | (37.7722550008378, -122.428775842479) | 7 | 9 | 11 | 28852 | 10 | ||
5721 | 246522 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005173.73012 | 2109399.79549 | 37.7723024285329 | -122.425504318986 | (37.7723024285329, -122.425504318986) | 7 | 9 | 5 | 28852 | 10 | |||
6161 | 103626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.184 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | 13 | 9 | 1 | 57 | 17 | |
7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
7927 | 17200 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006498.35844 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | 7 | 9 | 11 | 28858 | 41 | |||
8377 | 42837 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.59276 | 2120362.48981 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | 5 | 9 | 1 | 28858 | 32 | ||
8449 | 131913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2108 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004558.4355 | 2116754.37575 | 37.7924614957554 | -122.428156903513 | (37.7924614957554, -122.428156903513) | 13 | 9 | 1 | 28858 | 27 | |||
9726 | 87886 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002562.15931 | 2121499.01412 | 37.8053758844436 | -122.4354036226 | (37.8053758844436, -122.4354036226) | 13 | 9 | 1 | 57 | 17 | |
9805 | 246529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | 7 | 9 | 5 | 28852 | 10 | |||
10208 | 250096 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005700.60971 | 2115508.13842 | 37.789104197049 | -122.42411627476 | (37.789104197049, -122.42411627476) | 13 | 9 | 1 | 28858 | 41 | |||
10431 | 48599 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1338(Revised) Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50644 | 6006556.20417 | 2119076.48456 | 37.7989502536048 | -122.42140953573 | (37.7989502536048, -122.42140953573) | 13 | 9 | 1 | 28858 | 32 | |
10933 | 138331 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002699 | 2115111 | 37.7878438257201 | -122.43447304438 | (37.7878438257201, -122.43447304438) | 13 | 9 | 11 | 29490 | 27 | |||
11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
12136 | 137985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003041.7191 | 2115135.3028 | 37.7879300034078 | -122.433289038266 | (37.7879300034078, -122.433289038266) | 13 | 9 | 11 | 29490 | 27 | |||
13048 | 131805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2474 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999492.72938 | 2119826.91207 | 37.8006099461438 | -122.445905412604 | (37.8006099461438, -122.445905412604) | 13 | 9 | 1 | 57 | 17 | |||
13090 | 131960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005876.90863 | 2120024.68366 | 37.8015154438506 | -122.423827585198 | (37.8015154438506, -122.423827585198) | 5 | 9 | 1 | 28858 | 32 | |||
13554 | 137982 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002983.8805 | 2115127.6807 | 37.7879057937101 | -122.433488604212 | (37.7879057937101, -122.433488604212) | 13 | 9 | 11 | 29490 | 27 | |||
14018 | 111009 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1801x WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003409 | 2114904 | 37.7873157334926 | -122.432001790592 | (37.7873157334926, -122.432001790592) | 13 | 9 | 11 | 29490 | 27 | ||||
14067 | 17211 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 | |||
15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
15215 | 131795 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3460 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999250.62549 | 2120749.14861 | 37.8031283320577 | -122.446809584704 | (37.8031283320577, -122.446809584704) | 13 | 9 | 1 | 57 | 17 | |||
15315 | 137876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2002 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004300.8024 | 2115368.2774 | 37.7886410402481 | -122.428949455049 | (37.7886410402481, -122.428949455049) | 13 | 9 | 11 | 29490 | 27 | |||
15828 | 17912 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2328 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/1991 12:00:00 AM | 15 | 3X3 | 6002774 | 2115172 | 37.7880155732413 | -122.434217921172 | (37.7880155732413, -122.434217921172) | 13 | 9 | 1 | 29490 | 27 | ||
17660 | 70991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004787.3366 | 2113342.9897 | 37.7831076327374 | -122.427121804289 | (37.7831076327374, -122.427121804289) | 7 | 9 | 11 | 28858 | 41 | |||
18494 | 250097 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6005753.06256 | 2115514.84991 | 37.7891255865184 | -122.423935271799 | (37.7891255865184, -122.423935271799) | 13 | 9 | 1 | 28858 | 41 | |||
19750 | 17216 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 299X Olive St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006076.21174 | 2113649.43361 | 37.7840218527702 | -122.422684597748 | (37.7840218527702, -122.422684597748) | 7 | 9 | 11 | 28858 | 41 | |||
20129 | 131915 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2040 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004317.21326 | 2115889.70211 | 37.7900736698198 | -122.428929865418 | (37.7900736698198, -122.428929865418) | 13 | 9 | 1 | 28858 | 27 | |||
20277 | 131922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1545 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005575.80497 | 2118541.65889 | 37.7974264333367 | -122.42476397727 | (37.7974264333367, -122.42476397727) | 13 | 9 | 1 | 57 | 17 | |||
22043 | 2647 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1944 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004195.494 | 2115001.3607 | 37.7876276181393 | -122.429287632049 | (37.7876276181393, -122.429287632049) | 13 | 9 | 11 | 29490 | 27 | |||
22169 | 232905 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004732.02467 | 2109415.61036 | 37.7723208853186 | -122.427033345413 | (37.7723208853186, -122.427033345413) | 7 | 9 | 5 | 28852 | 10 | |||
22301 | 17791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1830 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005168.1437793 | 2115479.8612246 | 37.7889964771069 | -122.425956526841 | (37.7889964771069, -122.425956526841) | 13 | 9 | 1 | 28858 | 27 | |||
23017 | 17880 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2204 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003377.8686741 | 2115231.1135652 | 37.788212139478 | -122.432132867359 | (37.788212139478, -122.432132867359) | 13 | 9 | 1 | 29490 | 27 | |||
23491 | 17204 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Olive St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006498.35844 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | 7 | 9 | 11 | 28858 | 41 | |||
23635 | 131926 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 811 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006096.41704 | 2112784.17992 | 37.7816472182901 | -122.422553190084 | (37.7816472182901, -122.422553190084) | 7 | 9 | 11 | 28852 | 41 | |||
23768 | 131865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000313.87819 | 2121622.81545 | 37.8055878690403 | -122.443192967399 | (37.8055878690403, -122.443192967399) | 13 | 9 | 1 | 57 | 17 | |||
24290 | 17903 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2291 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002984.8186377 | 2115126.0213176 | 37.787901290694 | -122.4334852398 | (37.787901290694, -122.4334852398) | 13 | 9 | 11 | 29490 | 27 | |||
25098 | 257924 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
25216 | 41766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1320-1360 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42186 | 6006043.0799 | 2120046.29254 | 37.8015841556561 | -122.423254093806 | (37.8015841556561, -122.423254093806) | 5 | 9 | 1 | 28858 | 32 | |
25642 | 103578 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
25812 | 42775 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
26421 | 246525 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6005186.06731 | 2109316.74693 | 37.7720750943316 | -122.425455732201 | (37.7720750943316, -122.425455732201) | 7 | 9 | 5 | 28852 | 10 | |||
27819 | 131863 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | 13 | 9 | 1 | 57 | 17 | |||
28155 | 106768 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 226 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x9 | 6001629.46862 | 2120633.92047 | 37.8029475537601 | -122.438569291156 | (37.8029475537601, -122.438569291156) | 13 | 9 | 1 | 57 | 17 | ||||
29787 | 131877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3533 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002622.38757 | 2120752.94987 | 37.80333080903 | -122.435141800264 | (37.80333080903, -122.435141800264) | 13 | 9 | 1 | 57 | 17 | |||
30769 | 101291 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1573 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769634 | 6005984.6308 | 2118253.95583 | 37.7966595553549 | -122.423328868831 | (37.7966595553549, -122.423328868831) | 13 | 9 | 10 | 28858 | 32 | |
30775 | 131798 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3550 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5999217.12066 | 2121060.49219 | 37.8039812832582 | -122.446947946285 | (37.8039812832582, -122.446947946285) | 13 | 9 | 1 | 57 | 17 | |||
30866 | 17767 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2000 12:00:00 AM | 4 | 3x3 | 6005655.45235 | 2115499.57318 | 37.7890781293118 | -122.424271904233 | (37.7890781293118, -122.424271904233) | 13 | 9 | 1 | 28858 | 41 | ||
31045 | 58389 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3 | Permit Number 776620 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | ||
31362 | 17212 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 231 Olive St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6006210.05924 | 2113680.59084 | 37.7841149534825 | -122.42222374774 | (37.7841149534825, -122.42222374774) | 7 | 9 | 11 | 28858 | 41 | |||
31429 | 131784 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2672 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000209.69016 | 2118190.51282 | 37.7961577408457 | -122.443306841341 | (37.7961577408457, -122.443306841341) | 13 | 9 | 1 | 57 | 17 | |||
31620 | 131917 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1870 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005825.85678 | 2116265.47758 | 37.7911907321235 | -122.423736805829 | (37.7911907321235, -122.423736805829) | 13 | 9 | 1 | 28858 | 27 | |||
32165 | 103580 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
32298 | 232914 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004909.91403 | 2109494.03243 | 37.7725462707313 | -122.426423594296 | (37.7725462707313, -122.426423594296) | 7 | 9 | 5 | 28852 | 10 | |||
32423 | 244509 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 460 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003687.3205 | 2109926.09 | 37.7736634073771 | -122.430683505284 | (37.7736634073771, -122.430683505284) | 7 | 9 | 11 | 29492 | 10 | |||
32906 | 18829 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.424954193796 | (37.791048376629, -122.424954193796) | 13 | 9 | 1 | 28858 | 27 | |||
33259 | 7944 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1715X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005719.3289 | 2115506.1033 | 37.7890996659994 | -122.424051363883 | (37.7890996659994, -122.424051363883) | 13 | 9 | 1 | 28858 | 41 | |||
33522 | 140025 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 619 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005803.6906 | 2111825.1954 | 37.7789975628417 | -122.423497687453 | (37.7789975628417, -122.423497687453) | 7 | 9 | 11 | 28852 | 41 | |||
34303 | 137821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2260 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003077.7361 | 2115191.2965 | 37.7880857910494 | -122.433168428468 | (37.7880857910494, -122.433168428468) | 13 | 9 | 1 | 29490 | 27 | |||
35700 | 17190 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1804X Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4X4 | 6004839.2103 | 2115093.1205 | 37.7879159889562 | -122.427067036821 | (37.7879159889562, -122.427067036821) | 13 | 9 | 11 | 28858 | 27 | |||
36151 | 232435 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1 Church St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 6004121.39652 | 2108664.33355 | 37.7702235143292 | -122.429091988022 | (37.7702235143292, -122.429091988022) | 7 | 9 | 5 | 29492 | 10 | |||
36779 | 138332 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002870.3255 | 2115114.7895 | 37.7878639544693 | -122.433880561554 | (37.7878639544693, -122.433880561554) | 13 | 9 | 11 | 29490 | 27 | |||
36989 | 9731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.423598987459 | (37.7794635560295, -122.423598987459) | 7 | 9 | 11 | 28852 | 41 | |||
37464 | 131957 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005919.70095 | 2120030.27594 | 37.8015332144515 | -122.423679902122 | (37.8015332144515, -122.423679902122) | 5 | 9 | 1 | 28858 | 32 | |||
37920 | 41770 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1320-1360 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42186 | 6006011.16357 | 2120042.84948 | 37.80157290063 | -122.423364294051 | (37.80157290063, -122.423364294051) | 5 | 9 | 1 | 28858 | 32 | |
38591 | 103581 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
38691 | 9732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 645 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2011 12:00:00 AM | 3 | 4x4 | 6005775.5462 | 2112013.5463 | 37.7795131398465 | -122.423608445305 | (37.7795131398465, -122.423608445305) | 7 | 9 | 11 | 28852 | 41 | ||
38723 | 17885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2214 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003222.3202 | 2115211.247 | 37.7881487707297 | -122.432669618765 | (37.7881487707297, -122.432669618765) | 13 | 9 | 1 | 29490 | 27 | |||
38988 | 67111 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1828 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1992 12:00:00 AM | 6 | Permit Number 30528 | 6004418.6275 | 2115152.9607 | 37.788056503265 | -122.428526443858 | (37.788056503265, -122.428526443858) | 13 | 9 | 11 | 28858 | 27 | ||
39257 | 249461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 6 | : | Tree | Private 2 | 9 | Width 4ft | 6006433.55883 | 2113714.71473 | 37.7842212533479 | -122.42145294241 | (37.7842212533479, -122.42145294241) | 7 | 9 | 11 | 28858 | 41 | |||
39396 | 131845 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3265 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999298.17954 | 2120081.87045 | 37.8012988825863 | -122.446596985889 | (37.8012988825863, -122.446596985889) | 13 | 9 | 1 | 57 | 17 | |||
40141 | 34838 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | 7 | 9 | 11 | 28852 | 10 | |||
40305 | 114742 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
40549 | 131815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 149 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 9 | Width 6ft | Permit Number 49255 | 6001582.80517 | 2120278.3225 | 37.8019685213769 | -122.438705274832 | (37.8019685213769, -122.438705274832) | 13 | 9 | 1 | 57 | 17 | |
40829 | 42773 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
41602 | 114741 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
41790 | 131955 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005951.4142 | 2120034.36994 | 37.8015462456249 | -122.423570451039 | (37.8015462456249, -122.423570451039) | 5 | 9 | 1 | 28858 | 32 | |||
42854 | 143547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2237 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002257.1503 | 2118430.5182 | 37.796933274228 | -122.436239411972 | (37.796933274228, -122.436239411972) | 13 | 9 | 1 | 57 | 17 | |||
43055 | 131861 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 5998876.90196 | 2121298.68391 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | 13 | 9 | 1 | 57 | 17 | |||
43500 | 103583 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
44255 | 131947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2137 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006386.49519 | 2118108.61482 | 37.7962831575941 | -122.421927995778 | (37.7962831575941, -122.421927995778) | 13 | 9 | 10 | 28858 | 32 | |||
44397 | 17206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 | |||
44605 | 246528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 1 | : | Tree | Private 2 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | 7 | 9 | 5 | 28852 | 10 | |||
46570 | 18893 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2515 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/22/1998 12:00:00 AM | 5 | 3X3 | 6002606.59443 | 2115769.77975 | 37.7896474207301 | -122.434839879589 | (37.7896474207301, -122.434839879589) | 13 | 9 | 1 | 29490 | 27 | ||
46828 | 17769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1739 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6005596.16237 | 2115493.24585 | 37.7890574080333 | -122.424476589929 | (37.7890574080333, -122.424476589929) | 13 | 9 | 1 | 28858 | 41 | |||
47037 | 131869 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3249 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002752.13191 | 2119809.90093 | 37.8007488104747 | -122.434625342984 | (37.8007488104747, -122.434625342984) | 13 | 9 | 1 | 57 | 17 | |||
47369 | 137921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2202 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003357.4315 | 2115229.1211 | 37.7882055099466 | -122.432203434141 | (37.7882055099466, -122.432203434141) | 13 | 9 | 1 | 29490 | 27 | |||
47658 | 232900 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004744.51087 | 2109324.00731 | 37.7720700716203 | -122.426983629118 | (37.7720700716203, -122.426983629118) | 7 | 9 | 5 | 28852 | 10 | |||
47919 | 18816 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1805X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006086.69341 | 2116261.34321 | 37.7911941008575 | -122.422834023652 | (37.7911941008575, -122.422834023652) | 13 | 9 | 1 | 28858 | 27 | |||
48156 | 131792 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3400 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999280.39152 | 2120532.60597 | 37.8025354648026 | -122.446690989297 | (37.8025354648026, -122.446690989297) | 13 | 9 | 1 | 57 | 17 |
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) );