trees
494 rows where qSpecies_id = 243 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2950 | 19885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
6530 | 20001 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
7827 | 115725 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250X Octavia St | 2 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
15870 | 19880 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
192454 | 179670 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 300x Winding Way | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6001487.80324 | 2086473.73507 | 37.7091438874604 | -122.436612949055 | (37.7091438874604, -122.436612949055) | 9 | 7 | 6 | 28861 | 5 | |||
13180 | 179663 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 333 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012567.36741 | 2086868.9308 | 37.7108524248833 | -122.398347742071 | (37.7108524248833, -122.398347742071) | 10 | 3 | 8 | 309 | 1 | |||
37142 | 105552 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 329 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6012582.61187 | 2086912.65676 | 37.7109733369276 | -122.398298119266 | (37.7109733369276, -122.398298119266) | 10 | 3 | 8 | 309 | 1 | ||||
28719 | 179664 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 325 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6012585.69681 | 2086923.17392 | 37.711002386816 | -122.398288194338 | (37.711002386816, -122.398288194338) | 10 | 3 | 8 | 309 | 1 | |||
136823 | 179665 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 325 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6012591.22281 | 2086940.79015 | 37.7110510653234 | -122.398270330217 | (37.7110510653234, -122.398270330217) | 10 | 3 | 8 | 309 | 1 | |||
36253 | 16409 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1186X Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | TR | 6001094.97043 | 2087182.82135 | 37.7110685499383 | -122.438021394384 | (37.7110685499383, -122.438021394384) | 9 | 7 | 6 | 28861 | 5 | |||
44044 | 179666 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 309 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012604.11309 | 2086981.70393 | 37.7111641245081 | -122.398228646659 | (37.7111641245081, -122.398228646659) | 10 | 3 | 8 | 309 | 1 | |||
152940 | 179667 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 309 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012610.18411 | 2086997.87945 | 37.7112088774584 | -122.398208797709 | (37.7112088774584, -122.398208797709) | 10 | 3 | 8 | 309 | 1 | |||
124480 | 179668 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 301 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012612.99348 | 2087008.97407 | 37.7112394975798 | -122.398199865648 | (37.7112394975798, -122.398199865648) | 10 | 3 | 8 | 309 | 1 | |||
44118 | 179637 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 120 Farragut Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5997385.09042 | 2087337.68892 | 37.7112821038472 | -122.450854733483 | (37.7112821038472, -122.450854733483) | 9 | 7 | 6 | 28861 | 25 | |||
134422 | 179669 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 301 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012620.01263 | 2087029.41964 | 37.7112960280502 | -122.398177039048 | (37.7112960280502, -122.398177039048) | 10 | 3 | 8 | 309 | 1 | |||
118771 | 179794 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 640 Rolph St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6002828.72839 | 2087264.39121 | 37.7113909685913 | -122.432034933064 | (37.7113909685913, -122.432034933064) | 9 | 7 | 6 | 28861 | 5 | |||
106726 | 179671 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009275.06023 | 2087222.94519 | 37.71164052686 | -122.409751738267 | (37.71164052686, -122.409751738267) | 9 | 7 | 8 | 309 | 39 | |||
165463 | 179672 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6009276.50354 | 2087227.45755 | 37.7116529977608 | -122.409747068083 | (37.7116529977608, -122.409747068083) | 9 | 7 | 8 | 309 | 39 | |||
129410 | 179662 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 200 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6012226.23754 | 2087173.50879 | 37.7116697269483 | -122.399548143633 | (37.7116697269483, -122.399548143633) | 10 | 3 | 8 | 309 | 1 | |||
167069 | 179673 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 701 Delta St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009280.11553 | 2087236.74684 | 37.7116787066663 | -122.40973523929 | (37.7116787066663, -122.40973523929) | 9 | 7 | 8 | 309 | 39 | |||
186099 | 179795 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 433 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002164.81137 | 2087709.16432 | 37.7125745555472 | -122.434361376687 | (37.7125745555472, -122.434361376687) | 9 | 7 | 6 | 28861 | 5 | |||
99273 | 179636 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 9 Moneta Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5997940.69552 | 2088047.53237 | 37.7132629622883 | -122.448985532167 | (37.7132629622883, -122.448985532167) | 9 | 7 | 6 | 28861 | 25 | |||
179257 | 179635 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 9 Moneta Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997908.32309 | 2088048.3986 | 37.7132634892865 | -122.449097484276 | (37.7132634892865, -122.449097484276) | 9 | 7 | 6 | 28861 | 25 | ||||
188996 | 179661 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 4 | Side Yard : Yard | Tree | Private 2 | 10 | 6012216.37842 | 2087780.43205 | 37.7133356679799 | -122.399624805455 | (37.7133356679799, -122.399624805455) | 10 | 3 | 8 | 309 | 1 | ||||
145047 | 179659 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 2 | Side Yard : Yard | Tree | Private 2 | 8 | 6012208.68796 | 2087783.6774 | 37.7133441503725 | -122.399651614248 | (37.7133441503725, -122.399651614248) | 10 | 3 | 8 | 309 | 1 | ||||
110486 | 179660 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 287 Hester Ave | 3 | Side Yard : Yard | Tree | Private 2 | 8 | 6012212.84494 | 2087789.77212 | 37.7133611169841 | -122.399637673848 | (37.7133611169841, -122.399637673848) | 10 | 3 | 8 | 309 | 1 | ||||
166340 | 179634 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 256 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999057.74482 | 2088126.56922 | 37.7135438016737 | -122.445130318423 | (37.7135438016737, -122.445130318423) | 9 | 7 | 6 | 28861 | 25 | |||
164242 | 179633 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 256 Ellington Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999062.81319 | 2088131.65291 | 37.7135580496254 | -122.445113165646 | (37.7135580496254, -122.445113165646) | 9 | 7 | 6 | 28861 | 25 | |||
26310 | 187552 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Beeman Ln | 1 | Side Yard : Yard | Tree | Private 2 | 35 | 6012028.62057 | 2088183.94027 | 37.7144331529482 | -122.400302089394 | (37.7144331529482, -122.400302089394) | 10 | 7 | 8 | 309 | 39 | ||||
31815 | 179630 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 290 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998313.80825 | 2088717.96768 | 37.7151251560878 | -122.447744166462 | (37.7151251560878, -122.447744166462) | 9 | 7 | 6 | 28861 | 25 | |||
24220 | 179638 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 286 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998314.38547 | 2088719.36109 | 37.7151290150634 | -122.447742271601 | (37.7151290150634, -122.447742271601) | 9 | 7 | 6 | 28861 | 25 | |||
177744 | 179639 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 286 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998303.30516 | 2088729.74058 | 37.7151568814675 | -122.447781316552 | (37.7151568814675, -122.447781316552) | 9 | 7 | 6 | 28861 | 25 | |||
148672 | 179645 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 900 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6001612.66073 | 2088823.27551 | 37.7156023012857 | -122.43634946387 | (37.7156023012857, -122.43634946387) | 9 | 7 | 6 | 28861 | 5 | |||
123001 | 179644 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 900 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6001616.89073 | 2088831.6058 | 37.7156254147599 | -122.436335438935 | (37.7156254147599, -122.436335438935) | 9 | 7 | 6 | 28861 | 5 | |||
79733 | 179646 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6001175.91542 | 2089143.93183 | 37.7164579261785 | -122.437882003961 | (37.7164579261785, -122.437882003961) | 9 | 7 | 6 | 28861 | 5 | |||
60830 | 179647 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6001184.8946 | 2089159.50887 | 37.7165012078479 | -122.43785208261 | (37.7165012078479, -122.43785208261) | 9 | 7 | 6 | 28861 | 5 | |||
97469 | 179648 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 786 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6001194.88831 | 2089176.29641 | 37.7165478709616 | -122.437818741162 | (37.7165478709616, -122.437818741162) | 9 | 7 | 6 | 28861 | 5 | |||
49407 | 179631 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 184 Mount Vernon Ave | 11 | Side Yard : Yard | Tree | Private 2 | 10 | 5998932.98787 | 2089405.36091 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | 9 | 7 | 6 | 28861 | 25 | ||||
175975 | 215249 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5992441.12756 | 2089702.71282 | 37.717491627621 | -122.468114091393 | (37.717491627621, -122.468114091393) | 9 | 8 | 6 | 64 | 24 | |||
82960 | 215243 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 284 Thrift St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 5994231.73056 | 2089665.25289 | 37.7174920206045 | -122.461922130513 | (37.7174920206045, -122.461922130513) | 9 | 8 | 6 | 28861 | 24 | ||||
168914 | 215248 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992441.33528 | 2089712.58876 | 37.717518756553 | -122.468114091406 | (37.717518756553, -122.468114091406) | 9 | 8 | 6 | 64 | 24 | |||
59476 | 215247 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992441.17613 | 2089717.25616 | 37.7175315629099 | -122.468114980839 | (37.7175315629099, -122.468114980839) | 9 | 8 | 6 | 64 | 24 | |||
133591 | 215246 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 279 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992441.1535 | 2089722.09297 | 37.7175448423099 | -122.468115410705 | (37.7175448423099, -122.468115410705) | 9 | 8 | 6 | 64 | 24 | |||
167017 | 19344 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 526 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 5992574.47288 | 2089868.50561 | 37.7179545545446 | -122.467665232592 | (37.7179545545446, -122.467665232592) | 9 | 8 | 6 | 64 | 24 | |||
126379 | 215252 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 401 Victoria St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5993219.33811 | 2089885.0414 | 37.7180371707569 | -122.465437434717 | (37.7180371707569, -122.465437434717) | 9 | 8 | 6 | 64 | 24 | |||
145734 | 215251 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 401 Victoria St | 8 | : | Tree | Private 2 | 12 | Width 2ft | 5993228.9557 | 2089914.8953 | 37.7181196970457 | -122.46540635862 | (37.7181196970457, -122.46540635862) | 9 | 8 | 6 | 64 | 24 | |||
151863 | 215245 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 318 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992229.52127 | 2090002.05617 | 37.7183013286233 | -122.468867281705 | (37.7183013286233, -122.468867281705) | 9 | 8 | 6 | 64 | 24 | |||
169359 | 197888 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 955 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013536.79803 | 2089586.31829 | 37.7183677903304 | -122.395187363419 | (37.7183677903304, -122.395187363419) | 10 | 3 | 8 | 58 | 1 | ||||
56345 | 179632 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1277 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5999581.03215 | 2090102.74199 | 37.7189997781048 | -122.443463521241 | (37.7189997781048, -122.443463521241) | 9 | 7 | 6 | 28861 | 25 | |||
168902 | 197889 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1098 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012673.3872 | 2089947.03209 | 37.7193101835929 | -122.398197126321 | (37.7193101835929, -122.398197126321) | 10 | 3 | 8 | 58 | 1 | |||
132777 | 179649 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 567 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001885.83058 | 2090189.0326 | 37.7193678841138 | -122.435502912226 | (37.7193678841138, -122.435502912226) | 9 | 7 | 6 | 28861 | 5 | |||
32092 | 179650 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 567 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001888.79555 | 2090193.80134 | 37.719381146405 | -122.435493004403 | (37.719381146405, -122.435493004403) | 9 | 7 | 6 | 28861 | 5 | |||
92917 | 215244 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 290 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5991718.94325 | 2090452.86708 | 37.7195096334551 | -122.470664935645 | (37.7195096334551, -122.470664935645) | 9 | 8 | 6 | 64 | 24 | |||
115658 | 215241 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 978 Capitol Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 5995069.40558 | 2090424.49054 | 37.7196248968642 | -122.459081637134 | (37.7196248968642, -122.459081637134) | 9 | 8 | 6 | 28861 | 24 | |||
95315 | 215242 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 978 Capitol Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5995069.34707 | 2090438.49633 | 37.7196633500672 | -122.459082852985 | (37.7196633500672, -122.459082852985) | 9 | 8 | 6 | 28861 | 24 | |||
113269 | 179657 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002562.87891 | 2090358.04011 | 37.7198703712871 | -122.433174679891 | (37.7198703712871, -122.433174679891) | 9 | 7 | 6 | 28861 | 5 | |||
94234 | 179656 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002583.76122 | 2090389.8333 | 37.7199588528956 | -122.433104767489 | (37.7199588528956, -122.433104767489) | 9 | 7 | 6 | 28861 | 5 | |||
184740 | 179655 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6002626.5609 | 2090458.35615 | 37.7201494291437 | -122.432961716828 | (37.7201494291437, -122.432961716828) | 9 | 7 | 6 | 28861 | 5 | |||
49845 | 215250 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 520 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5992758.1847 | 2090664.52836 | 37.7201508455634 | -122.467088069255 | (37.7201508455634, -122.467088069255) | 9 | 8 | 6 | 64 | 24 | |||
66085 | 179654 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002647.12563 | 2090489.8461 | 37.7202370599795 | -122.432892880025 | (37.7202370599795, -122.432892880025) | 9 | 7 | 6 | 28861 | 5 | |||
165582 | 179653 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6002670.92192 | 2090527.15665 | 37.7203408561316 | -122.432813288222 | (37.7203408561316, -122.432813288222) | 9 | 7 | 6 | 28861 | 5 | |||
44987 | 179658 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 579 Madrid St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002445.72289 | 2090555.63899 | 37.7204062871908 | -122.433593761257 | (37.7204062871908, -122.433593761257) | 9 | 7 | 6 | 28861 | 5 | |||
193909 | 179652 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6002692.5092 | 2090562.96331 | 37.7204403975978 | -122.43274122465 | (37.7204403975978, -122.43274122465) | 9 | 7 | 6 | 28861 | 5 | |||
67636 | 215240 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995902.13017 | 2090713.19411 | 37.7204654445931 | -122.456224088976 | (37.7204654445931, -122.456224088976) | 9 | 8 | 6 | 28861 | 24 | |||
83517 | 179651 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 570 Edinburgh St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002715.97514 | 2090599.35086 | 37.7205416405563 | -122.432662708433 | (37.7205416405563, -122.432662708433) | 9 | 7 | 6 | 28861 | 5 | |||
48868 | 179640 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000461.77381 | 2090733.06087 | 37.7207806794643 | -122.440464330785 | (37.7207806794643, -122.440464330785) | 9 | 7 | 6 | 28861 | 25 | |||
34112 | 179641 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000468.15764 | 2090746.71388 | 37.72081853103 | -122.440443242589 | (37.72081853103, -122.440443242589) | 9 | 7 | 6 | 28861 | 25 | |||
181680 | 112452 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1021 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004875.37651 | 2091205.89933 | 37.7223293183158 | -122.42524147682 | (37.7223293183158, -122.42524147682) | 9 | 7 | 6 | 28861 | 5 | |||
192062 | 179719 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1021 Excelsior Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6004873.15059 | 2091207.68365 | 37.7223340919162 | -122.425249298216 | (37.7223340919162, -122.425249298216) | 9 | 7 | 6 | 28861 | 5 | |||
50822 | 179642 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Valerton Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001010.15104 | 2091331.02147 | 37.7224537539105 | -122.438611586159 | (37.7224537539105, -122.438611586159) | 9 | 7 | 6 | 28861 | 25 | |||
53673 | 179643 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Valerton Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001011.57815 | 2091346.43493 | 37.7224961569611 | -122.43860775684 | (37.7224961569611, -122.43860775684) | 9 | 7 | 6 | 28861 | 25 | |||
98884 | 43333 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 355 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 1 | Permit Number 43090 | 6003660.20851 | 2091489.47516 | 37.723039229671 | -122.429462239795 | (37.723039229671, -122.429462239795) | 9 | 7 | 6 | 28861 | 5 | |
110118 | 106728 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 663 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 2x2 | 6007262.56469 | 2091493.39322 | 37.7232532889972 | -122.417009866133 | (37.7232532889972, -122.417009866133) | 9 | 3 | 7 | 309 | 28 | |||
19691 | 215239 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 490 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994798.71482 | 2091830.48976 | 37.7234698691262 | -122.46011911753 | (37.7234698691262, -122.46011911753) | 9 | 8 | 4 | 28861 | 24 | |||
52215 | 179790 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6009766.50447 | 2091537.32256 | 37.7235144458085 | -122.408357284583 | (37.7235144458085, -122.408357284583) | 10 | 3 | 7 | 309 | 28 | |||
69886 | 179791 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6009764.47245 | 2091543.83169 | 37.7235322047282 | -122.408364767842 | (37.7235322047282, -122.408364767842) | 10 | 3 | 7 | 309 | 28 | |||
33562 | 179792 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6009761.92268 | 2091556.81874 | 37.7235677216684 | -122.408374497582 | (37.7235677216684, -122.408374497582) | 10 | 3 | 7 | 309 | 28 | |||
8289 | 179793 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 629 Hamilton St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6009759.65206 | 2091562.25484 | 37.7235825209091 | -122.408382730001 | (37.7235825209091, -122.408382730001) | 10 | 3 | 7 | 309 | 28 | |||
60095 | 215238 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 De Montfort Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995012.54401 | 2091916.70112 | 37.7237188814963 | -122.459386194316 | (37.7237188814963, -122.459386194316) | 9 | 8 | 4 | 28861 | 24 | |||
130954 | 215237 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 De Montfort Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995021.72102 | 2091916.50896 | 37.7237188815105 | -122.459354457259 | (37.7237188815105, -122.459354457259) | 9 | 8 | 4 | 28861 | 24 | |||
161904 | 215236 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1209 Capitol Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995030.61507 | 2091933.03172 | 37.7237647604077 | -122.459324908221 | (37.7237647604077, -122.459324908221) | 9 | 8 | 4 | 28861 | 24 | |||
194453 | 265096 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
194463 | 265099 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
194464 | 265097 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
194466 | 265098 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
45972 | 215224 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 400x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 29 | 5995369.41897 | 2092571.16571 | 37.7255363969609 | -122.458199891431 | (37.7255363969609, -122.458199891431) | 9 | 7 | 4 | 28861 | 40 | ||||
174952 | 179685 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 218 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6003869.47166 | 2092417.36805 | 37.7255988638766 | -122.428804976589 | (37.7255988638766, -122.428804976589) | 9 | 7 | 6 | 28861 | 5 | |||
108072 | 215225 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 500x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 39 | 5995372.41973 | 2092668.03741 | 37.7258025558202 | -122.458196526156 | (37.7258025558202, -122.458196526156) | 9 | 7 | 4 | 28861 | 40 | ||||
127487 | 11707 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 24 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991285.0756 | 2092761.86788 | 37.7258244795155 | -122.472332875884 | (37.7258244795155, -122.472332875884) | 9 | 8 | 4 | 64 | 40 | ||
54266 | 11706 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 23 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991285.17012 | 2092766.35209 | 37.7258367975107 | -122.472332875884 | (37.7258367975107, -122.472332875884) | 9 | 8 | 4 | 64 | 40 | ||
136746 | 11704 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991287.48643 | 2092781.25675 | 37.7258778560565 | -122.472325954681 | (37.7258778560565, -122.472325954681) | 9 | 8 | 4 | 64 | 40 | ||
136258 | 179684 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 141 Lisbon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6003403.73924 | 2092580.98204 | 37.7260217403927 | -122.430426643075 | (37.7260217403927, -122.430426643075) | 9 | 7 | 6 | 28861 | 5 | |||
171116 | 11684 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 24 | 2X2 | 5991290.8523 | 2092837.83415 | 37.7260333983166 | -122.472318441749 | (37.7260333983166, -122.472318441749) | 9 | 8 | 4 | 64 | 40 | |||
77777 | 11682 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 700X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991292.04747 | 2092854.58417 | 37.7260794588728 | -122.472315530658 | (37.7260794588728, -122.472315530658) | 9 | 8 | 4 | 64 | 40 | ||
6959 | 179678 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000584.20911 | 2092761.60072 | 37.7263575580392 | -122.440186503209 | (37.7263575580392, -122.440186503209) | 9 | 7 | 6 | 28861 | 25 | |||
5366 | 179679 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000569.78695 | 2092772.13999 | 37.7263856753507 | -122.44023711527 | (37.7263856753507, -122.44023711527) | 9 | 7 | 6 | 28861 | 25 | |||
12366 | 179680 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000544.18408 | 2092789.85376 | 37.726432855581 | -122.440326892784 | (37.726432855581, -122.440326892784) | 9 | 7 | 6 | 28861 | 25 | |||
19097 | 179681 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6000538.34703 | 2092794.14032 | 37.7264442931449 | -122.44034737844 | (37.7264442931449, -122.44034737844) | 9 | 7 | 6 | 28861 | 25 | |||
61036 | 179682 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 501X San Juan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6000425.2781 | 2092808.87665 | 37.7264783171962 | -122.44073930839 | (37.7264783171962, -122.44073930839) | 9 | 7 | 6 | 28861 | 25 |
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) );