trees
3,709 rows where qSpecies_id = 9 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
122109 | 50498 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.78564 | 37.7141545573574 | -122.433096072852 | (37.7141545573574, -122.433096072852) | 9 | 7 | 6 | 28861 | 5 | |
164173 | 18616 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 715 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5992096.2291 | 2088496.6198 | 37.7141600639726 | -122.469218501712 | (37.7141600639726, -122.469218501712) | 9 | 8 | 6 | 64 | 24 | |||
79629 | 18615 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992139.1908 | 2088496.6198 | 37.7141625464129 | -122.469070010847 | (37.7141625464129, -122.469070010847) | 9 | 8 | 6 | 64 | 24 | |||
191605 | 18613 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 645 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992222.8127 | 2088500.1488 | 37.7141770675516 | -122.468781240528 | (37.7141770675516, -122.468781240528) | 9 | 8 | 6 | 64 | 24 | |||
68351 | 18609 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 5992399.8764 | 2088496.7733 | 37.7141780269744 | -122.468168999945 | (37.7141780269744, -122.468168999945) | 9 | 8 | 6 | 64 | 24 | |||
72526 | 18605 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 533 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992541.0363 | 2088494.6252 | 37.7141802803508 | -122.467680944889 | (37.7141802803508, -122.467680944889) | 9 | 8 | 6 | 64 | 24 | |||
188653 | 18599 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 449 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/1996 12:00:00 AM | 12 | 3X3 | 5992745.528 | 2088491.5039 | 37.7141835151811 | -122.466973921771 | (37.7141835151811, -122.466973921771) | 9 | 8 | 6 | 64 | 24 | ||
80897 | 31169 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34870 | 5992182.10994821 | 2088503.70058995 | 37.7141844683459 | -122.468922182021 | (37.7141844683459, -122.468922182021) | 9 | 8 | 6 | 64 | 24 | |
151828 | 18601 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 509 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5992650.5887 | 2088494.932 | 37.7141874476643 | -122.467302314998 | (37.7141874476643, -122.467302314998) | 9 | 8 | 6 | 64 | 24 | |||
129214 | 18587 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993176.8455 | 2088486.1085 | 37.7141935864691 | -122.4654827422 | (37.7141935864691, -122.4654827422) | 9 | 8 | 6 | 64 | 24 | ||
7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
155730 | 17241 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5993905.3882 | 2088478.8088 | 37.714215535169 | -122.462964106477 | (37.714215535169, -122.462964106477) | 9 | 8 | 6 | 64 | 24 | |||
61370 | 76728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 10 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
119464 | 76771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
129428 | 76768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
140619 | 76757 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
72108 | 18611 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 618 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992335.2804 | 2088560.1418 | 37.7143482906927 | -122.468396874173 | (37.7143482906927, -122.468396874173) | 9 | 8 | 6 | 64 | 24 | |||
128397 | 18600 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1992 12:00:00 AM | 6 | 3X3 | 5992650.7421 | 2088555.8456 | 37.7143547106063 | -122.467306211311 | (37.7143547106063, -122.467306211311) | 9 | 8 | 6 | 64 | 24 | ||
125337 | 18595 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 400 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5992880.7313 | 2088552.758 | 37.7143595070954 | -122.466511060282 | (37.7143595070954, -122.466511060282) | 9 | 8 | 6 | 64 | 24 | |||
142123 | 18594 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 400 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5992917.5472 | 2088553.0754 | 37.7143625030062 | -122.466383834117 | (37.7143625030062, -122.466383834117) | 9 | 8 | 6 | 64 | 24 | |||
93646 | 18578 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 114 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5993641.4878 | 2088544.8235 | 37.7143815912468 | -122.463881030417 | (37.7143815912468, -122.463881030417) | 9 | 8 | 6 | 64 | 24 | |||
159028 | 18574 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 24 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993864.1289 | 2088541.8084 | 37.7143861403954 | -122.463111281888 | (37.7143861403954, -122.463111281888) | 9 | 8 | 6 | 64 | 24 | |||
74360 | 177864 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001714.74238 | 2088380.40679 | 37.7143920818056 | -122.43596495334 | (37.7143920818056, -122.43596495334) | 9 | 7 | 6 | 28861 | 5 | |||
193284 | 177865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001720.67634 | 2088389.37557 | 37.7144170451902 | -122.43594508462 | (37.7144170451902, -122.43594508462) | 9 | 7 | 6 | 28861 | 5 | |||
158288 | 177866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001726.64511 | 2088400.0268 | 37.7144466301838 | -122.43592521588 | (37.7144466301838, -122.43592521588) | 9 | 7 | 6 | 28861 | 5 | |||
100065 | 98885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5994871.8 | 2088553.5 | 37.7144762388107 | -122.459629241673 | (37.7144762388107, -122.459629241673) | 9 | 8 | 6 | 28861 | 24 | ||
51736 | 53477 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 310 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1969 12:00:00 AM | 14 | 4x5 | Permit Number 6386 | 5994039.73667493 | 2088736.05427739 | 37.7149296078016 | -122.462518397729 | (37.7149296078016, -122.462518397729) | 9 | 8 | 6 | 28861 | 24 | |
31370 | 210711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 310 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994028.62821 | 2088760.05738 | 37.7149948748848 | -122.462558533061 | (37.7149948748848, -122.462558533061) | 9 | 8 | 6 | 28861 | 24 | |||
291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
110390 | 177935 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989493.36658 | 2088932.77712 | 37.7152068945538 | -122.478246769977 | (37.7152068945538, -122.478246769977) | 1 | 8 | 4 | 64 | 14 | ||||
137788 | 177936 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989491.06081 | 2088964.93712 | 37.7152950640932 | -122.478257089699 | (37.7152950640932, -122.478257089699) | 1 | 8 | 4 | 64 | 14 | ||||
3001 | 80365 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 Campbell Ave | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 1 | 6010298.58269 | 2088549.93008 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | 9 | 7 | 8 | 309 | 39 | |||
1512 | 177963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5988967.05933 | 2088996.09626 | 37.7153501871281 | -122.480070526755 | (37.7153501871281, -122.480070526755) | 1 | 8 | 4 | 64 | 14 | ||||
87980 | 177937 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989487.39768 | 2088989.39507 | 37.7153620069155 | -122.478271538203 | (37.7153620069155, -122.478271538203) | 1 | 8 | 4 | 64 | 14 | ||||
49334 | 177883 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 502 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010280.18784 | 2088557.91427 | 37.7153623567706 | -122.40637173349 | (37.7153623567706, -122.40637173349) | 9 | 7 | 8 | 309 | 39 | |||
146587 | 177964 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988925.38088 | 2089008.91353 | 37.7153829584191 | -122.480215521739 | (37.7153829584191, -122.480215521739) | 1 | 8 | 4 | 64 | 14 | ||||
12482 | 177894 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010334.18865 | 2088569.51073 | 37.7153972189891 | -122.406185898468 | (37.7153972189891, -122.406185898468) | 9 | 7 | 8 | 309 | 39 | |||
161013 | 177893 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010340.10601 | 2088584.08173 | 37.7154375589705 | -122.406166471321 | (37.7154375589705, -122.406166471321) | 9 | 7 | 8 | 309 | 39 | |||
63497 | 177892 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010348.87494 | 2088600.69344 | 37.7154836618219 | -122.406137331491 | (37.7154836618219, -122.406137331491) | 9 | 7 | 8 | 309 | 39 | |||
28195 | 177938 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989480.91989 | 2089050.18574 | 37.7155285469807 | -122.478298370392 | (37.7155285469807, -122.478298370392) | 1 | 8 | 4 | 64 | 14 | ||||
46347 | 177891 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010352.02594 | 2088617.41992 | 37.7155297655706 | -122.406127617893 | (37.7155297655706, -122.406127617893) | 9 | 7 | 8 | 309 | 39 | |||
83125 | 177890 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010359.41892 | 2088635.45885 | 37.7155797103057 | -122.406103334421 | (37.7155797103057, -122.406103334421) | 9 | 7 | 8 | 309 | 39 | |||
7404 | 210734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992990.46687 | 2089001.91036 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | 9 | 8 | 6 | 64 | 24 | |||
90815 | 210735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 274 Ramsell St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992991.6057 | 2089025.54794 | 37.7156640721019 | -122.466162174951 | (37.7156640721019, -122.466162174951) | 9 | 8 | 6 | 64 | 24 | |||
159208 | 254192 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 131 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/18/2018 12:00:00 AM | 3 | 3x3 | 5989195 | 2089107 | 37.7156679426736 | -122.479290780653 | (37.7156679426736, -122.479290780653) | 1 | 8 | 4 | 64 | 14 | ||
136049 | 105994 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 131 GRIJALVA DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989195.7 | 2089107.3 | 37.7156688070552 | -122.479288383095 | (37.7156688070552, -122.479288383095) | 1 | 8 | 4 | 64 | 14 | ||||
107894 | 177860 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5999854.50154 | 2088904.19241 | 37.7157244247064 | -122.442432245267 | (37.7157244247064, -122.442432245267) | 9 | 7 | 6 | 28861 | 25 | |||
23967 | 210736 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 279 Ramsell St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992958.08764 | 2089050.23377 | 37.7157299195648 | -122.466279820655 | (37.7157299195648, -122.466279820655) | 9 | 8 | 6 | 64 | 24 | |||
8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
13349 | 261323 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 278 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993017 | 2089051 | 37.7157354224316 | -122.466076249864 | (37.7157354224316, -122.466076249864) | 9 | 8 | 6 | 64 | 24 | ||||
170558 | 177962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989078.7127 | 2089134.39971 | 37.7157364207672 | -122.479694721656 | (37.7157364207672, -122.479694721656) | 1 | 8 | 4 | 64 | 14 | ||||
180676 | 177940 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989427.62768 | 2089128.02152 | 37.7157391708956 | -122.478488258642 | (37.7157391708956, -122.478488258642) | 1 | 8 | 4 | 64 | 14 | ||||
117932 | 177923 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988561.02848 | 2089156.81478 | 37.7157678799561 | -122.481485695422 | (37.7157678799561, -122.481485695422) | 1 | 8 | 4 | 64 | 14 | ||||
39295 | 15831 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5179 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1995 12:00:00 AM | 6 | 3X3 | 6000153.21338 | 2088921.93918 | 37.715790175057 | -122.441401035832 | (37.715790175057, -122.441401035832) | 9 | 7 | 6 | 28861 | 5 | ||
86323 | 210737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 283 Ramsell St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992959.06004 | 2089081.22924 | 37.7158150817716 | -122.466278710897 | (37.7158150817716, -122.466278710897) | 9 | 8 | 6 | 64 | 24 | |||
178134 | 32741 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 234 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43375 | 5994675.9266539 | 2089047.50718001 | 37.7158214002357 | -122.460342025585 | (37.7158214002357, -122.460342025585) | 9 | 8 | 6 | 28861 | 24 | ||
192263 | 177961 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989118.28423 | 2089183.86132 | 37.7158745287534 | -122.479561562622 | (37.7158745287534, -122.479561562622) | 1 | 8 | 4 | 64 | 14 | ||||
165570 | 177960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989129.76935 | 2089200.6687 | 37.7159213447791 | -122.479523094137 | (37.7159213447791, -122.479523094137) | 1 | 8 | 4 | 64 | 14 | ||||
187180 | 177959 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989083.70402 | 2089208.46347 | 37.7159400713658 | -122.479682885652 | (37.7159400713658, -122.479682885652) | 1 | 8 | 4 | 64 | 14 | ||||
168209 | 210738 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 291 Ramsell St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992961.95972 | 2089127.53233 | 37.7159423862175 | -122.46627205144 | (37.7159423862175, -122.46627205144) | 9 | 8 | 6 | 64 | 24 | |||
90976 | 103877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 7x9 | 6002369.63002 | 2088931.52673 | 37.7159425175008 | -122.433740770734 | (37.7159425175008, -122.433740770734) | 9 | 7 | 6 | 28861 | 5 | |||
194435 | 103878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2017 12:00:00 AM | 3 | 6x6 | Permit Number 776939 | 6002377.91546 | 2088944.75079 | 37.7159792979937 | -122.433713076995 | (37.7159792979937, -122.433713076995) | 9 | 7 | 6 | 28861 | 5 | |
100529 | 210710 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 389 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994002.44073 | 2089155.53894 | 37.7160792648303 | -122.462677719297 | (37.7160792648303, -122.462677719297) | 9 | 8 | 6 | 64 | 24 | |||
9238 | 177934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | 1 | 8 | 4 | 64 | 14 | ||||
148122 | 210709 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 389 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994001.88114 | 2089168.33159 | 37.7161143581664 | -122.462680580956 | (37.7161143581664, -122.462680580956) | 9 | 8 | 6 | 64 | 24 | |||
56001 | 177922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990625.84661 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | 1 | 8 | 4 | 64 | 14 | |||
82311 | 60468 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 153 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20061 | 5996949.68072772 | 2089116.47275902 | 37.7161412978071 | -122.452487894641 | (37.7161412978071, -122.452487894641) | 9 | 8 | 6 | 28861 | 24 | ||
129911 | 210708 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5993993.93281 | 2089184.16477 | 37.7161573745291 | -122.462709201884 | (37.7161573745291, -122.462709201884) | 9 | 8 | 6 | 64 | 24 | |||
119745 | 177921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.474319162615 | (37.7161606912434, -122.474319162615) | 1 | 8 | 4 | 64 | 14 | |||
111656 | 177957 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989199.22849 | 2089287.00846 | 37.7161624467126 | -122.479289326156 | (37.7161624467126, -122.479289326156) | 1 | 8 | 4 | 64 | 14 | ||||
172203 | 210707 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994004.02055 | 2089191.37438 | 37.716177751384 | -122.462674856786 | (37.716177751384, -122.462674856786) | 9 | 8 | 6 | 64 | 24 | |||
186466 | 210706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994003.39155 | 2089200.86992 | 37.7162037876449 | -122.462677719319 | (37.7162037876449, -122.462677719319) | 9 | 8 | 6 | 64 | 24 | |||
36811 | 46745 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
68744 | 46748 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | |||
71863 | 46747 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
108989 | 46744 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | |||
135482 | 46746 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
143228 | 177933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988685.34824 | 2089320.71628 | 37.7162251402652 | -122.481067988213 | (37.7162251402652, -122.481067988213) | 1 | 8 | 4 | 64 | 14 | ||||
155324 | 177958 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989169.01716 | 2089315.78059 | 37.7162396930894 | -122.479395853531 | (37.7162396930894, -122.479395853531) | 1 | 8 | 4 | 64 | 14 | ||||
133241 | 177941 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989724.37872 | 2089308.83263 | 37.7162528573591 | -122.477475769516 | (37.7162528573591, -122.477475769516) | 1 | 8 | 4 | 64 | 14 | ||||
91884 | 177932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988789.67714 | 2089358.25698 | 37.7163342819918 | -122.480710128176 | (37.7163342819918, -122.480710128176) | 1 | 8 | 4 | 64 | 14 | ||||
192389 | 177931 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988808.76092 | 2089375.86435 | 37.7163837365992 | -122.480645454328 | (37.7163837365992, -122.480645454328) | 1 | 8 | 4 | 64 | 14 | ||||
131577 | 177956 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989293.3686 | 2089406.92644 | 37.7164971788871 | -122.478972702723 | (37.7164971788871, -122.478972702723) | 1 | 8 | 4 | 64 | 14 | ||||
92388 | 177930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988862.76325 | 2089422.54432 | 37.7165150466091 | -122.480462212988 | (37.7165150466091, -122.480462212988) | 1 | 8 | 4 | 64 | 14 | ||||
38141 | 210728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 113 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997053.85221 | 2089279.44742 | 37.716594756218 | -122.4521395823 | (37.716594756218, -122.4521395823) | 9 | 8 | 6 | 28861 | 24 | |||
190001 | 177942 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989710.75871 | 2089436.68507 | 37.7166031181237 | -122.477532185763 | (37.7166031181237, -122.477532185763) | 1 | 8 | 4 | 64 | 14 | ||||
177831 | 177929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988839.75679 | 2089455.3276 | 37.7166037242653 | -122.480544132207 | (37.7166037242653, -122.480544132207) | 1 | 8 | 4 | 64 | 14 | ||||
194431 | 265089 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 747 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002550 | 2089172 | 37.7166130372881 | -122.433134500018 | (37.7166130372881, -122.433134500018) | 9 | 7 | 6 | 28861 | 5 | ||||
118117 | 177928 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5988855.6313 | 2089468.65527 | 37.7166412412847 | -122.480490237638 | (37.7166412412847, -122.480490237638) | 1 | 8 | 4 | 64 | 14 | ||||
180172 | 60462 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 113 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20048 | 5997094.17901268 | 2089323.97099125 | 37.7167193175881 | -122.452003403891 | (37.7167193175881, -122.452003403891) | 9 | 8 | 6 | 28861 | 24 | ||
141505 | 177927 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | 1 | 8 | 4 | 64 | 14 | ||||
60585 | 177955 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5989333.41698 | 2089519.46327 | 37.7168085025868 | -122.478842503398 | (37.7168085025868, -122.478842503398) | 1 | 8 | 4 | 64 | 14 | ||||
30778 | 50494 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 821 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/2014 12:00:00 AM | 1 | Permit Number 772457 | 6003014.84349 | 2089242.88308 | 37.7168340244398 | -122.431532827182 | (37.7168340244398, -122.431532827182) | 9 | 7 | 6 | 28861 | 5 | |
139082 | 177926 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5988935.7978 | 2089543.35128 | 37.7168509964648 | -122.480218609114 | (37.7168509964648, -122.480218609114) | 1 | 8 | 4 | 64 | 14 | ||||
3596 | 264801 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011023 | 2089107 | 37.7169115603385 | -122.403842847789 | (37.7169115603385, -122.403842847789) | 10 | 7 | 8 | 309 | 39 | ||||
144120 | 177954 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989416.48515 | 2089561.18461 | 37.7169278821906 | -122.478558430025 | (37.7169278821906, -122.478558430025) | 1 | 8 | 4 | 64 | 14 | ||||
31762 | 177953 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989426.93386 | 2089569.48868 | 37.7169512897353 | -122.478522921221 | (37.7169512897353, -122.478522921221) | 1 | 8 | 4 | 64 | 14 | ||||
180758 | 177952 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989400.28977 | 2089605.00468 | 37.7170472609007 | -122.478617611739 | (37.7170472609007, -122.478617611739) | 1 | 8 | 4 | 64 | 14 | ||||
155960 | 177870 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003581.97685 | 2089338.65901 | 37.7171291324866 | -122.429579352212 | (37.7171291324866, -122.429579352212) | 9 | 7 | 6 | 28861 | 5 | |||
34316 | 177869 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002755.50618 | 2089362.7676 | 37.7171484984792 | -122.4324377862 | (37.7171484984792, -122.4324377862) | 9 | 7 | 6 | 28861 | 5 |
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) );