trees
406 rows where qSpecies_id = 47 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21600 | 105136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175X ESMERALDA AVE | 2 | unknown : Yard | Tree | DPW 1 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | |||||
129532 | 52497 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 371 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48606 | 6007135.79724675 | 2096038.97616324 | 37.7357273409345 | -122.417770123047 | (37.7357273409345, -122.417770123047) | 2 | 7 | 7 | 28859 | 2 | ||
25754 | 47111 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45095 | 6007076.38254046 | 2097931.15674799 | 37.7409195061747 | -122.418109646545 | (37.7409195061747, -122.418109646545) | 2 | 7 | 7 | 28859 | 2 |
107721 | 23670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 317 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006937.9415449 | 2098264.8464559 | 37.7418279505329 | -122.41861198258 | (37.7418279505329, -122.41861198258) | 2 | 7 | 7 | 28859 | 2 | |||
155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 2 | 7 | 7 | 28859 | 2 | |||
88904 | 116681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
78182 | 113478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6006917 | 2098966 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | 2 | 7 | 7 | 28859 | 2 | ||||
84866 | 227691 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006868.92044 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | 2 | 7 | 7 | 28859 | 2 | |||
137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
148994 | 47225 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1643 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45170 | 6006193.94874397 | 2092417.83045771 | 37.7257314225765 | -122.420769469994 | (37.7257314225765, -122.420769469994) | 9 | 7 | 7 | 309 | 5 | ||
14177 | 129468 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | 5 | 1 | 1 | 28858 | 32 | ||||
111648 | 46761 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.7251564045519 | -122.421056498489 | (37.7251564045519, -122.421056498489) | 9 | 7 | 7 | 309 | 5 | |||
157287 | 115975 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006168 | 2102576 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | 2 | 4 | 5 | 28859 | 19 | |||
103423 | 82598 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3503 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006166.2666896 | 2102562.46439955 | 37.7535847553547 | -122.421585344765 | (37.7535847553547, -122.421585344765) | 2 | 4 | 5 | 28859 | 19 | ||
47586 | 57377 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3505 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006157.87748572 | 2102561.9990288 | 37.7535830045092 | -122.421614323469 | (37.7535830045092, -122.421614323469) | 2 | 4 | 5 | 28859 | 19 | ||
115683 | 129467 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6006504.31748 | 2119710.78815 | 37.8006889650949 | -122.421634156713 | (37.8006889650949, -122.421634156713) | 13 | 9 | 1 | 28858 | 32 | |||
58452 | 101254 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3700X Cesar Chavez St | 1 | Front Yard : Yard | Tree | DPW 1 | 6005840.6 | 2100555.6 | 37.7480559984104 | -122.422568977073 | (37.7480559984104, -122.422568977073) | 2 | 4 | 5 | 28859 | 19 | |||||
42446 | 52384 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 36TA MARINA Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48509 | 6005730.58900637 | 2097520.8738626 | 37.7397171218166 | -122.422733759035 | (37.7397171218166, -122.422733759035) | 2 | 7 | 7 | 28859 | 2 | ||
54078 | 52269 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48434 | 6005520.49766263 | 2101354.49181367 | 37.7502315077339 | -122.423732674774 | (37.7502315077339, -122.423732674774) | 2 | 4 | 5 | 28859 | 19 | ||
76454 | 227670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005513.92482 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | 2 | 4 | 5 | 28859 | 19 | |||
141197 | 227672 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.424897379118 | (37.7383979127325, -122.424897379118) | 2 | 7 | 5 | 28859 | 7 | ||||
118985 | 227671 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 10 | 6005087.18528 | 2097058.71456 | 37.7384118144577 | -122.424925504521 | (37.7384118144577, -122.424925504521) | 2 | 7 | 5 | 63 | 7 | ||||
181040 | 227673 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 64 | Front Yard : Yard | Tree | Private 2 | 12 | 6005078.09924 | 2097049.53511 | 37.7383860965292 | -122.424956266738 | (37.7383860965292, -122.424956266738) | 2 | 7 | 5 | 63 | 7 | ||||
121679 | 227674 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 83 | Front Yard : Yard | Tree | Private 2 | 15 | 6005065.10158 | 2097012.05309 | 37.7382824451638 | -122.424998540269 | (37.7382824451638, -122.424998540269) | 2 | 7 | 5 | 63 | 7 | ||||
156310 | 227675 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 104 | Front Yard : Yard | Tree | Private 2 | 27 | 6005040.40727 | 2096975.56438 | 37.7381808604543 | -122.425081325568 | (37.7381808604543, -122.425081325568) | 2 | 7 | 5 | 63 | 7 | ||||
148893 | 42597 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.425158599805 | (37.7919342879744, -122.425158599805) | 13 | 9 | 1 | 28858 | 27 | ||
30568 | 129464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | 13 | 9 | 1 | 28858 | 27 | |||
122863 | 129465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | 13 | 9 | 1 | 28858 | 27 | |||
105151 | 129466 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.7918582853821 | -122.425769315008 | (37.7918582853821, -122.425769315008) | 13 | 9 | 1 | 28858 | 27 | |||
139898 | 105256 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185684 | (37.7195776934466, -122.42687185684) | 9 | 7 | 6 | 28861 | 5 | ||
73352 | 34348 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 330 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38106 | 6004294.50938701 | 2096370.47715627 | 37.7364772644099 | -122.427617172202 | (37.7364772644099, -122.427617172202) | 2 | 7 | 5 | 63 | 7 | ||
67862 | 37850 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681197 | 37.7256681018117 | -122.428552395212 | (37.7256681018117, -122.428552395212) | 9 | 7 | 6 | 28861 | 5 | ||
56832 | 227680 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003988.60954 | 2099295.31119 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | 2 | 7 | 5 | 63 | 22 | |||
22890 | 50289 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
84280 | 50293 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
89527 | 50288 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
112832 | 50290 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | |
113972 | 50292 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | |
193338 | 50291 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
123108 | 227677 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003907.02908 | 2099270.15617 | 37.7444171939021 | -122.429163548878 | (37.7444171939021, -122.429163548878) | 2 | 7 | 5 | 63 | 22 | |||
176307 | 227678 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.7444117377113 | -122.429222690078 | (37.7444117377113, -122.429222690078) | 2 | 7 | 5 | 63 | 22 | |||
63526 | 882 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.97393 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | 9 | 7 | 5 | 28861 | 25 | ||
182837 | 890 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1146 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003547.94647 | 2094400.70663 | 37.7310264639915 | -122.430057882374 | (37.7310264639915, -122.430057882374) | 9 | 7 | 5 | 28861 | 25 | |||
145982 | 227697 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | 15 | 9 | 11 | 29492 | 10 | |||
147419 | 227696 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003774.74871 | 2108065.24722 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | 7 | 9 | 5 | 28862 | 3 | |||
192707 | 49012 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | 2 | 7 | 5 | 63 | 22 | |||
134621 | 227679 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003556.92712 | 2099495.03666 | 37.7450148383554 | -122.430390170187 | (37.7450148383554, -122.430390170187) | 2 | 7 | 5 | 63 | 22 | |||
137505 | 34621 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 370 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2016 12:00:00 AM | 3 | Permit Number 778228 | 6003497.10528776 | 2099542.95496323 | 37.7451430220882 | -122.430600441889 | (37.7451430220882, -122.430600441889) | 2 | 7 | 5 | 63 | 22 | |
77195 | 237551 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.7604095509682 | -122.430689380017 | (37.7604095509682, -122.430689380017) | 2 | 4 | 5 | 28862 | 3 | |
174441 | 889 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1136X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6003353.03343 | 2094335.58352 | 37.7308366096666 | -122.430727084074 | (37.7308366096666, -122.430727084074) | 9 | 7 | 5 | 28861 | 25 | |||
65610 | 237552 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003566.97457 | 2105097.88602 | 37.7603995118464 | -122.430755182518 | (37.7603995118464, -122.430755182518) | 2 | 4 | 5 | 28862 | 3 | |
92382 | 47550 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | 2 | 7 | 5 | 63 | 22 | ||
128589 | 18878 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6003659.52132 | 2115878.15996 | 37.7900047293604 | -122.431204600475 | (37.7900047293604, -122.431204600475) | 13 | 9 | 1 | 29490 | 27 | |||
169833 | 2477 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.7901239554137 | -122.43124522669 | (37.7901239554137, -122.43124522669) | 13 | 9 | 1 | 29490 | 27 | |||
56036 | 909 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003163.68633 | 2094174.89484 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | 9 | 7 | 6 | 28861 | 25 | |||
63925 | 167503 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003389.60758 | 2106563.82057 | 37.7644145648084 | -122.431473265088 | (37.7644145648084, -122.431473265088) | 15 | 4 | 5 | 28862 | 3 | |
62191 | 255989 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003384.96446 | 2106555.65654 | 37.7643918851964 | -122.431488741482 | (37.7643918851964, -122.431488741482) | 15 | 4 | 5 | 28862 | 3 | |
50220 | 18882 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6003557.0695 | 2115907.13274 | 37.7900784748972 | -122.43156114415 | (37.7900784748972, -122.43156114415) | 13 | 9 | 1 | 29490 | 27 | |||
174016 | 167504 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003358.46768 | 2106563.63668 | 37.7644122949287 | -122.431580956196 | (37.7644122949287, -122.431580956196) | 15 | 4 | 5 | 28862 | 3 | |
40263 | 227676 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 427 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | 2 | 7 | 5 | 63 | 22 | ||||
132662 | 176986 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.432060704959 | (37.7170867510327, -122.432060704959) | 9 | 7 | 6 | 28861 | 5 | |||
142493 | 227693 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002979.94012 | 2100929.17253 | 37.7489199393117 | -122.432487701248 | (37.7489199393117, -122.432487701248) | 2 | 4 | 5 | 28862 | 22 | |||
46607 | 176987 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6002815.8897 | 2094148.38707 | 37.7302921639516 | -122.432570708688 | (37.7302921639516, -122.432570708688) | 9 | 7 | 5 | 28861 | 25 | |||
154538 | 926 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6002807.70183 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | 9 | 7 | 5 | 28861 | 25 | |||
193986 | 68368 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 194 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | Permit Number 32189 | 6002712.41508002 | 2094283.54436078 | 37.730657406687 | -122.432938086411 | (37.730657406687, -122.432938086411) | 9 | 7 | 5 | 28861 | 25 | ||
174228 | 227684 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2560 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002253.36783 | 2096984.49578 | 37.7380475512412 | -122.434718147625 | (37.7380475512412, -122.434718147625) | 2 | 7 | 5 | 63 | 7 | |||
130752 | 1383 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | 2 | 7 | 5 | 63 | 7 | |||
48894 | 976 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 6001942.44101 | 2093088.00211 | 37.7273310167784 | -122.435514506557 | (37.7273310167784, -122.435514506557) | 9 | 7 | 6 | 28861 | 25 | |||
105561 | 973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | 9 | 7 | 6 | 28861 | 25 | |||
104265 | 129463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.7916643510872 | -122.436174782264 | (37.7916643510872, -122.436174782264) | 13 | 9 | 1 | 29490 | 27 | |||
148733 | 24276 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 350X Winding Way | 14 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.7100038012068 | -122.438925891137 | (37.7100038012068, -122.438925891137) | 9 | 7 | 6 | 28861 | 5 | |||
177935 | 121420 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1155x Prague St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000780 | 2086820 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | 9 | 7 | 6 | 28861 | 5 | ||||
99445 | 9277 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000049.09202 | 2089751.67924 | 37.7180625213905 | -122.441820442737 | (37.7180625213905, -122.441820442737) | 9 | 7 | 6 | 28861 | 25 | |||
29255 | 176982 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5999995.5387 | 2089705.60981 | 37.7179329735202 | -122.442002247903 | (37.7179329735202, -122.442002247903) | 9 | 7 | 6 | 28861 | 25 | |||
174502 | 16565 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.7168706139428 | -122.443365227339 | (37.7168706139428, -122.443365227339) | 9 | 7 | 6 | 28861 | 25 | |||
177777 | 16566 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.7168063779221 | -122.443430230482 | (37.7168063779221, -122.443430230482) | 9 | 7 | 6 | 28861 | 25 | |||
95742 | 176981 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 1ft | 5999571.4621 | 2089300.92693 | 37.7167976306892 | -122.443439037193 | (37.7167976306892, -122.443439037193) | 9 | 7 | 6 | 28861 | 25 | |||
127819 | 227694 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.443491144794 | (37.7592869569347, -122.443491144794) | 2 | 4 | 5 | 28862 | 3 | |||
29184 | 176980 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5999548.76247 | 2089280.82364 | 37.7167411370713 | -122.443516055124 | (37.7167411370713, -122.443516055124) | 9 | 7 | 6 | 28861 | 25 | |||
68936 | 13417 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 400 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 70 | 5 | 5999553.15658 | 2097034.91654 | 37.7380323275191 | -122.444057708717 | (37.7380323275191, -122.444057708717) | 9 | 7 | 4 | 59 | 40 | |||
50732 | 253463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
70915 | 253464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
150375 | 253465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
159025 | 253462 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
75879 | 176985 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2571 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5998574.33272 | 2088565.20963 | 37.7147206041402 | -122.446832699994 | (37.7147206041402, -122.446832699994) | 9 | 7 | 6 | 28861 | 25 | |||
69315 | 138260 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | 15 | 5 | 1 | 54 | 16 | |||
47779 | 138264 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 32 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.446995936272 | (37.7823276740968, -122.446995936272) | 15 | 5 | 1 | 54 | 16 | |||
163946 | 117519 | Undocumented 4 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1601 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998904 | 2109014 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | 15 | 5 | 11 | 29492 | 9 | ||||
166333 | 244098 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.7708313932465 | -122.447469528169 | (37.7708313932465, -122.447469528169) | 15 | 5 | 11 | 29492 | 9 | |||
5099 | 261940 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Verna St | 5 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
37655 | 207106 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Tara St | 2 | : | Tree | Private 2 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | 9 | 8 | 6 | 28861 | 24 | |||
121491 | 31546 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.449190424029 | (37.7809035197163, -122.449190424029) | 15 | 6 | 2 | 54 | 16 | |
118542 | 138270 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.449227076582 | (37.7809154323836, -122.449227076582) | 15 | 6 | 2 | 54 | 16 | |||
174440 | 246123 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 35 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779621 | 5998184.8878 | 2108385.4066 | 37.7691198159889 | -122.449606139087 | (37.7691198159889, -122.449606139087) | 15 | 5 | 11 | 29492 | 9 | |
49514 | 227681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997959.25406 | 2106183.43699 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | 15 | 5 | 11 | 29492 | 9 | |||
86130 | 52103 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | 9 | 7 | 4 | 59 | 40 | ||
43157 | 227687 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.451424345184 | (37.7653509793933, -122.451424345184) | 15 | 5 | 11 | 29492 | 9 | |||
62642 | 227686 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997629.48637 | 2107046.84316 | 37.7654126728718 | -122.451430672783 | (37.7654126728718, -122.451430672783) | 15 | 5 | 11 | 29492 | 9 | |||
4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
59472 | 52106 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | 9 | 7 | 4 | 59 | 40 |
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) );