Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 43202 | 43202 | 118930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 875 La Playa | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980751.65283 | 2109636.5801 | 37.7715424153171 | -122.509998562861 | (37.7715424153171, -122.509998562861) | |||
| 27285 | 27285 | 118936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.21349 | 2109713.8297599996 | 37.7717754261179 | -122.508777876355 | (37.7717754261179, -122.508777876355) | |||
| 39031 | 39031 | 118935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.559230001 | 2109729.9345299997 | 37.7718196654774 | -122.50877787634701 | (37.7718196654774, -122.508777876347) | |||
| 173736 | 173736 | 57800 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1977 12:00:00 AM | 9 | Permit Number 16735 | 5981352.9647 | 2110030.94394 | 37.7726606704836 | -122.50794790130199 | (37.7726606704836, -122.507947901302) | ||
| 67370 | 67370 | 119159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5981353.13131 | 2110018.81201 | 37.7726273695738 | -122.50794642446002 | (37.7726273695738, -122.50794642446) | |||
| 155878 | 155878 | 119158 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5981361.29524 | 2110027.47694 | 37.772651641953395 | -122.507918828236 | (37.7726516419534, -122.507918828236) | |||
| 179080 | 179080 | 118669 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | ||||
| 157526 | 157526 | 97087 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x4.5 | 5981444.7277 | 2111006.81618 | 37.7753455356701 | -122.50770291724501 | (37.7753455356701, -122.507702917245) | |||
| 44382 | 44382 | 54527 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 8 | 3x5 | Permit Number 10322 | 5981462.67511 | 2111006.65453 | 37.775346149152 | -122.507640822085 | (37.775346149152, -122.507640822085) | |
| 75317 | 75317 | 34709 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 25 | Permit Number 38365 | 5981632.43118 | 2110780.81019 | 37.7747360459971 | -122.50703684968501 | (37.7747360459971, -122.507036849685) | |
| 67844 | 67844 | 119114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5981633.48884 | 2110754.76442 | 37.7746645942414 | -122.50703125858601 | (37.7746645942414, -122.507031258586) | |||
| 174258 | 174258 | 119070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5981915.41012 | 2111609.48599 | 37.7770280083436 | -122.506119441606 | (37.7770280083436, -122.506119441606) | |||
| 167693 | 167693 | 38364 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825001 | (37.7566067521127, -122.50598509825) | |
| 90158 | 90158 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 143885 | 143885 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 186712 | 186712 | 38366 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 6 | Permit Number 40430 | 5981835.1907 | 2104176.6987 | 37.756614999407894 | -122.50584576351999 | (37.7566149994079, -122.50584576352) | ||
| 41354 | 41354 | 184569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3943 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981967.8868 | 2103494.6521 | 37.7547501020315 | -122.505336310147 | (37.7547501020315, -122.505336310147) | |||
| 62290 | 62290 | 184570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3941 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981986.5378 | 2103495.1429 | 37.754752547113206 | -122.505271847368 | (37.7547525471132, -122.505271847368) | |||
| 139863 | 139863 | 24744 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 128X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982380.471419999 | 2112632.1433099997 | 37.7798632908372 | -122.504586464809 | (37.7798632908372, -122.504586464809) | ||
| 157951 | 157951 | 118705 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) | |||
| 75381 | 75381 | 118704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5982455.1363 | 2110968.5092599997 | 37.775299830770294 | -122.504204899972 | (37.7752998307703, -122.504204899972) | |||
| 180391 | 180391 | 69013 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2183 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 4 | Permit Number 33017 | 5982309.8617 | 2100270.0071 | 37.7459162464128 | -122.50391486605301 | (37.7459162464128, -122.503914866053) | |
| 44824 | 44824 | 68547 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 526 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Permit Number 32434 | 5982567.23967 | 2112157.10709 | 37.7785699651083 | -122.50390516811599 | (37.7785699651083, -122.503905168116) | ||
| 29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
| 37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
| 31654 | 31654 | 117698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4049 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | |||
| 76179 | 76179 | 117700 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982971.473069999 | 2113077.09614 | 37.7811197468717 | -122.502574905114 | (37.7811197468717, -122.502574905114) | |||
| 135274 | 135274 | 117699 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5982983.94909 | 2113077.92837 | 37.781122765049 | -122.50253180663601 | (37.781122765049, -122.502531806636) | |||
| 51821 | 51821 | 185254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5982701.1675 | 2097764.3628 | 37.7390594386794 | -122.502376400061 | (37.7390594386794, -122.502376400061) | |||
| 52317 | 52317 | 185256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5982701.6583 | 2097746.6934 | 37.7390109521784 | -122.502373395791 | (37.7390109521784, -122.502373395791) | |||
| 91705 | 91705 | 185255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5982702.6399 | 2097754.5465 | 37.739032572319104 | -122.502370582964 | (37.7390325723191, -122.502370582964) | |||
| 168266 | 168266 | 184451 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2150 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982967.4153 | 2100488.966 | 37.7465560908843 | -122.50165736947099 | (37.7465560908843, -122.501657369471) | |||
| 75864 | 75864 | 117818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3936 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 1ft | 5983313.54909 | 2111075.82361 | 37.775644931310396 | -122.501243440143 | (37.7756449313104, -122.501243440143) | |||
| 27504 | 27504 | 117817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5983396.39556 | 2111078.07387 | 37.7756559745836 | -122.50095702488899 | (37.7756559745836, -122.500957024889) | |||
| 149616 | 149616 | 117816 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 6ft | 5983419.54459 | 2111079.81342 | 37.775662110061 | -122.50087707664801 | (37.775662110061, -122.500877076648) | |||
| 179349 | 179349 | 117815 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5983440.2073 | 2111080.71217 | 37.7756657909172 | -122.50080566686 | (37.7756657909172, -122.50080566686) | |||
| 166581 | 166581 | 117814 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983453.00574 | 2111081.1088 | 37.7756676313487 | -122.500761423942 | (37.7756676313487, -122.500761423942) | |||
| 44550 | 44550 | 117813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983481.12715 | 2111084.52953 | 37.775678674640396 | -122.500664399599 | (37.7756786746404, -122.500664399599) | |||
| 36733 | 36733 | 117761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 39th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983797.475319999 | 2112772.58996 | 37.7803321653034 | -122.499694882039 | (37.7803321653034, -122.499694882039) | |||
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 61110 | 61110 | 92458 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3319 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52848 | 5983933.4582 | 2104246.8072 | 37.756930776386795 | -122.498594490514 | (37.7569307763868, -122.498594490514) |
| 63477 | 63477 | 184595 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1738 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984423.6443 | 2103335.7702 | 37.7544580572925 | -122.496832032885 | (37.7544580572925, -122.496832032885) | |||
| 54634 | 54634 | 184594 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1738 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984424.6596 | 2103325.6175 | 37.754430240283796 | -122.496827772507 | (37.7544302402838, -122.496827772507) | |||
| 73223 | 73223 | 118055 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 499 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5984683.022969999 | 2112541.9282299997 | 37.7797507575988 | -122.496614381059 | (37.7797507575988, -122.496614381059) | |||
| 43211 | 43211 | 118078 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7150 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5984743.66491 | 2112532.51161 | 37.7797284549829 | -122.496403902204 | (37.7797284549829, -122.496403902204) | |||
| 65282 | 65282 | 118037 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3421 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5984874.28781 | 2113152.5227900003 | 37.7814384776062 | -122.49599778017401 | (37.7814384776062, -122.495997780174) | |||
| 171608 | 171608 | 118088 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5984949.57327 | 2112422.00658 | 37.7794371003845 | -122.495683432703 | (37.7794371003845, -122.495683432703) | |||
| 76845 | 76845 | 118087 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984956.11601 | 2112422.0770099997 | 37.7794376769099 | -122.495660804133 | (37.7794376769099, -122.495660804133) | |||
| 181808 | 181808 | 118086 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984961.82415 | 2112422.5857 | 37.779439407892795 | -122.495641095089 | (37.7794394078928, -122.495641095089) | |||
| 147263 | 147263 | 118085 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5984968.995209999 | 2112422.4327599998 | 37.779439407894 | -122.495616276446 | (37.779439407894, -122.495616276446) | |||
| 39296 | 39296 | 118084 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5984977.6516 | 2112422.66835 | 37.7794405616591 | -122.49558634816002 | (37.7794405616591, -122.49558634816) | |||
| 77219 | 77219 | 118070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.51413 | 2113017.90855 | 37.7810780733056 | -122.49544393016599 | (37.7810780733056, -122.495443930166) | |||
| 158745 | 158745 | 118071 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.745180001 | 2113002.45389 | 37.7810356528066 | -122.49544199070401 | (37.7810356528066, -122.495441990704) | |||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 132494 | 132494 | 185500 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2400 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985111.7766 | 2098706.9627 | 37.7417889108579 | -122.49411119019399 | (37.7417889108579, -122.494111190194) | |||
| 178055 | 178055 | 118281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5985519.75315 | 2110399.45496 | 37.7739171254243 | -122.493561899449 | (37.7739171254243, -122.493561899449) | |||
| 178370 | 178370 | 118280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5985532.1252 | 2110400.01193 | 37.7739193784435 | -122.493519144142 | (37.7739193784435, -122.493519144142) | |||
| 160189 | 160189 | 185221 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2507 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985796.5284 | 2098145.3036 | 37.740286789775 | -122.491702240957 | (37.740286789775, -122.491702240957) | |||
| 163948 | 163948 | 185240 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2538 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5985848.3989 | 2097948.0365 | 37.7397481784215 | -122.491508379416 | (37.7397481784215, -122.491508379416) | |||
| 66797 | 66797 | 120004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 530 29th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5986920.19544 | 2112296.72927 | 37.779208328318795 | -122.48885709710599 | (37.7792083283188, -122.488857097106) | |||
| 46998 | 46998 | 44750 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 524 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | 3 | Permit Number 43866 | 5987216.13778 | 2112350.62215 | 37.779373569745104 | -122.487837284703 | (37.7793735697451, -122.487837284703) | ||
| 67422 | 67422 | 250323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.03432 | 2114802.15795 | 37.7861152804279 | -122.48739508214399 | (37.7861152804279, -122.487395082144) | |||
| 70401 | 70401 | 250324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.8518 | 2114775.1083299997 | 37.7860410575969 | -122.487390266267 | (37.7860410575969, -122.487390266267) | |||
| 133819 | 133819 | 120070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 26th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5987678.122930001 | 2115272.13774 | 37.7874221569894 | -122.48645366177401 | (37.7874221569894, -122.486453661774) | |||
| 184137 | 184137 | 119986 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2512 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5987630.129509999 | 2110546.4758099997 | 37.774444031255 | -122.48627264673999 | (37.774444031255, -122.48627264674) | |||
| 112041 | 112041 | 121326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 25th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5987896.0 | 2115988.0 | 37.7894004070969 | -122.48575242171101 | (37.7894004070969, -122.485752421711) | ||||
| 182712 | 182712 | 183002 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2590 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988041.6053 | 2098260.4304 | 37.7407338538563 | -122.48394819724399 | (37.7407338538563, -122.483948197244) | |||
| 174872 | 174872 | 183003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2570 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988097.5458 | 2098263.8729 | 37.740746562571005 | -122.48375503089301 | (37.740746562571, -122.483755030893) | |||
| 120444 | 120444 | 120172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5988392.10695 | 2111261.25032 | 37.7764509846763 | -122.483689270751 | (37.7764509846763, -122.483689270751) | |||
| 54348 | 54348 | 183004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988132.401000001 | 2098265.1638 | 37.7407521359399 | -122.483634610884 | (37.7407521359399, -122.483634610884) | |||
| 63662 | 63662 | 120171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5988414.35774 | 2111262.94747 | 37.7764569397419 | -122.48361242435 | (37.7764569397419, -122.48361242435) | |||
| 168701 | 168701 | 182592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2489 26th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988273.3615 | 2098387.8742 | 37.7410972704537 | -122.483156220906 | (37.7410972704537, -122.483156220906) | |||
| 50099 | 50099 | 108350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 94535 | 94535 | 108345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 99148 | 99148 | 108346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 99222 | 99222 | 108353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 124192 | 124192 | 108351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 124212 | 124212 | 108347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 129230 | 129230 | 108349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 81185 | 81185 | 108348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 3x3 | 5988501.0 | 2100296.0 | 37.746349726050894 | -122.48250892192699 | (37.7463497260509, -122.482508921927) | |||
| 158597 | 158597 | 120329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | |||
| 108530 | 108530 | 110402 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 115819 | 115819 | 110406 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 144668 | 144668 | 110414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 43911 | 43911 | 219267 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1486 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990295.40982 | 2105284.56966 | 37.7601512467979 | -122.476668525453 | (37.7601512467979, -122.476668525453) | |||
| 184421 | 184421 | 219266 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1486 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990295.30501 | 2105270.33919 | 37.7601121676522 | -122.47666784826299 | (37.7601121676522, -122.476667848263) | |||
| 49550 | 49550 | 219265 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1586 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990318.67489 | 2104606.71448 | 37.758291386764604 | -122.47653854281401 | (37.7582913867646, -122.476538542814) | |||
| 40450 | 40450 | 219269 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1330 Kirkham St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5990592.20952 | 2105220.86504 | 37.7599935416893 | -122.47563739517099 | (37.7599935416893, -122.475637395171) | |||
| 172366 | 172366 | 219268 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1330 Kirkham St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5990642.8904800005 | 2105223.71561 | 37.760004306576704 | -122.47546232413299 | (37.7600043065767, -122.475462324133) | |||
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 183872 | 183872 | 219255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1498 17th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 1ft | 5990885.81695 | 2105244.6208200003 | 37.760075785584 | -122.47462369285 | (37.760075785584, -122.47462369285) | |||
| 178909 | 178909 | 219365 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5990937.49847 | 2095339.3344400001 | 37.7328814326142 | -122.473722354509 | (37.7328814326142, -122.473722354509) | |||
| 76628 | 76628 | 219364 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5990943.63906 | 2095348.36175 | 37.732906574966 | -122.473701783431 | (37.732906574966, -122.473701783431) | |||
| 40056 | 40056 | 219363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5990950.29751 | 2095356.30121 | 37.7329287603452 | -122.47367934265199 | (37.7329287603452, -122.473679342652) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");