Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 32 | 10933 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1359 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016893.48466 | 2096461.5108299998 | 37.7374318223223 | -122.384063092353 | (37.7374318223223, -122.384063092353) | |||
38 | 38 | 192589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008004.0 | 2110521.0 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | |||
41 | 41 | 192590 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008004.0 | 2110521.0 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | |||
64 | 64 | 138748 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1614 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000643.1477 | 2114229.9232 | 37.7853077023438 | -122.441522641665 | (37.7853077023438, -122.441522641665) | |||
101 | 101 | 192592 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1399X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008031.0 | 2110483.0 | 37.775437677991796 | -122.41569744526699 | (37.7754376779918, -122.415697445267) | |||
108 | 108 | 192593 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1399X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008031.0 | 2110483.0 | 37.775437677991796 | -122.41569744526699 | (37.7754376779918, -122.415697445267) | |||
126 | 126 | 228560 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006200.30022 | 2105449.82338 | 37.761514690968596 | -122.42167271244301 | (37.7615146909686, -122.421672712443) | |||
137 | 137 | 228561 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006199.77605 | 2105468.2728 | 37.7615653191939 | -122.42167583577299 | (37.7615653191939, -122.421675835773) | |||
281 | 281 | 9686 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.42276159987499 | (37.7762854431535, -122.422761599875) | |||
348 | 348 | 229175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 795 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6006285.87907 | 2104987.97511 | 37.7602513890079 | -122.421343931093 | (37.7602513890079, -122.421343931093) | |||
376 | 376 | 229176 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 793 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6006285.11873 | 2105008.6290700003 | 37.7603080570896 | -122.42134802750601 | (37.7603080570896, -122.421348027506) | |||
379 | 379 | 122497 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 31X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008445.21835 | 2111601.2724900004 | 37.7785314648928 | -122.414343702699 | (37.7785314648928, -122.414343702699) | |||
411 | 411 | 154366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6006164.37856 | 2107202.76015 | 37.7663258166161 | -122.42192147568899 | (37.7663258166161, -122.421921475689) | |||
417 | 417 | 229177 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 789 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006284.79968 | 2105036.34994 | 37.7603841541343 | -122.42135109956699 | (37.7603841541343, -122.421351099567) | |||
790 | 790 | 216490 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 800x Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 3ft | 6001788.93125 | 2095501.57158 | 37.7339494063362 | -122.436217839104 | (37.7339494063362, -122.436217839104) | |||
912 | 912 | 137817 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004275.6077 | 2115310.8412 | 37.7884819087987 | -122.429032528237 | (37.7884819087987, -122.429032528237) | |||
965 | 965 | 130085 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6006282.409 | 2112253.58537 | 37.7802008260541 | -122.421872043567 | (37.7802008260541, -122.421872043567) | |||
968 | 968 | 129976 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 90x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6009114.5006 | 2112815.4856 | 37.781902979173005 | -122.41211422669399 | (37.781902979173, -122.412114226694) | |||
969 | 969 | 229181 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 701 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006262.86833 | 2105467.84413 | 37.7615676997051 | -122.421457594595 | (37.7615676997051, -122.421457594595) | |||
981 | 981 | 191653 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 149 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012146.38303 | 2114300.35662 | 37.786149737060796 | -122.40172965521799 | (37.7861497370608, -122.401729655218) | |||
1036 | 1036 | 200488 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 4ft | 6015927.44102 | 2103090.66004 | 37.7555806376415 | -122.38786561392901 | (37.7555806376415, -122.387865613929) | |||
1047 | 1047 | 200448 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6015917.22039 | 2103323.37431 | 37.7562190555923 | -122.387917198143 | (37.7562190555923, -122.387917198143) | |||
1106 | 1106 | 251445 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6014884.877230001 | 2114997.01321 | 37.7882150346369 | -122.39230385636002 | (37.7882150346369, -122.39230385636) | ||||
1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
1205 | 1205 | 200814 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 4706 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6014979.4823 | 2095765.9955 | 37.7354160755771 | -122.390632161008 | (37.7354160755771, -122.390632161008) | |||
1257 | 1257 | 197452 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 668 Natoma St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009185.76341 | 2111038.87777 | 37.7770288335587 | -122.41174211691799 | (37.7770288335587, -122.411742116918) | |||
1279 | 1279 | 245833 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 451 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005191.6007 | 2110574.0246 | 37.775527586454004 | -122.425526086229 | (37.775527586454, -122.425526086229) | |||
1355 | 1355 | 29680 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006072.343230001 | 2117086.04016 | 37.7934577026643 | -122.422942314134 | (37.7934577026643, -122.422942314134) | ||||
1388 | 1388 | 251519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1401 | 1401 | 251523 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1413 | 1413 | 246406 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | |||
1414 | 1414 | 251524 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1416 | 1416 | 251521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1425 | 1425 | 251522 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1433 | 1433 | 251520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1569 | 1569 | 29756 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 990 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008576.3352 | 2120666.0433 | 37.8034284755503 | -122.414531731143 | (37.8034284755503, -122.414531731143) | |||
1690 | 1690 | 6935 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 528 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004882.44233 | 2110586.3122400003 | 37.775543852304004 | -122.426596415205 | (37.775543852304, -122.426596415205) | |||
1703 | 1703 | 29682 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006057.50051 | 2117137.8264200003 | 37.7935990572132 | -122.422997353566 | (37.7935990572132, -122.422997353566) | ||||
1730 | 1730 | 26216 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 847 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X6 | 6005539.1347199995 | 2098169.79344 | 37.741488104692 | -122.42344184796002 | (37.741488104692, -122.42344184796) | |||
1739 | 1739 | 26215 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 851 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X6 | 6005528.08782 | 2098148.15105 | 37.7414280560726 | -122.423478506131 | (37.7414280560726, -122.423478506131) | |||
1768 | 1768 | 251696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
1780 | 1780 | 7055 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1380 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000908.235 | 2110033.3424 | 37.773800058267604 | -122.440304458977 | (37.7738000582676, -122.440304458977) | |||
1829 | 1829 | 9893 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005337.6793 | 2115599.8801599997 | 37.7893355988943 | -122.425378500212 | (37.7893355988943, -122.425378500212) | |||
1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
1912 | 1912 | 251809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
1921 | 1921 | 251811 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
1963 | 1963 | 140354 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1314 ELLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004320.8279 | 2113281.1051 | 37.7829113213724 | -122.42873132198099 | (37.7829113213724, -122.428731321981) | |||
2085 | 2085 | 252880 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001313.0 | 2088154.0 | 37.7137475882422 | -122.43733732943001 | (37.7137475882422, -122.43733732943) | ||||
2093 | 2093 | 177161 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007505.03845 | 2087315.4239400001 | 37.711795103221604 | -122.41587597032499 | (37.7117951032216, -122.415875970325) | |||
2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2208 | 2208 | 252955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2312 | 2312 | 253038 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778941 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | |||
2318 | 2318 | 253034 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2328 | 2328 | 253035 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2338 | 2338 | 253037 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2339 | 2339 | 253036 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2341 | 2341 | 138904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 743 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004092.4052 | 2110770.0131 | 37.7760035542999 | -122.429342446805 | (37.7760035542999, -122.429342446805) | |||
2345 | 2345 | 138905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 739 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004125.2186 | 2110775.3704 | 37.776020121780206 | -122.42922931872499 | (37.7760201217802, -122.429229318725) | |||
2514 | 2514 | 246848 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001221.8841699995 | 2109765.97896 | 37.773083798207296 | -122.439200331843 | (37.7730837982073, -122.439200331843) | |||
2519 | 2519 | 246843 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001198.912769999 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | |||
2532 | 2532 | 246847 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.773133053181404 | -122.43923249339198 | (37.7731330531814, -122.439232493392) | |||
2533 | 2533 | 246849 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001216.8657599995 | 2109748.1446700003 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | |||
2535 | 2535 | 246841 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | |||
2546 | 2546 | 246846 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 8 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001207.38463 | 2109809.38993 | 37.773202168766105 | -122.43925359959101 | (37.7732021687661, -122.439253599591) | |||
2552 | 2552 | 246840 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : 4 | Tree 1 | DPW for City Agency 10 | 19 | Width 3ft | 6001188.51269 | 2109936.2184200003 | 37.7735493340682 | -122.43932797261999 | (37.7735493340682, -122.43932797262) | |||
2553 | 2553 | 246842 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 4 | : 4 | Tree 1 | DPW for City Agency 10 | 15 | Width 4ft | 6001208.43411 | 2109888.06605 | 37.7734182533891 | -122.439255609578 | (37.7734182533891, -122.439255609578) | |||
2554 | 2554 | 246844 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 6 | : 4 | Tree 1 | DPW for City Agency 10 | 17 | Width 3ft | 6001203.63374 | 2109838.69012 | 37.773282406297895 | -122.439268674924 | (37.7732824062979, -122.439268674924) | |||
2747 | 2747 | 177162 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007512.10716 | 2087312.1903 | 37.711786621718296 | -122.415851310014 | (37.7117866217183, -122.415851310014) | ||
2758 | 2758 | 177160 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | ||
2801 | 2801 | 142460 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 536 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6004827.4421 | 2110579.0189 | 37.775520717053205 | -122.426786154864 | (37.7755207170532, -122.426786154864) | |||
2956 | 2956 | 248424 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997237.9413 | 2108083.6374 | 37.768237016007 | -122.452859770858 | (37.768237016007, -122.452859770858) | |||
2966 | 2966 | 137576 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6002354.5808 | 2112241.3971 | 37.7799450671147 | -122.435459310364 | (37.7799450671147, -122.435459310364) | |||
2973 | 2973 | 248423 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997213.1093 | 2108080.0035 | 37.7682256152375 | -122.45294539950399 | (37.7682256152375, -122.452945399504) | |||
2998 | 2998 | 137578 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6002358.9103 | 2112196.2192 | 37.7798212658547 | -122.435441099997 | (37.7798212658547, -122.435441099997) | |||
3008 | 3008 | 248421 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | |||
3020 | 3020 | 248422 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997181.0094 | 2108075.4611 | 37.768211303376496 | -122.45305610134199 | (37.7682113033765, -122.453056101342) | |||
3023 | 3023 | 253281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | ||||
3104 | 3104 | 23477 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2400X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 9 | 6005826.46835 | 2118791.49543 | 37.7981265753418 | -122.423914390454 | (37.7981265753418, -122.423914390454) | |||
3596 | 3596 | 202610 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | Permit Number 779780 | 6011146.73396 | 2109912.7154099997 | 37.774046463106 | -122.40487916734301 | (37.774046463106, -122.404879167343) | ||
3602 | 3602 | 202609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | Permit Number 779780 | 6011126.85654 | 2109894.99849 | 37.773996705425795 | -122.40494667944799 | (37.7739967054258, -122.404946679448) | ||
3613 | 3613 | 202611 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | Permit Number 779780 | 6011168.27337 | 2109934.33837 | 37.7741070387293 | -122.404806181057 | (37.7741070387293, -122.404806181057) | ||
4094 | 4094 | 6166 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005702.86932 | 2113419.87846 | 37.783370480293996 | -122.423959898857 | (37.783370480294, -122.423959898857) | |||
4540 | 4540 | 18899 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2575 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6002504.45373 | 2115758.05504 | 37.7896094280702 | -122.435192436588 | (37.7896094280702, -122.435192436588) | |||
4623 | 4623 | 129872 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 7 | Width 4ft | Permit Number 771149 | 6000353.54628 | 2120943.15919 | 37.803723977330996 | -122.44300685090401 | (37.803723977331, -122.443006850904) | ||
4712 | 4712 | 29681 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006062.7062 | 2117112.9687900003 | 37.79353109814161 | -122.42297757386001 | (37.7935310981416, -122.42297757386) | ||||
4724 | 4724 | 123749 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995567.69989 | 2110826.7231400004 | 37.7756729573603 | -122.458835555737 | (37.7756729573603, -122.458835555737) | |||
4733 | 4733 | 123748 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995551.56394 | 2110826.65908 | 37.7756718539675 | -122.45889136897301 | (37.7756718539675, -122.458891368973) | |||
4802 | 4802 | 14630 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6006405.54587 | 2112179.60651 | 37.7800046416385 | -122.42144080067499 | (37.7800046416385, -122.421440800675) | |||
5066 | 5066 | 3614 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.742354807434396 | -122.380409304248 | (37.7423548074344, -122.380409304248) | |||
5134 | 5134 | 228559 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006186.0 | 2105451.0 | 37.7615171153003 | -122.42172225467199 | (37.7615171153003, -122.421722254672) | |||
5140 | 5140 | 228571 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 513 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006244.0 | 2106614.0 | 37.7647137104058 | -122.42160425957701 | (37.7647137104058, -122.421604259577) | |||
5152 | 5152 | 228556 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 786 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006236.0 | 2105017.0 | 37.760328272277 | -122.42151850101101 | (37.760328272277, -122.421518501011) | |||
5153 | 5153 | 228555 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 786 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006236.0 | 2105017.0 | 37.760328272277 | -122.42151850101101 | (37.760328272277, -122.421518501011) | |||
5157 | 5157 | 228554 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 786 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006236.0 | 2105017.0 | 37.760328272277 | -122.42151850101101 | (37.760328272277, -122.421518501011) | |||
5164 | 5164 | 123751 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995599.55133 | 2110826.05638 | 37.7756729573693 | -122.45872532616801 | (37.7756729573693, -122.458725326168) | |||
5193 | 5193 | 228189 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1050 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006316.10269 | 2103413.26425 | 37.7559293029964 | -122.421127585696 | (37.7559293029964, -122.421127585696) | |||
5201 | 5201 | 228562 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 696X Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006192.66856 | 2105583.99775 | 37.7618826719793 | -122.42170863765499 | (37.7618826719793, -122.421708637655) | |||
5545 | 5545 | 6168 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005744.11835 | 2113425.67205 | 37.7833887167454 | -122.423817605392 | (37.7833887167454, -122.423817605392) | |||
5671 | 5671 | 9432 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 727 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005971.0045 | 2112414.18829 | 37.7806242358464 | -122.422960753834 | (37.7806242358464, -122.422960753834) | |||
5712 | 5712 | 14629 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6006423.31397 | 2112182.40692 | 37.7800133326755 | -122.42137953166001 | (37.7800133326755, -122.42137953166) |
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");